PREVIEW / etf_5min / 2024-04-17
file: by_date/etf_5min/2024/2024-04-17.parquet size: 2.2 MB rows: 112,750
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-04-17 04:00:00 | SPY | ETF | 504.15 | 504.34 | 504.15 | 504.24 | 3394.0 |
| 2024-04-17 04:05:00 | SPY | ETF | 504.26 | 504.26 | 504.17 | 504.21 | 1687.0 |
| 2024-04-17 04:10:00 | SPY | ETF | 504.4 | 504.55 | 504.4 | 504.51 | 8489.0 |
| 2024-04-17 04:15:00 | SPY | ETF | 504.59 | 504.59 | 504.5 | 504.5 | 700.0 |
| 2024-04-17 04:20:00 | SPY | ETF | 504.58 | 504.77 | 504.58 | 504.75 | 735.0 |
| 2024-04-17 04:25:00 | SPY | ETF | 504.9 | 504.9 | 504.82 | 504.82 | 1490.0 |
| 2024-04-17 04:30:00 | SPY | ETF | 504.66 | 505.12 | 504.66 | 505.12 | 955.0 |
| 2024-04-17 04:35:00 | SPY | ETF | 505.1 | 505.1 | 505.0 | 505.0 | 1758.0 |
| 2024-04-17 04:40:00 | SPY | ETF | 505.09 | 505.38 | 505.09 | 505.35 | 6539.0 |
| 2024-04-17 04:45:00 | SPY | ETF | 505.45 | 505.48 | 505.35 | 505.35 | 2619.0 |
| 2024-04-17 04:50:00 | SPY | ETF | 505.09 | 505.15 | 505.04 | 505.04 | 850.0 |
| 2024-04-17 04:55:00 | SPY | ETF | 505.11 | 505.25 | 505.11 | 505.24 | 6860.0 |
| 2024-04-17 05:00:00 | SPY | ETF | 505.15 | 505.15 | 504.56 | 505.05 | 15603.0 |
| 2024-04-17 05:05:00 | SPY | ETF | 504.96 | 505.09 | 504.96 | 505.0 | 450.0 |
| 2024-04-17 05:10:00 | SPY | ETF | 504.92 | 504.92 | 504.85 | 504.85 | 400.0 |
| 2024-04-17 05:15:00 | SPY | ETF | 504.85 | 504.85 | 504.7 | 504.7 | 3638.0 |
| 2024-04-17 05:20:00 | SPY | ETF | 504.63 | 504.8 | 504.63 | 504.8 | 750.0 |
| 2024-04-17 05:25:00 | SPY | ETF | 504.9 | 504.9 | 504.77 | 504.77 | 351.0 |
| 2024-04-17 05:30:00 | SPY | ETF | 504.92 | 504.95 | 504.92 | 504.95 | 500.0 |
| 2024-04-17 05:35:00 | SPY | ETF | 505.02 | 505.02 | 505.02 | 505.02 | 100.0 |
| 2024-04-17 05:40:00 | SPY | ETF | 505.08 | 505.08 | 505.08 | 505.08 | 1000.0 |
| 2024-04-17 05:45:00 | SPY | ETF | 505.0 | 505.23 | 505.0 | 505.2 | 1096.0 |
| 2024-04-17 05:50:00 | SPY | ETF | 505.31 | 505.5 | 505.31 | 505.5 | 5756.0 |
| 2024-04-17 05:55:00 | SPY | ETF | 505.4 | 505.44 | 505.35 | 505.35 | 510.0 |
| 2024-04-17 06:00:00 | SPY | ETF | 505.49 | 505.53 | 505.44 | 505.45 | 4949.0 |
| 2024-04-17 06:05:00 | SPY | ETF | 505.42 | 505.64 | 505.42 | 505.64 | 500.0 |
| 2024-04-17 06:10:00 | SPY | ETF | 505.62 | 505.67 | 505.6 | 505.6 | 960.0 |
| 2024-04-17 06:15:00 | SPY | ETF | 505.65 | 505.65 | 505.56 | 505.59 | 1468.0 |
| 2024-04-17 06:20:00 | SPY | ETF | 505.59 | 505.59 | 505.33 | 505.33 | 1850.0 |
| 2024-04-17 06:25:00 | SPY | ETF | 505.39 | 505.61 | 505.39 | 505.61 | 2942.0 |
| 2024-04-17 06:30:00 | SPY | ETF | 505.75 | 505.98 | 505.75 | 505.87 | 101468.0 |
| 2024-04-17 06:35:00 | SPY | ETF | 505.86 | 505.88 | 505.65 | 505.8 | 12600.0 |
| 2024-04-17 06:40:00 | SPY | ETF | 505.82 | 506.0 | 505.82 | 505.99 | 6206.0 |
| 2024-04-17 06:45:00 | SPY | ETF | 505.98 | 506.02 | 505.9 | 506.02 | 1988.0 |
| 2024-04-17 06:50:00 | SPY | ETF | 505.92 | 505.95 | 505.62 | 505.73 | 3608.0 |
| 2024-04-17 06:55:00 | SPY | ETF | 505.68 | 505.68 | 505.5 | 505.54 | 11691.0 |
| 2024-04-17 07:00:00 | SPY | ETF | 505.56 | 505.75 | 504.9 | 505.611 | 101025.0 |
| 2024-04-17 07:05:00 | SPY | ETF | 505.68 | 505.72 | 505.55 | 505.6 | 20683.0 |
| 2024-04-17 07:10:00 | SPY | ETF | 505.6 | 505.7 | 505.5 | 505.53 | 30459.0 |
| 2024-04-17 07:15:00 | SPY | ETF | 505.53 | 505.56 | 505.26 | 505.29 | 11192.0 |
| 2024-04-17 07:20:00 | SPY | ETF | 505.27 | 505.27 | 505.06 | 505.15 | 21930.0 |
| 2024-04-17 07:25:00 | SPY | ETF | 505.16 | 505.38 | 505.08 | 505.38 | 4121.0 |
| 2024-04-17 07:30:00 | SPY | ETF | 505.36 | 505.58 | 505.23 | 505.52 | 10675.0 |
| 2024-04-17 07:35:00 | SPY | ETF | 505.43 | 505.43 | 505.2 | 505.2 | 7179.0 |
| 2024-04-17 07:40:00 | SPY | ETF | 505.15 | 505.34 | 505.15 | 505.3 | 9808.0 |
| 2024-04-17 07:45:00 | SPY | ETF | 505.31 | 505.5 | 505.2 | 505.48 | 14759.0 |
| 2024-04-17 07:50:00 | SPY | ETF | 505.48 | 505.52 | 505.18 | 505.25 | 14798.0 |
| 2024-04-17 07:55:00 | SPY | ETF | 505.19 | 505.19 | 504.94 | 505.07 | 18735.0 |
| 2024-04-17 08:00:00 | SPY | ETF | 505.62 | 506.05 | 502.25 | 504.9 | 81558.0 |
| 2024-04-17 08:05:00 | SPY | ETF | 504.9 | 505.12 | 503.0 | 504.84 | 33331.0 |
> showing 50 of 112,750 rows — these rows as CSV