PREVIEW / futures_30min / 2020-01-30
file: by_date/futures_30min/2020/2020-01-30.parquet size: 100 KB rows: 3,622
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 |
|---|---|---|---|---|---|---|---|
| 2020-01-30 00:00:00 | ES | Futures | 3526.7 | 3527.5 | 3522.9 | 3525.6 | 10424.0 |
| 2020-01-30 00:30:00 | ES | Futures | 3525.6 | 3530.5 | 3523.7 | 3527.5 | 10517.0 |
| 2020-01-30 01:00:00 | ES | Futures | 3527.8 | 3529.4 | 3525.9 | 3527.5 | 6939.0 |
| 2020-01-30 01:30:00 | ES | Futures | 3527.2 | 3527.5 | 3524.0 | 3524.5 | 6464.0 |
| 2020-01-30 02:00:00 | ES | Futures | 3524.2 | 3526.4 | 3514.5 | 3515.8 | 33977.0 |
| 2020-01-30 02:30:00 | ES | Futures | 3515.8 | 3520.2 | 3511.8 | 3517.2 | 23836.0 |
| 2020-01-30 03:00:00 | ES | Futures | 3517.5 | 3522.9 | 3513.4 | 3519.9 | 33939.0 |
| 2020-01-30 03:30:00 | ES | Futures | 3519.9 | 3523.4 | 3517.2 | 3522.9 | 19737.0 |
| 2020-01-30 04:00:00 | ES | Futures | 3522.6 | 3532.4 | 3520.7 | 3529.4 | 34580.0 |
| 2020-01-30 04:30:00 | ES | Futures | 3529.6 | 3529.9 | 3524.5 | 3526.7 | 13519.0 |
| 2020-01-30 05:00:00 | ES | Futures | 3526.7 | 3527.5 | 3523.1 | 3523.7 | 15116.0 |
| 2020-01-30 05:30:00 | ES | Futures | 3523.7 | 3526.9 | 3522.3 | 3523.7 | 12994.0 |
| 2020-01-30 06:00:00 | ES | Futures | 3523.7 | 3524.5 | 3515.0 | 3519.1 | 21230.0 |
| 2020-01-30 06:30:00 | ES | Futures | 3519.1 | 3523.4 | 3518.0 | 3521.8 | 15191.0 |
| 2020-01-30 07:00:00 | ES | Futures | 3522.1 | 3523.7 | 3519.1 | 3519.4 | 18751.0 |
| 2020-01-30 07:30:00 | ES | Futures | 3519.1 | 3521.5 | 3516.9 | 3518.3 | 17823.0 |
| 2020-01-30 08:00:00 | ES | Futures | 3518.3 | 3525.3 | 3515.8 | 3522.9 | 29560.0 |
| 2020-01-30 08:30:00 | ES | Futures | 3522.6 | 3530.2 | 3520.7 | 3524.5 | 41263.0 |
| 2020-01-30 09:00:00 | ES | Futures | 3524.5 | 3529.4 | 3521.2 | 3521.5 | 31773.0 |
| 2020-01-30 09:30:00 | ES | Futures | 3521.8 | 3538.9 | 3521.2 | 3531.3 | 232228.0 |
| 2020-01-30 10:00:00 | ES | Futures | 3531.3 | 3538.6 | 3528.3 | 3531.5 | 123744.0 |
| 2020-01-30 10:30:00 | ES | Futures | 3531.5 | 3531.8 | 3513.1 | 3515.0 | 159048.0 |
| 2020-01-30 11:00:00 | ES | Futures | 3515.0 | 3530.2 | 3514.2 | 3528.3 | 128296.0 |
| 2020-01-30 11:30:00 | ES | Futures | 3528.3 | 3536.7 | 3526.1 | 3530.7 | 122389.0 |
| 2020-01-30 12:00:00 | ES | Futures | 3530.7 | 3532.9 | 3524.0 | 3524.2 | 67948.0 |
| 2020-01-30 12:30:00 | ES | Futures | 3524.0 | 3525.9 | 3516.4 | 3521.0 | 132830.0 |
| 2020-01-30 13:00:00 | ES | Futures | 3521.0 | 3524.2 | 3518.5 | 3522.9 | 49721.0 |
| 2020-01-30 13:30:00 | ES | Futures | 3522.9 | 3525.9 | 3520.7 | 3524.0 | 46137.0 |
| 2020-01-30 14:00:00 | ES | Futures | 3524.0 | 3532.4 | 3522.9 | 3530.5 | 66025.0 |
| 2020-01-30 14:30:00 | ES | Futures | 3530.5 | 3541.6 | 3525.6 | 3538.6 | 227601.0 |
| 2020-01-30 15:00:00 | ES | Futures | 3538.6 | 3547.5 | 3537.0 | 3544.6 | 142060.0 |
| 2020-01-30 15:30:00 | ES | Futures | 3544.3 | 3561.1 | 3543.7 | 3558.4 | 219287.0 |
| 2020-01-30 16:00:00 | ES | Futures | 3558.4 | 3568.4 | 3557.3 | 3566.8 | 104739.0 |
| 2020-01-30 16:30:00 | ES | Futures | 3567.3 | 3571.9 | 3566.8 | 3570.8 | 17209.0 |
| 2020-01-30 18:00:00 | ES | Futures | 3568.4 | 3568.9 | 3564.9 | 3566.8 | 11237.0 |
| 2020-01-30 18:30:00 | ES | Futures | 3566.8 | 3568.4 | 3565.1 | 3565.4 | 7345.0 |
| 2020-01-30 19:00:00 | ES | Futures | 3565.7 | 3567.3 | 3560.5 | 3561.4 | 11749.0 |
| 2020-01-30 19:30:00 | ES | Futures | 3561.4 | 3568.9 | 3561.4 | 3568.7 | 13016.0 |
| 2020-01-30 20:00:00 | ES | Futures | 3568.7 | 3574.4 | 3567.0 | 3572.7 | 17978.0 |
| 2020-01-30 20:30:00 | ES | Futures | 3573.0 | 3573.5 | 3563.8 | 3564.1 | 14306.0 |
| 2020-01-30 21:00:00 | ES | Futures | 3564.1 | 3573.3 | 3563.8 | 3571.4 | 12560.0 |
| 2020-01-30 21:30:00 | ES | Futures | 3571.7 | 3572.7 | 3568.9 | 3569.8 | 6825.0 |
| 2020-01-30 22:00:00 | ES | Futures | 3570.0 | 3571.1 | 3567.3 | 3568.7 | 5046.0 |
| 2020-01-30 22:30:00 | ES | Futures | 3568.9 | 3570.6 | 3568.4 | 3569.2 | 2723.0 |
| 2020-01-30 23:00:00 | ES | Futures | 3568.9 | 3569.8 | 3567.9 | 3568.4 | 2640.0 |
| 2020-01-30 23:30:00 | ES | Futures | 3568.4 | 3571.7 | 3568.4 | 3571.7 | 2927.0 |
| 2020-01-30 00:00:00 | NQ | Futures | 10477.9 | 10480.22 | 10459.98 | 10471.25 | 5228.0 |
| 2020-01-30 00:30:00 | NQ | Futures | 10471.25 | 10489.47 | 10463.73 | 10479.06 | 5800.0 |
| 2020-01-30 01:00:00 | NQ | Futures | 10479.06 | 10483.98 | 10472.41 | 10474.72 | 3648.0 |
| 2020-01-30 01:30:00 | NQ | Futures | 10474.43 | 10475.88 | 10461.42 | 10465.47 | 3422.0 |
> showing 50 of 3,622 rows — these rows as CSV