PREVIEW / etf_5min / 2023-12-29
file: by_date/etf_5min/2023/2023-12-29.parquet size: 2.2 MB rows: 109,783
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-12-29 04:00:00 | SPY | ETF | 477.4 | 477.4 | 477.4 | 477.4 | 500.0 |
| 2023-12-29 04:10:00 | SPY | ETF | 477.46 | 477.46 | 477.37 | 477.37 | 2286.0 |
| 2023-12-29 04:20:00 | SPY | ETF | 477.34 | 477.34 | 477.34 | 477.34 | 100.0 |
| 2023-12-29 04:35:00 | SPY | ETF | 477.32 | 477.32 | 477.24 | 477.24 | 2438.0 |
| 2023-12-29 04:40:00 | SPY | ETF | 477.28 | 477.28 | 477.28 | 477.28 | 200.0 |
| 2023-12-29 04:45:00 | SPY | ETF | 477.14 | 477.16 | 477.14 | 477.16 | 200.0 |
| 2023-12-29 04:50:00 | SPY | ETF | 477.16 | 477.17 | 477.13 | 477.13 | 6540.0 |
| 2023-12-29 04:55:00 | SPY | ETF | 477.14 | 477.15 | 477.11 | 477.11 | 6938.0 |
| 2023-12-29 05:00:00 | SPY | ETF | 477.12 | 477.15 | 477.07 | 477.14 | 5500.0 |
| 2023-12-29 05:05:00 | SPY | ETF | 477.07 | 477.1 | 477.07 | 477.07 | 1611.0 |
| 2023-12-29 05:10:00 | SPY | ETF | 477.07 | 477.18 | 477.07 | 477.13 | 5134.0 |
| 2023-12-29 05:15:00 | SPY | ETF | 477.22 | 477.22 | 477.03 | 477.05 | 2300.0 |
| 2023-12-29 05:20:00 | SPY | ETF | 477.0 | 477.0 | 476.97 | 476.97 | 750.0 |
| 2023-12-29 05:25:00 | SPY | ETF | 477.01 | 477.01 | 477.01 | 477.01 | 500.0 |
| 2023-12-29 05:30:00 | SPY | ETF | 477.0 | 477.0 | 477.0 | 477.0 | 100.0 |
| 2023-12-29 05:40:00 | SPY | ETF | 477.13 | 477.18 | 477.13 | 477.13 | 1500.0 |
| 2023-12-29 05:55:00 | SPY | ETF | 477.18 | 477.23 | 477.18 | 477.23 | 1000.0 |
| 2023-12-29 06:00:00 | SPY | ETF | 477.1 | 477.1 | 477.1 | 477.1 | 560.0 |
| 2023-12-29 06:05:00 | SPY | ETF | 477.13 | 477.18 | 477.13 | 477.18 | 1000.0 |
| 2023-12-29 06:15:00 | SPY | ETF | 477.13 | 477.13 | 477.12 | 477.12 | 1000.0 |
| 2023-12-29 06:20:00 | SPY | ETF | 477.22 | 477.22 | 477.22 | 477.22 | 400.0 |
| 2023-12-29 06:25:00 | SPY | ETF | 477.17 | 477.17 | 477.17 | 477.17 | 1000.0 |
| 2023-12-29 06:30:00 | SPY | ETF | 477.1 | 477.1 | 477.1 | 477.1 | 100.0 |
| 2023-12-29 06:35:00 | SPY | ETF | 477.23 | 477.23 | 477.18 | 477.23 | 1100.0 |
| 2023-12-29 06:40:00 | SPY | ETF | 477.26 | 477.3 | 477.26 | 477.3 | 232.0 |
| 2023-12-29 06:45:00 | SPY | ETF | 477.33 | 477.36 | 477.22 | 477.22 | 3000.0 |
| 2023-12-29 06:50:00 | SPY | ETF | 477.2 | 477.2 | 477.2 | 477.2 | 100.0 |
| 2023-12-29 06:55:00 | SPY | ETF | 477.23 | 477.26 | 477.21 | 477.26 | 800.0 |
| 2023-12-29 07:00:00 | SPY | ETF | 477.19 | 477.24 | 477.12 | 477.13 | 4261.0 |
| 2023-12-29 07:05:00 | SPY | ETF | 477.04 | 477.04 | 476.9 | 476.97 | 13000.0 |
| 2023-12-29 07:10:00 | SPY | ETF | 477.0 | 477.0 | 476.79 | 476.79 | 14592.0 |
| 2023-12-29 07:15:00 | SPY | ETF | 476.851 | 476.89 | 476.851 | 476.89 | 1008.0 |
| 2023-12-29 07:20:00 | SPY | ETF | 476.93 | 476.99 | 476.9 | 476.9 | 2225.0 |
| 2023-12-29 07:25:00 | SPY | ETF | 476.93 | 476.93 | 476.83 | 476.83 | 2677.0 |
| 2023-12-29 07:30:00 | SPY | ETF | 476.88 | 476.9 | 476.75 | 476.77 | 3956.0 |
| 2023-12-29 07:35:00 | SPY | ETF | 476.79 | 476.79 | 476.54 | 476.58 | 13338.0 |
| 2023-12-29 07:40:00 | SPY | ETF | 476.62 | 476.79 | 476.62 | 476.72 | 3583.0 |
| 2023-12-29 07:45:00 | SPY | ETF | 476.74 | 476.74 | 476.62 | 476.65 | 13978.0 |
| 2023-12-29 07:50:00 | SPY | ETF | 476.65 | 476.73 | 476.65 | 476.72 | 1300.0 |
| 2023-12-29 07:55:00 | SPY | ETF | 476.68 | 476.7 | 476.68 | 476.7 | 725.0 |
| 2023-12-29 08:00:00 | SPY | ETF | 477.0 | 477.63 | 476.56 | 477.39 | 40665.0 |
| 2023-12-29 08:05:00 | SPY | ETF | 477.57 | 477.57 | 476.66 | 476.8 | 12066.0 |
| 2023-12-29 08:10:00 | SPY | ETF | 476.8401 | 476.87 | 476.64 | 476.72 | 6237.0 |
| 2023-12-29 08:15:00 | SPY | ETF | 476.66 | 476.66 | 476.48 | 476.53 | 11017.0 |
| 2023-12-29 08:20:00 | SPY | ETF | 476.66 | 476.74 | 476.65 | 476.72 | 8911.0 |
| 2023-12-29 08:25:00 | SPY | ETF | 476.72 | 476.73 | 476.67 | 476.73 | 5277.0 |
| 2023-12-29 08:30:00 | SPY | ETF | 476.75 | 476.78 | 476.73 | 476.78 | 13451.0 |
| 2023-12-29 08:35:00 | SPY | ETF | 476.79 | 476.83 | 476.73 | 476.7601 | 11218.0 |
| 2023-12-29 08:40:00 | SPY | ETF | 476.72 | 476.78 | 476.69 | 476.73 | 6112.0 |
| 2023-12-29 08:45:00 | SPY | ETF | 476.74 | 476.74 | 476.63 | 476.64 | 10049.0 |
> showing 50 of 109,783 rows — these rows as CSV