PREVIEW / futures_1hour / 2009-05-10
file: by_date/futures_1hour/2009/2009-05-10.parquet size: 13 KB rows: 235
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-10 18:00:00 | ES | Futures | 882.81 | 882.81 | 879.7 | 881.13 | 5052.0 |
| 2009-05-10 19:00:00 | ES | Futures | 881.13 | 884.73 | 880.65 | 882.33 | 4649.0 |
| 2009-05-10 20:00:00 | ES | Futures | 882.57 | 883.05 | 879.22 | 879.94 | 4519.0 |
| 2009-05-10 21:00:00 | ES | Futures | 879.7 | 880.89 | 878.26 | 878.5 | 4772.0 |
| 2009-05-10 22:00:00 | ES | Futures | 878.74 | 881.85 | 878.5 | 879.46 | 4812.0 |
| 2009-05-10 23:00:00 | ES | Futures | 879.22 | 880.65 | 878.02 | 878.5 | 3562.0 |
| 2009-05-10 18:00:00 | NQ | Futures | 1576.41 | 1576.41 | 1567.6 | 1569.59 | 584.0 |
| 2009-05-10 19:00:00 | NQ | Futures | 1569.3 | 1575.84 | 1569.02 | 1573.0 | 468.0 |
| 2009-05-10 20:00:00 | NQ | Futures | 1571.29 | 1572.43 | 1565.04 | 1566.75 | 150.0 |
| 2009-05-10 21:00:00 | NQ | Futures | 1566.75 | 1567.32 | 1563.91 | 1563.91 | 574.0 |
| 2009-05-10 22:00:00 | NQ | Futures | 1564.47 | 1569.3 | 1563.91 | 1566.18 | 388.0 |
| 2009-05-10 23:00:00 | NQ | Futures | 1566.18 | 1568.45 | 1565.89 | 1565.89 | 483.0 |
| 2009-05-10 18:00:00 | YM | Futures | 7807.4 | 7807.4 | 7774.3 | 7785.3 | 276.0 |
| 2009-05-10 19:00:00 | YM | Futures | 7785.3 | 7818.4 | 7781.7 | 7797.3 | 220.0 |
| 2009-05-10 20:00:00 | YM | Futures | 7798.2 | 7802.8 | 7772.5 | 7777.1 | 312.0 |
| 2009-05-10 21:00:00 | YM | Futures | 7778.9 | 7788.1 | 7767.0 | 7767.9 | 263.0 |
| 2009-05-10 22:00:00 | YM | Futures | 7769.7 | 7803.7 | 7769.7 | 7775.2 | 497.0 |
| 2009-05-10 23:00:00 | YM | Futures | 7774.3 | 7784.4 | 7766.0 | 7771.6 | 316.0 |
| 2009-05-10 18:00:00 | CL | Futures | 141.967 | 141.967 | 141.093 | 141.336 | 593.0 |
| 2009-05-10 19:00:00 | CL | Futures | 141.311 | 142.234 | 141.044 | 141.578 | 515.0 |
| 2009-05-10 20:00:00 | CL | Futures | 141.554 | 142.161 | 141.36 | 141.821 | 611.0 |
| 2009-05-10 21:00:00 | CL | Futures | 141.748 | 142.039 | 141.214 | 141.214 | 494.0 |
| 2009-05-10 22:00:00 | CL | Futures | 141.19 | 141.384 | 140.826 | 141.336 | 651.0 |
| 2009-05-10 23:00:00 | CL | Futures | 141.287 | 141.384 | 140.656 | 140.802 | 403.0 |
| 2009-05-10 18:00:00 | GC | Futures | 1301.3 | 1301.9 | 1297.9 | 1300.5 | 487.0 |
| 2009-05-10 19:00:00 | GC | Futures | 1300.3 | 1303.2 | 1296.4 | 1303.2 | 413.0 |
| 2009-05-10 20:00:00 | GC | Futures | 1303.2 | 1303.3 | 1299.1 | 1299.8 | 829.0 |
| 2009-05-10 21:00:00 | GC | Futures | 1299.6 | 1300.6 | 1296.8 | 1296.8 | 508.0 |
| 2009-05-10 22:00:00 | GC | Futures | 1297.2 | 1298.6 | 1296.5 | 1297.2 | 328.0 |
| 2009-05-10 23:00:00 | GC | Futures | 1297.5 | 1301.5 | 1297.5 | 1299.6 | 443.0 |
| 2009-05-10 18:00:00 | ZN | Futures | 94.100347 | 94.185815 | 94.088138 | 94.161396 | 780.0 |
| 2009-05-10 19:00:00 | ZN | Futures | 94.161396 | 94.173606 | 94.112557 | 94.136976 | 1038.0 |
| 2009-05-10 20:00:00 | ZN | Futures | 94.136976 | 94.222445 | 94.136976 | 94.210235 | 1583.0 |
| 2009-05-10 21:00:00 | ZN | Futures | 94.210235 | 94.234654 | 94.210235 | 94.234654 | 1686.0 |
| 2009-05-10 22:00:00 | ZN | Futures | 94.234654 | 94.246864 | 94.210235 | 94.234654 | 848.0 |
| 2009-05-10 23:00:00 | ZN | Futures | 94.246864 | 94.259074 | 94.234654 | 94.259074 | 1215.0 |
> showing 36 of 235 rows — these rows as CSV