PREVIEW / futures_30min / 2020-07-30
file: by_date/futures_30min/2020/2020-07-30.parquet size: 101 KB rows: 3,483
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-07-30 00:00:00 | ES | Futures | 3628.49 | 3629.33 | 3625.14 | 3626.81 | 2337.0 |
| 2020-07-30 00:30:00 | ES | Futures | 3626.81 | 3627.93 | 3626.26 | 3626.26 | 1176.0 |
| 2020-07-30 01:00:00 | ES | Futures | 3626.54 | 3626.54 | 3622.63 | 3623.46 | 3579.0 |
| 2020-07-30 01:30:00 | ES | Futures | 3623.46 | 3625.7 | 3621.79 | 3624.86 | 3484.0 |
| 2020-07-30 02:00:00 | ES | Futures | 3624.86 | 3627.09 | 3621.51 | 3623.18 | 7536.0 |
| 2020-07-30 02:30:00 | ES | Futures | 3623.18 | 3624.3 | 3618.44 | 3618.44 | 4919.0 |
| 2020-07-30 03:00:00 | ES | Futures | 3618.44 | 3619.28 | 3607.83 | 3608.94 | 30881.0 |
| 2020-07-30 03:30:00 | ES | Futures | 3608.94 | 3609.22 | 3600.29 | 3604.75 | 19212.0 |
| 2020-07-30 04:00:00 | ES | Futures | 3604.75 | 3606.99 | 3599.45 | 3600.29 | 11627.0 |
| 2020-07-30 04:30:00 | ES | Futures | 3600.57 | 3602.24 | 3592.19 | 3593.58 | 18837.0 |
| 2020-07-30 05:00:00 | ES | Futures | 3593.58 | 3601.96 | 3591.35 | 3600.57 | 26810.0 |
| 2020-07-30 05:30:00 | ES | Futures | 3600.57 | 3607.55 | 3600.57 | 3601.68 | 16199.0 |
| 2020-07-30 06:00:00 | ES | Futures | 3601.96 | 3603.92 | 3597.77 | 3600.01 | 10497.0 |
| 2020-07-30 06:30:00 | ES | Futures | 3599.73 | 3600.85 | 3586.32 | 3591.63 | 16304.0 |
| 2020-07-30 07:00:00 | ES | Futures | 3591.91 | 3600.29 | 3591.07 | 3597.21 | 17476.0 |
| 2020-07-30 07:30:00 | ES | Futures | 3597.49 | 3606.43 | 3597.21 | 3605.31 | 13155.0 |
| 2020-07-30 08:00:00 | ES | Futures | 3605.31 | 3605.87 | 3601.12 | 3604.75 | 15503.0 |
| 2020-07-30 08:30:00 | ES | Futures | 3604.75 | 3607.27 | 3588.28 | 3588.28 | 44170.0 |
| 2020-07-30 09:00:00 | ES | Futures | 3588.28 | 3595.82 | 3582.97 | 3594.7 | 43767.0 |
| 2020-07-30 09:30:00 | ES | Futures | 3594.7 | 3600.57 | 3572.92 | 3574.6 | 151560.0 |
| 2020-07-30 10:00:00 | ES | Futures | 3574.6 | 3584.09 | 3568.73 | 3581.86 | 150470.0 |
| 2020-07-30 10:30:00 | ES | Futures | 3581.86 | 3591.35 | 3578.78 | 3588.84 | 110074.0 |
| 2020-07-30 11:00:00 | ES | Futures | 3588.84 | 3601.96 | 3585.49 | 3596.1 | 109936.0 |
| 2020-07-30 11:30:00 | ES | Futures | 3596.1 | 3606.71 | 3594.42 | 3603.92 | 71809.0 |
| 2020-07-30 12:00:00 | ES | Futures | 3603.64 | 3617.6 | 3599.73 | 3611.18 | 104221.0 |
| 2020-07-30 12:30:00 | ES | Futures | 3611.18 | 3614.53 | 3610.06 | 3613.13 | 54742.0 |
| 2020-07-30 13:00:00 | ES | Futures | 3613.13 | 3622.63 | 3612.01 | 3615.09 | 62261.0 |
| 2020-07-30 13:30:00 | ES | Futures | 3615.09 | 3615.92 | 3608.38 | 3614.81 | 100118.0 |
| 2020-07-30 14:00:00 | ES | Futures | 3615.09 | 3617.6 | 3608.38 | 3612.29 | 153471.0 |
| 2020-07-30 14:30:00 | ES | Futures | 3612.01 | 3621.79 | 3612.01 | 3617.32 | 138345.0 |
| 2020-07-30 15:00:00 | ES | Futures | 3617.32 | 3621.23 | 3611.18 | 3620.95 | 234030.0 |
| 2020-07-30 15:30:00 | ES | Futures | 3620.67 | 3623.18 | 3613.41 | 3617.88 | 102827.0 |
| 2020-07-30 16:00:00 | ES | Futures | 3617.88 | 3632.96 | 3613.69 | 3628.77 | 52140.0 |
| 2020-07-30 16:30:00 | ES | Futures | 3632.12 | 3651.39 | 3631.56 | 3649.99 | 32860.0 |
| 2020-07-30 18:00:00 | ES | Futures | 3651.67 | 3656.69 | 3645.52 | 3646.36 | 9923.0 |
| 2020-07-30 18:30:00 | ES | Futures | 3646.36 | 3647.76 | 3642.73 | 3646.64 | 4628.0 |
| 2020-07-30 19:00:00 | ES | Futures | 3646.92 | 3650.83 | 3645.52 | 3650.27 | 5830.0 |
| 2020-07-30 19:30:00 | ES | Futures | 3650.55 | 3652.51 | 3648.04 | 3649.71 | 6431.0 |
| 2020-07-30 20:00:00 | ES | Futures | 3649.43 | 3652.78 | 3640.78 | 3642.17 | 13868.0 |
| 2020-07-30 20:30:00 | ES | Futures | 3642.17 | 3643.57 | 3638.54 | 3638.54 | 9645.0 |
| 2020-07-30 21:00:00 | ES | Futures | 3638.54 | 3646.64 | 3636.31 | 3645.8 | 12432.0 |
| 2020-07-30 21:30:00 | ES | Futures | 3645.8 | 3651.95 | 3644.97 | 3650.27 | 7239.0 |
| 2020-07-30 22:00:00 | ES | Futures | 3650.27 | 3650.55 | 3643.29 | 3645.52 | 8171.0 |
| 2020-07-30 22:30:00 | ES | Futures | 3645.52 | 3645.52 | 3638.26 | 3638.54 | 7700.0 |
| 2020-07-30 23:00:00 | ES | Futures | 3638.82 | 3643.01 | 3637.71 | 3641.61 | 4654.0 |
| 2020-07-30 23:30:00 | ES | Futures | 3641.61 | 3643.29 | 3638.54 | 3640.78 | 4576.0 |
| 2020-07-30 00:00:00 | NQ | Futures | 12347.35 | 12351.39 | 12326.52 | 12335.2 | 1963.0 |
| 2020-07-30 00:30:00 | NQ | Futures | 12334.91 | 12342.43 | 12333.18 | 12334.04 | 962.0 |
| 2020-07-30 01:00:00 | NQ | Futures | 12334.91 | 12337.22 | 12321.61 | 12324.5 | 1631.0 |
| 2020-07-30 01:30:00 | NQ | Futures | 12324.5 | 12333.18 | 12314.09 | 12328.26 | 1860.0 |
> showing 50 of 3,483 rows — these rows as CSV