PREVIEW / futures_1hour / 2008-03-16
file: by_date/futures_1hour/2008/2008-03-16.parquet size: 14 KB rows: 246
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-16 18:00:00 | ES | Futures | 1201.01 | 1207.06 | 1196.82 | 1205.66 | 37903.0 |
| 2008-03-16 19:00:00 | ES | Futures | 1205.43 | 1223.83 | 1190.76 | 1191.23 | 74206.0 |
| 2008-03-16 20:00:00 | ES | Futures | 1191.23 | 1193.09 | 1178.42 | 1184.71 | 53788.0 |
| 2008-03-16 21:00:00 | ES | Futures | 1184.24 | 1184.24 | 1173.3 | 1174.93 | 30050.0 |
| 2008-03-16 22:00:00 | ES | Futures | 1175.16 | 1175.4 | 1167.01 | 1170.51 | 33263.0 |
| 2008-03-16 23:00:00 | ES | Futures | 1170.74 | 1177.96 | 1168.64 | 1176.56 | 16195.0 |
| 2008-03-16 18:00:00 | NQ | Futures | 1946.99 | 1956.04 | 1937.94 | 1951.8 | 1836.0 |
| 2008-03-16 19:00:00 | NQ | Futures | 1952.37 | 1985.46 | 1929.17 | 1930.02 | 3625.0 |
| 2008-03-16 20:00:00 | NQ | Futures | 1929.74 | 1932.0 | 1905.13 | 1916.73 | 2259.0 |
| 2008-03-16 21:00:00 | NQ | Futures | 1913.62 | 1914.47 | 1902.87 | 1907.68 | 861.0 |
| 2008-03-16 22:00:00 | NQ | Futures | 1907.68 | 1910.22 | 1898.06 | 1903.72 | 1422.0 |
| 2008-03-16 23:00:00 | NQ | Futures | 1902.31 | 1904.0 | 1894.39 | 1900.61 | 1683.0 |
| 2008-03-16 18:00:00 | YM | Futures | 10882.0 | 10892.9 | 10826.6 | 10882.0 | 839.0 |
| 2008-03-16 19:00:00 | YM | Futures | 10882.0 | 11031.0 | 10794.8 | 10803.9 | 2364.0 |
| 2008-03-16 20:00:00 | YM | Futures | 10798.4 | 10809.3 | 10699.4 | 10748.4 | 2615.0 |
| 2008-03-16 21:00:00 | YM | Futures | 10736.6 | 10740.3 | 10667.6 | 10674.8 | 1470.0 |
| 2008-03-16 22:00:00 | YM | Futures | 10678.5 | 10684.8 | 10604.9 | 10645.8 | 1594.0 |
| 2008-03-16 23:00:00 | YM | Futures | 10648.5 | 10693.9 | 10635.8 | 10685.7 | 887.0 |
| 2008-03-16 18:00:00 | CL | Futures | 410.56 | 410.78 | 409.2 | 409.84 | 298.0 |
| 2008-03-16 19:00:00 | CL | Futures | 409.92 | 410.6 | 409.88 | 410.29 | 76.0 |
| 2008-03-16 20:00:00 | CL | Futures | 410.14 | 412.26 | 409.65 | 411.27 | 231.0 |
| 2008-03-16 21:00:00 | CL | Futures | 410.71 | 415.13 | 409.95 | 413.96 | 1055.0 |
| 2008-03-16 22:00:00 | CL | Futures | 414.03 | 414.18 | 413.28 | 413.84 | 307.0 |
| 2008-03-16 23:00:00 | CL | Futures | 414.03 | 414.18 | 413.39 | 413.88 | 199.0 |
| 2008-03-16 18:00:00 | GC | Futures | 1462.3 | 1466.8 | 1458.7 | 1463.9 | 1243.0 |
| 2008-03-16 19:00:00 | GC | Futures | 1463.7 | 1480.5 | 1463.7 | 1479.3 | 5078.0 |
| 2008-03-16 20:00:00 | GC | Futures | 1479.0 | 1490.4 | 1478.7 | 1488.9 | 7514.0 |
| 2008-03-16 21:00:00 | GC | Futures | 1488.6 | 1505.1 | 1488.2 | 1496.9 | 7034.0 |
| 2008-03-16 22:00:00 | GC | Futures | 1497.4 | 1500.4 | 1488.6 | 1490.7 | 4052.0 |
| 2008-03-16 23:00:00 | GC | Futures | 1491.1 | 1498.1 | 1490.2 | 1494.3 | 2139.0 |
| 2008-03-16 18:00:00 | ZN | Futures | 88.101314 | 88.228494 | 88.07819 | 88.07819 | 13523.0 |
| 2008-03-16 19:00:00 | ZN | Futures | 88.089752 | 88.26318 | 87.858515 | 88.251618 | 25623.0 |
| 2008-03-16 20:00:00 | ZN | Futures | 88.251618 | 88.505979 | 88.228494 | 88.459731 | 31817.0 |
| 2008-03-16 21:00:00 | ZN | Futures | 88.459731 | 88.714092 | 88.459731 | 88.679406 | 14042.0 |
| 2008-03-16 22:00:00 | ZN | Futures | 88.690968 | 88.818149 | 88.621597 | 88.656283 | 13465.0 |
| 2008-03-16 23:00:00 | ZN | Futures | 88.656283 | 88.656283 | 88.552226 | 88.586912 | 8536.0 |
> showing 36 of 246 rows — these rows as CSV