PREVIEW / etf_1min / 2022-03-28
file: by_date/etf_1min/2022/2022-03-28.parquet size: 4.5 MB rows: 255,318
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-03-28 04:00:00 | SPY | ETF | 451.96 | 451.96 | 451.77 | 451.77 | 724.0 |
| 2022-03-28 04:01:00 | SPY | ETF | 451.76 | 451.76 | 451.75 | 451.75 | 316.0 |
| 2022-03-28 04:02:00 | SPY | ETF | 451.65 | 451.65 | 451.65 | 451.65 | 150.0 |
| 2022-03-28 04:03:00 | SPY | ETF | 451.4 | 451.4 | 451.38 | 451.38 | 331.0 |
| 2022-03-28 04:04:00 | SPY | ETF | 451.34 | 451.34 | 451.34 | 451.34 | 798.0 |
| 2022-03-28 04:05:00 | SPY | ETF | 451.46 | 451.49 | 451.38 | 451.38 | 1289.0 |
| 2022-03-28 04:06:00 | SPY | ETF | 451.36 | 451.36 | 451.28 | 451.31 | 6415.0 |
| 2022-03-28 04:07:00 | SPY | ETF | 451.24 | 451.32 | 451.24 | 451.32 | 991.0 |
| 2022-03-28 04:08:00 | SPY | ETF | 451.3 | 451.31 | 451.29 | 451.31 | 2437.0 |
| 2022-03-28 04:09:00 | SPY | ETF | 451.26 | 451.43 | 451.26 | 451.43 | 528.0 |
| 2022-03-28 04:10:00 | SPY | ETF | 451.43 | 451.44 | 451.43 | 451.44 | 300.0 |
| 2022-03-28 04:11:00 | SPY | ETF | 451.46 | 451.46 | 451.46 | 451.46 | 299.0 |
| 2022-03-28 04:12:00 | SPY | ETF | 451.5 | 451.5 | 451.5 | 451.5 | 132.0 |
| 2022-03-28 04:13:00 | SPY | ETF | 451.49 | 451.49 | 451.49 | 451.49 | 129.0 |
| 2022-03-28 04:14:00 | SPY | ETF | 451.6 | 451.6 | 451.6 | 451.6 | 177.0 |
| 2022-03-28 04:15:00 | SPY | ETF | 451.55 | 451.59 | 451.55 | 451.59 | 850.0 |
| 2022-03-28 04:16:00 | SPY | ETF | 451.67 | 451.8 | 451.67 | 451.8 | 595.0 |
| 2022-03-28 04:17:00 | SPY | ETF | 451.95 | 451.97 | 451.85 | 451.94 | 7000.0 |
| 2022-03-28 04:18:00 | SPY | ETF | 451.84 | 452.05 | 451.84 | 452.05 | 2349.0 |
| 2022-03-28 04:20:00 | SPY | ETF | 451.88 | 451.95 | 451.87 | 451.95 | 607.0 |
| 2022-03-28 04:22:00 | SPY | ETF | 451.89 | 451.89 | 451.85 | 451.85 | 2419.0 |
| 2022-03-28 04:26:00 | SPY | ETF | 452.01 | 452.01 | 452.01 | 452.01 | 100.0 |
| 2022-03-28 04:28:00 | SPY | ETF | 451.93 | 451.94 | 451.93 | 451.94 | 520.0 |
| 2022-03-28 04:31:00 | SPY | ETF | 451.89 | 451.89 | 451.8 | 451.8 | 614.0 |
| 2022-03-28 04:35:00 | SPY | ETF | 451.88 | 451.88 | 451.88 | 451.88 | 100.0 |
| 2022-03-28 04:40:00 | SPY | ETF | 451.94 | 451.99 | 451.94 | 451.99 | 200.0 |
| 2022-03-28 04:41:00 | SPY | ETF | 451.96 | 451.96 | 451.96 | 451.96 | 300.0 |
| 2022-03-28 04:44:00 | SPY | ETF | 452.1 | 452.11 | 452.1 | 452.11 | 350.0 |
| 2022-03-28 04:45:00 | SPY | ETF | 452.08 | 452.08 | 452.05 | 452.05 | 200.0 |
| 2022-03-28 04:46:00 | SPY | ETF | 452.1 | 452.16 | 452.1 | 452.16 | 400.0 |
| 2022-03-28 04:48:00 | SPY | ETF | 452.4 | 452.4 | 452.38 | 452.38 | 350.0 |
| 2022-03-28 04:49:00 | SPY | ETF | 452.42 | 452.42 | 452.42 | 452.42 | 100.0 |
| 2022-03-28 04:51:00 | SPY | ETF | 452.4 | 452.4 | 452.4 | 452.4 | 300.0 |
| 2022-03-28 04:52:00 | SPY | ETF | 452.5 | 452.5 | 452.5 | 452.5 | 100.0 |
| 2022-03-28 04:54:00 | SPY | ETF | 452.6 | 452.6 | 452.6 | 452.6 | 100.0 |
| 2022-03-28 04:55:00 | SPY | ETF | 452.67 | 452.75 | 452.67 | 452.75 | 850.0 |
| 2022-03-28 04:56:00 | SPY | ETF | 452.79 | 452.84 | 452.79 | 452.84 | 232.0 |
| 2022-03-28 04:59:00 | SPY | ETF | 452.87 | 452.87 | 452.87 | 452.87 | 200.0 |
| 2022-03-28 05:00:00 | SPY | ETF | 452.81 | 452.81 | 452.75 | 452.75 | 332.0 |
| 2022-03-28 05:01:00 | SPY | ETF | 452.83 | 452.83 | 452.77 | 452.77 | 600.0 |
| 2022-03-28 05:02:00 | SPY | ETF | 452.7 | 452.7 | 452.62 | 452.62 | 200.0 |
| 2022-03-28 05:03:00 | SPY | ETF | 452.59 | 452.59 | 452.59 | 452.59 | 100.0 |
| 2022-03-28 05:04:00 | SPY | ETF | 452.6 | 452.6 | 452.45 | 452.45 | 605.0 |
| 2022-03-28 05:05:00 | SPY | ETF | 452.46 | 452.46 | 452.45 | 452.45 | 902.0 |
| 2022-03-28 05:06:00 | SPY | ETF | 452.31 | 452.31 | 452.31 | 452.31 | 100.0 |
| 2022-03-28 05:08:00 | SPY | ETF | 452.25 | 452.25 | 452.25 | 452.25 | 500.0 |
| 2022-03-28 05:11:00 | SPY | ETF | 452.17 | 452.17 | 452.12 | 452.12 | 550.0 |
| 2022-03-28 05:12:00 | SPY | ETF | 452.16 | 452.18 | 452.12 | 452.16 | 883.0 |
| 2022-03-28 05:13:00 | SPY | ETF | 452.11 | 452.11 | 452.11 | 452.11 | 590.0 |
| 2022-03-28 05:16:00 | SPY | ETF | 452.0 | 452.0 | 452.0 | 452.0 | 100.0 |
> showing 50 of 255,318 rows — these rows as CSV