PREVIEW / etf_5min / 2021-09-15
file: by_date/etf_5min/2021/2021-09-15.parquet size: 1.7 MB rows: 79,744
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-09-15 04:00:00 | SPY | ETF | 444.61 | 445.0 | 444.61 | 445.0 | 12418.0 |
| 2021-09-15 04:05:00 | SPY | ETF | 444.97 | 445.05 | 444.95 | 445.05 | 926.0 |
| 2021-09-15 04:15:00 | SPY | ETF | 444.88 | 445.05 | 444.87 | 445.02 | 2700.0 |
| 2021-09-15 04:20:00 | SPY | ETF | 445.02 | 445.07 | 444.95 | 444.99 | 7800.0 |
| 2021-09-15 04:25:00 | SPY | ETF | 444.95 | 445.17 | 444.95 | 445.16 | 2500.0 |
| 2021-09-15 04:30:00 | SPY | ETF | 445.23 | 445.28 | 445.23 | 445.26 | 1004.0 |
| 2021-09-15 04:35:00 | SPY | ETF | 445.25 | 445.32 | 445.25 | 445.32 | 1600.0 |
| 2021-09-15 04:40:00 | SPY | ETF | 445.32 | 445.32 | 445.28 | 445.28 | 2579.0 |
| 2021-09-15 04:45:00 | SPY | ETF | 445.28 | 445.29 | 445.25 | 445.25 | 900.0 |
| 2021-09-15 04:50:00 | SPY | ETF | 445.21 | 445.21 | 445.17 | 445.19 | 2711.0 |
| 2021-09-15 04:55:00 | SPY | ETF | 445.11 | 445.15 | 445.11 | 445.15 | 207.0 |
| 2021-09-15 05:00:00 | SPY | ETF | 445.14 | 445.22 | 445.14 | 445.15 | 994.0 |
| 2021-09-15 05:05:00 | SPY | ETF | 445.19 | 445.19 | 445.19 | 445.19 | 200.0 |
| 2021-09-15 05:10:00 | SPY | ETF | 445.15 | 445.17 | 445.15 | 445.16 | 335.0 |
| 2021-09-15 05:15:00 | SPY | ETF | 445.22 | 445.31 | 445.22 | 445.31 | 200.0 |
| 2021-09-15 05:20:00 | SPY | ETF | 445.29 | 445.29 | 445.2 | 445.21 | 411.0 |
| 2021-09-15 05:25:00 | SPY | ETF | 445.11 | 445.13 | 445.09 | 445.13 | 916.0 |
| 2021-09-15 05:30:00 | SPY | ETF | 445.08 | 445.24 | 445.03 | 445.24 | 1700.0 |
| 2021-09-15 05:35:00 | SPY | ETF | 445.24 | 445.24 | 445.16 | 445.16 | 1799.0 |
| 2021-09-15 05:40:00 | SPY | ETF | 445.17 | 445.19 | 445.15 | 445.15 | 1150.0 |
| 2021-09-15 05:50:00 | SPY | ETF | 445.4 | 445.41 | 445.26 | 445.27 | 800.0 |
| 2021-09-15 05:55:00 | SPY | ETF | 445.27 | 445.3 | 445.27 | 445.3 | 400.0 |
| 2021-09-15 06:00:00 | SPY | ETF | 445.33 | 445.35 | 445.3 | 445.33 | 4600.0 |
| 2021-09-15 06:05:00 | SPY | ETF | 445.35 | 445.4 | 445.35 | 445.35 | 2368.0 |
| 2021-09-15 06:10:00 | SPY | ETF | 445.34 | 445.34 | 445.2 | 445.22 | 1700.0 |
| 2021-09-15 06:15:00 | SPY | ETF | 445.16 | 445.2 | 445.1 | 445.11 | 2996.0 |
| 2021-09-15 06:20:00 | SPY | ETF | 445.11 | 445.13 | 445.07 | 445.07 | 2200.0 |
| 2021-09-15 06:25:00 | SPY | ETF | 445.15 | 445.22 | 445.11 | 445.22 | 900.0 |
| 2021-09-15 06:30:00 | SPY | ETF | 445.2 | 445.2 | 445.12 | 445.12 | 210.0 |
| 2021-09-15 06:35:00 | SPY | ETF | 445.12 | 445.12 | 445.1 | 445.1 | 900.0 |
| 2021-09-15 06:40:00 | SPY | ETF | 444.93 | 444.93 | 444.9 | 444.9 | 2126.0 |
| 2021-09-15 06:45:00 | SPY | ETF | 444.9 | 444.9 | 444.9 | 444.9 | 300.0 |
| 2021-09-15 06:50:00 | SPY | ETF | 444.7 | 444.84 | 444.7 | 444.82 | 3950.0 |
| 2021-09-15 06:55:00 | SPY | ETF | 444.71 | 444.71 | 444.58 | 444.58 | 1888.0 |
| 2021-09-15 07:00:00 | SPY | ETF | 444.73 | 444.73 | 444.48 | 444.61 | 5027.0 |
| 2021-09-15 07:05:00 | SPY | ETF | 444.68 | 444.76 | 444.68 | 444.75 | 2515.0 |
| 2021-09-15 07:10:00 | SPY | ETF | 444.74 | 444.75 | 444.42 | 444.46 | 5424.0 |
| 2021-09-15 07:15:00 | SPY | ETF | 444.42 | 444.58 | 444.42 | 444.57 | 7600.0 |
| 2021-09-15 07:20:00 | SPY | ETF | 444.58 | 444.6 | 444.42 | 444.57 | 6104.0 |
| 2021-09-15 07:25:00 | SPY | ETF | 444.56 | 444.6 | 444.38 | 444.38 | 6667.0 |
| 2021-09-15 07:30:00 | SPY | ETF | 444.39 | 444.41 | 444.2 | 444.26 | 23590.0 |
| 2021-09-15 07:35:00 | SPY | ETF | 444.25 | 444.29 | 444.12 | 444.22 | 25153.0 |
| 2021-09-15 07:40:00 | SPY | ETF | 444.21 | 444.51 | 444.21 | 444.51 | 6473.0 |
| 2021-09-15 07:45:00 | SPY | ETF | 444.52 | 444.64 | 444.49 | 444.52 | 42822.0 |
| 2021-09-15 07:50:00 | SPY | ETF | 444.48 | 444.55 | 444.39 | 444.5 | 5439.0 |
| 2021-09-15 07:55:00 | SPY | ETF | 444.51 | 444.51 | 444.44 | 444.47 | 12900.0 |
| 2021-09-15 08:00:00 | SPY | ETF | 444.7 | 445.07 | 444.1 | 444.47 | 25483.0 |
| 2021-09-15 08:05:00 | SPY | ETF | 444.5 | 444.5 | 444.32 | 444.37 | 14133.0 |
| 2021-09-15 08:10:00 | SPY | ETF | 444.37 | 444.4 | 444.32 | 444.33 | 10640.0 |
| 2021-09-15 08:15:00 | SPY | ETF | 444.33 | 444.51 | 444.33 | 444.48 | 6419.0 |
> showing 50 of 79,744 rows — these rows as CSV