PREVIEW / futures_1hour / 2015-05-03
file: by_date/futures_1hour/2015/2015-05-03.parquet size: 14 KB rows: 262
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 |
|---|---|---|---|---|---|---|---|
| 2015-05-03 18:00:00 | ES | Futures | 2220.44 | 2221.49 | 2219.12 | 2219.65 | 3302.0 |
| 2015-05-03 19:00:00 | ES | Futures | 2219.65 | 2219.91 | 2218.06 | 2218.59 | 2379.0 |
| 2015-05-03 20:00:00 | ES | Futures | 2218.59 | 2219.38 | 2218.06 | 2219.12 | 2168.0 |
| 2015-05-03 21:00:00 | ES | Futures | 2218.85 | 2220.17 | 2217.8 | 2218.85 | 2339.0 |
| 2015-05-03 22:00:00 | ES | Futures | 2218.59 | 2218.85 | 2217.53 | 2218.59 | 1587.0 |
| 2015-05-03 23:00:00 | ES | Futures | 2218.59 | 2219.12 | 2218.33 | 2218.59 | 785.0 |
| 2015-05-03 18:00:00 | NQ | Futures | 5259.91 | 5260.8 | 5251.09 | 5253.15 | 1069.0 |
| 2015-05-03 19:00:00 | NQ | Futures | 5253.15 | 5253.45 | 5249.62 | 5251.09 | 432.0 |
| 2015-05-03 20:00:00 | NQ | Futures | 5250.8 | 5251.97 | 5248.45 | 5251.39 | 502.0 |
| 2015-05-03 21:00:00 | NQ | Futures | 5251.68 | 5253.45 | 5247.56 | 5248.74 | 620.0 |
| 2015-05-03 22:00:00 | NQ | Futures | 5248.74 | 5248.74 | 5246.39 | 5248.74 | 665.0 |
| 2015-05-03 23:00:00 | NQ | Futures | 5248.74 | 5249.62 | 5247.56 | 5248.45 | 278.0 |
| 2015-05-03 18:00:00 | YM | Futures | 18811.0 | 18815.2 | 18799.4 | 18803.6 | 511.0 |
| 2015-05-03 19:00:00 | YM | Futures | 18804.7 | 18806.8 | 18791.1 | 18795.3 | 346.0 |
| 2015-05-03 20:00:00 | YM | Futures | 18795.3 | 18802.6 | 18791.1 | 18800.5 | 405.0 |
| 2015-05-03 21:00:00 | YM | Futures | 18798.4 | 18812.0 | 18786.9 | 18794.2 | 468.0 |
| 2015-05-03 22:00:00 | YM | Futures | 18793.2 | 18796.3 | 18785.8 | 18795.3 | 313.0 |
| 2015-05-03 23:00:00 | YM | Futures | 18795.3 | 18798.4 | 18794.2 | 18798.4 | 78.0 |
| 2015-05-03 18:00:00 | CL | Futures | 90.41 | 90.49 | 90.1 | 90.21 | 1157.0 |
| 2015-05-03 19:00:00 | CL | Futures | 90.21 | 90.21 | 89.97 | 90.07 | 621.0 |
| 2015-05-03 20:00:00 | CL | Futures | 90.06 | 90.14 | 89.97 | 90.01 | 882.0 |
| 2015-05-03 21:00:00 | CL | Futures | 90.03 | 90.06 | 89.53 | 89.65 | 2115.0 |
| 2015-05-03 22:00:00 | CL | Futures | 89.63 | 89.91 | 89.57 | 89.91 | 1580.0 |
| 2015-05-03 23:00:00 | CL | Futures | 89.91 | 90.15 | 89.78 | 90.06 | 1613.0 |
| 2015-05-03 18:00:00 | GC | Futures | 1606.9 | 1610.6 | 1606.9 | 1607.9 | 1508.0 |
| 2015-05-03 19:00:00 | GC | Futures | 1607.9 | 1608.7 | 1607.2 | 1608.3 | 527.0 |
| 2015-05-03 20:00:00 | GC | Futures | 1608.3 | 1610.1 | 1607.8 | 1608.6 | 1004.0 |
| 2015-05-03 21:00:00 | GC | Futures | 1608.6 | 1614.9 | 1607.4 | 1614.7 | 4837.0 |
| 2015-05-03 22:00:00 | GC | Futures | 1614.9 | 1615.7 | 1613.8 | 1615.1 | 1982.0 |
| 2015-05-03 23:00:00 | GC | Futures | 1615.0 | 1616.6 | 1614.6 | 1615.0 | 1848.0 |
| 2015-05-03 18:00:00 | ZN | Futures | 122.215502 | 122.215502 | 122.0363 | 122.110967 | 5283.0 |
| 2015-05-03 19:00:00 | ZN | Futures | 122.096034 | 122.125901 | 122.0811 | 122.110967 | 2171.0 |
| 2015-05-03 20:00:00 | ZN | Futures | 122.096034 | 122.125901 | 122.096034 | 122.110967 | 895.0 |
| 2015-05-03 21:00:00 | ZN | Futures | 122.110967 | 122.155768 | 122.096034 | 122.140834 | 2730.0 |
| 2015-05-03 22:00:00 | ZN | Futures | 122.140834 | 122.170701 | 122.140834 | 122.140834 | 2193.0 |
| 2015-05-03 23:00:00 | ZN | Futures | 122.155768 | 122.155768 | 122.096034 | 122.110967 | 1977.0 |
> showing 36 of 262 rows — these rows as CSV