PREVIEW / futures_1hour / 2008-12-24
file: by_date/futures_1hour/2008/2008-12-24.parquet size: 25 KB rows: 654
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-24 00:00:00 | ES | Futures | 814.49 | 816.87 | 814.49 | 815.68 | 693.0 |
| 2008-12-24 01:00:00 | ES | Futures | 815.44 | 816.15 | 814.49 | 815.44 | 539.0 |
| 2008-12-24 02:00:00 | ES | Futures | 815.68 | 815.92 | 815.21 | 815.92 | 439.0 |
| 2008-12-24 03:00:00 | ES | Futures | 815.68 | 815.92 | 813.55 | 814.26 | 2803.0 |
| 2008-12-24 04:00:00 | ES | Futures | 814.26 | 815.44 | 814.02 | 814.97 | 1110.0 |
| 2008-12-24 05:00:00 | ES | Futures | 814.97 | 816.15 | 814.49 | 815.68 | 1066.0 |
| 2008-12-24 06:00:00 | ES | Futures | 815.44 | 816.63 | 814.73 | 814.97 | 1012.0 |
| 2008-12-24 07:00:00 | ES | Futures | 815.21 | 815.92 | 812.12 | 812.36 | 3388.0 |
| 2008-12-24 08:00:00 | ES | Futures | 812.36 | 817.58 | 812.12 | 817.58 | 7427.0 |
| 2008-12-24 09:00:00 | ES | Futures | 817.58 | 819.24 | 815.21 | 815.21 | 43193.0 |
| 2008-12-24 10:00:00 | ES | Futures | 815.44 | 820.42 | 813.78 | 819.0 | 64336.0 |
| 2008-12-24 11:00:00 | ES | Futures | 819.0 | 821.14 | 818.05 | 820.19 | 32708.0 |
| 2008-12-24 12:00:00 | ES | Futures | 820.19 | 822.08 | 818.29 | 819.48 | 51989.0 |
| 2008-12-24 13:00:00 | ES | Futures | 819.48 | 821.14 | 819.0 | 820.42 | 17651.0 |
| 2008-12-24 00:00:00 | NQ | Futures | 1339.9 | 1341.03 | 1337.92 | 1341.03 | 8.0 |
| 2008-12-24 01:00:00 | NQ | Futures | 1339.05 | 1340.18 | 1339.05 | 1339.61 | 8.0 |
| 2008-12-24 02:00:00 | NQ | Futures | 1339.9 | 1341.31 | 1338.77 | 1341.31 | 67.0 |
| 2008-12-24 03:00:00 | NQ | Futures | 1339.61 | 1339.9 | 1337.35 | 1338.2 | 51.0 |
| 2008-12-24 04:00:00 | NQ | Futures | 1339.05 | 1340.46 | 1338.2 | 1338.48 | 44.0 |
| 2008-12-24 05:00:00 | NQ | Futures | 1339.33 | 1340.74 | 1338.77 | 1340.18 | 76.0 |
| 2008-12-24 06:00:00 | NQ | Futures | 1339.9 | 1343.0 | 1339.61 | 1340.74 | 70.0 |
| 2008-12-24 07:00:00 | NQ | Futures | 1341.31 | 1341.31 | 1336.51 | 1336.51 | 258.0 |
| 2008-12-24 08:00:00 | NQ | Futures | 1337.92 | 1342.72 | 1333.97 | 1341.87 | 1460.0 |
| 2008-12-24 09:00:00 | NQ | Futures | 1341.31 | 1343.57 | 1334.25 | 1335.1 | 6891.0 |
| 2008-12-24 10:00:00 | NQ | Futures | 1335.1 | 1343.57 | 1332.27 | 1339.33 | 9562.0 |
| 2008-12-24 11:00:00 | NQ | Futures | 1339.61 | 1341.87 | 1336.51 | 1338.77 | 7166.0 |
| 2008-12-24 12:00:00 | NQ | Futures | 1338.77 | 1342.16 | 1335.94 | 1337.35 | 9028.0 |
| 2008-12-24 13:00:00 | NQ | Futures | 1337.64 | 1337.64 | 1331.42 | 1333.97 | 4180.0 |
| 2008-12-24 00:00:00 | YM | Futures | 7650.1 | 7668.4 | 7650.1 | 7659.3 | 82.0 |
| 2008-12-24 01:00:00 | YM | Futures | 7657.4 | 7664.7 | 7652.9 | 7656.5 | 74.0 |
| 2008-12-24 02:00:00 | YM | Futures | 7658.3 | 7662.0 | 7652.0 | 7659.3 | 80.0 |
| 2008-12-24 03:00:00 | YM | Futures | 7657.4 | 7660.2 | 7634.7 | 7647.4 | 174.0 |
| 2008-12-24 04:00:00 | YM | Futures | 7647.4 | 7655.6 | 7647.4 | 7651.1 | 107.0 |
| 2008-12-24 05:00:00 | YM | Futures | 7653.8 | 7659.3 | 7650.1 | 7658.3 | 95.0 |
| 2008-12-24 06:00:00 | YM | Futures | 7656.5 | 7667.5 | 7645.6 | 7645.6 | 226.0 |
| 2008-12-24 07:00:00 | YM | Futures | 7649.2 | 7651.1 | 7620.1 | 7624.6 | 136.0 |
| 2008-12-24 08:00:00 | YM | Futures | 7624.6 | 7673.8 | 7620.1 | 7672.9 | 1151.0 |
| 2008-12-24 09:00:00 | YM | Futures | 7672.9 | 7686.6 | 7649.2 | 7653.8 | 6064.0 |
| 2008-12-24 10:00:00 | YM | Futures | 7653.8 | 7683.9 | 7641.9 | 7671.1 | 7056.0 |
| 2008-12-24 11:00:00 | YM | Futures | 7672.0 | 7703.0 | 7667.5 | 7684.8 | 5478.0 |
| 2008-12-24 12:00:00 | YM | Futures | 7685.7 | 7711.2 | 7673.8 | 7677.5 | 4780.0 |
| 2008-12-24 13:00:00 | YM | Futures | 7677.5 | 7688.4 | 7666.5 | 7676.6 | 1486.0 |
| 2008-12-24 00:00:00 | CL | Futures | 136.27 | 136.82 | 135.81 | 135.95 | 163.0 |
| 2008-12-24 01:00:00 | CL | Futures | 135.95 | 136.44 | 135.95 | 136.13 | 117.0 |
| 2008-12-24 02:00:00 | CL | Futures | 136.09 | 136.54 | 135.53 | 136.54 | 495.0 |
| 2008-12-24 03:00:00 | CL | Futures | 136.51 | 136.75 | 135.71 | 136.06 | 439.0 |
| 2008-12-24 04:00:00 | CL | Futures | 136.02 | 136.09 | 134.03 | 135.11 | 805.0 |
| 2008-12-24 05:00:00 | CL | Futures | 135.11 | 135.11 | 132.77 | 133.09 | 1218.0 |
| 2008-12-24 06:00:00 | CL | Futures | 133.12 | 133.33 | 129.77 | 130.89 | 2198.0 |
| 2008-12-24 07:00:00 | CL | Futures | 130.89 | 130.89 | 127.85 | 129.49 | 3986.0 |
> showing 50 of 654 rows — these rows as CSV