PREVIEW / etf_5min / 2024-04-05
file: by_date/etf_5min/2024/2024-04-05.parquet size: 2.2 MB rows: 109,940
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-05 04:00:00 | SPY | ETF | 514.42 | 514.6 | 514.1 | 514.6 | 8395.0 |
| 2024-04-05 04:05:00 | SPY | ETF | 514.62 | 514.62 | 514.49 | 514.52 | 2364.0 |
| 2024-04-05 04:10:00 | SPY | ETF | 514.3 | 514.3 | 514.3 | 514.3 | 200.0 |
| 2024-04-05 04:15:00 | SPY | ETF | 514.38 | 514.43 | 514.23 | 514.3 | 3374.0 |
| 2024-04-05 04:20:00 | SPY | ETF | 514.34 | 514.34 | 514.34 | 514.34 | 300.0 |
| 2024-04-05 04:25:00 | SPY | ETF | 514.36 | 514.5 | 514.36 | 514.5 | 500.0 |
| 2024-04-05 04:30:00 | SPY | ETF | 514.6 | 514.69 | 514.6 | 514.67 | 735.0 |
| 2024-04-05 04:35:00 | SPY | ETF | 514.67 | 514.68 | 514.67 | 514.68 | 600.0 |
| 2024-04-05 04:40:00 | SPY | ETF | 514.66 | 514.74 | 514.48 | 514.48 | 400.0 |
| 2024-04-05 04:45:00 | SPY | ETF | 514.53 | 514.53 | 514.52 | 514.52 | 350.0 |
| 2024-04-05 04:50:00 | SPY | ETF | 514.41 | 514.41 | 514.35 | 514.35 | 520.0 |
| 2024-04-05 04:55:00 | SPY | ETF | 514.29 | 514.29 | 514.28 | 514.28 | 300.0 |
| 2024-04-05 05:00:00 | SPY | ETF | 514.57 | 514.57 | 514.57 | 514.57 | 200.0 |
| 2024-04-05 05:05:00 | SPY | ETF | 514.54 | 514.54 | 514.46 | 514.46 | 312.0 |
| 2024-04-05 05:15:00 | SPY | ETF | 514.61 | 514.61 | 514.31 | 514.31 | 600.0 |
| 2024-04-05 05:20:00 | SPY | ETF | 514.61 | 514.61 | 514.61 | 514.61 | 200.0 |
| 2024-04-05 05:25:00 | SPY | ETF | 514.41 | 514.41 | 514.41 | 514.41 | 400.0 |
| 2024-04-05 05:35:00 | SPY | ETF | 514.43 | 514.58 | 514.43 | 514.57 | 3400.0 |
| 2024-04-05 05:45:00 | SPY | ETF | 514.5 | 514.5 | 514.5 | 514.5 | 200.0 |
| 2024-04-05 05:55:00 | SPY | ETF | 514.74 | 514.75 | 514.5 | 514.5 | 7315.0 |
| 2024-04-05 06:00:00 | SPY | ETF | 514.63 | 514.63 | 514.48 | 514.5 | 1425.0 |
| 2024-04-05 06:05:00 | SPY | ETF | 514.41 | 514.41 | 514.41 | 514.41 | 400.0 |
| 2024-04-05 06:10:00 | SPY | ETF | 514.52 | 514.55 | 514.52 | 514.55 | 1747.0 |
| 2024-04-05 06:20:00 | SPY | ETF | 514.39 | 514.39 | 514.39 | 514.39 | 564.0 |
| 2024-04-05 06:25:00 | SPY | ETF | 514.38 | 514.38 | 514.37 | 514.38 | 2300.0 |
| 2024-04-05 06:30:00 | SPY | ETF | 514.3 | 514.36 | 514.24 | 514.35 | 3049.0 |
| 2024-04-05 06:35:00 | SPY | ETF | 514.4 | 514.54 | 514.4 | 514.54 | 1701.0 |
| 2024-04-05 06:40:00 | SPY | ETF | 514.55 | 514.55 | 514.55 | 514.55 | 100.0 |
| 2024-04-05 06:45:00 | SPY | ETF | 514.55 | 514.56 | 514.55 | 514.55 | 1114.0 |
| 2024-04-05 06:50:00 | SPY | ETF | 514.67 | 514.67 | 514.61 | 514.61 | 1517.0 |
| 2024-04-05 06:55:00 | SPY | ETF | 514.6 | 514.64 | 514.56 | 514.57 | 2600.0 |
| 2024-04-05 07:00:00 | SPY | ETF | 514.6 | 514.74 | 514.59 | 514.7 | 8234.0 |
| 2024-04-05 07:05:00 | SPY | ETF | 514.66 | 514.69 | 514.59 | 514.621 | 23454.0 |
| 2024-04-05 07:10:00 | SPY | ETF | 514.64 | 514.64 | 514.51 | 514.51 | 6406.0 |
| 2024-04-05 07:15:00 | SPY | ETF | 514.5 | 514.62 | 514.5 | 514.62 | 17084.0 |
| 2024-04-05 07:20:00 | SPY | ETF | 514.62 | 514.66 | 514.6 | 514.6 | 62420.0 |
| 2024-04-05 07:25:00 | SPY | ETF | 514.59 | 514.6 | 514.46 | 514.6 | 8079.0 |
| 2024-04-05 07:30:00 | SPY | ETF | 514.61 | 514.65 | 514.57 | 514.65 | 5035.0 |
| 2024-04-05 07:35:00 | SPY | ETF | 514.67 | 515.03 | 514.67 | 515.0 | 38204.0 |
| 2024-04-05 07:40:00 | SPY | ETF | 515.05 | 515.24 | 514.96 | 515.1 | 12112.0 |
| 2024-04-05 07:45:00 | SPY | ETF | 515.1 | 515.1 | 514.95 | 514.98 | 7800.0 |
| 2024-04-05 07:50:00 | SPY | ETF | 514.99 | 515.04 | 514.91 | 514.91 | 12474.0 |
| 2024-04-05 07:55:00 | SPY | ETF | 514.9 | 514.9 | 514.7 | 514.73 | 12324.0 |
| 2024-04-05 08:00:00 | SPY | ETF | 514.66 | 515.17 | 513.65 | 515.03 | 49903.0 |
| 2024-04-05 08:05:00 | SPY | ETF | 513.67 | 515.07 | 513.67 | 514.8 | 35655.0 |
| 2024-04-05 08:10:00 | SPY | ETF | 514.72 | 514.83 | 514.69 | 514.7 | 21343.0 |
| 2024-04-05 08:15:00 | SPY | ETF | 514.74 | 514.84 | 514.74 | 514.83 | 46496.0 |
| 2024-04-05 08:20:00 | SPY | ETF | 514.84 | 514.9 | 514.7 | 514.71 | 57411.0 |
| 2024-04-05 08:25:00 | SPY | ETF | 514.7 | 515.21 | 514.67 | 515.21 | 49909.0 |
| 2024-04-05 08:30:00 | SPY | ETF | 514.5 | 514.91 | 512.51 | 514.74 | 1086469.0 |
> showing 50 of 109,940 rows — these rows as CSV