PREVIEW / etf_1min / 2022-06-24
file: by_date/etf_1min/2022/2022-06-24.parquet size: 4.6 MB rows: 263,329
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-06-24 04:00:00 | SPY | ETF | 380.77 | 380.88 | 380.0 | 380.66 | 3277.0 |
| 2022-06-24 04:01:00 | SPY | ETF | 380.88 | 381.0 | 380.76 | 381.0 | 6819.0 |
| 2022-06-24 04:02:00 | SPY | ETF | 381.25 | 381.25 | 381.01 | 381.01 | 500.0 |
| 2022-06-24 04:03:00 | SPY | ETF | 380.95 | 380.95 | 380.95 | 380.95 | 200.0 |
| 2022-06-24 04:04:00 | SPY | ETF | 380.96 | 381.0 | 380.79 | 380.89 | 5938.0 |
| 2022-06-24 04:05:00 | SPY | ETF | 380.8 | 380.82 | 380.65 | 380.65 | 690.0 |
| 2022-06-24 04:06:00 | SPY | ETF | 380.67 | 380.72 | 380.67 | 380.72 | 300.0 |
| 2022-06-24 04:08:00 | SPY | ETF | 380.71 | 380.79 | 380.71 | 380.79 | 600.0 |
| 2022-06-24 04:09:00 | SPY | ETF | 380.75 | 380.8 | 380.61 | 380.61 | 700.0 |
| 2022-06-24 04:10:00 | SPY | ETF | 380.58 | 380.63 | 380.58 | 380.58 | 2300.0 |
| 2022-06-24 04:11:00 | SPY | ETF | 380.7 | 380.7 | 380.7 | 380.7 | 100.0 |
| 2022-06-24 04:12:00 | SPY | ETF | 380.51 | 380.57 | 380.51 | 380.54 | 2000.0 |
| 2022-06-24 04:13:00 | SPY | ETF | 380.53 | 380.53 | 380.36 | 380.36 | 1050.0 |
| 2022-06-24 04:14:00 | SPY | ETF | 380.37 | 380.37 | 380.37 | 380.37 | 100.0 |
| 2022-06-24 04:15:00 | SPY | ETF | 380.63 | 380.63 | 380.63 | 380.63 | 100.0 |
| 2022-06-24 04:16:00 | SPY | ETF | 380.63 | 380.63 | 380.48 | 380.48 | 900.0 |
| 2022-06-24 04:17:00 | SPY | ETF | 380.6 | 380.64 | 380.6 | 380.64 | 800.0 |
| 2022-06-24 04:18:00 | SPY | ETF | 380.71 | 380.71 | 380.7 | 380.71 | 400.0 |
| 2022-06-24 04:19:00 | SPY | ETF | 380.68 | 380.68 | 380.68 | 380.68 | 100.0 |
| 2022-06-24 04:20:00 | SPY | ETF | 380.76 | 380.76 | 380.76 | 380.76 | 100.0 |
| 2022-06-24 04:22:00 | SPY | ETF | 380.31 | 380.32 | 380.3 | 380.3 | 600.0 |
| 2022-06-24 04:23:00 | SPY | ETF | 380.13 | 380.2 | 380.05 | 380.2 | 1900.0 |
| 2022-06-24 04:25:00 | SPY | ETF | 380.2 | 380.2 | 380.18 | 380.18 | 617.0 |
| 2022-06-24 04:26:00 | SPY | ETF | 380.21 | 380.21 | 380.21 | 380.21 | 198.0 |
| 2022-06-24 04:27:00 | SPY | ETF | 380.41 | 380.41 | 380.41 | 380.41 | 109.0 |
| 2022-06-24 04:28:00 | SPY | ETF | 380.53 | 380.57 | 380.5 | 380.5 | 1200.0 |
| 2022-06-24 04:30:00 | SPY | ETF | 380.61 | 380.61 | 380.61 | 380.61 | 400.0 |
| 2022-06-24 04:31:00 | SPY | ETF | 380.48 | 380.48 | 380.48 | 380.48 | 500.0 |
| 2022-06-24 04:32:00 | SPY | ETF | 380.61 | 380.61 | 380.6 | 380.6 | 600.0 |
| 2022-06-24 04:33:00 | SPY | ETF | 380.6 | 380.66 | 380.6 | 380.65 | 2000.0 |
| 2022-06-24 04:34:00 | SPY | ETF | 380.8 | 380.8 | 380.8 | 380.8 | 131.0 |
| 2022-06-24 04:36:00 | SPY | ETF | 380.7 | 380.79 | 380.7 | 380.79 | 599.0 |
| 2022-06-24 04:37:00 | SPY | ETF | 380.88 | 380.92 | 380.88 | 380.92 | 700.0 |
| 2022-06-24 04:39:00 | SPY | ETF | 380.72 | 380.8 | 380.72 | 380.8 | 1175.0 |
| 2022-06-24 04:40:00 | SPY | ETF | 380.89 | 380.89 | 380.89 | 380.89 | 990.0 |
| 2022-06-24 04:42:00 | SPY | ETF | 380.9 | 380.9 | 380.9 | 380.9 | 6990.0 |
| 2022-06-24 04:43:00 | SPY | ETF | 380.84 | 380.84 | 380.82 | 380.82 | 1000.0 |
| 2022-06-24 04:44:00 | SPY | ETF | 380.86 | 380.86 | 380.86 | 380.86 | 100.0 |
| 2022-06-24 04:45:00 | SPY | ETF | 380.84 | 380.84 | 380.84 | 380.84 | 145.0 |
| 2022-06-24 04:46:00 | SPY | ETF | 380.88 | 380.93 | 380.88 | 380.91 | 300.0 |
| 2022-06-24 04:49:00 | SPY | ETF | 380.83 | 380.83 | 380.67 | 380.67 | 382.0 |
| 2022-06-24 04:51:00 | SPY | ETF | 380.58 | 380.6 | 380.54 | 380.56 | 2400.0 |
| 2022-06-24 04:52:00 | SPY | ETF | 380.59 | 380.59 | 380.59 | 380.59 | 1490.0 |
| 2022-06-24 04:53:00 | SPY | ETF | 380.78 | 380.78 | 380.73 | 380.73 | 482.0 |
| 2022-06-24 04:55:00 | SPY | ETF | 380.76 | 380.79 | 380.76 | 380.79 | 325.0 |
| 2022-06-24 04:56:00 | SPY | ETF | 380.82 | 380.82 | 380.82 | 380.82 | 498.0 |
| 2022-06-24 04:57:00 | SPY | ETF | 380.84 | 380.95 | 380.84 | 380.95 | 2533.0 |
| 2022-06-24 04:58:00 | SPY | ETF | 380.84 | 380.84 | 380.84 | 380.84 | 100.0 |
| 2022-06-24 05:00:00 | SPY | ETF | 380.8 | 380.8 | 380.8 | 380.8 | 100.0 |
| 2022-06-24 05:01:00 | SPY | ETF | 380.79 | 380.79 | 380.79 | 380.79 | 1000.0 |
> showing 50 of 263,329 rows — these rows as CSV