PREVIEW / etf_5min / 2021-08-17
file: by_date/etf_5min/2021/2021-08-17.parquet size: 1.8 MB rows: 83,566
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-08-17 04:00:00 | SPY | ETF | 445.51 | 445.51 | 445.02 | 445.26 | 38544.0 |
| 2021-08-17 04:05:00 | SPY | ETF | 445.31 | 445.31 | 445.07 | 445.07 | 10332.0 |
| 2021-08-17 04:10:00 | SPY | ETF | 445.16 | 445.16 | 445.06 | 445.06 | 3529.0 |
| 2021-08-17 04:15:00 | SPY | ETF | 445.12 | 445.12 | 445.12 | 445.12 | 329.0 |
| 2021-08-17 04:20:00 | SPY | ETF | 445.06 | 445.07 | 444.95 | 445.07 | 26509.0 |
| 2021-08-17 04:25:00 | SPY | ETF | 445.15 | 445.2 | 445.07 | 445.07 | 390.0 |
| 2021-08-17 04:30:00 | SPY | ETF | 444.95 | 444.95 | 444.95 | 444.95 | 100.0 |
| 2021-08-17 04:35:00 | SPY | ETF | 444.92 | 445.12 | 444.89 | 445.12 | 2498.0 |
| 2021-08-17 04:40:00 | SPY | ETF | 445.12 | 445.12 | 445.12 | 445.12 | 100.0 |
| 2021-08-17 04:50:00 | SPY | ETF | 445.05 | 445.05 | 445.05 | 445.05 | 100.0 |
| 2021-08-17 04:55:00 | SPY | ETF | 445.07 | 445.07 | 445.07 | 445.07 | 135.0 |
| 2021-08-17 05:00:00 | SPY | ETF | 445.15 | 445.15 | 445.15 | 445.15 | 100.0 |
| 2021-08-17 05:05:00 | SPY | ETF | 445.07 | 445.1 | 445.07 | 445.1 | 2000.0 |
| 2021-08-17 05:10:00 | SPY | ETF | 445.36 | 445.36 | 445.3 | 445.3 | 900.0 |
| 2021-08-17 05:15:00 | SPY | ETF | 445.27 | 445.3 | 445.27 | 445.28 | 400.0 |
| 2021-08-17 05:20:00 | SPY | ETF | 445.41 | 445.41 | 445.4 | 445.4 | 3100.0 |
| 2021-08-17 05:25:00 | SPY | ETF | 445.49 | 445.5 | 445.44 | 445.48 | 2906.0 |
| 2021-08-17 05:30:00 | SPY | ETF | 445.37 | 445.37 | 445.31 | 445.31 | 5124.0 |
| 2021-08-17 05:35:00 | SPY | ETF | 445.31 | 445.31 | 445.21 | 445.21 | 2900.0 |
| 2021-08-17 05:40:00 | SPY | ETF | 445.22 | 445.22 | 445.22 | 445.22 | 500.0 |
| 2021-08-17 05:45:00 | SPY | ETF | 445.1 | 445.15 | 445.05 | 445.05 | 633.0 |
| 2021-08-17 05:50:00 | SPY | ETF | 445.0 | 445.0 | 445.0 | 445.0 | 495.0 |
| 2021-08-17 05:55:00 | SPY | ETF | 445.17 | 445.17 | 445.17 | 445.17 | 2000.0 |
| 2021-08-17 06:00:00 | SPY | ETF | 444.95 | 445.01 | 444.92 | 444.92 | 1600.0 |
| 2021-08-17 06:10:00 | SPY | ETF | 445.13 | 445.15 | 445.08 | 445.08 | 19773.0 |
| 2021-08-17 06:15:00 | SPY | ETF | 445.13 | 445.14 | 445.13 | 445.14 | 1000.0 |
| 2021-08-17 06:20:00 | SPY | ETF | 445.06 | 445.16 | 445.06 | 445.09 | 8573.0 |
| 2021-08-17 06:25:00 | SPY | ETF | 445.18 | 445.18 | 445.06 | 445.06 | 600.0 |
| 2021-08-17 06:30:00 | SPY | ETF | 445.12 | 445.13 | 445.01 | 445.09 | 5800.0 |
| 2021-08-17 06:35:00 | SPY | ETF | 445.03 | 445.03 | 444.92 | 444.96 | 11400.0 |
| 2021-08-17 06:40:00 | SPY | ETF | 444.92 | 444.92 | 444.83 | 444.85 | 3800.0 |
| 2021-08-17 06:45:00 | SPY | ETF | 444.85 | 444.98 | 444.85 | 444.98 | 12700.0 |
| 2021-08-17 06:50:00 | SPY | ETF | 444.98 | 445.01 | 444.96 | 444.96 | 18260.0 |
| 2021-08-17 06:55:00 | SPY | ETF | 444.99 | 445.0 | 444.98 | 444.99 | 2170.0 |
| 2021-08-17 07:00:00 | SPY | ETF | 445.12 | 445.13 | 445.04 | 445.1 | 8100.0 |
| 2021-08-17 07:05:00 | SPY | ETF | 445.109 | 445.109 | 444.89 | 444.99 | 9699.0 |
| 2021-08-17 07:10:00 | SPY | ETF | 445.0 | 445.02 | 444.94 | 444.98 | 23931.0 |
| 2021-08-17 07:15:00 | SPY | ETF | 444.97 | 445.0 | 444.6 | 444.78 | 34281.0 |
| 2021-08-17 07:20:00 | SPY | ETF | 444.81 | 444.89 | 444.75 | 444.75 | 8830.0 |
| 2021-08-17 07:25:00 | SPY | ETF | 444.76 | 444.82 | 444.69 | 444.82 | 14806.0 |
| 2021-08-17 07:30:00 | SPY | ETF | 444.81 | 444.95 | 444.69 | 444.95 | 29792.0 |
| 2021-08-17 07:35:00 | SPY | ETF | 444.97 | 445.11 | 444.97 | 445.01 | 27840.0 |
| 2021-08-17 07:40:00 | SPY | ETF | 445.07 | 445.08 | 444.9 | 445.04 | 8211.0 |
| 2021-08-17 07:45:00 | SPY | ETF | 445.01 | 445.14 | 444.95 | 445.12 | 42054.0 |
| 2021-08-17 07:50:00 | SPY | ETF | 445.13 | 445.15 | 445.05 | 445.13 | 40072.0 |
| 2021-08-17 07:55:00 | SPY | ETF | 445.09 | 445.15 | 445.04 | 445.08 | 41000.0 |
| 2021-08-17 08:00:00 | SPY | ETF | 445.08 | 447.305 | 444.62 | 445.04 | 49170.0 |
| 2021-08-17 08:05:00 | SPY | ETF | 445.11 | 445.15 | 445.04 | 445.07 | 5645.0 |
| 2021-08-17 08:10:00 | SPY | ETF | 445.1 | 445.12 | 445.04 | 445.12 | 13339.0 |
| 2021-08-17 08:15:00 | SPY | ETF | 445.08 | 445.08 | 444.88 | 444.9 | 11836.0 |
> showing 50 of 83,566 rows — these rows as CSV