PREVIEW / etf_5min / 2023-08-30
file: by_date/etf_5min/2023/2023-08-30.parquet size: 1.9 MB rows: 95,525
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 |
|---|---|---|---|---|---|---|---|
| 2023-08-30 04:00:00 | SPY | ETF | 449.32 | 449.33 | 449.09 | 449.09 | 3160.0 |
| 2023-08-30 04:05:00 | SPY | ETF | 449.1 | 449.1 | 448.99 | 449.0 | 3140.0 |
| 2023-08-30 04:10:00 | SPY | ETF | 449.0 | 449.0 | 448.77 | 448.98 | 3495.0 |
| 2023-08-30 04:15:00 | SPY | ETF | 448.89 | 449.07 | 448.89 | 449.07 | 327.0 |
| 2023-08-30 04:20:00 | SPY | ETF | 448.96 | 449.01 | 448.8 | 448.8 | 3725.0 |
| 2023-08-30 04:25:00 | SPY | ETF | 448.77 | 448.8 | 448.59 | 448.59 | 1300.0 |
| 2023-08-30 04:30:00 | SPY | ETF | 448.57 | 448.76 | 448.57 | 448.76 | 3305.0 |
| 2023-08-30 04:35:00 | SPY | ETF | 448.72 | 448.72 | 448.61 | 448.61 | 2207.0 |
| 2023-08-30 04:40:00 | SPY | ETF | 448.65 | 448.75 | 448.65 | 448.75 | 1822.0 |
| 2023-08-30 04:45:00 | SPY | ETF | 448.69 | 448.69 | 448.69 | 448.69 | 200.0 |
| 2023-08-30 04:50:00 | SPY | ETF | 448.6 | 448.6 | 448.55 | 448.55 | 738.0 |
| 2023-08-30 04:55:00 | SPY | ETF | 448.72 | 448.72 | 448.55 | 448.61 | 2243.0 |
| 2023-08-30 05:00:00 | SPY | ETF | 448.65 | 448.65 | 448.65 | 448.65 | 200.0 |
| 2023-08-30 05:05:00 | SPY | ETF | 448.48 | 448.48 | 448.48 | 448.48 | 100.0 |
| 2023-08-30 05:10:00 | SPY | ETF | 448.46 | 448.46 | 448.41 | 448.41 | 788.0 |
| 2023-08-30 05:15:00 | SPY | ETF | 448.52 | 448.52 | 448.52 | 448.52 | 161.0 |
| 2023-08-30 05:20:00 | SPY | ETF | 448.46 | 448.65 | 448.46 | 448.57 | 1721.0 |
| 2023-08-30 05:25:00 | SPY | ETF | 448.52 | 448.59 | 448.41 | 448.59 | 2549.0 |
| 2023-08-30 05:30:00 | SPY | ETF | 448.52 | 448.52 | 448.33 | 448.33 | 3407.0 |
| 2023-08-30 05:35:00 | SPY | ETF | 448.35 | 448.43 | 448.35 | 448.43 | 2076.0 |
| 2023-08-30 05:40:00 | SPY | ETF | 448.4 | 448.4 | 448.33 | 448.34 | 2399.0 |
| 2023-08-30 05:45:00 | SPY | ETF | 448.38 | 448.43 | 448.38 | 448.43 | 1575.0 |
| 2023-08-30 05:50:00 | SPY | ETF | 448.42 | 448.65 | 448.42 | 448.65 | 995.0 |
| 2023-08-30 06:00:00 | SPY | ETF | 448.57 | 448.57 | 448.57 | 448.57 | 325.0 |
| 2023-08-30 06:05:00 | SPY | ETF | 448.51 | 448.56 | 448.51 | 448.55 | 3876.0 |
| 2023-08-30 06:10:00 | SPY | ETF | 448.7 | 448.73 | 448.69 | 448.73 | 1175.0 |
| 2023-08-30 06:15:00 | SPY | ETF | 448.74 | 448.79 | 448.74 | 448.79 | 3900.0 |
| 2023-08-30 06:20:00 | SPY | ETF | 448.8 | 448.86 | 448.76 | 448.86 | 486.0 |
| 2023-08-30 06:25:00 | SPY | ETF | 448.8 | 448.9 | 448.77 | 448.9 | 6899.0 |
| 2023-08-30 06:30:00 | SPY | ETF | 448.87 | 448.92 | 448.87 | 448.87 | 689.0 |
| 2023-08-30 06:35:00 | SPY | ETF | 448.86 | 448.88 | 448.82 | 448.88 | 1653.0 |
| 2023-08-30 06:40:00 | SPY | ETF | 448.93 | 449.1 | 448.93 | 449.03 | 4947.0 |
| 2023-08-30 06:45:00 | SPY | ETF | 449.03 | 449.03 | 448.95 | 448.95 | 600.0 |
| 2023-08-30 06:50:00 | SPY | ETF | 448.99 | 448.99 | 448.99 | 448.99 | 173.0 |
| 2023-08-30 06:55:00 | SPY | ETF | 448.99 | 449.06 | 448.99 | 449.0 | 1470.0 |
| 2023-08-30 07:00:00 | SPY | ETF | 449.0 | 449.02 | 448.77 | 448.8 | 78361.0 |
| 2023-08-30 07:05:00 | SPY | ETF | 448.78 | 448.85 | 448.71 | 448.81 | 51715.0 |
| 2023-08-30 07:10:00 | SPY | ETF | 448.81 | 448.85 | 448.8 | 448.83 | 28489.0 |
| 2023-08-30 07:15:00 | SPY | ETF | 448.79 | 448.79 | 448.72 | 448.72 | 2925.0 |
| 2023-08-30 07:20:00 | SPY | ETF | 448.72 | 448.95 | 448.67 | 448.95 | 10516.0 |
| 2023-08-30 07:25:00 | SPY | ETF | 448.95 | 449.05 | 448.95 | 449.01 | 5690.0 |
| 2023-08-30 07:30:00 | SPY | ETF | 448.89 | 448.89 | 448.85 | 448.85 | 5628.0 |
| 2023-08-30 07:35:00 | SPY | ETF | 448.95 | 448.95 | 448.76 | 448.76 | 23728.0 |
| 2023-08-30 07:40:00 | SPY | ETF | 448.89 | 448.89 | 448.8 | 448.82 | 7984.0 |
| 2023-08-30 07:45:00 | SPY | ETF | 448.79 | 448.94 | 448.79 | 448.94 | 5575.0 |
| 2023-08-30 07:50:00 | SPY | ETF | 449.0 | 449.0 | 448.92 | 448.98 | 7461.0 |
| 2023-08-30 07:55:00 | SPY | ETF | 449.0 | 449.0 | 448.79 | 448.79 | 3307.0 |
| 2023-08-30 08:00:00 | SPY | ETF | 448.9188 | 450.08 | 448.3104 | 448.97 | 41469.0 |
| 2023-08-30 08:05:00 | SPY | ETF | 449.0 | 449.09 | 449.0 | 449.06 | 25103.0 |
| 2023-08-30 08:10:00 | SPY | ETF | 449.1 | 449.25 | 449.1 | 449.12 | 84321.0 |
> showing 50 of 95,525 rows — these rows as CSV