PREVIEW / futures_30min / 2014-07-30
file: by_date/futures_30min/2014/2014-07-30.parquet size: 75 KB rows: 2,844
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-30 00:00:00 | ES | Futures | 2048.69 | 2048.95 | 2048.17 | 2048.95 | 519.0 |
| 2014-07-30 00:30:00 | ES | Futures | 2048.69 | 2049.47 | 2048.69 | 2048.69 | 636.0 |
| 2014-07-30 01:00:00 | ES | Futures | 2048.95 | 2049.47 | 2048.69 | 2049.21 | 1147.0 |
| 2014-07-30 01:30:00 | ES | Futures | 2049.21 | 2049.47 | 2048.69 | 2049.21 | 839.0 |
| 2014-07-30 02:00:00 | ES | Futures | 2049.47 | 2049.73 | 2048.69 | 2049.47 | 2725.0 |
| 2014-07-30 02:30:00 | ES | Futures | 2049.47 | 2052.34 | 2048.95 | 2051.03 | 8543.0 |
| 2014-07-30 03:00:00 | ES | Futures | 2051.03 | 2051.81 | 2049.47 | 2049.73 | 18706.0 |
| 2014-07-30 03:30:00 | ES | Futures | 2049.99 | 2049.99 | 2048.69 | 2048.95 | 10023.0 |
| 2014-07-30 04:00:00 | ES | Futures | 2048.69 | 2050.25 | 2048.17 | 2049.21 | 10945.0 |
| 2014-07-30 04:30:00 | ES | Futures | 2049.21 | 2050.25 | 2048.95 | 2049.21 | 7029.0 |
| 2014-07-30 05:00:00 | ES | Futures | 2049.47 | 2051.29 | 2049.21 | 2050.51 | 8823.0 |
| 2014-07-30 05:30:00 | ES | Futures | 2050.51 | 2051.29 | 2049.73 | 2049.99 | 6224.0 |
| 2014-07-30 06:00:00 | ES | Futures | 2049.99 | 2050.77 | 2049.21 | 2050.25 | 4676.0 |
| 2014-07-30 06:30:00 | ES | Futures | 2050.25 | 2051.29 | 2049.73 | 2051.03 | 8072.0 |
| 2014-07-30 07:00:00 | ES | Futures | 2051.03 | 2053.64 | 2050.51 | 2052.86 | 15327.0 |
| 2014-07-30 07:30:00 | ES | Futures | 2052.86 | 2053.38 | 2052.34 | 2053.12 | 6013.0 |
| 2014-07-30 08:00:00 | ES | Futures | 2053.12 | 2053.64 | 2049.73 | 2050.51 | 18522.0 |
| 2014-07-30 08:30:00 | ES | Futures | 2050.51 | 2057.55 | 2050.51 | 2055.46 | 65046.0 |
| 2014-07-30 09:00:00 | ES | Futures | 2055.46 | 2055.98 | 2053.12 | 2054.94 | 25453.0 |
| 2014-07-30 09:30:00 | ES | Futures | 2054.94 | 2058.07 | 2050.25 | 2050.77 | 181110.0 |
| 2014-07-30 10:00:00 | ES | Futures | 2051.03 | 2051.55 | 2046.08 | 2049.73 | 174492.0 |
| 2014-07-30 10:30:00 | ES | Futures | 2049.73 | 2050.77 | 2042.95 | 2045.04 | 137493.0 |
| 2014-07-30 11:00:00 | ES | Futures | 2044.78 | 2047.38 | 2040.61 | 2046.08 | 125951.0 |
| 2014-07-30 11:30:00 | ES | Futures | 2046.08 | 2046.34 | 2040.35 | 2041.13 | 93908.0 |
| 2014-07-30 12:00:00 | ES | Futures | 2041.13 | 2044.78 | 2039.57 | 2044.0 | 87511.0 |
| 2014-07-30 12:30:00 | ES | Futures | 2044.0 | 2046.34 | 2042.69 | 2045.56 | 45929.0 |
| 2014-07-30 13:00:00 | ES | Futures | 2045.3 | 2045.82 | 2041.39 | 2042.69 | 41436.0 |
| 2014-07-30 13:30:00 | ES | Futures | 2042.69 | 2045.3 | 2042.17 | 2044.52 | 38269.0 |
| 2014-07-30 14:00:00 | ES | Futures | 2044.52 | 2055.2 | 2041.65 | 2052.34 | 220557.0 |
| 2014-07-30 14:30:00 | ES | Futures | 2052.34 | 2053.12 | 2045.3 | 2047.9 | 106816.0 |
| 2014-07-30 15:00:00 | ES | Futures | 2047.9 | 2048.95 | 2044.26 | 2048.17 | 82510.0 |
| 2014-07-30 15:30:00 | ES | Futures | 2048.17 | 2050.51 | 2048.17 | 2048.43 | 98958.0 |
| 2014-07-30 16:00:00 | ES | Futures | 2048.69 | 2048.95 | 2047.38 | 2048.95 | 75983.0 |
| 2014-07-30 16:30:00 | ES | Futures | 2048.69 | 2048.69 | 2047.9 | 2048.69 | 8279.0 |
| 2014-07-30 17:00:00 | ES | Futures | 2048.69 | 2048.95 | 2048.43 | 2048.69 | 2751.0 |
| 2014-07-30 18:00:00 | ES | Futures | 2048.43 | 2048.95 | 2047.64 | 2048.17 | 2491.0 |
| 2014-07-30 18:30:00 | ES | Futures | 2048.17 | 2048.43 | 2048.17 | 2048.17 | 439.0 |
| 2014-07-30 19:00:00 | ES | Futures | 2048.17 | 2048.43 | 2047.9 | 2047.9 | 393.0 |
| 2014-07-30 19:30:00 | ES | Futures | 2047.9 | 2048.17 | 2047.12 | 2047.38 | 688.0 |
| 2014-07-30 20:00:00 | ES | Futures | 2047.12 | 2047.38 | 2046.34 | 2046.6 | 2827.0 |
| 2014-07-30 20:30:00 | ES | Futures | 2046.6 | 2047.64 | 2046.6 | 2047.38 | 1344.0 |
| 2014-07-30 21:00:00 | ES | Futures | 2047.12 | 2047.38 | 2046.86 | 2047.12 | 1233.0 |
| 2014-07-30 21:30:00 | ES | Futures | 2046.86 | 2047.9 | 2046.86 | 2047.38 | 2716.0 |
| 2014-07-30 22:00:00 | ES | Futures | 2047.12 | 2047.38 | 2046.86 | 2047.12 | 883.0 |
| 2014-07-30 22:30:00 | ES | Futures | 2047.38 | 2047.38 | 2046.08 | 2046.08 | 2183.0 |
| 2014-07-30 23:00:00 | ES | Futures | 2046.08 | 2046.08 | 2044.78 | 2045.82 | 2468.0 |
| 2014-07-30 23:30:00 | ES | Futures | 2045.82 | 2046.34 | 2045.3 | 2046.08 | 2049.0 |
| 2014-07-30 00:00:00 | NQ | Futures | 4625.22 | 4625.51 | 4624.05 | 4625.51 | 68.0 |
| 2014-07-30 00:30:00 | NQ | Futures | 4625.51 | 4626.1 | 4625.22 | 4625.22 | 99.0 |
| 2014-07-30 01:00:00 | NQ | Futures | 4624.93 | 4626.39 | 4624.64 | 4626.39 | 173.0 |
> showing 50 of 2,844 rows — these rows as CSV