PREVIEW / etf_1min / 2007-01-04
file: by_date/etf_1min/2007/2007-01-04.parquet size: 623 KB rows: 37,136
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 |
|---|---|---|---|---|---|---|---|
| 2007-01-04 06:57:00 | SPY | ETF | 141.09 | 141.09 | 141.09 | 141.09 | 1000.0 |
| 2007-01-04 07:06:00 | SPY | ETF | 141.06 | 141.06 | 141.06 | 141.06 | 1900.0 |
| 2007-01-04 07:07:00 | SPY | ETF | 141.04 | 141.04 | 141.04 | 141.04 | 2000.0 |
| 2007-01-04 07:08:00 | SPY | ETF | 141.06 | 141.06 | 141.06 | 141.06 | 500.0 |
| 2007-01-04 07:11:00 | SPY | ETF | 141.03 | 141.03 | 141.03 | 141.03 | 500.0 |
| 2007-01-04 07:13:00 | SPY | ETF | 141.07 | 141.07 | 141.07 | 141.07 | 900.0 |
| 2007-01-04 07:14:00 | SPY | ETF | 141.11 | 141.11 | 141.11 | 141.11 | 2500.0 |
| 2007-01-04 07:16:00 | SPY | ETF | 141.1 | 141.1 | 141.1 | 141.1 | 2000.0 |
| 2007-01-04 07:27:00 | SPY | ETF | 141.14 | 141.14 | 141.14 | 141.14 | 1000.0 |
| 2007-01-04 07:38:00 | SPY | ETF | 141.1 | 141.1 | 141.09 | 141.09 | 37300.0 |
| 2007-01-04 07:51:00 | SPY | ETF | 141.15 | 141.16 | 141.15 | 141.16 | 500.0 |
| 2007-01-04 07:52:00 | SPY | ETF | 141.14 | 141.14 | 141.13 | 141.13 | 6000.0 |
| 2007-01-04 07:57:00 | SPY | ETF | 141.14 | 141.14 | 141.14 | 141.14 | 75000.0 |
| 2007-01-04 07:58:00 | SPY | ETF | 141.14 | 141.15 | 141.14 | 141.15 | 41000.0 |
| 2007-01-04 08:00:00 | SPY | ETF | 141.17 | 141.17 | 141.17 | 141.17 | 400.0 |
| 2007-01-04 08:01:00 | SPY | ETF | 141.15 | 141.15 | 141.03 | 141.12 | 290700.0 |
| 2007-01-04 08:03:00 | SPY | ETF | 141.11 | 141.11 | 141.11 | 141.11 | 700.0 |
| 2007-01-04 08:04:00 | SPY | ETF | 141.09 | 141.09 | 141.09 | 141.09 | 9300.0 |
| 2007-01-04 08:07:00 | SPY | ETF | 141.13 | 141.13 | 141.13 | 141.13 | 1000.0 |
| 2007-01-04 08:08:00 | SPY | ETF | 141.09 | 141.09 | 141.09 | 141.09 | 10700.0 |
| 2007-01-04 08:09:00 | SPY | ETF | 141.09 | 141.09 | 141.09 | 141.09 | 9200.0 |
| 2007-01-04 08:10:00 | SPY | ETF | 141.12 | 141.12 | 141.12 | 141.12 | 2000.0 |
| 2007-01-04 08:11:00 | SPY | ETF | 141.12 | 141.12 | 141.12 | 141.12 | 3000.0 |
| 2007-01-04 08:13:00 | SPY | ETF | 141.12 | 141.16 | 141.12 | 141.16 | 700.0 |
| 2007-01-04 08:14:00 | SPY | ETF | 141.17 | 141.18 | 141.17 | 141.18 | 1200.0 |
| 2007-01-04 08:16:00 | SPY | ETF | 141.2 | 141.2 | 141.18 | 141.18 | 50100.0 |
| 2007-01-04 08:17:00 | SPY | ETF | 141.19 | 141.2 | 141.19 | 141.19 | 600.0 |
| 2007-01-04 08:18:00 | SPY | ETF | 141.18 | 141.18 | 141.15 | 141.16 | 12400.0 |
| 2007-01-04 08:22:00 | SPY | ETF | 141.18 | 141.18 | 141.18 | 141.18 | 200.0 |
| 2007-01-04 08:24:00 | SPY | ETF | 141.2 | 141.2 | 141.2 | 141.2 | 5500.0 |
| 2007-01-04 08:26:00 | SPY | ETF | 141.2 | 141.2 | 141.2 | 141.2 | 3000.0 |
| 2007-01-04 08:30:00 | SPY | ETF | 141.15 | 141.18 | 141.14 | 141.14 | 20000.0 |
| 2007-01-04 08:32:00 | SPY | ETF | 141.18 | 141.19 | 141.18 | 141.19 | 2200.0 |
| 2007-01-04 08:33:00 | SPY | ETF | 141.2 | 141.22 | 141.18 | 141.18 | 85200.0 |
| 2007-01-04 08:34:00 | SPY | ETF | 141.18 | 141.19 | 141.16 | 141.16 | 10200.0 |
| 2007-01-04 08:35:00 | SPY | ETF | 141.17 | 141.18 | 141.17 | 141.18 | 1200.0 |
| 2007-01-04 08:36:00 | SPY | ETF | 141.18 | 141.18 | 141.17 | 141.18 | 600.0 |
| 2007-01-04 08:39:00 | SPY | ETF | 141.18 | 141.18 | 141.18 | 141.18 | 45900.0 |
| 2007-01-04 08:40:00 | SPY | ETF | 141.19 | 141.2 | 141.19 | 141.2 | 1800.0 |
| 2007-01-04 08:42:00 | SPY | ETF | 141.2 | 141.2 | 141.2 | 141.2 | 8400.0 |
| 2007-01-04 08:44:00 | SPY | ETF | 141.2 | 141.2 | 141.2 | 141.2 | 6700.0 |
| 2007-01-04 08:48:00 | SPY | ETF | 141.2 | 141.24 | 141.2 | 141.24 | 7700.0 |
| 2007-01-04 08:49:00 | SPY | ETF | 141.24 | 141.27 | 141.23 | 141.27 | 41600.0 |
| 2007-01-04 08:50:00 | SPY | ETF | 141.26 | 141.26 | 141.26 | 141.26 | 2000.0 |
| 2007-01-04 08:52:00 | SPY | ETF | 141.25 | 141.25 | 141.22 | 141.22 | 4600.0 |
| 2007-01-04 08:53:00 | SPY | ETF | 141.22 | 141.22 | 141.2 | 141.2 | 9900.0 |
| 2007-01-04 08:54:00 | SPY | ETF | 141.23 | 141.23 | 141.21 | 141.21 | 4600.0 |
| 2007-01-04 08:55:00 | SPY | ETF | 141.18 | 141.18 | 141.15 | 141.18 | 18600.0 |
| 2007-01-04 08:57:00 | SPY | ETF | 141.17 | 141.2 | 141.17 | 141.2 | 63600.0 |
| 2007-01-04 08:59:00 | SPY | ETF | 141.19 | 141.21 | 141.19 | 141.21 | 11500.0 |
> showing 50 of 37,136 rows — these rows as CSV