PREVIEW / futures_1hour / 2008-12-19
file: by_date/futures_1hour/2008/2008-12-19.parquet size: 36 KB rows: 1,011
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-19 00:00:00 | ES | Futures | 840.58 | 843.43 | 840.11 | 840.35 | 3515.0 |
| 2008-12-19 01:00:00 | ES | Futures | 840.35 | 841.3 | 839.87 | 840.58 | 1324.0 |
| 2008-12-19 02:00:00 | ES | Futures | 840.58 | 841.53 | 839.87 | 840.11 | 4047.0 |
| 2008-12-19 03:00:00 | ES | Futures | 840.11 | 843.43 | 838.92 | 840.11 | 12537.0 |
| 2008-12-19 04:00:00 | ES | Futures | 840.11 | 844.38 | 839.87 | 841.06 | 11937.0 |
| 2008-12-19 05:00:00 | ES | Futures | 841.06 | 844.14 | 837.03 | 841.53 | 21661.0 |
| 2008-12-19 06:00:00 | ES | Futures | 841.77 | 841.77 | 837.03 | 840.58 | 12340.0 |
| 2008-12-19 07:00:00 | ES | Futures | 840.58 | 841.3 | 837.26 | 840.82 | 16543.0 |
| 2008-12-19 08:00:00 | ES | Futures | 841.06 | 850.31 | 839.87 | 849.6 | 63188.0 |
| 2008-12-19 09:00:00 | ES | Futures | 849.6 | 851.73 | 841.06 | 844.14 | 235605.0 |
| 2008-12-19 10:00:00 | ES | Futures | 844.14 | 857.19 | 843.91 | 852.44 | 277182.0 |
| 2008-12-19 11:00:00 | ES | Futures | 852.68 | 853.39 | 841.3 | 842.01 | 231417.0 |
| 2008-12-19 12:00:00 | ES | Futures | 842.25 | 844.14 | 837.74 | 842.01 | 189985.0 |
| 2008-12-19 13:00:00 | ES | Futures | 842.01 | 848.17 | 841.53 | 843.19 | 136789.0 |
| 2008-12-19 14:00:00 | ES | Futures | 843.19 | 846.51 | 839.64 | 841.53 | 161601.0 |
| 2008-12-19 15:00:00 | ES | Futures | 841.77 | 842.25 | 834.89 | 837.26 | 308278.0 |
| 2008-12-19 16:00:00 | ES | Futures | 837.26 | 838.45 | 831.57 | 836.08 | 101417.0 |
| 2008-12-19 00:00:00 | NQ | Futures | 1374.91 | 1377.17 | 1371.24 | 1371.24 | 73.0 |
| 2008-12-19 01:00:00 | NQ | Futures | 1371.24 | 1373.78 | 1371.24 | 1371.52 | 44.0 |
| 2008-12-19 02:00:00 | NQ | Futures | 1371.81 | 1373.5 | 1371.24 | 1372.37 | 88.0 |
| 2008-12-19 03:00:00 | NQ | Futures | 1372.09 | 1377.17 | 1367.85 | 1372.37 | 699.0 |
| 2008-12-19 04:00:00 | NQ | Futures | 1372.37 | 1378.02 | 1372.37 | 1372.37 | 592.0 |
| 2008-12-19 05:00:00 | NQ | Futures | 1372.09 | 1376.89 | 1367.29 | 1375.48 | 994.0 |
| 2008-12-19 06:00:00 | NQ | Futures | 1375.19 | 1375.48 | 1367.29 | 1373.78 | 521.0 |
| 2008-12-19 07:00:00 | NQ | Futures | 1373.5 | 1373.5 | 1367.0 | 1370.96 | 1081.0 |
| 2008-12-19 08:00:00 | NQ | Futures | 1370.68 | 1382.25 | 1369.83 | 1381.12 | 5389.0 |
| 2008-12-19 09:00:00 | NQ | Futures | 1381.12 | 1390.16 | 1374.91 | 1382.82 | 40340.0 |
| 2008-12-19 10:00:00 | NQ | Futures | 1383.1 | 1398.07 | 1382.82 | 1392.7 | 38389.0 |
| 2008-12-19 11:00:00 | NQ | Futures | 1392.7 | 1393.83 | 1376.32 | 1377.45 | 25121.0 |
| 2008-12-19 12:00:00 | NQ | Futures | 1377.45 | 1379.15 | 1370.11 | 1375.76 | 25905.0 |
| 2008-12-19 13:00:00 | NQ | Futures | 1375.48 | 1384.51 | 1374.91 | 1379.99 | 17801.0 |
| 2008-12-19 14:00:00 | NQ | Futures | 1380.28 | 1385.36 | 1374.91 | 1378.3 | 17297.0 |
| 2008-12-19 15:00:00 | NQ | Futures | 1378.58 | 1379.71 | 1369.26 | 1374.35 | 40414.0 |
| 2008-12-19 16:00:00 | NQ | Futures | 1374.35 | 1375.48 | 1365.59 | 1367.85 | 11951.0 |
| 2008-12-19 00:00:00 | YM | Futures | 7857.0 | 7881.6 | 7852.4 | 7855.2 | 254.0 |
| 2008-12-19 01:00:00 | YM | Futures | 7855.2 | 7859.7 | 7850.6 | 7858.8 | 110.0 |
| 2008-12-19 02:00:00 | YM | Futures | 7857.0 | 7865.2 | 7851.5 | 7857.0 | 485.0 |
| 2008-12-19 03:00:00 | YM | Futures | 7857.0 | 7878.9 | 7843.3 | 7856.1 | 1254.0 |
| 2008-12-19 04:00:00 | YM | Futures | 7857.9 | 7882.5 | 7852.4 | 7852.4 | 933.0 |
| 2008-12-19 05:00:00 | YM | Futures | 7852.4 | 7878.0 | 7821.5 | 7870.7 | 1774.0 |
| 2008-12-19 06:00:00 | YM | Futures | 7868.8 | 7872.5 | 7833.3 | 7861.6 | 1094.0 |
| 2008-12-19 07:00:00 | YM | Futures | 7861.6 | 7863.4 | 7834.2 | 7854.3 | 1227.0 |
| 2008-12-19 08:00:00 | YM | Futures | 7852.4 | 7941.8 | 7845.2 | 7939.9 | 3642.0 |
| 2008-12-19 09:00:00 | YM | Futures | 7938.1 | 7955.4 | 7856.1 | 7878.0 | 17169.0 |
| 2008-12-19 10:00:00 | YM | Futures | 7877.1 | 7986.4 | 7873.4 | 7934.5 | 25348.0 |
| 2008-12-19 11:00:00 | YM | Futures | 7935.4 | 7941.8 | 7816.9 | 7826.9 | 21941.0 |
| 2008-12-19 12:00:00 | YM | Futures | 7826.0 | 7849.7 | 7789.6 | 7821.5 | 19957.0 |
| 2008-12-19 13:00:00 | YM | Futures | 7821.5 | 7885.3 | 7816.9 | 7834.2 | 15197.0 |
| 2008-12-19 14:00:00 | YM | Futures | 7833.3 | 7872.5 | 7804.1 | 7820.6 | 18100.0 |
| 2008-12-19 15:00:00 | YM | Futures | 7820.6 | 7825.1 | 7765.0 | 7765.0 | 33216.0 |
> showing 50 of 1,011 rows — these rows as CSV