PREVIEW / futures_30min / 2014-05-25
file: by_date/futures_30min/2014/2014-05-25.parquet size: 15 KB rows: 370
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 |
|---|---|---|---|---|---|---|---|
| 2014-05-25 18:00:00 | ES | Futures | 1971.42 | 1973.24 | 1970.64 | 1972.46 | 4132.0 |
| 2014-05-25 18:30:00 | ES | Futures | 1972.46 | 1972.98 | 1971.94 | 1972.2 | 1154.0 |
| 2014-05-25 19:00:00 | ES | Futures | 1971.94 | 1972.2 | 1971.42 | 1971.94 | 630.0 |
| 2014-05-25 19:30:00 | ES | Futures | 1971.94 | 1972.2 | 1970.9 | 1971.16 | 868.0 |
| 2014-05-25 20:00:00 | ES | Futures | 1971.16 | 1971.42 | 1970.64 | 1971.16 | 893.0 |
| 2014-05-25 20:30:00 | ES | Futures | 1970.9 | 1971.68 | 1970.64 | 1971.68 | 683.0 |
| 2014-05-25 21:00:00 | ES | Futures | 1971.42 | 1971.94 | 1971.16 | 1971.68 | 581.0 |
| 2014-05-25 21:30:00 | ES | Futures | 1971.68 | 1971.94 | 1971.42 | 1971.68 | 419.0 |
| 2014-05-25 22:00:00 | ES | Futures | 1971.68 | 1971.68 | 1971.42 | 1971.42 | 194.0 |
| 2014-05-25 22:30:00 | ES | Futures | 1971.16 | 1971.42 | 1970.9 | 1971.16 | 210.0 |
| 2014-05-25 23:00:00 | ES | Futures | 1971.42 | 1971.42 | 1970.38 | 1970.64 | 452.0 |
| 2014-05-25 23:30:00 | ES | Futures | 1970.64 | 1970.9 | 1970.38 | 1970.64 | 229.0 |
| 2014-05-25 18:00:00 | NQ | Futures | 4285.63 | 4294.65 | 4285.04 | 4291.74 | 1050.0 |
| 2014-05-25 18:30:00 | NQ | Futures | 4291.45 | 4292.03 | 4290.0 | 4290.58 | 108.0 |
| 2014-05-25 19:00:00 | NQ | Futures | 4290.29 | 4290.29 | 4288.25 | 4288.83 | 136.0 |
| 2014-05-25 19:30:00 | NQ | Futures | 4289.12 | 4289.7 | 4286.79 | 4287.67 | 121.0 |
| 2014-05-25 20:00:00 | NQ | Futures | 4287.67 | 4287.67 | 4285.63 | 4286.5 | 222.0 |
| 2014-05-25 20:30:00 | NQ | Futures | 4286.5 | 4287.96 | 4286.21 | 4287.37 | 203.0 |
| 2014-05-25 21:00:00 | NQ | Futures | 4287.08 | 4287.96 | 4287.08 | 4287.08 | 97.0 |
| 2014-05-25 21:30:00 | NQ | Futures | 4287.37 | 4287.96 | 4287.08 | 4287.37 | 78.0 |
| 2014-05-25 22:00:00 | NQ | Futures | 4287.37 | 4287.67 | 4286.5 | 4286.79 | 56.0 |
| 2014-05-25 22:30:00 | NQ | Futures | 4286.5 | 4286.5 | 4285.92 | 4286.21 | 67.0 |
| 2014-05-25 23:00:00 | NQ | Futures | 4286.21 | 4286.21 | 4284.17 | 4285.04 | 152.0 |
| 2014-05-25 23:30:00 | NQ | Futures | 4285.04 | 4285.63 | 4283.88 | 4285.63 | 60.0 |
| 2014-05-25 18:00:00 | YM | Futures | 17088.5 | 17110.1 | 17087.4 | 17103.9 | 903.0 |
| 2014-05-25 18:30:00 | YM | Futures | 17101.8 | 17108.0 | 17099.8 | 17101.8 | 124.0 |
| 2014-05-25 19:00:00 | YM | Futures | 17101.8 | 17101.8 | 17095.7 | 17099.8 | 63.0 |
| 2014-05-25 19:30:00 | YM | Futures | 17099.8 | 17102.9 | 17091.5 | 17093.6 | 122.0 |
| 2014-05-25 20:00:00 | YM | Futures | 17095.7 | 17095.7 | 17090.5 | 17094.6 | 105.0 |
| 2014-05-25 20:30:00 | YM | Futures | 17093.6 | 17095.7 | 17090.5 | 17095.7 | 122.0 |
| 2014-05-25 21:00:00 | YM | Futures | 17095.7 | 17098.8 | 17094.6 | 17096.7 | 105.0 |
| 2014-05-25 21:30:00 | YM | Futures | 17095.7 | 17100.8 | 17095.7 | 17098.8 | 143.0 |
| 2014-05-25 22:00:00 | YM | Futures | 17096.7 | 17099.8 | 17095.7 | 17095.7 | 49.0 |
| 2014-05-25 22:30:00 | YM | Futures | 17094.6 | 17094.6 | 17092.6 | 17092.6 | 71.0 |
| 2014-05-25 23:00:00 | YM | Futures | 17093.6 | 17093.6 | 17085.4 | 17085.4 | 100.0 |
| 2014-05-25 23:30:00 | YM | Futures | 17085.4 | 17090.5 | 17085.4 | 17089.5 | 114.0 |
| 2014-05-25 18:00:00 | CL | Futures | 168.43 | 168.43 | 168.22 | 168.33 | 514.0 |
| 2014-05-25 18:30:00 | CL | Futures | 168.32 | 168.36 | 168.28 | 168.28 | 120.0 |
| 2014-05-25 19:00:00 | CL | Futures | 168.28 | 168.38 | 168.27 | 168.28 | 271.0 |
| 2014-05-25 19:30:00 | CL | Futures | 168.27 | 168.3 | 168.19 | 168.2 | 167.0 |
| 2014-05-25 20:00:00 | CL | Futures | 168.22 | 168.25 | 168.06 | 168.07 | 237.0 |
| 2014-05-25 20:30:00 | CL | Futures | 168.07 | 168.12 | 168.01 | 168.06 | 227.0 |
| 2014-05-25 21:00:00 | CL | Futures | 168.06 | 168.07 | 167.96 | 168.06 | 237.0 |
| 2014-05-25 21:30:00 | CL | Futures | 168.07 | 168.09 | 167.98 | 168.04 | 201.0 |
| 2014-05-25 22:00:00 | CL | Futures | 168.03 | 168.04 | 168.01 | 168.03 | 147.0 |
| 2014-05-25 22:30:00 | CL | Futures | 168.01 | 168.03 | 167.98 | 168.01 | 210.0 |
| 2014-05-25 23:00:00 | CL | Futures | 168.01 | 168.03 | 167.93 | 167.94 | 136.0 |
| 2014-05-25 23:30:00 | CL | Futures | 167.96 | 167.99 | 167.93 | 167.96 | 125.0 |
| 2014-05-25 18:00:00 | GC | Futures | 1772.1 | 1773.7 | 1768.9 | 1769.5 | 356.0 |
| 2014-05-25 18:30:00 | GC | Futures | 1769.5 | 1770.2 | 1768.4 | 1769.4 | 179.0 |
> showing 50 of 370 rows — these rows as CSV