PREVIEW / etf_5min / 2019-04-17
file: by_date/etf_5min/2019/2019-04-17.parquet size: 1.4 MB rows: 62,140
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 |
|---|---|---|---|---|---|---|---|
| 2019-04-17 04:00:00 | SPY | ETF | 290.52 | 290.52 | 290.52 | 290.52 | 325.0 |
| 2019-04-17 04:05:00 | SPY | ETF | 290.68 | 290.68 | 290.66 | 290.66 | 290.0 |
| 2019-04-17 04:10:00 | SPY | ETF | 290.67 | 290.68 | 290.67 | 290.68 | 315.0 |
| 2019-04-17 04:15:00 | SPY | ETF | 290.71 | 290.71 | 290.69 | 290.71 | 2300.0 |
| 2019-04-17 04:30:00 | SPY | ETF | 290.66 | 290.69 | 290.64 | 290.69 | 1710.0 |
| 2019-04-17 04:50:00 | SPY | ETF | 290.66 | 290.69 | 290.66 | 290.69 | 5197.0 |
| 2019-04-17 04:55:00 | SPY | ETF | 290.69 | 290.69 | 290.68 | 290.68 | 4269.0 |
| 2019-04-17 05:00:00 | SPY | ETF | 290.69 | 290.78 | 290.68 | 290.78 | 2262.0 |
| 2019-04-17 05:05:00 | SPY | ETF | 290.74 | 290.78 | 290.74 | 290.77 | 1322.0 |
| 2019-04-17 05:10:00 | SPY | ETF | 290.69 | 290.78 | 290.69 | 290.77 | 1755.0 |
| 2019-04-17 05:20:00 | SPY | ETF | 290.68 | 290.69 | 290.66 | 290.69 | 1576.0 |
| 2019-04-17 05:25:00 | SPY | ETF | 290.71 | 290.71 | 290.68 | 290.68 | 1569.0 |
| 2019-04-17 05:30:00 | SPY | ETF | 290.72 | 290.78 | 290.72 | 290.78 | 469.0 |
| 2019-04-17 05:35:00 | SPY | ETF | 290.8 | 290.81 | 290.8 | 290.81 | 594.0 |
| 2019-04-17 05:40:00 | SPY | ETF | 290.79 | 290.81 | 290.79 | 290.8 | 3000.0 |
| 2019-04-17 05:50:00 | SPY | ETF | 290.79 | 290.8 | 290.79 | 290.79 | 888.0 |
| 2019-04-17 06:05:00 | SPY | ETF | 290.82 | 290.82 | 290.82 | 290.82 | 200.0 |
| 2019-04-17 06:10:00 | SPY | ETF | 290.81 | 290.81 | 290.79 | 290.79 | 369.0 |
| 2019-04-17 06:15:00 | SPY | ETF | 290.79 | 290.79 | 290.79 | 290.79 | 231.0 |
| 2019-04-17 06:20:00 | SPY | ETF | 290.77 | 290.77 | 290.77 | 290.77 | 169.0 |
| 2019-04-17 06:25:00 | SPY | ETF | 290.77 | 290.8 | 290.77 | 290.79 | 13350.0 |
| 2019-04-17 06:30:00 | SPY | ETF | 290.8 | 290.8 | 290.79 | 290.79 | 3080.0 |
| 2019-04-17 06:35:00 | SPY | ETF | 290.78 | 290.81 | 290.77 | 290.81 | 10081.0 |
| 2019-04-17 06:40:00 | SPY | ETF | 290.78 | 290.78 | 290.72 | 290.72 | 600.0 |
| 2019-04-17 06:45:00 | SPY | ETF | 290.77 | 290.77 | 290.77 | 290.77 | 2000.0 |
| 2019-04-17 06:50:00 | SPY | ETF | 290.74 | 290.76 | 290.74 | 290.76 | 303.0 |
| 2019-04-17 07:00:00 | SPY | ETF | 290.7 | 290.78 | 290.7 | 290.78 | 5158.0 |
| 2019-04-17 07:05:00 | SPY | ETF | 290.78 | 290.85 | 290.78 | 290.83 | 3587.0 |
| 2019-04-17 07:10:00 | SPY | ETF | 290.83 | 290.9 | 290.83 | 290.87 | 9721.0 |
| 2019-04-17 07:15:00 | SPY | ETF | 290.84 | 290.87 | 290.82 | 290.82 | 3174.0 |
| 2019-04-17 07:20:00 | SPY | ETF | 290.84 | 290.87 | 290.84 | 290.86 | 2260.0 |
| 2019-04-17 07:25:00 | SPY | ETF | 290.86 | 290.86 | 290.86 | 290.86 | 100.0 |
| 2019-04-17 07:30:00 | SPY | ETF | 290.84 | 290.9 | 290.84 | 290.89 | 7690.0 |
| 2019-04-17 07:35:00 | SPY | ETF | 290.9 | 290.92 | 290.89 | 290.92 | 3760.0 |
| 2019-04-17 07:40:00 | SPY | ETF | 290.87 | 290.95 | 290.87 | 290.95 | 4165.0 |
| 2019-04-17 07:45:00 | SPY | ETF | 290.92 | 290.92 | 290.89 | 290.92 | 1130.0 |
| 2019-04-17 07:50:00 | SPY | ETF | 290.92 | 290.92 | 290.85 | 290.88 | 52749.0 |
| 2019-04-17 07:55:00 | SPY | ETF | 290.89 | 290.9 | 290.89 | 290.89 | 2948.0 |
| 2019-04-17 08:00:00 | SPY | ETF | 290.7401 | 290.98 | 290.46 | 290.98 | 46412.0 |
| 2019-04-17 08:05:00 | SPY | ETF | 290.95 | 290.95 | 290.92 | 290.92 | 28410.0 |
| 2019-04-17 08:10:00 | SPY | ETF | 290.94 | 290.96 | 290.92 | 290.96 | 11650.0 |
| 2019-04-17 08:15:00 | SPY | ETF | 290.94 | 290.96 | 290.93 | 290.95 | 14756.0 |
| 2019-04-17 08:20:00 | SPY | ETF | 290.96 | 290.96 | 290.92 | 290.94 | 26144.0 |
| 2019-04-17 08:25:00 | SPY | ETF | 290.97 | 290.97 | 290.92 | 290.92 | 33285.0 |
| 2019-04-17 08:30:00 | SPY | ETF | 290.92 | 291.0 | 290.92 | 291.0 | 25846.0 |
| 2019-04-17 08:35:00 | SPY | ETF | 290.98 | 291.0199 | 290.95 | 291.01 | 17227.0 |
| 2019-04-17 08:40:00 | SPY | ETF | 291.02 | 291.04 | 291.01 | 291.04 | 13335.0 |
| 2019-04-17 08:45:00 | SPY | ETF | 291.04 | 291.14 | 291.03 | 291.09 | 54407.0 |
| 2019-04-17 08:50:00 | SPY | ETF | 291.09 | 291.09 | 291.07 | 291.07 | 11725.0 |
| 2019-04-17 08:55:00 | SPY | ETF | 291.07 | 291.09 | 291.04 | 291.08 | 47119.0 |
> showing 50 of 62,140 rows — these rows as CSV