PREVIEW / etf_1min / 2023-02-21
file: by_date/etf_1min/2023/2023-02-21.parquet size: 4.8 MB rows: 266,313
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-02-21 04:00:00 | SPY | ETF | 403.67 | 405.49 | 403.6 | 403.6 | 2705.0 |
| 2023-02-21 04:01:00 | SPY | ETF | 403.59 | 403.59 | 403.57 | 403.58 | 1650.0 |
| 2023-02-21 04:02:00 | SPY | ETF | 403.6 | 403.6 | 403.55 | 403.55 | 1300.0 |
| 2023-02-21 04:03:00 | SPY | ETF | 403.56 | 403.62 | 403.55 | 403.55 | 1625.0 |
| 2023-02-21 04:04:00 | SPY | ETF | 403.57 | 403.6 | 403.55 | 403.59 | 936.0 |
| 2023-02-21 04:05:00 | SPY | ETF | 403.55 | 403.61 | 403.55 | 403.61 | 2432.0 |
| 2023-02-21 04:06:00 | SPY | ETF | 403.56 | 403.58 | 403.52 | 403.52 | 5162.0 |
| 2023-02-21 04:07:00 | SPY | ETF | 403.56 | 403.58 | 403.56 | 403.58 | 450.0 |
| 2023-02-21 04:08:00 | SPY | ETF | 403.58 | 403.75 | 403.36 | 403.75 | 1620.0 |
| 2023-02-21 04:09:00 | SPY | ETF | 403.76 | 403.76 | 403.69 | 403.69 | 4200.0 |
| 2023-02-21 04:10:00 | SPY | ETF | 403.68 | 403.68 | 403.68 | 403.68 | 178.0 |
| 2023-02-21 04:11:00 | SPY | ETF | 403.71 | 403.84 | 403.71 | 403.8 | 6238.0 |
| 2023-02-21 04:12:00 | SPY | ETF | 403.82 | 404.02 | 403.82 | 404.02 | 300.0 |
| 2023-02-21 04:13:00 | SPY | ETF | 404.06 | 404.07 | 403.83 | 404.06 | 2700.0 |
| 2023-02-21 04:14:00 | SPY | ETF | 404.04 | 404.05 | 403.99 | 403.99 | 1461.0 |
| 2023-02-21 04:15:00 | SPY | ETF | 404.08 | 404.08 | 404.08 | 404.08 | 250.0 |
| 2023-02-21 04:16:00 | SPY | ETF | 404.1 | 404.19 | 404.1 | 404.18 | 475.0 |
| 2023-02-21 04:18:00 | SPY | ETF | 403.95 | 403.95 | 403.95 | 403.95 | 603.0 |
| 2023-02-21 04:19:00 | SPY | ETF | 403.9 | 403.9 | 403.85 | 403.85 | 860.0 |
| 2023-02-21 04:20:00 | SPY | ETF | 403.68 | 403.68 | 403.63 | 403.63 | 600.0 |
| 2023-02-21 04:21:00 | SPY | ETF | 403.6 | 403.6 | 403.39 | 403.39 | 7012.0 |
| 2023-02-21 04:22:00 | SPY | ETF | 403.53 | 403.53 | 403.53 | 403.53 | 100.0 |
| 2023-02-21 04:23:00 | SPY | ETF | 403.58 | 403.6 | 403.58 | 403.6 | 281.0 |
| 2023-02-21 04:24:00 | SPY | ETF | 403.61 | 403.61 | 403.61 | 403.61 | 400.0 |
| 2023-02-21 04:25:00 | SPY | ETF | 403.83 | 404.07 | 403.83 | 404.07 | 2200.0 |
| 2023-02-21 04:26:00 | SPY | ETF | 403.8 | 403.8 | 403.8 | 403.8 | 475.0 |
| 2023-02-21 04:27:00 | SPY | ETF | 404.05 | 404.18 | 404.05 | 404.15 | 2921.0 |
| 2023-02-21 04:30:00 | SPY | ETF | 404.07 | 404.07 | 404.05 | 404.05 | 1595.0 |
| 2023-02-21 04:31:00 | SPY | ETF | 404.15 | 404.23 | 404.08 | 404.08 | 2100.0 |
| 2023-02-21 04:32:00 | SPY | ETF | 404.27 | 404.27 | 404.17 | 404.2 | 1008.0 |
| 2023-02-21 04:33:00 | SPY | ETF | 404.45 | 404.45 | 404.45 | 404.45 | 450.0 |
| 2023-02-21 04:34:00 | SPY | ETF | 404.47 | 404.47 | 404.47 | 404.47 | 100.0 |
| 2023-02-21 04:35:00 | SPY | ETF | 404.48 | 404.49 | 404.48 | 404.49 | 525.0 |
| 2023-02-21 04:39:00 | SPY | ETF | 404.35 | 404.48 | 404.35 | 404.48 | 580.0 |
| 2023-02-21 04:40:00 | SPY | ETF | 404.47 | 404.47 | 404.47 | 404.47 | 800.0 |
| 2023-02-21 04:41:00 | SPY | ETF | 404.55 | 404.55 | 404.54 | 404.54 | 800.0 |
| 2023-02-21 04:42:00 | SPY | ETF | 404.52 | 404.71 | 404.52 | 404.7 | 1900.0 |
| 2023-02-21 04:43:00 | SPY | ETF | 404.54 | 404.54 | 404.54 | 404.54 | 200.0 |
| 2023-02-21 04:44:00 | SPY | ETF | 404.56 | 404.56 | 404.48 | 404.48 | 2437.0 |
| 2023-02-21 04:46:00 | SPY | ETF | 404.54 | 404.63 | 404.44 | 404.63 | 2755.0 |
| 2023-02-21 04:48:00 | SPY | ETF | 404.7 | 404.7 | 404.7 | 404.7 | 100.0 |
| 2023-02-21 04:49:00 | SPY | ETF | 404.75 | 404.75 | 404.75 | 404.75 | 400.0 |
| 2023-02-21 04:50:00 | SPY | ETF | 404.69 | 404.77 | 404.69 | 404.77 | 597.0 |
| 2023-02-21 04:51:00 | SPY | ETF | 404.84 | 405.04 | 404.84 | 405.04 | 20675.0 |
| 2023-02-21 04:52:00 | SPY | ETF | 405.04 | 405.09 | 405.0 | 405.04 | 2500.0 |
| 2023-02-21 04:53:00 | SPY | ETF | 405.21 | 405.21 | 405.21 | 405.21 | 475.0 |
| 2023-02-21 04:54:00 | SPY | ETF | 405.31 | 405.42 | 405.3 | 405.36 | 2926.0 |
| 2023-02-21 04:55:00 | SPY | ETF | 405.43 | 405.43 | 405.32 | 405.32 | 1106.0 |
| 2023-02-21 04:56:00 | SPY | ETF | 405.27 | 405.27 | 405.13 | 405.13 | 2160.0 |
| 2023-02-21 04:57:00 | SPY | ETF | 405.1 | 405.1 | 405.1 | 405.1 | 500.0 |
> showing 50 of 266,313 rows — these rows as CSV