PREVIEW / futures_30min / 2018-11-22
file: by_date/futures_30min/2018/2018-11-22.parquet size: 59 KB rows: 2,213
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-11-22 00:00:00 | ES | Futures | 2885.9 | 2886.72 | 2884.54 | 2885.63 | 1733.0 |
| 2018-11-22 00:30:00 | ES | Futures | 2885.36 | 2887.26 | 2884.0 | 2886.45 | 1391.0 |
| 2018-11-22 01:00:00 | ES | Futures | 2886.45 | 2887.81 | 2885.9 | 2887.53 | 1174.0 |
| 2018-11-22 01:30:00 | ES | Futures | 2887.26 | 2889.98 | 2886.72 | 2888.08 | 1520.0 |
| 2018-11-22 02:00:00 | ES | Futures | 2888.08 | 2889.17 | 2884.81 | 2886.17 | 3031.0 |
| 2018-11-22 02:30:00 | ES | Futures | 2886.17 | 2887.81 | 2883.18 | 2883.45 | 3331.0 |
| 2018-11-22 03:00:00 | ES | Futures | 2883.18 | 2883.73 | 2880.73 | 2881.01 | 6767.0 |
| 2018-11-22 03:30:00 | ES | Futures | 2881.28 | 2881.55 | 2873.39 | 2874.48 | 10055.0 |
| 2018-11-22 04:00:00 | ES | Futures | 2874.48 | 2875.57 | 2868.22 | 2868.77 | 8906.0 |
| 2018-11-22 04:30:00 | ES | Futures | 2868.49 | 2874.48 | 2867.41 | 2872.85 | 8135.0 |
| 2018-11-22 05:00:00 | ES | Futures | 2872.85 | 2877.47 | 2872.57 | 2875.29 | 6877.0 |
| 2018-11-22 05:30:00 | ES | Futures | 2875.29 | 2879.37 | 2871.76 | 2872.3 | 7510.0 |
| 2018-11-22 06:00:00 | ES | Futures | 2872.57 | 2876.65 | 2871.49 | 2873.39 | 4336.0 |
| 2018-11-22 06:30:00 | ES | Futures | 2873.39 | 2877.74 | 2873.39 | 2876.93 | 5472.0 |
| 2018-11-22 07:00:00 | ES | Futures | 2876.65 | 2879.1 | 2875.57 | 2876.93 | 3133.0 |
| 2018-11-22 07:30:00 | ES | Futures | 2876.93 | 2878.56 | 2875.29 | 2876.93 | 2964.0 |
| 2018-11-22 08:00:00 | ES | Futures | 2876.93 | 2876.93 | 2873.39 | 2873.66 | 2795.0 |
| 2018-11-22 08:30:00 | ES | Futures | 2873.66 | 2876.38 | 2873.39 | 2875.02 | 3164.0 |
| 2018-11-22 09:00:00 | ES | Futures | 2875.29 | 2876.11 | 2873.12 | 2874.75 | 2863.0 |
| 2018-11-22 09:30:00 | ES | Futures | 2875.02 | 2876.38 | 2874.48 | 2875.29 | 6556.0 |
| 2018-11-22 10:00:00 | ES | Futures | 2875.57 | 2876.38 | 2866.86 | 2867.95 | 9293.0 |
| 2018-11-22 10:30:00 | ES | Futures | 2867.68 | 2870.4 | 2866.05 | 2867.41 | 10681.0 |
| 2018-11-22 11:00:00 | ES | Futures | 2867.41 | 2867.68 | 2858.16 | 2863.87 | 18932.0 |
| 2018-11-22 11:30:00 | ES | Futures | 2864.14 | 2868.22 | 2860.33 | 2867.95 | 10750.0 |
| 2018-11-22 12:00:00 | ES | Futures | 2867.95 | 2869.04 | 2864.96 | 2866.59 | 4658.0 |
| 2018-11-22 12:30:00 | ES | Futures | 2866.59 | 2866.86 | 2863.87 | 2864.41 | 3668.0 |
| 2018-11-22 18:00:00 | ES | Futures | 2867.41 | 2872.85 | 2866.32 | 2871.76 | 3117.0 |
| 2018-11-22 18:30:00 | ES | Futures | 2872.03 | 2873.93 | 2870.4 | 2873.39 | 1051.0 |
| 2018-11-22 19:00:00 | ES | Futures | 2873.39 | 2875.84 | 2872.85 | 2872.85 | 2182.0 |
| 2018-11-22 19:30:00 | ES | Futures | 2872.85 | 2876.38 | 2872.3 | 2876.11 | 1368.0 |
| 2018-11-22 20:00:00 | ES | Futures | 2876.38 | 2877.74 | 2875.02 | 2875.29 | 2074.0 |
| 2018-11-22 20:30:00 | ES | Futures | 2875.29 | 2876.65 | 2874.21 | 2875.02 | 1730.0 |
| 2018-11-22 21:00:00 | ES | Futures | 2875.02 | 2876.38 | 2873.39 | 2875.29 | 1973.0 |
| 2018-11-22 21:30:00 | ES | Futures | 2875.29 | 2876.93 | 2874.75 | 2876.38 | 1795.0 |
| 2018-11-22 22:00:00 | ES | Futures | 2876.38 | 2876.65 | 2872.57 | 2873.39 | 2072.0 |
| 2018-11-22 22:30:00 | ES | Futures | 2873.66 | 2875.29 | 2873.12 | 2874.21 | 997.0 |
| 2018-11-22 23:00:00 | ES | Futures | 2874.48 | 2875.02 | 2872.85 | 2873.39 | 632.0 |
| 2018-11-22 23:30:00 | ES | Futures | 2873.39 | 2873.66 | 2870.94 | 2872.3 | 1074.0 |
| 2018-11-22 00:00:00 | NQ | Futures | 7722.96 | 7724.43 | 7717.98 | 7718.86 | 837.0 |
| 2018-11-22 00:30:00 | NQ | Futures | 7719.15 | 7726.77 | 7713.28 | 7722.96 | 1148.0 |
| 2018-11-22 01:00:00 | NQ | Futures | 7722.67 | 7729.41 | 7721.49 | 7726.48 | 740.0 |
| 2018-11-22 01:30:00 | NQ | Futures | 7727.07 | 7734.69 | 7724.13 | 7729.12 | 784.0 |
| 2018-11-22 02:00:00 | NQ | Futures | 7729.71 | 7734.11 | 7715.63 | 7720.03 | 1634.0 |
| 2018-11-22 02:30:00 | NQ | Futures | 7720.61 | 7726.48 | 7713.58 | 7714.75 | 1257.0 |
| 2018-11-22 03:00:00 | NQ | Futures | 7714.75 | 7715.34 | 7702.14 | 7705.95 | 3377.0 |
| 2018-11-22 03:30:00 | NQ | Futures | 7706.54 | 7706.83 | 7681.31 | 7687.18 | 4866.0 |
| 2018-11-22 04:00:00 | NQ | Futures | 7686.88 | 7690.11 | 7663.71 | 7668.41 | 5153.0 |
| 2018-11-22 04:30:00 | NQ | Futures | 7668.41 | 7680.72 | 7664.01 | 7676.32 | 3825.0 |
| 2018-11-22 05:00:00 | NQ | Futures | 7675.74 | 7694.8 | 7675.44 | 7680.72 | 4328.0 |
| 2018-11-22 05:30:00 | NQ | Futures | 7680.72 | 7693.92 | 7669.87 | 7672.51 | 3025.0 |
> showing 50 of 2,213 rows — these rows as CSV