PREVIEW / futures_1hour / 2024-11-29
file: by_date/futures_1hour/2024/2024-11-29.parquet size: 49 KB rows: 1,418
schema
timestamp TIMESTAMP symbol VARCHAR asset_type VARCHAR open DOUBLE high DOUBLE low DOUBLE close DOUBLE volume DOUBLE
sample rows
| timestamp | symbol | asset_type | open | high | low | close | volume |
|---|---|---|---|---|---|---|---|
| 2024-11-29 00:00:00 | ES | Futures | 6264.89 | 6265.41 | 6260.74 | 6261.0 | 4001.0 |
| 2024-11-29 01:00:00 | ES | Futures | 6261.0 | 6262.3 | 6258.15 | 6260.74 | 3710.0 |
| 2024-11-29 02:00:00 | ES | Futures | 6260.74 | 6260.74 | 6252.96 | 6256.85 | 6244.0 |
| 2024-11-29 03:00:00 | ES | Futures | 6256.85 | 6263.08 | 6256.59 | 6261.26 | 8450.0 |
| 2024-11-29 04:00:00 | ES | Futures | 6261.0 | 6264.38 | 6260.22 | 6262.56 | 7214.0 |
| 2024-11-29 05:00:00 | ES | Futures | 6262.56 | 6265.15 | 6259.96 | 6262.3 | 6262.0 |
| 2024-11-29 06:00:00 | ES | Futures | 6262.04 | 6263.86 | 6258.93 | 6263.08 | 5925.0 |
| 2024-11-29 07:00:00 | ES | Futures | 6262.82 | 6263.6 | 6256.07 | 6258.93 | 9094.0 |
| 2024-11-29 08:00:00 | ES | Futures | 6258.93 | 6259.44 | 6248.03 | 6251.66 | 21120.0 |
| 2024-11-29 09:00:00 | ES | Futures | 6251.92 | 6262.82 | 6248.29 | 6262.82 | 106184.0 |
| 2024-11-29 10:00:00 | ES | Futures | 6262.56 | 6275.28 | 6262.56 | 6274.76 | 141116.0 |
| 2024-11-29 11:00:00 | ES | Futures | 6274.5 | 6285.92 | 6274.5 | 6284.1 | 106436.0 |
| 2024-11-29 12:00:00 | ES | Futures | 6284.1 | 6290.85 | 6280.21 | 6282.02 | 190350.0 |
| 2024-11-29 13:00:00 | ES | Futures | 6282.28 | 6284.88 | 6279.17 | 6282.02 | 39849.0 |
| 2024-11-29 00:00:00 | NQ | Futures | 21845.93 | 21849.58 | 21812.53 | 21814.62 | 2749.0 |
| 2024-11-29 01:00:00 | NQ | Futures | 21814.36 | 21825.58 | 21802.88 | 21818.53 | 2602.0 |
| 2024-11-29 02:00:00 | NQ | Futures | 21818.27 | 21819.58 | 21776.26 | 21792.7 | 4565.0 |
| 2024-11-29 03:00:00 | NQ | Futures | 21793.22 | 21817.75 | 21790.88 | 21813.05 | 5412.0 |
| 2024-11-29 04:00:00 | NQ | Futures | 21812.53 | 21822.71 | 21806.01 | 21809.14 | 4093.0 |
| 2024-11-29 05:00:00 | NQ | Futures | 21809.4 | 21821.66 | 21791.92 | 21807.83 | 3672.0 |
| 2024-11-29 06:00:00 | NQ | Futures | 21806.79 | 21807.05 | 21786.18 | 21795.57 | 3729.0 |
| 2024-11-29 07:00:00 | NQ | Futures | 21795.83 | 21798.44 | 21752.0 | 21768.18 | 6079.0 |
| 2024-11-29 08:00:00 | NQ | Futures | 21767.91 | 21775.22 | 21720.69 | 21737.65 | 12547.0 |
| 2024-11-29 09:00:00 | NQ | Futures | 21737.65 | 21832.36 | 21713.65 | 21828.71 | 51839.0 |
| 2024-11-29 10:00:00 | NQ | Futures | 21828.45 | 21897.59 | 21818.01 | 21868.63 | 65322.0 |
| 2024-11-29 11:00:00 | NQ | Futures | 21869.15 | 21923.42 | 21869.15 | 21912.98 | 44525.0 |
| 2024-11-29 12:00:00 | NQ | Futures | 21912.98 | 21934.9 | 21895.24 | 21906.98 | 48497.0 |
| 2024-11-29 13:00:00 | NQ | Futures | 21906.72 | 21911.68 | 21896.02 | 21907.5 | 6834.0 |
| 2024-11-29 00:00:00 | YM | Futures | 46798.5 | 46801.6 | 46777.7 | 46778.7 | 437.0 |
| 2024-11-29 01:00:00 | YM | Futures | 46778.7 | 46792.2 | 46765.2 | 46777.7 | 405.0 |
| 2024-11-29 02:00:00 | YM | Futures | 46780.8 | 46786.0 | 46745.4 | 46774.5 | 1066.0 |
| 2024-11-29 03:00:00 | YM | Futures | 46775.6 | 46821.4 | 46758.9 | 46778.7 | 1576.0 |
| 2024-11-29 04:00:00 | YM | Futures | 46777.7 | 46824.5 | 46763.1 | 46809.9 | 1483.0 |
| 2024-11-29 05:00:00 | YM | Futures | 46809.9 | 46831.8 | 46783.9 | 46798.5 | 1226.0 |
| 2024-11-29 06:00:00 | YM | Futures | 46795.3 | 46839.1 | 46775.6 | 46837.0 | 1132.0 |
| 2024-11-29 07:00:00 | YM | Futures | 46835.9 | 46839.1 | 46775.6 | 46795.3 | 2154.0 |
| 2024-11-29 08:00:00 | YM | Futures | 46793.3 | 46802.6 | 46705.8 | 46735.0 | 2886.0 |
| 2024-11-29 09:00:00 | YM | Futures | 46736.0 | 46828.6 | 46680.9 | 46745.4 | 11133.0 |
| 2024-11-29 10:00:00 | YM | Futures | 46745.4 | 46858.8 | 46741.2 | 46851.5 | 10648.0 |
| 2024-11-29 11:00:00 | YM | Futures | 46851.5 | 46970.2 | 46839.1 | 46946.3 | 8985.0 |
| 2024-11-29 12:00:00 | YM | Futures | 46946.3 | 47011.8 | 46871.3 | 46892.1 | 11738.0 |
| 2024-11-29 13:00:00 | YM | Futures | 46892.1 | 46914.0 | 46871.3 | 46885.9 | 1703.0 |
| 2024-11-29 00:00:00 | CL | Futures | 62.73 | 62.77 | 62.67 | 62.69 | 795.0 |
| 2024-11-29 01:00:00 | CL | Futures | 62.69 | 62.76 | 62.65 | 62.74 | 828.0 |
| 2024-11-29 02:00:00 | CL | Futures | 62.73 | 62.73 | 62.13 | 62.16 | 5012.0 |
| 2024-11-29 03:00:00 | CL | Futures | 62.16 | 62.62 | 62.09 | 62.21 | 8047.0 |
| 2024-11-29 04:00:00 | CL | Futures | 62.2 | 62.43 | 61.97 | 62.04 | 7551.0 |
| 2024-11-29 05:00:00 | CL | Futures | 62.02 | 62.12 | 61.89 | 61.9 | 6247.0 |
| 2024-11-29 06:00:00 | CL | Futures | 61.91 | 62.21 | 61.9 | 62.03 | 3674.0 |
| 2024-11-29 07:00:00 | CL | Futures | 62.04 | 62.98 | 62.02 | 62.86 | 12418.0 |
> showing 50 of 1,418 rows — these rows as CSV