PREVIEW / futures_1hour / 2024-10-18
file: by_date/futures_1hour/2024/2024-10-18.parquet size: 56 KB rows: 1,674
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-18 00:00:00 | ES | Futures | 6108.4 | 6110.74 | 6107.62 | 6109.7 | 1894.0 |
| 2024-10-18 01:00:00 | ES | Futures | 6109.7 | 6113.07 | 6108.92 | 6112.55 | 4694.0 |
| 2024-10-18 02:00:00 | ES | Futures | 6112.81 | 6114.63 | 6111.52 | 6113.59 | 6572.0 |
| 2024-10-18 03:00:00 | ES | Futures | 6113.85 | 6121.9 | 6113.33 | 6121.9 | 11287.0 |
| 2024-10-18 04:00:00 | ES | Futures | 6121.9 | 6124.49 | 6119.56 | 6121.9 | 9558.0 |
| 2024-10-18 05:00:00 | ES | Futures | 6122.16 | 6125.27 | 6118.0 | 6119.04 | 8014.0 |
| 2024-10-18 06:00:00 | ES | Futures | 6118.78 | 6122.16 | 6116.45 | 6121.9 | 6112.0 |
| 2024-10-18 07:00:00 | ES | Futures | 6121.64 | 6126.05 | 6118.78 | 6123.97 | 13418.0 |
| 2024-10-18 08:00:00 | ES | Futures | 6123.97 | 6127.35 | 6121.12 | 6125.01 | 16561.0 |
| 2024-10-18 09:00:00 | ES | Futures | 6125.01 | 6131.5 | 6110.74 | 6118.0 | 165642.0 |
| 2024-10-18 10:00:00 | ES | Futures | 6118.0 | 6125.79 | 6115.67 | 6119.82 | 118589.0 |
| 2024-10-18 11:00:00 | ES | Futures | 6119.56 | 6130.72 | 6119.3 | 6124.75 | 84274.0 |
| 2024-10-18 12:00:00 | ES | Futures | 6124.75 | 6139.29 | 6122.42 | 6133.06 | 71992.0 |
| 2024-10-18 13:00:00 | ES | Futures | 6133.06 | 6137.73 | 6130.98 | 6132.02 | 61815.0 |
| 2024-10-18 14:00:00 | ES | Futures | 6132.02 | 6140.84 | 6123.97 | 6134.61 | 73577.0 |
| 2024-10-18 15:00:00 | ES | Futures | 6134.61 | 6134.61 | 6126.05 | 6131.24 | 139181.0 |
| 2024-10-18 16:00:00 | ES | Futures | 6130.98 | 6134.87 | 6129.16 | 6132.54 | 56128.0 |
| 2024-10-18 00:00:00 | NQ | Futures | 21251.05 | 21270.36 | 21247.39 | 21263.05 | 1578.0 |
| 2024-10-18 01:00:00 | NQ | Futures | 21263.57 | 21297.75 | 21258.61 | 21295.4 | 2564.0 |
| 2024-10-18 02:00:00 | NQ | Futures | 21295.14 | 21324.89 | 21287.31 | 21321.75 | 4346.0 |
| 2024-10-18 03:00:00 | NQ | Futures | 21322.02 | 21348.63 | 21313.14 | 21347.06 | 5006.0 |
| 2024-10-18 04:00:00 | NQ | Futures | 21347.59 | 21361.41 | 21327.49 | 21341.32 | 5621.0 |
| 2024-10-18 05:00:00 | NQ | Futures | 21342.63 | 21355.41 | 21314.97 | 21320.97 | 4304.0 |
| 2024-10-18 06:00:00 | NQ | Futures | 21321.75 | 21343.15 | 21309.75 | 21340.8 | 3897.0 |
| 2024-10-18 07:00:00 | NQ | Futures | 21340.54 | 21373.68 | 21328.8 | 21361.67 | 6548.0 |
| 2024-10-18 08:00:00 | NQ | Futures | 21361.94 | 21379.94 | 21349.67 | 21372.37 | 7438.0 |
| 2024-10-18 09:00:00 | NQ | Futures | 21372.63 | 21406.03 | 21324.89 | 21368.98 | 68892.0 |
| 2024-10-18 10:00:00 | NQ | Futures | 21369.5 | 21419.08 | 21344.72 | 21350.72 | 58893.0 |
| 2024-10-18 11:00:00 | NQ | Futures | 21350.19 | 21425.86 | 21348.63 | 21362.46 | 49250.0 |
| 2024-10-18 12:00:00 | NQ | Futures | 21362.46 | 21417.25 | 21334.28 | 21390.9 | 36395.0 |
| 2024-10-18 13:00:00 | NQ | Futures | 21391.16 | 21419.6 | 21373.15 | 21379.68 | 30351.0 |
| 2024-10-18 14:00:00 | NQ | Futures | 21379.94 | 21403.94 | 21344.45 | 21386.72 | 24918.0 |
| 2024-10-18 15:00:00 | NQ | Futures | 21386.72 | 21390.64 | 21350.19 | 21376.81 | 36311.0 |
| 2024-10-18 16:00:00 | NQ | Futures | 21376.02 | 21399.25 | 21367.68 | 21378.37 | 11591.0 |
| 2024-10-18 00:00:00 | YM | Futures | 45247.7 | 45261.3 | 45244.6 | 45258.2 | 176.0 |
| 2024-10-18 01:00:00 | YM | Futures | 45261.3 | 45266.5 | 45245.7 | 45264.4 | 579.0 |
| 2024-10-18 02:00:00 | YM | Futures | 45264.4 | 45265.4 | 45220.7 | 45234.2 | 1067.0 |
| 2024-10-18 03:00:00 | YM | Futures | 45234.2 | 45299.8 | 45226.9 | 45292.5 | 1209.0 |
| 2024-10-18 04:00:00 | YM | Futures | 45293.5 | 45309.2 | 45284.2 | 45298.7 | 1168.0 |
| 2024-10-18 05:00:00 | YM | Futures | 45299.8 | 45319.6 | 45285.2 | 45293.5 | 1186.0 |
| 2024-10-18 06:00:00 | YM | Futures | 45294.6 | 45301.9 | 45268.6 | 45296.7 | 1520.0 |
| 2024-10-18 07:00:00 | YM | Futures | 45295.6 | 45333.1 | 45209.2 | 45231.1 | 3724.0 |
| 2024-10-18 08:00:00 | YM | Futures | 45233.2 | 45244.6 | 45186.3 | 45186.3 | 2334.0 |
| 2024-10-18 09:00:00 | YM | Futures | 45186.3 | 45276.9 | 45050.0 | 45063.5 | 23290.0 |
| 2024-10-18 10:00:00 | YM | Futures | 45064.6 | 45192.6 | 45052.1 | 45167.6 | 13127.0 |
| 2024-10-18 11:00:00 | YM | Futures | 45166.6 | 45219.6 | 45148.9 | 45207.2 | 6766.0 |
| 2024-10-18 12:00:00 | YM | Futures | 45209.2 | 45348.7 | 45202.0 | 45289.4 | 7237.0 |
| 2024-10-18 13:00:00 | YM | Futures | 45290.4 | 45324.8 | 45269.6 | 45284.2 | 4524.0 |
| 2024-10-18 14:00:00 | YM | Futures | 45283.1 | 45357.0 | 45215.5 | 45308.1 | 5944.0 |
| 2024-10-18 15:00:00 | YM | Futures | 45303.9 | 45307.1 | 45256.1 | 45289.4 | 7485.0 |
> showing 50 of 1,674 rows — these rows as CSV