PREVIEW / futures_30min / 2013-10-27
file: by_date/futures_30min/2013/2013-10-27.parquet size: 19 KB rows: 485
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-10-27 18:00:00 | ES | Futures | 1809.59 | 1810.62 | 1809.08 | 1809.85 | 2396.0 |
| 2013-10-27 18:30:00 | ES | Futures | 1809.85 | 1810.37 | 1808.56 | 1808.56 | 1460.0 |
| 2013-10-27 19:00:00 | ES | Futures | 1808.56 | 1809.33 | 1808.56 | 1808.56 | 1060.0 |
| 2013-10-27 19:30:00 | ES | Futures | 1808.56 | 1815.27 | 1808.56 | 1814.24 | 9213.0 |
| 2013-10-27 20:00:00 | ES | Futures | 1814.24 | 1814.75 | 1812.95 | 1814.24 | 4667.0 |
| 2013-10-27 20:30:00 | ES | Futures | 1813.98 | 1814.75 | 1813.72 | 1814.75 | 2494.0 |
| 2013-10-27 21:00:00 | ES | Futures | 1814.49 | 1815.78 | 1814.24 | 1815.53 | 4165.0 |
| 2013-10-27 21:30:00 | ES | Futures | 1815.53 | 1818.36 | 1815.01 | 1816.3 | 10904.0 |
| 2013-10-27 22:00:00 | ES | Futures | 1816.04 | 1816.56 | 1815.78 | 1816.3 | 2189.0 |
| 2013-10-27 22:30:00 | ES | Futures | 1816.04 | 1817.07 | 1815.78 | 1816.82 | 1629.0 |
| 2013-10-27 23:00:00 | ES | Futures | 1816.82 | 1816.82 | 1815.78 | 1816.04 | 747.0 |
| 2013-10-27 23:30:00 | ES | Futures | 1816.04 | 1817.07 | 1815.27 | 1815.53 | 1809.0 |
| 2013-10-27 18:00:00 | NQ | Futures | 3919.97 | 3921.71 | 3917.93 | 3921.71 | 271.0 |
| 2013-10-27 18:30:00 | NQ | Futures | 3921.71 | 3922.58 | 3917.64 | 3918.22 | 321.0 |
| 2013-10-27 19:00:00 | NQ | Futures | 3918.22 | 3919.1 | 3918.22 | 3918.52 | 70.0 |
| 2013-10-27 19:30:00 | NQ | Futures | 3918.81 | 3931.58 | 3918.81 | 3929.55 | 1029.0 |
| 2013-10-27 20:00:00 | NQ | Futures | 3929.84 | 3930.13 | 3926.65 | 3928.97 | 626.0 |
| 2013-10-27 20:30:00 | NQ | Futures | 3928.97 | 3930.71 | 3927.52 | 3930.42 | 446.0 |
| 2013-10-27 21:00:00 | NQ | Futures | 3930.71 | 3933.04 | 3929.26 | 3931.88 | 472.0 |
| 2013-10-27 21:30:00 | NQ | Futures | 3932.17 | 3937.68 | 3931.0 | 3933.91 | 1351.0 |
| 2013-10-27 22:00:00 | NQ | Futures | 3933.62 | 3935.07 | 3933.33 | 3934.49 | 448.0 |
| 2013-10-27 22:30:00 | NQ | Futures | 3934.49 | 3936.23 | 3933.91 | 3934.78 | 327.0 |
| 2013-10-27 23:00:00 | NQ | Futures | 3934.49 | 3934.78 | 3933.91 | 3934.78 | 159.0 |
| 2013-10-27 23:30:00 | NQ | Futures | 3934.49 | 3935.65 | 3933.04 | 3933.33 | 314.0 |
| 2013-10-27 18:00:00 | YM | Futures | 15822.2 | 15837.5 | 15819.1 | 15836.5 | 278.0 |
| 2013-10-27 18:30:00 | YM | Futures | 15834.4 | 15836.5 | 15827.3 | 15828.3 | 173.0 |
| 2013-10-27 19:00:00 | YM | Futures | 15827.3 | 15828.3 | 15824.2 | 15827.3 | 91.0 |
| 2013-10-27 19:30:00 | YM | Futures | 15828.3 | 15884.5 | 15826.3 | 15879.4 | 1795.0 |
| 2013-10-27 20:00:00 | YM | Futures | 15878.3 | 15882.4 | 15863.0 | 15871.2 | 978.0 |
| 2013-10-27 20:30:00 | YM | Futures | 15871.2 | 15879.4 | 15868.1 | 15874.3 | 479.0 |
| 2013-10-27 21:00:00 | YM | Futures | 15875.3 | 15883.5 | 15871.2 | 15880.4 | 489.0 |
| 2013-10-27 21:30:00 | YM | Futures | 15881.4 | 15904.9 | 15876.3 | 15888.6 | 1938.0 |
| 2013-10-27 22:00:00 | YM | Futures | 15888.6 | 15892.6 | 15883.5 | 15888.6 | 707.0 |
| 2013-10-27 22:30:00 | YM | Futures | 15887.5 | 15896.7 | 15886.5 | 15891.6 | 268.0 |
| 2013-10-27 23:00:00 | YM | Futures | 15893.7 | 15893.7 | 15885.5 | 15891.6 | 120.0 |
| 2013-10-27 23:30:00 | YM | Futures | 15891.6 | 15894.7 | 15883.5 | 15885.5 | 365.0 |
| 2013-10-27 18:00:00 | CL | Futures | 155.52 | 155.52 | 154.93 | 155.11 | 745.0 |
| 2013-10-27 18:30:00 | CL | Futures | 155.09 | 155.14 | 155.01 | 155.13 | 171.0 |
| 2013-10-27 19:00:00 | CL | Futures | 155.11 | 155.16 | 155.06 | 155.08 | 196.0 |
| 2013-10-27 19:30:00 | CL | Futures | 155.08 | 155.14 | 154.95 | 154.97 | 249.0 |
| 2013-10-27 20:00:00 | CL | Futures | 154.95 | 155.11 | 154.95 | 155.09 | 202.0 |
| 2013-10-27 20:30:00 | CL | Futures | 155.09 | 155.11 | 155.0 | 155.09 | 149.0 |
| 2013-10-27 21:00:00 | CL | Futures | 155.09 | 155.33 | 155.08 | 155.2 | 640.0 |
| 2013-10-27 21:30:00 | CL | Futures | 155.22 | 155.33 | 155.19 | 155.25 | 290.0 |
| 2013-10-27 22:00:00 | CL | Futures | 155.24 | 155.27 | 155.19 | 155.2 | 121.0 |
| 2013-10-27 22:30:00 | CL | Futures | 155.19 | 155.25 | 155.09 | 155.19 | 158.0 |
| 2013-10-27 23:00:00 | CL | Futures | 155.2 | 155.24 | 155.16 | 155.19 | 103.0 |
| 2013-10-27 23:30:00 | CL | Futures | 155.19 | 155.22 | 155.16 | 155.16 | 44.0 |
| 2013-10-27 18:00:00 | GC | Futures | 1854.2 | 1856.7 | 1852.5 | 1855.6 | 737.0 |
| 2013-10-27 18:30:00 | GC | Futures | 1855.3 | 1855.9 | 1851.4 | 1852.5 | 569.0 |
> showing 50 of 485 rows — these rows as CSV