PREVIEW / etf_5min / 2016-02-11
file: by_date/etf_5min/2016/2016-02-11.parquet size: 1.3 MB rows: 57,323
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 |
|---|---|---|---|---|---|---|---|
| 2016-02-11 04:00:00 | SPY | ETF | 182.41 | 182.79 | 182.16 | 182.16 | 34822.0 |
| 2016-02-11 04:05:00 | SPY | ETF | 182.11 | 182.24 | 181.96 | 182.11 | 24832.0 |
| 2016-02-11 04:10:00 | SPY | ETF | 182.06 | 182.06 | 181.5 | 181.62 | 36995.0 |
| 2016-02-11 04:15:00 | SPY | ETF | 181.66 | 182.5 | 181.57 | 182.03 | 40381.0 |
| 2016-02-11 04:20:00 | SPY | ETF | 182.03 | 182.03 | 181.51 | 181.61 | 12742.0 |
| 2016-02-11 04:25:00 | SPY | ETF | 181.63 | 181.83 | 181.63 | 181.66 | 6806.0 |
| 2016-02-11 04:30:00 | SPY | ETF | 181.77 | 181.83 | 181.66 | 181.83 | 11272.0 |
| 2016-02-11 04:35:00 | SPY | ETF | 181.83 | 182.17 | 181.82 | 181.96 | 13173.0 |
| 2016-02-11 04:40:00 | SPY | ETF | 181.98 | 182.05 | 181.65 | 181.65 | 6955.0 |
| 2016-02-11 04:45:00 | SPY | ETF | 181.65 | 181.73 | 181.53 | 181.73 | 6132.0 |
| 2016-02-11 04:50:00 | SPY | ETF | 181.68 | 181.91 | 181.61 | 181.9 | 4500.0 |
| 2016-02-11 04:55:00 | SPY | ETF | 181.96 | 182.08 | 181.96 | 182.03 | 8277.0 |
| 2016-02-11 05:00:00 | SPY | ETF | 181.98 | 182.09 | 181.91 | 182.09 | 8290.0 |
| 2016-02-11 05:05:00 | SPY | ETF | 182.04 | 182.04 | 181.87 | 181.87 | 2334.0 |
| 2016-02-11 05:10:00 | SPY | ETF | 181.81 | 181.82 | 181.68 | 181.8 | 6627.0 |
| 2016-02-11 05:15:00 | SPY | ETF | 181.76 | 181.76 | 181.57 | 181.62 | 4373.0 |
| 2016-02-11 05:20:00 | SPY | ETF | 181.68 | 181.8 | 181.68 | 181.8 | 9706.0 |
| 2016-02-11 05:25:00 | SPY | ETF | 181.75 | 181.87 | 181.74 | 181.87 | 4995.0 |
| 2016-02-11 05:30:00 | SPY | ETF | 181.87 | 181.9 | 181.74 | 181.89 | 20417.0 |
| 2016-02-11 05:35:00 | SPY | ETF | 181.89 | 182.2 | 181.89 | 182.15 | 10739.0 |
| 2016-02-11 05:40:00 | SPY | ETF | 182.2 | 182.22 | 181.93 | 182.02 | 16090.0 |
| 2016-02-11 05:45:00 | SPY | ETF | 182.08 | 182.26 | 182.08 | 182.26 | 3291.0 |
| 2016-02-11 05:50:00 | SPY | ETF | 182.25 | 182.27 | 182.16 | 182.26 | 7539.0 |
| 2016-02-11 05:55:00 | SPY | ETF | 182.21 | 182.27 | 182.03 | 182.06 | 8013.0 |
| 2016-02-11 06:00:00 | SPY | ETF | 182.2 | 182.21 | 181.9 | 181.9 | 48592.0 |
| 2016-02-11 06:05:00 | SPY | ETF | 181.93 | 182.01 | 181.76 | 181.79 | 42567.0 |
| 2016-02-11 06:10:00 | SPY | ETF | 181.79 | 181.9 | 181.73 | 181.9 | 11605.0 |
| 2016-02-11 06:15:00 | SPY | ETF | 181.85 | 182.0 | 181.81 | 182.0 | 4107.0 |
| 2016-02-11 06:20:00 | SPY | ETF | 181.92 | 182.17 | 181.87 | 182.17 | 26220.0 |
| 2016-02-11 06:25:00 | SPY | ETF | 182.2 | 182.25 | 181.94 | 181.94 | 55355.0 |
| 2016-02-11 06:30:00 | SPY | ETF | 182.0 | 182.04 | 181.88 | 182.0 | 37513.0 |
| 2016-02-11 06:35:00 | SPY | ETF | 182.05 | 182.13 | 181.86 | 182.08 | 44322.0 |
| 2016-02-11 06:40:00 | SPY | ETF | 182.08 | 182.08 | 181.7 | 181.86 | 53900.0 |
| 2016-02-11 06:45:00 | SPY | ETF | 181.94 | 181.96 | 181.64 | 181.72 | 52191.0 |
| 2016-02-11 06:50:00 | SPY | ETF | 181.71 | 181.71 | 181.48 | 181.6 | 48597.0 |
| 2016-02-11 06:55:00 | SPY | ETF | 181.61 | 181.61 | 181.3 | 181.33 | 88552.0 |
| 2016-02-11 07:00:00 | SPY | ETF | 181.31 | 181.5 | 180.91 | 181.45 | 215477.0 |
| 2016-02-11 07:05:00 | SPY | ETF | 181.39 | 181.64 | 181.36 | 181.6 | 27337.0 |
| 2016-02-11 07:10:00 | SPY | ETF | 181.58 | 181.62 | 181.3 | 181.48 | 115875.0 |
| 2016-02-11 07:15:00 | SPY | ETF | 181.48 | 181.74 | 181.34 | 181.74 | 64210.0 |
| 2016-02-11 07:20:00 | SPY | ETF | 181.72 | 182.21 | 181.6 | 181.84 | 196562.0 |
| 2016-02-11 07:25:00 | SPY | ETF | 181.93 | 182.24 | 181.89 | 182.22 | 147362.0 |
| 2016-02-11 07:30:00 | SPY | ETF | 182.24 | 182.44 | 181.91 | 181.96 | 177526.0 |
| 2016-02-11 07:35:00 | SPY | ETF | 181.96 | 182.1 | 181.82 | 182.01 | 77240.0 |
| 2016-02-11 07:40:00 | SPY | ETF | 182.04 | 182.41 | 182.04 | 182.23 | 88309.0 |
| 2016-02-11 07:45:00 | SPY | ETF | 182.19 | 182.22 | 181.91 | 181.94 | 147318.0 |
| 2016-02-11 07:50:00 | SPY | ETF | 181.93 | 182.11 | 181.69 | 181.8 | 96756.0 |
| 2016-02-11 07:55:00 | SPY | ETF | 181.73 | 182.02 | 181.67 | 181.75 | 168635.0 |
| 2016-02-11 08:00:00 | SPY | ETF | 181.79 | 182.29 | 181.22 | 181.8273 | 409100.0 |
| 2016-02-11 08:05:00 | SPY | ETF | 181.82 | 182.03 | 181.78 | 181.99 | 75866.0 |
> showing 50 of 57,323 rows — these rows as CSV