PREVIEW / futures_1hour / 2024-06-28
file: by_date/futures_1hour/2024/2024-06-28.parquet size: 57 KB rows: 1,673
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-28 00:00:00 | ES | Futures | 5831.31 | 5831.84 | 5827.64 | 5828.69 | 4572.0 |
| 2024-06-28 01:00:00 | ES | Futures | 5828.69 | 5829.22 | 5826.07 | 5827.64 | 4599.0 |
| 2024-06-28 02:00:00 | ES | Futures | 5827.38 | 5833.41 | 5827.38 | 5831.31 | 8961.0 |
| 2024-06-28 03:00:00 | ES | Futures | 5831.57 | 5834.46 | 5829.22 | 5830.0 | 11155.0 |
| 2024-06-28 04:00:00 | ES | Futures | 5830.0 | 5834.2 | 5827.12 | 5833.41 | 11777.0 |
| 2024-06-28 05:00:00 | ES | Futures | 5833.67 | 5838.13 | 5833.67 | 5836.29 | 12957.0 |
| 2024-06-28 06:00:00 | ES | Futures | 5836.29 | 5837.6 | 5833.93 | 5837.34 | 8626.0 |
| 2024-06-28 07:00:00 | ES | Futures | 5837.34 | 5837.34 | 5833.93 | 5835.51 | 13583.0 |
| 2024-06-28 08:00:00 | ES | Futures | 5835.51 | 5844.16 | 5825.28 | 5826.86 | 69501.0 |
| 2024-06-28 09:00:00 | ES | Futures | 5827.12 | 5834.46 | 5817.68 | 5832.62 | 159037.0 |
| 2024-06-28 10:00:00 | ES | Futures | 5832.62 | 5856.74 | 5832.62 | 5839.18 | 281304.0 |
| 2024-06-28 11:00:00 | ES | Futures | 5838.92 | 5839.18 | 5823.71 | 5828.69 | 193968.0 |
| 2024-06-28 12:00:00 | ES | Futures | 5828.43 | 5830.0 | 5804.83 | 5813.75 | 170203.0 |
| 2024-06-28 13:00:00 | ES | Futures | 5813.75 | 5821.09 | 5809.03 | 5811.13 | 102151.0 |
| 2024-06-28 14:00:00 | ES | Futures | 5810.86 | 5817.16 | 5799.85 | 5801.69 | 126317.0 |
| 2024-06-28 15:00:00 | ES | Futures | 5801.69 | 5805.88 | 5778.88 | 5791.99 | 404339.0 |
| 2024-06-28 16:00:00 | ES | Futures | 5792.25 | 5803.52 | 5791.73 | 5801.43 | 99200.0 |
| 2024-06-28 00:00:00 | NQ | Futures | 21256.93 | 21257.72 | 21228.68 | 21233.17 | 3384.0 |
| 2024-06-28 01:00:00 | NQ | Futures | 21232.9 | 21237.13 | 21223.4 | 21233.96 | 2445.0 |
| 2024-06-28 02:00:00 | NQ | Futures | 21233.7 | 21257.72 | 21233.43 | 21239.77 | 5200.0 |
| 2024-06-28 03:00:00 | NQ | Futures | 21238.45 | 21248.74 | 21228.68 | 21229.47 | 5447.0 |
| 2024-06-28 04:00:00 | NQ | Futures | 21230.26 | 21242.67 | 21215.48 | 21240.03 | 6190.0 |
| 2024-06-28 05:00:00 | NQ | Futures | 21240.3 | 21259.04 | 21238.98 | 21252.44 | 5364.0 |
| 2024-06-28 06:00:00 | NQ | Futures | 21251.38 | 21255.87 | 21240.82 | 21251.91 | 3925.0 |
| 2024-06-28 07:00:00 | NQ | Futures | 21251.91 | 21255.34 | 21243.99 | 21252.7 | 4775.0 |
| 2024-06-28 08:00:00 | NQ | Futures | 21252.18 | 21306.56 | 21200.96 | 21205.45 | 34138.0 |
| 2024-06-28 09:00:00 | NQ | Futures | 21205.45 | 21275.93 | 21160.05 | 21274.35 | 93554.0 |
| 2024-06-28 10:00:00 | NQ | Futures | 21275.14 | 21407.13 | 21244.78 | 21267.22 | 142008.0 |
| 2024-06-28 11:00:00 | NQ | Futures | 21266.96 | 21267.22 | 21198.59 | 21232.9 | 86991.0 |
| 2024-06-28 12:00:00 | NQ | Futures | 21233.7 | 21240.3 | 21103.03 | 21156.88 | 83365.0 |
| 2024-06-28 13:00:00 | NQ | Futures | 21156.61 | 21195.16 | 21136.81 | 21161.89 | 43722.0 |
| 2024-06-28 14:00:00 | NQ | Futures | 21161.1 | 21194.36 | 21122.03 | 21131.8 | 47516.0 |
| 2024-06-28 15:00:00 | NQ | Futures | 21131.8 | 21137.87 | 21019.61 | 21047.32 | 123041.0 |
| 2024-06-28 16:00:00 | NQ | Futures | 21047.32 | 21094.05 | 21046.0 | 21083.23 | 25883.0 |
| 2024-06-28 00:00:00 | YM | Futures | 41555.2 | 41557.3 | 41542.6 | 41547.9 | 616.0 |
| 2024-06-28 01:00:00 | YM | Futures | 41547.9 | 41552.1 | 41536.3 | 41541.6 | 485.0 |
| 2024-06-28 02:00:00 | YM | Futures | 41540.5 | 41592.0 | 41540.5 | 41588.9 | 1362.0 |
| 2024-06-28 03:00:00 | YM | Futures | 41587.8 | 41603.6 | 41554.2 | 41559.4 | 1589.0 |
| 2024-06-28 04:00:00 | YM | Futures | 41560.5 | 41591.0 | 41535.3 | 41581.5 | 2244.0 |
| 2024-06-28 05:00:00 | YM | Futures | 41580.5 | 41608.8 | 41577.3 | 41588.9 | 1576.0 |
| 2024-06-28 06:00:00 | YM | Futures | 41588.9 | 41599.4 | 41576.2 | 41596.2 | 975.0 |
| 2024-06-28 07:00:00 | YM | Futures | 41596.2 | 41601.5 | 41561.5 | 41576.2 | 1951.0 |
| 2024-06-28 08:00:00 | YM | Futures | 41578.4 | 41612.0 | 41544.7 | 41561.5 | 5250.0 |
| 2024-06-28 09:00:00 | YM | Futures | 41564.7 | 41807.4 | 41468.0 | 41610.9 | 28531.0 |
| 2024-06-28 10:00:00 | YM | Futures | 41614.1 | 41838.9 | 41614.1 | 41728.6 | 28085.0 |
| 2024-06-28 11:00:00 | YM | Futures | 41727.6 | 41728.6 | 41577.3 | 41601.5 | 18158.0 |
| 2024-06-28 12:00:00 | YM | Futures | 41602.5 | 41604.6 | 41500.6 | 41544.7 | 11241.0 |
| 2024-06-28 13:00:00 | YM | Futures | 41543.7 | 41581.5 | 41444.9 | 41454.4 | 8194.0 |
| 2024-06-28 14:00:00 | YM | Futures | 41453.3 | 41491.1 | 41368.2 | 41372.4 | 9808.0 |
| 2024-06-28 15:00:00 | YM | Futures | 41372.4 | 41493.2 | 41276.8 | 41486.9 | 26487.0 |
> showing 50 of 1,673 rows — these rows as CSV