PREVIEW / etf_5min / 2022-03-21
file: by_date/etf_5min/2022/2022-03-21.parquet size: 2.0 MB rows: 95,632
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-21 04:00:00 | SPY | ETF | 443.34 | 444.48 | 443.18 | 443.65 | 23496.0 |
| 2022-03-21 04:05:00 | SPY | ETF | 443.6 | 443.77 | 443.4 | 443.73 | 14412.0 |
| 2022-03-21 04:10:00 | SPY | ETF | 443.71 | 443.85 | 443.51 | 443.51 | 4363.0 |
| 2022-03-21 04:15:00 | SPY | ETF | 443.55 | 444.17 | 443.55 | 444.17 | 4742.0 |
| 2022-03-21 04:20:00 | SPY | ETF | 443.99 | 444.02 | 443.98 | 444.02 | 350.0 |
| 2022-03-21 04:25:00 | SPY | ETF | 443.9 | 443.9 | 443.71 | 443.72 | 7654.0 |
| 2022-03-21 04:30:00 | SPY | ETF | 443.76 | 444.0 | 443.76 | 443.89 | 4300.0 |
| 2022-03-21 04:35:00 | SPY | ETF | 443.9 | 444.18 | 443.9 | 444.18 | 800.0 |
| 2022-03-21 04:40:00 | SPY | ETF | 443.93 | 443.93 | 443.93 | 443.93 | 1000.0 |
| 2022-03-21 04:45:00 | SPY | ETF | 444.23 | 444.23 | 443.99 | 443.99 | 2300.0 |
| 2022-03-21 04:50:00 | SPY | ETF | 443.9 | 443.9 | 443.64 | 443.65 | 1799.0 |
| 2022-03-21 04:55:00 | SPY | ETF | 443.75 | 443.84 | 443.7 | 443.81 | 1676.0 |
| 2022-03-21 05:00:00 | SPY | ETF | 443.99 | 443.99 | 443.75 | 443.75 | 1800.0 |
| 2022-03-21 05:05:00 | SPY | ETF | 443.75 | 443.78 | 443.1 | 443.65 | 6867.0 |
| 2022-03-21 05:10:00 | SPY | ETF | 443.63 | 443.63 | 443.63 | 443.63 | 100.0 |
| 2022-03-21 05:15:00 | SPY | ETF | 443.65 | 443.94 | 443.65 | 443.94 | 500.0 |
| 2022-03-21 05:20:00 | SPY | ETF | 444.0 | 444.25 | 444.0 | 444.1 | 2200.0 |
| 2022-03-21 05:25:00 | SPY | ETF | 444.0 | 444.1 | 444.0 | 444.1 | 896.0 |
| 2022-03-21 05:35:00 | SPY | ETF | 444.33 | 444.41 | 444.05 | 444.05 | 2423.0 |
| 2022-03-21 05:40:00 | SPY | ETF | 444.08 | 444.11 | 444.04 | 444.04 | 4650.0 |
| 2022-03-21 05:45:00 | SPY | ETF | 444.04 | 444.04 | 443.88 | 443.88 | 2100.0 |
| 2022-03-21 05:50:00 | SPY | ETF | 443.91 | 443.92 | 443.83 | 443.9 | 1800.0 |
| 2022-03-21 05:55:00 | SPY | ETF | 443.91 | 444.0 | 443.91 | 444.0 | 900.0 |
| 2022-03-21 06:00:00 | SPY | ETF | 443.85 | 444.0 | 443.72 | 443.74 | 2599.0 |
| 2022-03-21 06:05:00 | SPY | ETF | 443.72 | 443.85 | 443.72 | 443.85 | 600.0 |
| 2022-03-21 06:10:00 | SPY | ETF | 443.87 | 444.04 | 443.8 | 444.04 | 600.0 |
| 2022-03-21 06:15:00 | SPY | ETF | 443.96 | 443.96 | 443.76 | 443.76 | 1900.0 |
| 2022-03-21 06:20:00 | SPY | ETF | 443.8 | 443.91 | 443.6 | 443.6 | 4250.0 |
| 2022-03-21 06:25:00 | SPY | ETF | 443.55 | 443.68 | 443.5 | 443.5 | 4711.0 |
| 2022-03-21 06:30:00 | SPY | ETF | 443.48 | 443.57 | 443.4 | 443.4 | 5042.0 |
| 2022-03-21 06:35:00 | SPY | ETF | 443.38 | 443.38 | 443.35 | 443.35 | 12820.0 |
| 2022-03-21 06:40:00 | SPY | ETF | 443.39 | 443.55 | 443.38 | 443.55 | 400.0 |
| 2022-03-21 06:45:00 | SPY | ETF | 443.65 | 443.68 | 443.5 | 443.5 | 1434.0 |
| 2022-03-21 06:50:00 | SPY | ETF | 443.5 | 443.53 | 443.35 | 443.44 | 5376.0 |
| 2022-03-21 06:55:00 | SPY | ETF | 443.49 | 443.88 | 443.49 | 443.88 | 17086.0 |
| 2022-03-21 07:00:00 | SPY | ETF | 443.86 | 444.2 | 443.8 | 444.1 | 54432.0 |
| 2022-03-21 07:05:00 | SPY | ETF | 444.29 | 444.5 | 444.23 | 444.23 | 58130.0 |
| 2022-03-21 07:10:00 | SPY | ETF | 444.25 | 444.46 | 444.22 | 444.45 | 10617.0 |
| 2022-03-21 07:15:00 | SPY | ETF | 444.62 | 444.99 | 444.4 | 444.99 | 15323.0 |
| 2022-03-21 07:20:00 | SPY | ETF | 444.98 | 445.2 | 444.66 | 444.82 | 38069.0 |
| 2022-03-21 07:25:00 | SPY | ETF | 444.87 | 444.89 | 444.75 | 444.75 | 11838.0 |
| 2022-03-21 07:30:00 | SPY | ETF | 444.85 | 445.01 | 444.77 | 444.96 | 18199.0 |
| 2022-03-21 07:35:00 | SPY | ETF | 444.97 | 445.09 | 444.81 | 444.86 | 18618.0 |
| 2022-03-21 07:40:00 | SPY | ETF | 444.86 | 444.87 | 444.69 | 444.81 | 9429.0 |
| 2022-03-21 07:45:00 | SPY | ETF | 444.79 | 444.9 | 444.65 | 444.84 | 16307.0 |
| 2022-03-21 07:50:00 | SPY | ETF | 444.76 | 444.76 | 444.62 | 444.63 | 11909.0 |
| 2022-03-21 07:55:00 | SPY | ETF | 444.52 | 444.65 | 444.47 | 444.65 | 2361.0 |
| 2022-03-21 08:00:00 | SPY | ETF | 443.9001 | 445.07 | 442.43 | 444.49 | 89339.0 |
| 2022-03-21 08:05:00 | SPY | ETF | 444.48 | 444.57 | 444.45 | 444.45 | 22367.0 |
| 2022-03-21 08:10:00 | SPY | ETF | 444.4 | 444.65 | 444.37 | 444.53 | 16078.0 |
> showing 50 of 95,632 rows — these rows as CSV