PREVIEW / etf_5min / 2024-02-21
file: by_date/etf_5min/2024/2024-02-21.parquet size: 2.2 MB rows: 109,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-02-21 04:00:00 | SPY | ETF | 495.33 | 495.54 | 495.33 | 495.54 | 685.0 |
| 2024-02-21 04:05:00 | SPY | ETF | 495.38 | 495.74 | 495.38 | 495.53 | 1046.0 |
| 2024-02-21 04:10:00 | SPY | ETF | 495.44 | 495.44 | 495.44 | 495.44 | 111.0 |
| 2024-02-21 04:15:00 | SPY | ETF | 495.43 | 495.47 | 495.42 | 495.47 | 1787.0 |
| 2024-02-21 04:20:00 | SPY | ETF | 495.62 | 495.62 | 495.57 | 495.57 | 450.0 |
| 2024-02-21 04:25:00 | SPY | ETF | 495.5 | 495.5 | 495.46 | 495.46 | 600.0 |
| 2024-02-21 04:35:00 | SPY | ETF | 495.64 | 495.64 | 495.64 | 495.64 | 165.0 |
| 2024-02-21 04:40:00 | SPY | ETF | 495.74 | 495.74 | 495.71 | 495.71 | 950.0 |
| 2024-02-21 04:45:00 | SPY | ETF | 495.59 | 495.61 | 495.52 | 495.57 | 2566.0 |
| 2024-02-21 04:50:00 | SPY | ETF | 495.55 | 495.59 | 495.55 | 495.59 | 1506.0 |
| 2024-02-21 04:55:00 | SPY | ETF | 495.59 | 495.6 | 495.5 | 495.54 | 4170.0 |
| 2024-02-21 05:00:00 | SPY | ETF | 495.59 | 495.59 | 495.58 | 495.58 | 1346.0 |
| 2024-02-21 05:05:00 | SPY | ETF | 495.57 | 495.58 | 495.57 | 495.58 | 900.0 |
| 2024-02-21 05:15:00 | SPY | ETF | 495.7 | 495.78 | 495.7 | 495.75 | 1433.0 |
| 2024-02-21 05:25:00 | SPY | ETF | 495.93 | 495.93 | 495.93 | 495.93 | 100.0 |
| 2024-02-21 05:30:00 | SPY | ETF | 495.86 | 495.86 | 495.86 | 495.86 | 100.0 |
| 2024-02-21 05:35:00 | SPY | ETF | 495.69 | 495.75 | 495.69 | 495.75 | 328.0 |
| 2024-02-21 05:40:00 | SPY | ETF | 495.68 | 495.68 | 495.68 | 495.68 | 300.0 |
| 2024-02-21 05:45:00 | SPY | ETF | 495.82 | 495.82 | 495.82 | 495.82 | 100.0 |
| 2024-02-21 05:50:00 | SPY | ETF | 495.94 | 495.94 | 495.94 | 495.94 | 160.0 |
| 2024-02-21 05:55:00 | SPY | ETF | 495.89 | 495.9 | 495.89 | 495.9 | 2405.0 |
| 2024-02-21 06:00:00 | SPY | ETF | 495.9 | 495.9 | 495.9 | 495.9 | 250.0 |
| 2024-02-21 06:05:00 | SPY | ETF | 495.87 | 495.87 | 495.87 | 495.87 | 760.0 |
| 2024-02-21 06:10:00 | SPY | ETF | 495.8 | 495.8 | 495.51 | 495.54 | 2943.0 |
| 2024-02-21 06:15:00 | SPY | ETF | 495.64 | 495.65 | 495.59 | 495.59 | 400.0 |
| 2024-02-21 06:20:00 | SPY | ETF | 495.5 | 495.52 | 495.44 | 495.52 | 2418.0 |
| 2024-02-21 06:25:00 | SPY | ETF | 495.55 | 495.56 | 495.55 | 495.56 | 650.0 |
| 2024-02-21 06:30:00 | SPY | ETF | 495.61 | 495.62 | 495.53 | 495.62 | 1900.0 |
| 2024-02-21 06:35:00 | SPY | ETF | 495.52 | 495.65 | 495.52 | 495.65 | 300.0 |
| 2024-02-21 06:40:00 | SPY | ETF | 495.56 | 495.65 | 495.41 | 495.41 | 18000.0 |
| 2024-02-21 06:45:00 | SPY | ETF | 495.49 | 495.62 | 495.49 | 495.62 | 2157.0 |
| 2024-02-21 06:50:00 | SPY | ETF | 495.56 | 495.56 | 495.55 | 495.55 | 1450.0 |
| 2024-02-21 06:55:00 | SPY | ETF | 495.65 | 495.7 | 495.62 | 495.7 | 553.0 |
| 2024-02-21 07:00:00 | SPY | ETF | 495.62 | 495.75 | 495.59 | 495.65 | 3442.0 |
| 2024-02-21 07:05:00 | SPY | ETF | 495.57 | 495.57 | 495.37 | 495.49 | 3649.0 |
| 2024-02-21 07:10:00 | SPY | ETF | 495.5 | 495.811 | 495.5 | 495.81 | 14672.0 |
| 2024-02-21 07:15:00 | SPY | ETF | 495.85 | 496.0 | 495.85 | 495.93 | 8429.0 |
| 2024-02-21 07:20:00 | SPY | ETF | 495.77 | 495.779 | 495.65 | 495.75 | 14960.0 |
| 2024-02-21 07:25:00 | SPY | ETF | 495.8 | 495.89 | 495.8 | 495.89 | 654.0 |
| 2024-02-21 07:30:00 | SPY | ETF | 495.79 | 495.81 | 495.639 | 495.7 | 19801.0 |
| 2024-02-21 07:35:00 | SPY | ETF | 495.64 | 495.64 | 495.48 | 495.59 | 103469.0 |
| 2024-02-21 07:40:00 | SPY | ETF | 495.49 | 495.67 | 495.49 | 495.63 | 3950.0 |
| 2024-02-21 07:45:00 | SPY | ETF | 495.4 | 495.4 | 495.27 | 495.27 | 4241.0 |
| 2024-02-21 07:50:00 | SPY | ETF | 495.25 | 495.27 | 495.1 | 495.1 | 44128.0 |
| 2024-02-21 07:55:00 | SPY | ETF | 495.171 | 495.2 | 495.07 | 495.07 | 10798.0 |
| 2024-02-21 08:00:00 | SPY | ETF | 495.16 | 496.14 | 495.08 | 495.4101 | 39536.0 |
| 2024-02-21 08:05:00 | SPY | ETF | 496.12 | 496.31 | 495.3 | 495.3 | 8789.0 |
| 2024-02-21 08:10:00 | SPY | ETF | 495.32 | 495.3909 | 495.28 | 495.3 | 12178.0 |
| 2024-02-21 08:15:00 | SPY | ETF | 495.32 | 495.41 | 495.31 | 495.35 | 2630.0 |
| 2024-02-21 08:20:00 | SPY | ETF | 495.3 | 495.3 | 495.11 | 495.18 | 13975.0 |
> showing 50 of 109,716 rows — these rows as CSV