PREVIEW / futures_1hour / 2015-02-24
file: by_date/futures_1hour/2015/2015-02-24.parquet size: 50 KB rows: 1,551
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-02-24 00:00:00 | ES | Futures | 2218.11 | 2218.63 | 2217.58 | 2218.63 | 1940.0 |
| 2015-02-24 01:00:00 | ES | Futures | 2218.37 | 2218.63 | 2217.84 | 2218.37 | 1539.0 |
| 2015-02-24 02:00:00 | ES | Futures | 2218.37 | 2218.9 | 2217.84 | 2218.37 | 2733.0 |
| 2015-02-24 03:00:00 | ES | Futures | 2218.37 | 2219.16 | 2216.53 | 2216.79 | 15486.0 |
| 2015-02-24 04:00:00 | ES | Futures | 2216.79 | 2217.84 | 2215.74 | 2216.79 | 11180.0 |
| 2015-02-24 05:00:00 | ES | Futures | 2216.79 | 2217.58 | 2216.53 | 2217.58 | 4575.0 |
| 2015-02-24 06:00:00 | ES | Futures | 2217.32 | 2218.9 | 2217.05 | 2218.11 | 8052.0 |
| 2015-02-24 07:00:00 | ES | Futures | 2218.11 | 2218.63 | 2216.26 | 2217.32 | 10872.0 |
| 2015-02-24 08:00:00 | ES | Futures | 2217.32 | 2218.37 | 2216.53 | 2217.84 | 12205.0 |
| 2015-02-24 09:00:00 | ES | Futures | 2218.11 | 2219.69 | 2216.0 | 2217.58 | 132410.0 |
| 2015-02-24 10:00:00 | ES | Futures | 2217.58 | 2222.84 | 2213.37 | 2221.53 | 244520.0 |
| 2015-02-24 11:00:00 | ES | Futures | 2221.79 | 2225.48 | 2221.26 | 2222.05 | 136617.0 |
| 2015-02-24 12:00:00 | ES | Futures | 2222.05 | 2223.11 | 2217.05 | 2221.53 | 98877.0 |
| 2015-02-24 13:00:00 | ES | Futures | 2221.53 | 2223.63 | 2219.95 | 2223.11 | 74527.0 |
| 2015-02-24 14:00:00 | ES | Futures | 2223.11 | 2224.16 | 2221.26 | 2223.9 | 71909.0 |
| 2015-02-24 15:00:00 | ES | Futures | 2223.9 | 2227.05 | 2223.37 | 2224.69 | 176919.0 |
| 2015-02-24 16:00:00 | ES | Futures | 2224.95 | 2225.74 | 2223.63 | 2225.21 | 53144.0 |
| 2015-02-24 17:00:00 | ES | Futures | 2225.21 | 2225.48 | 2224.69 | 2224.95 | 1219.0 |
| 2015-02-24 18:00:00 | ES | Futures | 2224.95 | 2225.21 | 2224.42 | 2224.69 | 3056.0 |
| 2015-02-24 19:00:00 | ES | Futures | 2224.69 | 2224.95 | 2223.11 | 2224.42 | 4024.0 |
| 2015-02-24 20:00:00 | ES | Futures | 2224.42 | 2224.95 | 2223.37 | 2224.42 | 3577.0 |
| 2015-02-24 21:00:00 | ES | Futures | 2224.42 | 2224.95 | 2223.11 | 2223.37 | 2661.0 |
| 2015-02-24 22:00:00 | ES | Futures | 2223.63 | 2224.16 | 2223.11 | 2223.9 | 1083.0 |
| 2015-02-24 23:00:00 | ES | Futures | 2223.9 | 2224.42 | 2223.9 | 2224.16 | 1311.0 |
| 2015-02-24 00:00:00 | NQ | Futures | 5223.54 | 5225.01 | 5222.66 | 5225.01 | 393.0 |
| 2015-02-24 01:00:00 | NQ | Futures | 5224.72 | 5225.3 | 5223.25 | 5224.72 | 225.0 |
| 2015-02-24 02:00:00 | NQ | Futures | 5224.42 | 5225.01 | 5222.95 | 5224.42 | 348.0 |
| 2015-02-24 03:00:00 | NQ | Futures | 5224.42 | 5225.89 | 5220.6 | 5221.19 | 1817.0 |
| 2015-02-24 04:00:00 | NQ | Futures | 5220.9 | 5224.13 | 5219.14 | 5221.19 | 1753.0 |
| 2015-02-24 05:00:00 | NQ | Futures | 5221.49 | 5222.95 | 5220.6 | 5222.07 | 910.0 |
| 2015-02-24 06:00:00 | NQ | Futures | 5221.78 | 5223.54 | 5220.31 | 5221.49 | 1872.0 |
| 2015-02-24 07:00:00 | NQ | Futures | 5221.19 | 5222.07 | 5215.91 | 5217.96 | 1944.0 |
| 2015-02-24 08:00:00 | NQ | Futures | 5218.26 | 5220.6 | 5216.79 | 5219.14 | 2307.0 |
| 2015-02-24 09:00:00 | NQ | Futures | 5219.72 | 5220.02 | 5205.92 | 5209.44 | 25947.0 |
| 2015-02-24 10:00:00 | NQ | Futures | 5209.74 | 5222.66 | 5200.63 | 5221.49 | 36605.0 |
| 2015-02-24 11:00:00 | NQ | Futures | 5221.19 | 5232.94 | 5219.72 | 5223.25 | 22756.0 |
| 2015-02-24 12:00:00 | NQ | Futures | 5223.25 | 5227.07 | 5210.03 | 5218.84 | 16869.0 |
| 2015-02-24 13:00:00 | NQ | Futures | 5218.55 | 5227.95 | 5215.91 | 5226.19 | 10595.0 |
| 2015-02-24 14:00:00 | NQ | Futures | 5226.19 | 5229.71 | 5222.37 | 5228.24 | 9313.0 |
| 2015-02-24 15:00:00 | NQ | Futures | 5228.53 | 5234.41 | 5224.42 | 5228.53 | 22662.0 |
| 2015-02-24 16:00:00 | NQ | Futures | 5228.53 | 5230.3 | 5227.07 | 5227.95 | 4723.0 |
| 2015-02-24 17:00:00 | NQ | Futures | 5227.95 | 5227.95 | 5225.3 | 5226.19 | 259.0 |
| 2015-02-24 18:00:00 | NQ | Futures | 5226.77 | 5226.77 | 5224.42 | 5224.42 | 407.0 |
| 2015-02-24 19:00:00 | NQ | Futures | 5224.42 | 5224.72 | 5221.78 | 5223.84 | 489.0 |
| 2015-02-24 20:00:00 | NQ | Futures | 5223.84 | 5224.72 | 5222.07 | 5222.37 | 666.0 |
| 2015-02-24 21:00:00 | NQ | Futures | 5222.37 | 5224.13 | 5220.9 | 5221.49 | 482.0 |
| 2015-02-24 22:00:00 | NQ | Futures | 5221.78 | 5222.95 | 5221.19 | 5222.95 | 163.0 |
| 2015-02-24 23:00:00 | NQ | Futures | 5223.25 | 5224.72 | 5222.66 | 5224.13 | 206.0 |
| 2015-02-24 00:00:00 | YM | Futures | 18881.7 | 18897.3 | 18881.7 | 18896.3 | 822.0 |
| 2015-02-24 01:00:00 | YM | Futures | 18896.3 | 18897.3 | 18886.9 | 18891.0 | 288.0 |
> showing 50 of 1,551 rows — these rows as CSV