PREVIEW / etf_5min / 2021-05-06
file: by_date/etf_5min/2021/2021-05-06.parquet size: 1.8 MB rows: 83,925
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-06 04:00:00 | SPY | ETF | 416.4 | 416.5 | 416.2 | 416.36 | 3000.0 |
| 2021-05-06 04:05:00 | SPY | ETF | 416.33 | 416.52 | 416.31 | 416.4 | 1800.0 |
| 2021-05-06 04:15:00 | SPY | ETF | 416.61 | 416.61 | 416.59 | 416.59 | 200.0 |
| 2021-05-06 04:20:00 | SPY | ETF | 416.49 | 416.63 | 416.49 | 416.63 | 200.0 |
| 2021-05-06 04:25:00 | SPY | ETF | 416.67 | 416.68 | 416.67 | 416.68 | 700.0 |
| 2021-05-06 04:40:00 | SPY | ETF | 416.42 | 416.42 | 416.33 | 416.33 | 1100.0 |
| 2021-05-06 04:45:00 | SPY | ETF | 416.14 | 416.15 | 416.0 | 416.15 | 2300.0 |
| 2021-05-06 04:50:00 | SPY | ETF | 415.99 | 415.99 | 415.99 | 415.99 | 100.0 |
| 2021-05-06 04:55:00 | SPY | ETF | 415.93 | 416.03 | 415.92 | 416.03 | 3200.0 |
| 2021-05-06 05:00:00 | SPY | ETF | 416.08 | 416.28 | 416.08 | 416.28 | 200.0 |
| 2021-05-06 05:10:00 | SPY | ETF | 416.35 | 416.35 | 416.07 | 416.08 | 5600.0 |
| 2021-05-06 05:15:00 | SPY | ETF | 415.9 | 415.93 | 415.8 | 415.8 | 2900.0 |
| 2021-05-06 05:20:00 | SPY | ETF | 415.59 | 415.83 | 415.59 | 415.82 | 3399.0 |
| 2021-05-06 05:25:00 | SPY | ETF | 415.84 | 415.85 | 415.84 | 415.85 | 900.0 |
| 2021-05-06 05:30:00 | SPY | ETF | 415.75 | 415.75 | 415.75 | 415.75 | 400.0 |
| 2021-05-06 05:35:00 | SPY | ETF | 415.38 | 415.45 | 415.38 | 415.45 | 200.0 |
| 2021-05-06 05:50:00 | SPY | ETF | 415.87 | 415.87 | 415.87 | 415.87 | 100.0 |
| 2021-05-06 05:55:00 | SPY | ETF | 415.94 | 415.97 | 415.88 | 415.97 | 600.0 |
| 2021-05-06 06:00:00 | SPY | ETF | 415.98 | 416.01 | 415.98 | 416.01 | 200.0 |
| 2021-05-06 06:05:00 | SPY | ETF | 416.24 | 416.24 | 416.21 | 416.21 | 1699.0 |
| 2021-05-06 06:10:00 | SPY | ETF | 416.2 | 416.2 | 416.2 | 416.2 | 100.0 |
| 2021-05-06 06:15:00 | SPY | ETF | 416.0 | 416.16 | 415.97 | 416.16 | 1245.0 |
| 2021-05-06 06:20:00 | SPY | ETF | 416.19 | 416.4 | 416.19 | 416.37 | 1700.0 |
| 2021-05-06 06:25:00 | SPY | ETF | 416.38 | 416.38 | 416.26 | 416.27 | 2300.0 |
| 2021-05-06 06:30:00 | SPY | ETF | 416.25 | 416.28 | 416.25 | 416.28 | 3300.0 |
| 2021-05-06 06:35:00 | SPY | ETF | 416.5 | 416.5 | 416.46 | 416.46 | 3670.0 |
| 2021-05-06 06:40:00 | SPY | ETF | 416.46 | 416.46 | 416.32 | 416.32 | 700.0 |
| 2021-05-06 06:45:00 | SPY | ETF | 416.26 | 416.26 | 416.09 | 416.12 | 2300.0 |
| 2021-05-06 06:50:00 | SPY | ETF | 416.08 | 416.1 | 416.0 | 416.0 | 4199.0 |
| 2021-05-06 06:55:00 | SPY | ETF | 416.01 | 416.08 | 415.89 | 415.9 | 2300.0 |
| 2021-05-06 07:00:00 | SPY | ETF | 415.85 | 416.14 | 415.75 | 416.0 | 14323.0 |
| 2021-05-06 07:05:00 | SPY | ETF | 416.0 | 416.06 | 415.89 | 416.04 | 28575.0 |
| 2021-05-06 07:10:00 | SPY | ETF | 416.06 | 416.25 | 416.05 | 416.24 | 12457.0 |
| 2021-05-06 07:15:00 | SPY | ETF | 416.26 | 416.28 | 416.0 | 416.02 | 16761.0 |
| 2021-05-06 07:20:00 | SPY | ETF | 416.02 | 416.1 | 415.99 | 415.99 | 4367.0 |
| 2021-05-06 07:25:00 | SPY | ETF | 416.04 | 416.11 | 415.91 | 416.06 | 21473.0 |
| 2021-05-06 07:30:00 | SPY | ETF | 416.03 | 416.03 | 415.92 | 415.92 | 2163.0 |
| 2021-05-06 07:35:00 | SPY | ETF | 415.92 | 415.93 | 415.78 | 415.78 | 3993.0 |
| 2021-05-06 07:40:00 | SPY | ETF | 415.77 | 415.85 | 415.71 | 415.81 | 22647.0 |
| 2021-05-06 07:45:00 | SPY | ETF | 415.82 | 416.01 | 415.82 | 416.0 | 17400.0 |
| 2021-05-06 07:50:00 | SPY | ETF | 416.01 | 416.04 | 416.0 | 416.04 | 2902.0 |
| 2021-05-06 07:55:00 | SPY | ETF | 416.02 | 416.05 | 415.9 | 415.95 | 7160.0 |
| 2021-05-06 08:00:00 | SPY | ETF | 415.9101 | 416.91 | 415.71 | 415.99 | 52614.0 |
| 2021-05-06 08:05:00 | SPY | ETF | 415.99 | 416.04 | 415.65 | 415.77 | 30112.0 |
| 2021-05-06 08:10:00 | SPY | ETF | 415.81 | 415.81 | 415.66 | 415.76 | 10664.0 |
| 2021-05-06 08:15:00 | SPY | ETF | 415.74 | 415.77 | 415.38 | 415.41 | 48715.0 |
| 2021-05-06 08:20:00 | SPY | ETF | 415.46 | 415.51 | 415.33 | 415.42 | 12077.0 |
| 2021-05-06 08:25:00 | SPY | ETF | 415.51 | 415.56 | 415.43 | 415.43 | 16547.0 |
| 2021-05-06 08:30:00 | SPY | ETF | 415.52 | 415.58 | 415.19 | 415.52 | 67997.0 |
| 2021-05-06 08:35:00 | SPY | ETF | 415.511 | 415.62 | 415.45 | 415.51 | 92322.0 |
> showing 50 of 83,925 rows — these rows as CSV