PREVIEW / futures_1hour / 2024-01-30
file: by_date/futures_1hour/2024/2024-01-30.parquet size: 67 KB rows: 2,099
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-01-30 00:00:00 | ES | Futures | 5321.05 | 5324.27 | 5320.78 | 5322.39 | 3773.0 |
| 2024-01-30 01:00:00 | ES | Futures | 5322.66 | 5323.47 | 5319.17 | 5319.17 | 4871.0 |
| 2024-01-30 02:00:00 | ES | Futures | 5319.44 | 5319.44 | 5313.8 | 5317.29 | 8984.0 |
| 2024-01-30 03:00:00 | ES | Futures | 5317.29 | 5321.85 | 5315.14 | 5321.05 | 17384.0 |
| 2024-01-30 04:00:00 | ES | Futures | 5320.78 | 5322.12 | 5315.41 | 5317.56 | 9948.0 |
| 2024-01-30 05:00:00 | ES | Futures | 5317.56 | 5320.78 | 5316.75 | 5317.83 | 7563.0 |
| 2024-01-30 06:00:00 | ES | Futures | 5317.83 | 5318.09 | 5314.07 | 5317.02 | 10778.0 |
| 2024-01-30 07:00:00 | ES | Futures | 5317.29 | 5318.36 | 5312.99 | 5314.33 | 12091.0 |
| 2024-01-30 08:00:00 | ES | Futures | 5314.6 | 5315.14 | 5308.16 | 5310.84 | 24234.0 |
| 2024-01-30 09:00:00 | ES | Futures | 5311.11 | 5322.12 | 5309.5 | 5321.59 | 116511.0 |
| 2024-01-30 10:00:00 | ES | Futures | 5322.12 | 5322.39 | 5311.65 | 5315.14 | 187951.0 |
| 2024-01-30 11:00:00 | ES | Futures | 5315.14 | 5324.27 | 5312.99 | 5322.39 | 102070.0 |
| 2024-01-30 12:00:00 | ES | Futures | 5322.66 | 5324.27 | 5308.96 | 5312.18 | 113541.0 |
| 2024-01-30 13:00:00 | ES | Futures | 5312.18 | 5319.44 | 5309.5 | 5316.21 | 84608.0 |
| 2024-01-30 14:00:00 | ES | Futures | 5316.21 | 5324.27 | 5312.99 | 5322.93 | 85306.0 |
| 2024-01-30 15:00:00 | ES | Futures | 5323.2 | 5325.88 | 5315.95 | 5317.29 | 159792.0 |
| 2024-01-30 16:00:00 | ES | Futures | 5317.56 | 5320.24 | 5299.83 | 5300.37 | 99190.0 |
| 2024-01-30 18:00:00 | ES | Futures | 5296.88 | 5300.9 | 5293.38 | 5296.34 | 16163.0 |
| 2024-01-30 19:00:00 | ES | Futures | 5296.34 | 5301.17 | 5296.34 | 5299.83 | 6459.0 |
| 2024-01-30 20:00:00 | ES | Futures | 5299.83 | 5300.37 | 5296.34 | 5296.88 | 5159.0 |
| 2024-01-30 21:00:00 | ES | Futures | 5296.61 | 5297.95 | 5295.8 | 5296.88 | 5267.0 |
| 2024-01-30 22:00:00 | ES | Futures | 5297.14 | 5297.95 | 5296.34 | 5296.61 | 3174.0 |
| 2024-01-30 23:00:00 | ES | Futures | 5296.88 | 5299.56 | 5296.61 | 5299.02 | 2613.0 |
| 2024-01-30 00:00:00 | NQ | Futures | 19214.92 | 19232.55 | 19213.56 | 19226.58 | 2759.0 |
| 2024-01-30 01:00:00 | NQ | Futures | 19226.85 | 19232.0 | 19202.17 | 19207.6 | 4179.0 |
| 2024-01-30 02:00:00 | NQ | Futures | 19207.6 | 19208.95 | 19175.32 | 19191.87 | 7158.0 |
| 2024-01-30 03:00:00 | NQ | Futures | 19191.32 | 19223.87 | 19163.93 | 19220.61 | 11760.0 |
| 2024-01-30 04:00:00 | NQ | Futures | 19220.07 | 19224.41 | 19184.54 | 19192.14 | 9438.0 |
| 2024-01-30 05:00:00 | NQ | Futures | 19192.41 | 19214.92 | 19188.88 | 19200.27 | 5423.0 |
| 2024-01-30 06:00:00 | NQ | Futures | 19200.27 | 19207.87 | 19183.19 | 19200.54 | 6014.0 |
| 2024-01-30 07:00:00 | NQ | Futures | 19200.82 | 19204.34 | 19176.95 | 19180.2 | 7988.0 |
| 2024-01-30 08:00:00 | NQ | Futures | 19179.93 | 19184.54 | 19150.37 | 19159.05 | 15269.0 |
| 2024-01-30 09:00:00 | NQ | Futures | 19158.78 | 19184.81 | 19141.96 | 19168.0 | 59974.0 |
| 2024-01-30 10:00:00 | NQ | Futures | 19168.0 | 19171.25 | 19110.77 | 19135.45 | 98898.0 |
| 2024-01-30 11:00:00 | NQ | Futures | 19135.73 | 19152.27 | 19120.27 | 19136.27 | 48283.0 |
| 2024-01-30 12:00:00 | NQ | Futures | 19136.27 | 19144.4 | 19052.74 | 19064.13 | 57914.0 |
| 2024-01-30 13:00:00 | NQ | Futures | 19064.13 | 19095.04 | 19043.52 | 19061.14 | 43498.0 |
| 2024-01-30 14:00:00 | NQ | Futures | 19061.42 | 19094.5 | 19036.74 | 19082.03 | 41691.0 |
| 2024-01-30 15:00:00 | NQ | Futures | 19082.3 | 19102.1 | 19067.11 | 19075.25 | 57156.0 |
| 2024-01-30 16:00:00 | NQ | Futures | 19075.52 | 19101.55 | 18948.59 | 18952.12 | 45476.0 |
| 2024-01-30 18:00:00 | NQ | Futures | 18892.73 | 18943.17 | 18886.76 | 18928.25 | 12361.0 |
| 2024-01-30 19:00:00 | NQ | Futures | 18927.98 | 18941.81 | 18922.56 | 18926.36 | 4406.0 |
| 2024-01-30 20:00:00 | NQ | Futures | 18926.9 | 18932.86 | 18907.37 | 18911.17 | 3904.0 |
| 2024-01-30 21:00:00 | NQ | Futures | 18911.17 | 18921.2 | 18902.22 | 18919.03 | 3974.0 |
| 2024-01-30 22:00:00 | NQ | Futures | 18919.03 | 18926.08 | 18911.71 | 18917.13 | 2408.0 |
| 2024-01-30 23:00:00 | NQ | Futures | 18917.41 | 18932.32 | 18916.32 | 18929.61 | 2537.0 |
| 2024-01-30 00:00:00 | YM | Futures | 41279.0 | 41299.4 | 41274.7 | 41286.5 | 668.0 |
| 2024-01-30 01:00:00 | YM | Futures | 41287.5 | 41295.1 | 41273.6 | 41274.7 | 669.0 |
| 2024-01-30 02:00:00 | YM | Futures | 41274.7 | 41277.9 | 41245.7 | 41275.7 | 1514.0 |
| 2024-01-30 03:00:00 | YM | Futures | 41274.7 | 41297.2 | 41262.8 | 41285.4 | 2206.0 |
> showing 50 of 2,099 rows — these rows as CSV