PREVIEW / etf_1min / 2023-10-16
file: by_date/etf_1min/2023/2023-10-16.parquet size: 4.5 MB rows: 258,319
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-10-16 04:00:00 | SPY | ETF | 432.09 | 432.09 | 432.0 | 432.0 | 3125.0 |
| 2023-10-16 04:02:00 | SPY | ETF | 431.9 | 431.94 | 431.9 | 431.94 | 950.0 |
| 2023-10-16 04:03:00 | SPY | ETF | 431.81 | 431.81 | 431.72 | 431.72 | 1250.0 |
| 2023-10-16 04:04:00 | SPY | ETF | 431.6 | 431.68 | 431.6 | 431.68 | 566.0 |
| 2023-10-16 04:05:00 | SPY | ETF | 431.68 | 431.68 | 431.68 | 431.68 | 100.0 |
| 2023-10-16 04:06:00 | SPY | ETF | 431.63 | 431.63 | 431.6 | 431.63 | 901.0 |
| 2023-10-16 04:07:00 | SPY | ETF | 431.56 | 431.56 | 431.56 | 431.56 | 100.0 |
| 2023-10-16 04:08:00 | SPY | ETF | 431.5 | 431.57 | 431.49 | 431.56 | 1355.0 |
| 2023-10-16 04:09:00 | SPY | ETF | 431.55 | 431.55 | 431.48 | 431.48 | 290.0 |
| 2023-10-16 04:10:00 | SPY | ETF | 431.49 | 431.51 | 431.49 | 431.51 | 657.0 |
| 2023-10-16 04:12:00 | SPY | ETF | 431.45 | 431.45 | 431.45 | 431.45 | 150.0 |
| 2023-10-16 04:13:00 | SPY | ETF | 431.43 | 431.43 | 431.4 | 431.4 | 741.0 |
| 2023-10-16 04:14:00 | SPY | ETF | 431.35 | 431.52 | 431.35 | 431.51 | 1175.0 |
| 2023-10-16 04:15:00 | SPY | ETF | 431.37 | 431.37 | 431.33 | 431.33 | 1000.0 |
| 2023-10-16 04:16:00 | SPY | ETF | 431.3 | 431.35 | 431.3 | 431.34 | 925.0 |
| 2023-10-16 04:17:00 | SPY | ETF | 431.35 | 431.35 | 431.35 | 431.35 | 100.0 |
| 2023-10-16 04:18:00 | SPY | ETF | 431.45 | 431.45 | 431.45 | 431.45 | 100.0 |
| 2023-10-16 04:19:00 | SPY | ETF | 431.42 | 431.42 | 431.42 | 431.42 | 200.0 |
| 2023-10-16 04:20:00 | SPY | ETF | 431.5 | 431.56 | 431.5 | 431.56 | 219.0 |
| 2023-10-16 04:21:00 | SPY | ETF | 431.58 | 431.64 | 431.58 | 431.62 | 3076.0 |
| 2023-10-16 04:22:00 | SPY | ETF | 431.63 | 431.63 | 431.63 | 431.63 | 104.0 |
| 2023-10-16 04:23:00 | SPY | ETF | 431.7 | 431.7 | 431.69 | 431.69 | 550.0 |
| 2023-10-16 04:24:00 | SPY | ETF | 431.69 | 431.71 | 431.69 | 431.71 | 300.0 |
| 2023-10-16 04:25:00 | SPY | ETF | 431.71 | 431.85 | 431.71 | 431.85 | 249.0 |
| 2023-10-16 04:26:00 | SPY | ETF | 431.87 | 431.97 | 431.87 | 431.97 | 1350.0 |
| 2023-10-16 04:27:00 | SPY | ETF | 431.97 | 431.97 | 431.97 | 431.97 | 100.0 |
| 2023-10-16 04:28:00 | SPY | ETF | 432.13 | 432.14 | 432.1 | 432.1 | 662.0 |
| 2023-10-16 04:29:00 | SPY | ETF | 432.05 | 432.1 | 432.05 | 432.1 | 500.0 |
| 2023-10-16 04:30:00 | SPY | ETF | 432.1 | 432.16 | 432.1 | 432.12 | 700.0 |
| 2023-10-16 04:32:00 | SPY | ETF | 432.17 | 432.17 | 432.17 | 432.17 | 100.0 |
| 2023-10-16 04:33:00 | SPY | ETF | 432.2 | 432.21 | 432.2 | 432.21 | 1300.0 |
| 2023-10-16 04:35:00 | SPY | ETF | 432.16 | 432.17 | 432.16 | 432.17 | 200.0 |
| 2023-10-16 04:36:00 | SPY | ETF | 432.11 | 432.17 | 432.11 | 432.17 | 250.0 |
| 2023-10-16 04:37:00 | SPY | ETF | 432.32 | 432.33 | 432.29 | 432.29 | 950.0 |
| 2023-10-16 04:38:00 | SPY | ETF | 432.31 | 432.36 | 432.29 | 432.29 | 400.0 |
| 2023-10-16 04:39:00 | SPY | ETF | 432.25 | 432.27 | 432.25 | 432.27 | 601.0 |
| 2023-10-16 04:41:00 | SPY | ETF | 432.28 | 432.28 | 432.25 | 432.25 | 300.0 |
| 2023-10-16 04:42:00 | SPY | ETF | 432.28 | 432.28 | 432.28 | 432.28 | 114.0 |
| 2023-10-16 04:43:00 | SPY | ETF | 432.18 | 432.2 | 432.18 | 432.2 | 350.0 |
| 2023-10-16 04:44:00 | SPY | ETF | 432.28 | 432.28 | 432.28 | 432.28 | 225.0 |
| 2023-10-16 04:45:00 | SPY | ETF | 432.26 | 432.38 | 432.26 | 432.38 | 2800.0 |
| 2023-10-16 04:46:00 | SPY | ETF | 432.31 | 432.31 | 432.31 | 432.31 | 100.0 |
| 2023-10-16 04:47:00 | SPY | ETF | 432.3 | 432.34 | 432.3 | 432.34 | 200.0 |
| 2023-10-16 04:48:00 | SPY | ETF | 432.56 | 432.56 | 432.56 | 432.56 | 482.0 |
| 2023-10-16 04:50:00 | SPY | ETF | 432.65 | 432.65 | 432.55 | 432.55 | 10210.0 |
| 2023-10-16 04:53:00 | SPY | ETF | 432.45 | 432.45 | 432.45 | 432.45 | 150.0 |
| 2023-10-16 04:54:00 | SPY | ETF | 432.36 | 432.36 | 432.36 | 432.36 | 117.0 |
| 2023-10-16 04:55:00 | SPY | ETF | 432.41 | 432.46 | 432.4 | 432.46 | 1750.0 |
| 2023-10-16 04:57:00 | SPY | ETF | 432.34 | 432.34 | 432.34 | 432.34 | 100.0 |
| 2023-10-16 05:01:00 | SPY | ETF | 432.29 | 432.29 | 432.29 | 432.29 | 118.0 |
> showing 50 of 258,319 rows — these rows as CSV