PREVIEW / futures_30min / 2013-11-03
file: by_date/futures_30min/2013/2013-11-03.parquet size: 19 KB rows: 513
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-11-03 18:00:00 | ES | Futures | 1809.85 | 1811.4 | 1809.08 | 1810.62 | 4114.0 |
| 2013-11-03 18:30:00 | ES | Futures | 1810.62 | 1811.14 | 1810.37 | 1810.62 | 1145.0 |
| 2013-11-03 19:00:00 | ES | Futures | 1810.62 | 1811.4 | 1810.37 | 1811.14 | 992.0 |
| 2013-11-03 19:30:00 | ES | Futures | 1811.4 | 1812.95 | 1811.4 | 1812.95 | 2297.0 |
| 2013-11-03 20:00:00 | ES | Futures | 1812.95 | 1813.98 | 1812.43 | 1813.46 | 3016.0 |
| 2013-11-03 20:30:00 | ES | Futures | 1813.46 | 1815.01 | 1812.95 | 1814.75 | 4561.0 |
| 2013-11-03 21:00:00 | ES | Futures | 1815.01 | 1816.56 | 1814.75 | 1816.56 | 4994.0 |
| 2013-11-03 21:30:00 | ES | Futures | 1816.56 | 1816.82 | 1814.49 | 1815.01 | 3270.0 |
| 2013-11-03 22:00:00 | ES | Futures | 1815.01 | 1815.27 | 1813.2 | 1813.2 | 4179.0 |
| 2013-11-03 22:30:00 | ES | Futures | 1813.46 | 1814.75 | 1813.2 | 1814.75 | 1546.0 |
| 2013-11-03 23:00:00 | ES | Futures | 1814.75 | 1815.01 | 1814.49 | 1814.75 | 349.0 |
| 2013-11-03 23:30:00 | ES | Futures | 1814.49 | 1815.01 | 1814.49 | 1814.75 | 1001.0 |
| 2013-11-03 18:00:00 | NQ | Futures | 3912.71 | 3914.16 | 3911.25 | 3913.58 | 377.0 |
| 2013-11-03 18:30:00 | NQ | Futures | 3913.29 | 3914.45 | 3913.0 | 3913.87 | 92.0 |
| 2013-11-03 19:00:00 | NQ | Futures | 3913.58 | 3913.87 | 3912.71 | 3913.87 | 177.0 |
| 2013-11-03 19:30:00 | NQ | Futures | 3914.16 | 3917.35 | 3914.16 | 3917.35 | 265.0 |
| 2013-11-03 20:00:00 | NQ | Futures | 3917.64 | 3919.97 | 3917.06 | 3918.81 | 348.0 |
| 2013-11-03 20:30:00 | NQ | Futures | 3919.1 | 3922.0 | 3918.52 | 3922.0 | 387.0 |
| 2013-11-03 21:00:00 | NQ | Futures | 3922.0 | 3925.78 | 3921.71 | 3924.9 | 406.0 |
| 2013-11-03 21:30:00 | NQ | Futures | 3925.2 | 3925.49 | 3921.13 | 3921.42 | 251.0 |
| 2013-11-03 22:00:00 | NQ | Futures | 3921.42 | 3922.29 | 3918.81 | 3918.81 | 334.0 |
| 2013-11-03 22:30:00 | NQ | Futures | 3918.81 | 3921.71 | 3918.81 | 3921.71 | 113.0 |
| 2013-11-03 23:00:00 | NQ | Futures | 3921.42 | 3922.58 | 3921.42 | 3922.29 | 54.0 |
| 2013-11-03 23:30:00 | NQ | Futures | 3922.29 | 3923.16 | 3922.0 | 3922.58 | 118.0 |
| 2013-11-03 18:00:00 | YM | Futures | 15870.2 | 15881.4 | 15864.1 | 15876.3 | 406.0 |
| 2013-11-03 18:30:00 | YM | Futures | 15877.3 | 15880.4 | 15875.3 | 15879.4 | 263.0 |
| 2013-11-03 19:00:00 | YM | Futures | 15877.3 | 15881.4 | 15877.3 | 15881.4 | 382.0 |
| 2013-11-03 19:30:00 | YM | Futures | 15882.4 | 15894.7 | 15882.4 | 15894.7 | 379.0 |
| 2013-11-03 20:00:00 | YM | Futures | 15894.7 | 15901.8 | 15890.6 | 15898.8 | 469.0 |
| 2013-11-03 20:30:00 | YM | Futures | 15898.8 | 15910.0 | 15895.7 | 15909.0 | 541.0 |
| 2013-11-03 21:00:00 | YM | Futures | 15910.0 | 15925.3 | 15910.0 | 15921.2 | 876.0 |
| 2013-11-03 21:30:00 | YM | Futures | 15922.3 | 15925.3 | 15908.0 | 15911.0 | 723.0 |
| 2013-11-03 22:00:00 | YM | Futures | 15911.0 | 15912.1 | 15898.8 | 15898.8 | 564.0 |
| 2013-11-03 22:30:00 | YM | Futures | 15899.8 | 15909.0 | 15899.8 | 15908.0 | 244.0 |
| 2013-11-03 23:00:00 | YM | Futures | 15909.0 | 15911.0 | 15906.9 | 15908.0 | 28.0 |
| 2013-11-03 23:30:00 | YM | Futures | 15908.0 | 15911.0 | 15906.9 | 15909.0 | 61.0 |
| 2013-11-03 18:00:00 | CL | Futures | 150.18 | 150.41 | 150.07 | 150.18 | 923.0 |
| 2013-11-03 18:30:00 | CL | Futures | 150.2 | 150.26 | 150.1 | 150.2 | 168.0 |
| 2013-11-03 19:00:00 | CL | Futures | 150.2 | 150.26 | 150.17 | 150.22 | 199.0 |
| 2013-11-03 19:30:00 | CL | Futures | 150.23 | 150.34 | 150.22 | 150.28 | 375.0 |
| 2013-11-03 20:00:00 | CL | Futures | 150.26 | 150.47 | 150.26 | 150.41 | 429.0 |
| 2013-11-03 20:30:00 | CL | Futures | 150.41 | 150.52 | 150.33 | 150.5 | 332.0 |
| 2013-11-03 21:00:00 | CL | Futures | 150.5 | 150.5 | 150.37 | 150.39 | 411.0 |
| 2013-11-03 21:30:00 | CL | Futures | 150.39 | 150.5 | 150.36 | 150.49 | 175.0 |
| 2013-11-03 22:00:00 | CL | Futures | 150.47 | 150.5 | 150.3 | 150.36 | 348.0 |
| 2013-11-03 22:30:00 | CL | Futures | 150.34 | 150.36 | 150.28 | 150.31 | 136.0 |
| 2013-11-03 23:00:00 | CL | Futures | 150.3 | 150.34 | 150.07 | 150.15 | 491.0 |
| 2013-11-03 23:30:00 | CL | Futures | 150.14 | 150.26 | 150.14 | 150.22 | 214.0 |
| 2013-11-03 18:00:00 | GC | Futures | 1799.8 | 1803.2 | 1799.4 | 1802.6 | 837.0 |
| 2013-11-03 18:30:00 | GC | Futures | 1802.7 | 1803.7 | 1800.8 | 1800.9 | 256.0 |
> showing 50 of 513 rows — these rows as CSV