PREVIEW / etf_5min / 2018-09-28
file: by_date/etf_5min/2018/2018-09-28.parquet size: 1.3 MB rows: 57,645
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 |
|---|---|---|---|---|---|---|---|
| 2018-09-28 04:00:00 | SPY | ETF | 290.41 | 290.54 | 290.41 | 290.54 | 2402.0 |
| 2018-09-28 04:10:00 | SPY | ETF | 290.66 | 290.69 | 290.66 | 290.69 | 800.0 |
| 2018-09-28 04:15:00 | SPY | ETF | 290.69 | 290.69 | 290.69 | 290.69 | 300.0 |
| 2018-09-28 04:20:00 | SPY | ETF | 290.64 | 290.64 | 290.59 | 290.59 | 1000.0 |
| 2018-09-28 04:25:00 | SPY | ETF | 290.66 | 290.66 | 290.66 | 290.66 | 300.0 |
| 2018-09-28 04:30:00 | SPY | ETF | 290.76 | 290.76 | 290.76 | 290.76 | 430.0 |
| 2018-09-28 04:50:00 | SPY | ETF | 290.79 | 290.79 | 290.79 | 290.79 | 300.0 |
| 2018-09-28 04:55:00 | SPY | ETF | 290.86 | 290.86 | 290.81 | 290.81 | 2800.0 |
| 2018-09-28 05:00:00 | SPY | ETF | 290.81 | 290.81 | 290.79 | 290.79 | 900.0 |
| 2018-09-28 05:05:00 | SPY | ETF | 290.79 | 290.79 | 290.79 | 290.79 | 100.0 |
| 2018-09-28 05:10:00 | SPY | ETF | 290.65 | 290.65 | 290.65 | 290.65 | 500.0 |
| 2018-09-28 05:15:00 | SPY | ETF | 290.7 | 290.7 | 290.65 | 290.69 | 5300.0 |
| 2018-09-28 05:20:00 | SPY | ETF | 290.59 | 290.59 | 290.58 | 290.58 | 2250.0 |
| 2018-09-28 05:35:00 | SPY | ETF | 290.54 | 290.54 | 290.51 | 290.51 | 3100.0 |
| 2018-09-28 05:40:00 | SPY | ETF | 290.51 | 290.51 | 290.51 | 290.51 | 300.0 |
| 2018-09-28 05:45:00 | SPY | ETF | 290.49 | 290.49 | 290.49 | 290.49 | 1300.0 |
| 2018-09-28 05:50:00 | SPY | ETF | 290.43 | 290.43 | 290.43 | 290.43 | 1000.0 |
| 2018-09-28 05:55:00 | SPY | ETF | 290.46 | 290.46 | 290.46 | 290.46 | 100.0 |
| 2018-09-28 06:00:00 | SPY | ETF | 290.46 | 290.46 | 290.46 | 290.46 | 500.0 |
| 2018-09-28 06:05:00 | SPY | ETF | 290.36 | 290.37 | 290.32 | 290.32 | 1510.0 |
| 2018-09-28 06:10:00 | SPY | ETF | 290.29 | 290.29 | 290.29 | 290.29 | 300.0 |
| 2018-09-28 06:15:00 | SPY | ETF | 290.29 | 290.29 | 290.11 | 290.11 | 11448.0 |
| 2018-09-28 06:20:00 | SPY | ETF | 290.06 | 290.09 | 289.99 | 290.09 | 3370.0 |
| 2018-09-28 06:25:00 | SPY | ETF | 290.11 | 290.11 | 290.09 | 290.09 | 1300.0 |
| 2018-09-28 06:30:00 | SPY | ETF | 290.11 | 290.11 | 290.06 | 290.11 | 3035.0 |
| 2018-09-28 06:35:00 | SPY | ETF | 290.03 | 290.17 | 290.02 | 290.17 | 6200.0 |
| 2018-09-28 06:40:00 | SPY | ETF | 290.16 | 290.17 | 290.15 | 290.15 | 2800.0 |
| 2018-09-28 06:45:00 | SPY | ETF | 290.21 | 290.24 | 290.21 | 290.24 | 1745.0 |
| 2018-09-28 06:50:00 | SPY | ETF | 290.32 | 290.32 | 290.29 | 290.29 | 5750.0 |
| 2018-09-28 06:55:00 | SPY | ETF | 290.15 | 290.15 | 290.08 | 290.14 | 5620.0 |
| 2018-09-28 07:00:00 | SPY | ETF | 290.17 | 290.17 | 290.01 | 290.05 | 76571.0 |
| 2018-09-28 07:05:00 | SPY | ETF | 290.02 | 290.08 | 289.9 | 289.93 | 17885.0 |
| 2018-09-28 07:10:00 | SPY | ETF | 289.99 | 290.02 | 289.95 | 289.99 | 14515.0 |
| 2018-09-28 07:15:00 | SPY | ETF | 289.99 | 290.0 | 289.95 | 289.95 | 24557.0 |
| 2018-09-28 07:20:00 | SPY | ETF | 289.93 | 289.94 | 289.87 | 289.94 | 39204.0 |
| 2018-09-28 07:25:00 | SPY | ETF | 289.95 | 289.97 | 289.92 | 289.92 | 1660.0 |
| 2018-09-28 07:30:00 | SPY | ETF | 289.93 | 289.95 | 289.84 | 289.87 | 15025.0 |
| 2018-09-28 07:35:00 | SPY | ETF | 289.86 | 289.9 | 289.82 | 289.88 | 11539.0 |
| 2018-09-28 07:40:00 | SPY | ETF | 289.86 | 289.86 | 289.8 | 289.83 | 13700.0 |
| 2018-09-28 07:45:00 | SPY | ETF | 289.8 | 289.81 | 289.62 | 289.65 | 22801.0 |
| 2018-09-28 07:50:00 | SPY | ETF | 289.65 | 289.7 | 289.6 | 289.7 | 19785.0 |
| 2018-09-28 07:55:00 | SPY | ETF | 289.74 | 289.74 | 289.63 | 289.63 | 80287.0 |
| 2018-09-28 08:00:00 | SPY | ETF | 290.69 | 291.0 | 289.63 | 289.76 | 271133.0 |
| 2018-09-28 08:05:00 | SPY | ETF | 289.73 | 289.78 | 289.69 | 289.77 | 24905.0 |
| 2018-09-28 08:10:00 | SPY | ETF | 289.8 | 289.81 | 289.76 | 289.78 | 18199.0 |
| 2018-09-28 08:15:00 | SPY | ETF | 289.77 | 289.8 | 289.54 | 289.54 | 33565.0 |
| 2018-09-28 08:20:00 | SPY | ETF | 289.56 | 289.73 | 289.55 | 289.7 | 147058.0 |
| 2018-09-28 08:25:00 | SPY | ETF | 289.74 | 289.86 | 289.72 | 289.84 | 46584.0 |
| 2018-09-28 08:30:00 | SPY | ETF | 289.86 | 289.96 | 289.83 | 289.9 | 67198.0 |
| 2018-09-28 08:35:00 | SPY | ETF | 289.88 | 289.9 | 289.77 | 289.9 | 21535.0 |
> showing 50 of 57,645 rows — these rows as CSV