PREVIEW / futures_1hour / 2008-11-11
file: by_date/futures_1hour/2008/2008-11-11.parquet size: 44 KB rows: 1,236
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-11 00:00:00 | ES | Futures | 874.18 | 875.37 | 870.16 | 870.63 | 2417.0 |
| 2008-11-11 01:00:00 | ES | Futures | 870.63 | 872.53 | 869.21 | 872.05 | 2521.0 |
| 2008-11-11 02:00:00 | ES | Futures | 872.05 | 872.76 | 865.9 | 867.32 | 6378.0 |
| 2008-11-11 03:00:00 | ES | Futures | 867.32 | 872.29 | 864.24 | 867.56 | 18421.0 |
| 2008-11-11 04:00:00 | ES | Futures | 867.56 | 869.92 | 862.11 | 863.3 | 11986.0 |
| 2008-11-11 05:00:00 | ES | Futures | 863.3 | 865.9 | 859.98 | 864.48 | 13648.0 |
| 2008-11-11 06:00:00 | ES | Futures | 864.72 | 866.61 | 860.46 | 861.17 | 11609.0 |
| 2008-11-11 07:00:00 | ES | Futures | 861.17 | 861.88 | 852.89 | 857.62 | 47588.0 |
| 2008-11-11 08:00:00 | ES | Futures | 857.62 | 859.27 | 854.78 | 856.91 | 42632.0 |
| 2008-11-11 09:00:00 | ES | Futures | 856.67 | 859.04 | 841.53 | 844.13 | 317308.0 |
| 2008-11-11 10:00:00 | ES | Futures | 843.89 | 849.57 | 839.63 | 840.58 | 362110.0 |
| 2008-11-11 11:00:00 | ES | Futures | 840.58 | 847.44 | 837.5 | 841.76 | 281730.0 |
| 2008-11-11 12:00:00 | ES | Futures | 841.53 | 842.47 | 835.61 | 841.76 | 161908.0 |
| 2008-11-11 13:00:00 | ES | Futures | 841.76 | 852.41 | 837.74 | 851.7 | 242552.0 |
| 2008-11-11 14:00:00 | ES | Futures | 851.47 | 868.03 | 847.68 | 848.39 | 548733.0 |
| 2008-11-11 15:00:00 | ES | Futures | 848.39 | 857.85 | 838.92 | 849.1 | 485544.0 |
| 2008-11-11 16:00:00 | ES | Futures | 849.1 | 849.81 | 844.6 | 846.02 | 85600.0 |
| 2008-11-11 17:00:00 | ES | Futures | 846.02 | 846.26 | 844.84 | 845.79 | 1841.0 |
| 2008-11-11 18:00:00 | ES | Futures | 845.79 | 847.68 | 845.55 | 846.97 | 3066.0 |
| 2008-11-11 19:00:00 | ES | Futures | 846.97 | 851.47 | 846.73 | 850.28 | 4681.0 |
| 2008-11-11 20:00:00 | ES | Futures | 850.28 | 862.35 | 850.05 | 860.93 | 10455.0 |
| 2008-11-11 21:00:00 | ES | Futures | 861.4 | 861.4 | 854.07 | 855.96 | 6859.0 |
| 2008-11-11 22:00:00 | ES | Futures | 856.2 | 856.67 | 848.15 | 850.05 | 5353.0 |
| 2008-11-11 23:00:00 | ES | Futures | 850.28 | 855.49 | 850.05 | 852.89 | 2630.0 |
| 2008-11-11 00:00:00 | NQ | Futures | 1423.31 | 1423.31 | 1417.08 | 1417.65 | 60.0 |
| 2008-11-11 01:00:00 | NQ | Futures | 1417.36 | 1421.32 | 1415.1 | 1421.32 | 83.0 |
| 2008-11-11 02:00:00 | NQ | Futures | 1420.76 | 1421.04 | 1410.01 | 1413.68 | 250.0 |
| 2008-11-11 03:00:00 | NQ | Futures | 1412.55 | 1423.02 | 1409.16 | 1412.55 | 1164.0 |
| 2008-11-11 04:00:00 | NQ | Futures | 1411.7 | 1414.82 | 1404.06 | 1404.91 | 973.0 |
| 2008-11-11 05:00:00 | NQ | Futures | 1404.91 | 1410.86 | 1400.67 | 1408.87 | 693.0 |
| 2008-11-11 06:00:00 | NQ | Futures | 1409.16 | 1409.72 | 1401.52 | 1403.22 | 680.0 |
| 2008-11-11 07:00:00 | NQ | Futures | 1403.5 | 1403.5 | 1392.75 | 1400.67 | 2600.0 |
| 2008-11-11 08:00:00 | NQ | Futures | 1400.67 | 1403.5 | 1396.42 | 1401.23 | 4464.0 |
| 2008-11-11 09:00:00 | NQ | Futures | 1401.23 | 1404.35 | 1374.64 | 1378.6 | 39189.0 |
| 2008-11-11 10:00:00 | NQ | Futures | 1378.03 | 1383.69 | 1372.66 | 1374.35 | 41481.0 |
| 2008-11-11 11:00:00 | NQ | Futures | 1374.07 | 1381.43 | 1368.69 | 1375.2 | 32020.0 |
| 2008-11-11 12:00:00 | NQ | Futures | 1375.2 | 1377.75 | 1367.28 | 1377.47 | 20584.0 |
| 2008-11-11 13:00:00 | NQ | Futures | 1377.47 | 1390.76 | 1369.83 | 1389.35 | 30112.0 |
| 2008-11-11 14:00:00 | NQ | Futures | 1389.35 | 1416.23 | 1381.99 | 1386.24 | 79270.0 |
| 2008-11-11 15:00:00 | NQ | Futures | 1386.52 | 1403.5 | 1373.22 | 1386.52 | 74658.0 |
| 2008-11-11 16:00:00 | NQ | Futures | 1386.52 | 1387.65 | 1381.99 | 1382.84 | 9918.0 |
| 2008-11-11 17:00:00 | NQ | Futures | 1383.12 | 1385.39 | 1380.86 | 1385.11 | 140.0 |
| 2008-11-11 18:00:00 | NQ | Futures | 1383.12 | 1386.52 | 1383.12 | 1384.82 | 110.0 |
| 2008-11-11 19:00:00 | NQ | Futures | 1384.82 | 1393.03 | 1384.82 | 1391.05 | 167.0 |
| 2008-11-11 20:00:00 | NQ | Futures | 1392.18 | 1408.31 | 1391.05 | 1408.31 | 422.0 |
| 2008-11-11 21:00:00 | NQ | Futures | 1408.59 | 1408.87 | 1396.42 | 1400.1 | 254.0 |
| 2008-11-11 22:00:00 | NQ | Futures | 1400.95 | 1400.95 | 1389.07 | 1391.05 | 132.0 |
| 2008-11-11 23:00:00 | NQ | Futures | 1392.75 | 1399.25 | 1392.75 | 1395.86 | 127.0 |
| 2008-11-11 00:00:00 | YM | Futures | 8097.4 | 8103.8 | 8059.2 | 8063.8 | 248.0 |
| 2008-11-11 01:00:00 | YM | Futures | 8062.9 | 8081.1 | 8050.2 | 8074.7 | 207.0 |
> showing 50 of 1,236 rows — these rows as CSV