PREVIEW / futures_30min / 2019-07-12
file: by_date/futures_30min/2019/2019-07-12.parquet size: 74 KB rows: 2,746
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-07-12 00:00:00 | ES | Futures | 3260.37 | 3261.18 | 3260.1 | 3260.64 | 1330.0 |
| 2019-07-12 00:30:00 | ES | Futures | 3260.64 | 3260.91 | 3259.83 | 3260.37 | 2151.0 |
| 2019-07-12 01:00:00 | ES | Futures | 3260.37 | 3260.91 | 3259.56 | 3260.64 | 2167.0 |
| 2019-07-12 01:30:00 | ES | Futures | 3260.64 | 3261.18 | 3259.83 | 3260.91 | 2536.0 |
| 2019-07-12 02:00:00 | ES | Futures | 3261.18 | 3261.18 | 3259.29 | 3259.56 | 3355.0 |
| 2019-07-12 02:30:00 | ES | Futures | 3259.83 | 3259.83 | 3257.39 | 3257.66 | 6819.0 |
| 2019-07-12 03:00:00 | ES | Futures | 3257.66 | 3258.48 | 3257.12 | 3257.66 | 10062.0 |
| 2019-07-12 03:30:00 | ES | Futures | 3257.94 | 3259.29 | 3256.85 | 3258.48 | 10792.0 |
| 2019-07-12 04:00:00 | ES | Futures | 3258.48 | 3260.91 | 3257.39 | 3260.91 | 9714.0 |
| 2019-07-12 04:30:00 | ES | Futures | 3260.91 | 3261.45 | 3259.56 | 3260.1 | 8113.0 |
| 2019-07-12 05:00:00 | ES | Futures | 3260.37 | 3261.73 | 3259.56 | 3260.64 | 9360.0 |
| 2019-07-12 05:30:00 | ES | Futures | 3260.37 | 3261.45 | 3259.83 | 3260.37 | 8102.0 |
| 2019-07-12 06:00:00 | ES | Futures | 3260.64 | 3262.0 | 3260.1 | 3260.91 | 7099.0 |
| 2019-07-12 06:30:00 | ES | Futures | 3260.64 | 3262.27 | 3258.21 | 3259.56 | 13566.0 |
| 2019-07-12 07:00:00 | ES | Futures | 3259.83 | 3260.64 | 3259.02 | 3259.29 | 6935.0 |
| 2019-07-12 07:30:00 | ES | Futures | 3259.02 | 3260.1 | 3257.94 | 3259.83 | 9082.0 |
| 2019-07-12 08:00:00 | ES | Futures | 3259.83 | 3261.18 | 3259.02 | 3260.64 | 10555.0 |
| 2019-07-12 08:30:00 | ES | Futures | 3260.64 | 3261.18 | 3258.75 | 3259.56 | 12026.0 |
| 2019-07-12 09:00:00 | ES | Futures | 3259.56 | 3259.83 | 3257.94 | 3258.21 | 11786.0 |
| 2019-07-12 09:30:00 | ES | Futures | 3258.21 | 3259.83 | 3255.5 | 3256.85 | 123839.0 |
| 2019-07-12 10:00:00 | ES | Futures | 3257.12 | 3259.83 | 3255.5 | 3257.39 | 66454.0 |
| 2019-07-12 10:30:00 | ES | Futures | 3257.39 | 3258.21 | 3254.42 | 3255.77 | 54038.0 |
| 2019-07-12 11:00:00 | ES | Futures | 3255.77 | 3259.83 | 3254.42 | 3259.83 | 44856.0 |
| 2019-07-12 11:30:00 | ES | Futures | 3259.83 | 3260.37 | 3257.39 | 3259.29 | 43195.0 |
| 2019-07-12 12:00:00 | ES | Futures | 3259.29 | 3260.1 | 3257.94 | 3258.75 | 32745.0 |
| 2019-07-12 12:30:00 | ES | Futures | 3258.48 | 3260.91 | 3257.66 | 3260.64 | 34086.0 |
| 2019-07-12 13:00:00 | ES | Futures | 3260.91 | 3261.18 | 3259.56 | 3260.37 | 20668.0 |
| 2019-07-12 13:30:00 | ES | Futures | 3260.37 | 3260.64 | 3258.75 | 3259.56 | 17599.0 |
| 2019-07-12 14:00:00 | ES | Futures | 3259.56 | 3262.0 | 3259.29 | 3261.18 | 31171.0 |
| 2019-07-12 14:30:00 | ES | Futures | 3261.45 | 3263.89 | 3260.91 | 3263.62 | 48619.0 |
| 2019-07-12 15:00:00 | ES | Futures | 3263.35 | 3264.43 | 3261.45 | 3263.08 | 37595.0 |
| 2019-07-12 15:30:00 | ES | Futures | 3263.35 | 3267.95 | 3263.08 | 3266.87 | 110314.0 |
| 2019-07-12 16:00:00 | ES | Futures | 3266.87 | 3267.68 | 3264.16 | 3264.43 | 52790.0 |
| 2019-07-12 16:30:00 | ES | Futures | 3264.7 | 3265.79 | 3263.62 | 3263.89 | 6884.0 |
| 2019-07-12 00:00:00 | NQ | Futures | 9211.73 | 9212.6 | 9209.12 | 9209.99 | 695.0 |
| 2019-07-12 00:30:00 | NQ | Futures | 9210.28 | 9210.28 | 9205.35 | 9206.22 | 905.0 |
| 2019-07-12 01:00:00 | NQ | Futures | 9206.22 | 9210.57 | 9203.61 | 9209.12 | 1021.0 |
| 2019-07-12 01:30:00 | NQ | Futures | 9208.83 | 9211.73 | 9205.64 | 9210.28 | 1050.0 |
| 2019-07-12 02:00:00 | NQ | Futures | 9210.57 | 9212.31 | 9207.38 | 9209.12 | 1111.0 |
| 2019-07-12 02:30:00 | NQ | Futures | 9209.12 | 9209.7 | 9199.55 | 9201.0 | 2780.0 |
| 2019-07-12 03:00:00 | NQ | Futures | 9200.71 | 9205.35 | 9197.81 | 9203.03 | 2330.0 |
| 2019-07-12 03:30:00 | NQ | Futures | 9203.03 | 9208.83 | 9198.39 | 9204.19 | 2181.0 |
| 2019-07-12 04:00:00 | NQ | Futures | 9203.9 | 9218.7 | 9201.0 | 9218.41 | 3631.0 |
| 2019-07-12 04:30:00 | NQ | Futures | 9218.41 | 9219.86 | 9213.47 | 9216.08 | 2526.0 |
| 2019-07-12 05:00:00 | NQ | Futures | 9216.37 | 9219.57 | 9212.89 | 9216.08 | 2586.0 |
| 2019-07-12 05:30:00 | NQ | Futures | 9216.08 | 9218.41 | 9214.05 | 9216.08 | 1475.0 |
| 2019-07-12 06:00:00 | NQ | Futures | 9216.08 | 9223.92 | 9216.08 | 9219.28 | 2030.0 |
| 2019-07-12 06:30:00 | NQ | Futures | 9219.28 | 9223.34 | 9207.09 | 9213.18 | 3446.0 |
| 2019-07-12 07:00:00 | NQ | Futures | 9213.47 | 9216.37 | 9209.12 | 9209.7 | 1829.0 |
| 2019-07-12 07:30:00 | NQ | Futures | 9209.41 | 9212.02 | 9204.19 | 9209.99 | 2516.0 |
> showing 50 of 2,746 rows — these rows as CSV