PREVIEW / futures_1hour / 2012-08-05
file: by_date/futures_1hour/2012/2012-08-05.parquet size: 14 KB rows: 265
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-08-05 18:00:00 | ES | Futures | 1414.07 | 1417.12 | 1412.04 | 1412.04 | 7280.0 |
| 2012-08-05 19:00:00 | ES | Futures | 1412.04 | 1414.83 | 1411.78 | 1414.32 | 4727.0 |
| 2012-08-05 20:00:00 | ES | Futures | 1414.07 | 1415.6 | 1413.31 | 1415.34 | 6086.0 |
| 2012-08-05 21:00:00 | ES | Futures | 1415.34 | 1415.6 | 1413.31 | 1413.56 | 5248.0 |
| 2012-08-05 22:00:00 | ES | Futures | 1413.56 | 1414.07 | 1412.54 | 1413.31 | 4279.0 |
| 2012-08-05 23:00:00 | ES | Futures | 1413.31 | 1413.56 | 1412.54 | 1412.8 | 1787.0 |
| 2012-08-05 18:00:00 | NQ | Futures | 3101.77 | 3107.57 | 3098.0 | 3098.29 | 820.0 |
| 2012-08-05 19:00:00 | NQ | Futures | 3098.29 | 3105.25 | 3098.29 | 3104.96 | 583.0 |
| 2012-08-05 20:00:00 | NQ | Futures | 3104.67 | 3107.86 | 3102.64 | 3107.28 | 852.0 |
| 2012-08-05 21:00:00 | NQ | Futures | 3107.28 | 3107.86 | 3101.77 | 3102.06 | 985.0 |
| 2012-08-05 22:00:00 | NQ | Futures | 3101.77 | 3102.93 | 3099.45 | 3100.9 | 463.0 |
| 2012-08-05 23:00:00 | NQ | Futures | 3100.9 | 3101.77 | 3099.74 | 3099.74 | 197.0 |
| 2012-08-05 18:00:00 | YM | Futures | 12990.9 | 13007.8 | 12969.0 | 12972.0 | 725.0 |
| 2012-08-05 19:00:00 | YM | Futures | 12971.0 | 12992.9 | 12970.0 | 12990.9 | 294.0 |
| 2012-08-05 20:00:00 | YM | Futures | 12991.9 | 13001.8 | 12980.9 | 13000.8 | 434.0 |
| 2012-08-05 21:00:00 | YM | Futures | 12998.8 | 12999.8 | 12982.9 | 12984.9 | 435.0 |
| 2012-08-05 22:00:00 | YM | Futures | 12984.9 | 12987.9 | 12974.0 | 12980.9 | 351.0 |
| 2012-08-05 23:00:00 | YM | Futures | 12982.9 | 12982.9 | 12977.0 | 12977.0 | 203.0 |
| 2012-08-05 18:00:00 | CL | Futures | 149.98 | 150.19 | 149.39 | 149.52 | 1485.0 |
| 2012-08-05 19:00:00 | CL | Futures | 149.5 | 150.05 | 149.34 | 149.85 | 981.0 |
| 2012-08-05 20:00:00 | CL | Futures | 149.82 | 149.82 | 149.57 | 149.8 | 885.0 |
| 2012-08-05 21:00:00 | CL | Futures | 149.8 | 150.08 | 149.63 | 149.75 | 855.0 |
| 2012-08-05 22:00:00 | CL | Futures | 149.73 | 149.91 | 149.49 | 149.7 | 687.0 |
| 2012-08-05 23:00:00 | CL | Futures | 149.68 | 149.77 | 149.57 | 149.63 | 317.0 |
| 2012-08-05 18:00:00 | GC | Futures | 2217.9 | 2218.2 | 2214.6 | 2217.2 | 656.0 |
| 2012-08-05 19:00:00 | GC | Futures | 2217.3 | 2219.7 | 2215.7 | 2218.6 | 646.0 |
| 2012-08-05 20:00:00 | GC | Futures | 2218.7 | 2219.3 | 2216.1 | 2217.5 | 666.0 |
| 2012-08-05 21:00:00 | GC | Futures | 2217.3 | 2220.8 | 2216.1 | 2219.4 | 1670.0 |
| 2012-08-05 22:00:00 | GC | Futures | 2219.1 | 2220.2 | 2217.7 | 2218.6 | 725.0 |
| 2012-08-05 23:00:00 | GC | Futures | 2218.7 | 2219.4 | 2216.9 | 2219.1 | 698.0 |
| 2012-08-05 18:00:00 | ZN | Futures | 117.938341 | 117.938341 | 117.869572 | 117.883326 | 5182.0 |
| 2012-08-05 19:00:00 | ZN | Futures | 117.89708 | 117.89708 | 117.828311 | 117.842065 | 4416.0 |
| 2012-08-05 20:00:00 | ZN | Futures | 117.842065 | 117.965848 | 117.842065 | 117.924587 | 8231.0 |
| 2012-08-05 21:00:00 | ZN | Futures | 117.924587 | 117.952095 | 117.910833 | 117.938341 | 2745.0 |
| 2012-08-05 22:00:00 | ZN | Futures | 117.952095 | 117.979602 | 117.938341 | 117.965848 | 3453.0 |
| 2012-08-05 23:00:00 | ZN | Futures | 117.965848 | 118.020863 | 117.952095 | 117.993356 | 8774.0 |
> showing 36 of 265 rows — these rows as CSV