PREVIEW / etf_5min / 2021-05-17
file: by_date/etf_5min/2021/2021-05-17.parquet size: 1.7 MB rows: 82,012
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-17 04:00:00 | SPY | ETF | 415.34 | 415.79 | 415.3 | 415.76 | 5656.0 |
| 2021-05-17 04:05:00 | SPY | ETF | 415.74 | 415.74 | 415.6 | 415.64 | 4905.0 |
| 2021-05-17 04:10:00 | SPY | ETF | 415.74 | 415.74 | 415.57 | 415.57 | 1895.0 |
| 2021-05-17 04:15:00 | SPY | ETF | 415.52 | 415.63 | 415.52 | 415.63 | 599.0 |
| 2021-05-17 04:20:00 | SPY | ETF | 415.69 | 415.88 | 415.69 | 415.88 | 1500.0 |
| 2021-05-17 04:25:00 | SPY | ETF | 415.83 | 415.83 | 415.83 | 415.83 | 100.0 |
| 2021-05-17 04:30:00 | SPY | ETF | 415.85 | 415.92 | 415.85 | 415.92 | 2677.0 |
| 2021-05-17 04:35:00 | SPY | ETF | 415.87 | 415.99 | 415.86 | 415.99 | 500.0 |
| 2021-05-17 04:40:00 | SPY | ETF | 416.06 | 416.12 | 416.02 | 416.05 | 4822.0 |
| 2021-05-17 04:45:00 | SPY | ETF | 415.98 | 415.98 | 415.98 | 415.98 | 200.0 |
| 2021-05-17 04:55:00 | SPY | ETF | 415.99 | 416.07 | 415.99 | 416.07 | 500.0 |
| 2021-05-17 05:00:00 | SPY | ETF | 415.88 | 415.98 | 415.88 | 415.97 | 2500.0 |
| 2021-05-17 05:05:00 | SPY | ETF | 415.91 | 415.91 | 415.85 | 415.85 | 3131.0 |
| 2021-05-17 05:10:00 | SPY | ETF | 416.0 | 416.0 | 415.92 | 415.92 | 900.0 |
| 2021-05-17 05:15:00 | SPY | ETF | 415.92 | 415.92 | 415.92 | 415.92 | 1706.0 |
| 2021-05-17 05:20:00 | SPY | ETF | 415.93 | 416.0 | 415.93 | 416.0 | 1300.0 |
| 2021-05-17 05:25:00 | SPY | ETF | 416.01 | 416.05 | 416.01 | 416.05 | 1000.0 |
| 2021-05-17 05:30:00 | SPY | ETF | 415.95 | 415.95 | 415.95 | 415.95 | 200.0 |
| 2021-05-17 05:40:00 | SPY | ETF | 415.77 | 415.77 | 415.6 | 415.65 | 5391.0 |
| 2021-05-17 05:45:00 | SPY | ETF | 415.83 | 415.87 | 415.83 | 415.87 | 600.0 |
| 2021-05-17 05:55:00 | SPY | ETF | 415.62 | 415.69 | 415.55 | 415.67 | 1500.0 |
| 2021-05-17 06:00:00 | SPY | ETF | 415.53 | 415.53 | 415.4 | 415.43 | 1202.0 |
| 2021-05-17 06:05:00 | SPY | ETF | 415.51 | 415.52 | 415.4 | 415.48 | 2336.0 |
| 2021-05-17 06:10:00 | SPY | ETF | 415.4 | 415.55 | 415.4 | 415.44 | 5596.0 |
| 2021-05-17 06:15:00 | SPY | ETF | 415.35 | 415.35 | 415.3 | 415.35 | 1600.0 |
| 2021-05-17 06:20:00 | SPY | ETF | 415.38 | 415.38 | 415.21 | 415.21 | 1900.0 |
| 2021-05-17 06:25:00 | SPY | ETF | 415.18 | 415.3 | 415.11 | 415.11 | 18790.0 |
| 2021-05-17 06:30:00 | SPY | ETF | 415.14 | 415.25 | 415.1 | 415.24 | 15400.0 |
| 2021-05-17 06:35:00 | SPY | ETF | 415.25 | 415.25 | 415.11 | 415.2 | 46000.0 |
| 2021-05-17 06:40:00 | SPY | ETF | 415.19 | 415.22 | 415.16 | 415.18 | 2310.0 |
| 2021-05-17 06:45:00 | SPY | ETF | 415.18 | 415.18 | 415.12 | 415.16 | 16300.0 |
| 2021-05-17 06:50:00 | SPY | ETF | 415.24 | 415.27 | 415.12 | 415.13 | 10299.0 |
| 2021-05-17 06:55:00 | SPY | ETF | 415.15 | 415.15 | 415.0 | 415.09 | 28712.0 |
| 2021-05-17 07:00:00 | SPY | ETF | 415.05 | 415.18 | 414.99 | 415.04 | 28600.0 |
| 2021-05-17 07:05:00 | SPY | ETF | 415.0 | 415.35 | 414.93 | 415.31 | 22007.0 |
| 2021-05-17 07:10:00 | SPY | ETF | 415.3 | 415.4 | 415.28 | 415.3 | 9323.0 |
| 2021-05-17 07:15:00 | SPY | ETF | 415.3 | 415.45 | 415.3 | 415.44 | 2773.0 |
| 2021-05-17 07:20:00 | SPY | ETF | 415.44 | 415.44 | 415.05 | 415.05 | 12640.0 |
| 2021-05-17 07:25:00 | SPY | ETF | 415.05 | 415.09 | 414.86 | 415.0 | 28017.0 |
| 2021-05-17 07:30:00 | SPY | ETF | 415.06 | 415.1 | 414.93 | 415.05 | 19135.0 |
| 2021-05-17 07:35:00 | SPY | ETF | 415.08 | 415.23 | 415.07 | 415.15 | 15305.0 |
| 2021-05-17 07:40:00 | SPY | ETF | 415.14 | 415.15 | 414.87 | 414.96 | 35578.0 |
| 2021-05-17 07:45:00 | SPY | ETF | 414.91 | 414.91 | 414.55 | 414.65 | 205285.0 |
| 2021-05-17 07:50:00 | SPY | ETF | 414.67 | 414.72 | 414.55 | 414.7 | 53784.0 |
| 2021-05-17 07:55:00 | SPY | ETF | 414.68 | 414.72 | 414.64 | 414.68 | 6307.0 |
| 2021-05-17 08:00:00 | SPY | ETF | 415.1099 | 416.5 | 414.55 | 414.87 | 81585.0 |
| 2021-05-17 08:05:00 | SPY | ETF | 414.87 | 414.89 | 414.84 | 414.87 | 57572.0 |
| 2021-05-17 08:10:00 | SPY | ETF | 414.86 | 414.86 | 414.58 | 414.62 | 32551.0 |
| 2021-05-17 08:15:00 | SPY | ETF | 414.6 | 414.66 | 414.45 | 414.62 | 43156.0 |
| 2021-05-17 08:20:00 | SPY | ETF | 414.7 | 414.85 | 414.69 | 414.8 | 40089.0 |
> showing 50 of 82,012 rows — these rows as CSV