PREVIEW / futures_1hour / 2008-11-26
file: by_date/futures_1hour/2008/2008-11-26.parquet size: 41 KB rows: 1,161
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-11-26 00:00:00 | ES | Futures | 803.9 | 804.85 | 802.01 | 802.48 | 2321.0 |
| 2008-11-26 01:00:00 | ES | Futures | 802.72 | 803.19 | 798.93 | 801.53 | 3218.0 |
| 2008-11-26 02:00:00 | ES | Futures | 801.53 | 805.79 | 799.17 | 802.48 | 5924.0 |
| 2008-11-26 03:00:00 | ES | Futures | 802.48 | 808.63 | 798.93 | 807.92 | 17552.0 |
| 2008-11-26 04:00:00 | ES | Futures | 807.92 | 809.82 | 801.06 | 803.19 | 23043.0 |
| 2008-11-26 05:00:00 | ES | Futures | 803.19 | 804.14 | 794.91 | 797.51 | 19488.0 |
| 2008-11-26 06:00:00 | ES | Futures | 797.75 | 800.11 | 795.85 | 798.46 | 9622.0 |
| 2008-11-26 07:00:00 | ES | Futures | 798.22 | 801.53 | 789.94 | 791.12 | 42400.0 |
| 2008-11-26 08:00:00 | ES | Futures | 791.12 | 795.14 | 785.2 | 793.01 | 83062.0 |
| 2008-11-26 09:00:00 | ES | Futures | 793.01 | 806.03 | 792.78 | 802.95 | 241032.0 |
| 2008-11-26 10:00:00 | ES | Futures | 802.95 | 812.89 | 798.46 | 811.23 | 361622.0 |
| 2008-11-26 11:00:00 | ES | Futures | 811.23 | 821.41 | 807.45 | 816.44 | 270685.0 |
| 2008-11-26 12:00:00 | ES | Futures | 816.68 | 824.25 | 813.36 | 821.88 | 160586.0 |
| 2008-11-26 13:00:00 | ES | Futures | 821.88 | 826.38 | 817.86 | 819.75 | 154827.0 |
| 2008-11-26 14:00:00 | ES | Futures | 819.75 | 835.14 | 816.44 | 833.01 | 228818.0 |
| 2008-11-26 15:00:00 | ES | Futures | 833.01 | 839.87 | 830.4 | 839.16 | 418304.0 |
| 2008-11-26 16:00:00 | ES | Futures | 839.16 | 840.34 | 836.79 | 838.45 | 113658.0 |
| 2008-11-26 17:00:00 | ES | Futures | 838.45 | 838.69 | 837.5 | 838.21 | 608.0 |
| 2008-11-26 18:00:00 | ES | Futures | 837.27 | 838.45 | 834.43 | 834.66 | 2880.0 |
| 2008-11-26 19:00:00 | ES | Futures | 834.66 | 836.32 | 834.19 | 835.14 | 1643.0 |
| 2008-11-26 20:00:00 | ES | Futures | 835.14 | 835.14 | 829.22 | 829.93 | 4378.0 |
| 2008-11-26 21:00:00 | ES | Futures | 830.17 | 831.11 | 828.98 | 830.17 | 1956.0 |
| 2008-11-26 22:00:00 | ES | Futures | 830.17 | 833.95 | 829.69 | 832.77 | 2102.0 |
| 2008-11-26 23:00:00 | ES | Futures | 832.53 | 832.53 | 828.51 | 830.64 | 1772.0 |
| 2008-11-26 00:00:00 | NQ | Futures | 1283.8 | 1284.65 | 1278.99 | 1278.99 | 181.0 |
| 2008-11-26 01:00:00 | NQ | Futures | 1280.13 | 1280.13 | 1273.9 | 1277.3 | 155.0 |
| 2008-11-26 02:00:00 | NQ | Futures | 1277.58 | 1288.62 | 1275.03 | 1283.8 | 736.0 |
| 2008-11-26 03:00:00 | NQ | Futures | 1283.52 | 1292.86 | 1276.16 | 1291.44 | 1146.0 |
| 2008-11-26 04:00:00 | NQ | Futures | 1291.44 | 1295.69 | 1281.82 | 1284.37 | 1554.0 |
| 2008-11-26 05:00:00 | NQ | Futures | 1286.07 | 1286.07 | 1271.35 | 1275.6 | 1509.0 |
| 2008-11-26 06:00:00 | NQ | Futures | 1275.88 | 1278.99 | 1271.64 | 1276.16 | 890.0 |
| 2008-11-26 07:00:00 | NQ | Futures | 1276.45 | 1286.35 | 1272.2 | 1277.86 | 6023.0 |
| 2008-11-26 08:00:00 | NQ | Futures | 1277.58 | 1284.37 | 1269.94 | 1279.56 | 9219.0 |
| 2008-11-26 09:00:00 | NQ | Futures | 1279.84 | 1304.46 | 1278.15 | 1300.22 | 41321.0 |
| 2008-11-26 10:00:00 | NQ | Futures | 1299.93 | 1320.59 | 1296.26 | 1317.48 | 52551.0 |
| 2008-11-26 11:00:00 | NQ | Futures | 1317.19 | 1330.78 | 1310.69 | 1324.83 | 41827.0 |
| 2008-11-26 12:00:00 | NQ | Futures | 1324.83 | 1332.19 | 1318.04 | 1331.06 | 23446.0 |
| 2008-11-26 13:00:00 | NQ | Futures | 1331.06 | 1337.0 | 1318.89 | 1320.02 | 23151.0 |
| 2008-11-26 14:00:00 | NQ | Futures | 1320.02 | 1343.79 | 1315.21 | 1341.25 | 33618.0 |
| 2008-11-26 15:00:00 | NQ | Futures | 1341.53 | 1350.87 | 1333.04 | 1349.74 | 54735.0 |
| 2008-11-26 16:00:00 | NQ | Futures | 1350.02 | 1352.56 | 1346.06 | 1348.6 | 11380.0 |
| 2008-11-26 17:00:00 | NQ | Futures | 1349.17 | 1349.45 | 1348.04 | 1348.32 | 29.0 |
| 2008-11-26 18:00:00 | NQ | Futures | 1349.17 | 1349.17 | 1344.08 | 1345.21 | 208.0 |
| 2008-11-26 19:00:00 | NQ | Futures | 1345.77 | 1346.34 | 1341.25 | 1341.25 | 163.0 |
| 2008-11-26 20:00:00 | NQ | Futures | 1343.51 | 1343.51 | 1335.59 | 1336.72 | 87.0 |
| 2008-11-26 21:00:00 | NQ | Futures | 1337.0 | 1339.55 | 1335.59 | 1338.13 | 54.0 |
| 2008-11-26 22:00:00 | NQ | Futures | 1338.13 | 1345.21 | 1337.85 | 1342.66 | 110.0 |
| 2008-11-26 23:00:00 | NQ | Futures | 1342.38 | 1342.38 | 1336.72 | 1340.68 | 152.0 |
| 2008-11-26 00:00:00 | YM | Futures | 7656.3 | 7664.5 | 7640.0 | 7648.1 | 192.0 |
| 2008-11-26 01:00:00 | YM | Futures | 7647.2 | 7650.9 | 7613.6 | 7630.0 | 440.0 |
> showing 50 of 1,161 rows — these rows as CSV