PREVIEW / futures_1hour / 2012-04-22
file: by_date/futures_1hour/2012/2012-04-22.parquet size: 13 KB rows: 259
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 |
|---|---|---|---|---|---|---|---|
| 2012-04-22 18:00:00 | ES | Futures | 1388.63 | 1390.66 | 1387.62 | 1389.64 | 9090.0 |
| 2012-04-22 19:00:00 | ES | Futures | 1389.39 | 1389.64 | 1388.38 | 1389.14 | 3642.0 |
| 2012-04-22 20:00:00 | ES | Futures | 1388.88 | 1391.16 | 1387.87 | 1388.38 | 8767.0 |
| 2012-04-22 21:00:00 | ES | Futures | 1388.63 | 1389.64 | 1386.86 | 1388.13 | 9444.0 |
| 2012-04-22 22:00:00 | ES | Futures | 1388.13 | 1389.9 | 1387.37 | 1389.39 | 4872.0 |
| 2012-04-22 23:00:00 | ES | Futures | 1389.39 | 1390.15 | 1388.88 | 1389.14 | 1393.0 |
| 2012-04-22 18:00:00 | NQ | Futures | 3089.82 | 3092.71 | 3084.61 | 3090.69 | 904.0 |
| 2012-04-22 19:00:00 | NQ | Futures | 3090.4 | 3090.98 | 3087.5 | 3090.11 | 209.0 |
| 2012-04-22 20:00:00 | NQ | Futures | 3089.82 | 3094.45 | 3086.93 | 3088.37 | 981.0 |
| 2012-04-22 21:00:00 | NQ | Futures | 3088.37 | 3090.69 | 3085.48 | 3088.08 | 891.0 |
| 2012-04-22 22:00:00 | NQ | Futures | 3087.79 | 3090.69 | 3086.35 | 3089.82 | 501.0 |
| 2012-04-22 23:00:00 | NQ | Futures | 3089.82 | 3090.98 | 3088.08 | 3088.37 | 195.0 |
| 2012-04-22 18:00:00 | YM | Futures | 12919.0 | 12929.0 | 12905.1 | 12922.0 | 662.0 |
| 2012-04-22 19:00:00 | YM | Futures | 12921.0 | 12921.0 | 12899.1 | 12914.0 | 792.0 |
| 2012-04-22 20:00:00 | YM | Futures | 12914.0 | 12930.0 | 12906.1 | 12910.0 | 416.0 |
| 2012-04-22 21:00:00 | YM | Futures | 12910.0 | 12925.0 | 12899.1 | 12908.1 | 1240.0 |
| 2012-04-22 22:00:00 | YM | Futures | 12908.1 | 12924.0 | 12903.1 | 12919.0 | 712.0 |
| 2012-04-22 23:00:00 | YM | Futures | 12919.0 | 12923.0 | 12907.1 | 12914.0 | 500.0 |
| 2012-04-22 18:00:00 | CL | Futures | 172.59 | 172.69 | 172.39 | 172.64 | 554.0 |
| 2012-04-22 19:00:00 | CL | Futures | 172.64 | 172.69 | 172.49 | 172.63 | 281.0 |
| 2012-04-22 20:00:00 | CL | Futures | 172.68 | 172.73 | 172.48 | 172.49 | 264.0 |
| 2012-04-22 21:00:00 | CL | Futures | 172.49 | 172.56 | 172.41 | 172.43 | 738.0 |
| 2012-04-22 22:00:00 | CL | Futures | 172.44 | 172.64 | 172.41 | 172.56 | 611.0 |
| 2012-04-22 23:00:00 | CL | Futures | 172.54 | 172.69 | 172.51 | 172.51 | 334.0 |
| 2012-04-22 18:00:00 | GC | Futures | 2276.7 | 2277.3 | 2273.6 | 2277.0 | 489.0 |
| 2012-04-22 19:00:00 | GC | Futures | 2276.4 | 2278.1 | 2275.4 | 2277.8 | 280.0 |
| 2012-04-22 20:00:00 | GC | Futures | 2277.7 | 2278.6 | 2274.1 | 2274.9 | 1175.0 |
| 2012-04-22 21:00:00 | GC | Futures | 2274.9 | 2277.1 | 2274.5 | 2275.4 | 1607.0 |
| 2012-04-22 22:00:00 | GC | Futures | 2275.4 | 2278.4 | 2274.3 | 2277.1 | 1119.0 |
| 2012-04-22 23:00:00 | GC | Futures | 2277.0 | 2277.4 | 2276.0 | 2276.4 | 613.0 |
| 2012-04-22 18:00:00 | ZN | Futures | 115.243804 | 115.284816 | 115.243804 | 115.257475 | 1072.0 |
| 2012-04-22 19:00:00 | ZN | Futures | 115.257475 | 115.298487 | 115.257475 | 115.271145 | 3147.0 |
| 2012-04-22 20:00:00 | ZN | Futures | 115.271145 | 115.298487 | 115.230133 | 115.257475 | 9874.0 |
| 2012-04-22 21:00:00 | ZN | Futures | 115.257475 | 115.298487 | 115.230133 | 115.257475 | 8461.0 |
| 2012-04-22 22:00:00 | ZN | Futures | 115.257475 | 115.284816 | 115.230133 | 115.243804 | 2986.0 |
| 2012-04-22 23:00:00 | ZN | Futures | 115.257475 | 115.271145 | 115.243804 | 115.271145 | 1840.0 |
> showing 36 of 259 rows — these rows as CSV