PREVIEW / futures_30min / 2019-06-12
file: by_date/futures_30min/2019/2019-06-12.parquet size: 79 KB rows: 3,093
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 |
|---|---|---|---|---|---|---|---|
| 2019-06-12 00:00:00 | ES | Futures | 3129.6 | 3129.6 | 3128.25 | 3128.25 | 1918.0 |
| 2019-06-12 00:30:00 | ES | Futures | 3128.52 | 3129.06 | 3128.25 | 3128.79 | 1199.0 |
| 2019-06-12 01:00:00 | ES | Futures | 3129.06 | 3129.6 | 3126.89 | 3127.16 | 4567.0 |
| 2019-06-12 01:30:00 | ES | Futures | 3126.89 | 3127.44 | 3122.83 | 3124.18 | 5543.0 |
| 2019-06-12 02:00:00 | ES | Futures | 3124.18 | 3124.45 | 3121.47 | 3122.83 | 8246.0 |
| 2019-06-12 02:30:00 | ES | Futures | 3122.56 | 3123.64 | 3120.39 | 3120.66 | 8916.0 |
| 2019-06-12 03:00:00 | ES | Futures | 3120.93 | 3126.08 | 3120.93 | 3125.0 | 13633.0 |
| 2019-06-12 03:30:00 | ES | Futures | 3125.0 | 3126.35 | 3123.37 | 3123.64 | 11473.0 |
| 2019-06-12 04:00:00 | ES | Futures | 3123.64 | 3127.98 | 3121.2 | 3122.01 | 13115.0 |
| 2019-06-12 04:30:00 | ES | Futures | 3122.28 | 3125.0 | 3121.74 | 3121.74 | 9564.0 |
| 2019-06-12 05:00:00 | ES | Futures | 3121.74 | 3123.91 | 3120.12 | 3123.1 | 11132.0 |
| 2019-06-12 05:30:00 | ES | Futures | 3122.83 | 3123.37 | 3119.03 | 3119.84 | 10194.0 |
| 2019-06-12 06:00:00 | ES | Futures | 3119.84 | 3121.74 | 3117.95 | 3121.47 | 10319.0 |
| 2019-06-12 06:30:00 | ES | Futures | 3121.74 | 3125.0 | 3121.47 | 3125.0 | 12449.0 |
| 2019-06-12 07:00:00 | ES | Futures | 3125.0 | 3126.08 | 3121.2 | 3122.28 | 12651.0 |
| 2019-06-12 07:30:00 | ES | Futures | 3122.28 | 3124.18 | 3120.93 | 3120.93 | 7887.0 |
| 2019-06-12 08:00:00 | ES | Futures | 3120.93 | 3124.18 | 3120.93 | 3123.1 | 11579.0 |
| 2019-06-12 08:30:00 | ES | Futures | 3123.1 | 3127.16 | 3122.83 | 3123.37 | 22639.0 |
| 2019-06-12 09:00:00 | ES | Futures | 3123.64 | 3127.71 | 3123.37 | 3127.16 | 17843.0 |
| 2019-06-12 09:30:00 | ES | Futures | 3126.89 | 3133.67 | 3124.45 | 3129.06 | 167751.0 |
| 2019-06-12 10:00:00 | ES | Futures | 3129.33 | 3130.69 | 3122.01 | 3122.83 | 95293.0 |
| 2019-06-12 10:30:00 | ES | Futures | 3122.83 | 3129.33 | 3120.39 | 3123.37 | 90973.0 |
| 2019-06-12 11:00:00 | ES | Futures | 3123.64 | 3125.54 | 3121.47 | 3123.91 | 67829.0 |
| 2019-06-12 11:30:00 | ES | Futures | 3123.64 | 3125.81 | 3118.22 | 3118.22 | 62591.0 |
| 2019-06-12 12:00:00 | ES | Futures | 3118.22 | 3124.18 | 3117.95 | 3123.1 | 54219.0 |
| 2019-06-12 12:30:00 | ES | Futures | 3122.83 | 3126.35 | 3121.74 | 3124.45 | 39631.0 |
| 2019-06-12 13:00:00 | ES | Futures | 3124.72 | 3126.08 | 3122.28 | 3123.91 | 27282.0 |
| 2019-06-12 13:30:00 | ES | Futures | 3123.91 | 3124.72 | 3121.47 | 3124.18 | 25293.0 |
| 2019-06-12 14:00:00 | ES | Futures | 3124.18 | 3124.72 | 3120.12 | 3121.74 | 25379.0 |
| 2019-06-12 14:30:00 | ES | Futures | 3121.47 | 3126.08 | 3120.66 | 3124.45 | 33500.0 |
| 2019-06-12 15:00:00 | ES | Futures | 3124.45 | 3125.27 | 3122.28 | 3122.56 | 25460.0 |
| 2019-06-12 15:30:00 | ES | Futures | 3122.28 | 3124.72 | 3120.39 | 3123.91 | 100681.0 |
| 2019-06-12 16:00:00 | ES | Futures | 3123.91 | 3124.72 | 3122.56 | 3124.72 | 34097.0 |
| 2019-06-12 16:30:00 | ES | Futures | 3124.72 | 3125.81 | 3124.18 | 3124.72 | 5063.0 |
| 2019-06-12 18:00:00 | ES | Futures | 3125.27 | 3126.89 | 3124.45 | 3125.27 | 2366.0 |
| 2019-06-12 18:30:00 | ES | Futures | 3125.0 | 3128.79 | 3124.72 | 3127.71 | 2520.0 |
| 2019-06-12 19:00:00 | ES | Futures | 3127.71 | 3128.52 | 3127.16 | 3128.52 | 1207.0 |
| 2019-06-12 19:30:00 | ES | Futures | 3128.52 | 3130.15 | 3127.44 | 3129.06 | 3398.0 |
| 2019-06-12 20:00:00 | ES | Futures | 3129.06 | 3132.32 | 3127.98 | 3131.77 | 10372.0 |
| 2019-06-12 20:30:00 | ES | Futures | 3131.77 | 3132.32 | 3129.6 | 3130.42 | 3242.0 |
| 2019-06-12 21:00:00 | ES | Futures | 3130.42 | 3131.5 | 3128.79 | 3130.15 | 5410.0 |
| 2019-06-12 21:30:00 | ES | Futures | 3130.42 | 3131.23 | 3121.74 | 3123.1 | 12998.0 |
| 2019-06-12 22:00:00 | ES | Futures | 3122.83 | 3123.1 | 3109.27 | 3115.24 | 32585.0 |
| 2019-06-12 22:30:00 | ES | Futures | 3115.51 | 3116.59 | 3112.8 | 3115.78 | 7159.0 |
| 2019-06-12 23:00:00 | ES | Futures | 3116.05 | 3123.64 | 3115.24 | 3122.28 | 9495.0 |
| 2019-06-12 23:30:00 | ES | Futures | 3122.01 | 3122.56 | 3118.76 | 3119.84 | 4849.0 |
| 2019-06-12 00:00:00 | NQ | Futures | 8744.0 | 8744.87 | 8739.34 | 8740.21 | 739.0 |
| 2019-06-12 00:30:00 | NQ | Futures | 8740.5 | 8743.71 | 8740.21 | 8741.67 | 571.0 |
| 2019-06-12 01:00:00 | NQ | Futures | 8741.96 | 8744.87 | 8734.97 | 8735.85 | 1556.0 |
| 2019-06-12 01:30:00 | NQ | Futures | 8735.26 | 8737.59 | 8720.41 | 8723.62 | 2493.0 |
> showing 50 of 3,093 rows — these rows as CSV