PREVIEW / futures_30min / 2019-08-22
file: by_date/futures_30min/2019/2019-08-22.parquet size: 92 KB rows: 3,430
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-08-22 00:00:00 | ES | Futures | 3168.6 | 3171.04 | 3168.6 | 3169.96 | 2917.0 |
| 2019-08-22 00:30:00 | ES | Futures | 3169.69 | 3170.77 | 3169.14 | 3170.23 | 1658.0 |
| 2019-08-22 01:00:00 | ES | Futures | 3170.5 | 3171.04 | 3166.71 | 3166.98 | 4174.0 |
| 2019-08-22 01:30:00 | ES | Futures | 3166.98 | 3168.33 | 3165.9 | 3168.06 | 4369.0 |
| 2019-08-22 02:00:00 | ES | Futures | 3168.33 | 3168.6 | 3164.54 | 3165.9 | 7803.0 |
| 2019-08-22 02:30:00 | ES | Futures | 3165.63 | 3169.41 | 3165.35 | 3168.87 | 4367.0 |
| 2019-08-22 03:00:00 | ES | Futures | 3168.87 | 3176.72 | 3165.63 | 3173.75 | 23278.0 |
| 2019-08-22 03:30:00 | ES | Futures | 3173.75 | 3178.62 | 3172.66 | 3175.1 | 17897.0 |
| 2019-08-22 04:00:00 | ES | Futures | 3175.1 | 3176.45 | 3167.52 | 3167.52 | 14160.0 |
| 2019-08-22 04:30:00 | ES | Futures | 3167.52 | 3169.14 | 3164.54 | 3168.87 | 15698.0 |
| 2019-08-22 05:00:00 | ES | Futures | 3168.6 | 3169.41 | 3161.84 | 3162.38 | 15628.0 |
| 2019-08-22 05:30:00 | ES | Futures | 3162.65 | 3164.27 | 3160.21 | 3163.19 | 17920.0 |
| 2019-08-22 06:00:00 | ES | Futures | 3163.19 | 3167.79 | 3162.92 | 3166.71 | 12946.0 |
| 2019-08-22 06:30:00 | ES | Futures | 3166.71 | 3168.06 | 3165.35 | 3166.44 | 10130.0 |
| 2019-08-22 07:00:00 | ES | Futures | 3166.44 | 3173.2 | 3165.63 | 3172.12 | 11847.0 |
| 2019-08-22 07:30:00 | ES | Futures | 3172.39 | 3177.54 | 3171.31 | 3175.91 | 23183.0 |
| 2019-08-22 08:00:00 | ES | Futures | 3175.91 | 3177.81 | 3174.56 | 3176.99 | 13570.0 |
| 2019-08-22 08:30:00 | ES | Futures | 3176.99 | 3180.78 | 3174.56 | 3178.89 | 21516.0 |
| 2019-08-22 09:00:00 | ES | Futures | 3178.62 | 3179.16 | 3174.56 | 3175.37 | 19576.0 |
| 2019-08-22 09:30:00 | ES | Futures | 3175.37 | 3183.22 | 3174.56 | 3178.35 | 156237.0 |
| 2019-08-22 10:00:00 | ES | Futures | 3178.35 | 3178.35 | 3161.84 | 3163.46 | 125322.0 |
| 2019-08-22 10:30:00 | ES | Futures | 3163.73 | 3163.73 | 3144.78 | 3146.68 | 194736.0 |
| 2019-08-22 11:00:00 | ES | Futures | 3146.68 | 3158.86 | 3146.41 | 3154.53 | 110524.0 |
| 2019-08-22 11:30:00 | ES | Futures | 3154.8 | 3161.02 | 3153.98 | 3156.42 | 62148.0 |
| 2019-08-22 12:00:00 | ES | Futures | 3156.69 | 3164.81 | 3155.88 | 3162.11 | 47782.0 |
| 2019-08-22 12:30:00 | ES | Futures | 3162.11 | 3165.9 | 3160.21 | 3162.11 | 39705.0 |
| 2019-08-22 13:00:00 | ES | Futures | 3162.11 | 3169.96 | 3162.11 | 3168.87 | 40612.0 |
| 2019-08-22 13:30:00 | ES | Futures | 3168.6 | 3171.04 | 3167.79 | 3168.87 | 33581.0 |
| 2019-08-22 14:00:00 | ES | Futures | 3168.87 | 3170.5 | 3165.63 | 3166.17 | 31310.0 |
| 2019-08-22 14:30:00 | ES | Futures | 3165.9 | 3172.66 | 3165.08 | 3171.31 | 44758.0 |
| 2019-08-22 15:00:00 | ES | Futures | 3171.58 | 3172.39 | 3164.27 | 3167.52 | 47811.0 |
| 2019-08-22 15:30:00 | ES | Futures | 3167.52 | 3175.64 | 3163.46 | 3165.35 | 127254.0 |
| 2019-08-22 16:00:00 | ES | Futures | 3165.35 | 3167.25 | 3163.19 | 3163.73 | 52234.0 |
| 2019-08-22 16:30:00 | ES | Futures | 3163.19 | 3164.27 | 3161.56 | 3161.84 | 6699.0 |
| 2019-08-22 18:00:00 | ES | Futures | 3162.11 | 3166.17 | 3161.84 | 3164.81 | 3506.0 |
| 2019-08-22 18:30:00 | ES | Futures | 3164.81 | 3165.9 | 3163.19 | 3163.73 | 1389.0 |
| 2019-08-22 19:00:00 | ES | Futures | 3163.73 | 3165.08 | 3162.38 | 3162.65 | 1227.0 |
| 2019-08-22 19:30:00 | ES | Futures | 3162.65 | 3165.08 | 3160.48 | 3164.27 | 3575.0 |
| 2019-08-22 20:00:00 | ES | Futures | 3164.27 | 3169.69 | 3162.92 | 3168.87 | 7494.0 |
| 2019-08-22 20:30:00 | ES | Futures | 3168.87 | 3170.77 | 3168.06 | 3170.23 | 4642.0 |
| 2019-08-22 21:00:00 | ES | Futures | 3170.23 | 3172.39 | 3169.41 | 3170.77 | 7672.0 |
| 2019-08-22 21:30:00 | ES | Futures | 3170.77 | 3175.91 | 3167.79 | 3174.29 | 10298.0 |
| 2019-08-22 22:00:00 | ES | Futures | 3174.29 | 3174.83 | 3172.12 | 3173.48 | 3139.0 |
| 2019-08-22 22:30:00 | ES | Futures | 3173.48 | 3175.37 | 3172.93 | 3174.83 | 2907.0 |
| 2019-08-22 23:00:00 | ES | Futures | 3175.1 | 3176.72 | 3174.83 | 3175.37 | 3350.0 |
| 2019-08-22 23:30:00 | ES | Futures | 3175.37 | 3175.64 | 3174.02 | 3174.83 | 1725.0 |
| 2019-08-22 00:00:00 | NQ | Futures | 8976.14 | 8984.84 | 8975.56 | 8980.78 | 1401.0 |
| 2019-08-22 00:30:00 | NQ | Futures | 8980.78 | 8986.0 | 8978.75 | 8985.42 | 1118.0 |
| 2019-08-22 01:00:00 | NQ | Futures | 8985.42 | 8986.87 | 8971.49 | 8972.07 | 2299.0 |
| 2019-08-22 01:30:00 | NQ | Futures | 8971.78 | 8977.88 | 8966.56 | 8977.3 | 2734.0 |
> showing 50 of 3,430 rows — these rows as CSV