PREVIEW / futures_1hour / 2024-04-30
file: by_date/futures_1hour/2024/2024-04-30.parquet size: 69 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-04-30 00:00:00 | ES | Futures | 5457.66 | 5457.93 | 5455.54 | 5456.07 | 1997.0 |
| 2024-04-30 01:00:00 | ES | Futures | 5456.07 | 5456.87 | 5449.44 | 5455.01 | 5728.0 |
| 2024-04-30 02:00:00 | ES | Futures | 5455.01 | 5458.99 | 5453.95 | 5457.4 | 7030.0 |
| 2024-04-30 03:00:00 | ES | Futures | 5457.4 | 5458.99 | 5453.95 | 5456.34 | 8985.0 |
| 2024-04-30 04:00:00 | ES | Futures | 5456.07 | 5457.66 | 5450.24 | 5450.77 | 9540.0 |
| 2024-04-30 05:00:00 | ES | Futures | 5451.03 | 5455.54 | 5449.44 | 5453.42 | 17197.0 |
| 2024-04-30 06:00:00 | ES | Futures | 5453.68 | 5460.05 | 5452.62 | 5459.79 | 9837.0 |
| 2024-04-30 07:00:00 | ES | Futures | 5459.52 | 5460.32 | 5455.28 | 5456.07 | 13802.0 |
| 2024-04-30 08:00:00 | ES | Futures | 5455.81 | 5460.05 | 5433.79 | 5440.68 | 81826.0 |
| 2024-04-30 09:00:00 | ES | Futures | 5440.68 | 5455.81 | 5437.5 | 5451.56 | 154504.0 |
| 2024-04-30 10:00:00 | ES | Futures | 5451.3 | 5455.81 | 5439.89 | 5445.72 | 180691.0 |
| 2024-04-30 11:00:00 | ES | Futures | 5445.72 | 5445.72 | 5417.6 | 5423.44 | 203443.0 |
| 2024-04-30 12:00:00 | ES | Futures | 5423.71 | 5428.22 | 5404.07 | 5409.38 | 148099.0 |
| 2024-04-30 13:00:00 | ES | Futures | 5409.64 | 5419.99 | 5403.01 | 5418.13 | 108257.0 |
| 2024-04-30 14:00:00 | ES | Futures | 5418.4 | 5422.91 | 5399.83 | 5404.07 | 126222.0 |
| 2024-04-30 15:00:00 | ES | Futures | 5404.34 | 5409.64 | 5374.89 | 5374.89 | 325254.0 |
| 2024-04-30 16:00:00 | ES | Futures | 5375.16 | 5387.89 | 5360.03 | 5364.28 | 160321.0 |
| 2024-04-30 18:00:00 | ES | Futures | 5358.97 | 5366.67 | 5357.38 | 5365.08 | 13420.0 |
| 2024-04-30 19:00:00 | ES | Futures | 5364.81 | 5369.59 | 5361.89 | 5367.2 | 7728.0 |
| 2024-04-30 20:00:00 | ES | Futures | 5367.46 | 5369.59 | 5365.87 | 5369.05 | 6372.0 |
| 2024-04-30 21:00:00 | ES | Futures | 5368.79 | 5370.38 | 5367.2 | 5369.85 | 5831.0 |
| 2024-04-30 22:00:00 | ES | Futures | 5369.85 | 5372.5 | 5366.93 | 5371.18 | 4197.0 |
| 2024-04-30 23:00:00 | ES | Futures | 5371.44 | 5374.89 | 5371.44 | 5374.63 | 4389.0 |
| 2024-04-30 00:00:00 | NQ | Futures | 19164.79 | 19165.86 | 19155.7 | 19158.64 | 1432.0 |
| 2024-04-30 01:00:00 | NQ | Futures | 19158.91 | 19159.71 | 19123.33 | 19143.66 | 4279.0 |
| 2024-04-30 02:00:00 | NQ | Futures | 19143.12 | 19164.79 | 19138.31 | 19153.29 | 4695.0 |
| 2024-04-30 03:00:00 | NQ | Futures | 19153.02 | 19161.85 | 19131.62 | 19151.42 | 6051.0 |
| 2024-04-30 04:00:00 | NQ | Futures | 19151.15 | 19158.1 | 19121.46 | 19121.46 | 6032.0 |
| 2024-04-30 05:00:00 | NQ | Futures | 19122.26 | 19140.18 | 19112.09 | 19124.93 | 7545.0 |
| 2024-04-30 06:00:00 | NQ | Futures | 19125.2 | 19149.01 | 19120.12 | 19144.19 | 5191.0 |
| 2024-04-30 07:00:00 | NQ | Futures | 19143.66 | 19147.4 | 19121.46 | 19126.81 | 7377.0 |
| 2024-04-30 08:00:00 | NQ | Futures | 19126.27 | 19139.38 | 19036.12 | 19075.18 | 35884.0 |
| 2024-04-30 09:00:00 | NQ | Futures | 19074.64 | 19140.18 | 19059.13 | 19123.06 | 81494.0 |
| 2024-04-30 10:00:00 | NQ | Futures | 19123.06 | 19148.21 | 19065.55 | 19087.48 | 86448.0 |
| 2024-04-30 11:00:00 | NQ | Futures | 19087.21 | 19089.62 | 18973.53 | 19008.03 | 92115.0 |
| 2024-04-30 12:00:00 | NQ | Futures | 19008.03 | 19020.61 | 18920.29 | 18944.1 | 62559.0 |
| 2024-04-30 13:00:00 | NQ | Futures | 18944.1 | 18978.88 | 18913.07 | 18970.32 | 49490.0 |
| 2024-04-30 14:00:00 | NQ | Futures | 18970.05 | 18987.7 | 18905.31 | 18919.49 | 55178.0 |
| 2024-04-30 15:00:00 | NQ | Futures | 18920.02 | 18948.65 | 18793.23 | 18793.76 | 98010.0 |
| 2024-04-30 16:00:00 | NQ | Futures | 18793.23 | 18865.19 | 18696.93 | 18734.38 | 50544.0 |
| 2024-04-30 18:00:00 | NQ | Futures | 18685.16 | 18728.76 | 18675.79 | 18720.47 | 8013.0 |
| 2024-04-30 19:00:00 | NQ | Futures | 18720.2 | 18739.46 | 18705.22 | 18732.77 | 4893.0 |
| 2024-04-30 20:00:00 | NQ | Futures | 18733.84 | 18743.47 | 18725.55 | 18740.26 | 3789.0 |
| 2024-04-30 21:00:00 | NQ | Futures | 18740.26 | 18745.61 | 18724.21 | 18737.05 | 3746.0 |
| 2024-04-30 22:00:00 | NQ | Futures | 18737.85 | 18748.55 | 18726.89 | 18741.87 | 2333.0 |
| 2024-04-30 23:00:00 | NQ | Futures | 18742.67 | 18754.97 | 18742.4 | 18753.1 | 2155.0 |
| 2024-04-30 00:00:00 | YM | Futures | 40906.3 | 40909.5 | 40895.7 | 40898.9 | 253.0 |
| 2024-04-30 01:00:00 | YM | Futures | 40898.9 | 40901.0 | 40867.0 | 40895.7 | 980.0 |
| 2024-04-30 02:00:00 | YM | Futures | 40896.8 | 40933.9 | 40893.6 | 40915.9 | 1559.0 |
| 2024-04-30 03:00:00 | YM | Futures | 40916.9 | 40938.2 | 40896.8 | 40902.1 | 1278.0 |
> showing 50 of 2,076 rows — these rows as CSV