PREVIEW / etf_1min / 2006-07-19
file: by_date/etf_1min/2006/2006-07-19.parquet size: 505 KB rows: 29,661
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-07-19 06:29:00 | SPY | ETF | 123.97 | 123.97 | 123.97 | 123.97 | 100.0 |
| 2006-07-19 06:58:00 | SPY | ETF | 124.02 | 124.02 | 124.02 | 124.02 | 2500.0 |
| 2006-07-19 07:01:00 | SPY | ETF | 124.06 | 124.06 | 124.03 | 124.03 | 3000.0 |
| 2006-07-19 07:07:00 | SPY | ETF | 123.99 | 123.99 | 123.97 | 123.97 | 77200.0 |
| 2006-07-19 07:13:00 | SPY | ETF | 123.96 | 123.96 | 123.96 | 123.96 | 72500.0 |
| 2006-07-19 07:14:00 | SPY | ETF | 123.93 | 123.93 | 123.93 | 123.93 | 6200.0 |
| 2006-07-19 07:21:00 | SPY | ETF | 123.9 | 123.9 | 123.9 | 123.9 | 86100.0 |
| 2006-07-19 07:22:00 | SPY | ETF | 123.9 | 123.9 | 123.9 | 123.9 | 9600.0 |
| 2006-07-19 07:26:00 | SPY | ETF | 123.96 | 123.96 | 123.96 | 123.96 | 1000.0 |
| 2006-07-19 07:38:00 | SPY | ETF | 123.95 | 123.95 | 123.95 | 123.95 | 2000.0 |
| 2006-07-19 07:40:00 | SPY | ETF | 123.95 | 123.96 | 123.95 | 123.96 | 5500.0 |
| 2006-07-19 07:43:00 | SPY | ETF | 123.97 | 123.97 | 123.97 | 123.97 | 5000.0 |
| 2006-07-19 07:49:00 | SPY | ETF | 123.97 | 123.98 | 123.97 | 123.98 | 29900.0 |
| 2006-07-19 07:58:00 | SPY | ETF | 123.95 | 123.95 | 123.95 | 123.95 | 5000.0 |
| 2006-07-19 07:59:00 | SPY | ETF | 123.95 | 123.95 | 123.93 | 123.93 | 8500.0 |
| 2006-07-19 08:00:00 | SPY | ETF | 123.92 | 124.0 | 123.92 | 123.96 | 769100.0 |
| 2006-07-19 08:01:00 | SPY | ETF | 123.92 | 123.99 | 123.9 | 123.95 | 273400.0 |
| 2006-07-19 08:03:00 | SPY | ETF | 123.97 | 123.97 | 123.96 | 123.97 | 55100.0 |
| 2006-07-19 08:05:00 | SPY | ETF | 123.97 | 123.98 | 123.97 | 123.98 | 2600.0 |
| 2006-07-19 08:07:00 | SPY | ETF | 124.0 | 124.0 | 124.0 | 124.0 | 1000.0 |
| 2006-07-19 08:08:00 | SPY | ETF | 124.0 | 124.0 | 124.0 | 124.0 | 200.0 |
| 2006-07-19 08:09:00 | SPY | ETF | 124.01 | 124.04 | 124.01 | 124.04 | 12600.0 |
| 2006-07-19 08:10:00 | SPY | ETF | 124.04 | 124.09 | 124.04 | 124.05 | 28900.0 |
| 2006-07-19 08:11:00 | SPY | ETF | 124.05 | 124.11 | 124.05 | 124.1 | 15100.0 |
| 2006-07-19 08:12:00 | SPY | ETF | 124.1 | 124.11 | 124.1 | 124.11 | 1100.0 |
| 2006-07-19 08:13:00 | SPY | ETF | 124.1 | 124.13 | 124.1 | 124.13 | 9800.0 |
| 2006-07-19 08:14:00 | SPY | ETF | 124.12 | 124.18 | 124.12 | 124.16 | 8600.0 |
| 2006-07-19 08:15:00 | SPY | ETF | 123.99 | 124.16 | 123.99 | 124.12 | 488700.0 |
| 2006-07-19 08:16:00 | SPY | ETF | 124.13 | 124.13 | 124.12 | 124.12 | 2700.0 |
| 2006-07-19 08:17:00 | SPY | ETF | 124.11 | 124.27 | 124.11 | 124.27 | 74500.0 |
| 2006-07-19 08:18:00 | SPY | ETF | 124.25 | 124.3 | 124.25 | 124.25 | 22000.0 |
| 2006-07-19 08:19:00 | SPY | ETF | 124.23 | 124.25 | 124.13 | 124.13 | 434000.0 |
| 2006-07-19 08:20:00 | SPY | ETF | 124.25 | 124.31 | 124.25 | 124.31 | 15900.0 |
| 2006-07-19 08:21:00 | SPY | ETF | 124.3 | 124.44 | 124.23 | 124.44 | 86800.0 |
| 2006-07-19 08:22:00 | SPY | ETF | 124.45 | 124.45 | 124.23 | 124.23 | 926500.0 |
| 2006-07-19 08:23:00 | SPY | ETF | 124.4 | 124.41 | 124.31 | 124.31 | 73000.0 |
| 2006-07-19 08:24:00 | SPY | ETF | 124.32 | 124.39 | 124.3 | 124.39 | 181900.0 |
| 2006-07-19 08:25:00 | SPY | ETF | 124.38 | 124.41 | 124.37 | 124.39 | 54000.0 |
| 2006-07-19 08:26:00 | SPY | ETF | 124.36 | 124.53 | 124.34 | 124.45 | 952800.0 |
| 2006-07-19 08:27:00 | SPY | ETF | 124.45 | 124.52 | 124.38 | 124.38 | 542100.0 |
| 2006-07-19 08:28:00 | SPY | ETF | 124.38 | 124.38 | 124.3 | 124.35 | 127300.0 |
| 2006-07-19 08:29:00 | SPY | ETF | 124.35 | 124.38 | 124.31 | 124.32 | 114000.0 |
| 2006-07-19 08:30:00 | SPY | ETF | 124.31 | 124.31 | 123.79 | 124.13 | 1405900.0 |
| 2006-07-19 08:31:00 | SPY | ETF | 124.14 | 124.27 | 124.04 | 124.05 | 717700.0 |
| 2006-07-19 08:32:00 | SPY | ETF | 124.05 | 124.08 | 123.96 | 124.04 | 276200.0 |
| 2006-07-19 08:33:00 | SPY | ETF | 124.04 | 124.1 | 123.94 | 123.95 | 316200.0 |
| 2006-07-19 08:34:00 | SPY | ETF | 124.01 | 124.01 | 123.81 | 123.86 | 301700.0 |
| 2006-07-19 08:35:00 | SPY | ETF | 123.86 | 123.93 | 123.82 | 123.92 | 337300.0 |
| 2006-07-19 08:36:00 | SPY | ETF | 124.25 | 124.25 | 123.82 | 123.98 | 205300.0 |
| 2006-07-19 08:37:00 | SPY | ETF | 123.99 | 124.17 | 123.96 | 123.96 | 659600.0 |
> showing 50 of 29,661 rows — these rows as CSV