PREVIEW / etf_1min / 2006-03-03
file: by_date/etf_1min/2006/2006-03-03.parquet size: 362 KB rows: 23,711
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-03 06:04:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 6500.0 |
| 2006-03-03 06:05:00 | SPY | ETF | 129.39 | 129.39 | 129.39 | 129.39 | 13000.0 |
| 2006-03-03 06:10:00 | SPY | ETF | 129.38 | 129.38 | 129.38 | 129.38 | 5500.0 |
| 2006-03-03 06:41:00 | SPY | ETF | 129.36 | 129.36 | 129.36 | 129.36 | 2000.0 |
| 2006-03-03 07:02:00 | SPY | ETF | 129.36 | 129.37 | 129.36 | 129.37 | 2300.0 |
| 2006-03-03 07:07:00 | SPY | ETF | 129.3 | 129.3 | 129.3 | 129.3 | 600.0 |
| 2006-03-03 07:20:00 | SPY | ETF | 129.28 | 129.28 | 129.28 | 129.28 | 1000.0 |
| 2006-03-03 07:28:00 | SPY | ETF | 129.27 | 129.27 | 129.27 | 129.27 | 2500.0 |
| 2006-03-03 07:53:00 | SPY | ETF | 129.3 | 129.3 | 129.3 | 129.3 | 1000.0 |
| 2006-03-03 08:01:00 | SPY | ETF | 129.25 | 129.36 | 129.22 | 129.22 | 43400.0 |
| 2006-03-03 08:02:00 | SPY | ETF | 129.23 | 129.23 | 129.23 | 129.23 | 100.0 |
| 2006-03-03 08:07:00 | SPY | ETF | 129.22 | 129.22 | 129.2 | 129.2 | 600.0 |
| 2006-03-03 08:08:00 | SPY | ETF | 129.2 | 129.2 | 129.2 | 129.2 | 1500.0 |
| 2006-03-03 08:09:00 | SPY | ETF | 129.18 | 129.19 | 129.14 | 129.15 | 30400.0 |
| 2006-03-03 08:10:00 | SPY | ETF | 129.15 | 129.17 | 129.15 | 129.17 | 5400.0 |
| 2006-03-03 08:11:00 | SPY | ETF | 129.15 | 129.15 | 129.14 | 129.14 | 195500.0 |
| 2006-03-03 08:13:00 | SPY | ETF | 129.18 | 129.18 | 129.17 | 129.18 | 15500.0 |
| 2006-03-03 08:14:00 | SPY | ETF | 129.17 | 129.17 | 129.16 | 129.16 | 9500.0 |
| 2006-03-03 08:15:00 | SPY | ETF | 129.16 | 129.16 | 129.15 | 129.15 | 5000.0 |
| 2006-03-03 08:17:00 | SPY | ETF | 129.13 | 129.13 | 129.13 | 129.13 | 1000.0 |
| 2006-03-03 08:19:00 | SPY | ETF | 129.13 | 129.15 | 129.13 | 129.15 | 200.0 |
| 2006-03-03 08:20:00 | SPY | ETF | 129.18 | 129.18 | 129.18 | 129.18 | 1100.0 |
| 2006-03-03 08:24:00 | SPY | ETF | 129.18 | 129.18 | 129.18 | 129.18 | 10000.0 |
| 2006-03-03 08:25:00 | SPY | ETF | 129.2 | 129.2 | 129.2 | 129.2 | 2000.0 |
| 2006-03-03 08:28:00 | SPY | ETF | 129.2 | 129.2 | 129.18 | 129.18 | 2000.0 |
| 2006-03-03 08:29:00 | SPY | ETF | 129.19 | 129.19 | 129.16 | 129.16 | 2500.0 |
| 2006-03-03 08:31:00 | SPY | ETF | 129.15 | 129.15 | 129.13 | 129.13 | 1300.0 |
| 2006-03-03 08:32:00 | SPY | ETF | 129.13 | 129.13 | 129.13 | 129.13 | 23100.0 |
| 2006-03-03 08:33:00 | SPY | ETF | 129.13 | 129.15 | 129.13 | 129.15 | 4700.0 |
| 2006-03-03 08:34:00 | SPY | ETF | 129.16 | 129.16 | 129.16 | 129.16 | 100.0 |
| 2006-03-03 08:37:00 | SPY | ETF | 129.15 | 129.15 | 129.15 | 129.15 | 700.0 |
| 2006-03-03 08:38:00 | SPY | ETF | 129.15 | 129.15 | 129.13 | 129.13 | 1300.0 |
| 2006-03-03 08:39:00 | SPY | ETF | 129.12 | 129.14 | 129.12 | 129.14 | 1500.0 |
| 2006-03-03 08:40:00 | SPY | ETF | 129.12 | 129.12 | 129.12 | 129.12 | 800.0 |
| 2006-03-03 08:41:00 | SPY | ETF | 129.12 | 129.13 | 129.12 | 129.12 | 3800.0 |
| 2006-03-03 08:42:00 | SPY | ETF | 129.12 | 129.12 | 129.12 | 129.12 | 500.0 |
| 2006-03-03 08:43:00 | SPY | ETF | 129.12 | 129.12 | 129.12 | 129.12 | 900.0 |
| 2006-03-03 08:45:00 | SPY | ETF | 129.12 | 129.12 | 129.11 | 129.11 | 800.0 |
| 2006-03-03 08:46:00 | SPY | ETF | 129.11 | 129.11 | 129.07 | 129.08 | 37900.0 |
| 2006-03-03 08:47:00 | SPY | ETF | 129.1 | 129.1 | 129.06 | 129.07 | 2100.0 |
| 2006-03-03 08:48:00 | SPY | ETF | 129.06 | 129.06 | 129.05 | 129.05 | 2400.0 |
| 2006-03-03 08:49:00 | SPY | ETF | 129.05 | 129.05 | 129.0 | 129.01 | 6300.0 |
| 2006-03-03 08:50:00 | SPY | ETF | 128.97 | 128.98 | 128.91 | 128.98 | 11300.0 |
| 2006-03-03 08:51:00 | SPY | ETF | 128.95 | 128.96 | 128.94 | 128.95 | 10100.0 |
| 2006-03-03 08:52:00 | SPY | ETF | 128.95 | 128.95 | 128.94 | 128.94 | 302200.0 |
| 2006-03-03 08:53:00 | SPY | ETF | 128.94 | 128.99 | 128.94 | 128.99 | 3900.0 |
| 2006-03-03 08:54:00 | SPY | ETF | 129.0 | 129.01 | 128.99 | 128.99 | 12900.0 |
| 2006-03-03 08:55:00 | SPY | ETF | 128.98 | 128.99 | 128.98 | 128.99 | 5400.0 |
| 2006-03-03 08:56:00 | SPY | ETF | 128.96 | 128.96 | 128.79 | 128.79 | 300600.0 |
| 2006-03-03 08:57:00 | SPY | ETF | 128.8 | 128.82 | 128.79 | 128.81 | 99000.0 |
> showing 50 of 23,711 rows — these rows as CSV