PREVIEW / etf_1min / 2022-10-21
file: by_date/etf_1min/2022/2022-10-21.parquet size: 4.8 MB rows: 277,768
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-21 04:00:00 | SPY | ETF | 364.0 | 364.0 | 363.87 | 363.87 | 700.0 |
| 2022-10-21 04:01:00 | SPY | ETF | 364.14 | 364.22 | 364.02 | 364.02 | 1000.0 |
| 2022-10-21 04:02:00 | SPY | ETF | 363.91 | 363.91 | 363.83 | 363.85 | 3450.0 |
| 2022-10-21 04:03:00 | SPY | ETF | 363.99 | 364.08 | 363.96 | 363.96 | 1071.0 |
| 2022-10-21 04:04:00 | SPY | ETF | 363.94 | 363.94 | 363.94 | 363.94 | 500.0 |
| 2022-10-21 04:05:00 | SPY | ETF | 363.91 | 363.94 | 363.77 | 363.77 | 3130.0 |
| 2022-10-21 04:06:00 | SPY | ETF | 363.84 | 363.92 | 363.81 | 363.81 | 2300.0 |
| 2022-10-21 04:07:00 | SPY | ETF | 363.9 | 363.9 | 363.9 | 363.9 | 500.0 |
| 2022-10-21 04:08:00 | SPY | ETF | 363.83 | 363.83 | 363.77 | 363.77 | 400.0 |
| 2022-10-21 04:09:00 | SPY | ETF | 363.62 | 363.74 | 363.62 | 363.74 | 300.0 |
| 2022-10-21 04:10:00 | SPY | ETF | 363.75 | 363.75 | 363.75 | 363.75 | 100.0 |
| 2022-10-21 04:11:00 | SPY | ETF | 363.91 | 364.0 | 363.91 | 363.96 | 840.0 |
| 2022-10-21 04:12:00 | SPY | ETF | 363.83 | 363.83 | 363.83 | 363.83 | 200.0 |
| 2022-10-21 04:13:00 | SPY | ETF | 363.71 | 363.72 | 363.7 | 363.7 | 500.0 |
| 2022-10-21 04:15:00 | SPY | ETF | 363.75 | 363.75 | 363.67 | 363.67 | 500.0 |
| 2022-10-21 04:16:00 | SPY | ETF | 363.63 | 363.7 | 363.49 | 363.5 | 13264.0 |
| 2022-10-21 04:17:00 | SPY | ETF | 363.63 | 363.69 | 363.62 | 363.67 | 3675.0 |
| 2022-10-21 04:18:00 | SPY | ETF | 363.91 | 363.99 | 363.91 | 363.99 | 200.0 |
| 2022-10-21 04:19:00 | SPY | ETF | 363.93 | 363.93 | 363.83 | 363.83 | 913.0 |
| 2022-10-21 04:20:00 | SPY | ETF | 363.5 | 363.5 | 363.5 | 363.5 | 100.0 |
| 2022-10-21 04:21:00 | SPY | ETF | 363.39 | 363.39 | 363.39 | 363.39 | 500.0 |
| 2022-10-21 04:23:00 | SPY | ETF | 363.41 | 363.41 | 363.41 | 363.41 | 1300.0 |
| 2022-10-21 04:24:00 | SPY | ETF | 363.39 | 363.39 | 363.39 | 363.39 | 100.0 |
| 2022-10-21 04:25:00 | SPY | ETF | 363.39 | 363.39 | 363.38 | 363.38 | 400.0 |
| 2022-10-21 04:27:00 | SPY | ETF | 363.29 | 363.33 | 363.23 | 363.3 | 1000.0 |
| 2022-10-21 04:31:00 | SPY | ETF | 363.26 | 363.26 | 363.16 | 363.16 | 400.0 |
| 2022-10-21 04:32:00 | SPY | ETF | 363.18 | 363.21 | 363.18 | 363.21 | 200.0 |
| 2022-10-21 04:33:00 | SPY | ETF | 363.34 | 363.34 | 363.34 | 363.34 | 300.0 |
| 2022-10-21 04:35:00 | SPY | ETF | 363.32 | 363.32 | 363.29 | 363.29 | 1100.0 |
| 2022-10-21 04:36:00 | SPY | ETF | 363.34 | 363.4 | 363.34 | 363.4 | 200.0 |
| 2022-10-21 04:37:00 | SPY | ETF | 363.37 | 363.37 | 363.27 | 363.27 | 400.0 |
| 2022-10-21 04:39:00 | SPY | ETF | 363.26 | 363.28 | 363.16 | 363.16 | 2000.0 |
| 2022-10-21 04:43:00 | SPY | ETF | 363.16 | 363.17 | 363.16 | 363.17 | 200.0 |
| 2022-10-21 04:45:00 | SPY | ETF | 363.11 | 363.11 | 363.07 | 363.11 | 450.0 |
| 2022-10-21 04:46:00 | SPY | ETF | 363.13 | 363.15 | 363.13 | 363.15 | 325.0 |
| 2022-10-21 04:49:00 | SPY | ETF | 363.27 | 363.27 | 363.27 | 363.27 | 100.0 |
| 2022-10-21 04:50:00 | SPY | ETF | 363.4 | 363.4 | 363.4 | 363.4 | 300.0 |
| 2022-10-21 04:52:00 | SPY | ETF | 363.17 | 363.18 | 363.16 | 363.18 | 400.0 |
| 2022-10-21 04:55:00 | SPY | ETF | 363.2 | 363.2 | 363.2 | 363.2 | 200.0 |
| 2022-10-21 04:56:00 | SPY | ETF | 363.2 | 363.2 | 363.2 | 363.2 | 100.0 |
| 2022-10-21 04:58:00 | SPY | ETF | 363.18 | 363.18 | 363.18 | 363.18 | 400.0 |
| 2022-10-21 05:00:00 | SPY | ETF | 363.36 | 363.36 | 363.34 | 363.34 | 300.0 |
| 2022-10-21 05:01:00 | SPY | ETF | 363.32 | 363.32 | 363.32 | 363.32 | 500.0 |
| 2022-10-21 05:02:00 | SPY | ETF | 363.4 | 363.4 | 363.4 | 363.4 | 210.0 |
| 2022-10-21 05:03:00 | SPY | ETF | 363.51 | 363.51 | 363.45 | 363.45 | 496.0 |
| 2022-10-21 05:06:00 | SPY | ETF | 363.13 | 363.14 | 362.95 | 362.95 | 3475.0 |
| 2022-10-21 05:07:00 | SPY | ETF | 362.88 | 362.92 | 362.84 | 362.92 | 2600.0 |
| 2022-10-21 05:09:00 | SPY | ETF | 363.2 | 363.31 | 363.2 | 363.31 | 500.0 |
| 2022-10-21 05:10:00 | SPY | ETF | 363.26 | 363.5 | 363.26 | 363.45 | 1250.0 |
| 2022-10-21 05:11:00 | SPY | ETF | 363.4 | 363.4 | 363.24 | 363.24 | 475.0 |
> showing 50 of 277,768 rows — these rows as CSV