PREVIEW / futures_1hour / 2010-03-14
file: by_date/futures_1hour/2010/2010-03-14.parquet size: 13 KB rows: 228
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 |
|---|---|---|---|---|---|---|---|
| 2010-03-14 18:00:00 | ES | Futures | 1120.45 | 1120.94 | 1119.23 | 1120.45 | 3408.0 |
| 2010-03-14 19:00:00 | ES | Futures | 1120.21 | 1120.45 | 1119.47 | 1120.21 | 1603.0 |
| 2010-03-14 20:00:00 | ES | Futures | 1120.21 | 1120.21 | 1117.76 | 1117.76 | 2916.0 |
| 2010-03-14 21:00:00 | ES | Futures | 1118.01 | 1118.01 | 1115.56 | 1115.81 | 8773.0 |
| 2010-03-14 22:00:00 | ES | Futures | 1115.81 | 1116.29 | 1114.83 | 1115.56 | 6703.0 |
| 2010-03-14 23:00:00 | ES | Futures | 1115.32 | 1116.29 | 1115.07 | 1115.81 | 1951.0 |
| 2010-03-14 18:00:00 | NQ | Futures | 2200.49 | 2201.92 | 2199.34 | 2201.35 | 111.0 |
| 2010-03-14 19:00:00 | NQ | Futures | 2201.35 | 2202.21 | 2200.77 | 2201.92 | 204.0 |
| 2010-03-14 20:00:00 | NQ | Futures | 2202.21 | 2202.21 | 2198.2 | 2198.2 | 192.0 |
| 2010-03-14 21:00:00 | NQ | Futures | 2197.91 | 2197.91 | 2195.33 | 2195.62 | 490.0 |
| 2010-03-14 22:00:00 | NQ | Futures | 2195.62 | 2196.48 | 2193.9 | 2194.19 | 643.0 |
| 2010-03-14 23:00:00 | NQ | Futures | 2194.19 | 2195.91 | 2194.19 | 2195.33 | 248.0 |
| 2010-03-14 18:00:00 | YM | Futures | 9948.0 | 9948.0 | 9934.9 | 9941.5 | 81.0 |
| 2010-03-14 19:00:00 | YM | Futures | 9941.5 | 9945.2 | 9934.9 | 9939.6 | 106.0 |
| 2010-03-14 20:00:00 | YM | Futures | 9941.5 | 9941.5 | 9924.5 | 9924.5 | 156.0 |
| 2010-03-14 21:00:00 | YM | Futures | 9924.5 | 9924.5 | 9905.7 | 9907.6 | 518.0 |
| 2010-03-14 22:00:00 | YM | Futures | 9907.6 | 9914.2 | 9901.9 | 9907.6 | 213.0 |
| 2010-03-14 23:00:00 | YM | Futures | 9906.6 | 9913.2 | 9905.7 | 9908.5 | 190.0 |
| 2010-03-14 18:00:00 | CL | Futures | 172.52 | 172.52 | 171.97 | 172.33 | 85.0 |
| 2010-03-14 19:00:00 | CL | Futures | 172.37 | 172.59 | 171.65 | 171.93 | 148.0 |
| 2010-03-14 20:00:00 | CL | Futures | 171.97 | 172.18 | 171.78 | 172.06 | 167.0 |
| 2010-03-14 21:00:00 | CL | Futures | 172.04 | 172.1 | 171.68 | 171.76 | 167.0 |
| 2010-03-14 22:00:00 | CL | Futures | 171.76 | 171.82 | 171.55 | 171.72 | 113.0 |
| 2010-03-14 23:00:00 | CL | Futures | 171.72 | 171.76 | 171.61 | 171.65 | 95.0 |
| 2010-03-14 18:00:00 | GC | Futures | 1551.0 | 1554.0 | 1550.1 | 1553.4 | 1149.0 |
| 2010-03-14 19:00:00 | GC | Futures | 1553.4 | 1555.4 | 1552.3 | 1555.4 | 1015.0 |
| 2010-03-14 20:00:00 | GC | Futures | 1555.1 | 1556.1 | 1552.4 | 1553.0 | 1366.0 |
| 2010-03-14 21:00:00 | GC | Futures | 1553.2 | 1555.0 | 1552.9 | 1554.4 | 1152.0 |
| 2010-03-14 22:00:00 | GC | Futures | 1554.4 | 1555.4 | 1553.3 | 1555.4 | 907.0 |
| 2010-03-14 23:00:00 | GC | Futures | 1555.1 | 1555.8 | 1554.3 | 1555.5 | 953.0 |
| 2010-03-14 18:00:00 | ZN | Futures | 96.126294 | 96.126294 | 96.087751 | 96.087751 | 1719.0 |
| 2010-03-14 19:00:00 | ZN | Futures | 96.087751 | 96.100598 | 96.062055 | 96.074903 | 1835.0 |
| 2010-03-14 20:00:00 | ZN | Futures | 96.087751 | 96.113446 | 96.023512 | 96.049208 | 4999.0 |
| 2010-03-14 21:00:00 | ZN | Futures | 96.049208 | 96.087751 | 96.049208 | 96.074903 | 3998.0 |
| 2010-03-14 22:00:00 | ZN | Futures | 96.087751 | 96.126294 | 96.074903 | 96.113446 | 3900.0 |
| 2010-03-14 23:00:00 | ZN | Futures | 96.113446 | 96.151989 | 96.100598 | 96.126294 | 5743.0 |
> showing 36 of 228 rows — these rows as CSV