PREVIEW / etf_5min / 2021-03-19
file: by_date/etf_5min/2021/2021-03-19.parquet size: 1.8 MB rows: 84,212
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 |
|---|---|---|---|---|---|---|---|
| 2021-03-19 04:00:00 | SPY | ETF | 391.8 | 391.8 | 390.73 | 391.26 | 8718.0 |
| 2021-03-19 04:05:00 | SPY | ETF | 391.24 | 391.55 | 391.24 | 391.5 | 1180.0 |
| 2021-03-19 04:10:00 | SPY | ETF | 391.43 | 391.53 | 391.41 | 391.51 | 2750.0 |
| 2021-03-19 04:15:00 | SPY | ETF | 391.56 | 391.64 | 391.56 | 391.64 | 200.0 |
| 2021-03-19 04:20:00 | SPY | ETF | 391.66 | 391.66 | 391.66 | 391.66 | 130.0 |
| 2021-03-19 04:25:00 | SPY | ETF | 391.46 | 391.68 | 391.46 | 391.68 | 780.0 |
| 2021-03-19 04:30:00 | SPY | ETF | 391.81 | 391.81 | 391.59 | 391.78 | 6400.0 |
| 2021-03-19 04:35:00 | SPY | ETF | 391.65 | 391.65 | 391.65 | 391.65 | 100.0 |
| 2021-03-19 04:40:00 | SPY | ETF | 391.62 | 391.71 | 391.54 | 391.71 | 1300.0 |
| 2021-03-19 04:45:00 | SPY | ETF | 391.7 | 391.7 | 391.7 | 391.7 | 300.0 |
| 2021-03-19 04:50:00 | SPY | ETF | 391.74 | 391.74 | 391.7 | 391.7 | 3100.0 |
| 2021-03-19 04:55:00 | SPY | ETF | 391.73 | 391.73 | 391.72 | 391.73 | 900.0 |
| 2021-03-19 05:00:00 | SPY | ETF | 391.6 | 391.6 | 391.54 | 391.54 | 200.0 |
| 2021-03-19 05:05:00 | SPY | ETF | 391.62 | 391.62 | 391.42 | 391.45 | 5500.0 |
| 2021-03-19 05:10:00 | SPY | ETF | 391.62 | 391.62 | 391.62 | 391.62 | 1300.0 |
| 2021-03-19 05:15:00 | SPY | ETF | 391.76 | 391.76 | 391.65 | 391.65 | 5900.0 |
| 2021-03-19 05:20:00 | SPY | ETF | 391.66 | 391.68 | 391.5 | 391.68 | 3300.0 |
| 2021-03-19 05:25:00 | SPY | ETF | 391.59 | 391.59 | 391.59 | 391.59 | 500.0 |
| 2021-03-19 05:30:00 | SPY | ETF | 391.49 | 391.54 | 391.36 | 391.54 | 3400.0 |
| 2021-03-19 05:35:00 | SPY | ETF | 391.5 | 391.5 | 391.48 | 391.48 | 700.0 |
| 2021-03-19 05:40:00 | SPY | ETF | 391.4 | 391.49 | 391.4 | 391.48 | 4130.0 |
| 2021-03-19 05:45:00 | SPY | ETF | 391.52 | 391.6 | 391.49 | 391.6 | 1730.0 |
| 2021-03-19 05:50:00 | SPY | ETF | 391.52 | 391.52 | 391.4 | 391.43 | 1675.0 |
| 2021-03-19 05:55:00 | SPY | ETF | 391.4 | 391.4 | 391.4 | 391.4 | 120.0 |
| 2021-03-19 06:00:00 | SPY | ETF | 391.39 | 391.39 | 391.26 | 391.26 | 2400.0 |
| 2021-03-19 06:05:00 | SPY | ETF | 391.39 | 391.41 | 391.37 | 391.41 | 6898.0 |
| 2021-03-19 06:10:00 | SPY | ETF | 391.43 | 391.45 | 390.95 | 391.03 | 6009.0 |
| 2021-03-19 06:15:00 | SPY | ETF | 390.89 | 391.13 | 390.89 | 391.02 | 1500.0 |
| 2021-03-19 06:20:00 | SPY | ETF | 390.95 | 391.05 | 390.95 | 391.05 | 200.0 |
| 2021-03-19 06:25:00 | SPY | ETF | 391.1 | 391.16 | 391.09 | 391.16 | 1397.0 |
| 2021-03-19 06:30:00 | SPY | ETF | 391.35 | 391.36 | 391.3 | 391.3 | 13300.0 |
| 2021-03-19 06:35:00 | SPY | ETF | 391.29 | 391.3 | 391.16 | 391.16 | 4863.0 |
| 2021-03-19 06:40:00 | SPY | ETF | 391.36 | 391.4 | 391.29 | 391.29 | 2590.0 |
| 2021-03-19 06:45:00 | SPY | ETF | 391.33 | 391.48 | 391.33 | 391.48 | 999.0 |
| 2021-03-19 06:50:00 | SPY | ETF | 391.5 | 391.68 | 391.49 | 391.56 | 6830.0 |
| 2021-03-19 06:55:00 | SPY | ETF | 391.5 | 391.56 | 391.5 | 391.56 | 200.0 |
| 2021-03-19 07:00:00 | SPY | ETF | 391.6 | 391.6 | 391.45 | 391.53 | 8610.0 |
| 2021-03-19 07:05:00 | SPY | ETF | 391.51 | 391.58 | 391.3 | 391.399 | 56684.0 |
| 2021-03-19 07:10:00 | SPY | ETF | 391.43 | 391.43 | 391.2 | 391.31 | 7196.0 |
| 2021-03-19 07:15:00 | SPY | ETF | 391.24 | 391.4 | 391.24 | 391.33 | 8800.0 |
| 2021-03-19 07:20:00 | SPY | ETF | 391.3 | 391.3 | 390.61 | 390.65 | 18234.0 |
| 2021-03-19 07:25:00 | SPY | ETF | 390.65 | 390.72 | 390.45 | 390.7 | 42285.0 |
| 2021-03-19 07:30:00 | SPY | ETF | 390.79 | 390.84 | 390.75 | 390.81 | 10801.0 |
| 2021-03-19 07:35:00 | SPY | ETF | 390.83 | 391.0 | 390.82 | 390.95 | 6899.0 |
| 2021-03-19 07:40:00 | SPY | ETF | 391.08 | 391.1 | 390.98 | 391.1 | 12269.0 |
| 2021-03-19 07:45:00 | SPY | ETF | 391.09 | 391.1 | 390.98 | 391.09 | 7788.0 |
| 2021-03-19 07:50:00 | SPY | ETF | 391.09 | 391.09 | 390.98 | 391.01 | 2425.0 |
| 2021-03-19 07:55:00 | SPY | ETF | 391.0 | 391.14 | 390.98 | 391.04 | 28003.0 |
| 2021-03-19 08:00:00 | SPY | ETF | 390.8 | 391.55 | 389.83 | 391.07 | 35468.0 |
| 2021-03-19 08:05:00 | SPY | ETF | 391.04 | 391.12 | 390.98 | 391.11 | 16105.0 |
> showing 50 of 84,212 rows — these rows as CSV