PREVIEW / etf_5min / 2024-08-19
file: by_date/etf_5min/2024/2024-08-19.parquet size: 2.3 MB rows: 113,558
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 |
|---|---|---|---|---|---|---|---|
| 2024-08-19 04:00:00 | SPY | ETF | 554.15 | 554.15 | 553.65 | 553.7 | 7774.0 |
| 2024-08-19 04:05:00 | SPY | ETF | 553.61 | 553.61 | 553.24 | 553.5 | 6172.0 |
| 2024-08-19 04:10:00 | SPY | ETF | 553.61 | 553.67 | 553.56 | 553.67 | 3070.0 |
| 2024-08-19 04:15:00 | SPY | ETF | 553.59 | 553.79 | 553.59 | 553.73 | 2103.0 |
| 2024-08-19 04:20:00 | SPY | ETF | 553.96 | 553.96 | 553.96 | 553.96 | 100.0 |
| 2024-08-19 04:30:00 | SPY | ETF | 553.89 | 553.89 | 553.81 | 553.85 | 8909.0 |
| 2024-08-19 04:35:00 | SPY | ETF | 554.02 | 554.02 | 553.95 | 553.95 | 586.0 |
| 2024-08-19 04:40:00 | SPY | ETF | 553.84 | 554.02 | 553.72 | 554.02 | 1152.0 |
| 2024-08-19 04:45:00 | SPY | ETF | 554.14 | 554.19 | 554.1 | 554.19 | 643.0 |
| 2024-08-19 04:50:00 | SPY | ETF | 554.02 | 554.15 | 553.9 | 554.15 | 608.0 |
| 2024-08-19 04:55:00 | SPY | ETF | 554.24 | 554.24 | 554.23 | 554.23 | 600.0 |
| 2024-08-19 05:00:00 | SPY | ETF | 553.97 | 553.97 | 553.97 | 553.97 | 169.0 |
| 2024-08-19 05:05:00 | SPY | ETF | 553.95 | 553.96 | 553.87 | 553.92 | 400.0 |
| 2024-08-19 05:10:00 | SPY | ETF | 553.73 | 553.81 | 553.73 | 553.81 | 240.0 |
| 2024-08-19 05:20:00 | SPY | ETF | 553.84 | 553.96 | 553.79 | 553.96 | 1200.0 |
| 2024-08-19 05:25:00 | SPY | ETF | 553.95 | 554.17 | 553.95 | 554.17 | 1163.0 |
| 2024-08-19 05:30:00 | SPY | ETF | 554.17 | 554.26 | 554.17 | 554.26 | 1440.0 |
| 2024-08-19 05:35:00 | SPY | ETF | 554.16 | 554.18 | 554.16 | 554.18 | 818.0 |
| 2024-08-19 05:45:00 | SPY | ETF | 554.12 | 554.12 | 554.12 | 554.12 | 251.0 |
| 2024-08-19 05:50:00 | SPY | ETF | 554.06 | 554.07 | 554.05 | 554.07 | 300.0 |
| 2024-08-19 05:55:00 | SPY | ETF | 554.07 | 554.14 | 554.02 | 554.14 | 1400.0 |
| 2024-08-19 06:00:00 | SPY | ETF | 554.17 | 554.45 | 554.17 | 554.4 | 2510.0 |
| 2024-08-19 06:05:00 | SPY | ETF | 554.47 | 554.55 | 554.44 | 554.55 | 990.0 |
| 2024-08-19 06:10:00 | SPY | ETF | 554.44 | 554.5 | 554.44 | 554.47 | 840.0 |
| 2024-08-19 06:15:00 | SPY | ETF | 554.4 | 554.4 | 554.4 | 554.4 | 854.0 |
| 2024-08-19 06:20:00 | SPY | ETF | 554.32 | 554.34 | 554.3 | 554.32 | 2095.0 |
| 2024-08-19 06:25:00 | SPY | ETF | 554.45 | 554.45 | 554.32 | 554.32 | 601.0 |
| 2024-08-19 06:30:00 | SPY | ETF | 554.38 | 554.38 | 554.26 | 554.3 | 10313.0 |
| 2024-08-19 06:35:00 | SPY | ETF | 554.35 | 554.35 | 554.16 | 554.19 | 1887.0 |
| 2024-08-19 06:40:00 | SPY | ETF | 554.26 | 554.27 | 554.22 | 554.26 | 59656.0 |
| 2024-08-19 06:45:00 | SPY | ETF | 554.27 | 554.36 | 554.27 | 554.36 | 41486.0 |
| 2024-08-19 06:50:00 | SPY | ETF | 554.35 | 554.36 | 554.15 | 554.15 | 648.0 |
| 2024-08-19 06:55:00 | SPY | ETF | 554.13 | 554.13 | 554.1 | 554.1 | 302.0 |
| 2024-08-19 07:00:00 | SPY | ETF | 554.05 | 554.27 | 554.04 | 554.24 | 7436.0 |
| 2024-08-19 07:05:00 | SPY | ETF | 554.23 | 554.39 | 554.2 | 554.39 | 4360.0 |
| 2024-08-19 07:10:00 | SPY | ETF | 554.35 | 554.64 | 554.35 | 554.59 | 6828.0 |
| 2024-08-19 07:15:00 | SPY | ETF | 554.62 | 554.62 | 554.51 | 554.53 | 8193.0 |
| 2024-08-19 07:20:00 | SPY | ETF | 554.5 | 554.51 | 554.47 | 554.47 | 7465.0 |
| 2024-08-19 07:25:00 | SPY | ETF | 554.58 | 554.6 | 554.54 | 554.6 | 1711.0 |
| 2024-08-19 07:30:00 | SPY | ETF | 554.63 | 554.68 | 554.61 | 554.61 | 6100.0 |
| 2024-08-19 07:35:00 | SPY | ETF | 554.68 | 554.68 | 554.5 | 554.56 | 14254.0 |
| 2024-08-19 07:40:00 | SPY | ETF | 554.52 | 554.56 | 554.43 | 554.56 | 6282.0 |
| 2024-08-19 07:45:00 | SPY | ETF | 554.54 | 554.58 | 554.51 | 554.55 | 6345.0 |
| 2024-08-19 07:50:00 | SPY | ETF | 554.55 | 554.55 | 554.44 | 554.44 | 29269.0 |
| 2024-08-19 07:55:00 | SPY | ETF | 554.53 | 554.53 | 554.49 | 554.53 | 4770.0 |
| 2024-08-19 08:00:00 | SPY | ETF | 554.56 | 554.76 | 553.74 | 554.72 | 48569.0 |
| 2024-08-19 08:05:00 | SPY | ETF | 554.68 | 554.69 | 554.58 | 554.62 | 10634.0 |
| 2024-08-19 08:10:00 | SPY | ETF | 554.62 | 554.76 | 554.61 | 554.73 | 12923.0 |
| 2024-08-19 08:15:00 | SPY | ETF | 554.77 | 554.97 | 554.77 | 554.94 | 10330.0 |
| 2024-08-19 08:20:00 | SPY | ETF | 554.92 | 554.98 | 554.84 | 554.98 | 13714.0 |
> showing 50 of 113,558 rows — these rows as CSV