PREVIEW / etf_1min / 2023-12-18
file: by_date/etf_1min/2023/2023-12-18.parquet size: 5.3 MB rows: 291,798
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-12-18 04:00:00 | SPY | ETF | 470.61 | 470.62 | 470.51 | 470.51 | 700.0 |
| 2023-12-18 04:01:00 | SPY | ETF | 470.41 | 470.49 | 470.41 | 470.48 | 5199.0 |
| 2023-12-18 04:02:00 | SPY | ETF | 470.45 | 470.45 | 470.45 | 470.45 | 100.0 |
| 2023-12-18 04:04:00 | SPY | ETF | 470.46 | 470.46 | 470.46 | 470.46 | 100.0 |
| 2023-12-18 04:05:00 | SPY | ETF | 470.46 | 470.46 | 470.46 | 470.46 | 100.0 |
| 2023-12-18 04:07:00 | SPY | ETF | 470.61 | 470.61 | 470.61 | 470.61 | 300.0 |
| 2023-12-18 04:10:00 | SPY | ETF | 470.65 | 470.65 | 470.65 | 470.65 | 100.0 |
| 2023-12-18 04:11:00 | SPY | ETF | 470.65 | 470.65 | 470.63 | 470.63 | 807.0 |
| 2023-12-18 04:12:00 | SPY | ETF | 470.67 | 470.67 | 470.67 | 470.67 | 344.0 |
| 2023-12-18 04:18:00 | SPY | ETF | 470.51 | 470.51 | 470.46 | 470.46 | 300.0 |
| 2023-12-18 04:20:00 | SPY | ETF | 470.45 | 470.53 | 470.45 | 470.53 | 584.0 |
| 2023-12-18 04:21:00 | SPY | ETF | 470.57 | 470.57 | 470.57 | 470.57 | 110.0 |
| 2023-12-18 04:22:00 | SPY | ETF | 470.52 | 470.52 | 470.52 | 470.52 | 120.0 |
| 2023-12-18 04:27:00 | SPY | ETF | 470.74 | 470.74 | 470.74 | 470.74 | 100.0 |
| 2023-12-18 04:31:00 | SPY | ETF | 470.76 | 470.76 | 470.66 | 470.67 | 1882.0 |
| 2023-12-18 04:34:00 | SPY | ETF | 470.73 | 470.73 | 470.73 | 470.73 | 100.0 |
| 2023-12-18 04:45:00 | SPY | ETF | 470.74 | 470.74 | 470.69 | 470.69 | 206.0 |
| 2023-12-18 04:48:00 | SPY | ETF | 470.72 | 470.72 | 470.33 | 470.67 | 14950.0 |
| 2023-12-18 04:54:00 | SPY | ETF | 470.72 | 470.72 | 470.72 | 470.72 | 100.0 |
| 2023-12-18 04:56:00 | SPY | ETF | 470.68 | 470.68 | 470.68 | 470.68 | 200.0 |
| 2023-12-18 04:59:00 | SPY | ETF | 470.63 | 470.63 | 470.63 | 470.63 | 139.0 |
| 2023-12-18 05:05:00 | SPY | ETF | 470.61 | 470.61 | 470.61 | 470.61 | 500.0 |
| 2023-12-18 05:06:00 | SPY | ETF | 470.56 | 470.56 | 470.54 | 470.56 | 3000.0 |
| 2023-12-18 05:07:00 | SPY | ETF | 470.6 | 470.6 | 470.6 | 470.6 | 284.0 |
| 2023-12-18 05:11:00 | SPY | ETF | 470.54 | 470.54 | 470.53 | 470.54 | 2697.0 |
| 2023-12-18 05:22:00 | SPY | ETF | 470.72 | 470.72 | 470.72 | 470.72 | 100.0 |
| 2023-12-18 05:23:00 | SPY | ETF | 470.8 | 470.8 | 470.8 | 470.8 | 300.0 |
| 2023-12-18 05:27:00 | SPY | ETF | 470.7 | 470.7 | 470.7 | 470.7 | 200.0 |
| 2023-12-18 05:30:00 | SPY | ETF | 470.78 | 470.78 | 470.78 | 470.78 | 100.0 |
| 2023-12-18 05:33:00 | SPY | ETF | 470.86 | 470.88 | 470.86 | 470.88 | 200.0 |
| 2023-12-18 05:35:00 | SPY | ETF | 470.7 | 470.7 | 470.7 | 470.7 | 300.0 |
| 2023-12-18 05:42:00 | SPY | ETF | 470.55 | 470.55 | 470.55 | 470.55 | 100.0 |
| 2023-12-18 05:47:00 | SPY | ETF | 470.46 | 470.46 | 470.46 | 470.46 | 159.0 |
| 2023-12-18 05:52:00 | SPY | ETF | 470.55 | 470.56 | 470.55 | 470.56 | 600.0 |
| 2023-12-18 05:58:00 | SPY | ETF | 470.55 | 470.55 | 470.55 | 470.55 | 100.0 |
| 2023-12-18 05:59:00 | SPY | ETF | 470.52 | 470.52 | 470.52 | 470.52 | 500.0 |
| 2023-12-18 06:03:00 | SPY | ETF | 470.47 | 470.47 | 470.47 | 470.47 | 300.0 |
| 2023-12-18 06:06:00 | SPY | ETF | 470.57 | 470.57 | 470.57 | 470.57 | 200.0 |
| 2023-12-18 06:07:00 | SPY | ETF | 470.52 | 470.52 | 470.52 | 470.52 | 100.0 |
| 2023-12-18 06:09:00 | SPY | ETF | 470.54 | 470.54 | 470.54 | 470.54 | 500.0 |
| 2023-12-18 06:13:00 | SPY | ETF | 470.49 | 470.49 | 470.49 | 470.49 | 100.0 |
| 2023-12-18 06:16:00 | SPY | ETF | 470.52 | 470.52 | 470.52 | 470.52 | 302.0 |
| 2023-12-18 06:19:00 | SPY | ETF | 470.61 | 470.61 | 470.61 | 470.61 | 718.0 |
| 2023-12-18 06:20:00 | SPY | ETF | 470.74 | 470.74 | 470.74 | 470.74 | 700.0 |
| 2023-12-18 06:21:00 | SPY | ETF | 470.69 | 470.69 | 470.69 | 470.69 | 222.0 |
| 2023-12-18 06:25:00 | SPY | ETF | 470.69 | 470.69 | 470.69 | 470.69 | 231.0 |
| 2023-12-18 06:28:00 | SPY | ETF | 470.5 | 470.5 | 470.5 | 470.5 | 100.0 |
| 2023-12-18 06:29:00 | SPY | ETF | 470.45 | 470.45 | 470.45 | 470.45 | 122.0 |
| 2023-12-18 06:35:00 | SPY | ETF | 470.33 | 470.35 | 470.33 | 470.35 | 219.0 |
| 2023-12-18 06:37:00 | SPY | ETF | 470.32 | 470.32 | 470.31 | 470.31 | 616.0 |
> showing 50 of 291,798 rows — these rows as CSV