PREVIEW / etf_1min / 2022-10-25
file: by_date/etf_1min/2022/2022-10-25.parquet size: 4.8 MB rows: 277,836
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-10-25 04:00:00 | SPY | ETF | 378.0 | 378.98 | 378.0 | 378.98 | 4348.0 |
| 2022-10-25 04:01:00 | SPY | ETF | 378.76 | 378.76 | 378.7 | 378.75 | 1720.0 |
| 2022-10-25 04:02:00 | SPY | ETF | 378.7 | 378.89 | 378.65 | 378.89 | 1655.0 |
| 2022-10-25 04:03:00 | SPY | ETF | 378.92 | 378.93 | 378.91 | 378.91 | 1100.0 |
| 2022-10-25 04:04:00 | SPY | ETF | 378.85 | 378.94 | 378.85 | 378.93 | 3466.0 |
| 2022-10-25 04:05:00 | SPY | ETF | 378.9 | 378.9 | 378.9 | 378.9 | 100.0 |
| 2022-10-25 04:06:00 | SPY | ETF | 378.9 | 378.96 | 378.9 | 378.96 | 1875.0 |
| 2022-10-25 04:07:00 | SPY | ETF | 379.23 | 379.23 | 379.23 | 379.23 | 100.0 |
| 2022-10-25 04:08:00 | SPY | ETF | 379.03 | 379.03 | 379.03 | 379.03 | 100.0 |
| 2022-10-25 04:09:00 | SPY | ETF | 379.0 | 379.0 | 378.89 | 378.89 | 242.0 |
| 2022-10-25 04:10:00 | SPY | ETF | 378.91 | 378.91 | 378.91 | 378.91 | 500.0 |
| 2022-10-25 04:11:00 | SPY | ETF | 378.97 | 378.97 | 378.9 | 378.95 | 600.0 |
| 2022-10-25 04:12:00 | SPY | ETF | 379.09 | 379.19 | 379.09 | 379.19 | 600.0 |
| 2022-10-25 04:13:00 | SPY | ETF | 379.17 | 379.25 | 379.17 | 379.2 | 3573.0 |
| 2022-10-25 04:14:00 | SPY | ETF | 379.11 | 379.17 | 379.11 | 379.16 | 527.0 |
| 2022-10-25 04:15:00 | SPY | ETF | 379.24 | 379.24 | 379.18 | 379.18 | 1125.0 |
| 2022-10-25 04:16:00 | SPY | ETF | 379.25 | 379.25 | 379.25 | 379.25 | 200.0 |
| 2022-10-25 04:17:00 | SPY | ETF | 379.01 | 379.1 | 379.01 | 379.1 | 1257.0 |
| 2022-10-25 04:18:00 | SPY | ETF | 379.06 | 379.06 | 379.0 | 379.0 | 280.0 |
| 2022-10-25 04:20:00 | SPY | ETF | 378.87 | 378.87 | 378.8 | 378.8 | 2105.0 |
| 2022-10-25 04:21:00 | SPY | ETF | 378.8 | 378.8 | 378.8 | 378.8 | 140.0 |
| 2022-10-25 04:23:00 | SPY | ETF | 378.82 | 378.82 | 378.73 | 378.73 | 400.0 |
| 2022-10-25 04:24:00 | SPY | ETF | 378.78 | 378.8 | 378.7 | 378.7 | 2201.0 |
| 2022-10-25 04:28:00 | SPY | ETF | 378.7 | 378.7 | 378.7 | 378.7 | 300.0 |
| 2022-10-25 04:29:00 | SPY | ETF | 378.61 | 378.61 | 378.6 | 378.61 | 9751.0 |
| 2022-10-25 04:30:00 | SPY | ETF | 378.61 | 378.61 | 378.61 | 378.61 | 9070.0 |
| 2022-10-25 04:31:00 | SPY | ETF | 378.63 | 378.63 | 378.63 | 378.63 | 7700.0 |
| 2022-10-25 04:32:00 | SPY | ETF | 378.7 | 378.7 | 378.7 | 378.7 | 400.0 |
| 2022-10-25 04:34:00 | SPY | ETF | 378.74 | 378.74 | 378.74 | 378.74 | 101.0 |
| 2022-10-25 04:35:00 | SPY | ETF | 378.72 | 378.72 | 378.72 | 378.72 | 300.0 |
| 2022-10-25 04:36:00 | SPY | ETF | 378.67 | 378.67 | 378.67 | 378.67 | 100.0 |
| 2022-10-25 04:39:00 | SPY | ETF | 378.72 | 378.72 | 378.72 | 378.72 | 400.0 |
| 2022-10-25 04:43:00 | SPY | ETF | 379.02 | 379.02 | 378.95 | 378.96 | 4900.0 |
| 2022-10-25 04:44:00 | SPY | ETF | 378.79 | 378.79 | 378.79 | 378.79 | 250.0 |
| 2022-10-25 04:45:00 | SPY | ETF | 378.59 | 378.59 | 378.59 | 378.59 | 225.0 |
| 2022-10-25 04:46:00 | SPY | ETF | 378.54 | 378.54 | 378.54 | 378.54 | 127.0 |
| 2022-10-25 04:50:00 | SPY | ETF | 378.53 | 378.53 | 378.53 | 378.53 | 500.0 |
| 2022-10-25 04:52:00 | SPY | ETF | 378.6 | 378.6 | 378.6 | 378.6 | 100.0 |
| 2022-10-25 04:55:00 | SPY | ETF | 378.37 | 378.37 | 378.18 | 378.19 | 3439.0 |
| 2022-10-25 04:56:00 | SPY | ETF | 378.2 | 378.2 | 378.2 | 378.2 | 300.0 |
| 2022-10-25 04:57:00 | SPY | ETF | 378.01 | 378.09 | 378.01 | 378.09 | 300.0 |
| 2022-10-25 04:58:00 | SPY | ETF | 378.19 | 378.19 | 378.06 | 378.13 | 2000.0 |
| 2022-10-25 04:59:00 | SPY | ETF | 378.11 | 378.11 | 378.11 | 378.11 | 270.0 |
| 2022-10-25 05:00:00 | SPY | ETF | 378.08 | 378.09 | 377.98 | 377.98 | 1400.0 |
| 2022-10-25 05:01:00 | SPY | ETF | 377.95 | 377.95 | 377.93 | 377.94 | 2500.0 |
| 2022-10-25 05:05:00 | SPY | ETF | 377.8 | 377.8 | 377.8 | 377.8 | 100.0 |
| 2022-10-25 05:06:00 | SPY | ETF | 377.93 | 377.93 | 377.82 | 377.82 | 1030.0 |
| 2022-10-25 05:07:00 | SPY | ETF | 377.8 | 377.8 | 377.8 | 377.8 | 699.0 |
| 2022-10-25 05:08:00 | SPY | ETF | 377.84 | 377.84 | 377.81 | 377.81 | 740.0 |
| 2022-10-25 05:10:00 | SPY | ETF | 377.7 | 377.83 | 377.69 | 377.83 | 1110.0 |
> showing 50 of 277,836 rows — these rows as CSV