PREVIEW / etf_1min / 2021-12-29
file: by_date/etf_1min/2021/2021-12-29.parquet size: 4.2 MB rows: 239,404
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 |
|---|---|---|---|---|---|---|---|
| 2021-12-29 04:02:00 | SPY | ETF | 477.9 | 477.9 | 477.9 | 477.9 | 100.0 |
| 2021-12-29 04:03:00 | SPY | ETF | 477.9 | 477.9 | 477.9 | 477.9 | 200.0 |
| 2021-12-29 04:04:00 | SPY | ETF | 477.93 | 477.93 | 477.93 | 477.93 | 100.0 |
| 2021-12-29 04:05:00 | SPY | ETF | 477.92 | 477.92 | 477.88 | 477.88 | 622.0 |
| 2021-12-29 04:07:00 | SPY | ETF | 477.77 | 477.77 | 477.77 | 477.77 | 287.0 |
| 2021-12-29 04:08:00 | SPY | ETF | 477.74 | 477.74 | 477.67 | 477.67 | 330.0 |
| 2021-12-29 04:09:00 | SPY | ETF | 477.68 | 477.7 | 477.68 | 477.7 | 200.0 |
| 2021-12-29 04:10:00 | SPY | ETF | 477.7 | 477.7 | 477.7 | 477.7 | 100.0 |
| 2021-12-29 04:11:00 | SPY | ETF | 477.73 | 477.79 | 477.72 | 477.79 | 503.0 |
| 2021-12-29 04:14:00 | SPY | ETF | 477.7 | 477.7 | 477.7 | 477.7 | 200.0 |
| 2021-12-29 04:15:00 | SPY | ETF | 477.64 | 477.66 | 477.64 | 477.66 | 204.0 |
| 2021-12-29 04:16:00 | SPY | ETF | 477.67 | 477.71 | 477.67 | 477.71 | 1153.0 |
| 2021-12-29 04:19:00 | SPY | ETF | 477.66 | 477.66 | 477.66 | 477.66 | 100.0 |
| 2021-12-29 04:20:00 | SPY | ETF | 477.65 | 477.65 | 477.6 | 477.62 | 727.0 |
| 2021-12-29 04:21:00 | SPY | ETF | 477.62 | 477.62 | 477.62 | 477.62 | 505.0 |
| 2021-12-29 04:25:00 | SPY | ETF | 477.63 | 477.63 | 477.63 | 477.63 | 100.0 |
| 2021-12-29 04:26:00 | SPY | ETF | 477.76 | 477.76 | 477.76 | 477.76 | 100.0 |
| 2021-12-29 04:27:00 | SPY | ETF | 477.75 | 477.75 | 477.75 | 477.75 | 240.0 |
| 2021-12-29 04:28:00 | SPY | ETF | 477.72 | 477.75 | 477.72 | 477.75 | 2100.0 |
| 2021-12-29 04:29:00 | SPY | ETF | 477.75 | 477.75 | 477.75 | 477.75 | 100.0 |
| 2021-12-29 04:30:00 | SPY | ETF | 477.83 | 477.84 | 477.83 | 477.84 | 574.0 |
| 2021-12-29 04:31:00 | SPY | ETF | 477.8 | 477.82 | 477.8 | 477.82 | 386.0 |
| 2021-12-29 04:40:00 | SPY | ETF | 477.83 | 477.83 | 477.83 | 477.83 | 192.0 |
| 2021-12-29 04:44:00 | SPY | ETF | 477.83 | 477.83 | 477.83 | 477.83 | 100.0 |
| 2021-12-29 04:46:00 | SPY | ETF | 477.8 | 477.8 | 477.8 | 477.8 | 100.0 |
| 2021-12-29 04:47:00 | SPY | ETF | 477.83 | 477.83 | 477.83 | 477.83 | 102.0 |
| 2021-12-29 04:49:00 | SPY | ETF | 477.8 | 477.8 | 477.8 | 477.8 | 100.0 |
| 2021-12-29 04:50:00 | SPY | ETF | 477.83 | 477.83 | 477.83 | 477.83 | 342.0 |
| 2021-12-29 04:57:00 | SPY | ETF | 477.82 | 477.82 | 477.82 | 477.82 | 120.0 |
| 2021-12-29 05:00:00 | SPY | ETF | 477.89 | 477.89 | 477.89 | 477.89 | 594.0 |
| 2021-12-29 05:01:00 | SPY | ETF | 477.89 | 477.93 | 477.89 | 477.93 | 620.0 |
| 2021-12-29 05:04:00 | SPY | ETF | 477.96 | 477.96 | 477.96 | 477.96 | 200.0 |
| 2021-12-29 05:05:00 | SPY | ETF | 477.88 | 477.88 | 477.88 | 477.88 | 147.0 |
| 2021-12-29 05:07:00 | SPY | ETF | 477.94 | 477.94 | 477.94 | 477.94 | 110.0 |
| 2021-12-29 05:08:00 | SPY | ETF | 477.88 | 477.88 | 477.88 | 477.88 | 150.0 |
| 2021-12-29 05:09:00 | SPY | ETF | 477.88 | 477.88 | 477.88 | 477.88 | 100.0 |
| 2021-12-29 05:10:00 | SPY | ETF | 477.84 | 477.84 | 477.84 | 477.84 | 235.0 |
| 2021-12-29 05:11:00 | SPY | ETF | 477.81 | 477.81 | 477.81 | 477.81 | 237.0 |
| 2021-12-29 05:14:00 | SPY | ETF | 477.78 | 477.78 | 477.78 | 477.78 | 100.0 |
| 2021-12-29 05:16:00 | SPY | ETF | 477.78 | 477.78 | 477.78 | 477.78 | 318.0 |
| 2021-12-29 05:18:00 | SPY | ETF | 477.78 | 477.78 | 477.78 | 477.78 | 111.0 |
| 2021-12-29 05:24:00 | SPY | ETF | 477.7 | 477.72 | 477.62 | 477.62 | 2300.0 |
| 2021-12-29 05:26:00 | SPY | ETF | 477.75 | 477.75 | 477.75 | 477.75 | 100.0 |
| 2021-12-29 05:30:00 | SPY | ETF | 477.75 | 477.75 | 477.74 | 477.74 | 496.0 |
| 2021-12-29 05:31:00 | SPY | ETF | 477.71 | 477.76 | 477.71 | 477.76 | 355.0 |
| 2021-12-29 05:37:00 | SPY | ETF | 477.62 | 477.62 | 477.62 | 477.62 | 497.0 |
| 2021-12-29 05:40:00 | SPY | ETF | 477.69 | 477.69 | 477.69 | 477.69 | 206.0 |
| 2021-12-29 05:41:00 | SPY | ETF | 477.74 | 477.74 | 477.73 | 477.73 | 420.0 |
| 2021-12-29 05:48:00 | SPY | ETF | 477.76 | 477.76 | 477.76 | 477.76 | 500.0 |
| 2021-12-29 05:50:00 | SPY | ETF | 477.76 | 477.76 | 477.76 | 477.76 | 100.0 |
> showing 50 of 239,404 rows — these rows as CSV