PREVIEW / futures_1hour / 2008-03-09
file: by_date/futures_1hour/2008/2008-03-09.parquet size: 13 KB rows: 224
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-03-09 18:00:00 | ES | Futures | 1204.95 | 1205.88 | 1200.29 | 1201.45 | 7511.0 |
| 2008-03-09 19:00:00 | ES | Futures | 1201.69 | 1202.85 | 1200.05 | 1202.62 | 4232.0 |
| 2008-03-09 20:00:00 | ES | Futures | 1202.85 | 1203.32 | 1201.69 | 1201.69 | 2637.0 |
| 2008-03-09 21:00:00 | ES | Futures | 1201.69 | 1202.85 | 1200.29 | 1201.69 | 3096.0 |
| 2008-03-09 22:00:00 | ES | Futures | 1201.69 | 1202.39 | 1200.05 | 1200.29 | 1979.0 |
| 2008-03-09 23:00:00 | ES | Futures | 1200.52 | 1201.92 | 1200.52 | 1201.22 | 1505.0 |
| 2008-03-09 18:00:00 | NQ | Futures | 1939.5 | 1939.5 | 1928.72 | 1932.98 | 448.0 |
| 2008-03-09 19:00:00 | NQ | Futures | 1931.84 | 1933.54 | 1930.14 | 1932.12 | 245.0 |
| 2008-03-09 20:00:00 | NQ | Futures | 1932.98 | 1933.83 | 1931.27 | 1931.27 | 108.0 |
| 2008-03-09 21:00:00 | NQ | Futures | 1931.27 | 1934.96 | 1930.14 | 1932.12 | 199.0 |
| 2008-03-09 22:00:00 | NQ | Futures | 1932.12 | 1932.69 | 1930.7 | 1931.27 | 69.0 |
| 2008-03-09 23:00:00 | NQ | Futures | 1930.7 | 1931.27 | 1930.42 | 1930.7 | 17.0 |
| 2008-03-09 18:00:00 | YM | Futures | 10802.0 | 10806.6 | 10755.7 | 10766.6 | 361.0 |
| 2008-03-09 19:00:00 | YM | Futures | 10766.6 | 10773.0 | 10752.1 | 10773.0 | 194.0 |
| 2008-03-09 20:00:00 | YM | Futures | 10774.8 | 10786.6 | 10772.1 | 10774.8 | 243.0 |
| 2008-03-09 21:00:00 | YM | Futures | 10773.0 | 10778.4 | 10762.1 | 10769.3 | 158.0 |
| 2008-03-09 22:00:00 | YM | Futures | 10772.1 | 10772.1 | 10756.6 | 10759.3 | 138.0 |
| 2008-03-09 23:00:00 | YM | Futures | 10759.3 | 10767.5 | 10756.6 | 10765.7 | 91.0 |
| 2008-03-09 18:00:00 | CL | Futures | 393.0 | 394.04 | 391.84 | 393.48 | 462.0 |
| 2008-03-09 19:00:00 | CL | Futures | 393.56 | 394.3 | 393.0 | 393.22 | 240.0 |
| 2008-03-09 20:00:00 | CL | Futures | 393.22 | 393.63 | 391.91 | 392.25 | 312.0 |
| 2008-03-09 21:00:00 | CL | Futures | 392.4 | 392.4 | 391.05 | 391.2 | 489.0 |
| 2008-03-09 22:00:00 | CL | Futures | 391.32 | 392.06 | 391.05 | 391.61 | 265.0 |
| 2008-03-09 23:00:00 | CL | Futures | 391.76 | 392.14 | 391.32 | 391.73 | 130.0 |
| 2008-03-09 18:00:00 | GC | Futures | 1419.8 | 1424.9 | 1419.1 | 1423.9 | 797.0 |
| 2008-03-09 19:00:00 | GC | Futures | 1424.0 | 1425.0 | 1421.1 | 1421.5 | 634.0 |
| 2008-03-09 20:00:00 | GC | Futures | 1421.5 | 1421.5 | 1415.1 | 1418.3 | 1692.0 |
| 2008-03-09 21:00:00 | GC | Futures | 1418.3 | 1421.1 | 1415.0 | 1421.1 | 1618.0 |
| 2008-03-09 22:00:00 | GC | Futures | 1421.1 | 1422.7 | 1420.5 | 1421.1 | 612.0 |
| 2008-03-09 23:00:00 | GC | Futures | 1421.2 | 1422.4 | 1420.9 | 1422.0 | 222.0 |
| 2008-03-09 18:00:00 | ZN | Futures | 87.026062 | 87.095433 | 86.968252 | 87.060747 | 3073.0 |
| 2008-03-09 19:00:00 | ZN | Futures | 87.049185 | 87.106994 | 87.037623 | 87.060747 | 2775.0 |
| 2008-03-09 20:00:00 | ZN | Futures | 87.060747 | 87.060747 | 86.922005 | 86.991376 | 5717.0 |
| 2008-03-09 21:00:00 | ZN | Futures | 87.002938 | 87.026062 | 86.979814 | 87.002938 | 2939.0 |
| 2008-03-09 22:00:00 | ZN | Futures | 87.0145 | 87.026062 | 86.991376 | 87.026062 | 900.0 |
| 2008-03-09 23:00:00 | ZN | Futures | 87.0145 | 87.049185 | 87.0145 | 87.049185 | 1376.0 |
> showing 36 of 224 rows — these rows as CSV