PREVIEW / futures_1hour / 2024-10-21
file: by_date/futures_1hour/2024/2024-10-21.parquet size: 68 KB rows: 2,076
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-10-21 00:00:00 | ES | Futures | 6133.06 | 6133.58 | 6130.2 | 6130.72 | 2342.0 |
| 2024-10-21 01:00:00 | ES | Futures | 6130.72 | 6130.98 | 6127.09 | 6127.61 | 4940.0 |
| 2024-10-21 02:00:00 | ES | Futures | 6127.35 | 6129.16 | 6123.71 | 6125.27 | 5589.0 |
| 2024-10-21 03:00:00 | ES | Futures | 6125.53 | 6131.5 | 6125.01 | 6127.35 | 8143.0 |
| 2024-10-21 04:00:00 | ES | Futures | 6127.35 | 6130.46 | 6126.57 | 6128.9 | 5636.0 |
| 2024-10-21 05:00:00 | ES | Futures | 6128.9 | 6129.42 | 6116.97 | 6121.9 | 11296.0 |
| 2024-10-21 06:00:00 | ES | Futures | 6121.9 | 6123.45 | 6111.26 | 6111.52 | 11211.0 |
| 2024-10-21 07:00:00 | ES | Futures | 6111.52 | 6113.85 | 6107.1 | 6109.7 | 15447.0 |
| 2024-10-21 08:00:00 | ES | Futures | 6109.7 | 6118.26 | 6107.88 | 6117.23 | 18320.0 |
| 2024-10-21 09:00:00 | ES | Futures | 6117.23 | 6129.68 | 6116.45 | 6125.01 | 102557.0 |
| 2024-10-21 10:00:00 | ES | Futures | 6125.27 | 6133.58 | 6103.99 | 6109.44 | 184658.0 |
| 2024-10-21 11:00:00 | ES | Futures | 6109.44 | 6110.48 | 6088.42 | 6106.85 | 194709.0 |
| 2024-10-21 12:00:00 | ES | Futures | 6106.85 | 6112.81 | 6101.14 | 6112.04 | 80007.0 |
| 2024-10-21 13:00:00 | ES | Futures | 6112.3 | 6118.0 | 6109.7 | 6116.71 | 58747.0 |
| 2024-10-21 14:00:00 | ES | Futures | 6116.97 | 6117.23 | 6105.81 | 6107.62 | 58203.0 |
| 2024-10-21 15:00:00 | ES | Futures | 6107.62 | 6122.42 | 6105.29 | 6121.64 | 170768.0 |
| 2024-10-21 16:00:00 | ES | Futures | 6121.64 | 6125.79 | 6119.3 | 6123.45 | 67819.0 |
| 2024-10-21 18:00:00 | ES | Futures | 6125.53 | 6125.53 | 6120.6 | 6120.86 | 3822.0 |
| 2024-10-21 19:00:00 | ES | Futures | 6120.6 | 6122.16 | 6119.3 | 6120.34 | 2272.0 |
| 2024-10-21 20:00:00 | ES | Futures | 6120.34 | 6120.6 | 6111.78 | 6112.3 | 8377.0 |
| 2024-10-21 21:00:00 | ES | Futures | 6112.04 | 6114.11 | 6109.18 | 6111.52 | 7955.0 |
| 2024-10-21 22:00:00 | ES | Futures | 6111.52 | 6114.63 | 6108.66 | 6109.18 | 4216.0 |
| 2024-10-21 23:00:00 | ES | Futures | 6109.18 | 6112.81 | 6109.18 | 6109.7 | 2969.0 |
| 2024-10-21 00:00:00 | NQ | Futures | 21373.94 | 21377.33 | 21358.54 | 21362.72 | 1772.0 |
| 2024-10-21 01:00:00 | NQ | Futures | 21362.2 | 21365.07 | 21336.63 | 21341.06 | 3438.0 |
| 2024-10-21 02:00:00 | NQ | Futures | 21341.06 | 21353.33 | 21316.54 | 21326.45 | 4451.0 |
| 2024-10-21 03:00:00 | NQ | Futures | 21326.45 | 21353.85 | 21318.88 | 21332.71 | 4822.0 |
| 2024-10-21 04:00:00 | NQ | Futures | 21332.19 | 21352.8 | 21329.84 | 21346.8 | 4047.0 |
| 2024-10-21 05:00:00 | NQ | Futures | 21347.32 | 21349.67 | 21284.71 | 21315.75 | 7072.0 |
| 2024-10-21 06:00:00 | NQ | Futures | 21316.8 | 21323.32 | 21258.61 | 21260.96 | 7633.0 |
| 2024-10-21 07:00:00 | NQ | Futures | 21260.7 | 21272.44 | 21231.74 | 21247.66 | 8408.0 |
| 2024-10-21 08:00:00 | NQ | Futures | 21247.92 | 21299.32 | 21239.31 | 21292.01 | 9989.0 |
| 2024-10-21 09:00:00 | NQ | Futures | 21291.23 | 21397.42 | 21286.79 | 21387.77 | 53085.0 |
| 2024-10-21 10:00:00 | NQ | Futures | 21388.03 | 21451.69 | 21271.66 | 21319.41 | 95321.0 |
| 2024-10-21 11:00:00 | NQ | Futures | 21319.67 | 21358.28 | 21233.04 | 21349.15 | 77481.0 |
| 2024-10-21 12:00:00 | NQ | Futures | 21348.37 | 21370.81 | 21317.58 | 21364.28 | 34764.0 |
| 2024-10-21 13:00:00 | NQ | Futures | 21364.54 | 21391.94 | 21348.11 | 21386.2 | 28682.0 |
| 2024-10-21 14:00:00 | NQ | Futures | 21386.46 | 21391.16 | 21343.93 | 21350.72 | 25327.0 |
| 2024-10-21 15:00:00 | NQ | Futures | 21351.24 | 21418.81 | 21338.45 | 21416.21 | 45950.0 |
| 2024-10-21 16:00:00 | NQ | Futures | 21416.47 | 21444.12 | 21407.07 | 21435.25 | 14581.0 |
| 2024-10-21 18:00:00 | NQ | Futures | 21432.9 | 21440.73 | 21409.94 | 21411.25 | 3035.0 |
| 2024-10-21 19:00:00 | NQ | Futures | 21411.77 | 21422.73 | 21403.94 | 21411.51 | 1720.0 |
| 2024-10-21 20:00:00 | NQ | Futures | 21411.51 | 21411.77 | 21366.11 | 21370.02 | 5584.0 |
| 2024-10-21 21:00:00 | NQ | Futures | 21370.81 | 21377.85 | 21352.8 | 21364.28 | 4997.0 |
| 2024-10-21 22:00:00 | NQ | Futures | 21364.02 | 21378.37 | 21349.93 | 21352.54 | 3343.0 |
| 2024-10-21 23:00:00 | NQ | Futures | 21352.02 | 21370.81 | 21350.72 | 21360.89 | 2097.0 |
| 2024-10-21 00:00:00 | YM | Futures | 45320.6 | 45322.7 | 45308.1 | 45311.2 | 342.0 |
| 2024-10-21 01:00:00 | YM | Futures | 45311.2 | 45317.5 | 45299.8 | 45302.9 | 643.0 |
| 2024-10-21 02:00:00 | YM | Futures | 45301.9 | 45315.4 | 45296.7 | 45303.9 | 788.0 |
| 2024-10-21 03:00:00 | YM | Futures | 45303.9 | 45350.8 | 45299.8 | 45324.8 | 1348.0 |
> showing 50 of 2,076 rows — these rows as CSV