PREVIEW / futures_30min / 2014-07-14
file: by_date/futures_30min/2014/2014-07-14.parquet size: 68 KB rows: 2,789
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 |
|---|---|---|---|---|---|---|---|
| 2014-07-14 00:00:00 | ES | Futures | 2047.64 | 2048.95 | 2047.64 | 2048.69 | 1524.0 |
| 2014-07-14 00:30:00 | ES | Futures | 2048.69 | 2048.95 | 2048.43 | 2048.95 | 548.0 |
| 2014-07-14 01:00:00 | ES | Futures | 2048.95 | 2049.47 | 2048.69 | 2048.95 | 1423.0 |
| 2014-07-14 01:30:00 | ES | Futures | 2048.95 | 2049.99 | 2048.95 | 2049.21 | 1928.0 |
| 2014-07-14 02:00:00 | ES | Futures | 2049.21 | 2049.99 | 2048.95 | 2048.95 | 2636.0 |
| 2014-07-14 02:30:00 | ES | Futures | 2048.95 | 2049.47 | 2048.43 | 2048.69 | 1822.0 |
| 2014-07-14 03:00:00 | ES | Futures | 2048.69 | 2050.25 | 2047.9 | 2049.99 | 10054.0 |
| 2014-07-14 03:30:00 | ES | Futures | 2049.73 | 2050.25 | 2048.95 | 2049.73 | 6178.0 |
| 2014-07-14 04:00:00 | ES | Futures | 2049.73 | 2053.12 | 2049.73 | 2052.86 | 16937.0 |
| 2014-07-14 04:30:00 | ES | Futures | 2052.86 | 2053.38 | 2052.34 | 2052.6 | 4595.0 |
| 2014-07-14 05:00:00 | ES | Futures | 2052.34 | 2052.86 | 2051.55 | 2051.55 | 7716.0 |
| 2014-07-14 05:30:00 | ES | Futures | 2051.55 | 2053.12 | 2051.55 | 2052.6 | 5036.0 |
| 2014-07-14 06:00:00 | ES | Futures | 2052.6 | 2053.12 | 2052.07 | 2052.34 | 5394.0 |
| 2014-07-14 06:30:00 | ES | Futures | 2052.6 | 2052.6 | 2051.81 | 2052.07 | 4689.0 |
| 2014-07-14 07:00:00 | ES | Futures | 2052.07 | 2052.86 | 2052.07 | 2052.6 | 6876.0 |
| 2014-07-14 07:30:00 | ES | Futures | 2052.34 | 2053.9 | 2051.81 | 2053.64 | 13025.0 |
| 2014-07-14 08:00:00 | ES | Futures | 2053.64 | 2055.2 | 2053.64 | 2054.42 | 12868.0 |
| 2014-07-14 08:30:00 | ES | Futures | 2054.42 | 2054.68 | 2053.9 | 2053.9 | 7607.0 |
| 2014-07-14 09:00:00 | ES | Futures | 2054.16 | 2055.98 | 2053.9 | 2055.2 | 20913.0 |
| 2014-07-14 09:30:00 | ES | Futures | 2055.2 | 2057.03 | 2053.38 | 2055.2 | 175112.0 |
| 2014-07-14 10:00:00 | ES | Futures | 2054.94 | 2056.24 | 2054.42 | 2055.2 | 88899.0 |
| 2014-07-14 10:30:00 | ES | Futures | 2054.94 | 2057.29 | 2054.94 | 2056.24 | 73608.0 |
| 2014-07-14 11:00:00 | ES | Futures | 2056.5 | 2057.81 | 2056.5 | 2057.03 | 51800.0 |
| 2014-07-14 11:30:00 | ES | Futures | 2057.03 | 2057.81 | 2055.72 | 2055.72 | 47653.0 |
| 2014-07-14 12:00:00 | ES | Futures | 2055.72 | 2057.03 | 2055.72 | 2056.5 | 34459.0 |
| 2014-07-14 12:30:00 | ES | Futures | 2056.24 | 2056.77 | 2054.16 | 2055.2 | 62519.0 |
| 2014-07-14 13:00:00 | ES | Futures | 2054.94 | 2055.72 | 2054.68 | 2055.2 | 26154.0 |
| 2014-07-14 13:30:00 | ES | Futures | 2055.2 | 2056.24 | 2054.94 | 2055.46 | 28127.0 |
| 2014-07-14 14:00:00 | ES | Futures | 2055.72 | 2056.24 | 2054.68 | 2054.68 | 28980.0 |
| 2014-07-14 14:30:00 | ES | Futures | 2054.68 | 2056.24 | 2054.68 | 2056.24 | 35701.0 |
| 2014-07-14 15:00:00 | ES | Futures | 2056.24 | 2056.24 | 2054.16 | 2054.42 | 36031.0 |
| 2014-07-14 15:30:00 | ES | Futures | 2054.42 | 2055.46 | 2053.9 | 2054.94 | 94982.0 |
| 2014-07-14 16:00:00 | ES | Futures | 2054.94 | 2055.46 | 2054.16 | 2054.68 | 62934.0 |
| 2014-07-14 16:30:00 | ES | Futures | 2054.68 | 2055.2 | 2054.42 | 2054.94 | 4490.0 |
| 2014-07-14 17:00:00 | ES | Futures | 2054.68 | 2055.2 | 2054.68 | 2054.94 | 2187.0 |
| 2014-07-14 18:00:00 | ES | Futures | 2054.94 | 2055.46 | 2054.42 | 2054.68 | 2682.0 |
| 2014-07-14 18:30:00 | ES | Futures | 2054.68 | 2054.94 | 2054.42 | 2054.42 | 172.0 |
| 2014-07-14 19:00:00 | ES | Futures | 2054.42 | 2054.68 | 2053.9 | 2054.42 | 777.0 |
| 2014-07-14 19:30:00 | ES | Futures | 2054.42 | 2054.94 | 2054.16 | 2054.42 | 665.0 |
| 2014-07-14 20:00:00 | ES | Futures | 2054.68 | 2055.98 | 2054.42 | 2055.46 | 3002.0 |
| 2014-07-14 20:30:00 | ES | Futures | 2055.46 | 2056.24 | 2055.46 | 2056.24 | 1195.0 |
| 2014-07-14 21:00:00 | ES | Futures | 2055.98 | 2056.77 | 2055.72 | 2055.98 | 2795.0 |
| 2014-07-14 21:30:00 | ES | Futures | 2055.98 | 2057.03 | 2055.98 | 2056.24 | 2521.0 |
| 2014-07-14 22:00:00 | ES | Futures | 2056.24 | 2056.5 | 2055.98 | 2055.98 | 973.0 |
| 2014-07-14 22:30:00 | ES | Futures | 2056.24 | 2056.5 | 2055.98 | 2056.24 | 407.0 |
| 2014-07-14 23:00:00 | ES | Futures | 2056.24 | 2056.5 | 2055.98 | 2056.24 | 556.0 |
| 2014-07-14 23:30:00 | ES | Futures | 2056.24 | 2056.5 | 2055.2 | 2055.72 | 1701.0 |
| 2014-07-14 00:00:00 | NQ | Futures | 4558.06 | 4560.98 | 4558.06 | 4560.1 | 144.0 |
| 2014-07-14 00:30:00 | NQ | Futures | 4560.1 | 4560.98 | 4559.52 | 4560.98 | 76.0 |
| 2014-07-14 01:00:00 | NQ | Futures | 4560.98 | 4561.85 | 4560.39 | 4561.27 | 185.0 |
> showing 50 of 2,789 rows — these rows as CSV