PREVIEW / etf_1min / 2022-04-27
file: by_date/etf_1min/2022/2022-04-27.parquet size: 5.0 MB rows: 288,484
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 |
|---|---|---|---|---|---|---|---|
| 2022-04-27 04:00:00 | SPY | ETF | 419.0 | 420.22 | 419.0 | 419.95 | 5561.0 |
| 2022-04-27 04:01:00 | SPY | ETF | 419.95 | 419.99 | 419.91 | 419.98 | 563.0 |
| 2022-04-27 04:02:00 | SPY | ETF | 419.77 | 419.83 | 419.77 | 419.83 | 200.0 |
| 2022-04-27 04:03:00 | SPY | ETF | 419.84 | 419.84 | 419.68 | 419.69 | 38834.0 |
| 2022-04-27 04:04:00 | SPY | ETF | 419.7 | 419.77 | 419.5 | 419.77 | 12432.0 |
| 2022-04-27 04:05:00 | SPY | ETF | 419.6 | 419.69 | 419.6 | 419.69 | 500.0 |
| 2022-04-27 04:07:00 | SPY | ETF | 419.73 | 419.73 | 419.73 | 419.73 | 550.0 |
| 2022-04-27 04:08:00 | SPY | ETF | 419.61 | 419.68 | 419.61 | 419.68 | 200.0 |
| 2022-04-27 04:09:00 | SPY | ETF | 419.43 | 419.6 | 419.41 | 419.6 | 668.0 |
| 2022-04-27 04:11:00 | SPY | ETF | 419.95 | 419.95 | 419.95 | 419.95 | 100.0 |
| 2022-04-27 04:12:00 | SPY | ETF | 419.84 | 420.2 | 419.84 | 420.2 | 2995.0 |
| 2022-04-27 04:13:00 | SPY | ETF | 420.1 | 420.1 | 420.09 | 420.09 | 500.0 |
| 2022-04-27 04:14:00 | SPY | ETF | 420.2 | 420.56 | 420.2 | 420.56 | 1220.0 |
| 2022-04-27 04:15:00 | SPY | ETF | 420.57 | 420.62 | 420.55 | 420.6 | 16140.0 |
| 2022-04-27 04:16:00 | SPY | ETF | 420.51 | 420.79 | 420.51 | 420.79 | 4939.0 |
| 2022-04-27 04:17:00 | SPY | ETF | 420.82 | 420.92 | 420.8 | 420.92 | 5172.0 |
| 2022-04-27 04:18:00 | SPY | ETF | 420.83 | 420.85 | 420.8 | 420.85 | 12600.0 |
| 2022-04-27 04:19:00 | SPY | ETF | 420.89 | 420.9 | 420.89 | 420.9 | 200.0 |
| 2022-04-27 04:20:00 | SPY | ETF | 420.5 | 420.56 | 420.5 | 420.56 | 200.0 |
| 2022-04-27 04:21:00 | SPY | ETF | 420.51 | 420.51 | 420.5 | 420.5 | 200.0 |
| 2022-04-27 04:22:00 | SPY | ETF | 420.73 | 420.82 | 420.7 | 420.82 | 635.0 |
| 2022-04-27 04:23:00 | SPY | ETF | 420.99 | 421.0 | 420.95 | 420.95 | 11400.0 |
| 2022-04-27 04:24:00 | SPY | ETF | 420.61 | 420.68 | 420.61 | 420.68 | 600.0 |
| 2022-04-27 04:25:00 | SPY | ETF | 420.5 | 420.5 | 420.5 | 420.5 | 100.0 |
| 2022-04-27 04:26:00 | SPY | ETF | 420.48 | 420.53 | 420.47 | 420.53 | 1500.0 |
| 2022-04-27 04:27:00 | SPY | ETF | 420.52 | 420.52 | 420.52 | 420.52 | 1400.0 |
| 2022-04-27 04:28:00 | SPY | ETF | 420.51 | 420.53 | 420.4 | 420.41 | 3300.0 |
| 2022-04-27 04:29:00 | SPY | ETF | 420.41 | 420.43 | 420.3 | 420.3 | 5300.0 |
| 2022-04-27 04:30:00 | SPY | ETF | 420.31 | 420.52 | 420.3 | 420.52 | 1700.0 |
| 2022-04-27 04:32:00 | SPY | ETF | 420.26 | 420.26 | 420.2 | 420.2 | 1135.0 |
| 2022-04-27 04:33:00 | SPY | ETF | 420.17 | 420.17 | 420.1 | 420.1 | 400.0 |
| 2022-04-27 04:34:00 | SPY | ETF | 420.02 | 420.02 | 419.85 | 419.93 | 2100.0 |
| 2022-04-27 04:35:00 | SPY | ETF | 419.9 | 419.9 | 419.76 | 419.8 | 3200.0 |
| 2022-04-27 04:36:00 | SPY | ETF | 419.8 | 420.06 | 419.8 | 420.06 | 400.0 |
| 2022-04-27 04:37:00 | SPY | ETF | 419.97 | 420.15 | 419.97 | 420.15 | 2500.0 |
| 2022-04-27 04:38:00 | SPY | ETF | 419.85 | 420.0 | 419.85 | 420.0 | 600.0 |
| 2022-04-27 04:39:00 | SPY | ETF | 420.08 | 420.08 | 420.08 | 420.08 | 100.0 |
| 2022-04-27 04:41:00 | SPY | ETF | 420.2 | 420.2 | 420.2 | 420.2 | 800.0 |
| 2022-04-27 04:42:00 | SPY | ETF | 420.16 | 420.16 | 420.16 | 420.16 | 200.0 |
| 2022-04-27 04:43:00 | SPY | ETF | 420.05 | 420.05 | 420.05 | 420.05 | 100.0 |
| 2022-04-27 04:44:00 | SPY | ETF | 420.05 | 420.05 | 420.05 | 420.05 | 100.0 |
| 2022-04-27 04:45:00 | SPY | ETF | 420.01 | 420.01 | 419.7 | 419.8 | 2226.0 |
| 2022-04-27 04:46:00 | SPY | ETF | 419.8 | 419.8 | 419.7 | 419.7 | 500.0 |
| 2022-04-27 04:47:00 | SPY | ETF | 419.5 | 419.5 | 419.44 | 419.44 | 2700.0 |
| 2022-04-27 04:48:00 | SPY | ETF | 419.5 | 419.5 | 419.3 | 419.3 | 2800.0 |
| 2022-04-27 04:49:00 | SPY | ETF | 419.47 | 419.47 | 419.45 | 419.45 | 500.0 |
| 2022-04-27 04:50:00 | SPY | ETF | 419.32 | 419.35 | 419.26 | 419.31 | 25215.0 |
| 2022-04-27 04:51:00 | SPY | ETF | 419.42 | 419.45 | 419.4 | 419.45 | 2140.0 |
| 2022-04-27 04:52:00 | SPY | ETF | 419.38 | 419.38 | 419.37 | 419.37 | 3900.0 |
| 2022-04-27 04:53:00 | SPY | ETF | 419.37 | 419.53 | 419.37 | 419.52 | 7800.0 |
> showing 50 of 288,484 rows — these rows as CSV