Below are monthly market prices for the first of the month for unopened loose Pokémon TCG packs from TCG Player. Clicking the links below may earn me a commission through TCG Player if a product is purchased.
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`
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'
WHERE `s`.`tcgpid` IS NOT NULL AND `s`.`groupid` = ? AND `s`.`isminiset` = 0
GROUP BY `s`.`id`
ORDER BY `s`.`releasedate` DESC
Scarlet & Violet
Sword & Shield
Sun & Moon
XY
Black & White
Data date: 2025-06-14