PREVIEW / futures_1hour / 2008-04-20
file: by_date/futures_1hour/2008/2008-04-20.parquet size: 13 KB rows: 227
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 |
|---|---|---|---|---|---|---|---|
| 2008-04-20 18:00:00 | ES | Futures | 1293.68 | 1294.15 | 1292.05 | 1292.98 | 5464.0 |
| 2008-04-20 19:00:00 | ES | Futures | 1292.98 | 1294.15 | 1292.98 | 1294.15 | 1101.0 |
| 2008-04-20 20:00:00 | ES | Futures | 1293.91 | 1294.61 | 1293.45 | 1294.15 | 1229.0 |
| 2008-04-20 21:00:00 | ES | Futures | 1294.15 | 1294.61 | 1293.68 | 1294.15 | 941.0 |
| 2008-04-20 22:00:00 | ES | Futures | 1293.91 | 1296.01 | 1293.91 | 1295.31 | 1917.0 |
| 2008-04-20 23:00:00 | ES | Futures | 1295.31 | 1296.24 | 1294.84 | 1295.08 | 802.0 |
| 2008-04-20 18:00:00 | NQ | Futures | 2152.89 | 2156.0 | 2151.19 | 2152.89 | 391.0 |
| 2008-04-20 19:00:00 | NQ | Futures | 2153.46 | 2154.87 | 2152.61 | 2154.02 | 122.0 |
| 2008-04-20 20:00:00 | NQ | Futures | 2153.74 | 2155.44 | 2152.89 | 2154.02 | 36.0 |
| 2008-04-20 21:00:00 | NQ | Futures | 2153.46 | 2154.87 | 2153.46 | 2154.59 | 43.0 |
| 2008-04-20 22:00:00 | NQ | Futures | 2154.59 | 2158.55 | 2154.59 | 2158.27 | 244.0 |
| 2008-04-20 23:00:00 | NQ | Futures | 2158.27 | 2159.68 | 2157.42 | 2157.98 | 105.0 |
| 2008-04-20 18:00:00 | YM | Futures | 11647.1 | 11655.3 | 11639.8 | 11648.0 | 118.0 |
| 2008-04-20 19:00:00 | YM | Futures | 11648.0 | 11658.9 | 11646.2 | 11658.0 | 76.0 |
| 2008-04-20 20:00:00 | YM | Futures | 11653.5 | 11658.9 | 11649.8 | 11657.1 | 146.0 |
| 2008-04-20 21:00:00 | YM | Futures | 11655.3 | 11658.0 | 11652.5 | 11655.3 | 49.0 |
| 2008-04-20 22:00:00 | YM | Futures | 11656.2 | 11667.1 | 11652.5 | 11661.6 | 116.0 |
| 2008-04-20 23:00:00 | YM | Futures | 11664.4 | 11666.2 | 11658.9 | 11659.8 | 96.0 |
| 2008-04-20 18:00:00 | CL | Futures | 443.26 | 443.26 | 441.59 | 442.2 | 343.0 |
| 2008-04-20 19:00:00 | CL | Futures | 442.2 | 442.54 | 441.74 | 441.93 | 185.0 |
| 2008-04-20 20:00:00 | CL | Futures | 441.93 | 442.2 | 441.28 | 441.85 | 313.0 |
| 2008-04-20 21:00:00 | CL | Futures | 441.85 | 442.2 | 441.59 | 442.08 | 161.0 |
| 2008-04-20 22:00:00 | CL | Futures | 441.89 | 442.12 | 441.44 | 441.74 | 212.0 |
| 2008-04-20 23:00:00 | CL | Futures | 441.74 | 441.74 | 441.4 | 441.66 | 143.0 |
| 2008-04-20 18:00:00 | GC | Futures | 1333.1 | 1336.8 | 1333.1 | 1335.7 | 495.0 |
| 2008-04-20 19:00:00 | GC | Futures | 1335.4 | 1338.1 | 1333.6 | 1336.1 | 676.0 |
| 2008-04-20 20:00:00 | GC | Futures | 1336.2 | 1340.9 | 1336.2 | 1340.2 | 1516.0 |
| 2008-04-20 21:00:00 | GC | Futures | 1340.2 | 1341.5 | 1337.8 | 1339.3 | 992.0 |
| 2008-04-20 22:00:00 | GC | Futures | 1339.3 | 1341.2 | 1339.0 | 1339.3 | 471.0 |
| 2008-04-20 23:00:00 | GC | Futures | 1339.3 | 1340.6 | 1338.6 | 1340.4 | 623.0 |
| 2008-04-20 18:00:00 | ZN | Futures | 85.997057 | 86.008619 | 85.962371 | 85.985495 | 2684.0 |
| 2008-04-20 19:00:00 | ZN | Futures | 85.985495 | 86.008619 | 85.881438 | 85.893 | 4090.0 |
| 2008-04-20 20:00:00 | ZN | Futures | 85.904562 | 85.950809 | 85.904562 | 85.950809 | 2014.0 |
| 2008-04-20 21:00:00 | ZN | Futures | 85.950809 | 85.962371 | 85.858314 | 85.893 | 3504.0 |
| 2008-04-20 22:00:00 | ZN | Futures | 85.893 | 85.916124 | 85.881438 | 85.904562 | 1171.0 |
| 2008-04-20 23:00:00 | ZN | Futures | 85.893 | 85.904562 | 85.869876 | 85.904562 | 719.0 |
> showing 36 of 227 rows — these rows as CSV