PREVIEW / futures_30min / 2021-04-22
file: by_date/futures_30min/2021/2021-04-22.parquet size: 100 KB rows: 3,620
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 |
|---|---|---|---|---|---|---|---|
| 2021-04-22 00:00:00 | ES | Futures | 4674.49 | 4675.33 | 4673.08 | 4673.92 | 1561.0 |
| 2021-04-22 00:30:00 | ES | Futures | 4673.92 | 4677.3 | 4672.8 | 4677.3 | 2912.0 |
| 2021-04-22 01:00:00 | ES | Futures | 4677.3 | 4677.58 | 4674.49 | 4677.02 | 2998.0 |
| 2021-04-22 01:30:00 | ES | Futures | 4677.3 | 4679.54 | 4675.05 | 4679.26 | 4253.0 |
| 2021-04-22 02:00:00 | ES | Futures | 4679.26 | 4683.2 | 4678.42 | 4679.83 | 7278.0 |
| 2021-04-22 02:30:00 | ES | Futures | 4680.11 | 4680.39 | 4677.3 | 4677.58 | 3519.0 |
| 2021-04-22 03:00:00 | ES | Futures | 4677.58 | 4680.95 | 4675.61 | 4680.11 | 7494.0 |
| 2021-04-22 03:30:00 | ES | Futures | 4679.83 | 4681.23 | 4676.17 | 4676.17 | 6625.0 |
| 2021-04-22 04:00:00 | ES | Futures | 4676.17 | 4679.26 | 4675.05 | 4678.42 | 5627.0 |
| 2021-04-22 04:30:00 | ES | Futures | 4678.42 | 4680.95 | 4675.33 | 4675.61 | 5497.0 |
| 2021-04-22 05:00:00 | ES | Futures | 4675.89 | 4677.86 | 4674.49 | 4677.3 | 3701.0 |
| 2021-04-22 05:30:00 | ES | Futures | 4677.3 | 4679.26 | 4675.05 | 4678.98 | 3795.0 |
| 2021-04-22 06:00:00 | ES | Futures | 4678.7 | 4679.54 | 4673.92 | 4675.89 | 5224.0 |
| 2021-04-22 06:30:00 | ES | Futures | 4675.89 | 4678.42 | 4673.36 | 4675.33 | 4340.0 |
| 2021-04-22 07:00:00 | ES | Futures | 4675.05 | 4677.3 | 4673.64 | 4675.33 | 6480.0 |
| 2021-04-22 07:30:00 | ES | Futures | 4675.61 | 4676.17 | 4673.64 | 4675.05 | 6362.0 |
| 2021-04-22 08:00:00 | ES | Futures | 4674.77 | 4679.54 | 4674.21 | 4677.3 | 9601.0 |
| 2021-04-22 08:30:00 | ES | Futures | 4677.58 | 4682.07 | 4676.17 | 4678.14 | 14522.0 |
| 2021-04-22 09:00:00 | ES | Futures | 4678.14 | 4682.07 | 4677.3 | 4678.98 | 21374.0 |
| 2021-04-22 09:30:00 | ES | Futures | 4678.98 | 4679.26 | 4665.21 | 4671.68 | 187696.0 |
| 2021-04-22 10:00:00 | ES | Futures | 4671.4 | 4674.49 | 4663.25 | 4672.24 | 128501.0 |
| 2021-04-22 10:30:00 | ES | Futures | 4672.24 | 4681.79 | 4671.68 | 4678.14 | 97446.0 |
| 2021-04-22 11:00:00 | ES | Futures | 4678.14 | 4682.92 | 4677.58 | 4678.7 | 73584.0 |
| 2021-04-22 11:30:00 | ES | Futures | 4678.7 | 4684.88 | 4676.45 | 4680.67 | 70205.0 |
| 2021-04-22 12:00:00 | ES | Futures | 4680.95 | 4684.32 | 4677.02 | 4684.04 | 52716.0 |
| 2021-04-22 12:30:00 | ES | Futures | 4684.04 | 4688.25 | 4683.76 | 4687.97 | 37738.0 |
| 2021-04-22 13:00:00 | ES | Futures | 4688.25 | 4688.54 | 4647.79 | 4664.93 | 310168.0 |
| 2021-04-22 13:30:00 | ES | Futures | 4664.93 | 4666.06 | 4628.97 | 4632.62 | 224763.0 |
| 2021-04-22 14:00:00 | ES | Futures | 4632.62 | 4647.23 | 4625.04 | 4646.95 | 157989.0 |
| 2021-04-22 14:30:00 | ES | Futures | 4646.95 | 4651.17 | 4643.3 | 4646.11 | 88975.0 |
| 2021-04-22 15:00:00 | ES | Futures | 4646.11 | 4651.17 | 4632.06 | 4636.84 | 100418.0 |
| 2021-04-22 15:30:00 | ES | Futures | 4636.84 | 4646.95 | 4635.43 | 4638.52 | 176628.0 |
| 2021-04-22 16:00:00 | ES | Futures | 4638.52 | 4641.05 | 4634.87 | 4640.49 | 43370.0 |
| 2021-04-22 16:30:00 | ES | Futures | 4639.37 | 4641.89 | 4638.24 | 4641.61 | 5869.0 |
| 2021-04-22 18:00:00 | ES | Futures | 4640.49 | 4644.42 | 4639.93 | 4640.49 | 4434.0 |
| 2021-04-22 18:30:00 | ES | Futures | 4640.77 | 4644.42 | 4640.49 | 4643.58 | 2729.0 |
| 2021-04-22 19:00:00 | ES | Futures | 4643.58 | 4644.42 | 4642.46 | 4643.86 | 1837.0 |
| 2021-04-22 19:30:00 | ES | Futures | 4644.14 | 4644.14 | 4639.37 | 4641.33 | 4932.0 |
| 2021-04-22 20:00:00 | ES | Futures | 4641.61 | 4645.83 | 4639.37 | 4645.55 | 7685.0 |
| 2021-04-22 20:30:00 | ES | Futures | 4645.27 | 4645.55 | 4642.18 | 4644.98 | 3338.0 |
| 2021-04-22 21:00:00 | ES | Futures | 4644.7 | 4646.95 | 4643.3 | 4645.83 | 4687.0 |
| 2021-04-22 21:30:00 | ES | Futures | 4645.83 | 4649.48 | 4643.3 | 4647.79 | 7336.0 |
| 2021-04-22 22:00:00 | ES | Futures | 4647.79 | 4649.48 | 4646.67 | 4646.95 | 3272.0 |
| 2021-04-22 22:30:00 | ES | Futures | 4646.95 | 4648.08 | 4645.27 | 4647.23 | 2762.0 |
| 2021-04-22 23:00:00 | ES | Futures | 4647.51 | 4650.32 | 4647.23 | 4649.76 | 3809.0 |
| 2021-04-22 23:30:00 | ES | Futures | 4650.04 | 4650.32 | 4647.51 | 4648.36 | 1877.0 |
| 2021-04-22 00:00:00 | NQ | Futures | 16099.12 | 16102.02 | 16092.17 | 16096.23 | 676.0 |
| 2021-04-22 00:30:00 | NQ | Futures | 16095.94 | 16107.52 | 16087.25 | 16106.65 | 1562.0 |
| 2021-04-22 01:00:00 | NQ | Futures | 16106.94 | 16107.23 | 16093.62 | 16102.89 | 1234.0 |
| 2021-04-22 01:30:00 | NQ | Futures | 16102.89 | 16119.97 | 16095.07 | 16117.36 | 2114.0 |
> showing 50 of 3,620 rows — these rows as CSV