PREVIEW / etf_5min / 2024-04-09
file: by_date/etf_5min/2024/2024-04-09.parquet size: 2.2 MB rows: 108,960
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-04-09 04:00:00 | SPY | ETF | 518.32 | 518.56 | 518.25 | 518.56 | 3954.0 |
| 2024-04-09 04:05:00 | SPY | ETF | 518.48 | 518.48 | 518.33 | 518.33 | 1200.0 |
| 2024-04-09 04:10:00 | SPY | ETF | 518.34 | 518.4 | 518.29 | 518.4 | 1888.0 |
| 2024-04-09 04:15:00 | SPY | ETF | 518.59 | 518.59 | 518.59 | 518.59 | 200.0 |
| 2024-04-09 04:20:00 | SPY | ETF | 518.67 | 518.68 | 518.67 | 518.67 | 657.0 |
| 2024-04-09 04:25:00 | SPY | ETF | 518.68 | 518.68 | 518.68 | 518.68 | 100.0 |
| 2024-04-09 04:30:00 | SPY | ETF | 518.65 | 518.65 | 518.5 | 518.5 | 860.0 |
| 2024-04-09 04:35:00 | SPY | ETF | 518.51 | 518.57 | 518.51 | 518.57 | 439.0 |
| 2024-04-09 04:40:00 | SPY | ETF | 518.57 | 518.57 | 518.57 | 518.57 | 100.0 |
| 2024-04-09 04:50:00 | SPY | ETF | 518.55 | 518.68 | 518.55 | 518.68 | 209.0 |
| 2024-04-09 04:55:00 | SPY | ETF | 518.73 | 518.73 | 518.73 | 518.73 | 100.0 |
| 2024-04-09 05:05:00 | SPY | ETF | 518.85 | 518.9 | 518.7 | 518.75 | 1680.0 |
| 2024-04-09 05:10:00 | SPY | ETF | 518.65 | 518.75 | 518.65 | 518.75 | 550.0 |
| 2024-04-09 05:15:00 | SPY | ETF | 518.8 | 518.8 | 518.8 | 518.8 | 100.0 |
| 2024-04-09 05:20:00 | SPY | ETF | 519.0 | 519.05 | 519.0 | 519.05 | 2083.0 |
| 2024-04-09 05:25:00 | SPY | ETF | 519.04 | 519.04 | 519.04 | 519.04 | 250.0 |
| 2024-04-09 05:30:00 | SPY | ETF | 518.99 | 519.0 | 518.95 | 519.0 | 400.0 |
| 2024-04-09 05:35:00 | SPY | ETF | 518.87 | 518.88 | 518.87 | 518.88 | 200.0 |
| 2024-04-09 05:40:00 | SPY | ETF | 518.87 | 518.99 | 518.87 | 518.99 | 3200.0 |
| 2024-04-09 05:45:00 | SPY | ETF | 519.09 | 519.09 | 519.09 | 519.09 | 100.0 |
| 2024-04-09 05:50:00 | SPY | ETF | 519.16 | 519.23 | 519.14 | 519.14 | 4000.0 |
| 2024-04-09 05:55:00 | SPY | ETF | 519.16 | 519.16 | 519.01 | 519.01 | 450.0 |
| 2024-04-09 06:00:00 | SPY | ETF | 519.01 | 519.06 | 519.0 | 519.06 | 2500.0 |
| 2024-04-09 06:05:00 | SPY | ETF | 519.14 | 519.14 | 519.12 | 519.12 | 500.0 |
| 2024-04-09 06:10:00 | SPY | ETF | 519.15 | 519.15 | 519.15 | 519.15 | 2810.0 |
| 2024-04-09 06:15:00 | SPY | ETF | 519.2 | 519.2 | 519.2 | 519.2 | 750.0 |
| 2024-04-09 06:20:00 | SPY | ETF | 519.2 | 519.2 | 519.05 | 519.05 | 1485.0 |
| 2024-04-09 06:25:00 | SPY | ETF | 518.97 | 518.97 | 518.81 | 518.81 | 400.0 |
| 2024-04-09 06:30:00 | SPY | ETF | 518.77 | 518.77 | 518.33 | 518.45 | 2733.0 |
| 2024-04-09 06:35:00 | SPY | ETF | 518.38 | 518.38 | 518.04 | 518.05 | 3935.0 |
| 2024-04-09 06:40:00 | SPY | ETF | 518.06 | 518.2 | 518.01 | 518.15 | 3140.0 |
| 2024-04-09 06:45:00 | SPY | ETF | 518.04 | 518.28 | 518.04 | 518.28 | 973.0 |
| 2024-04-09 06:50:00 | SPY | ETF | 518.24 | 518.3 | 518.24 | 518.3 | 400.0 |
| 2024-04-09 06:55:00 | SPY | ETF | 518.35 | 518.37 | 518.32 | 518.37 | 520.0 |
| 2024-04-09 07:00:00 | SPY | ETF | 518.39 | 518.58 | 518.39 | 518.58 | 9454.0 |
| 2024-04-09 07:05:00 | SPY | ETF | 518.67 | 518.74 | 518.6 | 518.74 | 3292.0 |
| 2024-04-09 07:10:00 | SPY | ETF | 518.74 | 519.08 | 518.71 | 519.08 | 22758.0 |
| 2024-04-09 07:15:00 | SPY | ETF | 519.18 | 519.3 | 518.92 | 518.99 | 17700.0 |
| 2024-04-09 07:20:00 | SPY | ETF | 519.01 | 519.24 | 518.99 | 519.12 | 3683.0 |
| 2024-04-09 07:25:00 | SPY | ETF | 519.04 | 519.1 | 519.04 | 519.1 | 4215.0 |
| 2024-04-09 07:30:00 | SPY | ETF | 519.08 | 519.14 | 519.0 | 519.0 | 5804.0 |
| 2024-04-09 07:35:00 | SPY | ETF | 518.95 | 519.1 | 518.95 | 519.1 | 2698.0 |
| 2024-04-09 07:40:00 | SPY | ETF | 519.15 | 519.2 | 519.1 | 519.17 | 6950.0 |
| 2024-04-09 07:45:00 | SPY | ETF | 519.04 | 519.05 | 519.03 | 519.04 | 550.0 |
| 2024-04-09 07:50:00 | SPY | ETF | 519.0 | 519.14 | 519.0 | 519.12 | 1200.0 |
| 2024-04-09 07:55:00 | SPY | ETF | 519.13 | 519.46 | 519.13 | 519.46 | 8310.0 |
| 2024-04-09 08:00:00 | SPY | ETF | 519.48 | 519.63 | 518.2596 | 519.62 | 52077.0 |
| 2024-04-09 08:05:00 | SPY | ETF | 519.62 | 519.62 | 519.49 | 519.49 | 1200.0 |
| 2024-04-09 08:10:00 | SPY | ETF | 519.49 | 520.09 | 519.49 | 520.0 | 34565.0 |
| 2024-04-09 08:15:00 | SPY | ETF | 520.04 | 520.08 | 519.9804 | 520.08 | 18955.0 |
> showing 50 of 108,960 rows — these rows as CSV