PREVIEW / etf_1min / 2023-11-27
file: by_date/etf_1min/2023/2023-11-27.parquet size: 4.7 MB rows: 265,925
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-11-27 04:00:00 | SPY | ETF | 454.62 | 454.71 | 454.62 | 454.71 | 706.0 |
| 2023-11-27 04:02:00 | SPY | ETF | 454.43 | 454.43 | 454.43 | 454.43 | 500.0 |
| 2023-11-27 04:03:00 | SPY | ETF | 454.39 | 454.39 | 454.39 | 454.39 | 100.0 |
| 2023-11-27 04:04:00 | SPY | ETF | 454.39 | 454.39 | 454.36 | 454.39 | 2040.0 |
| 2023-11-27 04:05:00 | SPY | ETF | 454.37 | 454.39 | 454.37 | 454.39 | 1491.0 |
| 2023-11-27 04:06:00 | SPY | ETF | 454.4 | 454.4 | 454.37 | 454.37 | 957.0 |
| 2023-11-27 04:07:00 | SPY | ETF | 454.35 | 454.35 | 454.35 | 454.35 | 208.0 |
| 2023-11-27 04:08:00 | SPY | ETF | 454.29 | 454.29 | 454.29 | 454.29 | 430.0 |
| 2023-11-27 04:09:00 | SPY | ETF | 454.37 | 454.37 | 454.37 | 454.37 | 100.0 |
| 2023-11-27 04:10:00 | SPY | ETF | 454.37 | 454.37 | 454.35 | 454.35 | 200.0 |
| 2023-11-27 04:11:00 | SPY | ETF | 454.49 | 454.49 | 454.49 | 454.49 | 960.0 |
| 2023-11-27 04:14:00 | SPY | ETF | 454.53 | 454.53 | 454.53 | 454.53 | 200.0 |
| 2023-11-27 04:15:00 | SPY | ETF | 454.55 | 454.55 | 454.55 | 454.55 | 151.0 |
| 2023-11-27 04:16:00 | SPY | ETF | 454.5 | 454.5 | 454.5 | 454.5 | 410.0 |
| 2023-11-27 04:17:00 | SPY | ETF | 454.44 | 454.47 | 454.44 | 454.45 | 1686.0 |
| 2023-11-27 04:19:00 | SPY | ETF | 454.36 | 454.36 | 454.35 | 454.36 | 1164.0 |
| 2023-11-27 04:20:00 | SPY | ETF | 454.37 | 454.37 | 454.36 | 454.36 | 1500.0 |
| 2023-11-27 04:24:00 | SPY | ETF | 454.34 | 454.34 | 454.34 | 454.34 | 212.0 |
| 2023-11-27 04:27:00 | SPY | ETF | 454.35 | 454.35 | 454.35 | 454.35 | 100.0 |
| 2023-11-27 04:28:00 | SPY | ETF | 454.35 | 454.35 | 454.35 | 454.35 | 400.0 |
| 2023-11-27 04:36:00 | SPY | ETF | 454.23 | 454.23 | 454.23 | 454.23 | 500.0 |
| 2023-11-27 04:43:00 | SPY | ETF | 454.17 | 454.19 | 454.17 | 454.19 | 836.0 |
| 2023-11-27 04:51:00 | SPY | ETF | 454.17 | 454.17 | 454.17 | 454.17 | 967.0 |
| 2023-11-27 04:54:00 | SPY | ETF | 454.17 | 454.17 | 454.17 | 454.17 | 100.0 |
| 2023-11-27 04:55:00 | SPY | ETF | 454.11 | 454.11 | 454.11 | 454.11 | 500.0 |
| 2023-11-27 04:59:00 | SPY | ETF | 454.0 | 454.0 | 454.0 | 454.0 | 200.0 |
| 2023-11-27 05:00:00 | SPY | ETF | 454.07 | 454.07 | 454.07 | 454.07 | 100.0 |
| 2023-11-27 05:07:00 | SPY | ETF | 454.28 | 454.28 | 454.28 | 454.28 | 563.0 |
| 2023-11-27 05:09:00 | SPY | ETF | 454.21 | 454.21 | 454.21 | 454.21 | 100.0 |
| 2023-11-27 05:11:00 | SPY | ETF | 454.32 | 454.44 | 454.32 | 454.44 | 340.0 |
| 2023-11-27 05:13:00 | SPY | ETF | 454.49 | 454.49 | 454.49 | 454.49 | 200.0 |
| 2023-11-27 05:14:00 | SPY | ETF | 454.47 | 454.47 | 454.47 | 454.47 | 950.0 |
| 2023-11-27 05:15:00 | SPY | ETF | 454.5 | 454.56 | 454.5 | 454.56 | 715.0 |
| 2023-11-27 05:17:00 | SPY | ETF | 454.47 | 454.47 | 454.47 | 454.47 | 301.0 |
| 2023-11-27 05:19:00 | SPY | ETF | 454.59 | 454.59 | 454.59 | 454.59 | 124.0 |
| 2023-11-27 05:20:00 | SPY | ETF | 454.62 | 454.62 | 454.62 | 454.62 | 326.0 |
| 2023-11-27 05:22:00 | SPY | ETF | 454.63 | 454.63 | 454.63 | 454.63 | 600.0 |
| 2023-11-27 05:23:00 | SPY | ETF | 454.64 | 454.64 | 454.64 | 454.64 | 847.0 |
| 2023-11-27 05:26:00 | SPY | ETF | 454.68 | 454.7 | 454.68 | 454.7 | 662.0 |
| 2023-11-27 05:31:00 | SPY | ETF | 454.65 | 454.65 | 454.65 | 454.65 | 229.0 |
| 2023-11-27 05:33:00 | SPY | ETF | 454.6 | 454.6 | 454.6 | 454.6 | 750.0 |
| 2023-11-27 05:34:00 | SPY | ETF | 454.6 | 454.6 | 454.6 | 454.6 | 100.0 |
| 2023-11-27 05:35:00 | SPY | ETF | 454.6 | 454.6 | 454.6 | 454.6 | 326.0 |
| 2023-11-27 05:36:00 | SPY | ETF | 454.53 | 454.53 | 454.53 | 454.53 | 2326.0 |
| 2023-11-27 05:41:00 | SPY | ETF | 454.72 | 454.73 | 454.72 | 454.72 | 2410.0 |
| 2023-11-27 05:42:00 | SPY | ETF | 454.75 | 454.75 | 454.75 | 454.75 | 165.0 |
| 2023-11-27 05:49:00 | SPY | ETF | 454.8 | 454.8 | 454.8 | 454.8 | 305.0 |
| 2023-11-27 05:52:00 | SPY | ETF | 454.8 | 454.84 | 454.8 | 454.84 | 514.0 |
| 2023-11-27 05:53:00 | SPY | ETF | 454.84 | 454.85 | 454.84 | 454.85 | 450.0 |
| 2023-11-27 05:54:00 | SPY | ETF | 454.87 | 454.89 | 454.87 | 454.89 | 1442.0 |
> showing 50 of 265,925 rows — these rows as CSV