PREVIEW / etf_1min / 2022-08-15
file: by_date/etf_1min/2022/2022-08-15.parquet size: 4.3 MB rows: 243,707
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-08-15 04:00:00 | SPY | ETF | 425.0 | 425.59 | 424.96 | 425.0 | 14453.0 |
| 2022-08-15 04:01:00 | SPY | ETF | 425.04 | 425.05 | 425.04 | 425.05 | 400.0 |
| 2022-08-15 04:02:00 | SPY | ETF | 425.06 | 425.08 | 425.02 | 425.07 | 3023.0 |
| 2022-08-15 04:03:00 | SPY | ETF | 425.08 | 425.1 | 425.02 | 425.1 | 1292.0 |
| 2022-08-15 04:04:00 | SPY | ETF | 425.1 | 425.14 | 425.1 | 425.14 | 1455.0 |
| 2022-08-15 04:05:00 | SPY | ETF | 425.17 | 425.31 | 425.17 | 425.31 | 917.0 |
| 2022-08-15 04:06:00 | SPY | ETF | 425.31 | 425.37 | 425.31 | 425.37 | 443.0 |
| 2022-08-15 04:07:00 | SPY | ETF | 425.42 | 425.42 | 425.38 | 425.38 | 4100.0 |
| 2022-08-15 04:08:00 | SPY | ETF | 425.37 | 425.37 | 425.35 | 425.37 | 600.0 |
| 2022-08-15 04:09:00 | SPY | ETF | 425.32 | 425.32 | 425.32 | 425.32 | 184.0 |
| 2022-08-15 04:10:00 | SPY | ETF | 425.32 | 425.32 | 425.32 | 425.32 | 300.0 |
| 2022-08-15 04:12:00 | SPY | ETF | 425.3 | 425.32 | 425.24 | 425.24 | 2900.0 |
| 2022-08-15 04:13:00 | SPY | ETF | 425.18 | 425.18 | 425.18 | 425.18 | 400.0 |
| 2022-08-15 04:15:00 | SPY | ETF | 425.17 | 425.17 | 425.17 | 425.17 | 200.0 |
| 2022-08-15 04:16:00 | SPY | ETF | 425.17 | 425.17 | 425.17 | 425.17 | 100.0 |
| 2022-08-15 04:18:00 | SPY | ETF | 425.16 | 425.16 | 425.15 | 425.15 | 500.0 |
| 2022-08-15 04:19:00 | SPY | ETF | 425.11 | 425.11 | 425.11 | 425.11 | 150.0 |
| 2022-08-15 04:21:00 | SPY | ETF | 425.14 | 425.19 | 425.14 | 425.19 | 1400.0 |
| 2022-08-15 04:24:00 | SPY | ETF | 425.17 | 425.17 | 425.1 | 425.11 | 700.0 |
| 2022-08-15 04:25:00 | SPY | ETF | 425.07 | 425.21 | 425.07 | 425.21 | 1200.0 |
| 2022-08-15 04:29:00 | SPY | ETF | 425.28 | 425.28 | 425.28 | 425.28 | 100.0 |
| 2022-08-15 04:30:00 | SPY | ETF | 425.34 | 425.34 | 425.34 | 425.34 | 180.0 |
| 2022-08-15 04:31:00 | SPY | ETF | 425.31 | 425.31 | 425.3 | 425.3 | 200.0 |
| 2022-08-15 04:32:00 | SPY | ETF | 425.34 | 425.34 | 425.34 | 425.34 | 100.0 |
| 2022-08-15 04:33:00 | SPY | ETF | 425.4 | 425.4 | 425.38 | 425.38 | 221.0 |
| 2022-08-15 04:34:00 | SPY | ETF | 425.4 | 425.4 | 425.35 | 425.35 | 284.0 |
| 2022-08-15 04:36:00 | SPY | ETF | 425.35 | 425.35 | 425.35 | 425.35 | 800.0 |
| 2022-08-15 04:37:00 | SPY | ETF | 425.36 | 425.36 | 425.36 | 425.36 | 103.0 |
| 2022-08-15 04:39:00 | SPY | ETF | 425.32 | 425.36 | 425.32 | 425.36 | 410.0 |
| 2022-08-15 04:40:00 | SPY | ETF | 425.46 | 425.55 | 425.46 | 425.55 | 1587.0 |
| 2022-08-15 04:41:00 | SPY | ETF | 425.5 | 425.5 | 425.49 | 425.49 | 800.0 |
| 2022-08-15 04:43:00 | SPY | ETF | 425.45 | 425.45 | 425.45 | 425.45 | 262.0 |
| 2022-08-15 04:53:00 | SPY | ETF | 425.2 | 425.2 | 425.2 | 425.2 | 186.0 |
| 2022-08-15 04:56:00 | SPY | ETF | 425.15 | 425.15 | 425.15 | 425.15 | 300.0 |
| 2022-08-15 04:58:00 | SPY | ETF | 425.13 | 425.14 | 425.13 | 425.13 | 1000.0 |
| 2022-08-15 04:59:00 | SPY | ETF | 425.13 | 425.13 | 425.13 | 425.13 | 500.0 |
| 2022-08-15 05:00:00 | SPY | ETF | 425.1 | 425.1 | 425.1 | 425.1 | 200.0 |
| 2022-08-15 05:01:00 | SPY | ETF | 425.07 | 425.07 | 425.07 | 425.07 | 400.0 |
| 2022-08-15 05:02:00 | SPY | ETF | 425.1 | 425.1 | 425.08 | 425.08 | 1000.0 |
| 2022-08-15 05:06:00 | SPY | ETF | 425.05 | 425.05 | 425.05 | 425.05 | 100.0 |
| 2022-08-15 05:07:00 | SPY | ETF | 425.04 | 425.04 | 425.04 | 425.04 | 2100.0 |
| 2022-08-15 05:08:00 | SPY | ETF | 425.04 | 425.04 | 425.04 | 425.04 | 265.0 |
| 2022-08-15 05:10:00 | SPY | ETF | 425.07 | 425.07 | 425.07 | 425.07 | 299.0 |
| 2022-08-15 05:13:00 | SPY | ETF | 425.07 | 425.11 | 425.07 | 425.11 | 600.0 |
| 2022-08-15 05:14:00 | SPY | ETF | 425.1 | 425.15 | 425.1 | 425.15 | 1297.0 |
| 2022-08-15 05:15:00 | SPY | ETF | 425.18 | 425.21 | 425.18 | 425.21 | 1098.0 |
| 2022-08-15 05:16:00 | SPY | ETF | 425.16 | 425.16 | 425.0 | 425.0 | 5252.0 |
| 2022-08-15 05:17:00 | SPY | ETF | 424.98 | 425.1 | 424.98 | 425.09 | 4598.0 |
| 2022-08-15 05:18:00 | SPY | ETF | 424.95 | 424.95 | 424.95 | 424.95 | 500.0 |
| 2022-08-15 05:19:00 | SPY | ETF | 424.97 | 424.97 | 424.96 | 424.96 | 875.0 |
> showing 50 of 243,707 rows — these rows as CSV