PREVIEW / etf_1min / 2021-10-13
file: by_date/etf_1min/2021/2021-10-13.parquet size: 3.8 MB rows: 220,816
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-10-13 04:00:00 | SPY | ETF | 433.52 | 433.68 | 433.52 | 433.68 | 1500.0 |
| 2021-10-13 04:01:00 | SPY | ETF | 433.72 | 433.74 | 433.72 | 433.74 | 5296.0 |
| 2021-10-13 04:02:00 | SPY | ETF | 433.75 | 433.75 | 433.75 | 433.75 | 100.0 |
| 2021-10-13 04:03:00 | SPY | ETF | 433.65 | 433.65 | 433.65 | 433.65 | 1000.0 |
| 2021-10-13 04:05:00 | SPY | ETF | 433.62 | 433.62 | 433.62 | 433.62 | 200.0 |
| 2021-10-13 04:12:00 | SPY | ETF | 433.68 | 433.68 | 433.68 | 433.68 | 200.0 |
| 2021-10-13 04:16:00 | SPY | ETF | 433.6 | 433.61 | 433.6 | 433.61 | 250.0 |
| 2021-10-13 04:17:00 | SPY | ETF | 433.55 | 433.55 | 433.55 | 433.55 | 199.0 |
| 2021-10-13 04:19:00 | SPY | ETF | 433.86 | 434.16 | 433.86 | 434.14 | 2599.0 |
| 2021-10-13 04:20:00 | SPY | ETF | 434.11 | 434.11 | 434.03 | 434.03 | 200.0 |
| 2021-10-13 04:21:00 | SPY | ETF | 434.03 | 434.03 | 434.01 | 434.02 | 600.0 |
| 2021-10-13 04:22:00 | SPY | ETF | 434.12 | 434.12 | 434.12 | 434.12 | 100.0 |
| 2021-10-13 04:23:00 | SPY | ETF | 434.2 | 434.25 | 434.2 | 434.25 | 1700.0 |
| 2021-10-13 04:26:00 | SPY | ETF | 434.36 | 434.36 | 434.36 | 434.36 | 100.0 |
| 2021-10-13 04:28:00 | SPY | ETF | 434.26 | 434.26 | 434.26 | 434.26 | 1000.0 |
| 2021-10-13 04:30:00 | SPY | ETF | 434.25 | 434.25 | 434.25 | 434.25 | 425.0 |
| 2021-10-13 04:32:00 | SPY | ETF | 434.2 | 434.21 | 434.2 | 434.2 | 1000.0 |
| 2021-10-13 04:33:00 | SPY | ETF | 434.26 | 434.26 | 434.21 | 434.21 | 216.0 |
| 2021-10-13 04:43:00 | SPY | ETF | 434.25 | 434.41 | 434.25 | 434.41 | 2300.0 |
| 2021-10-13 04:44:00 | SPY | ETF | 434.43 | 434.58 | 434.39 | 434.58 | 1000.0 |
| 2021-10-13 04:45:00 | SPY | ETF | 434.51 | 434.56 | 434.51 | 434.56 | 200.0 |
| 2021-10-13 04:47:00 | SPY | ETF | 434.65 | 434.76 | 434.64 | 434.76 | 2200.0 |
| 2021-10-13 04:48:00 | SPY | ETF | 434.76 | 434.79 | 434.75 | 434.79 | 822.0 |
| 2021-10-13 04:49:00 | SPY | ETF | 434.76 | 434.77 | 434.76 | 434.77 | 227.0 |
| 2021-10-13 04:50:00 | SPY | ETF | 434.88 | 434.99 | 434.88 | 434.99 | 403.0 |
| 2021-10-13 04:52:00 | SPY | ETF | 434.89 | 434.92 | 434.87 | 434.92 | 6450.0 |
| 2021-10-13 04:54:00 | SPY | ETF | 434.75 | 434.75 | 434.75 | 434.75 | 500.0 |
| 2021-10-13 04:55:00 | SPY | ETF | 434.75 | 434.77 | 434.75 | 434.77 | 1170.0 |
| 2021-10-13 04:57:00 | SPY | ETF | 434.62 | 434.62 | 434.62 | 434.62 | 100.0 |
| 2021-10-13 05:01:00 | SPY | ETF | 434.55 | 434.55 | 434.55 | 434.55 | 100.0 |
| 2021-10-13 05:03:00 | SPY | ETF | 434.53 | 434.55 | 434.52 | 434.55 | 1800.0 |
| 2021-10-13 05:04:00 | SPY | ETF | 434.45 | 434.45 | 434.45 | 434.45 | 200.0 |
| 2021-10-13 05:05:00 | SPY | ETF | 434.4 | 434.4 | 434.4 | 434.4 | 200.0 |
| 2021-10-13 05:06:00 | SPY | ETF | 434.48 | 434.48 | 434.48 | 434.48 | 200.0 |
| 2021-10-13 05:07:00 | SPY | ETF | 434.41 | 434.41 | 434.41 | 434.41 | 100.0 |
| 2021-10-13 05:08:00 | SPY | ETF | 434.36 | 434.36 | 434.36 | 434.36 | 200.0 |
| 2021-10-13 05:11:00 | SPY | ETF | 434.38 | 434.38 | 434.38 | 434.38 | 100.0 |
| 2021-10-13 05:12:00 | SPY | ETF | 434.45 | 434.48 | 434.45 | 434.48 | 301.0 |
| 2021-10-13 05:13:00 | SPY | ETF | 434.45 | 434.45 | 434.45 | 434.45 | 100.0 |
| 2021-10-13 05:14:00 | SPY | ETF | 434.57 | 434.57 | 434.55 | 434.55 | 1100.0 |
| 2021-10-13 05:15:00 | SPY | ETF | 434.59 | 434.59 | 434.57 | 434.57 | 200.0 |
| 2021-10-13 05:16:00 | SPY | ETF | 434.59 | 434.59 | 434.59 | 434.59 | 145.0 |
| 2021-10-13 05:17:00 | SPY | ETF | 434.59 | 434.59 | 434.59 | 434.59 | 100.0 |
| 2021-10-13 05:18:00 | SPY | ETF | 434.59 | 434.59 | 434.59 | 434.59 | 500.0 |
| 2021-10-13 05:22:00 | SPY | ETF | 434.6 | 434.6 | 434.6 | 434.6 | 200.0 |
| 2021-10-13 05:27:00 | SPY | ETF | 434.47 | 434.47 | 434.45 | 434.45 | 12999.0 |
| 2021-10-13 05:31:00 | SPY | ETF | 434.63 | 434.63 | 434.63 | 434.63 | 300.0 |
| 2021-10-13 05:34:00 | SPY | ETF | 434.63 | 434.64 | 434.63 | 434.64 | 2250.0 |
| 2021-10-13 05:36:00 | SPY | ETF | 434.67 | 434.67 | 434.67 | 434.67 | 100.0 |
| 2021-10-13 05:40:00 | SPY | ETF | 434.7 | 434.7 | 434.7 | 434.7 | 200.0 |
> showing 50 of 220,816 rows — these rows as CSV