PREVIEW / etf_5min / 2021-04-20
file: by_date/etf_5min/2021/2021-04-20.parquet size: 1.8 MB rows: 86,453
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-04-20 04:00:00 | SPY | ETF | 415.66 | 415.72 | 415.51 | 415.52 | 7460.0 |
| 2021-04-20 04:05:00 | SPY | ETF | 415.41 | 415.5 | 415.39 | 415.49 | 1500.0 |
| 2021-04-20 04:10:00 | SPY | ETF | 415.39 | 415.45 | 415.3 | 415.43 | 3620.0 |
| 2021-04-20 04:15:00 | SPY | ETF | 415.34 | 415.51 | 415.34 | 415.51 | 1100.0 |
| 2021-04-20 04:20:00 | SPY | ETF | 415.51 | 415.61 | 415.51 | 415.6 | 2800.0 |
| 2021-04-20 04:25:00 | SPY | ETF | 415.6 | 415.63 | 415.44 | 415.44 | 1640.0 |
| 2021-04-20 04:30:00 | SPY | ETF | 415.31 | 415.31 | 415.31 | 415.31 | 600.0 |
| 2021-04-20 04:35:00 | SPY | ETF | 415.25 | 415.25 | 415.22 | 415.22 | 300.0 |
| 2021-04-20 04:40:00 | SPY | ETF | 415.1 | 415.1 | 415.1 | 415.1 | 200.0 |
| 2021-04-20 04:45:00 | SPY | ETF | 415.02 | 415.13 | 415.0 | 415.09 | 2792.0 |
| 2021-04-20 04:50:00 | SPY | ETF | 415.31 | 415.31 | 415.31 | 415.31 | 100.0 |
| 2021-04-20 04:55:00 | SPY | ETF | 415.01 | 415.09 | 415.01 | 415.08 | 17800.0 |
| 2021-04-20 05:05:00 | SPY | ETF | 415.02 | 415.02 | 414.85 | 414.85 | 2007.0 |
| 2021-04-20 05:10:00 | SPY | ETF | 414.92 | 415.0 | 414.92 | 415.0 | 500.0 |
| 2021-04-20 05:15:00 | SPY | ETF | 414.92 | 414.92 | 414.75 | 414.75 | 1400.0 |
| 2021-04-20 05:20:00 | SPY | ETF | 414.75 | 414.75 | 414.66 | 414.66 | 4199.0 |
| 2021-04-20 05:25:00 | SPY | ETF | 414.59 | 414.59 | 414.25 | 414.25 | 5399.0 |
| 2021-04-20 05:30:00 | SPY | ETF | 414.23 | 414.23 | 413.8 | 413.95 | 25690.0 |
| 2021-04-20 05:35:00 | SPY | ETF | 413.96 | 413.99 | 413.85 | 413.92 | 6889.0 |
| 2021-04-20 05:40:00 | SPY | ETF | 413.95 | 413.95 | 413.65 | 413.91 | 7200.0 |
| 2021-04-20 05:45:00 | SPY | ETF | 413.82 | 413.82 | 413.35 | 413.57 | 16509.0 |
| 2021-04-20 05:50:00 | SPY | ETF | 413.55 | 413.67 | 413.55 | 413.67 | 2800.0 |
| 2021-04-20 05:55:00 | SPY | ETF | 413.72 | 413.72 | 413.4 | 413.55 | 3800.0 |
| 2021-04-20 06:00:00 | SPY | ETF | 413.54 | 413.57 | 413.54 | 413.57 | 600.0 |
| 2021-04-20 06:05:00 | SPY | ETF | 413.51 | 413.51 | 413.3 | 413.45 | 3990.0 |
| 2021-04-20 06:10:00 | SPY | ETF | 413.44 | 413.44 | 413.36 | 413.37 | 2600.0 |
| 2021-04-20 06:15:00 | SPY | ETF | 413.4 | 413.4 | 413.3 | 413.33 | 1100.0 |
| 2021-04-20 06:20:00 | SPY | ETF | 413.31 | 413.34 | 413.23 | 413.34 | 2300.0 |
| 2021-04-20 06:25:00 | SPY | ETF | 413.33 | 413.55 | 413.32 | 413.55 | 1505.0 |
| 2021-04-20 06:30:00 | SPY | ETF | 413.56 | 413.75 | 413.55 | 413.58 | 4680.0 |
| 2021-04-20 06:35:00 | SPY | ETF | 413.5 | 413.62 | 413.45 | 413.55 | 5200.0 |
| 2021-04-20 06:40:00 | SPY | ETF | 413.58 | 413.58 | 412.68 | 412.89 | 12330.0 |
| 2021-04-20 06:45:00 | SPY | ETF | 412.88 | 413.18 | 412.86 | 413.18 | 2900.0 |
| 2021-04-20 06:50:00 | SPY | ETF | 413.16 | 413.34 | 413.02 | 413.34 | 52133.0 |
| 2021-04-20 06:55:00 | SPY | ETF | 413.42 | 413.59 | 413.42 | 413.55 | 10500.0 |
| 2021-04-20 07:00:00 | SPY | ETF | 413.57 | 413.6 | 413.4 | 413.43 | 45861.0 |
| 2021-04-20 07:05:00 | SPY | ETF | 413.35 | 413.57 | 413.3 | 413.51 | 14098.0 |
| 2021-04-20 07:10:00 | SPY | ETF | 413.52 | 413.63 | 413.48 | 413.55 | 22442.0 |
| 2021-04-20 07:15:00 | SPY | ETF | 413.55 | 413.58 | 413.25 | 413.31 | 16855.0 |
| 2021-04-20 07:20:00 | SPY | ETF | 413.35 | 413.55 | 413.26 | 413.32 | 13553.0 |
| 2021-04-20 07:25:00 | SPY | ETF | 413.4 | 413.44 | 413.27 | 413.35 | 2384.0 |
| 2021-04-20 07:30:00 | SPY | ETF | 413.35 | 413.57 | 413.35 | 413.57 | 8976.0 |
| 2021-04-20 07:35:00 | SPY | ETF | 413.53 | 413.73 | 413.52 | 413.63 | 38822.0 |
| 2021-04-20 07:40:00 | SPY | ETF | 413.61 | 413.69 | 413.61 | 413.66 | 11925.0 |
| 2021-04-20 07:45:00 | SPY | ETF | 413.66 | 413.69 | 413.61 | 413.65 | 10841.0 |
| 2021-04-20 07:50:00 | SPY | ETF | 413.62 | 413.7 | 413.6 | 413.66 | 38206.0 |
| 2021-04-20 07:55:00 | SPY | ETF | 413.63 | 413.68 | 413.62 | 413.63 | 12242.0 |
| 2021-04-20 08:00:00 | SPY | ETF | 413.4301 | 413.74 | 413.2204 | 413.69 | 68917.0 |
| 2021-04-20 08:05:00 | SPY | ETF | 413.73 | 413.74 | 413.6 | 413.69 | 13825.0 |
| 2021-04-20 08:10:00 | SPY | ETF | 413.69 | 413.75 | 413.6 | 413.68 | 18454.0 |
> showing 50 of 86,453 rows — these rows as CSV