PREVIEW / etf_1min / 2023-06-27
file: by_date/etf_1min/2023/2023-06-27.parquet size: 4.5 MB rows: 248,542
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-06-27 04:00:00 | SPY | ETF | 432.45 | 432.57 | 432.45 | 432.51 | 2570.0 |
| 2023-06-27 04:01:00 | SPY | ETF | 432.46 | 432.48 | 432.45 | 432.47 | 4225.0 |
| 2023-06-27 04:02:00 | SPY | ETF | 432.49 | 432.55 | 432.49 | 432.55 | 3000.0 |
| 2023-06-27 04:03:00 | SPY | ETF | 432.56 | 432.57 | 432.51 | 432.57 | 1296.0 |
| 2023-06-27 04:04:00 | SPY | ETF | 432.55 | 432.62 | 432.55 | 432.62 | 1600.0 |
| 2023-06-27 04:05:00 | SPY | ETF | 432.55 | 432.63 | 432.55 | 432.63 | 568.0 |
| 2023-06-27 04:07:00 | SPY | ETF | 432.53 | 432.53 | 432.52 | 432.52 | 409.0 |
| 2023-06-27 04:08:00 | SPY | ETF | 432.5 | 432.53 | 432.46 | 432.5 | 1660.0 |
| 2023-06-27 04:09:00 | SPY | ETF | 432.4 | 432.4 | 432.37 | 432.37 | 1200.0 |
| 2023-06-27 04:11:00 | SPY | ETF | 432.48 | 432.53 | 432.48 | 432.53 | 392.0 |
| 2023-06-27 04:12:00 | SPY | ETF | 432.66 | 432.66 | 432.53 | 432.56 | 600.0 |
| 2023-06-27 04:14:00 | SPY | ETF | 432.65 | 432.65 | 432.65 | 432.65 | 120.0 |
| 2023-06-27 04:15:00 | SPY | ETF | 432.56 | 432.56 | 432.55 | 432.55 | 300.0 |
| 2023-06-27 04:16:00 | SPY | ETF | 432.66 | 432.66 | 432.65 | 432.65 | 235.0 |
| 2023-06-27 04:17:00 | SPY | ETF | 432.7 | 432.7 | 432.7 | 432.7 | 100.0 |
| 2023-06-27 04:18:00 | SPY | ETF | 432.71 | 432.72 | 432.68 | 432.68 | 343.0 |
| 2023-06-27 04:19:00 | SPY | ETF | 432.68 | 432.69 | 432.68 | 432.69 | 700.0 |
| 2023-06-27 04:22:00 | SPY | ETF | 432.62 | 432.62 | 432.62 | 432.62 | 134.0 |
| 2023-06-27 04:23:00 | SPY | ETF | 432.59 | 432.59 | 432.52 | 432.52 | 1600.0 |
| 2023-06-27 04:27:00 | SPY | ETF | 432.52 | 432.52 | 432.52 | 432.52 | 125.0 |
| 2023-06-27 04:28:00 | SPY | ETF | 432.48 | 432.48 | 432.48 | 432.48 | 157.0 |
| 2023-06-27 04:30:00 | SPY | ETF | 432.41 | 432.41 | 432.39 | 432.39 | 1514.0 |
| 2023-06-27 04:32:00 | SPY | ETF | 432.37 | 432.37 | 432.33 | 432.33 | 476.0 |
| 2023-06-27 04:33:00 | SPY | ETF | 432.37 | 432.37 | 432.37 | 432.37 | 200.0 |
| 2023-06-27 04:35:00 | SPY | ETF | 432.4 | 432.4 | 432.4 | 432.4 | 2700.0 |
| 2023-06-27 04:36:00 | SPY | ETF | 432.34 | 432.34 | 432.34 | 432.34 | 500.0 |
| 2023-06-27 04:37:00 | SPY | ETF | 432.32 | 432.32 | 432.29 | 432.29 | 3000.0 |
| 2023-06-27 04:38:00 | SPY | ETF | 432.31 | 432.31 | 432.29 | 432.29 | 2800.0 |
| 2023-06-27 04:40:00 | SPY | ETF | 432.22 | 432.22 | 432.22 | 432.22 | 200.0 |
| 2023-06-27 04:41:00 | SPY | ETF | 432.1 | 432.1 | 432.09 | 432.1 | 809.0 |
| 2023-06-27 04:42:00 | SPY | ETF | 432.17 | 432.21 | 432.17 | 432.21 | 1391.0 |
| 2023-06-27 04:44:00 | SPY | ETF | 432.2 | 432.2 | 432.2 | 432.2 | 100.0 |
| 2023-06-27 04:45:00 | SPY | ETF | 432.23 | 432.23 | 432.23 | 432.23 | 100.0 |
| 2023-06-27 04:46:00 | SPY | ETF | 432.2 | 432.2 | 432.17 | 432.17 | 1100.0 |
| 2023-06-27 04:47:00 | SPY | ETF | 432.12 | 432.12 | 432.12 | 432.12 | 400.0 |
| 2023-06-27 04:49:00 | SPY | ETF | 432.24 | 432.24 | 432.24 | 432.24 | 100.0 |
| 2023-06-27 04:50:00 | SPY | ETF | 432.21 | 432.21 | 432.21 | 432.21 | 400.0 |
| 2023-06-27 04:57:00 | SPY | ETF | 432.22 | 432.22 | 432.22 | 432.22 | 200.0 |
| 2023-06-27 05:00:00 | SPY | ETF | 432.15 | 432.15 | 432.15 | 432.15 | 100.0 |
| 2023-06-27 05:02:00 | SPY | ETF | 432.14 | 432.14 | 432.11 | 432.14 | 300.0 |
| 2023-06-27 05:07:00 | SPY | ETF | 432.14 | 432.14 | 432.14 | 432.14 | 100.0 |
| 2023-06-27 05:08:00 | SPY | ETF | 432.19 | 432.19 | 432.19 | 432.19 | 1030.0 |
| 2023-06-27 05:09:00 | SPY | ETF | 432.26 | 432.28 | 432.26 | 432.28 | 405.0 |
| 2023-06-27 05:10:00 | SPY | ETF | 432.15 | 432.15 | 432.15 | 432.15 | 100.0 |
| 2023-06-27 05:11:00 | SPY | ETF | 432.12 | 432.12 | 432.12 | 432.12 | 100.0 |
| 2023-06-27 05:12:00 | SPY | ETF | 432.23 | 432.25 | 432.23 | 432.25 | 200.0 |
| 2023-06-27 05:13:00 | SPY | ETF | 432.22 | 432.22 | 432.15 | 432.16 | 1651.0 |
| 2023-06-27 05:15:00 | SPY | ETF | 432.15 | 432.16 | 432.1 | 432.16 | 804.0 |
| 2023-06-27 05:20:00 | SPY | ETF | 432.19 | 432.19 | 432.19 | 432.19 | 152.0 |
| 2023-06-27 05:22:00 | SPY | ETF | 432.23 | 432.23 | 432.23 | 432.23 | 100.0 |
> showing 50 of 248,542 rows — these rows as CSV