PREVIEW / futures_30min / 2015-02-24
file: by_date/futures_30min/2015/2015-02-24.parquet size: 78 KB rows: 2,886
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 |
|---|---|---|---|---|---|---|---|
| 2015-02-24 00:00:00 | ES | Futures | 2218.11 | 2218.37 | 2217.58 | 2217.84 | 992.0 |
| 2015-02-24 00:30:00 | ES | Futures | 2217.84 | 2218.63 | 2217.84 | 2218.63 | 948.0 |
| 2015-02-24 01:00:00 | ES | Futures | 2218.37 | 2218.63 | 2217.84 | 2217.84 | 869.0 |
| 2015-02-24 01:30:00 | ES | Futures | 2217.84 | 2218.63 | 2217.84 | 2218.37 | 670.0 |
| 2015-02-24 02:00:00 | ES | Futures | 2218.37 | 2218.9 | 2218.11 | 2218.37 | 1539.0 |
| 2015-02-24 02:30:00 | ES | Futures | 2218.63 | 2218.63 | 2217.84 | 2218.37 | 1194.0 |
| 2015-02-24 03:00:00 | ES | Futures | 2218.37 | 2219.16 | 2217.84 | 2218.11 | 7490.0 |
| 2015-02-24 03:30:00 | ES | Futures | 2218.11 | 2218.9 | 2216.53 | 2216.79 | 7996.0 |
| 2015-02-24 04:00:00 | ES | Futures | 2216.79 | 2217.84 | 2215.74 | 2217.58 | 7780.0 |
| 2015-02-24 04:30:00 | ES | Futures | 2217.32 | 2217.58 | 2216.53 | 2216.79 | 3400.0 |
| 2015-02-24 05:00:00 | ES | Futures | 2216.79 | 2217.58 | 2216.53 | 2217.05 | 2640.0 |
| 2015-02-24 05:30:00 | ES | Futures | 2217.32 | 2217.58 | 2216.79 | 2217.58 | 1935.0 |
| 2015-02-24 06:00:00 | ES | Futures | 2217.32 | 2218.9 | 2217.05 | 2217.84 | 4956.0 |
| 2015-02-24 06:30:00 | ES | Futures | 2217.84 | 2218.63 | 2217.58 | 2218.11 | 3096.0 |
| 2015-02-24 07:00:00 | ES | Futures | 2218.11 | 2218.63 | 2216.53 | 2217.32 | 5606.0 |
| 2015-02-24 07:30:00 | ES | Futures | 2217.32 | 2217.84 | 2216.26 | 2217.32 | 5266.0 |
| 2015-02-24 08:00:00 | ES | Futures | 2217.32 | 2217.58 | 2216.79 | 2217.58 | 3406.0 |
| 2015-02-24 08:30:00 | ES | Futures | 2217.58 | 2218.37 | 2216.53 | 2217.84 | 8799.0 |
| 2015-02-24 09:00:00 | ES | Futures | 2218.11 | 2218.63 | 2216.53 | 2217.05 | 13005.0 |
| 2015-02-24 09:30:00 | ES | Futures | 2217.05 | 2219.69 | 2216.0 | 2217.58 | 119405.0 |
| 2015-02-24 10:00:00 | ES | Futures | 2217.58 | 2222.84 | 2213.37 | 2221.79 | 169603.0 |
| 2015-02-24 10:30:00 | ES | Futures | 2221.79 | 2222.58 | 2220.21 | 2221.53 | 74917.0 |
| 2015-02-24 11:00:00 | ES | Futures | 2221.79 | 2225.48 | 2221.26 | 2224.42 | 78729.0 |
| 2015-02-24 11:30:00 | ES | Futures | 2224.42 | 2225.21 | 2222.05 | 2222.05 | 57888.0 |
| 2015-02-24 12:00:00 | ES | Futures | 2222.05 | 2223.11 | 2221.26 | 2221.79 | 32585.0 |
| 2015-02-24 12:30:00 | ES | Futures | 2221.53 | 2222.32 | 2217.05 | 2221.53 | 66292.0 |
| 2015-02-24 13:00:00 | ES | Futures | 2221.53 | 2221.79 | 2219.95 | 2221.0 | 33555.0 |
| 2015-02-24 13:30:00 | ES | Futures | 2221.0 | 2223.63 | 2221.0 | 2223.11 | 40972.0 |
| 2015-02-24 14:00:00 | ES | Futures | 2223.11 | 2223.63 | 2221.26 | 2221.79 | 33615.0 |
| 2015-02-24 14:30:00 | ES | Futures | 2222.05 | 2224.16 | 2221.26 | 2223.9 | 38294.0 |
| 2015-02-24 15:00:00 | ES | Futures | 2223.9 | 2226.0 | 2223.63 | 2225.74 | 48087.0 |
| 2015-02-24 15:30:00 | ES | Futures | 2226.0 | 2227.05 | 2223.37 | 2224.69 | 128832.0 |
| 2015-02-24 16:00:00 | ES | Futures | 2224.95 | 2225.48 | 2223.63 | 2224.95 | 48401.0 |
| 2015-02-24 16:30:00 | ES | Futures | 2224.69 | 2225.74 | 2224.69 | 2225.21 | 4743.0 |
| 2015-02-24 17:00:00 | ES | Futures | 2225.21 | 2225.48 | 2224.69 | 2224.95 | 1219.0 |
| 2015-02-24 18:00:00 | ES | Futures | 2224.95 | 2225.21 | 2224.42 | 2225.21 | 2284.0 |
| 2015-02-24 18:30:00 | ES | Futures | 2225.21 | 2225.21 | 2224.69 | 2224.69 | 772.0 |
| 2015-02-24 19:00:00 | ES | Futures | 2224.69 | 2224.95 | 2223.11 | 2223.63 | 3378.0 |
| 2015-02-24 19:30:00 | ES | Futures | 2223.63 | 2224.42 | 2223.63 | 2224.42 | 646.0 |
| 2015-02-24 20:00:00 | ES | Futures | 2224.42 | 2224.95 | 2223.9 | 2224.16 | 1582.0 |
| 2015-02-24 20:30:00 | ES | Futures | 2224.16 | 2224.95 | 2223.37 | 2224.42 | 1995.0 |
| 2015-02-24 21:00:00 | ES | Futures | 2224.42 | 2224.95 | 2224.16 | 2224.69 | 993.0 |
| 2015-02-24 21:30:00 | ES | Futures | 2224.42 | 2224.69 | 2223.11 | 2223.37 | 1668.0 |
| 2015-02-24 22:00:00 | ES | Futures | 2223.63 | 2223.9 | 2223.11 | 2223.9 | 525.0 |
| 2015-02-24 22:30:00 | ES | Futures | 2223.63 | 2224.16 | 2223.63 | 2223.9 | 558.0 |
| 2015-02-24 23:00:00 | ES | Futures | 2223.9 | 2224.16 | 2223.9 | 2223.9 | 798.0 |
| 2015-02-24 23:30:00 | ES | Futures | 2223.9 | 2224.42 | 2223.9 | 2224.16 | 513.0 |
| 2015-02-24 00:00:00 | NQ | Futures | 5223.54 | 5224.13 | 5222.66 | 5223.54 | 105.0 |
| 2015-02-24 00:30:00 | NQ | Futures | 5223.25 | 5225.01 | 5223.25 | 5225.01 | 288.0 |
| 2015-02-24 01:00:00 | NQ | Futures | 5224.72 | 5225.3 | 5223.25 | 5223.25 | 126.0 |
> showing 50 of 2,886 rows — these rows as CSV