PREVIEW / futures_30min / 2018-09-03
file: by_date/futures_30min/2018/2018-09-03.parquet size: 59 KB rows: 2,253
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-03 00:00:00 | ES | Futures | 3164.97 | 3165.24 | 3163.88 | 3164.42 | 1034.0 |
| 2018-09-03 00:30:00 | ES | Futures | 3164.15 | 3164.42 | 3163.61 | 3163.88 | 714.0 |
| 2018-09-03 01:00:00 | ES | Futures | 3164.15 | 3164.7 | 3163.61 | 3164.7 | 1930.0 |
| 2018-09-03 01:30:00 | ES | Futures | 3164.42 | 3165.79 | 3164.15 | 3164.7 | 2380.0 |
| 2018-09-03 02:00:00 | ES | Futures | 3164.7 | 3165.79 | 3163.88 | 3165.24 | 2700.0 |
| 2018-09-03 02:30:00 | ES | Futures | 3165.51 | 3165.51 | 3163.33 | 3164.42 | 2561.0 |
| 2018-09-03 03:00:00 | ES | Futures | 3164.7 | 3166.88 | 3164.15 | 3164.7 | 5824.0 |
| 2018-09-03 03:30:00 | ES | Futures | 3164.7 | 3167.69 | 3164.42 | 3167.42 | 4430.0 |
| 2018-09-03 04:00:00 | ES | Futures | 3167.42 | 3171.78 | 3166.88 | 3171.24 | 9182.0 |
| 2018-09-03 04:30:00 | ES | Futures | 3171.24 | 3171.51 | 3169.87 | 3170.96 | 3001.0 |
| 2018-09-03 05:00:00 | ES | Futures | 3170.96 | 3172.33 | 3170.42 | 3171.51 | 3166.0 |
| 2018-09-03 05:30:00 | ES | Futures | 3171.51 | 3171.51 | 3169.87 | 3170.42 | 3072.0 |
| 2018-09-03 06:00:00 | ES | Futures | 3170.15 | 3173.41 | 3169.87 | 3173.14 | 2931.0 |
| 2018-09-03 06:30:00 | ES | Futures | 3173.14 | 3173.96 | 3172.33 | 3172.6 | 2346.0 |
| 2018-09-03 07:00:00 | ES | Futures | 3172.87 | 3173.96 | 3172.33 | 3173.14 | 2992.0 |
| 2018-09-03 07:30:00 | ES | Futures | 3173.14 | 3174.23 | 3170.42 | 3170.42 | 3684.0 |
| 2018-09-03 08:00:00 | ES | Futures | 3170.42 | 3171.51 | 3169.87 | 3170.42 | 3958.0 |
| 2018-09-03 08:30:00 | ES | Futures | 3170.42 | 3170.42 | 3168.51 | 3169.06 | 3570.0 |
| 2018-09-03 09:00:00 | ES | Futures | 3169.06 | 3169.87 | 3167.97 | 3169.33 | 4902.0 |
| 2018-09-03 09:30:00 | ES | Futures | 3169.6 | 3170.42 | 3168.24 | 3170.42 | 4719.0 |
| 2018-09-03 10:00:00 | ES | Futures | 3170.42 | 3170.42 | 3168.51 | 3169.6 | 4848.0 |
| 2018-09-03 10:30:00 | ES | Futures | 3169.33 | 3171.24 | 3169.33 | 3170.42 | 4884.0 |
| 2018-09-03 11:00:00 | ES | Futures | 3170.42 | 3170.69 | 3168.24 | 3169.6 | 4679.0 |
| 2018-09-03 11:30:00 | ES | Futures | 3169.33 | 3172.05 | 3169.33 | 3170.96 | 4671.0 |
| 2018-09-03 12:00:00 | ES | Futures | 3170.96 | 3171.51 | 3170.69 | 3170.69 | 1760.0 |
| 2018-09-03 12:30:00 | ES | Futures | 3170.69 | 3171.24 | 3169.33 | 3169.6 | 2419.0 |
| 2018-09-03 13:00:00 | ES | Futures | 3169.6 | 3169.6 | 3169.6 | 3169.6 | 2.0 |
| 2018-09-03 18:00:00 | ES | Futures | 3169.06 | 3170.69 | 3168.51 | 3170.15 | 2159.0 |
| 2018-09-03 18:30:00 | ES | Futures | 3170.15 | 3170.15 | 3168.78 | 3169.06 | 830.0 |
| 2018-09-03 19:00:00 | ES | Futures | 3169.33 | 3169.33 | 3168.78 | 3169.06 | 884.0 |
| 2018-09-03 19:30:00 | ES | Futures | 3169.33 | 3169.6 | 3167.69 | 3167.97 | 1449.0 |
| 2018-09-03 20:00:00 | ES | Futures | 3167.69 | 3167.97 | 3164.15 | 3165.51 | 7222.0 |
| 2018-09-03 20:30:00 | ES | Futures | 3165.51 | 3167.15 | 3165.51 | 3166.88 | 2185.0 |
| 2018-09-03 21:00:00 | ES | Futures | 3166.6 | 3167.15 | 3162.52 | 3164.42 | 4637.0 |
| 2018-09-03 21:30:00 | ES | Futures | 3164.42 | 3168.24 | 3163.06 | 3167.15 | 6533.0 |
| 2018-09-03 22:00:00 | ES | Futures | 3167.15 | 3168.24 | 3166.06 | 3166.33 | 3139.0 |
| 2018-09-03 22:30:00 | ES | Futures | 3166.33 | 3167.97 | 3166.33 | 3167.97 | 1940.0 |
| 2018-09-03 23:00:00 | ES | Futures | 3168.24 | 3168.51 | 3166.6 | 3167.15 | 1321.0 |
| 2018-09-03 23:30:00 | ES | Futures | 3167.15 | 3167.42 | 3166.33 | 3166.88 | 898.0 |
| 2018-09-03 00:00:00 | NQ | Futures | 9029.51 | 9029.51 | 9025.68 | 9026.57 | 226.0 |
| 2018-09-03 00:30:00 | NQ | Futures | 9026.27 | 9026.86 | 9025.39 | 9025.98 | 205.0 |
| 2018-09-03 01:00:00 | NQ | Futures | 9026.27 | 9027.74 | 9023.92 | 9026.86 | 404.0 |
| 2018-09-03 01:30:00 | NQ | Futures | 9026.86 | 9031.28 | 9025.98 | 9027.74 | 492.0 |
| 2018-09-03 02:00:00 | NQ | Futures | 9027.45 | 9030.69 | 9025.39 | 9028.04 | 659.0 |
| 2018-09-03 02:30:00 | NQ | Futures | 9028.33 | 9028.33 | 9019.21 | 9023.03 | 929.0 |
| 2018-09-03 03:00:00 | NQ | Futures | 9022.74 | 9030.1 | 9021.27 | 9023.33 | 1597.0 |
| 2018-09-03 03:30:00 | NQ | Futures | 9023.33 | 9028.92 | 9021.56 | 9028.33 | 969.0 |
| 2018-09-03 04:00:00 | NQ | Futures | 9028.63 | 9042.76 | 9027.74 | 9038.05 | 2538.0 |
| 2018-09-03 04:30:00 | NQ | Futures | 9038.34 | 9040.11 | 9034.52 | 9036.58 | 900.0 |
| 2018-09-03 05:00:00 | NQ | Futures | 9036.87 | 9040.99 | 9035.69 | 9038.34 | 677.0 |
> showing 50 of 2,253 rows — these rows as CSV