PREVIEW / futures_1hour / 2008-11-14
file: by_date/futures_1hour/2008/2008-11-14.parquet size: 37 KB rows: 990
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-14 00:00:00 | ES | Futures | 849.34 | 851.47 | 846.5 | 849.57 | 5430.0 |
| 2008-11-14 01:00:00 | ES | Futures | 850.05 | 854.07 | 849.57 | 852.41 | 3257.0 |
| 2008-11-14 02:00:00 | ES | Futures | 852.18 | 855.96 | 847.44 | 847.68 | 16824.0 |
| 2008-11-14 03:00:00 | ES | Futures | 847.92 | 849.34 | 842.24 | 846.97 | 37215.0 |
| 2008-11-14 04:00:00 | ES | Futures | 846.97 | 850.76 | 844.6 | 845.79 | 15919.0 |
| 2008-11-14 05:00:00 | ES | Futures | 845.79 | 850.28 | 842.24 | 848.15 | 14981.0 |
| 2008-11-14 06:00:00 | ES | Futures | 848.39 | 851.94 | 847.92 | 851.47 | 12236.0 |
| 2008-11-14 07:00:00 | ES | Futures | 851.23 | 853.83 | 845.79 | 846.26 | 25698.0 |
| 2008-11-14 08:00:00 | ES | Futures | 846.02 | 848.39 | 840.82 | 846.73 | 86706.0 |
| 2008-11-14 09:00:00 | ES | Futures | 846.97 | 858.56 | 841.05 | 854.78 | 285197.0 |
| 2008-11-14 10:00:00 | ES | Futures | 855.02 | 857.62 | 830.64 | 834.19 | 459172.0 |
| 2008-11-14 11:00:00 | ES | Futures | 833.95 | 839.16 | 827.56 | 829.22 | 308499.0 |
| 2008-11-14 12:00:00 | ES | Futures | 829.22 | 836.32 | 821.65 | 833.24 | 308309.0 |
| 2008-11-14 13:00:00 | ES | Futures | 833.48 | 841.53 | 823.78 | 836.56 | 284574.0 |
| 2008-11-14 14:00:00 | ES | Futures | 836.56 | 866.14 | 834.66 | 864.95 | 534517.0 |
| 2008-11-14 15:00:00 | ES | Futures | 865.19 | 868.98 | 822.36 | 824.49 | 714951.0 |
| 2008-11-14 16:00:00 | ES | Futures | 824.49 | 825.67 | 814.31 | 814.55 | 200003.0 |
| 2008-11-14 00:00:00 | NQ | Futures | 1386.8 | 1389.92 | 1383.41 | 1389.07 | 252.0 |
| 2008-11-14 01:00:00 | NQ | Futures | 1388.78 | 1394.16 | 1388.78 | 1391.33 | 284.0 |
| 2008-11-14 02:00:00 | NQ | Futures | 1393.31 | 1398.12 | 1384.26 | 1385.67 | 1219.0 |
| 2008-11-14 03:00:00 | NQ | Futures | 1386.24 | 1388.22 | 1378.88 | 1383.12 | 1723.0 |
| 2008-11-14 04:00:00 | NQ | Futures | 1383.41 | 1391.05 | 1380.86 | 1382.56 | 1147.0 |
| 2008-11-14 05:00:00 | NQ | Futures | 1382.84 | 1390.48 | 1377.18 | 1387.09 | 855.0 |
| 2008-11-14 06:00:00 | NQ | Futures | 1387.94 | 1393.31 | 1385.95 | 1391.33 | 526.0 |
| 2008-11-14 07:00:00 | NQ | Futures | 1391.05 | 1394.73 | 1384.82 | 1386.24 | 1734.0 |
| 2008-11-14 08:00:00 | NQ | Futures | 1385.67 | 1386.24 | 1371.24 | 1377.47 | 8375.0 |
| 2008-11-14 09:00:00 | NQ | Futures | 1377.18 | 1383.12 | 1363.32 | 1375.2 | 51609.0 |
| 2008-11-14 10:00:00 | NQ | Futures | 1374.64 | 1379.45 | 1345.77 | 1350.87 | 61645.0 |
| 2008-11-14 11:00:00 | NQ | Futures | 1350.58 | 1356.53 | 1337.57 | 1342.1 | 38426.0 |
| 2008-11-14 12:00:00 | NQ | Futures | 1342.1 | 1359.64 | 1331.34 | 1354.83 | 39327.0 |
| 2008-11-14 13:00:00 | NQ | Futures | 1354.83 | 1365.3 | 1341.25 | 1357.38 | 36624.0 |
| 2008-11-14 14:00:00 | NQ | Futures | 1357.94 | 1395.86 | 1355.39 | 1395.86 | 68908.0 |
| 2008-11-14 15:00:00 | NQ | Futures | 1395.86 | 1400.1 | 1326.82 | 1331.34 | 96658.0 |
| 2008-11-14 16:00:00 | NQ | Futures | 1331.34 | 1334.17 | 1307.29 | 1308.14 | 27809.0 |
| 2008-11-14 00:00:00 | YM | Futures | 7942.8 | 7960.1 | 7918.3 | 7942.8 | 320.0 |
| 2008-11-14 01:00:00 | YM | Futures | 7945.6 | 7981.9 | 7945.6 | 7974.7 | 326.0 |
| 2008-11-14 02:00:00 | YM | Futures | 7973.8 | 8000.1 | 7934.6 | 7935.6 | 1230.0 |
| 2008-11-14 03:00:00 | YM | Futures | 7939.2 | 7949.2 | 7890.1 | 7929.2 | 2882.0 |
| 2008-11-14 04:00:00 | YM | Futures | 7932.8 | 7961.9 | 7911.9 | 7917.4 | 788.0 |
| 2008-11-14 05:00:00 | YM | Futures | 7919.2 | 7960.1 | 7895.5 | 7939.2 | 975.0 |
| 2008-11-14 06:00:00 | YM | Futures | 7942.8 | 7975.6 | 7936.5 | 7963.7 | 843.0 |
| 2008-11-14 07:00:00 | YM | Futures | 7963.7 | 7978.3 | 7910.1 | 7912.8 | 1960.0 |
| 2008-11-14 08:00:00 | YM | Futures | 7912.8 | 7938.3 | 7871.0 | 7921.9 | 4958.0 |
| 2008-11-14 09:00:00 | YM | Futures | 7920.1 | 8016.5 | 7866.4 | 7990.1 | 31163.0 |
| 2008-11-14 10:00:00 | YM | Futures | 7987.4 | 8018.3 | 7780.9 | 7800.9 | 42655.0 |
| 2008-11-14 11:00:00 | YM | Futures | 7799.1 | 7851.9 | 7740.9 | 7755.5 | 30982.0 |
| 2008-11-14 12:00:00 | YM | Futures | 7755.5 | 7823.7 | 7692.7 | 7801.9 | 29132.0 |
| 2008-11-14 13:00:00 | YM | Futures | 7800.9 | 7871.9 | 7712.7 | 7826.4 | 32804.0 |
| 2008-11-14 14:00:00 | YM | Futures | 7826.4 | 8085.6 | 7808.2 | 8076.5 | 50501.0 |
| 2008-11-14 15:00:00 | YM | Futures | 8075.6 | 8107.5 | 7688.2 | 7700.9 | 64441.0 |
> showing 50 of 990 rows — these rows as CSV