SELECT
`x`.`name` AS `setname`,
`s`.*, COUNT(`p1`.`id`) AS PRICED,
CONCAT('$',FORMAT(`p0`.`pack`,2,'en_US')) AS `pack0`,
CONCAT('$',FORMAT(`p1`.`pack`,2,'en_US')) AS `pack1`,
CONCAT('$',FORMAT(`p2`.`pack`,2,'en_US')) AS `pack2`,
CONCAT('$',FORMAT(`p3`.`pack`,2,'en_US')) AS `pack3`,
CONCAT('$',FORMAT(`p4`.`pack`,2,'en_US')) AS `pack4`,
CONCAT('$',FORMAT(`p5`.`pack`,2,'en_US')) AS `pack5`,
CONCAT('$',FORMAT(`p6`.`pack`,2,'en_US')) AS `pack6`,
CONCAT('$',FORMAT(`p7`.`pack`,2,'en_US')) AS `pack7`,
CONCAT('$',FORMAT(`p8`.`pack`,2,'en_US')) AS `pack8`,
CONCAT('$',FORMAT(`p9`.`pack`,2,'en_US')) AS `pack9`,
CONCAT('$',FORMAT(`p10`.`pack`,2,'en_US')) AS `pack10`
FROM `series` `x`
LEFT JOIN `sets` `s` ON `s`.`seriesid` = `x`.`id`
LEFT JOIN `prices` `p0` ON `s`.`tcgpid` = `p0`.`setid` AND `p0`.`pricedate` = '2024-12-01'
LEFT JOIN `prices` `p1` ON `s`.`tcgpid` = `p1`.`setid` AND `p1`.`pricedate` = '2025-01-01'
LEFT JOIN `prices` `p2` ON `s`.`tcgpid` = `p2`.`setid` AND `p2`.`pricedate` = '2025-02-01'
LEFT JOIN `prices` `p3` ON `s`.`tcgpid` = `p3`.`setid` AND `p3`.`pricedate` = '2025-03-01'
LEFT JOIN `prices` `p4` ON `s`.`tcgpid` = `p4`.`setid` AND `p4`.`pricedate` = '2025-04-01'
LEFT JOIN `prices` `p5` ON `s`.`tcgpid` = `p5`.`setid` AND `p5`.`pricedate` = '2025-05-01'
LEFT JOIN `prices` `p6` ON `s`.`tcgpid` = `p6`.`setid` AND `p6`.`pricedate` = '2025-06-01'
LEFT JOIN `prices` `p7` ON `s`.`tcgpid` = `p7`.`setid` AND `p7`.`pricedate` = '2025-07-01'
LEFT JOIN `prices` `p8` ON `s`.`tcgpid` = `p8`.`setid` AND `p8`.`pricedate` = '2025-08-01'
LEFT JOIN `prices` `p9` ON `s`.`tcgpid` = `p9`.`setid` AND `p9`.`pricedate` = '2025-09-01'
LEFT JOIN `prices` `p10` ON `s`.`tcgpid` = `p10`.`setid` AND `p10`.`pricedate` = '2025-10-01'
WHERE `s`.`tcgpid` IS NOT NULL AND `s`.`groupid` = ? AND `s`.`isminiset` = 0
GROUP BY `s`.`id`
ORDER BY `s`.`releasedate` DESC
Mega Evolution
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Mega Evolution |
| | | | | | | | | $18.69 | $8.30 |
Scarlet & Violet
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Black Bolt |
| | | | | | $19.95 | $17.07 | $9.28 | $8.22 | $9.33 |
| White Flare |
| | | | | | $19.49 | $16.22 | $8.75 | $8.25 | $8.86 |
| Destined Rivals |
| | | | $19.89 | $14.20 | $8.16 | $6.63 | $7.93 | $7.67 | $8.78 |
| Journey Together |
| | $8.83 | $8.36 | $6.79 | $6.02 | $5.93 | $6.37 | $5.98 | $5.86 | $6.63 |
| Prismatic Evolutions |
$11.08 | $14.12 | $11.39 | $12.92 | $13.10 | $12.62 | $11.36 | $10.14 | $10.19 | $9.95 | $8.47 |
| Surging Sparks |
$5.84 | $6.03 | $7.18 | $7.21 | $6.76 | $6.87 | $6.88 | $6.39 | $7.07 | $6.55 | $7.10 |
| Stellar Crown |
$3.25 | $3.84 | $4.43 | $5.45 | $6.30 | $5.77 | $6.05 | $5.96 | $6.48 | $6.20 | $6.92 |
| Shrouded Fable |
$3.63 | $3.94 | $4.63 | $5.14 | $5.43 | $5.71 | $6.28 | $7.17 | $7.32 | $6.86 | $7.58 |
| Twilight Masquerade |
$3.99 | $3.98 | $5.58 | $5.77 | $6.72 | $6.55 | $6.51 | $6.31 | $6.44 | $7.06 | $6.85 |
| Temporal Forces |
$3.10 | $3.90 | $4.66 | $4.64 | $5.52 | $5.52 | $6.04 | $6.01 | $6.42 | $6.57 | $6.22 |
| Paldean Fates |
$5.97 | $7.02 | $7.85 | $8.75 | $9.05 | $10.26 | $10.58 | $11.63 | $12.11 | $13.28 | $13.97 |
| Paradox Rift |
$3.22 | $3.59 | $4.58 | $4.87 | $5.90 | $5.66 | $5.44 | $5.83 | $5.92 | $6.03 | $5.85 |
| 151 |
$8.90 | $8.86 | $10.26 | $12.23 | $9.44 | $11.45 | $9.48 | $10.52 | $11.82 | $12.03 | $16.20 |
| Obsidian Flames |
$3.30 | $3.58 | $4.80 | $5.58 | $6.68 | $5.82 | $5.86 | $6.57 | $6.80 | $6.87 | $7.76 |
| Paldea Evolved |
$3.81 | $4.01 | $5.11 | $4.44 | $5.77 | $6.97 | $6.63 | $7.50 | $9.49 | $8.72 | $8.99 |
| Scarlet & Violet Base |
$2.82 | $3.68 | $3.88 | $4.35 | $5.56 | $5.33 | $5.54 | $5.97 | $6.17 | $6.45 | $6.54 |
Sword & Shield
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Crown Zeinth |
$4.67 | $4.61 | $6.56 | $7.56 | $9.12 | $9.63 | $9.81 | $9.43 | $11.45 | $11.71 | $14.05 |
| Silver Tempest |
$3.75 | $4.11 | $5.27 | $6.15 | $6.74 | $7.43 | $6.39 | $7.16 | $6.74 | $7.37 | $7.85 |
| Lost Origin |
$4.78 | $5.35 | $7.07 | $8.50 | $8.48 | $8.42 | $8.79 | $9.40 | $9.08 | $10.21 | $11.02 |
| Pokemon GO |
$4.24 | $4.23 | $4.91 | $5.43 | $6.22 | $6.40 | $6.38 | $6.12 | $6.93 | $7.63 | $8.74 |
| Astral Radiance |
$3.84 | $3.96 | $4.82 | $5.23 | $5.77 | $6.65 | $6.41 | $6.68 | $6.92 | $6.41 | $7.23 |
| Brilliant Stars |
$3.78 | $4.18 | $5.58 | $6.49 | $6.99 | $7.51 | $7.53 | $8.00 | $7.87 | $7.31 | $8.62 |
| Fusion Strike |
$4.53 | $6.03 | $8.01 | $8.81 | $8.66 | $9.57 | $11.46 | $12.32 | $12.58 | $11.82 | $12.91 |
| Celebrations |
$8.32 | $8.80 | $8.80 | $9.47 | $9.92 | $10.04 | $10.60 | $10.09 | $17.88 | $17.22 | $18.01 |
| Evolving Skies |
$15.48 | $18.64 | $20.82 | $23.70 | $21.59 | $23.78 | $25.69 | $25.90 | $27.20 | $29.40 | $30.59 |
| Chilling Reign |
$4.43 | $4.96 | $7.03 | $7.49 | $7.16 | $7.28 | $7.18 | $6.80 | $8.07 | $8.57 | $8.87 |
| Battle Styles |
$4.11 | $4.14 | $4.62 | $4.75 | $5.25 | $6.08 | $6.30 | $6.07 | $6.24 | $6.11 | $6.76 |
| Shining Fates |
$6.12 | $6.73 | $7.23 | $8.89 | $9.37 | $9.67 | $9.58 | $9.12 | $9.52 | $11.12 | $12.03 |
| Vivid Voltage |
$3.87 | $4.51 | $4.70 | $5.61 | $6.26 | $6.03 | $6.14 | $6.72 | $6.79 | $6.44 | $6.94 |
| Champions Path |
$9.23 | $11.64 | $11.85 | $11.56 | $12.01 | $12.69 | $14.41 | $12.92 | $13.06 | $14.23 | $13.96 |
| Darkness Ablaze |
$3.93 | $5.09 | $4.90 | $5.63 | $6.46 | $6.09 | $7.28 | $6.06 | $6.77 | $7.18 | $6.81 |
| Rebel Clash |
$4.52 | $4.76 | $4.80 | $5.07 | $5.88 | $6.00 | $6.54 | $7.07 | $7.67 | $7.39 | $7.55 |
| Sword & Shield Base |
$4.43 | $4.82 | $5.66 | $6.79 | $6.67 | $6.59 | $7.83 | $7.08 | $8.56 | $8.41 | $8.41 |
Sun & Moon
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Cosmic Eclipse |
| $20.42 | $22.19 | $25.54 | $28.75 | $34.37 | $41.61 | $42.08 | $59.81 | $59.85 | $64.94 |
| Hidden Fates |
| $23.40 | $23.44 | $26.50 | $28.08 | $26.79 | $28.41 | $34.42 | $34.54 | $34.15 | $34.44 |
| Unified Minds |
| $19.64 | $23.01 | $25.68 | $30.16 | $32.46 | $37.09 | $38.28 | $42.66 | $52.21 | $58.26 |
| Unbroken Bonds |
| $21.15 | $24.73 | $28.77 | $33.32 | $37.10 | $40.65 | $43.46 | $47.07 | $48.59 | $51.29 |
| Detective Pikachu |
| $9.42 | $9.89 | $10.18 | $10.47 | $10.98 | $11.60 | $12.09 | $12.67 | $12.93 | $12.75 |
| Team Up |
| $67.65 | $75.50 | $82.01 | $93.95 | $120.60 | $130.70 | $151.08 | $175.01 | $178.41 | $179.58 |
| Lost Thunder |
| $17.04 | $18.13 | $20.04 | $22.44 | $25.35 | $27.93 | $27.57 | $27.54 | $28.20 | $29.10 |
| Dragon Majesty |
| $40.75 | $41.03 | $41.76 | $42.63 | $44.19 | $44.17 | $45.65 | $47.42 | $48.16 | $53.06 |
| Celestial Storm |
| $21.12 | $24.05 | $27.33 | $27.24 | $29.87 | $36.67 | $37.53 | $39.78 | $42.92 | $43.57 |
| Forbidden Light |
| $15.66 | $17.57 | | $20.80 | $21.00 | $20.99 | $22.51 | $23.35 | $22.99 | $22.99 |
| Ultra Prism |
| $22.17 | $22.94 | $23.45 | $24.43 | $25.77 | $27.70 | $30.98 | $32.46 | $33.05 | $36.12 |
| Crimson Invasion |
| $8.46 | $8.96 | $9.21 | $9.84 | $9.93 | $9.70 | $10.16 | $11.49 | $12.80 | $13.33 |
| Shining Legends |
| $31.89 | $37.84 | $41.47 | $44.27 | $47.15 | $49.55 | $50.35 | $52.07 | $56.27 | $61.69 |
| Burning Shadows |
| $13.24 | $12.82 | $12.87 | $13.20 | $14.90 | $16.33 | $17.74 | $17.38 | $19.02 | $22.71 |
| Guardians Rising |
| $11.94 | $12.94 | $12.87 | $12.89 | $15.92 | $17.95 | $19.75 | $21.21 | $22.42 | $23.87 |
| Sun & Moon Base |
| $8.82 | $9.90 | $9.14 | $12.07 | $11.62 | $11.81 | $12.96 | $13.72 | $14.47 | $14.71 |
XY
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Evolutions |
| $27.61 | $29.25 | $32.60 | $31.81 | $34.17 | $38.21 | $38.88 | $38.58 | $42.45 | $44.04 |
| Steam Siege |
| $9.99 | $11.17 | $12.83 | $14.41 | $13.89 | $14.71 | $16.30 | $18.33 | $19.50 | $19.79 |
| Fates Collide |
| $16.81 | $17.12 | $18.17 | $21.79 | $25.23 | $26.26 | $25.25 | $26.99 | $28.22 | $33.26 |
| Generations |
| $52.67 | $56.67 | $61.12 | $71.42 | $87.38 | $117.00 | $166.06 | $182.84 | $190.81 | $192.09 |
| Breakpoint |
| $16.46 | $17.46 | $18.83 | $19.83 | $21.97 | $22.12 | $22.62 | $24.83 | $28.19 | $30.23 |
| BreakThrough |
| $16.27 | $16.25 | $17.21 | $17.58 | $22.39 | $24.11 | $25.28 | $30.11 | $31.06 | $32.02 |
| Ancient Origins |
| $39.39 | $44.66 | $46.06 | $48.39 | $47.22 | $45.99 | $46.61 | $66.75 | $77.19 | $82.95 |
| Roaring Skies |
| $25.43 | $25.82 | $28.57 | $32.01 | $33.21 | $35.48 | $36.40 | $43.61 | $49.09 | $52.22 |
| Double Crisis |
| $71.90 | $76.25 | $79.74 | $96.93 | | | $146.48 | | $178.39 | $236.48 |
| Primal Clash |
| $20.17 | $24.91 | $28.53 | $30.45 | $28.79 | $32.49 | $37.81 | $42.59 | $44.47 | $46.44 |
| Phantom Forces |
| $42.78 | $46.91 | $54.64 | $59.48 | $63.83 | $70.63 | $76.53 | $99.55 | $109.29 | $117.36 |
| Furious Fists |
| $25.44 | $28.80 | | | $35.57 | $40.78 | $42.36 | $45.26 | $49.63 | $50.29 |
| Flashfire |
| $64.67 | $66.62 | $67.21 | $70.77 | $73.41 | $78.29 | $81.36 | $86.27 | $112.77 | $120.25 |
| XY Base |
| $35.15 | $36.20 | $39.00 | $42.31 | $43.65 | $45.25 | $46.31 | $50.41 | $52.38 | $52.70 |
Black & White
| Set Name | Dec 1, 2024 | Jan 1, 2025 | Feb 1, 2025 | Mar 1, 2025 | Apr 1, 2025 | May 1, 2025 | Jun 1, 2025 | Jul 1, 2025 | Aug 1, 2025 | Sep 1, 2025 | Oct 1, 2025 |
|---|
| Legendary Treasures |
| | $94.55 | | | $110.35 | $120.94 | $130.70 | $139.07 | $152.66 | $156.93 |
| Plasma Blast |
| | $67.37 | $70.07 | $74.52 | $77.23 | $79.70 | $81.60 | $84.99 | $89.35 | $93.74 |
| Plasma Freeze |
| | $147.08 | $147.08 | $144.47 | $141.93 | $141.93 | $142.25 | $142.90 | $148.25 | $175.00 |
| Plasma Storm |
| | $147.24 | $152.77 | $181.41 | $192.49 | $253.31 | $253.31 | $284.31 | $287.73 | $290.31 |
| Boundaries Crossed |
| | | | | $126.61 | $126.61 | $126.61 | $126.61 | $125.21 | $135.50 |
| Dragon Vault |
| | | $109.99 | $123.99 | $127.49 | $129.99 | $129.99 | $174.99 | $183.32 | $199.99 |
| Dragons Exalted |
| | $121.32 | $123.53 | $123.28 | $123.28 | $135.12 | $145.16 | $144.20 | $150.50 | $167.99 |
| Dark Explorers |
| | | | | | | | | | |
| Next Destinies |
| | $79.95 | $77.79 | $79.35 | | $81.41 | $83.92 | $84.91 | $110.56 | $121.09 |
| Noble Victories |
| | $71.46 | $73.17 | $102.38 | $109.99 | $109.99 | $109.18 | $109.18 | $116.48 | $105.95 |
| Emerging Powers |
| | $53.60 | $54.42 | $60.81 | $61.66 | $68.34 | $68.75 | $71.38 | $76.96 | $77.97 |
| Black and White Base |
| | $76.78 | | $75.74 | $76.12 | $78.46 | | | $79.58 | $84.78 |
Data date: 2025-10-01
