PREVIEW / etf_1min / 2022-03-15
file: by_date/etf_1min/2022/2022-03-15.parquet size: 4.8 MB rows: 274,825
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-15 04:00:00 | SPY | ETF | 415.71 | 415.72 | 415.6 | 415.65 | 3610.0 |
| 2022-03-15 04:01:00 | SPY | ETF | 415.7 | 415.7 | 415.7 | 415.7 | 500.0 |
| 2022-03-15 04:02:00 | SPY | ETF | 415.31 | 415.33 | 415.27 | 415.27 | 798.0 |
| 2022-03-15 04:03:00 | SPY | ETF | 415.32 | 415.32 | 415.32 | 415.32 | 100.0 |
| 2022-03-15 04:04:00 | SPY | ETF | 415.33 | 415.7 | 415.33 | 415.62 | 1012.0 |
| 2022-03-15 04:05:00 | SPY | ETF | 415.67 | 415.99 | 415.66 | 415.78 | 1294.0 |
| 2022-03-15 04:06:00 | SPY | ETF | 416.0 | 416.04 | 416.0 | 416.04 | 480.0 |
| 2022-03-15 04:07:00 | SPY | ETF | 416.23 | 417.32 | 416.08 | 417.31 | 4209.0 |
| 2022-03-15 04:08:00 | SPY | ETF | 417.48 | 417.48 | 417.01 | 417.01 | 1800.0 |
| 2022-03-15 04:09:00 | SPY | ETF | 416.86 | 416.86 | 416.27 | 416.38 | 8000.0 |
| 2022-03-15 04:10:00 | SPY | ETF | 416.18 | 416.18 | 416.15 | 416.15 | 1200.0 |
| 2022-03-15 04:11:00 | SPY | ETF | 416.0 | 416.0 | 416.0 | 416.0 | 700.0 |
| 2022-03-15 04:12:00 | SPY | ETF | 416.0 | 416.03 | 415.88 | 415.88 | 800.0 |
| 2022-03-15 04:13:00 | SPY | ETF | 415.77 | 416.05 | 415.77 | 416.05 | 1178.0 |
| 2022-03-15 04:14:00 | SPY | ETF | 415.99 | 415.99 | 415.8 | 415.8 | 400.0 |
| 2022-03-15 04:16:00 | SPY | ETF | 415.75 | 415.75 | 415.52 | 415.52 | 800.0 |
| 2022-03-15 04:17:00 | SPY | ETF | 415.77 | 415.77 | 415.77 | 415.77 | 544.0 |
| 2022-03-15 04:18:00 | SPY | ETF | 415.65 | 415.65 | 415.65 | 415.65 | 100.0 |
| 2022-03-15 04:19:00 | SPY | ETF | 415.58 | 415.58 | 415.58 | 415.58 | 100.0 |
| 2022-03-15 04:20:00 | SPY | ETF | 415.46 | 415.46 | 415.46 | 415.46 | 500.0 |
| 2022-03-15 04:21:00 | SPY | ETF | 415.47 | 415.47 | 415.47 | 415.47 | 300.0 |
| 2022-03-15 04:22:00 | SPY | ETF | 415.0 | 415.09 | 415.0 | 415.09 | 700.0 |
| 2022-03-15 04:23:00 | SPY | ETF | 414.89 | 414.96 | 414.89 | 414.96 | 500.0 |
| 2022-03-15 04:24:00 | SPY | ETF | 415.09 | 415.16 | 415.09 | 415.1 | 1597.0 |
| 2022-03-15 04:25:00 | SPY | ETF | 415.26 | 415.29 | 415.23 | 415.23 | 1600.0 |
| 2022-03-15 04:27:00 | SPY | ETF | 415.44 | 415.53 | 415.41 | 415.41 | 2800.0 |
| 2022-03-15 04:28:00 | SPY | ETF | 415.4 | 415.4 | 415.15 | 415.15 | 500.0 |
| 2022-03-15 04:30:00 | SPY | ETF | 415.07 | 415.07 | 415.01 | 415.01 | 200.0 |
| 2022-03-15 04:31:00 | SPY | ETF | 414.8 | 415.03 | 414.8 | 415.03 | 6349.0 |
| 2022-03-15 04:32:00 | SPY | ETF | 415.04 | 415.04 | 415.04 | 415.04 | 500.0 |
| 2022-03-15 04:33:00 | SPY | ETF | 415.19 | 415.19 | 415.14 | 415.14 | 200.0 |
| 2022-03-15 04:34:00 | SPY | ETF | 415.14 | 415.14 | 415.11 | 415.11 | 400.0 |
| 2022-03-15 04:35:00 | SPY | ETF | 415.25 | 415.45 | 415.25 | 415.45 | 200.0 |
| 2022-03-15 04:36:00 | SPY | ETF | 415.15 | 415.42 | 415.15 | 415.42 | 300.0 |
| 2022-03-15 04:37:00 | SPY | ETF | 415.35 | 415.35 | 415.26 | 415.26 | 450.0 |
| 2022-03-15 04:38:00 | SPY | ETF | 415.0 | 415.0 | 415.0 | 415.0 | 100.0 |
| 2022-03-15 04:39:00 | SPY | ETF | 414.9 | 414.9 | 414.9 | 414.9 | 500.0 |
| 2022-03-15 04:40:00 | SPY | ETF | 415.0 | 415.04 | 415.0 | 415.03 | 750.0 |
| 2022-03-15 04:44:00 | SPY | ETF | 415.41 | 415.41 | 415.29 | 415.29 | 200.0 |
| 2022-03-15 04:45:00 | SPY | ETF | 415.12 | 415.12 | 415.07 | 415.07 | 200.0 |
| 2022-03-15 04:46:00 | SPY | ETF | 414.88 | 414.94 | 414.88 | 414.94 | 200.0 |
| 2022-03-15 04:47:00 | SPY | ETF | 414.8 | 414.8 | 414.76 | 414.76 | 200.0 |
| 2022-03-15 04:48:00 | SPY | ETF | 414.77 | 414.77 | 414.52 | 414.52 | 1750.0 |
| 2022-03-15 04:49:00 | SPY | ETF | 414.59 | 414.59 | 414.58 | 414.58 | 200.0 |
| 2022-03-15 04:50:00 | SPY | ETF | 414.68 | 414.68 | 414.34 | 414.34 | 500.0 |
| 2022-03-15 04:52:00 | SPY | ETF | 414.51 | 414.51 | 414.51 | 414.51 | 500.0 |
| 2022-03-15 04:53:00 | SPY | ETF | 414.49 | 414.49 | 414.49 | 414.49 | 200.0 |
| 2022-03-15 04:56:00 | SPY | ETF | 414.49 | 414.5 | 414.27 | 414.27 | 1200.0 |
| 2022-03-15 04:57:00 | SPY | ETF | 414.12 | 414.12 | 414.0 | 414.05 | 2300.0 |
| 2022-03-15 04:58:00 | SPY | ETF | 414.13 | 414.18 | 414.13 | 414.18 | 600.0 |
> showing 50 of 274,825 rows — these rows as CSV