PREVIEW / etf_1min / 2023-03-13
file: by_date/etf_1min/2023/2023-03-13.parquet size: 5.2 MB rows: 307,767
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-03-13 04:00:00 | SPY | ETF | 391.75 | 391.78 | 391.0 | 391.61 | 8651.0 |
| 2023-03-13 04:01:00 | SPY | ETF | 391.52 | 391.52 | 391.29 | 391.3 | 1449.0 |
| 2023-03-13 04:02:00 | SPY | ETF | 391.25 | 391.25 | 391.0 | 391.0 | 1392.0 |
| 2023-03-13 04:03:00 | SPY | ETF | 391.03 | 391.21 | 390.97 | 391.21 | 2318.0 |
| 2023-03-13 04:04:00 | SPY | ETF | 391.09 | 391.11 | 391.0 | 391.01 | 2981.0 |
| 2023-03-13 04:05:00 | SPY | ETF | 391.01 | 391.02 | 390.86 | 390.86 | 6587.0 |
| 2023-03-13 04:06:00 | SPY | ETF | 390.81 | 391.0 | 390.81 | 390.94 | 5189.0 |
| 2023-03-13 04:07:00 | SPY | ETF | 390.8 | 391.01 | 390.8 | 391.0 | 2877.0 |
| 2023-03-13 04:08:00 | SPY | ETF | 390.92 | 390.92 | 390.8 | 390.85 | 11000.0 |
| 2023-03-13 04:09:00 | SPY | ETF | 390.84 | 390.95 | 390.84 | 390.9 | 1208.0 |
| 2023-03-13 04:10:00 | SPY | ETF | 390.9 | 391.23 | 390.9 | 391.23 | 802.0 |
| 2023-03-13 04:11:00 | SPY | ETF | 391.24 | 391.27 | 391.11 | 391.11 | 3311.0 |
| 2023-03-13 04:12:00 | SPY | ETF | 391.23 | 391.27 | 391.21 | 391.27 | 700.0 |
| 2023-03-13 04:13:00 | SPY | ETF | 391.27 | 391.47 | 391.27 | 391.47 | 3970.0 |
| 2023-03-13 04:14:00 | SPY | ETF | 391.38 | 391.5 | 391.35 | 391.49 | 4236.0 |
| 2023-03-13 04:15:00 | SPY | ETF | 391.34 | 391.45 | 391.32 | 391.32 | 10725.0 |
| 2023-03-13 04:16:00 | SPY | ETF | 391.5 | 391.75 | 391.5 | 391.67 | 2800.0 |
| 2023-03-13 04:17:00 | SPY | ETF | 391.63 | 391.63 | 391.55 | 391.55 | 550.0 |
| 2023-03-13 04:18:00 | SPY | ETF | 391.49 | 391.51 | 391.29 | 391.29 | 3800.0 |
| 2023-03-13 04:19:00 | SPY | ETF | 391.2 | 391.2 | 391.08 | 391.08 | 474.0 |
| 2023-03-13 04:20:00 | SPY | ETF | 391.1 | 391.1 | 391.0 | 391.0 | 1354.0 |
| 2023-03-13 04:21:00 | SPY | ETF | 391.1 | 391.1 | 390.99 | 390.99 | 300.0 |
| 2023-03-13 04:22:00 | SPY | ETF | 391.02 | 391.02 | 391.02 | 391.02 | 100.0 |
| 2023-03-13 04:23:00 | SPY | ETF | 391.16 | 391.42 | 391.16 | 391.42 | 300.0 |
| 2023-03-13 04:24:00 | SPY | ETF | 391.29 | 391.3 | 391.28 | 391.3 | 400.0 |
| 2023-03-13 04:25:00 | SPY | ETF | 391.45 | 391.45 | 391.44 | 391.44 | 1200.0 |
| 2023-03-13 04:26:00 | SPY | ETF | 391.1 | 391.1 | 391.1 | 391.1 | 100.0 |
| 2023-03-13 04:27:00 | SPY | ETF | 390.87 | 390.87 | 390.71 | 390.71 | 1338.0 |
| 2023-03-13 04:28:00 | SPY | ETF | 390.73 | 390.76 | 390.64 | 390.64 | 1608.0 |
| 2023-03-13 04:29:00 | SPY | ETF | 390.56 | 390.58 | 390.39 | 390.4 | 4700.0 |
| 2023-03-13 04:30:00 | SPY | ETF | 390.38 | 390.42 | 390.2 | 390.2 | 2300.0 |
| 2023-03-13 04:31:00 | SPY | ETF | 390.21 | 390.21 | 390.11 | 390.11 | 600.0 |
| 2023-03-13 04:32:00 | SPY | ETF | 390.07 | 390.2 | 390.0 | 390.02 | 3600.0 |
| 2023-03-13 04:33:00 | SPY | ETF | 389.93 | 390.09 | 389.89 | 390.07 | 3807.0 |
| 2023-03-13 04:34:00 | SPY | ETF | 390.2 | 390.2 | 389.97 | 389.97 | 1000.0 |
| 2023-03-13 04:35:00 | SPY | ETF | 390.0 | 390.01 | 389.87 | 389.89 | 3070.0 |
| 2023-03-13 04:36:00 | SPY | ETF | 390.12 | 390.13 | 390.03 | 390.03 | 1600.0 |
| 2023-03-13 04:37:00 | SPY | ETF | 389.88 | 389.88 | 389.77 | 389.77 | 2800.0 |
| 2023-03-13 04:38:00 | SPY | ETF | 389.79 | 389.82 | 389.67 | 389.82 | 4100.0 |
| 2023-03-13 04:39:00 | SPY | ETF | 389.8 | 389.84 | 389.78 | 389.84 | 3847.0 |
| 2023-03-13 04:40:00 | SPY | ETF | 389.91 | 390.0 | 389.91 | 389.94 | 798.0 |
| 2023-03-13 04:41:00 | SPY | ETF | 389.91 | 389.91 | 389.72 | 389.72 | 5483.0 |
| 2023-03-13 04:42:00 | SPY | ETF | 389.63 | 389.8 | 389.62 | 389.8 | 4165.0 |
| 2023-03-13 04:43:00 | SPY | ETF | 389.62 | 389.62 | 389.57 | 389.59 | 7584.0 |
| 2023-03-13 04:44:00 | SPY | ETF | 389.65 | 389.67 | 389.52 | 389.6 | 20674.0 |
| 2023-03-13 04:45:00 | SPY | ETF | 389.53 | 389.53 | 389.15 | 389.26 | 13198.0 |
| 2023-03-13 04:46:00 | SPY | ETF | 389.22 | 389.22 | 389.12 | 389.12 | 1996.0 |
| 2023-03-13 04:47:00 | SPY | ETF | 389.01 | 389.17 | 388.98 | 389.17 | 5045.0 |
| 2023-03-13 04:48:00 | SPY | ETF | 389.21 | 389.32 | 389.19 | 389.19 | 500.0 |
| 2023-03-13 04:49:00 | SPY | ETF | 389.15 | 389.15 | 389.07 | 389.1 | 2100.0 |
> showing 50 of 307,767 rows — these rows as CSV