PREVIEW / etf_5min / 2017-05-12
file: by_date/etf_5min/2017/2017-05-12.parquet size: 1.2 MB rows: 51,180
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-05-12 04:00:00 | SPY | ETF | 238.85 | 238.85 | 238.85 | 238.85 | 371.0 |
| 2017-05-12 04:10:00 | SPY | ETF | 238.74 | 238.76 | 238.74 | 238.76 | 7530.0 |
| 2017-05-12 04:30:00 | SPY | ETF | 238.76 | 238.83 | 238.76 | 238.83 | 500.0 |
| 2017-05-12 04:35:00 | SPY | ETF | 238.75 | 238.75 | 238.75 | 238.75 | 410.0 |
| 2017-05-12 04:40:00 | SPY | ETF | 238.71 | 238.75 | 238.71 | 238.73 | 1650.0 |
| 2017-05-12 04:45:00 | SPY | ETF | 238.7 | 238.73 | 238.7 | 238.71 | 5100.0 |
| 2017-05-12 04:50:00 | SPY | ETF | 238.7 | 238.76 | 238.7 | 238.76 | 4400.0 |
| 2017-05-12 04:55:00 | SPY | ETF | 238.76 | 238.76 | 238.76 | 238.76 | 100.0 |
| 2017-05-12 05:00:00 | SPY | ETF | 238.76 | 238.76 | 238.73 | 238.73 | 400.0 |
| 2017-05-12 05:05:00 | SPY | ETF | 238.71 | 238.71 | 238.68 | 238.68 | 11000.0 |
| 2017-05-12 05:15:00 | SPY | ETF | 238.69 | 238.69 | 238.69 | 238.69 | 150.0 |
| 2017-05-12 05:20:00 | SPY | ETF | 238.67 | 238.67 | 238.67 | 238.67 | 100.0 |
| 2017-05-12 05:25:00 | SPY | ETF | 238.76 | 238.79 | 238.76 | 238.79 | 8100.0 |
| 2017-05-12 05:30:00 | SPY | ETF | 238.79 | 238.81 | 238.79 | 238.81 | 7000.0 |
| 2017-05-12 05:40:00 | SPY | ETF | 238.75 | 238.75 | 238.75 | 238.75 | 100.0 |
| 2017-05-12 05:45:00 | SPY | ETF | 238.75 | 238.75 | 238.71 | 238.71 | 3100.0 |
| 2017-05-12 05:50:00 | SPY | ETF | 238.73 | 238.76 | 238.73 | 238.76 | 2500.0 |
| 2017-05-12 06:00:00 | SPY | ETF | 238.76 | 238.76 | 238.76 | 238.76 | 1000.0 |
| 2017-05-12 06:10:00 | SPY | ETF | 238.71 | 238.71 | 238.69 | 238.69 | 1700.0 |
| 2017-05-12 06:15:00 | SPY | ETF | 238.75 | 238.75 | 238.75 | 238.75 | 3000.0 |
| 2017-05-12 06:20:00 | SPY | ETF | 238.79 | 238.79 | 238.79 | 238.79 | 100.0 |
| 2017-05-12 06:35:00 | SPY | ETF | 238.74 | 238.74 | 238.74 | 238.74 | 100.0 |
| 2017-05-12 06:40:00 | SPY | ETF | 238.72 | 238.74 | 238.72 | 238.74 | 1100.0 |
| 2017-05-12 06:45:00 | SPY | ETF | 238.79 | 238.79 | 238.76 | 238.79 | 1800.0 |
| 2017-05-12 06:55:00 | SPY | ETF | 238.79 | 238.79 | 238.79 | 238.79 | 2400.0 |
| 2017-05-12 07:00:00 | SPY | ETF | 238.84 | 238.89 | 238.84 | 238.89 | 1000.0 |
| 2017-05-12 07:05:00 | SPY | ETF | 238.89 | 238.89 | 238.88 | 238.88 | 3740.0 |
| 2017-05-12 07:10:00 | SPY | ETF | 238.89 | 238.92 | 238.89 | 238.89 | 4315.0 |
| 2017-05-12 07:15:00 | SPY | ETF | 238.89 | 238.92 | 238.89 | 238.92 | 669.0 |
| 2017-05-12 07:20:00 | SPY | ETF | 238.95 | 238.95 | 238.93 | 238.94 | 22909.0 |
| 2017-05-12 07:25:00 | SPY | ETF | 238.95 | 239.0 | 238.95 | 238.98 | 9069.0 |
| 2017-05-12 07:30:00 | SPY | ETF | 239.01 | 239.03 | 238.96 | 238.96 | 14189.0 |
| 2017-05-12 07:35:00 | SPY | ETF | 238.96 | 238.99 | 238.96 | 238.99 | 1338.0 |
| 2017-05-12 07:40:00 | SPY | ETF | 238.98 | 238.99 | 238.98 | 238.99 | 569.0 |
| 2017-05-12 07:45:00 | SPY | ETF | 238.98 | 239.0 | 238.98 | 238.99 | 1300.0 |
| 2017-05-12 07:50:00 | SPY | ETF | 238.97 | 238.97 | 238.96 | 238.96 | 1225.0 |
| 2017-05-12 07:55:00 | SPY | ETF | 238.98 | 238.98 | 238.86 | 238.86 | 19596.0 |
| 2017-05-12 08:00:00 | SPY | ETF | 238.89 | 238.99 | 238.84 | 238.97 | 173898.0 |
| 2017-05-12 08:05:00 | SPY | ETF | 238.98 | 238.98 | 238.92 | 238.92 | 5286.0 |
| 2017-05-12 08:10:00 | SPY | ETF | 238.93 | 238.93 | 238.9 | 238.9 | 7538.0 |
| 2017-05-12 08:15:00 | SPY | ETF | 238.9 | 238.93 | 238.89 | 238.93 | 61956.0 |
| 2017-05-12 08:20:00 | SPY | ETF | 238.93 | 238.95 | 238.92 | 238.95 | 25825.0 |
| 2017-05-12 08:25:00 | SPY | ETF | 238.95 | 238.99 | 238.94 | 238.98 | 9840.0 |
| 2017-05-12 08:30:00 | SPY | ETF | 238.95 | 239.03 | 238.82 | 239.02 | 68647.0 |
| 2017-05-12 08:35:00 | SPY | ETF | 239.02 | 239.02 | 238.97 | 239.02 | 14106.0 |
| 2017-05-12 08:40:00 | SPY | ETF | 239.0 | 239.06 | 238.99 | 239.05 | 23703.0 |
| 2017-05-12 08:45:00 | SPY | ETF | 239.06 | 239.26 | 239.06 | 239.19 | 60204.0 |
| 2017-05-12 08:50:00 | SPY | ETF | 239.19 | 239.21 | 239.14 | 239.14 | 4054.0 |
| 2017-05-12 08:55:00 | SPY | ETF | 239.16 | 239.18 | 239.16 | 239.17 | 1609.0 |
| 2017-05-12 09:00:00 | SPY | ETF | 239.17 | 239.23 | 239.16 | 239.2 | 21406.0 |
> showing 50 of 51,180 rows — these rows as CSV