PREVIEW / futures_1hour / 2024-06-20
file: by_date/futures_1hour/2024/2024-06-20.parquet size: 66 KB rows: 2,061
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-06-20 00:00:00 | ES | Futures | 5841.8 | 5845.99 | 5841.01 | 5845.21 | 3520.0 |
| 2024-06-20 01:00:00 | ES | Futures | 5844.95 | 5850.19 | 5844.68 | 5849.14 | 6555.0 |
| 2024-06-20 02:00:00 | ES | Futures | 5848.88 | 5849.93 | 5846.26 | 5846.78 | 7317.0 |
| 2024-06-20 03:00:00 | ES | Futures | 5846.78 | 5859.89 | 5846.26 | 5852.02 | 20893.0 |
| 2024-06-20 04:00:00 | ES | Futures | 5852.02 | 5854.12 | 5849.4 | 5853.33 | 12217.0 |
| 2024-06-20 05:00:00 | ES | Futures | 5853.33 | 5854.65 | 5850.71 | 5853.6 | 9774.0 |
| 2024-06-20 06:00:00 | ES | Futures | 5853.6 | 5855.69 | 5852.02 | 5853.6 | 8431.0 |
| 2024-06-20 07:00:00 | ES | Futures | 5853.33 | 5856.22 | 5848.88 | 5850.45 | 15255.0 |
| 2024-06-20 08:00:00 | ES | Futures | 5850.45 | 5852.81 | 5841.27 | 5842.59 | 34128.0 |
| 2024-06-20 09:00:00 | ES | Futures | 5842.59 | 5848.09 | 5834.46 | 5842.06 | 142434.0 |
| 2024-06-20 10:00:00 | ES | Futures | 5842.32 | 5844.68 | 5829.48 | 5838.39 | 184188.0 |
| 2024-06-20 11:00:00 | ES | Futures | 5838.39 | 5841.8 | 5828.43 | 5828.69 | 116208.0 |
| 2024-06-20 12:00:00 | ES | Futures | 5828.69 | 5831.57 | 5802.74 | 5816.63 | 229168.0 |
| 2024-06-20 13:00:00 | ES | Futures | 5816.37 | 5816.63 | 5794.35 | 5814.01 | 180552.0 |
| 2024-06-20 14:00:00 | ES | Futures | 5814.27 | 5826.07 | 5813.22 | 5815.06 | 133888.0 |
| 2024-06-20 15:00:00 | ES | Futures | 5815.06 | 5822.66 | 5800.64 | 5814.8 | 237082.0 |
| 2024-06-20 16:00:00 | ES | Futures | 5815.06 | 5815.85 | 5808.77 | 5813.75 | 49789.0 |
| 2024-06-20 18:00:00 | ES | Futures | 5814.8 | 5816.63 | 5812.7 | 5815.32 | 4379.0 |
| 2024-06-20 19:00:00 | ES | Futures | 5815.32 | 5817.94 | 5814.53 | 5816.89 | 3709.0 |
| 2024-06-20 20:00:00 | ES | Futures | 5816.63 | 5817.68 | 5810.6 | 5811.39 | 4315.0 |
| 2024-06-20 21:00:00 | ES | Futures | 5811.13 | 5812.96 | 5810.08 | 5812.7 | 3873.0 |
| 2024-06-20 22:00:00 | ES | Futures | 5812.96 | 5816.11 | 5812.17 | 5815.85 | 3045.0 |
| 2024-06-20 23:00:00 | ES | Futures | 5815.85 | 5817.42 | 5814.8 | 5815.06 | 2481.0 |
| 2024-06-20 00:00:00 | NQ | Futures | 21424.82 | 21450.43 | 21417.69 | 21442.77 | 3904.0 |
| 2024-06-20 01:00:00 | NQ | Futures | 21443.03 | 21470.75 | 21441.19 | 21464.42 | 5903.0 |
| 2024-06-20 02:00:00 | NQ | Futures | 21463.89 | 21467.59 | 21440.13 | 21447.52 | 5740.0 |
| 2024-06-20 03:00:00 | NQ | Futures | 21447.52 | 21510.35 | 21444.88 | 21477.88 | 10794.0 |
| 2024-06-20 04:00:00 | NQ | Futures | 21477.35 | 21478.14 | 21447.26 | 21466.27 | 7907.0 |
| 2024-06-20 05:00:00 | NQ | Futures | 21467.06 | 21469.17 | 21443.56 | 21458.87 | 7165.0 |
| 2024-06-20 06:00:00 | NQ | Futures | 21459.4 | 21474.45 | 21446.99 | 21456.76 | 5475.0 |
| 2024-06-20 07:00:00 | NQ | Futures | 21455.97 | 21467.06 | 21425.88 | 21431.95 | 8076.0 |
| 2024-06-20 08:00:00 | NQ | Futures | 21431.95 | 21441.45 | 21391.56 | 21401.06 | 20932.0 |
| 2024-06-20 09:00:00 | NQ | Futures | 21401.59 | 21404.49 | 21328.2 | 21366.22 | 101480.0 |
| 2024-06-20 10:00:00 | NQ | Futures | 21366.48 | 21373.08 | 21243.73 | 21346.68 | 115683.0 |
| 2024-06-20 11:00:00 | NQ | Futures | 21346.95 | 21360.14 | 21282.27 | 21290.98 | 64207.0 |
| 2024-06-20 12:00:00 | NQ | Futures | 21290.72 | 21303.92 | 21130.74 | 21202.28 | 103759.0 |
| 2024-06-20 13:00:00 | NQ | Futures | 21202.28 | 21203.07 | 21074.52 | 21153.45 | 102229.0 |
| 2024-06-20 14:00:00 | NQ | Futures | 21153.71 | 21202.55 | 21133.12 | 21136.02 | 80290.0 |
| 2024-06-20 15:00:00 | NQ | Futures | 21136.02 | 21191.2 | 21080.85 | 21156.88 | 108468.0 |
| 2024-06-20 16:00:00 | NQ | Futures | 21156.88 | 21177.73 | 21147.37 | 21175.09 | 15457.0 |
| 2024-06-20 18:00:00 | NQ | Futures | 21164.27 | 21185.12 | 21161.63 | 21181.96 | 2917.0 |
| 2024-06-20 19:00:00 | NQ | Futures | 21182.48 | 21199.11 | 21181.96 | 21192.78 | 2726.0 |
| 2024-06-20 20:00:00 | NQ | Futures | 21191.72 | 21194.1 | 21155.03 | 21156.09 | 3974.0 |
| 2024-06-20 21:00:00 | NQ | Futures | 21156.88 | 21169.02 | 21152.92 | 21166.38 | 3033.0 |
| 2024-06-20 22:00:00 | NQ | Futures | 21166.64 | 21181.16 | 21158.73 | 21179.32 | 2674.0 |
| 2024-06-20 23:00:00 | NQ | Futures | 21179.32 | 21184.86 | 21173.77 | 21175.36 | 1888.0 |
| 2024-06-20 00:00:00 | YM | Futures | 41243.2 | 41251.6 | 41233.7 | 41247.4 | 544.0 |
| 2024-06-20 01:00:00 | YM | Futures | 41246.3 | 41283.1 | 41246.3 | 41274.7 | 1058.0 |
| 2024-06-20 02:00:00 | YM | Futures | 41274.7 | 41281.0 | 41258.9 | 41260.0 | 1843.0 |
| 2024-06-20 03:00:00 | YM | Futures | 41258.9 | 41340.9 | 41253.7 | 41292.6 | 2389.0 |
> showing 50 of 2,061 rows — these rows as CSV