PREVIEW / futures_1hour / 2008-12-26
file: by_date/futures_1hour/2008/2008-12-26.parquet size: 22 KB rows: 551
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-12-26 06:00:00 | ES | Futures | 822.08 | 824.22 | 820.19 | 823.98 | 1191.0 |
| 2008-12-26 07:00:00 | ES | Futures | 824.22 | 827.07 | 823.51 | 825.64 | 1451.0 |
| 2008-12-26 08:00:00 | ES | Futures | 825.4 | 827.07 | 824.93 | 824.93 | 3034.0 |
| 2008-12-26 09:00:00 | ES | Futures | 824.93 | 826.35 | 822.56 | 822.8 | 29874.0 |
| 2008-12-26 10:00:00 | ES | Futures | 822.8 | 824.93 | 821.14 | 822.32 | 24219.0 |
| 2008-12-26 11:00:00 | ES | Futures | 822.08 | 823.03 | 820.66 | 821.85 | 19427.0 |
| 2008-12-26 12:00:00 | ES | Futures | 821.61 | 823.03 | 818.53 | 819.71 | 17342.0 |
| 2008-12-26 13:00:00 | ES | Futures | 819.48 | 821.85 | 819.24 | 820.42 | 12654.0 |
| 2008-12-26 14:00:00 | ES | Futures | 820.42 | 823.27 | 820.19 | 823.27 | 17783.0 |
| 2008-12-26 15:00:00 | ES | Futures | 823.03 | 826.35 | 821.85 | 824.46 | 51857.0 |
| 2008-12-26 16:00:00 | ES | Futures | 824.22 | 825.17 | 823.03 | 825.17 | 19817.0 |
| 2008-12-26 06:00:00 | NQ | Futures | 1338.2 | 1339.61 | 1335.1 | 1339.61 | 97.0 |
| 2008-12-26 07:00:00 | NQ | Futures | 1338.77 | 1343.85 | 1338.48 | 1341.87 | 166.0 |
| 2008-12-26 08:00:00 | NQ | Futures | 1342.44 | 1345.26 | 1341.87 | 1343.57 | 516.0 |
| 2008-12-26 09:00:00 | NQ | Futures | 1343.57 | 1344.13 | 1336.51 | 1336.79 | 6421.0 |
| 2008-12-26 10:00:00 | NQ | Futures | 1337.07 | 1339.61 | 1335.1 | 1337.35 | 5249.0 |
| 2008-12-26 11:00:00 | NQ | Futures | 1337.07 | 1338.2 | 1331.42 | 1335.38 | 6228.0 |
| 2008-12-26 12:00:00 | NQ | Futures | 1335.38 | 1336.79 | 1331.42 | 1332.27 | 3438.0 |
| 2008-12-26 13:00:00 | NQ | Futures | 1332.27 | 1336.23 | 1331.99 | 1335.1 | 2894.0 |
| 2008-12-26 14:00:00 | NQ | Futures | 1335.38 | 1339.05 | 1334.53 | 1338.48 | 3752.0 |
| 2008-12-26 15:00:00 | NQ | Futures | 1338.77 | 1341.87 | 1336.23 | 1338.77 | 7619.0 |
| 2008-12-26 16:00:00 | NQ | Futures | 1338.77 | 1341.87 | 1331.71 | 1339.61 | 3432.0 |
| 2008-12-26 06:00:00 | YM | Futures | 7691.2 | 7700.3 | 7678.4 | 7700.3 | 27.0 |
| 2008-12-26 07:00:00 | YM | Futures | 7699.4 | 7744.9 | 7699.4 | 7713.9 | 133.0 |
| 2008-12-26 08:00:00 | YM | Futures | 7713.0 | 7732.2 | 7711.2 | 7713.9 | 237.0 |
| 2008-12-26 09:00:00 | YM | Futures | 7713.9 | 7728.5 | 7708.5 | 7717.6 | 2791.0 |
| 2008-12-26 10:00:00 | YM | Futures | 7717.6 | 7741.3 | 7702.1 | 7717.6 | 3208.0 |
| 2008-12-26 11:00:00 | YM | Futures | 7716.7 | 7721.2 | 7703.0 | 7709.4 | 1741.0 |
| 2008-12-26 12:00:00 | YM | Futures | 7708.5 | 7716.7 | 7672.9 | 7682.9 | 2460.0 |
| 2008-12-26 13:00:00 | YM | Futures | 7682.9 | 7706.6 | 7680.2 | 7691.2 | 1905.0 |
| 2008-12-26 14:00:00 | YM | Futures | 7691.2 | 7710.3 | 7687.5 | 7709.4 | 1971.0 |
| 2008-12-26 15:00:00 | YM | Futures | 7708.5 | 7738.5 | 7698.4 | 7719.4 | 4122.0 |
| 2008-12-26 16:00:00 | YM | Futures | 7720.3 | 7727.6 | 7706.6 | 7716.7 | 1105.0 |
| 2008-12-26 00:00:00 | CL | Futures | 126.95 | 127.16 | 125.62 | 126.32 | 215.0 |
| 2008-12-26 01:00:00 | CL | Futures | 126.32 | 126.81 | 126.0 | 126.81 | 168.0 |
| 2008-12-26 02:00:00 | CL | Futures | 126.84 | 128.45 | 126.7 | 127.68 | 505.0 |
| 2008-12-26 03:00:00 | CL | Futures | 127.68 | 127.68 | 125.83 | 127.19 | 423.0 |
| 2008-12-26 04:00:00 | CL | Futures | 127.19 | 128.17 | 127.09 | 127.82 | 353.0 |
| 2008-12-26 05:00:00 | CL | Futures | 127.82 | 128.8 | 127.64 | 127.75 | 285.0 |
| 2008-12-26 06:00:00 | CL | Futures | 127.85 | 127.85 | 125.83 | 126.42 | 508.0 |
| 2008-12-26 07:00:00 | CL | Futures | 126.42 | 127.33 | 126.39 | 126.84 | 472.0 |
| 2008-12-26 08:00:00 | CL | Futures | 126.81 | 127.16 | 124.96 | 125.37 | 1897.0 |
| 2008-12-26 09:00:00 | CL | Futures | 125.34 | 128.1 | 124.26 | 126.56 | 7795.0 |
| 2008-12-26 10:00:00 | CL | Futures | 126.56 | 127.57 | 125.97 | 126.67 | 3320.0 |
| 2008-12-26 11:00:00 | CL | Futures | 126.6 | 130.09 | 126.14 | 129.14 | 6166.0 |
| 2008-12-26 12:00:00 | CL | Futures | 129.25 | 129.84 | 128.2 | 128.8 | 2071.0 |
| 2008-12-26 13:00:00 | CL | Futures | 128.87 | 131.38 | 125.83 | 127.19 | 6944.0 |
| 2008-12-26 14:00:00 | CL | Futures | 127.26 | 132.32 | 126.07 | 131.45 | 9236.0 |
| 2008-12-26 15:00:00 | CL | Futures | 131.31 | 132.74 | 131.31 | 131.73 | 1244.0 |
| 2008-12-26 16:00:00 | CL | Futures | 131.76 | 132.29 | 131.41 | 132.29 | 235.0 |
> showing 50 of 551 rows — these rows as CSV