PREVIEW / etf_5min / 2024-03-05
file: by_date/etf_5min/2024/2024-03-05.parquet size: 2.3 MB rows: 115,349
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-03-05 04:00:00 | SPY | ETF | 510.73 | 510.83 | 510.66 | 510.83 | 1825.0 |
| 2024-03-05 04:05:00 | SPY | ETF | 510.77 | 510.79 | 510.7 | 510.79 | 902.0 |
| 2024-03-05 04:10:00 | SPY | ETF | 510.89 | 510.89 | 510.71 | 510.73 | 800.0 |
| 2024-03-05 04:15:00 | SPY | ETF | 510.75 | 510.75 | 510.75 | 510.75 | 300.0 |
| 2024-03-05 04:20:00 | SPY | ETF | 510.85 | 510.95 | 510.83 | 510.89 | 1470.0 |
| 2024-03-05 04:25:00 | SPY | ETF | 510.92 | 510.92 | 510.92 | 510.92 | 175.0 |
| 2024-03-05 04:30:00 | SPY | ETF | 510.88 | 511.0 | 510.88 | 511.0 | 700.0 |
| 2024-03-05 04:35:00 | SPY | ETF | 510.9 | 510.9 | 510.73 | 510.79 | 2607.0 |
| 2024-03-05 04:40:00 | SPY | ETF | 510.8 | 510.8 | 510.8 | 510.8 | 212.0 |
| 2024-03-05 04:45:00 | SPY | ETF | 510.71 | 510.71 | 510.55 | 510.55 | 1918.0 |
| 2024-03-05 04:50:00 | SPY | ETF | 510.56 | 510.56 | 510.54 | 510.56 | 850.0 |
| 2024-03-05 04:55:00 | SPY | ETF | 510.5 | 510.56 | 510.5 | 510.55 | 1100.0 |
| 2024-03-05 05:00:00 | SPY | ETF | 510.54 | 510.57 | 510.48 | 510.48 | 1155.0 |
| 2024-03-05 05:05:00 | SPY | ETF | 510.5 | 510.51 | 510.43 | 510.46 | 3292.0 |
| 2024-03-05 05:10:00 | SPY | ETF | 510.48 | 510.51 | 510.4 | 510.51 | 634.0 |
| 2024-03-05 05:15:00 | SPY | ETF | 510.62 | 510.63 | 510.62 | 510.63 | 434.0 |
| 2024-03-05 05:20:00 | SPY | ETF | 510.66 | 510.66 | 510.66 | 510.66 | 100.0 |
| 2024-03-05 05:25:00 | SPY | ETF | 510.63 | 510.63 | 510.58 | 510.58 | 337.0 |
| 2024-03-05 05:30:00 | SPY | ETF | 510.69 | 510.69 | 510.69 | 510.69 | 499.0 |
| 2024-03-05 05:35:00 | SPY | ETF | 510.7 | 510.71 | 510.7 | 510.71 | 6100.0 |
| 2024-03-05 05:40:00 | SPY | ETF | 510.78 | 510.84 | 510.78 | 510.83 | 3250.0 |
| 2024-03-05 05:45:00 | SPY | ETF | 510.82 | 510.86 | 510.81 | 510.86 | 1742.0 |
| 2024-03-05 05:50:00 | SPY | ETF | 510.86 | 510.86 | 510.86 | 510.86 | 1300.0 |
| 2024-03-05 05:55:00 | SPY | ETF | 510.95 | 510.95 | 510.86 | 510.86 | 730.0 |
| 2024-03-05 06:00:00 | SPY | ETF | 510.92 | 511.0 | 510.9 | 511.0 | 3200.0 |
| 2024-03-05 06:05:00 | SPY | ETF | 511.11 | 511.11 | 511.02 | 511.06 | 799.0 |
| 2024-03-05 06:10:00 | SPY | ETF | 511.0 | 511.0 | 510.95 | 510.95 | 7665.0 |
| 2024-03-05 06:15:00 | SPY | ETF | 510.92 | 510.92 | 510.9 | 510.9 | 4875.0 |
| 2024-03-05 06:20:00 | SPY | ETF | 510.95 | 511.05 | 510.95 | 511.0 | 2530.0 |
| 2024-03-05 06:25:00 | SPY | ETF | 511.0 | 511.05 | 511.0 | 511.05 | 340.0 |
| 2024-03-05 06:30:00 | SPY | ETF | 511.09 | 511.12 | 511.05 | 511.08 | 2492.0 |
| 2024-03-05 06:35:00 | SPY | ETF | 511.06 | 511.06 | 510.93 | 510.94 | 3250.0 |
| 2024-03-05 06:40:00 | SPY | ETF | 510.9 | 510.93 | 510.83 | 510.83 | 110336.0 |
| 2024-03-05 06:45:00 | SPY | ETF | 510.81 | 510.87 | 510.78 | 510.84 | 3279.0 |
| 2024-03-05 06:50:00 | SPY | ETF | 510.91 | 510.91 | 510.86 | 510.89 | 1795.0 |
| 2024-03-05 06:55:00 | SPY | ETF | 510.89 | 511.01 | 510.89 | 511.01 | 1191.0 |
| 2024-03-05 07:00:00 | SPY | ETF | 511.01 | 511.11 | 511.0 | 511.0 | 10327.0 |
| 2024-03-05 07:05:00 | SPY | ETF | 511.07 | 511.17 | 511.07 | 511.15 | 6697.0 |
| 2024-03-05 07:10:00 | SPY | ETF | 511.19 | 511.24 | 511.17 | 511.2 | 6179.0 |
| 2024-03-05 07:15:00 | SPY | ETF | 511.2 | 511.2 | 511.1 | 511.13 | 10680.0 |
| 2024-03-05 07:20:00 | SPY | ETF | 511.13 | 511.13 | 510.9 | 511.0 | 14895.0 |
| 2024-03-05 07:25:00 | SPY | ETF | 511.15 | 511.21 | 511.12 | 511.12 | 5434.0 |
| 2024-03-05 07:30:00 | SPY | ETF | 511.06 | 511.06 | 510.78 | 510.78 | 9413.0 |
| 2024-03-05 07:35:00 | SPY | ETF | 510.83 | 510.88 | 510.73 | 510.87 | 9037.0 |
| 2024-03-05 07:40:00 | SPY | ETF | 510.89 | 510.89 | 510.8 | 510.86 | 1000.0 |
| 2024-03-05 07:45:00 | SPY | ETF | 510.8 | 510.8 | 510.45 | 510.57 | 17415.0 |
| 2024-03-05 07:50:00 | SPY | ETF | 510.53 | 510.67 | 510.5 | 510.67 | 3475.0 |
| 2024-03-05 07:55:00 | SPY | ETF | 510.61 | 510.69 | 510.549 | 510.549 | 1500.0 |
| 2024-03-05 08:00:00 | SPY | ETF | 511.0716 | 511.27 | 510.5 | 511.15 | 58239.0 |
| 2024-03-05 08:05:00 | SPY | ETF | 511.12 | 511.4 | 510.69 | 510.82 | 20126.0 |
> showing 50 of 115,349 rows — these rows as CSV