PREVIEW / etf_5min / 2022-03-14
file: by_date/etf_5min/2022/2022-03-14.parquet size: 2.0 MB rows: 99,057
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 |
|---|---|---|---|---|---|---|---|
| 2022-03-14 04:00:00 | SPY | ETF | 422.7 | 422.8 | 422.02 | 422.38 | 9991.0 |
| 2022-03-14 04:05:00 | SPY | ETF | 422.35 | 423.61 | 422.17 | 423.61 | 13192.0 |
| 2022-03-14 04:10:00 | SPY | ETF | 423.39 | 423.98 | 423.38 | 423.55 | 12654.0 |
| 2022-03-14 04:15:00 | SPY | ETF | 423.09 | 423.19 | 422.79 | 422.8 | 1900.0 |
| 2022-03-14 04:20:00 | SPY | ETF | 422.84 | 423.16 | 422.74 | 422.74 | 7643.0 |
| 2022-03-14 04:25:00 | SPY | ETF | 422.22 | 422.31 | 422.09 | 422.09 | 6092.0 |
| 2022-03-14 04:30:00 | SPY | ETF | 421.97 | 422.07 | 421.79 | 422.07 | 3527.0 |
| 2022-03-14 04:35:00 | SPY | ETF | 422.34 | 422.34 | 422.34 | 422.34 | 100.0 |
| 2022-03-14 04:40:00 | SPY | ETF | 422.2 | 422.2 | 421.95 | 422.14 | 3225.0 |
| 2022-03-14 04:45:00 | SPY | ETF | 422.48 | 422.56 | 422.48 | 422.51 | 1090.0 |
| 2022-03-14 04:50:00 | SPY | ETF | 422.86 | 422.86 | 422.04 | 422.04 | 1310.0 |
| 2022-03-14 04:55:00 | SPY | ETF | 422.27 | 422.5 | 422.27 | 422.44 | 24519.0 |
| 2022-03-14 05:00:00 | SPY | ETF | 423.0 | 423.2 | 423.0 | 423.2 | 7500.0 |
| 2022-03-14 05:05:00 | SPY | ETF | 423.12 | 423.21 | 423.12 | 423.21 | 466.0 |
| 2022-03-14 05:10:00 | SPY | ETF | 423.27 | 423.59 | 423.12 | 423.12 | 2408.0 |
| 2022-03-14 05:15:00 | SPY | ETF | 423.14 | 423.14 | 422.96 | 423.1 | 13520.0 |
| 2022-03-14 05:20:00 | SPY | ETF | 423.28 | 423.28 | 422.86 | 422.86 | 1070.0 |
| 2022-03-14 05:25:00 | SPY | ETF | 422.64 | 422.97 | 422.24 | 422.48 | 7252.0 |
| 2022-03-14 05:30:00 | SPY | ETF | 422.51 | 422.9 | 422.51 | 422.82 | 4707.0 |
| 2022-03-14 05:35:00 | SPY | ETF | 422.75 | 423.2 | 422.7 | 423.2 | 7761.0 |
| 2022-03-14 05:40:00 | SPY | ETF | 423.33 | 424.32 | 423.33 | 423.71 | 4260.0 |
| 2022-03-14 05:45:00 | SPY | ETF | 423.69 | 424.04 | 423.59 | 424.04 | 4238.0 |
| 2022-03-14 05:50:00 | SPY | ETF | 424.03 | 424.61 | 424.03 | 424.54 | 7217.0 |
| 2022-03-14 05:55:00 | SPY | ETF | 424.66 | 425.05 | 424.48 | 424.59 | 20270.0 |
| 2022-03-14 06:00:00 | SPY | ETF | 424.61 | 424.63 | 424.22 | 424.34 | 3766.0 |
| 2022-03-14 06:05:00 | SPY | ETF | 424.35 | 424.39 | 423.86 | 423.86 | 5100.0 |
| 2022-03-14 06:10:00 | SPY | ETF | 423.87 | 423.97 | 423.44 | 423.89 | 6690.0 |
| 2022-03-14 06:15:00 | SPY | ETF | 423.77 | 423.95 | 423.77 | 423.8 | 1775.0 |
| 2022-03-14 06:20:00 | SPY | ETF | 423.8 | 423.8 | 423.58 | 423.58 | 11250.0 |
| 2022-03-14 06:25:00 | SPY | ETF | 423.88 | 423.88 | 423.62 | 423.62 | 1125.0 |
| 2022-03-14 06:30:00 | SPY | ETF | 423.96 | 424.31 | 423.96 | 424.17 | 2100.0 |
| 2022-03-14 06:35:00 | SPY | ETF | 423.85 | 424.0 | 423.72 | 423.73 | 6825.0 |
| 2022-03-14 06:40:00 | SPY | ETF | 423.59 | 423.59 | 423.35 | 423.36 | 1300.0 |
| 2022-03-14 06:45:00 | SPY | ETF | 423.35 | 423.55 | 423.25 | 423.46 | 1973.0 |
| 2022-03-14 06:50:00 | SPY | ETF | 423.37 | 423.41 | 423.25 | 423.41 | 8783.0 |
| 2022-03-14 06:55:00 | SPY | ETF | 423.66 | 424.08 | 423.65 | 424.08 | 7602.0 |
| 2022-03-14 07:00:00 | SPY | ETF | 424.04 | 424.05 | 423.3 | 423.3 | 52327.0 |
| 2022-03-14 07:05:00 | SPY | ETF | 423.28 | 423.45 | 422.83 | 422.86 | 28350.0 |
| 2022-03-14 07:10:00 | SPY | ETF | 422.86 | 423.29 | 422.8 | 423.2 | 20867.0 |
| 2022-03-14 07:15:00 | SPY | ETF | 423.17 | 423.36 | 423.02 | 423.36 | 15176.0 |
| 2022-03-14 07:20:00 | SPY | ETF | 423.3 | 423.44 | 423.11 | 423.14 | 12180.0 |
| 2022-03-14 07:25:00 | SPY | ETF | 422.8 | 422.8 | 421.61 | 421.93 | 82039.0 |
| 2022-03-14 07:30:00 | SPY | ETF | 421.88 | 422.11 | 421.62 | 421.73 | 13971.0 |
| 2022-03-14 07:35:00 | SPY | ETF | 421.7 | 422.27 | 421.63 | 421.74 | 38245.0 |
| 2022-03-14 07:40:00 | SPY | ETF | 421.65 | 422.11 | 421.54 | 421.6 | 16802.0 |
| 2022-03-14 07:45:00 | SPY | ETF | 421.52 | 421.65 | 420.68 | 421.25 | 55004.0 |
| 2022-03-14 07:50:00 | SPY | ETF | 421.15 | 421.33 | 420.82 | 420.93 | 46978.0 |
| 2022-03-14 07:55:00 | SPY | ETF | 420.89 | 421.33 | 420.69 | 420.8 | 34510.0 |
| 2022-03-14 08:00:00 | SPY | ETF | 423.34 | 424.5704 | 420.54 | 421.41 | 105815.0 |
| 2022-03-14 08:05:00 | SPY | ETF | 421.39 | 421.65 | 421.33 | 421.55 | 34015.0 |
> showing 50 of 99,057 rows — these rows as CSV