PREVIEW / etf_5min / 2019-10-15
file: by_date/etf_5min/2019/2019-10-15.parquet size: 1.4 MB rows: 61,480
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-10-15 04:00:00 | SPY | ETF | 297.32 | 297.32 | 297.24 | 297.24 | 5051.0 |
| 2019-10-15 04:05:00 | SPY | ETF | 297.2 | 297.2 | 297.2 | 297.2 | 150.0 |
| 2019-10-15 04:10:00 | SPY | ETF | 297.2 | 297.36 | 297.2 | 297.36 | 970.0 |
| 2019-10-15 04:15:00 | SPY | ETF | 297.33 | 297.33 | 297.32 | 297.32 | 2700.0 |
| 2019-10-15 04:20:00 | SPY | ETF | 297.43 | 297.43 | 297.32 | 297.32 | 300.0 |
| 2019-10-15 04:30:00 | SPY | ETF | 297.5 | 297.62 | 297.5 | 297.62 | 4405.0 |
| 2019-10-15 04:35:00 | SPY | ETF | 297.5 | 297.5 | 297.38 | 297.38 | 1000.0 |
| 2019-10-15 04:45:00 | SPY | ETF | 297.41 | 297.41 | 297.2 | 297.2 | 850.0 |
| 2019-10-15 04:50:00 | SPY | ETF | 297.19 | 297.19 | 297.1 | 297.1 | 2500.0 |
| 2019-10-15 04:55:00 | SPY | ETF | 297.1 | 297.1 | 297.05 | 297.05 | 1167.0 |
| 2019-10-15 05:00:00 | SPY | ETF | 297.03 | 297.03 | 297.03 | 297.03 | 200.0 |
| 2019-10-15 05:15:00 | SPY | ETF | 297.18 | 297.18 | 297.18 | 297.18 | 100.0 |
| 2019-10-15 05:25:00 | SPY | ETF | 297.13 | 297.13 | 297.13 | 297.13 | 1000.0 |
| 2019-10-15 05:30:00 | SPY | ETF | 297.18 | 297.18 | 297.11 | 297.13 | 1600.0 |
| 2019-10-15 05:35:00 | SPY | ETF | 297.23 | 297.23 | 297.19 | 297.19 | 200.0 |
| 2019-10-15 05:40:00 | SPY | ETF | 297.14 | 297.14 | 297.14 | 297.14 | 101.0 |
| 2019-10-15 05:50:00 | SPY | ETF | 297.13 | 297.13 | 297.13 | 297.13 | 300.0 |
| 2019-10-15 05:55:00 | SPY | ETF | 297.19 | 297.29 | 297.19 | 297.29 | 625.0 |
| 2019-10-15 06:00:00 | SPY | ETF | 297.28 | 297.38 | 297.24 | 297.38 | 615.0 |
| 2019-10-15 06:05:00 | SPY | ETF | 297.33 | 297.33 | 297.33 | 297.33 | 950.0 |
| 2019-10-15 06:10:00 | SPY | ETF | 297.33 | 297.33 | 297.33 | 297.33 | 250.0 |
| 2019-10-15 06:15:00 | SPY | ETF | 297.33 | 297.33 | 297.03 | 297.08 | 5350.0 |
| 2019-10-15 06:20:00 | SPY | ETF | 297.13 | 297.13 | 296.56 | 296.7 | 12353.0 |
| 2019-10-15 06:25:00 | SPY | ETF | 296.71 | 296.71 | 296.61 | 296.61 | 4100.0 |
| 2019-10-15 06:30:00 | SPY | ETF | 296.67 | 296.78 | 296.65 | 296.78 | 4680.0 |
| 2019-10-15 06:35:00 | SPY | ETF | 296.73 | 296.73 | 296.64 | 296.65 | 4772.0 |
| 2019-10-15 06:40:00 | SPY | ETF | 296.73 | 296.8 | 296.73 | 296.8 | 4779.0 |
| 2019-10-15 06:45:00 | SPY | ETF | 296.85 | 296.88 | 296.85 | 296.88 | 700.0 |
| 2019-10-15 06:50:00 | SPY | ETF | 296.9 | 296.99 | 296.82 | 296.89 | 1611.0 |
| 2019-10-15 06:55:00 | SPY | ETF | 296.9 | 296.95 | 296.85 | 296.9 | 7585.0 |
| 2019-10-15 07:00:00 | SPY | ETF | 296.85 | 297.17 | 296.8 | 297.13 | 10635.0 |
| 2019-10-15 07:05:00 | SPY | ETF | 297.06 | 297.07 | 296.95 | 297.0 | 7994.0 |
| 2019-10-15 07:10:00 | SPY | ETF | 296.9 | 296.95 | 296.9 | 296.95 | 683.0 |
| 2019-10-15 07:15:00 | SPY | ETF | 296.88 | 296.92 | 296.87 | 296.9 | 1637.0 |
| 2019-10-15 07:20:00 | SPY | ETF | 296.9 | 296.9 | 296.85 | 296.87 | 4889.0 |
| 2019-10-15 07:25:00 | SPY | ETF | 296.89 | 297.03 | 296.87 | 297.03 | 4400.0 |
| 2019-10-15 07:30:00 | SPY | ETF | 297.03 | 297.03 | 296.9 | 296.95 | 4843.0 |
| 2019-10-15 07:35:00 | SPY | ETF | 296.9 | 296.9 | 296.88 | 296.88 | 1151.0 |
| 2019-10-15 07:40:00 | SPY | ETF | 296.88 | 296.9 | 296.83 | 296.84 | 5610.0 |
| 2019-10-15 07:45:00 | SPY | ETF | 296.85 | 296.85 | 296.76 | 296.76 | 11236.0 |
| 2019-10-15 07:50:00 | SPY | ETF | 296.74 | 297.24 | 296.68 | 297.1 | 31983.0 |
| 2019-10-15 07:55:00 | SPY | ETF | 297.04 | 297.07 | 296.7 | 296.86 | 47226.0 |
| 2019-10-15 08:00:00 | SPY | ETF | 296.86 | 297.6 | 296.65 | 296.73 | 22298.0 |
| 2019-10-15 08:05:00 | SPY | ETF | 296.75 | 296.84 | 296.75 | 296.8 | 23147.0 |
| 2019-10-15 08:10:00 | SPY | ETF | 296.74 | 296.88 | 296.73 | 296.82 | 15734.0 |
| 2019-10-15 08:15:00 | SPY | ETF | 296.83 | 296.92 | 296.83 | 296.89 | 19775.0 |
| 2019-10-15 08:20:00 | SPY | ETF | 296.9 | 296.92 | 296.86 | 296.89 | 16142.0 |
| 2019-10-15 08:25:00 | SPY | ETF | 296.86 | 296.93 | 296.86 | 296.89 | 9516.0 |
| 2019-10-15 08:30:00 | SPY | ETF | 296.86 | 296.94 | 296.78 | 296.87 | 19901.0 |
| 2019-10-15 08:35:00 | SPY | ETF | 296.84 | 296.84 | 296.82 | 296.82 | 3957.0 |
> showing 50 of 61,480 rows — these rows as CSV