PREVIEW / futures_1hour / 2017-03-24
file: by_date/futures_1hour/2017/2017-03-24.parquet size: 45 KB rows: 1,335
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 |
|---|---|---|---|---|---|---|---|
| 2017-03-24 00:00:00 | ES | Futures | 2562.35 | 2563.45 | 2562.08 | 2562.9 | 1836.0 |
| 2017-03-24 01:00:00 | ES | Futures | 2563.17 | 2564.27 | 2562.35 | 2563.17 | 4240.0 |
| 2017-03-24 02:00:00 | ES | Futures | 2563.45 | 2563.99 | 2562.08 | 2562.08 | 2631.0 |
| 2017-03-24 03:00:00 | ES | Futures | 2562.35 | 2562.9 | 2560.17 | 2561.81 | 8710.0 |
| 2017-03-24 04:00:00 | ES | Futures | 2561.53 | 2562.35 | 2559.08 | 2560.44 | 15342.0 |
| 2017-03-24 05:00:00 | ES | Futures | 2560.72 | 2561.81 | 2559.62 | 2559.9 | 9066.0 |
| 2017-03-24 06:00:00 | ES | Futures | 2560.17 | 2560.17 | 2557.44 | 2558.8 | 8031.0 |
| 2017-03-24 07:00:00 | ES | Futures | 2558.8 | 2562.08 | 2558.8 | 2559.62 | 11071.0 |
| 2017-03-24 08:00:00 | ES | Futures | 2559.62 | 2562.63 | 2559.08 | 2561.26 | 19504.0 |
| 2017-03-24 09:00:00 | ES | Futures | 2560.99 | 2568.09 | 2560.72 | 2565.91 | 129758.0 |
| 2017-03-24 10:00:00 | ES | Futures | 2565.91 | 2569.73 | 2563.99 | 2569.18 | 143789.0 |
| 2017-03-24 11:00:00 | ES | Futures | 2569.18 | 2570.55 | 2565.91 | 2568.09 | 102204.0 |
| 2017-03-24 12:00:00 | ES | Futures | 2568.36 | 2568.91 | 2560.44 | 2564.81 | 226933.0 |
| 2017-03-24 13:00:00 | ES | Futures | 2564.54 | 2565.91 | 2557.71 | 2558.8 | 117996.0 |
| 2017-03-24 14:00:00 | ES | Futures | 2558.8 | 2561.53 | 2553.07 | 2554.16 | 130683.0 |
| 2017-03-24 15:00:00 | ES | Futures | 2553.89 | 2564.54 | 2547.6 | 2558.53 | 513687.0 |
| 2017-03-24 16:00:00 | ES | Futures | 2558.26 | 2562.63 | 2557.44 | 2559.62 | 95311.0 |
| 2017-03-24 00:00:00 | NQ | Futures | 6400.18 | 6404.05 | 6400.18 | 6402.56 | 396.0 |
| 2017-03-24 01:00:00 | NQ | Futures | 6402.56 | 6404.65 | 6401.37 | 6403.16 | 505.0 |
| 2017-03-24 02:00:00 | NQ | Futures | 6403.46 | 6405.84 | 6401.96 | 6402.56 | 555.0 |
| 2017-03-24 03:00:00 | NQ | Futures | 6402.56 | 6404.65 | 6398.09 | 6401.96 | 1533.0 |
| 2017-03-24 04:00:00 | NQ | Futures | 6401.96 | 6404.65 | 6395.7 | 6399.58 | 2835.0 |
| 2017-03-24 05:00:00 | NQ | Futures | 6399.58 | 6402.26 | 6398.09 | 6398.98 | 1535.0 |
| 2017-03-24 06:00:00 | NQ | Futures | 6398.68 | 6398.68 | 6392.42 | 6393.91 | 2360.0 |
| 2017-03-24 07:00:00 | NQ | Futures | 6394.21 | 6401.37 | 6394.21 | 6396.6 | 2764.0 |
| 2017-03-24 08:00:00 | NQ | Futures | 6396.9 | 6404.95 | 6396.3 | 6403.16 | 3126.0 |
| 2017-03-24 09:00:00 | NQ | Futures | 6402.86 | 6431.18 | 6402.56 | 6424.62 | 34775.0 |
| 2017-03-24 10:00:00 | NQ | Futures | 6424.62 | 6430.59 | 6419.85 | 6428.5 | 25019.0 |
| 2017-03-24 11:00:00 | NQ | Futures | 6428.8 | 6433.87 | 6424.03 | 6431.78 | 17111.0 |
| 2017-03-24 12:00:00 | NQ | Futures | 6431.78 | 6432.97 | 6410.91 | 6423.73 | 43356.0 |
| 2017-03-24 13:00:00 | NQ | Futures | 6423.73 | 6425.82 | 6404.35 | 6406.73 | 22173.0 |
| 2017-03-24 14:00:00 | NQ | Futures | 6406.44 | 6413.0 | 6387.06 | 6387.95 | 26489.0 |
| 2017-03-24 15:00:00 | NQ | Futures | 6388.25 | 6418.96 | 6377.22 | 6401.07 | 91637.0 |
| 2017-03-24 16:00:00 | NQ | Futures | 6400.77 | 6415.98 | 6399.88 | 6407.63 | 9789.0 |
| 2017-03-24 00:00:00 | YM | Futures | 22434.6 | 22445.5 | 22431.4 | 22437.9 | 366.0 |
| 2017-03-24 01:00:00 | YM | Futures | 22437.9 | 22446.6 | 22433.5 | 22441.2 | 694.0 |
| 2017-03-24 02:00:00 | YM | Futures | 22443.3 | 22448.8 | 22434.6 | 22435.7 | 594.0 |
| 2017-03-24 03:00:00 | YM | Futures | 22435.7 | 22440.1 | 22418.3 | 22430.3 | 2018.0 |
| 2017-03-24 04:00:00 | YM | Futures | 22430.3 | 22439.0 | 22409.6 | 22420.5 | 2987.0 |
| 2017-03-24 05:00:00 | YM | Futures | 22420.5 | 22431.4 | 22416.2 | 22417.2 | 1298.0 |
| 2017-03-24 06:00:00 | YM | Futures | 22417.2 | 22417.2 | 22396.6 | 22403.1 | 1749.0 |
| 2017-03-24 07:00:00 | YM | Futures | 22403.1 | 22433.5 | 22403.1 | 22411.8 | 2227.0 |
| 2017-03-24 08:00:00 | YM | Futures | 22411.8 | 22436.8 | 22409.6 | 22424.8 | 2678.0 |
| 2017-03-24 09:00:00 | YM | Futures | 22425.9 | 22449.8 | 22411.8 | 22424.8 | 15285.0 |
| 2017-03-24 10:00:00 | YM | Futures | 22425.9 | 22455.3 | 22414.0 | 22449.8 | 11463.0 |
| 2017-03-24 11:00:00 | YM | Futures | 22449.8 | 22458.5 | 22411.8 | 22424.8 | 9720.0 |
| 2017-03-24 12:00:00 | YM | Futures | 22423.8 | 22432.5 | 22355.3 | 22397.7 | 25482.0 |
| 2017-03-24 13:00:00 | YM | Futures | 22398.8 | 22406.4 | 22345.5 | 22352.0 | 15540.0 |
| 2017-03-24 14:00:00 | YM | Futures | 22352.0 | 22372.7 | 22309.6 | 22316.2 | 15464.0 |
| 2017-03-24 15:00:00 | YM | Futures | 22316.2 | 22393.3 | 22253.1 | 22335.7 | 57608.0 |
> showing 50 of 1,335 rows — these rows as CSV