PREVIEW / futures_1hour / 2012-03-25
file: by_date/futures_1hour/2012/2012-03-25.parquet size: 13 KB rows: 261
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-03-25 18:00:00 | ES | Futures | 1410.39 | 1414.69 | 1410.13 | 1413.68 | 9055.0 |
| 2012-03-25 19:00:00 | ES | Futures | 1413.68 | 1414.69 | 1413.17 | 1414.44 | 3680.0 |
| 2012-03-25 20:00:00 | ES | Futures | 1414.44 | 1414.44 | 1412.66 | 1412.66 | 2842.0 |
| 2012-03-25 21:00:00 | ES | Futures | 1412.92 | 1412.92 | 1411.4 | 1412.41 | 4784.0 |
| 2012-03-25 22:00:00 | ES | Futures | 1412.16 | 1413.17 | 1411.4 | 1412.66 | 3262.0 |
| 2012-03-25 23:00:00 | ES | Futures | 1412.66 | 1413.68 | 1412.66 | 1413.68 | 1614.0 |
| 2012-03-25 18:00:00 | NQ | Futures | 3157.78 | 3165.88 | 3156.91 | 3163.85 | 872.0 |
| 2012-03-25 19:00:00 | NQ | Futures | 3164.14 | 3167.32 | 3163.28 | 3166.75 | 347.0 |
| 2012-03-25 20:00:00 | NQ | Futures | 3166.75 | 3166.75 | 3163.56 | 3164.14 | 503.0 |
| 2012-03-25 21:00:00 | NQ | Futures | 3164.14 | 3165.01 | 3162.41 | 3164.14 | 941.0 |
| 2012-03-25 22:00:00 | NQ | Futures | 3164.14 | 3165.59 | 3162.99 | 3164.72 | 473.0 |
| 2012-03-25 23:00:00 | NQ | Futures | 3165.3 | 3167.9 | 3165.3 | 3167.61 | 866.0 |
| 2012-03-25 18:00:00 | YM | Futures | 12981.8 | 13016.7 | 12981.8 | 13008.7 | 474.0 |
| 2012-03-25 19:00:00 | YM | Futures | 13009.7 | 13017.7 | 13008.7 | 13014.7 | 351.0 |
| 2012-03-25 20:00:00 | YM | Futures | 13013.7 | 13013.7 | 13002.7 | 13005.7 | 277.0 |
| 2012-03-25 21:00:00 | YM | Futures | 13004.7 | 13004.7 | 12994.7 | 13000.7 | 365.0 |
| 2012-03-25 22:00:00 | YM | Futures | 13001.7 | 13006.7 | 12994.7 | 13003.7 | 203.0 |
| 2012-03-25 23:00:00 | YM | Futures | 13005.7 | 13010.7 | 13004.7 | 13007.7 | 118.0 |
| 2012-03-25 18:00:00 | CL | Futures | 178.34 | 178.76 | 178.32 | 178.44 | 1043.0 |
| 2012-03-25 19:00:00 | CL | Futures | 178.39 | 178.51 | 178.11 | 178.27 | 827.0 |
| 2012-03-25 20:00:00 | CL | Futures | 178.26 | 178.27 | 178.01 | 178.09 | 923.0 |
| 2012-03-25 21:00:00 | CL | Futures | 178.07 | 178.22 | 177.94 | 178.09 | 602.0 |
| 2012-03-25 22:00:00 | CL | Futures | 178.09 | 178.21 | 177.94 | 177.94 | 430.0 |
| 2012-03-25 23:00:00 | CL | Futures | 177.94 | 178.16 | 177.94 | 178.12 | 342.0 |
| 2012-03-25 18:00:00 | GC | Futures | 2307.0 | 2316.3 | 2306.2 | 2315.9 | 1969.0 |
| 2012-03-25 19:00:00 | GC | Futures | 2315.8 | 2316.5 | 2314.0 | 2316.3 | 558.0 |
| 2012-03-25 20:00:00 | GC | Futures | 2316.8 | 2317.0 | 2310.8 | 2311.2 | 1427.0 |
| 2012-03-25 21:00:00 | GC | Futures | 2311.2 | 2311.2 | 2306.5 | 2307.5 | 3919.0 |
| 2012-03-25 22:00:00 | GC | Futures | 2307.5 | 2310.1 | 2307.5 | 2309.3 | 1030.0 |
| 2012-03-25 23:00:00 | GC | Futures | 2309.4 | 2310.1 | 2307.0 | 2307.5 | 753.0 |
| 2012-03-25 18:00:00 | ZN | Futures | 112.851436 | 112.865106 | 112.783082 | 112.810424 | 5463.0 |
| 2012-03-25 19:00:00 | ZN | Futures | 112.824094 | 112.837765 | 112.769412 | 112.783082 | 4381.0 |
| 2012-03-25 20:00:00 | ZN | Futures | 112.796753 | 112.796753 | 112.7284 | 112.769412 | 7414.0 |
| 2012-03-25 21:00:00 | ZN | Futures | 112.769412 | 112.810424 | 112.755741 | 112.769412 | 4416.0 |
| 2012-03-25 22:00:00 | ZN | Futures | 112.769412 | 112.796753 | 112.755741 | 112.769412 | 1520.0 |
| 2012-03-25 23:00:00 | ZN | Futures | 112.769412 | 112.769412 | 112.701058 | 112.74207 | 6600.0 |
> showing 36 of 261 rows — these rows as CSV