PREVIEW / futures_1hour / 2008-10-28
file: by_date/futures_1hour/2008/2008-10-28.parquet size: 47 KB rows: 1,310
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-10-28 00:00:00 | ES | Futures | 799.17 | 802.72 | 796.56 | 800.82 | 8781.0 |
| 2008-10-28 01:00:00 | ES | Futures | 800.59 | 808.63 | 799.4 | 806.5 | 8671.0 |
| 2008-10-28 02:00:00 | ES | Futures | 806.5 | 821.65 | 805.08 | 820.94 | 17932.0 |
| 2008-10-28 03:00:00 | ES | Futures | 820.94 | 830.64 | 820.46 | 824.01 | 29640.0 |
| 2008-10-28 04:00:00 | ES | Futures | 824.01 | 831.59 | 814.07 | 815.02 | 56734.0 |
| 2008-10-28 05:00:00 | ES | Futures | 815.02 | 825.91 | 814.55 | 824.49 | 33632.0 |
| 2008-10-28 06:00:00 | ES | Futures | 824.49 | 828.27 | 819.04 | 821.17 | 27621.0 |
| 2008-10-28 07:00:00 | ES | Futures | 821.41 | 831.59 | 820.94 | 828.98 | 47551.0 |
| 2008-10-28 08:00:00 | ES | Futures | 829.22 | 829.46 | 822.12 | 824.96 | 44199.0 |
| 2008-10-28 09:00:00 | ES | Futures | 824.96 | 834.43 | 820.23 | 830.88 | 329103.0 |
| 2008-10-28 10:00:00 | ES | Futures | 830.64 | 830.64 | 798.46 | 801.3 | 547736.0 |
| 2008-10-28 11:00:00 | ES | Futures | 801.3 | 818.81 | 800.82 | 811.94 | 412183.0 |
| 2008-10-28 12:00:00 | ES | Futures | 811.94 | 822.36 | 808.63 | 820.23 | 242447.0 |
| 2008-10-28 13:00:00 | ES | Futures | 820.46 | 828.98 | 812.42 | 815.02 | 235602.0 |
| 2008-10-28 14:00:00 | ES | Futures | 815.02 | 851.47 | 814.31 | 847.44 | 452179.0 |
| 2008-10-28 15:00:00 | ES | Futures | 847.44 | 891.46 | 840.82 | 890.04 | 929434.0 |
| 2008-10-28 16:00:00 | ES | Futures | 890.04 | 892.41 | 880.1 | 883.41 | 254298.0 |
| 2008-10-28 17:00:00 | ES | Futures | 883.41 | 888.15 | 882.7 | 885.31 | 9057.0 |
| 2008-10-28 18:00:00 | ES | Futures | 885.54 | 886.49 | 878.44 | 881.99 | 10215.0 |
| 2008-10-28 19:00:00 | ES | Futures | 881.99 | 885.78 | 881.28 | 884.6 | 4831.0 |
| 2008-10-28 20:00:00 | ES | Futures | 884.6 | 885.78 | 882.7 | 884.12 | 6088.0 |
| 2008-10-28 21:00:00 | ES | Futures | 884.12 | 885.54 | 881.28 | 882.47 | 5695.0 |
| 2008-10-28 22:00:00 | ES | Futures | 882.47 | 883.65 | 879.86 | 882.47 | 6107.0 |
| 2008-10-28 23:00:00 | ES | Futures | 882.47 | 884.12 | 878.92 | 879.39 | 5283.0 |
| 2008-10-28 00:00:00 | NQ | Futures | 1322.29 | 1330.21 | 1322.29 | 1327.66 | 167.0 |
| 2008-10-28 01:00:00 | NQ | Futures | 1326.82 | 1340.96 | 1326.53 | 1337.28 | 267.0 |
| 2008-10-28 02:00:00 | NQ | Futures | 1334.74 | 1361.62 | 1331.06 | 1358.79 | 627.0 |
| 2008-10-28 03:00:00 | NQ | Futures | 1358.22 | 1375.2 | 1357.66 | 1367.0 | 1061.0 |
| 2008-10-28 04:00:00 | NQ | Futures | 1366.43 | 1378.88 | 1352.28 | 1355.39 | 2126.0 |
| 2008-10-28 05:00:00 | NQ | Futures | 1354.83 | 1371.81 | 1353.41 | 1367.84 | 1283.0 |
| 2008-10-28 06:00:00 | NQ | Futures | 1368.41 | 1373.79 | 1357.38 | 1357.38 | 1171.0 |
| 2008-10-28 07:00:00 | NQ | Futures | 1359.92 | 1379.73 | 1359.36 | 1378.03 | 3276.0 |
| 2008-10-28 08:00:00 | NQ | Futures | 1378.31 | 1378.31 | 1361.62 | 1368.13 | 6568.0 |
| 2008-10-28 09:00:00 | NQ | Futures | 1368.41 | 1380.86 | 1356.24 | 1373.79 | 48187.0 |
| 2008-10-28 10:00:00 | NQ | Futures | 1373.79 | 1373.79 | 1327.66 | 1332.76 | 68357.0 |
| 2008-10-28 11:00:00 | NQ | Futures | 1331.91 | 1355.96 | 1331.34 | 1344.92 | 52007.0 |
| 2008-10-28 12:00:00 | NQ | Futures | 1344.64 | 1359.07 | 1339.27 | 1353.98 | 32286.0 |
| 2008-10-28 13:00:00 | NQ | Futures | 1354.26 | 1367.84 | 1348.04 | 1352.28 | 38749.0 |
| 2008-10-28 14:00:00 | NQ | Futures | 1352.28 | 1404.06 | 1350.3 | 1398.69 | 62118.0 |
| 2008-10-28 15:00:00 | NQ | Futures | 1398.97 | 1471.41 | 1389.35 | 1469.71 | 130748.0 |
| 2008-10-28 16:00:00 | NQ | Futures | 1470.56 | 1481.6 | 1464.9 | 1468.58 | 33982.0 |
| 2008-10-28 17:00:00 | NQ | Futures | 1469.15 | 1474.81 | 1468.01 | 1470.56 | 1133.0 |
| 2008-10-28 18:00:00 | NQ | Futures | 1469.71 | 1471.41 | 1458.96 | 1464.05 | 622.0 |
| 2008-10-28 19:00:00 | NQ | Futures | 1464.34 | 1468.01 | 1461.79 | 1466.88 | 481.0 |
| 2008-10-28 20:00:00 | NQ | Futures | 1467.17 | 1468.01 | 1464.05 | 1466.32 | 137.0 |
| 2008-10-28 21:00:00 | NQ | Futures | 1466.6 | 1469.15 | 1464.62 | 1466.32 | 185.0 |
| 2008-10-28 22:00:00 | NQ | Futures | 1465.75 | 1468.3 | 1461.79 | 1467.17 | 126.0 |
| 2008-10-28 23:00:00 | NQ | Futures | 1465.75 | 1468.01 | 1461.79 | 1462.07 | 421.0 |
| 2008-10-28 00:00:00 | YM | Futures | 7369.8 | 7398.0 | 7351.6 | 7389.8 | 456.0 |
| 2008-10-28 01:00:00 | YM | Futures | 7389.8 | 7449.0 | 7385.3 | 7435.3 | 848.0 |
> showing 50 of 1,310 rows — these rows as CSV