PREVIEW / etf_1min / 2023-12-01
file: by_date/etf_1min/2023/2023-12-01.parquet size: 5.2 MB rows: 292,742
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 |
|---|---|---|---|---|---|---|---|
| 2023-12-01 04:00:00 | SPY | ETF | 456.2 | 457.1 | 456.2 | 457.08 | 768.0 |
| 2023-12-01 04:01:00 | SPY | ETF | 457.11 | 457.15 | 457.09 | 457.09 | 400.0 |
| 2023-12-01 04:04:00 | SPY | ETF | 457.21 | 457.21 | 457.15 | 457.15 | 943.0 |
| 2023-12-01 04:05:00 | SPY | ETF | 457.16 | 457.16 | 457.13 | 457.15 | 1950.0 |
| 2023-12-01 04:06:00 | SPY | ETF | 457.11 | 457.11 | 457.08 | 457.08 | 6300.0 |
| 2023-12-01 04:07:00 | SPY | ETF | 457.12 | 457.12 | 457.11 | 457.11 | 1000.0 |
| 2023-12-01 04:08:00 | SPY | ETF | 457.14 | 457.14 | 457.14 | 457.14 | 100.0 |
| 2023-12-01 04:09:00 | SPY | ETF | 457.09 | 457.18 | 457.09 | 457.18 | 500.0 |
| 2023-12-01 04:11:00 | SPY | ETF | 457.2 | 457.21 | 457.13 | 457.13 | 23687.0 |
| 2023-12-01 04:12:00 | SPY | ETF | 457.13 | 457.13 | 457.09 | 457.09 | 2678.0 |
| 2023-12-01 04:13:00 | SPY | ETF | 457.11 | 457.11 | 457.08 | 457.08 | 4234.0 |
| 2023-12-01 04:15:00 | SPY | ETF | 457.09 | 457.09 | 457.09 | 457.09 | 733.0 |
| 2023-12-01 04:21:00 | SPY | ETF | 457.2 | 457.2 | 457.2 | 457.2 | 100.0 |
| 2023-12-01 04:23:00 | SPY | ETF | 457.22 | 457.22 | 457.21 | 457.22 | 2905.0 |
| 2023-12-01 04:24:00 | SPY | ETF | 457.19 | 457.19 | 457.19 | 457.19 | 500.0 |
| 2023-12-01 04:26:00 | SPY | ETF | 457.13 | 457.13 | 457.13 | 457.13 | 1200.0 |
| 2023-12-01 04:31:00 | SPY | ETF | 457.24 | 457.24 | 457.24 | 457.24 | 133.0 |
| 2023-12-01 04:40:00 | SPY | ETF | 457.27 | 457.27 | 457.27 | 457.27 | 100.0 |
| 2023-12-01 04:41:00 | SPY | ETF | 457.28 | 457.28 | 457.28 | 457.28 | 100.0 |
| 2023-12-01 04:44:00 | SPY | ETF | 457.27 | 457.27 | 457.27 | 457.27 | 100.0 |
| 2023-12-01 04:47:00 | SPY | ETF | 457.21 | 457.25 | 457.21 | 457.25 | 592.0 |
| 2023-12-01 04:49:00 | SPY | ETF | 457.23 | 457.23 | 457.23 | 457.23 | 798.0 |
| 2023-12-01 04:50:00 | SPY | ETF | 457.24 | 457.24 | 457.23 | 457.23 | 550.0 |
| 2023-12-01 04:51:00 | SPY | ETF | 457.21 | 457.25 | 457.21 | 457.25 | 300.0 |
| 2023-12-01 04:52:00 | SPY | ETF | 457.15 | 457.15 | 457.15 | 457.15 | 200.0 |
| 2023-12-01 04:54:00 | SPY | ETF | 457.13 | 457.13 | 457.13 | 457.13 | 100.0 |
| 2023-12-01 04:59:00 | SPY | ETF | 457.05 | 457.05 | 457.05 | 457.05 | 100.0 |
| 2023-12-01 05:00:00 | SPY | ETF | 457.03 | 457.03 | 457.03 | 457.03 | 1126.0 |
| 2023-12-01 05:01:00 | SPY | ETF | 457.0 | 457.0 | 456.99 | 456.99 | 1297.0 |
| 2023-12-01 05:21:00 | SPY | ETF | 456.94 | 456.94 | 456.94 | 456.94 | 118.0 |
| 2023-12-01 05:23:00 | SPY | ETF | 456.94 | 456.94 | 456.94 | 456.94 | 200.0 |
| 2023-12-01 05:30:00 | SPY | ETF | 456.93 | 456.93 | 456.93 | 456.93 | 100.0 |
| 2023-12-01 05:35:00 | SPY | ETF | 456.88 | 456.88 | 456.88 | 456.88 | 100.0 |
| 2023-12-01 05:38:00 | SPY | ETF | 456.87 | 456.87 | 456.87 | 456.87 | 111.0 |
| 2023-12-01 05:40:00 | SPY | ETF | 456.75 | 456.75 | 456.75 | 456.75 | 100.0 |
| 2023-12-01 05:41:00 | SPY | ETF | 456.7 | 456.7 | 456.7 | 456.7 | 120.0 |
| 2023-12-01 05:48:00 | SPY | ETF | 456.7 | 456.7 | 456.7 | 456.7 | 100.0 |
| 2023-12-01 05:49:00 | SPY | ETF | 456.8 | 456.8 | 456.8 | 456.8 | 153.0 |
| 2023-12-01 05:50:00 | SPY | ETF | 456.79 | 456.79 | 456.79 | 456.79 | 650.0 |
| 2023-12-01 05:52:00 | SPY | ETF | 456.7 | 456.7 | 456.68 | 456.68 | 1330.0 |
| 2023-12-01 05:54:00 | SPY | ETF | 456.7 | 456.7 | 456.7 | 456.7 | 1220.0 |
| 2023-12-01 05:56:00 | SPY | ETF | 456.65 | 456.65 | 456.65 | 456.65 | 100.0 |
| 2023-12-01 05:58:00 | SPY | ETF | 456.66 | 456.7 | 456.66 | 456.7 | 5500.0 |
| 2023-12-01 05:59:00 | SPY | ETF | 456.65 | 456.65 | 456.65 | 456.65 | 7100.0 |
| 2023-12-01 06:00:00 | SPY | ETF | 456.64 | 456.64 | 456.62 | 456.62 | 8100.0 |
| 2023-12-01 06:01:00 | SPY | ETF | 456.66 | 456.69 | 456.66 | 456.69 | 500.0 |
| 2023-12-01 06:05:00 | SPY | ETF | 456.67 | 456.67 | 456.67 | 456.67 | 750.0 |
| 2023-12-01 06:09:00 | SPY | ETF | 456.55 | 456.56 | 456.55 | 456.56 | 4100.0 |
| 2023-12-01 06:11:00 | SPY | ETF | 456.53 | 456.54 | 456.53 | 456.54 | 3193.0 |
| 2023-12-01 06:12:00 | SPY | ETF | 456.56 | 456.56 | 456.56 | 456.56 | 6625.0 |
> showing 50 of 292,742 rows — these rows as CSV