PREVIEW / futures_1hour / 2008-11-27
file: by_date/futures_1hour/2008/2008-11-27.parquet size: 28 KB rows: 767
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-27 00:00:00 | ES | Futures | 830.64 | 831.11 | 828.51 | 830.4 | 1120.0 |
| 2008-11-27 01:00:00 | ES | Futures | 830.4 | 833.95 | 830.4 | 832.06 | 1574.0 |
| 2008-11-27 02:00:00 | ES | Futures | 831.82 | 833.01 | 828.27 | 831.59 | 5642.0 |
| 2008-11-27 03:00:00 | ES | Futures | 831.82 | 836.56 | 831.11 | 835.61 | 10266.0 |
| 2008-11-27 04:00:00 | ES | Futures | 835.61 | 839.4 | 833.24 | 835.14 | 9434.0 |
| 2008-11-27 05:00:00 | ES | Futures | 834.9 | 837.03 | 832.06 | 834.19 | 7320.0 |
| 2008-11-27 06:00:00 | ES | Futures | 834.19 | 835.61 | 833.01 | 834.43 | 3804.0 |
| 2008-11-27 07:00:00 | ES | Futures | 834.19 | 834.66 | 829.69 | 830.4 | 5899.0 |
| 2008-11-27 08:00:00 | ES | Futures | 830.4 | 836.56 | 830.17 | 835.85 | 5119.0 |
| 2008-11-27 09:00:00 | ES | Futures | 835.85 | 837.5 | 834.19 | 836.79 | 5457.0 |
| 2008-11-27 10:00:00 | ES | Futures | 836.79 | 840.58 | 836.56 | 837.27 | 8640.0 |
| 2008-11-27 11:00:00 | ES | Futures | 837.27 | 842.24 | 836.08 | 841.76 | 6859.0 |
| 2008-11-27 18:00:00 | ES | Futures | 841.76 | 841.76 | 837.27 | 837.27 | 1628.0 |
| 2008-11-27 19:00:00 | ES | Futures | 837.27 | 837.98 | 834.43 | 836.79 | 1581.0 |
| 2008-11-27 20:00:00 | ES | Futures | 837.03 | 837.5 | 834.9 | 835.37 | 585.0 |
| 2008-11-27 21:00:00 | ES | Futures | 835.61 | 838.21 | 835.14 | 837.03 | 1094.0 |
| 2008-11-27 22:00:00 | ES | Futures | 837.03 | 837.5 | 835.37 | 836.79 | 1189.0 |
| 2008-11-27 23:00:00 | ES | Futures | 837.03 | 840.82 | 836.79 | 838.21 | 1840.0 |
| 2008-11-27 00:00:00 | NQ | Futures | 1339.55 | 1339.55 | 1337.28 | 1338.98 | 22.0 |
| 2008-11-27 01:00:00 | NQ | Futures | 1337.57 | 1343.79 | 1337.57 | 1340.96 | 67.0 |
| 2008-11-27 02:00:00 | NQ | Futures | 1340.96 | 1342.1 | 1335.87 | 1341.53 | 210.0 |
| 2008-11-27 03:00:00 | NQ | Futures | 1338.98 | 1346.62 | 1338.98 | 1343.51 | 292.0 |
| 2008-11-27 04:00:00 | NQ | Futures | 1345.21 | 1350.02 | 1341.81 | 1343.51 | 264.0 |
| 2008-11-27 05:00:00 | NQ | Futures | 1343.51 | 1346.34 | 1340.68 | 1342.66 | 220.0 |
| 2008-11-27 06:00:00 | NQ | Futures | 1342.1 | 1344.64 | 1340.11 | 1341.53 | 173.0 |
| 2008-11-27 07:00:00 | NQ | Futures | 1341.53 | 1341.53 | 1336.72 | 1337.0 | 281.0 |
| 2008-11-27 08:00:00 | NQ | Futures | 1337.0 | 1343.51 | 1337.0 | 1341.25 | 414.0 |
| 2008-11-27 09:00:00 | NQ | Futures | 1341.53 | 1343.51 | 1339.27 | 1342.66 | 761.0 |
| 2008-11-27 10:00:00 | NQ | Futures | 1342.1 | 1350.87 | 1342.1 | 1344.08 | 577.0 |
| 2008-11-27 11:00:00 | NQ | Futures | 1344.64 | 1353.7 | 1342.94 | 1351.72 | 382.0 |
| 2008-11-27 18:00:00 | NQ | Futures | 1352.0 | 1352.56 | 1346.62 | 1348.6 | 79.0 |
| 2008-11-27 19:00:00 | NQ | Futures | 1346.06 | 1346.06 | 1342.66 | 1346.06 | 37.0 |
| 2008-11-27 20:00:00 | NQ | Futures | 1346.06 | 1346.06 | 1342.66 | 1344.08 | 14.0 |
| 2008-11-27 21:00:00 | NQ | Futures | 1344.64 | 1346.91 | 1342.66 | 1345.49 | 43.0 |
| 2008-11-27 22:00:00 | NQ | Futures | 1346.34 | 1346.34 | 1344.08 | 1344.36 | 18.0 |
| 2008-11-27 23:00:00 | NQ | Futures | 1346.62 | 1351.15 | 1346.62 | 1346.91 | 48.0 |
| 2008-11-27 00:00:00 | YM | Futures | 7851.0 | 7853.7 | 7839.1 | 7851.0 | 127.0 |
| 2008-11-27 01:00:00 | YM | Futures | 7851.0 | 7879.2 | 7841.0 | 7848.2 | 186.0 |
| 2008-11-27 02:00:00 | YM | Futures | 7849.1 | 7858.2 | 7823.7 | 7844.6 | 501.0 |
| 2008-11-27 03:00:00 | YM | Futures | 7847.3 | 7885.5 | 7845.5 | 7877.3 | 860.0 |
| 2008-11-27 04:00:00 | YM | Futures | 7879.2 | 7908.3 | 7859.2 | 7876.4 | 879.0 |
| 2008-11-27 05:00:00 | YM | Futures | 7873.7 | 7891.9 | 7859.2 | 7876.4 | 323.0 |
| 2008-11-27 06:00:00 | YM | Futures | 7871.9 | 7881.9 | 7863.7 | 7875.5 | 162.0 |
| 2008-11-27 07:00:00 | YM | Futures | 7874.6 | 7877.3 | 7845.5 | 7847.3 | 401.0 |
| 2008-11-27 08:00:00 | YM | Futures | 7847.3 | 7891.9 | 7846.4 | 7889.2 | 337.0 |
| 2008-11-27 09:00:00 | YM | Futures | 7887.3 | 7898.3 | 7873.7 | 7891.0 | 614.0 |
| 2008-11-27 10:00:00 | YM | Futures | 7891.9 | 7932.8 | 7890.1 | 7901.9 | 792.0 |
| 2008-11-27 11:00:00 | YM | Futures | 7901.9 | 7943.7 | 7891.9 | 7932.8 | 258.0 |
| 2008-11-27 18:00:00 | YM | Futures | 7931.9 | 7933.7 | 7900.1 | 7900.1 | 75.0 |
| 2008-11-27 19:00:00 | YM | Futures | 7899.2 | 7902.8 | 7874.6 | 7896.4 | 140.0 |
> showing 50 of 767 rows — these rows as CSV