PREVIEW / futures_1hour / 2011-12-04
file: by_date/futures_1hour/2011/2011-12-04.parquet size: 13 KB rows: 255
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 |
|---|---|---|---|---|---|---|---|
| 2011-12-04 18:00:00 | ES | Futures | 1251.78 | 1258.55 | 1251.78 | 1255.8 | 17880.0 |
| 2011-12-04 19:00:00 | ES | Futures | 1256.05 | 1256.8 | 1254.04 | 1254.54 | 7497.0 |
| 2011-12-04 20:00:00 | ES | Futures | 1254.54 | 1256.3 | 1254.04 | 1255.8 | 7309.0 |
| 2011-12-04 21:00:00 | ES | Futures | 1256.05 | 1257.8 | 1255.29 | 1256.3 | 7169.0 |
| 2011-12-04 22:00:00 | ES | Futures | 1256.05 | 1257.55 | 1255.8 | 1256.3 | 3578.0 |
| 2011-12-04 23:00:00 | ES | Futures | 1256.55 | 1257.55 | 1256.3 | 1256.55 | 3919.0 |
| 2011-12-04 18:00:00 | NQ | Futures | 2662.95 | 2676.5 | 2662.95 | 2669.87 | 1263.0 |
| 2011-12-04 19:00:00 | NQ | Futures | 2669.58 | 2670.73 | 2666.98 | 2668.71 | 599.0 |
| 2011-12-04 20:00:00 | NQ | Futures | 2668.71 | 2670.73 | 2665.83 | 2669.87 | 442.0 |
| 2011-12-04 21:00:00 | NQ | Futures | 2669.87 | 2674.48 | 2669.0 | 2672.17 | 407.0 |
| 2011-12-04 22:00:00 | NQ | Futures | 2671.02 | 2673.04 | 2671.02 | 2671.88 | 206.0 |
| 2011-12-04 23:00:00 | NQ | Futures | 2671.88 | 2673.33 | 2670.44 | 2671.88 | 236.0 |
| 2011-12-04 18:00:00 | YM | Futures | 11849.2 | 11913.2 | 11849.2 | 11887.6 | 872.0 |
| 2011-12-04 19:00:00 | YM | Futures | 11888.6 | 11894.5 | 11870.8 | 11877.7 | 483.0 |
| 2011-12-04 20:00:00 | YM | Futures | 11877.7 | 11889.5 | 11870.8 | 11886.6 | 424.0 |
| 2011-12-04 21:00:00 | YM | Futures | 11884.6 | 11903.3 | 11871.8 | 11893.5 | 1346.0 |
| 2011-12-04 22:00:00 | YM | Futures | 11889.5 | 11900.4 | 11887.6 | 11891.5 | 259.0 |
| 2011-12-04 23:00:00 | YM | Futures | 11891.5 | 11905.3 | 11886.6 | 11896.4 | 714.0 |
| 2011-12-04 18:00:00 | CL | Futures | 171.05 | 171.89 | 171.05 | 171.47 | 1536.0 |
| 2011-12-04 19:00:00 | CL | Futures | 171.45 | 171.67 | 171.3 | 171.3 | 587.0 |
| 2011-12-04 20:00:00 | CL | Futures | 171.33 | 171.35 | 170.94 | 171.21 | 791.0 |
| 2011-12-04 21:00:00 | CL | Futures | 171.21 | 171.62 | 171.08 | 171.54 | 857.0 |
| 2011-12-04 22:00:00 | CL | Futures | 171.48 | 171.6 | 171.23 | 171.48 | 293.0 |
| 2011-12-04 23:00:00 | CL | Futures | 171.45 | 171.5 | 171.13 | 171.4 | 453.0 |
| 2011-12-04 18:00:00 | GC | Futures | 2434.7 | 2445.5 | 2434.0 | 2443.9 | 1598.0 |
| 2011-12-04 19:00:00 | GC | Futures | 2444.0 | 2445.1 | 2436.9 | 2437.2 | 1676.0 |
| 2011-12-04 20:00:00 | GC | Futures | 2437.3 | 2437.6 | 2430.0 | 2433.4 | 2772.0 |
| 2011-12-04 21:00:00 | GC | Futures | 2433.4 | 2437.2 | 2432.5 | 2433.3 | 1292.0 |
| 2011-12-04 22:00:00 | GC | Futures | 2433.2 | 2438.0 | 2431.6 | 2432.7 | 2156.0 |
| 2011-12-04 23:00:00 | GC | Futures | 2432.6 | 2435.7 | 2431.5 | 2433.3 | 916.0 |
| 2011-12-04 18:00:00 | ZN | Futures | 113.156631 | 113.156631 | 113.021098 | 113.048205 | 415.0 |
| 2011-12-04 19:00:00 | ZN | Futures | 113.075312 | 113.102418 | 113.075312 | 113.102418 | 24.0 |
| 2011-12-04 20:00:00 | ZN | Futures | 113.102418 | 113.102418 | 113.075312 | 113.102418 | 201.0 |
| 2011-12-04 21:00:00 | ZN | Futures | 113.115971 | 113.115971 | 113.007545 | 113.007545 | 44.0 |
| 2011-12-04 22:00:00 | ZN | Futures | 113.048205 | 113.075312 | 113.048205 | 113.075312 | 2.0 |
> showing 35 of 255 rows — these rows as CSV