PREVIEW / etf_5min / 2019-02-28
file: by_date/etf_5min/2019/2019-02-28.parquet size: 1.4 MB rows: 60,731
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-02-28 04:00:00 | SPY | ETF | 278.66 | 278.7 | 278.66 | 278.68 | 1970.0 |
| 2019-02-28 04:10:00 | SPY | ETF | 278.7 | 278.72 | 278.7 | 278.72 | 1907.0 |
| 2019-02-28 04:15:00 | SPY | ETF | 278.75 | 278.75 | 278.69 | 278.69 | 776.0 |
| 2019-02-28 04:20:00 | SPY | ETF | 278.75 | 278.75 | 278.75 | 278.75 | 452.0 |
| 2019-02-28 04:25:00 | SPY | ETF | 278.77 | 278.77 | 278.77 | 278.77 | 291.0 |
| 2019-02-28 04:30:00 | SPY | ETF | 278.72 | 278.72 | 278.68 | 278.68 | 575.0 |
| 2019-02-28 04:35:00 | SPY | ETF | 278.67 | 278.67 | 278.66 | 278.66 | 269.0 |
| 2019-02-28 04:40:00 | SPY | ETF | 278.83 | 278.83 | 278.83 | 278.83 | 1079.0 |
| 2019-02-28 04:45:00 | SPY | ETF | 278.8 | 278.8 | 278.8 | 278.8 | 100.0 |
| 2019-02-28 04:50:00 | SPY | ETF | 278.77 | 278.77 | 278.77 | 278.77 | 300.0 |
| 2019-02-28 05:00:00 | SPY | ETF | 278.75 | 278.75 | 278.75 | 278.75 | 401.0 |
| 2019-02-28 05:05:00 | SPY | ETF | 278.7 | 278.7 | 278.64 | 278.64 | 1100.0 |
| 2019-02-28 05:10:00 | SPY | ETF | 278.69 | 278.69 | 278.67 | 278.68 | 5900.0 |
| 2019-02-28 05:20:00 | SPY | ETF | 278.61 | 278.61 | 278.61 | 278.61 | 200.0 |
| 2019-02-28 05:30:00 | SPY | ETF | 278.7 | 278.77 | 278.7 | 278.77 | 3500.0 |
| 2019-02-28 05:45:00 | SPY | ETF | 278.75 | 278.8 | 278.75 | 278.8 | 1500.0 |
| 2019-02-28 05:50:00 | SPY | ETF | 278.76 | 278.77 | 278.76 | 278.77 | 800.0 |
| 2019-02-28 05:55:00 | SPY | ETF | 278.76 | 278.76 | 278.75 | 278.75 | 1600.0 |
| 2019-02-28 06:00:00 | SPY | ETF | 278.74 | 278.74 | 278.74 | 278.74 | 1800.0 |
| 2019-02-28 06:05:00 | SPY | ETF | 278.7 | 278.7 | 278.65 | 278.65 | 797.0 |
| 2019-02-28 06:10:00 | SPY | ETF | 278.7 | 278.77 | 278.7 | 278.71 | 1800.0 |
| 2019-02-28 06:15:00 | SPY | ETF | 278.73 | 278.85 | 278.73 | 278.85 | 1200.0 |
| 2019-02-28 06:25:00 | SPY | ETF | 278.81 | 278.82 | 278.8 | 278.8 | 700.0 |
| 2019-02-28 06:30:00 | SPY | ETF | 278.78 | 278.78 | 278.73 | 278.73 | 1100.0 |
| 2019-02-28 06:35:00 | SPY | ETF | 278.75 | 278.75 | 278.75 | 278.75 | 1300.0 |
| 2019-02-28 06:40:00 | SPY | ETF | 278.78 | 278.8 | 278.75 | 278.75 | 3300.0 |
| 2019-02-28 06:45:00 | SPY | ETF | 278.77 | 278.8 | 278.77 | 278.8 | 200.0 |
| 2019-02-28 06:50:00 | SPY | ETF | 278.81 | 278.84 | 278.75 | 278.8 | 1300.0 |
| 2019-02-28 06:55:00 | SPY | ETF | 278.8 | 278.86 | 278.8 | 278.86 | 5000.0 |
| 2019-02-28 07:00:00 | SPY | ETF | 278.87 | 278.9 | 278.85 | 278.86 | 38410.0 |
| 2019-02-28 07:05:00 | SPY | ETF | 278.87 | 278.87 | 278.71 | 278.77 | 32502.0 |
| 2019-02-28 07:10:00 | SPY | ETF | 278.77 | 278.8 | 278.75 | 278.8 | 19850.0 |
| 2019-02-28 07:15:00 | SPY | ETF | 278.78 | 278.9 | 278.76 | 278.9 | 3100.0 |
| 2019-02-28 07:20:00 | SPY | ETF | 278.96 | 278.98 | 278.92 | 278.92 | 4413.0 |
| 2019-02-28 07:25:00 | SPY | ETF | 278.97 | 278.97 | 278.91 | 278.91 | 1169.0 |
| 2019-02-28 07:30:00 | SPY | ETF | 278.92 | 278.92 | 278.82 | 278.82 | 790.0 |
| 2019-02-28 07:35:00 | SPY | ETF | 278.87 | 279.15 | 278.87 | 279.15 | 8382.0 |
| 2019-02-28 07:40:00 | SPY | ETF | 279.1 | 279.14 | 279.1 | 279.1 | 56625.0 |
| 2019-02-28 07:45:00 | SPY | ETF | 279.1 | 279.12 | 279.07 | 279.08 | 16100.0 |
| 2019-02-28 07:50:00 | SPY | ETF | 279.07 | 279.12 | 279.05 | 279.09 | 16200.0 |
| 2019-02-28 07:55:00 | SPY | ETF | 279.09 | 279.09 | 278.97 | 279.01 | 4664.0 |
| 2019-02-28 08:00:00 | SPY | ETF | 278.85 | 279.12 | 278.3 | 279.04 | 39016.0 |
| 2019-02-28 08:05:00 | SPY | ETF | 279.03 | 279.03 | 279.0 | 279.01 | 5352.0 |
| 2019-02-28 08:10:00 | SPY | ETF | 279.01 | 279.01 | 278.91 | 278.92 | 23059.0 |
| 2019-02-28 08:15:00 | SPY | ETF | 278.91 | 278.91 | 278.88 | 278.9 | 6822.0 |
| 2019-02-28 08:20:00 | SPY | ETF | 278.9 | 278.94 | 278.79 | 278.79 | 23264.0 |
| 2019-02-28 08:25:00 | SPY | ETF | 278.82 | 278.93 | 278.8 | 278.92 | 4486.0 |
| 2019-02-28 08:30:00 | SPY | ETF | 278.98 | 279.3 | 278.92 | 279.08 | 85469.0 |
| 2019-02-28 08:35:00 | SPY | ETF | 279.05 | 279.26 | 279.0 | 279.26 | 31464.0 |
| 2019-02-28 08:40:00 | SPY | ETF | 279.26 | 279.29 | 279.17 | 279.17 | 47918.0 |
> showing 50 of 60,731 rows — these rows as CSV