PREVIEW / etf_1min / 2021-08-06
file: by_date/etf_1min/2021/2021-08-06.parquet size: 3.5 MB rows: 202,277
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-08-06 04:05:00 | SPY | ETF | 441.41 | 441.41 | 441.41 | 441.41 | 1200.0 |
| 2021-08-06 04:12:00 | SPY | ETF | 441.4 | 441.4 | 441.4 | 441.4 | 1350.0 |
| 2021-08-06 04:15:00 | SPY | ETF | 441.45 | 441.45 | 441.45 | 441.45 | 790.0 |
| 2021-08-06 04:17:00 | SPY | ETF | 441.47 | 441.47 | 441.47 | 441.47 | 124.0 |
| 2021-08-06 04:18:00 | SPY | ETF | 441.42 | 441.43 | 441.42 | 441.43 | 300.0 |
| 2021-08-06 04:20:00 | SPY | ETF | 441.43 | 441.43 | 441.43 | 441.43 | 400.0 |
| 2021-08-06 04:25:00 | SPY | ETF | 441.5 | 441.51 | 441.5 | 441.51 | 288.0 |
| 2021-08-06 04:30:00 | SPY | ETF | 441.56 | 441.56 | 441.56 | 441.56 | 123.0 |
| 2021-08-06 04:35:00 | SPY | ETF | 441.54 | 441.54 | 441.54 | 441.54 | 600.0 |
| 2021-08-06 04:37:00 | SPY | ETF | 441.61 | 441.61 | 441.61 | 441.61 | 650.0 |
| 2021-08-06 04:40:00 | SPY | ETF | 441.65 | 441.65 | 441.65 | 441.65 | 800.0 |
| 2021-08-06 04:55:00 | SPY | ETF | 441.82 | 441.82 | 441.82 | 441.82 | 100.0 |
| 2021-08-06 04:57:00 | SPY | ETF | 441.9 | 441.9 | 441.9 | 441.9 | 100.0 |
| 2021-08-06 04:58:00 | SPY | ETF | 441.93 | 441.93 | 441.92 | 441.92 | 1400.0 |
| 2021-08-06 04:59:00 | SPY | ETF | 441.88 | 441.88 | 441.88 | 441.88 | 100.0 |
| 2021-08-06 05:08:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 100.0 |
| 2021-08-06 05:10:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 200.0 |
| 2021-08-06 05:23:00 | SPY | ETF | 441.87 | 441.87 | 441.87 | 441.87 | 900.0 |
| 2021-08-06 05:24:00 | SPY | ETF | 441.87 | 441.9 | 441.87 | 441.9 | 2382.0 |
| 2021-08-06 05:25:00 | SPY | ETF | 441.86 | 441.86 | 441.86 | 441.86 | 500.0 |
| 2021-08-06 05:28:00 | SPY | ETF | 441.81 | 441.81 | 441.81 | 441.81 | 500.0 |
| 2021-08-06 05:34:00 | SPY | ETF | 441.84 | 441.84 | 441.84 | 441.84 | 600.0 |
| 2021-08-06 05:45:00 | SPY | ETF | 441.86 | 441.86 | 441.86 | 441.86 | 100.0 |
| 2021-08-06 05:48:00 | SPY | ETF | 441.89 | 441.89 | 441.89 | 441.89 | 400.0 |
| 2021-08-06 06:04:00 | SPY | ETF | 441.87 | 441.87 | 441.87 | 441.87 | 474.0 |
| 2021-08-06 06:07:00 | SPY | ETF | 441.83 | 441.83 | 441.83 | 441.83 | 600.0 |
| 2021-08-06 06:09:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 12100.0 |
| 2021-08-06 06:10:00 | SPY | ETF | 441.85 | 441.85 | 441.85 | 441.85 | 200.0 |
| 2021-08-06 06:11:00 | SPY | ETF | 441.9 | 441.91 | 441.9 | 441.91 | 2115.0 |
| 2021-08-06 06:12:00 | SPY | ETF | 441.91 | 441.93 | 441.91 | 441.91 | 800.0 |
| 2021-08-06 06:14:00 | SPY | ETF | 441.96 | 442.0 | 441.96 | 442.0 | 1305.0 |
| 2021-08-06 06:19:00 | SPY | ETF | 441.98 | 441.98 | 441.97 | 441.97 | 690.0 |
| 2021-08-06 06:22:00 | SPY | ETF | 441.95 | 441.95 | 441.95 | 441.95 | 1500.0 |
| 2021-08-06 06:24:00 | SPY | ETF | 442.0 | 442.03 | 442.0 | 442.03 | 1600.0 |
| 2021-08-06 06:26:00 | SPY | ETF | 442.07 | 442.07 | 442.01 | 442.01 | 200.0 |
| 2021-08-06 06:27:00 | SPY | ETF | 442.02 | 442.02 | 442.02 | 442.02 | 300.0 |
| 2021-08-06 06:29:00 | SPY | ETF | 442.0 | 442.0 | 442.0 | 442.0 | 1791.0 |
| 2021-08-06 06:30:00 | SPY | ETF | 442.0 | 442.0 | 442.0 | 442.0 | 4918.0 |
| 2021-08-06 06:31:00 | SPY | ETF | 441.98 | 441.98 | 441.98 | 441.98 | 100.0 |
| 2021-08-06 06:41:00 | SPY | ETF | 441.94 | 441.94 | 441.94 | 441.94 | 100.0 |
| 2021-08-06 06:42:00 | SPY | ETF | 441.96 | 441.96 | 441.96 | 441.96 | 100.0 |
| 2021-08-06 06:46:00 | SPY | ETF | 441.95 | 441.95 | 441.95 | 441.95 | 2900.0 |
| 2021-08-06 06:52:00 | SPY | ETF | 441.92 | 441.92 | 441.92 | 441.92 | 2898.0 |
| 2021-08-06 06:56:00 | SPY | ETF | 441.93 | 441.93 | 441.93 | 441.93 | 374.0 |
| 2021-08-06 06:57:00 | SPY | ETF | 441.91 | 441.91 | 441.9 | 441.9 | 1996.0 |
| 2021-08-06 06:59:00 | SPY | ETF | 441.93 | 441.93 | 441.93 | 441.93 | 500.0 |
| 2021-08-06 07:00:00 | SPY | ETF | 441.94 | 441.94 | 441.93 | 441.94 | 725.0 |
| 2021-08-06 07:01:00 | SPY | ETF | 441.96 | 441.97 | 441.96 | 441.97 | 2000.0 |
| 2021-08-06 07:02:00 | SPY | ETF | 441.97 | 442.0 | 441.97 | 442.0 | 200.0 |
| 2021-08-06 07:03:00 | SPY | ETF | 441.97 | 441.97 | 441.97 | 441.97 | 250.0 |
> showing 50 of 202,277 rows — these rows as CSV