PREVIEW / etf_5min / 2021-05-14
file: by_date/etf_5min/2021/2021-05-14.parquet size: 1.8 MB rows: 82,742
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-05-14 04:00:00 | SPY | ETF | 412.13 | 412.32 | 412.0 | 412.32 | 2006.0 |
| 2021-05-14 04:05:00 | SPY | ETF | 412.46 | 412.46 | 412.14 | 412.14 | 6800.0 |
| 2021-05-14 04:10:00 | SPY | ETF | 412.19 | 412.3 | 412.19 | 412.3 | 600.0 |
| 2021-05-14 04:15:00 | SPY | ETF | 412.3 | 412.48 | 412.3 | 412.48 | 4200.0 |
| 2021-05-14 04:20:00 | SPY | ETF | 412.59 | 412.64 | 412.57 | 412.57 | 1100.0 |
| 2021-05-14 04:25:00 | SPY | ETF | 412.5 | 412.5 | 412.5 | 412.5 | 250.0 |
| 2021-05-14 04:30:00 | SPY | ETF | 412.69 | 412.7 | 412.69 | 412.69 | 450.0 |
| 2021-05-14 04:35:00 | SPY | ETF | 412.76 | 412.92 | 412.76 | 412.88 | 2100.0 |
| 2021-05-14 04:40:00 | SPY | ETF | 412.86 | 412.86 | 412.75 | 412.75 | 1360.0 |
| 2021-05-14 04:45:00 | SPY | ETF | 412.73 | 412.73 | 412.67 | 412.72 | 7100.0 |
| 2021-05-14 04:50:00 | SPY | ETF | 412.96 | 412.99 | 412.94 | 412.99 | 793.0 |
| 2021-05-14 04:55:00 | SPY | ETF | 412.94 | 412.94 | 412.83 | 412.83 | 1700.0 |
| 2021-05-14 05:00:00 | SPY | ETF | 412.92 | 413.06 | 412.87 | 413.0 | 2914.0 |
| 2021-05-14 05:05:00 | SPY | ETF | 412.95 | 413.15 | 412.95 | 413.12 | 2400.0 |
| 2021-05-14 05:10:00 | SPY | ETF | 413.19 | 413.34 | 413.19 | 413.2 | 6200.0 |
| 2021-05-14 05:15:00 | SPY | ETF | 413.13 | 413.42 | 413.13 | 413.37 | 1506.0 |
| 2021-05-14 05:20:00 | SPY | ETF | 413.38 | 413.38 | 413.23 | 413.25 | 2150.0 |
| 2021-05-14 05:25:00 | SPY | ETF | 413.22 | 413.23 | 413.19 | 413.19 | 1200.0 |
| 2021-05-14 05:30:00 | SPY | ETF | 413.08 | 413.17 | 413.08 | 413.14 | 1200.0 |
| 2021-05-14 05:35:00 | SPY | ETF | 413.14 | 413.2 | 413.13 | 413.16 | 1100.0 |
| 2021-05-14 05:40:00 | SPY | ETF | 413.15 | 413.15 | 413.09 | 413.12 | 2400.0 |
| 2021-05-14 05:45:00 | SPY | ETF | 413.2 | 413.2 | 413.08 | 413.17 | 1350.0 |
| 2021-05-14 05:50:00 | SPY | ETF | 413.0 | 413.0 | 413.0 | 413.0 | 300.0 |
| 2021-05-14 05:55:00 | SPY | ETF | 413.01 | 413.01 | 412.8 | 412.8 | 2600.0 |
| 2021-05-14 06:00:00 | SPY | ETF | 412.97 | 412.98 | 412.88 | 412.88 | 1900.0 |
| 2021-05-14 06:05:00 | SPY | ETF | 412.88 | 412.88 | 412.88 | 412.88 | 1000.0 |
| 2021-05-14 06:10:00 | SPY | ETF | 412.85 | 412.96 | 412.73 | 412.73 | 1800.0 |
| 2021-05-14 06:15:00 | SPY | ETF | 412.81 | 412.85 | 412.81 | 412.85 | 400.0 |
| 2021-05-14 06:20:00 | SPY | ETF | 412.98 | 412.98 | 412.9 | 412.9 | 500.0 |
| 2021-05-14 06:25:00 | SPY | ETF | 413.0 | 413.0 | 412.88 | 412.88 | 798.0 |
| 2021-05-14 06:30:00 | SPY | ETF | 412.95 | 413.0 | 412.83 | 412.83 | 28251.0 |
| 2021-05-14 06:35:00 | SPY | ETF | 412.74 | 412.74 | 412.67 | 412.71 | 13500.0 |
| 2021-05-14 06:45:00 | SPY | ETF | 412.68 | 412.89 | 412.68 | 412.76 | 5100.0 |
| 2021-05-14 06:50:00 | SPY | ETF | 412.92 | 413.02 | 412.91 | 413.0 | 16273.0 |
| 2021-05-14 06:55:00 | SPY | ETF | 413.0 | 413.0 | 412.79 | 412.79 | 10300.0 |
| 2021-05-14 07:00:00 | SPY | ETF | 412.76 | 413.05 | 412.63 | 413.0 | 36553.0 |
| 2021-05-14 07:05:00 | SPY | ETF | 413.0 | 413.2 | 412.95 | 413.11 | 32639.0 |
| 2021-05-14 07:10:00 | SPY | ETF | 413.1 | 413.1 | 412.97 | 413.01 | 5953.0 |
| 2021-05-14 07:15:00 | SPY | ETF | 412.99 | 412.99 | 412.85 | 412.9 | 5491.0 |
| 2021-05-14 07:20:00 | SPY | ETF | 412.97 | 412.99 | 412.9 | 412.91 | 4478.0 |
| 2021-05-14 07:25:00 | SPY | ETF | 412.87 | 413.16 | 412.86 | 413.15 | 7551.0 |
| 2021-05-14 07:30:00 | SPY | ETF | 413.19 | 413.4 | 413.07 | 413.23 | 65677.0 |
| 2021-05-14 07:35:00 | SPY | ETF | 413.24 | 413.24 | 413.05 | 413.05 | 13020.0 |
| 2021-05-14 07:40:00 | SPY | ETF | 413.14 | 413.25 | 413.09 | 413.24 | 49112.0 |
| 2021-05-14 07:45:00 | SPY | ETF | 413.24 | 413.32 | 413.07 | 413.07 | 77266.0 |
| 2021-05-14 07:50:00 | SPY | ETF | 413.07 | 413.15 | 413.0 | 413.08 | 51769.0 |
| 2021-05-14 07:55:00 | SPY | ETF | 413.08 | 413.24 | 413.04 | 413.14 | 8447.0 |
| 2021-05-14 08:00:00 | SPY | ETF | 412.86 | 413.37 | 412.02 | 413.23 | 35938.0 |
| 2021-05-14 08:05:00 | SPY | ETF | 413.24 | 413.24 | 413.05 | 413.17 | 43424.0 |
| 2021-05-14 08:10:00 | SPY | ETF | 413.17 | 413.25 | 413.06 | 413.06 | 52468.0 |
> showing 50 of 82,742 rows — these rows as CSV