PREVIEW / futures_1hour / 2009-07-12
file: by_date/futures_1hour/2009/2009-07-12.parquet size: 13 KB rows: 233
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 |
|---|---|---|---|---|---|---|---|
| 2009-07-12 18:00:00 | ES | Futures | 843.84 | 846.25 | 843.12 | 845.53 | 3727.0 |
| 2009-07-12 19:00:00 | ES | Futures | 845.53 | 846.25 | 844.56 | 845.53 | 1473.0 |
| 2009-07-12 20:00:00 | ES | Futures | 845.53 | 846.49 | 845.53 | 846.25 | 4595.0 |
| 2009-07-12 21:00:00 | ES | Futures | 846.25 | 846.49 | 841.43 | 841.67 | 5587.0 |
| 2009-07-12 22:00:00 | ES | Futures | 841.43 | 841.91 | 838.05 | 838.77 | 8226.0 |
| 2009-07-12 23:00:00 | ES | Futures | 839.02 | 840.46 | 837.81 | 838.29 | 5711.0 |
| 2009-07-12 18:00:00 | NQ | Futures | 1616.01 | 1618.86 | 1612.31 | 1617.15 | 377.0 |
| 2009-07-12 19:00:00 | NQ | Futures | 1617.15 | 1618.58 | 1616.01 | 1617.15 | 96.0 |
| 2009-07-12 20:00:00 | NQ | Futures | 1616.58 | 1619.43 | 1616.58 | 1618.29 | 169.0 |
| 2009-07-12 21:00:00 | NQ | Futures | 1618.01 | 1618.01 | 1609.18 | 1609.18 | 353.0 |
| 2009-07-12 22:00:00 | NQ | Futures | 1609.46 | 1609.46 | 1603.2 | 1603.48 | 547.0 |
| 2009-07-12 23:00:00 | NQ | Futures | 1603.77 | 1606.62 | 1602.34 | 1604.62 | 449.0 |
| 2009-07-12 18:00:00 | YM | Futures | 7476.6 | 7501.6 | 7474.8 | 7497.0 | 184.0 |
| 2009-07-12 19:00:00 | YM | Futures | 7496.0 | 7498.8 | 7487.7 | 7493.3 | 48.0 |
| 2009-07-12 20:00:00 | YM | Futures | 7493.3 | 7502.5 | 7493.3 | 7498.8 | 203.0 |
| 2009-07-12 21:00:00 | YM | Futures | 7499.7 | 7500.7 | 7462.8 | 7462.8 | 323.0 |
| 2009-07-12 22:00:00 | YM | Futures | 7463.7 | 7463.7 | 7436.9 | 7442.4 | 408.0 |
| 2009-07-12 23:00:00 | YM | Futures | 7441.5 | 7453.5 | 7435.9 | 7438.7 | 439.0 |
| 2009-07-12 18:00:00 | CL | Futures | 141.749 | 142.436 | 141.157 | 142.246 | 878.0 |
| 2009-07-12 19:00:00 | CL | Futures | 142.246 | 142.554 | 141.844 | 141.986 | 411.0 |
| 2009-07-12 20:00:00 | CL | Futures | 142.01 | 142.459 | 141.867 | 142.459 | 283.0 |
| 2009-07-12 21:00:00 | CL | Futures | 142.483 | 142.673 | 142.033 | 142.057 | 706.0 |
| 2009-07-12 22:00:00 | CL | Futures | 142.081 | 142.081 | 141.323 | 141.346 | 609.0 |
| 2009-07-12 23:00:00 | CL | Futures | 141.323 | 141.441 | 140.352 | 140.541 | 950.0 |
| 2009-07-12 18:00:00 | GC | Futures | 1292.5 | 1295.6 | 1290.8 | 1294.9 | 330.0 |
| 2009-07-12 19:00:00 | GC | Futures | 1294.9 | 1295.6 | 1293.9 | 1294.9 | 178.0 |
| 2009-07-12 20:00:00 | GC | Futures | 1295.2 | 1297.0 | 1295.1 | 1295.9 | 570.0 |
| 2009-07-12 21:00:00 | GC | Futures | 1295.6 | 1295.9 | 1294.3 | 1294.3 | 289.0 |
| 2009-07-12 22:00:00 | GC | Futures | 1294.6 | 1294.6 | 1293.1 | 1293.9 | 359.0 |
| 2009-07-12 23:00:00 | GC | Futures | 1293.9 | 1294.3 | 1292.2 | 1292.8 | 245.0 |
| 2009-07-12 18:00:00 | ZN | Futures | 94.242413 | 94.242413 | 94.13081 | 94.13081 | 448.0 |
| 2009-07-12 19:00:00 | ZN | Futures | 94.13081 | 94.168011 | 94.118409 | 94.168011 | 481.0 |
| 2009-07-12 20:00:00 | ZN | Futures | 94.168011 | 94.168011 | 94.081209 | 94.081209 | 2056.0 |
| 2009-07-12 21:00:00 | ZN | Futures | 94.081209 | 94.118409 | 94.031607 | 94.093609 | 4043.0 |
| 2009-07-12 22:00:00 | ZN | Futures | 94.106009 | 94.205212 | 94.106009 | 94.168011 | 3364.0 |
| 2009-07-12 23:00:00 | ZN | Futures | 94.180411 | 94.192811 | 94.168011 | 94.192811 | 1048.0 |
> showing 36 of 233 rows — these rows as CSV