PREVIEW / futures_1hour / 2013-11-03
file: by_date/futures_1hour/2013/2013-11-03.parquet size: 14 KB rows: 276
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 | 5259.0 |
| 2013-11-03 19:00:00 | ES | Futures | 1810.62 | 1812.95 | 1810.37 | 1812.95 | 3289.0 |
| 2013-11-03 20:00:00 | ES | Futures | 1812.95 | 1815.01 | 1812.43 | 1814.75 | 7577.0 |
| 2013-11-03 21:00:00 | ES | Futures | 1815.01 | 1816.82 | 1814.49 | 1815.01 | 8264.0 |
| 2013-11-03 22:00:00 | ES | Futures | 1815.01 | 1815.27 | 1813.2 | 1814.75 | 5725.0 |
| 2013-11-03 23:00:00 | ES | Futures | 1814.75 | 1815.01 | 1814.49 | 1814.75 | 1350.0 |
| 2013-11-03 18:00:00 | NQ | Futures | 3912.71 | 3914.45 | 3911.25 | 3913.87 | 469.0 |
| 2013-11-03 19:00:00 | NQ | Futures | 3913.58 | 3917.35 | 3912.71 | 3917.35 | 442.0 |
| 2013-11-03 20:00:00 | NQ | Futures | 3917.64 | 3922.0 | 3917.06 | 3922.0 | 735.0 |
| 2013-11-03 21:00:00 | NQ | Futures | 3922.0 | 3925.78 | 3921.13 | 3921.42 | 657.0 |
| 2013-11-03 22:00:00 | NQ | Futures | 3921.42 | 3922.29 | 3918.81 | 3921.71 | 447.0 |
| 2013-11-03 23:00:00 | NQ | Futures | 3921.42 | 3923.16 | 3921.42 | 3922.58 | 172.0 |
| 2013-11-03 18:00:00 | YM | Futures | 15870.2 | 15881.4 | 15864.1 | 15879.4 | 669.0 |
| 2013-11-03 19:00:00 | YM | Futures | 15877.3 | 15894.7 | 15877.3 | 15894.7 | 761.0 |
| 2013-11-03 20:00:00 | YM | Futures | 15894.7 | 15910.0 | 15890.6 | 15909.0 | 1010.0 |
| 2013-11-03 21:00:00 | YM | Futures | 15910.0 | 15925.3 | 15908.0 | 15911.0 | 1599.0 |
| 2013-11-03 22:00:00 | YM | Futures | 15911.0 | 15912.1 | 15898.8 | 15908.0 | 808.0 |
| 2013-11-03 23:00:00 | YM | Futures | 15909.0 | 15911.0 | 15906.9 | 15909.0 | 89.0 |
| 2013-11-03 18:00:00 | CL | Futures | 150.18 | 150.41 | 150.07 | 150.2 | 1091.0 |
| 2013-11-03 19:00:00 | CL | Futures | 150.2 | 150.34 | 150.17 | 150.28 | 574.0 |
| 2013-11-03 20:00:00 | CL | Futures | 150.26 | 150.52 | 150.26 | 150.5 | 761.0 |
| 2013-11-03 21:00:00 | CL | Futures | 150.5 | 150.5 | 150.36 | 150.49 | 586.0 |
| 2013-11-03 22:00:00 | CL | Futures | 150.47 | 150.5 | 150.28 | 150.31 | 484.0 |
| 2013-11-03 23:00:00 | CL | Futures | 150.3 | 150.34 | 150.07 | 150.22 | 705.0 |
| 2013-11-03 18:00:00 | GC | Futures | 1799.8 | 1803.7 | 1799.4 | 1800.9 | 1093.0 |
| 2013-11-03 19:00:00 | GC | Futures | 1800.8 | 1803.1 | 1800.1 | 1802.3 | 1640.0 |
| 2013-11-03 20:00:00 | GC | Futures | 1802.0 | 1803.1 | 1798.4 | 1802.0 | 2924.0 |
| 2013-11-03 21:00:00 | GC | Futures | 1802.0 | 1803.7 | 1800.0 | 1800.0 | 2074.0 |
| 2013-11-03 22:00:00 | GC | Futures | 1800.0 | 1801.3 | 1797.5 | 1797.6 | 1914.0 |
| 2013-11-03 23:00:00 | GC | Futures | 1797.5 | 1800.4 | 1797.5 | 1799.7 | 787.0 |
| 2013-11-03 18:00:00 | ZN | Futures | 115.800344 | 115.828909 | 115.786062 | 115.786062 | 5965.0 |
| 2013-11-03 19:00:00 | ZN | Futures | 115.800344 | 115.857473 | 115.786062 | 115.828909 | 5512.0 |
| 2013-11-03 20:00:00 | ZN | Futures | 115.828909 | 115.857473 | 115.814627 | 115.828909 | 2944.0 |
| 2013-11-03 21:00:00 | ZN | Futures | 115.843191 | 115.857473 | 115.814627 | 115.828909 | 1955.0 |
| 2013-11-03 22:00:00 | ZN | Futures | 115.843191 | 115.871756 | 115.786062 | 115.871756 | 5957.0 |
| 2013-11-03 23:00:00 | ZN | Futures | 115.857473 | 115.886038 | 115.857473 | 115.871756 | 1700.0 |
> showing 36 of 276 rows — these rows as CSV