PREVIEW / etf_1min / 2022-07-25
file: by_date/etf_1min/2022/2022-07-25.parquet size: 4.1 MB rows: 239,348
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-07-25 04:00:00 | SPY | ETF | 394.42 | 394.73 | 394.42 | 394.59 | 1273.0 |
| 2022-07-25 04:02:00 | SPY | ETF | 394.66 | 394.66 | 394.66 | 394.66 | 142.0 |
| 2022-07-25 04:03:00 | SPY | ETF | 394.68 | 394.91 | 394.68 | 394.91 | 420.0 |
| 2022-07-25 04:04:00 | SPY | ETF | 394.79 | 394.79 | 394.79 | 394.79 | 496.0 |
| 2022-07-25 04:05:00 | SPY | ETF | 394.79 | 394.82 | 394.79 | 394.79 | 2044.0 |
| 2022-07-25 04:06:00 | SPY | ETF | 394.89 | 394.89 | 394.89 | 394.89 | 300.0 |
| 2022-07-25 04:07:00 | SPY | ETF | 394.89 | 395.0 | 394.87 | 395.0 | 4400.0 |
| 2022-07-25 04:08:00 | SPY | ETF | 395.1 | 395.21 | 395.1 | 395.21 | 2161.0 |
| 2022-07-25 04:10:00 | SPY | ETF | 395.2 | 395.2 | 395.14 | 395.15 | 9002.0 |
| 2022-07-25 04:11:00 | SPY | ETF | 395.16 | 395.16 | 395.15 | 395.15 | 574.0 |
| 2022-07-25 04:13:00 | SPY | ETF | 395.15 | 395.15 | 395.01 | 395.01 | 700.0 |
| 2022-07-25 04:14:00 | SPY | ETF | 395.01 | 395.01 | 394.89 | 394.89 | 2492.0 |
| 2022-07-25 04:15:00 | SPY | ETF | 395.01 | 395.01 | 395.01 | 395.01 | 166.0 |
| 2022-07-25 04:16:00 | SPY | ETF | 395.0 | 395.11 | 395.0 | 395.05 | 973.0 |
| 2022-07-25 04:17:00 | SPY | ETF | 395.12 | 395.12 | 395.12 | 395.12 | 700.0 |
| 2022-07-25 04:19:00 | SPY | ETF | 395.25 | 395.25 | 395.25 | 395.25 | 500.0 |
| 2022-07-25 04:24:00 | SPY | ETF | 395.3 | 395.3 | 395.3 | 395.3 | 100.0 |
| 2022-07-25 04:25:00 | SPY | ETF | 395.4 | 395.4 | 395.4 | 395.4 | 200.0 |
| 2022-07-25 04:27:00 | SPY | ETF | 395.36 | 395.36 | 395.36 | 395.36 | 100.0 |
| 2022-07-25 04:28:00 | SPY | ETF | 395.35 | 395.35 | 395.27 | 395.28 | 985.0 |
| 2022-07-25 04:29:00 | SPY | ETF | 395.22 | 395.26 | 395.22 | 395.26 | 1150.0 |
| 2022-07-25 04:30:00 | SPY | ETF | 395.32 | 395.32 | 395.32 | 395.32 | 213.0 |
| 2022-07-25 04:32:00 | SPY | ETF | 395.33 | 395.33 | 395.33 | 395.33 | 164.0 |
| 2022-07-25 04:35:00 | SPY | ETF | 395.34 | 395.49 | 395.34 | 395.49 | 326.0 |
| 2022-07-25 04:36:00 | SPY | ETF | 395.52 | 395.77 | 395.52 | 395.77 | 936.0 |
| 2022-07-25 04:37:00 | SPY | ETF | 395.87 | 395.96 | 395.87 | 395.96 | 2152.0 |
| 2022-07-25 04:38:00 | SPY | ETF | 395.91 | 395.96 | 395.87 | 395.96 | 1450.0 |
| 2022-07-25 04:39:00 | SPY | ETF | 396.0 | 396.0 | 396.0 | 396.0 | 200.0 |
| 2022-07-25 04:40:00 | SPY | ETF | 395.99 | 395.99 | 395.87 | 395.87 | 2003.0 |
| 2022-07-25 04:42:00 | SPY | ETF | 396.0 | 396.0 | 396.0 | 396.0 | 234.0 |
| 2022-07-25 04:44:00 | SPY | ETF | 395.92 | 395.92 | 395.92 | 395.92 | 201.0 |
| 2022-07-25 04:47:00 | SPY | ETF | 396.02 | 396.02 | 395.93 | 395.93 | 600.0 |
| 2022-07-25 04:49:00 | SPY | ETF | 395.89 | 395.89 | 395.89 | 395.89 | 192.0 |
| 2022-07-25 04:50:00 | SPY | ETF | 395.86 | 395.86 | 395.86 | 395.86 | 100.0 |
| 2022-07-25 04:51:00 | SPY | ETF | 395.85 | 395.98 | 395.85 | 395.98 | 1918.0 |
| 2022-07-25 04:53:00 | SPY | ETF | 395.94 | 395.97 | 395.94 | 395.97 | 600.0 |
| 2022-07-25 04:54:00 | SPY | ETF | 395.99 | 395.99 | 395.91 | 395.91 | 900.0 |
| 2022-07-25 04:55:00 | SPY | ETF | 395.88 | 395.88 | 395.88 | 395.88 | 682.0 |
| 2022-07-25 04:57:00 | SPY | ETF | 395.93 | 395.93 | 395.93 | 395.93 | 200.0 |
| 2022-07-25 05:00:00 | SPY | ETF | 395.84 | 395.84 | 395.84 | 395.84 | 100.0 |
| 2022-07-25 05:01:00 | SPY | ETF | 395.84 | 395.84 | 395.84 | 395.84 | 139.0 |
| 2022-07-25 05:02:00 | SPY | ETF | 395.88 | 395.88 | 395.88 | 395.88 | 970.0 |
| 2022-07-25 05:05:00 | SPY | ETF | 396.05 | 396.22 | 396.05 | 396.22 | 400.0 |
| 2022-07-25 05:06:00 | SPY | ETF | 396.32 | 396.32 | 396.28 | 396.28 | 1020.0 |
| 2022-07-25 05:07:00 | SPY | ETF | 396.34 | 396.36 | 396.31 | 396.35 | 2100.0 |
| 2022-07-25 05:08:00 | SPY | ETF | 396.37 | 396.39 | 396.37 | 396.39 | 600.0 |
| 2022-07-25 05:09:00 | SPY | ETF | 396.25 | 396.25 | 396.22 | 396.22 | 636.0 |
| 2022-07-25 05:10:00 | SPY | ETF | 396.16 | 396.16 | 396.16 | 396.16 | 988.0 |
| 2022-07-25 05:11:00 | SPY | ETF | 396.13 | 396.13 | 396.13 | 396.13 | 350.0 |
| 2022-07-25 05:13:00 | SPY | ETF | 396.24 | 396.24 | 396.24 | 396.24 | 200.0 |
> showing 50 of 239,348 rows — these rows as CSV