PREVIEW / etf_5min / 2023-10-02
file: by_date/etf_5min/2023/2023-10-02.parquet size: 2.1 MB rows: 102,456
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-10-02 04:00:00 | SPY | ETF | 429.0 | 430.13 | 429.0 | 430.13 | 10425.0 |
| 2023-10-02 04:05:00 | SPY | ETF | 430.16 | 430.18 | 429.78 | 429.97 | 12429.0 |
| 2023-10-02 04:10:00 | SPY | ETF | 429.77 | 429.87 | 429.75 | 429.79 | 960.0 |
| 2023-10-02 04:15:00 | SPY | ETF | 429.66 | 429.66 | 429.52 | 429.64 | 1627.0 |
| 2023-10-02 04:20:00 | SPY | ETF | 429.55 | 429.55 | 429.55 | 429.55 | 100.0 |
| 2023-10-02 04:25:00 | SPY | ETF | 429.79 | 429.79 | 429.79 | 429.79 | 300.0 |
| 2023-10-02 04:30:00 | SPY | ETF | 429.7 | 429.76 | 429.7 | 429.76 | 484.0 |
| 2023-10-02 04:35:00 | SPY | ETF | 429.8 | 430.0 | 429.8 | 430.0 | 3107.0 |
| 2023-10-02 04:40:00 | SPY | ETF | 429.92 | 430.05 | 429.92 | 429.95 | 433.0 |
| 2023-10-02 04:45:00 | SPY | ETF | 429.93 | 429.93 | 429.93 | 429.93 | 141.0 |
| 2023-10-02 04:50:00 | SPY | ETF | 429.82 | 429.82 | 429.61 | 429.61 | 1255.0 |
| 2023-10-02 04:55:00 | SPY | ETF | 429.59 | 429.59 | 429.49 | 429.5 | 1313.0 |
| 2023-10-02 05:00:00 | SPY | ETF | 429.42 | 429.42 | 429.25 | 429.25 | 1299.0 |
| 2023-10-02 05:05:00 | SPY | ETF | 429.03 | 429.03 | 428.92 | 428.98 | 1760.0 |
| 2023-10-02 05:10:00 | SPY | ETF | 429.11 | 429.5 | 429.11 | 429.15 | 10614.0 |
| 2023-10-02 05:15:00 | SPY | ETF | 429.12 | 429.5 | 428.9 | 428.9 | 12072.0 |
| 2023-10-02 05:20:00 | SPY | ETF | 429.05 | 429.18 | 429.05 | 429.14 | 925.0 |
| 2023-10-02 05:25:00 | SPY | ETF | 429.01 | 429.01 | 428.67 | 428.67 | 2735.0 |
| 2023-10-02 05:30:00 | SPY | ETF | 428.79 | 428.87 | 428.79 | 428.82 | 3125.0 |
| 2023-10-02 05:35:00 | SPY | ETF | 428.79 | 428.86 | 428.79 | 428.86 | 1216.0 |
| 2023-10-02 05:40:00 | SPY | ETF | 428.86 | 428.86 | 428.73 | 428.73 | 241.0 |
| 2023-10-02 05:45:00 | SPY | ETF | 428.64 | 428.64 | 428.0 | 428.07 | 16535.0 |
| 2023-10-02 05:50:00 | SPY | ETF | 428.0 | 428.13 | 427.7 | 427.7 | 4221.0 |
| 2023-10-02 05:55:00 | SPY | ETF | 427.77 | 427.77 | 427.55 | 427.72 | 5153.0 |
| 2023-10-02 06:00:00 | SPY | ETF | 427.64 | 427.73 | 427.64 | 427.65 | 8131.0 |
| 2023-10-02 06:05:00 | SPY | ETF | 427.7 | 427.75 | 427.67 | 427.74 | 1244.0 |
| 2023-10-02 06:10:00 | SPY | ETF | 427.66 | 427.66 | 427.31 | 427.49 | 7161.0 |
| 2023-10-02 06:15:00 | SPY | ETF | 427.49 | 427.72 | 427.39 | 427.72 | 6265.0 |
| 2023-10-02 06:20:00 | SPY | ETF | 427.74 | 427.74 | 427.63 | 427.63 | 1305.0 |
| 2023-10-02 06:25:00 | SPY | ETF | 427.59 | 427.62 | 427.46 | 427.46 | 1961.0 |
| 2023-10-02 06:30:00 | SPY | ETF | 427.38 | 427.54 | 427.33 | 427.39 | 1563.0 |
| 2023-10-02 06:35:00 | SPY | ETF | 427.42 | 427.42 | 427.38 | 427.4 | 1400.0 |
| 2023-10-02 06:40:00 | SPY | ETF | 427.46 | 427.46 | 427.42 | 427.44 | 943.0 |
| 2023-10-02 06:45:00 | SPY | ETF | 427.49 | 427.56 | 427.45 | 427.45 | 5267.0 |
| 2023-10-02 06:50:00 | SPY | ETF | 427.49 | 427.52 | 427.32 | 427.5 | 27449.0 |
| 2023-10-02 06:55:00 | SPY | ETF | 427.55 | 427.55 | 427.48 | 427.48 | 10759.0 |
| 2023-10-02 07:00:00 | SPY | ETF | 427.48 | 427.63 | 427.45 | 427.45 | 11521.0 |
| 2023-10-02 07:05:00 | SPY | ETF | 427.45 | 427.51 | 427.35 | 427.49 | 4417.0 |
| 2023-10-02 07:10:00 | SPY | ETF | 427.4 | 427.49 | 427.4 | 427.45 | 33107.0 |
| 2023-10-02 07:15:00 | SPY | ETF | 427.49 | 427.6 | 427.49 | 427.6 | 11585.0 |
| 2023-10-02 07:20:00 | SPY | ETF | 427.62 | 427.75 | 427.62 | 427.7 | 19858.0 |
| 2023-10-02 07:25:00 | SPY | ETF | 427.71 | 427.73 | 427.68 | 427.69 | 5403.0 |
| 2023-10-02 07:30:00 | SPY | ETF | 427.7 | 427.72 | 427.45 | 427.51 | 27089.0 |
| 2023-10-02 07:35:00 | SPY | ETF | 427.52 | 427.68 | 427.52 | 427.6 | 15435.0 |
| 2023-10-02 07:40:00 | SPY | ETF | 427.6 | 427.6 | 427.0 | 427.02 | 114390.0 |
| 2023-10-02 07:45:00 | SPY | ETF | 427.1 | 427.1 | 426.85 | 426.97 | 14981.0 |
| 2023-10-02 07:50:00 | SPY | ETF | 427.0 | 427.07 | 426.8 | 426.8 | 16286.0 |
| 2023-10-02 07:55:00 | SPY | ETF | 426.77 | 426.95 | 426.75 | 426.87 | 16073.0 |
| 2023-10-02 08:00:00 | SPY | ETF | 427.47 | 430.19 | 426.44 | 426.44 | 56790.0 |
| 2023-10-02 08:05:00 | SPY | ETF | 426.43 | 426.6 | 426.42 | 426.53 | 18093.0 |
> showing 50 of 102,456 rows — these rows as CSV