PREVIEW / etf_5min / 2024-09-23
file: by_date/etf_5min/2024/2024-09-23.parquet size: 2.3 MB rows: 114,716
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-09-23 04:00:00 | SPY | ETF | 569.19 | 569.19 | 568.34 | 568.55 | 45012.0 |
| 2024-09-23 04:05:00 | SPY | ETF | 568.51 | 568.53 | 568.31 | 568.37 | 16183.0 |
| 2024-09-23 04:10:00 | SPY | ETF | 568.38 | 568.5 | 568.04 | 568.17 | 27674.0 |
| 2024-09-23 04:15:00 | SPY | ETF | 568.2 | 568.32 | 568.1 | 568.27 | 1478.0 |
| 2024-09-23 04:20:00 | SPY | ETF | 568.37 | 568.37 | 568.37 | 568.37 | 200.0 |
| 2024-09-23 04:25:00 | SPY | ETF | 568.59 | 568.79 | 568.59 | 568.66 | 13435.0 |
| 2024-09-23 04:30:00 | SPY | ETF | 568.59 | 568.68 | 568.3 | 568.35 | 774.0 |
| 2024-09-23 04:35:00 | SPY | ETF | 568.35 | 568.41 | 568.08 | 568.08 | 3800.0 |
| 2024-09-23 04:40:00 | SPY | ETF | 567.94 | 568.08 | 567.86 | 568.05 | 1500.0 |
| 2024-09-23 04:45:00 | SPY | ETF | 568.1 | 568.25 | 568.01 | 568.25 | 2005.0 |
| 2024-09-23 04:50:00 | SPY | ETF | 568.38 | 568.48 | 568.38 | 568.48 | 600.0 |
| 2024-09-23 04:55:00 | SPY | ETF | 568.57 | 568.61 | 568.55 | 568.55 | 500.0 |
| 2024-09-23 05:00:00 | SPY | ETF | 568.55 | 568.55 | 568.4 | 568.44 | 3643.0 |
| 2024-09-23 05:05:00 | SPY | ETF | 568.38 | 568.62 | 568.3 | 568.62 | 6972.0 |
| 2024-09-23 05:10:00 | SPY | ETF | 568.62 | 568.67 | 568.41 | 568.48 | 1628.0 |
| 2024-09-23 05:15:00 | SPY | ETF | 568.36 | 568.42 | 568.04 | 568.04 | 26131.0 |
| 2024-09-23 05:20:00 | SPY | ETF | 568.02 | 568.61 | 567.92 | 568.59 | 10317.0 |
| 2024-09-23 05:25:00 | SPY | ETF | 568.63 | 568.66 | 568.63 | 568.66 | 287.0 |
| 2024-09-23 05:30:00 | SPY | ETF | 568.72 | 568.72 | 568.53 | 568.53 | 1649.0 |
| 2024-09-23 05:35:00 | SPY | ETF | 568.52 | 568.65 | 568.52 | 568.61 | 2223.0 |
| 2024-09-23 05:40:00 | SPY | ETF | 568.57 | 568.72 | 568.57 | 568.72 | 1128.0 |
| 2024-09-23 05:45:00 | SPY | ETF | 568.95 | 569.16 | 568.91 | 569.13 | 15723.0 |
| 2024-09-23 05:50:00 | SPY | ETF | 568.99 | 569.05 | 568.99 | 569.01 | 1940.0 |
| 2024-09-23 05:55:00 | SPY | ETF | 569.06 | 569.06 | 569.06 | 569.06 | 100.0 |
| 2024-09-23 06:00:00 | SPY | ETF | 569.18 | 569.21 | 569.11 | 569.11 | 7400.0 |
| 2024-09-23 06:05:00 | SPY | ETF | 569.26 | 569.26 | 569.0 | 569.0 | 2172.0 |
| 2024-09-23 06:10:00 | SPY | ETF | 569.07 | 569.07 | 569.01 | 569.01 | 1448.0 |
| 2024-09-23 06:20:00 | SPY | ETF | 568.95 | 568.95 | 568.95 | 568.95 | 200.0 |
| 2024-09-23 06:25:00 | SPY | ETF | 569.0 | 569.2 | 569.0 | 569.2 | 1653.0 |
| 2024-09-23 06:30:00 | SPY | ETF | 569.1 | 569.12 | 569.06 | 569.06 | 2474.0 |
| 2024-09-23 06:35:00 | SPY | ETF | 569.17 | 569.25 | 569.17 | 569.24 | 2200.0 |
| 2024-09-23 06:40:00 | SPY | ETF | 569.16 | 569.16 | 569.07 | 569.07 | 593.0 |
| 2024-09-23 06:50:00 | SPY | ETF | 569.16 | 569.17 | 569.16 | 569.16 | 400.0 |
| 2024-09-23 06:55:00 | SPY | ETF | 568.96 | 568.96 | 568.85 | 568.85 | 999.0 |
| 2024-09-23 07:00:00 | SPY | ETF | 568.83 | 568.98 | 568.62 | 568.62 | 39668.0 |
| 2024-09-23 07:05:00 | SPY | ETF | 568.71 | 568.78 | 568.52 | 568.73 | 5741.0 |
| 2024-09-23 07:10:00 | SPY | ETF | 568.76 | 568.82 | 568.73 | 568.78 | 16663.0 |
| 2024-09-23 07:15:00 | SPY | ETF | 568.6 | 568.72 | 568.6 | 568.72 | 6072.0 |
| 2024-09-23 07:20:00 | SPY | ETF | 568.82 | 568.9 | 568.67 | 568.67 | 46838.0 |
| 2024-09-23 07:25:00 | SPY | ETF | 568.67 | 568.67 | 568.26 | 568.5 | 10539.0 |
| 2024-09-23 07:30:00 | SPY | ETF | 568.63 | 568.65 | 568.51 | 568.55 | 5040.0 |
| 2024-09-23 07:35:00 | SPY | ETF | 568.57 | 568.78 | 568.48 | 568.76 | 5930.0 |
| 2024-09-23 07:40:00 | SPY | ETF | 568.75 | 568.88 | 568.7 | 568.88 | 4541.0 |
| 2024-09-23 07:45:00 | SPY | ETF | 568.869 | 569.03 | 568.869 | 568.94 | 7325.0 |
| 2024-09-23 07:50:00 | SPY | ETF | 568.97 | 569.06 | 568.9 | 568.9 | 7816.0 |
| 2024-09-23 07:55:00 | SPY | ETF | 568.96 | 569.15 | 568.96 | 569.07 | 19110.0 |
| 2024-09-23 08:00:00 | SPY | ETF | 569.04 | 569.94 | 567.0 | 568.86 | 23413.0 |
| 2024-09-23 08:05:00 | SPY | ETF | 569.0438 | 569.14 | 569.04 | 569.12 | 3909.0 |
| 2024-09-23 08:10:00 | SPY | ETF | 569.02 | 569.02 | 568.73 | 568.77 | 4501.0 |
| 2024-09-23 08:15:00 | SPY | ETF | 568.8207 | 568.9 | 568.7 | 568.7 | 6628.0 |
> showing 50 of 114,716 rows — these rows as CSV