PREVIEW / futures_1hour / 2008-11-28
file: by_date/futures_1hour/2008/2008-11-28.parquet size: 31 KB rows: 834
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-28 00:00:00 | ES | Futures | 838.21 | 842.47 | 837.98 | 841.29 | 2124.0 |
| 2008-11-28 01:00:00 | ES | Futures | 841.53 | 842.24 | 838.69 | 841.29 | 1279.0 |
| 2008-11-28 02:00:00 | ES | Futures | 840.58 | 844.6 | 839.63 | 842.71 | 3923.0 |
| 2008-11-28 03:00:00 | ES | Futures | 842.95 | 845.79 | 838.92 | 842.95 | 10094.0 |
| 2008-11-28 04:00:00 | ES | Futures | 842.95 | 842.95 | 834.43 | 834.66 | 11353.0 |
| 2008-11-28 05:00:00 | ES | Futures | 834.9 | 838.69 | 834.19 | 837.5 | 5463.0 |
| 2008-11-28 06:00:00 | ES | Futures | 837.5 | 838.21 | 833.72 | 834.43 | 5809.0 |
| 2008-11-28 07:00:00 | ES | Futures | 834.19 | 835.14 | 829.46 | 832.06 | 15721.0 |
| 2008-11-28 08:00:00 | ES | Futures | 832.3 | 835.61 | 831.11 | 833.48 | 19472.0 |
| 2008-11-28 09:00:00 | ES | Futures | 833.48 | 841.76 | 832.06 | 836.79 | 129117.0 |
| 2008-11-28 10:00:00 | ES | Futures | 836.79 | 839.16 | 833.24 | 837.03 | 146309.0 |
| 2008-11-28 11:00:00 | ES | Futures | 837.27 | 843.42 | 834.19 | 842.95 | 135154.0 |
| 2008-11-28 12:00:00 | ES | Futures | 843.18 | 848.15 | 839.63 | 846.02 | 233582.0 |
| 2008-11-28 13:00:00 | ES | Futures | 846.5 | 849.1 | 845.31 | 846.97 | 70846.0 |
| 2008-11-28 00:00:00 | NQ | Futures | 1349.17 | 1352.56 | 1346.91 | 1352.28 | 39.0 |
| 2008-11-28 01:00:00 | NQ | Futures | 1352.56 | 1353.13 | 1348.32 | 1349.17 | 63.0 |
| 2008-11-28 02:00:00 | NQ | Futures | 1350.58 | 1355.96 | 1348.6 | 1354.26 | 114.0 |
| 2008-11-28 03:00:00 | NQ | Futures | 1354.55 | 1357.66 | 1349.17 | 1353.7 | 685.0 |
| 2008-11-28 04:00:00 | NQ | Futures | 1353.7 | 1353.7 | 1338.13 | 1338.98 | 977.0 |
| 2008-11-28 05:00:00 | NQ | Futures | 1339.27 | 1344.36 | 1336.72 | 1342.66 | 497.0 |
| 2008-11-28 06:00:00 | NQ | Futures | 1342.38 | 1345.21 | 1337.28 | 1339.55 | 224.0 |
| 2008-11-28 07:00:00 | NQ | Futures | 1340.68 | 1341.25 | 1332.19 | 1337.0 | 1020.0 |
| 2008-11-28 08:00:00 | NQ | Futures | 1337.0 | 1340.68 | 1333.32 | 1334.46 | 2250.0 |
| 2008-11-28 09:00:00 | NQ | Futures | 1334.46 | 1342.66 | 1329.64 | 1331.06 | 17154.0 |
| 2008-11-28 10:00:00 | NQ | Futures | 1331.06 | 1336.15 | 1325.68 | 1329.64 | 16088.0 |
| 2008-11-28 11:00:00 | NQ | Futures | 1329.36 | 1337.85 | 1326.25 | 1337.0 | 15537.0 |
| 2008-11-28 12:00:00 | NQ | Futures | 1337.28 | 1342.66 | 1329.93 | 1340.11 | 21367.0 |
| 2008-11-28 13:00:00 | NQ | Futures | 1339.83 | 1341.25 | 1336.72 | 1337.28 | 5881.0 |
| 2008-11-28 00:00:00 | YM | Futures | 7908.3 | 7937.4 | 7905.5 | 7936.5 | 190.0 |
| 2008-11-28 01:00:00 | YM | Futures | 7936.5 | 7937.4 | 7913.7 | 7924.6 | 108.0 |
| 2008-11-28 02:00:00 | YM | Futures | 7926.5 | 7958.3 | 7917.4 | 7944.6 | 392.0 |
| 2008-11-28 03:00:00 | YM | Futures | 7949.2 | 7970.1 | 7921.9 | 7953.7 | 1251.0 |
| 2008-11-28 04:00:00 | YM | Futures | 7952.8 | 7952.8 | 7876.4 | 7882.8 | 1065.0 |
| 2008-11-28 05:00:00 | YM | Futures | 7885.5 | 7921.9 | 7875.5 | 7911.0 | 678.0 |
| 2008-11-28 06:00:00 | YM | Futures | 7910.1 | 7914.6 | 7882.8 | 7887.3 | 381.0 |
| 2008-11-28 07:00:00 | YM | Futures | 7890.1 | 7892.8 | 7850.1 | 7864.6 | 1100.0 |
| 2008-11-28 08:00:00 | YM | Futures | 7866.4 | 7900.1 | 7861.9 | 7879.2 | 1369.0 |
| 2008-11-28 09:00:00 | YM | Futures | 7879.2 | 7953.7 | 7861.0 | 7933.7 | 11400.0 |
| 2008-11-28 10:00:00 | YM | Futures | 7934.6 | 7951.9 | 7902.8 | 7930.1 | 13204.0 |
| 2008-11-28 11:00:00 | YM | Futures | 7929.2 | 7982.8 | 7912.8 | 7979.2 | 11633.0 |
| 2008-11-28 12:00:00 | YM | Futures | 7980.1 | 8022.0 | 7957.4 | 8018.3 | 14802.0 |
| 2008-11-28 13:00:00 | YM | Futures | 8018.3 | 8029.2 | 8002.9 | 8022.9 | 3495.0 |
| 2008-11-28 00:00:00 | CL | Futures | 197.38 | 198.08 | 196.94 | 197.42 | 212.0 |
| 2008-11-28 01:00:00 | CL | Futures | 197.45 | 198.3 | 196.94 | 197.53 | 220.0 |
| 2008-11-28 02:00:00 | CL | Futures | 197.53 | 199.52 | 197.42 | 198.15 | 520.0 |
| 2008-11-28 03:00:00 | CL | Futures | 198.49 | 198.67 | 195.72 | 195.98 | 1400.0 |
| 2008-11-28 04:00:00 | CL | Futures | 195.98 | 197.79 | 194.83 | 196.27 | 1775.0 |
| 2008-11-28 05:00:00 | CL | Futures | 196.23 | 197.9 | 195.94 | 197.23 | 735.0 |
| 2008-11-28 06:00:00 | CL | Futures | 197.27 | 198.12 | 196.31 | 197.93 | 1211.0 |
| 2008-11-28 07:00:00 | CL | Futures | 197.86 | 199.96 | 197.79 | 198.49 | 2005.0 |
> showing 50 of 834 rows — these rows as CSV