PREVIEW / etf_5min / 2021-02-12
file: by_date/etf_5min/2021/2021-02-12.parquet size: 1.8 MB rows: 83,071
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-02-12 04:00:00 | SPY | ETF | 389.3 | 389.55 | 389.3 | 389.55 | 4532.0 |
| 2021-02-12 04:05:00 | SPY | ETF | 389.51 | 389.6 | 389.49 | 389.51 | 3340.0 |
| 2021-02-12 04:10:00 | SPY | ETF | 389.46 | 389.58 | 389.46 | 389.47 | 1150.0 |
| 2021-02-12 04:15:00 | SPY | ETF | 389.48 | 389.6 | 389.45 | 389.53 | 2000.0 |
| 2021-02-12 04:20:00 | SPY | ETF | 389.55 | 389.66 | 389.55 | 389.63 | 3500.0 |
| 2021-02-12 04:25:00 | SPY | ETF | 389.62 | 389.68 | 389.62 | 389.67 | 700.0 |
| 2021-02-12 04:30:00 | SPY | ETF | 389.66 | 389.66 | 389.6 | 389.64 | 500.0 |
| 2021-02-12 04:35:00 | SPY | ETF | 389.64 | 389.67 | 389.63 | 389.63 | 1111.0 |
| 2021-02-12 04:40:00 | SPY | ETF | 389.81 | 389.81 | 389.81 | 389.81 | 288.0 |
| 2021-02-12 04:45:00 | SPY | ETF | 389.91 | 389.91 | 389.89 | 389.89 | 22100.0 |
| 2021-02-12 04:50:00 | SPY | ETF | 389.82 | 389.82 | 389.69 | 389.69 | 650.0 |
| 2021-02-12 05:00:00 | SPY | ETF | 389.94 | 389.94 | 389.94 | 389.94 | 950.0 |
| 2021-02-12 05:05:00 | SPY | ETF | 390.0 | 390.0 | 389.96 | 389.96 | 350.0 |
| 2021-02-12 05:10:00 | SPY | ETF | 389.83 | 389.83 | 389.83 | 389.83 | 100.0 |
| 2021-02-12 05:15:00 | SPY | ETF | 389.89 | 389.9 | 389.89 | 389.9 | 1200.0 |
| 2021-02-12 05:20:00 | SPY | ETF | 389.99 | 390.0 | 389.98 | 389.99 | 990.0 |
| 2021-02-12 05:25:00 | SPY | ETF | 389.89 | 389.97 | 389.89 | 389.96 | 1100.0 |
| 2021-02-12 05:35:00 | SPY | ETF | 389.99 | 389.99 | 389.93 | 389.93 | 400.0 |
| 2021-02-12 05:40:00 | SPY | ETF | 389.89 | 389.99 | 389.89 | 389.99 | 250.0 |
| 2021-02-12 05:45:00 | SPY | ETF | 390.01 | 390.01 | 390.01 | 390.01 | 200.0 |
| 2021-02-12 05:50:00 | SPY | ETF | 389.91 | 389.98 | 389.91 | 389.98 | 600.0 |
| 2021-02-12 05:55:00 | SPY | ETF | 390.0 | 390.04 | 390.0 | 390.04 | 2250.0 |
| 2021-02-12 06:00:00 | SPY | ETF | 390.03 | 390.03 | 390.01 | 390.01 | 566.0 |
| 2021-02-12 06:05:00 | SPY | ETF | 390.02 | 390.02 | 390.02 | 390.02 | 400.0 |
| 2021-02-12 06:10:00 | SPY | ETF | 389.94 | 390.0 | 389.94 | 390.0 | 300.0 |
| 2021-02-12 06:15:00 | SPY | ETF | 389.97 | 389.97 | 389.96 | 389.96 | 600.0 |
| 2021-02-12 06:20:00 | SPY | ETF | 389.93 | 389.98 | 389.86 | 389.86 | 3400.0 |
| 2021-02-12 06:25:00 | SPY | ETF | 389.83 | 389.83 | 389.7 | 389.7 | 9599.0 |
| 2021-02-12 06:30:00 | SPY | ETF | 389.74 | 389.74 | 389.73 | 389.74 | 1099.0 |
| 2021-02-12 06:35:00 | SPY | ETF | 389.82 | 389.86 | 389.8 | 389.83 | 3500.0 |
| 2021-02-12 06:40:00 | SPY | ETF | 389.83 | 389.85 | 389.83 | 389.85 | 300.0 |
| 2021-02-12 06:45:00 | SPY | ETF | 389.84 | 389.84 | 389.8 | 389.81 | 1300.0 |
| 2021-02-12 06:50:00 | SPY | ETF | 389.86 | 389.95 | 389.85 | 389.95 | 5685.0 |
| 2021-02-12 06:55:00 | SPY | ETF | 389.98 | 390.03 | 389.98 | 389.99 | 11967.0 |
| 2021-02-12 07:00:00 | SPY | ETF | 390.04 | 390.36 | 390.04 | 390.15 | 10098.0 |
| 2021-02-12 07:05:00 | SPY | ETF | 390.16 | 390.16 | 390.0 | 390.0 | 7200.0 |
| 2021-02-12 07:10:00 | SPY | ETF | 390.0 | 390.04 | 389.97 | 390.01 | 6977.0 |
| 2021-02-12 07:15:00 | SPY | ETF | 390.08 | 390.09 | 390.01 | 390.01 | 2164.0 |
| 2021-02-12 07:20:00 | SPY | ETF | 390.02 | 390.1 | 390.02 | 390.08 | 1254.0 |
| 2021-02-12 07:25:00 | SPY | ETF | 390.08 | 390.1 | 390.06 | 390.06 | 14135.0 |
| 2021-02-12 07:30:00 | SPY | ETF | 390.1 | 390.35 | 390.1 | 390.3 | 16420.0 |
| 2021-02-12 07:35:00 | SPY | ETF | 390.35 | 390.35 | 390.11 | 390.18 | 6305.0 |
| 2021-02-12 07:40:00 | SPY | ETF | 390.13 | 390.15 | 390.13 | 390.15 | 484.0 |
| 2021-02-12 07:45:00 | SPY | ETF | 390.19 | 390.21 | 389.99 | 390.04 | 7078.0 |
| 2021-02-12 07:50:00 | SPY | ETF | 390.03 | 390.16 | 390.03 | 390.14 | 10600.0 |
| 2021-02-12 07:55:00 | SPY | ETF | 390.14 | 390.14 | 390.09 | 390.13 | 5208.0 |
| 2021-02-12 08:00:00 | SPY | ETF | 390.2701 | 390.32 | 389.7 | 390.32 | 29257.0 |
| 2021-02-12 08:05:00 | SPY | ETF | 390.3 | 390.36 | 390.29 | 390.29 | 19261.0 |
| 2021-02-12 08:10:00 | SPY | ETF | 390.28 | 390.3 | 390.11 | 390.13 | 1734.0 |
| 2021-02-12 08:15:00 | SPY | ETF | 390.19 | 390.27 | 390.16 | 390.23 | 2907.0 |
> showing 50 of 83,071 rows — these rows as CSV