PREVIEW / futures_30min / 2013-12-01
file: by_date/futures_30min/2013/2013-12-01.parquet size: 20 KB rows: 499
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 |
|---|---|---|---|---|---|---|---|
| 2013-12-01 18:00:00 | ES | Futures | 1863.76 | 1865.31 | 1862.99 | 1865.05 | 9001.0 |
| 2013-12-01 18:30:00 | ES | Futures | 1864.8 | 1865.31 | 1862.99 | 1863.25 | 2352.0 |
| 2013-12-01 19:00:00 | ES | Futures | 1862.99 | 1864.54 | 1862.73 | 1864.02 | 2771.0 |
| 2013-12-01 19:30:00 | ES | Futures | 1864.02 | 1864.28 | 1862.99 | 1863.25 | 1688.0 |
| 2013-12-01 20:00:00 | ES | Futures | 1863.51 | 1863.76 | 1862.73 | 1862.73 | 2389.0 |
| 2013-12-01 20:30:00 | ES | Futures | 1862.73 | 1863.76 | 1862.47 | 1863.25 | 2093.0 |
| 2013-12-01 21:00:00 | ES | Futures | 1863.51 | 1864.28 | 1862.99 | 1863.51 | 2309.0 |
| 2013-12-01 21:30:00 | ES | Futures | 1863.51 | 1864.28 | 1863.25 | 1864.02 | 1300.0 |
| 2013-12-01 22:00:00 | ES | Futures | 1864.02 | 1864.02 | 1863.25 | 1863.25 | 1190.0 |
| 2013-12-01 22:30:00 | ES | Futures | 1863.25 | 1863.25 | 1862.47 | 1862.99 | 1453.0 |
| 2013-12-01 23:00:00 | ES | Futures | 1862.99 | 1862.99 | 1862.47 | 1862.47 | 1051.0 |
| 2013-12-01 23:30:00 | ES | Futures | 1862.73 | 1862.73 | 1862.22 | 1862.22 | 1275.0 |
| 2013-12-01 18:00:00 | NQ | Futures | 4057.92 | 4061.12 | 4057.05 | 4060.25 | 956.0 |
| 2013-12-01 18:30:00 | NQ | Futures | 4060.25 | 4060.83 | 4056.76 | 4056.76 | 431.0 |
| 2013-12-01 19:00:00 | NQ | Futures | 4056.76 | 4059.67 | 4055.6 | 4058.5 | 838.0 |
| 2013-12-01 19:30:00 | NQ | Futures | 4058.5 | 4058.79 | 4057.05 | 4057.63 | 176.0 |
| 2013-12-01 20:00:00 | NQ | Futures | 4057.63 | 4058.5 | 4056.18 | 4057.92 | 428.0 |
| 2013-12-01 20:30:00 | NQ | Futures | 4057.92 | 4059.67 | 4056.76 | 4058.79 | 533.0 |
| 2013-12-01 21:00:00 | NQ | Futures | 4058.79 | 4060.54 | 4058.5 | 4059.38 | 762.0 |
| 2013-12-01 21:30:00 | NQ | Futures | 4059.38 | 4060.25 | 4058.79 | 4060.25 | 383.0 |
| 2013-12-01 22:00:00 | NQ | Futures | 4060.25 | 4060.83 | 4059.38 | 4059.96 | 451.0 |
| 2013-12-01 22:30:00 | NQ | Futures | 4059.67 | 4059.67 | 4057.63 | 4058.79 | 357.0 |
| 2013-12-01 23:00:00 | NQ | Futures | 4059.08 | 4059.38 | 4057.92 | 4058.5 | 79.0 |
| 2013-12-01 23:30:00 | NQ | Futures | 4058.21 | 4058.5 | 4057.34 | 4057.63 | 231.0 |
| 2013-12-01 18:00:00 | YM | Futures | 16438.0 | 16448.2 | 16431.9 | 16447.2 | 655.0 |
| 2013-12-01 18:30:00 | YM | Futures | 16448.2 | 16448.2 | 16432.9 | 16433.9 | 262.0 |
| 2013-12-01 19:00:00 | YM | Futures | 16434.9 | 16447.2 | 16432.9 | 16443.1 | 443.0 |
| 2013-12-01 19:30:00 | YM | Futures | 16443.1 | 16445.1 | 16436.0 | 16438.0 | 309.0 |
| 2013-12-01 20:00:00 | YM | Futures | 16437.0 | 16439.0 | 16431.9 | 16433.9 | 287.0 |
| 2013-12-01 20:30:00 | YM | Futures | 16433.9 | 16441.1 | 16431.9 | 16440.0 | 578.0 |
| 2013-12-01 21:00:00 | YM | Futures | 16439.0 | 16445.1 | 16434.9 | 16439.0 | 521.0 |
| 2013-12-01 21:30:00 | YM | Futures | 16440.0 | 16442.1 | 16436.0 | 16441.1 | 220.0 |
| 2013-12-01 22:00:00 | YM | Futures | 16441.1 | 16442.1 | 16433.9 | 16437.0 | 326.0 |
| 2013-12-01 22:30:00 | YM | Futures | 16437.0 | 16437.0 | 16428.8 | 16432.9 | 177.0 |
| 2013-12-01 23:00:00 | YM | Futures | 16433.9 | 16433.9 | 16428.8 | 16428.8 | 123.0 |
| 2013-12-01 23:30:00 | YM | Futures | 16429.8 | 16429.8 | 16426.8 | 16427.8 | 153.0 |
| 2013-12-01 18:00:00 | CL | Futures | 146.51 | 146.63 | 146.39 | 146.58 | 895.0 |
| 2013-12-01 18:30:00 | CL | Futures | 146.57 | 146.7 | 146.57 | 146.65 | 246.0 |
| 2013-12-01 19:00:00 | CL | Futures | 146.63 | 147.28 | 146.63 | 147.17 | 1177.0 |
| 2013-12-01 19:30:00 | CL | Futures | 147.19 | 147.26 | 146.92 | 147.07 | 429.0 |
| 2013-12-01 20:00:00 | CL | Futures | 147.07 | 147.14 | 146.95 | 147.06 | 459.0 |
| 2013-12-01 20:30:00 | CL | Futures | 147.06 | 147.22 | 147.01 | 147.15 | 322.0 |
| 2013-12-01 21:00:00 | CL | Futures | 147.19 | 147.45 | 147.15 | 147.33 | 699.0 |
| 2013-12-01 21:30:00 | CL | Futures | 147.33 | 147.34 | 147.25 | 147.25 | 149.0 |
| 2013-12-01 22:00:00 | CL | Futures | 147.25 | 147.31 | 147.15 | 147.3 | 223.0 |
| 2013-12-01 22:30:00 | CL | Futures | 147.26 | 147.39 | 147.19 | 147.28 | 270.0 |
| 2013-12-01 23:00:00 | CL | Futures | 147.28 | 147.39 | 147.26 | 147.33 | 137.0 |
| 2013-12-01 23:30:00 | CL | Futures | 147.3 | 147.44 | 147.22 | 147.22 | 247.0 |
| 2013-12-01 18:00:00 | GC | Futures | 1714.3 | 1715.1 | 1710.0 | 1710.6 | 1111.0 |
| 2013-12-01 18:30:00 | GC | Futures | 1710.7 | 1710.9 | 1709.6 | 1710.2 | 373.0 |
> showing 50 of 499 rows — these rows as CSV