PREVIEW / futures_1hour / 2023-05-22
file: by_date/futures_1hour/2023/2023-05-22.parquet size: 64 KB rows: 1,994
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 |
|---|---|---|---|---|---|---|---|
| 2023-05-22 00:00:00 | ES | Futures | 4663.7 | 4665.92 | 4662.87 | 4664.53 | 4680.0 |
| 2023-05-22 01:00:00 | ES | Futures | 4664.53 | 4665.08 | 4661.48 | 4662.31 | 4142.0 |
| 2023-05-22 02:00:00 | ES | Futures | 4662.31 | 4663.7 | 4658.43 | 4659.81 | 6804.0 |
| 2023-05-22 03:00:00 | ES | Futures | 4659.81 | 4663.97 | 4655.93 | 4662.87 | 15387.0 |
| 2023-05-22 04:00:00 | ES | Futures | 4663.14 | 4666.47 | 4660.65 | 4665.08 | 9159.0 |
| 2023-05-22 05:00:00 | ES | Futures | 4665.08 | 4665.92 | 4661.48 | 4661.76 | 8207.0 |
| 2023-05-22 06:00:00 | ES | Futures | 4661.76 | 4665.08 | 4658.98 | 4661.76 | 8696.0 |
| 2023-05-22 07:00:00 | ES | Futures | 4661.48 | 4667.58 | 4657.6 | 4667.3 | 13869.0 |
| 2023-05-22 08:00:00 | ES | Futures | 4667.03 | 4671.19 | 4665.08 | 4667.3 | 25566.0 |
| 2023-05-22 09:00:00 | ES | Futures | 4667.3 | 4683.67 | 4663.7 | 4668.97 | 171404.0 |
| 2023-05-22 10:00:00 | ES | Futures | 4668.97 | 4672.57 | 4649.55 | 4666.19 | 289113.0 |
| 2023-05-22 11:00:00 | ES | Futures | 4666.19 | 4673.68 | 4664.53 | 4671.19 | 124008.0 |
| 2023-05-22 12:00:00 | ES | Futures | 4671.19 | 4673.4 | 4665.36 | 4669.24 | 76740.0 |
| 2023-05-22 13:00:00 | ES | Futures | 4669.24 | 4673.68 | 4659.81 | 4670.08 | 120727.0 |
| 2023-05-22 14:00:00 | ES | Futures | 4670.08 | 4682.0 | 4669.24 | 4676.73 | 99200.0 |
| 2023-05-22 15:00:00 | ES | Futures | 4676.73 | 4678.95 | 4661.48 | 4665.92 | 186782.0 |
| 2023-05-22 16:00:00 | ES | Futures | 4665.64 | 4668.69 | 4664.53 | 4668.13 | 52734.0 |
| 2023-05-22 18:00:00 | ES | Futures | 4667.86 | 4669.8 | 4666.19 | 4669.24 | 2709.0 |
| 2023-05-22 19:00:00 | ES | Futures | 4669.52 | 4678.67 | 4667.58 | 4678.12 | 12928.0 |
| 2023-05-22 20:00:00 | ES | Futures | 4678.12 | 4680.62 | 4677.01 | 4678.67 | 7745.0 |
| 2023-05-22 21:00:00 | ES | Futures | 4678.4 | 4684.78 | 4677.29 | 4680.06 | 11847.0 |
| 2023-05-22 22:00:00 | ES | Futures | 4680.06 | 4680.62 | 4675.62 | 4677.01 | 7513.0 |
| 2023-05-22 23:00:00 | ES | Futures | 4677.29 | 4677.29 | 4671.19 | 4673.96 | 7338.0 |
| 2023-05-22 00:00:00 | NQ | Futures | 15622.25 | 15630.98 | 15619.72 | 15625.63 | 2867.0 |
| 2023-05-22 01:00:00 | NQ | Futures | 15625.35 | 15626.19 | 15612.4 | 15614.37 | 2595.0 |
| 2023-05-22 02:00:00 | NQ | Futures | 15614.37 | 15621.97 | 15604.51 | 15612.4 | 3723.0 |
| 2023-05-22 03:00:00 | NQ | Futures | 15612.11 | 15627.04 | 15601.98 | 15625.91 | 6368.0 |
| 2023-05-22 04:00:00 | NQ | Futures | 15625.91 | 15625.91 | 15606.77 | 15612.11 | 5324.0 |
| 2023-05-22 05:00:00 | NQ | Futures | 15611.83 | 15614.65 | 15583.11 | 15585.65 | 5795.0 |
| 2023-05-22 06:00:00 | NQ | Futures | 15585.37 | 15597.19 | 15577.2 | 15588.46 | 5819.0 |
| 2023-05-22 07:00:00 | NQ | Futures | 15588.46 | 15607.05 | 15569.32 | 15606.77 | 7691.0 |
| 2023-05-22 08:00:00 | NQ | Futures | 15606.2 | 15619.44 | 15595.5 | 15604.79 | 12918.0 |
| 2023-05-22 09:00:00 | NQ | Futures | 15604.79 | 15707.0 | 15592.12 | 15687.29 | 98875.0 |
| 2023-05-22 10:00:00 | NQ | Futures | 15687.29 | 15697.43 | 15611.83 | 15665.61 | 105670.0 |
| 2023-05-22 11:00:00 | NQ | Futures | 15666.17 | 15683.91 | 15634.08 | 15647.03 | 53031.0 |
| 2023-05-22 12:00:00 | NQ | Futures | 15647.03 | 15668.14 | 15625.91 | 15651.53 | 36907.0 |
| 2023-05-22 13:00:00 | NQ | Futures | 15651.53 | 15681.94 | 15620.84 | 15658.57 | 48634.0 |
| 2023-05-22 14:00:00 | NQ | Futures | 15658.85 | 15702.49 | 15654.91 | 15679.12 | 37796.0 |
| 2023-05-22 15:00:00 | NQ | Futures | 15679.41 | 15686.16 | 15636.61 | 15660.26 | 59523.0 |
| 2023-05-22 16:00:00 | NQ | Futures | 15660.26 | 15676.03 | 15654.63 | 15671.8 | 15752.0 |
| 2023-05-22 18:00:00 | NQ | Futures | 15669.27 | 15679.97 | 15667.3 | 15674.62 | 1699.0 |
| 2023-05-22 19:00:00 | NQ | Futures | 15674.34 | 15712.63 | 15668.14 | 15702.49 | 6654.0 |
| 2023-05-22 20:00:00 | NQ | Futures | 15702.21 | 15714.88 | 15699.68 | 15705.03 | 4064.0 |
| 2023-05-22 21:00:00 | NQ | Futures | 15704.75 | 15743.6 | 15701.65 | 15721.08 | 7600.0 |
| 2023-05-22 22:00:00 | NQ | Futures | 15721.64 | 15723.33 | 15707.0 | 15713.19 | 3354.0 |
| 2023-05-22 23:00:00 | NQ | Futures | 15712.91 | 15713.19 | 15688.13 | 15695.45 | 3880.0 |
| 2023-05-22 00:00:00 | YM | Futures | 36999.1 | 37010.1 | 36991.4 | 36999.1 | 637.0 |
| 2023-05-22 01:00:00 | YM | Futures | 36999.1 | 37006.8 | 36981.4 | 36986.9 | 785.0 |
| 2023-05-22 02:00:00 | YM | Futures | 36988.0 | 36993.6 | 36960.4 | 36962.6 | 1211.0 |
| 2023-05-22 03:00:00 | YM | Futures | 36964.8 | 36996.9 | 36935.0 | 36990.3 | 2166.0 |
> showing 50 of 1,994 rows — these rows as CSV