PREVIEW / futures_30min / 2023-04-18
file: by_date/futures_30min/2023/2023-04-18.parquet size: 104 KB rows: 3,854
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-04-18 00:00:00 | ES | Futures | 4631.25 | 4632.36 | 4630.97 | 4631.52 | 1169.0 |
| 2023-04-18 00:30:00 | ES | Futures | 4631.52 | 4631.52 | 4628.47 | 4629.86 | 2344.0 |
| 2023-04-18 01:00:00 | ES | Futures | 4629.86 | 4632.63 | 4629.58 | 4631.25 | 2071.0 |
| 2023-04-18 01:30:00 | ES | Futures | 4631.52 | 4634.85 | 4631.25 | 4634.58 | 2727.0 |
| 2023-04-18 02:00:00 | ES | Futures | 4634.58 | 4639.01 | 4633.19 | 4635.41 | 5663.0 |
| 2023-04-18 02:30:00 | ES | Futures | 4635.68 | 4638.18 | 4635.13 | 4636.52 | 2149.0 |
| 2023-04-18 03:00:00 | ES | Futures | 4636.79 | 4638.18 | 4635.41 | 4637.63 | 7608.0 |
| 2023-04-18 03:30:00 | ES | Futures | 4637.63 | 4638.46 | 4634.3 | 4636.52 | 4710.0 |
| 2023-04-18 04:00:00 | ES | Futures | 4636.52 | 4640.95 | 4635.96 | 4639.01 | 7990.0 |
| 2023-04-18 04:30:00 | ES | Futures | 4639.01 | 4645.67 | 4639.01 | 4643.45 | 7672.0 |
| 2023-04-18 05:00:00 | ES | Futures | 4643.73 | 4649.0 | 4642.34 | 4646.22 | 7614.0 |
| 2023-04-18 05:30:00 | ES | Futures | 4646.22 | 4652.05 | 4646.22 | 4649.27 | 9184.0 |
| 2023-04-18 06:00:00 | ES | Futures | 4649.55 | 4650.38 | 4647.61 | 4650.38 | 4929.0 |
| 2023-04-18 06:30:00 | ES | Futures | 4650.11 | 4655.38 | 4650.11 | 4653.99 | 9925.0 |
| 2023-04-18 07:00:00 | ES | Futures | 4653.99 | 4654.54 | 4650.11 | 4650.38 | 10336.0 |
| 2023-04-18 07:30:00 | ES | Futures | 4650.38 | 4654.54 | 4650.11 | 4651.49 | 11641.0 |
| 2023-04-18 08:00:00 | ES | Futures | 4651.49 | 4655.93 | 4651.22 | 4654.27 | 12454.0 |
| 2023-04-18 08:30:00 | ES | Futures | 4654.27 | 4657.6 | 4653.99 | 4654.54 | 15257.0 |
| 2023-04-18 09:00:00 | ES | Futures | 4654.82 | 4655.1 | 4650.38 | 4652.33 | 21601.0 |
| 2023-04-18 09:30:00 | ES | Futures | 4652.33 | 4653.71 | 4639.84 | 4641.79 | 155525.0 |
| 2023-04-18 10:00:00 | ES | Futures | 4642.06 | 4642.34 | 4626.81 | 4628.2 | 173877.0 |
| 2023-04-18 10:30:00 | ES | Futures | 4628.47 | 4632.08 | 4621.82 | 4626.25 | 112808.0 |
| 2023-04-18 11:00:00 | ES | Futures | 4625.98 | 4629.86 | 4622.65 | 4628.47 | 70432.0 |
| 2023-04-18 11:30:00 | ES | Futures | 4628.47 | 4632.08 | 4620.15 | 4625.42 | 77531.0 |
| 2023-04-18 12:00:00 | ES | Futures | 4625.15 | 4635.96 | 4624.04 | 4635.96 | 57066.0 |
| 2023-04-18 12:30:00 | ES | Futures | 4635.96 | 4636.79 | 4629.03 | 4631.52 | 52417.0 |
| 2023-04-18 13:00:00 | ES | Futures | 4631.8 | 4636.52 | 4629.86 | 4630.41 | 49959.0 |
| 2023-04-18 13:30:00 | ES | Futures | 4630.41 | 4639.29 | 4629.03 | 4633.47 | 51990.0 |
| 2023-04-18 14:00:00 | ES | Futures | 4633.74 | 4639.29 | 4630.41 | 4637.07 | 65064.0 |
| 2023-04-18 14:30:00 | ES | Futures | 4637.07 | 4639.57 | 4624.87 | 4631.8 | 74571.0 |
| 2023-04-18 15:00:00 | ES | Futures | 4632.08 | 4638.74 | 4631.8 | 4634.58 | 61595.0 |
| 2023-04-18 15:30:00 | ES | Futures | 4634.85 | 4640.68 | 4632.91 | 4636.79 | 113532.0 |
| 2023-04-18 16:00:00 | ES | Futures | 4636.52 | 4637.9 | 4631.25 | 4636.79 | 58989.0 |
| 2023-04-18 16:30:00 | ES | Futures | 4636.52 | 4638.46 | 4635.68 | 4636.24 | 19135.0 |
| 2023-04-18 18:00:00 | ES | Futures | 4632.91 | 4635.68 | 4632.91 | 4634.85 | 2433.0 |
| 2023-04-18 18:30:00 | ES | Futures | 4634.58 | 4635.68 | 4633.19 | 4635.41 | 1243.0 |
| 2023-04-18 19:00:00 | ES | Futures | 4635.41 | 4635.68 | 4633.19 | 4633.19 | 1286.0 |
| 2023-04-18 19:30:00 | ES | Futures | 4633.19 | 4633.74 | 4632.36 | 4632.91 | 1455.0 |
| 2023-04-18 20:00:00 | ES | Futures | 4632.63 | 4634.58 | 4631.8 | 4633.47 | 3150.0 |
| 2023-04-18 20:30:00 | ES | Futures | 4633.19 | 4634.3 | 4632.36 | 4633.74 | 1609.0 |
| 2023-04-18 21:00:00 | ES | Futures | 4633.74 | 4635.68 | 4632.36 | 4632.63 | 2953.0 |
| 2023-04-18 21:30:00 | ES | Futures | 4632.36 | 4632.36 | 4629.86 | 4630.41 | 4613.0 |
| 2023-04-18 22:00:00 | ES | Futures | 4630.41 | 4631.8 | 4629.31 | 4631.8 | 2819.0 |
| 2023-04-18 22:30:00 | ES | Futures | 4631.8 | 4632.63 | 4631.25 | 4631.52 | 1583.0 |
| 2023-04-18 23:00:00 | ES | Futures | 4631.52 | 4632.08 | 4631.25 | 4631.8 | 1277.0 |
| 2023-04-18 23:30:00 | ES | Futures | 4631.8 | 4632.08 | 4630.69 | 4631.52 | 1100.0 |
| 2023-04-18 00:00:00 | NQ | Futures | 14830.81 | 14833.9 | 14828.55 | 14830.81 | 677.0 |
| 2023-04-18 00:30:00 | NQ | Futures | 14830.81 | 14831.93 | 14821.23 | 14825.46 | 1360.0 |
| 2023-04-18 01:00:00 | NQ | Futures | 14825.46 | 14838.41 | 14824.61 | 14835.03 | 1408.0 |
| 2023-04-18 01:30:00 | NQ | Futures | 14835.87 | 14846.57 | 14834.18 | 14845.16 | 1480.0 |
> showing 50 of 3,854 rows — these rows as CSV