PREVIEW / futures_1hour / 2009-05-31
file: by_date/futures_1hour/2009/2009-05-31.parquet size: 13 KB rows: 233
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 |
|---|---|---|---|---|---|---|---|
| 2009-05-31 18:00:00 | ES | Futures | 882.09 | 883.29 | 880.17 | 881.85 | 7146.0 |
| 2009-05-31 19:00:00 | ES | Futures | 881.85 | 882.33 | 879.7 | 879.7 | 3337.0 |
| 2009-05-31 20:00:00 | ES | Futures | 879.7 | 879.94 | 878.5 | 879.22 | 4900.0 |
| 2009-05-31 21:00:00 | ES | Futures | 878.98 | 884.73 | 878.74 | 883.29 | 12767.0 |
| 2009-05-31 22:00:00 | ES | Futures | 883.05 | 885.93 | 883.05 | 884.97 | 7611.0 |
| 2009-05-31 23:00:00 | ES | Futures | 884.97 | 886.65 | 884.49 | 886.17 | 3162.0 |
| 2009-05-31 18:00:00 | NQ | Futures | 1629.83 | 1632.1 | 1628.12 | 1630.39 | 671.0 |
| 2009-05-31 19:00:00 | NQ | Futures | 1630.11 | 1630.68 | 1626.98 | 1627.27 | 277.0 |
| 2009-05-31 20:00:00 | NQ | Futures | 1627.27 | 1628.69 | 1625.28 | 1626.42 | 369.0 |
| 2009-05-31 21:00:00 | NQ | Futures | 1626.42 | 1635.22 | 1625.56 | 1632.38 | 1097.0 |
| 2009-05-31 22:00:00 | NQ | Futures | 1632.38 | 1639.77 | 1632.38 | 1636.65 | 438.0 |
| 2009-05-31 23:00:00 | NQ | Futures | 1636.36 | 1639.49 | 1635.79 | 1638.35 | 162.0 |
| 2009-05-31 18:00:00 | YM | Futures | 7813.8 | 7825.8 | 7806.5 | 7814.7 | 413.0 |
| 2009-05-31 19:00:00 | YM | Futures | 7814.7 | 7819.3 | 7795.4 | 7795.4 | 289.0 |
| 2009-05-31 20:00:00 | YM | Futures | 7794.5 | 7795.4 | 7785.3 | 7789.0 | 360.0 |
| 2009-05-31 21:00:00 | YM | Futures | 7790.9 | 7834.0 | 7790.9 | 7819.3 | 802.0 |
| 2009-05-31 22:00:00 | YM | Futures | 7819.3 | 7843.2 | 7819.3 | 7835.0 | 450.0 |
| 2009-05-31 23:00:00 | YM | Futures | 7835.0 | 7849.7 | 7830.4 | 7846.0 | 199.0 |
| 2009-05-31 18:00:00 | CL | Futures | 158.485 | 159.178 | 158.461 | 158.557 | 534.0 |
| 2009-05-31 19:00:00 | CL | Futures | 158.581 | 158.987 | 158.223 | 158.294 | 295.0 |
| 2009-05-31 20:00:00 | CL | Futures | 158.342 | 158.987 | 158.223 | 158.748 | 183.0 |
| 2009-05-31 21:00:00 | CL | Futures | 158.748 | 159.943 | 158.676 | 159.751 | 1330.0 |
| 2009-05-31 22:00:00 | CL | Futures | 159.751 | 160.062 | 159.56 | 159.799 | 650.0 |
| 2009-05-31 23:00:00 | CL | Futures | 159.823 | 160.062 | 159.465 | 159.943 | 325.0 |
| 2009-05-31 18:00:00 | GC | Futures | 1388.7 | 1390.4 | 1384.3 | 1385.3 | 787.0 |
| 2009-05-31 19:00:00 | GC | Futures | 1385.4 | 1388.3 | 1384.7 | 1385.4 | 456.0 |
| 2009-05-31 20:00:00 | GC | Futures | 1385.6 | 1388.3 | 1385.3 | 1387.9 | 652.0 |
| 2009-05-31 21:00:00 | GC | Futures | 1387.7 | 1394.8 | 1387.6 | 1393.7 | 2441.0 |
| 2009-05-31 22:00:00 | GC | Futures | 1393.5 | 1395.4 | 1393.0 | 1394.1 | 898.0 |
| 2009-05-31 23:00:00 | GC | Futures | 1394.1 | 1394.5 | 1393.7 | 1394.1 | 393.0 |
| 2009-05-31 18:00:00 | ZN | Futures | 92.488664 | 92.525293 | 92.476454 | 92.525293 | 17.0 |
| 2009-05-31 19:00:00 | ZN | Futures | 92.500873 | 92.513083 | 92.500873 | 92.513083 | 132.0 |
| 2009-05-31 20:00:00 | ZN | Futures | 92.525293 | 92.561922 | 92.525293 | 92.561922 | 341.0 |
| 2009-05-31 21:00:00 | ZN | Futures | 92.561922 | 92.561922 | 92.342147 | 92.403196 | 1478.0 |
| 2009-05-31 22:00:00 | ZN | Futures | 92.427615 | 92.452034 | 92.403196 | 92.452034 | 17.0 |
| 2009-05-31 23:00:00 | ZN | Futures | 92.439825 | 92.439825 | 92.378776 | 92.390986 | 39.0 |
> showing 36 of 233 rows — these rows as CSV