PREVIEW / etf_1min / 2008-10-21
file: by_date/etf_1min/2008/2008-10-21.parquet size: 1.2 MB rows: 78,235
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 |
|---|---|---|---|---|---|---|---|
| 2008-10-21 04:17:00 | SPY | ETF | 98.15 | 98.15 | 98.15 | 98.15 | 100.0 |
| 2008-10-21 04:18:00 | SPY | ETF | 98.0 | 98.0 | 98.0 | 98.0 | 100.0 |
| 2008-10-21 04:36:00 | SPY | ETF | 97.87 | 97.87 | 97.87 | 97.87 | 100.0 |
| 2008-10-21 04:38:00 | SPY | ETF | 97.9 | 97.9 | 97.9 | 97.9 | 100.0 |
| 2008-10-21 04:51:00 | SPY | ETF | 97.63 | 97.63 | 97.63 | 97.63 | 100.0 |
| 2008-10-21 05:58:00 | SPY | ETF | 98.18 | 98.18 | 98.18 | 98.18 | 100.0 |
| 2008-10-21 06:07:00 | SPY | ETF | 98.17 | 98.17 | 98.17 | 98.17 | 500.0 |
| 2008-10-21 06:09:00 | SPY | ETF | 98.21 | 98.21 | 98.21 | 98.21 | 1000.0 |
| 2008-10-21 06:18:00 | SPY | ETF | 98.35 | 98.35 | 98.35 | 98.35 | 100.0 |
| 2008-10-21 06:19:00 | SPY | ETF | 98.43 | 98.43 | 98.37 | 98.37 | 200.0 |
| 2008-10-21 06:20:00 | SPY | ETF | 98.35 | 98.37 | 98.35 | 98.37 | 3000.0 |
| 2008-10-21 06:21:00 | SPY | ETF | 98.3 | 98.3 | 98.3 | 98.3 | 100.0 |
| 2008-10-21 06:24:00 | SPY | ETF | 98.28 | 98.28 | 98.28 | 98.28 | 100.0 |
| 2008-10-21 06:32:00 | SPY | ETF | 98.2 | 98.2 | 98.2 | 98.2 | 100.0 |
| 2008-10-21 06:33:00 | SPY | ETF | 98.2 | 98.25 | 98.2 | 98.2 | 15000.0 |
| 2008-10-21 06:40:00 | SPY | ETF | 98.16 | 98.16 | 98.1 | 98.1 | 1500.0 |
| 2008-10-21 06:45:00 | SPY | ETF | 98.25 | 98.25 | 98.25 | 98.25 | 100.0 |
| 2008-10-21 06:46:00 | SPY | ETF | 98.33 | 98.33 | 98.33 | 98.33 | 2500.0 |
| 2008-10-21 06:49:00 | SPY | ETF | 98.3 | 98.3 | 98.2 | 98.2 | 2500.0 |
| 2008-10-21 06:53:00 | SPY | ETF | 98.25 | 98.25 | 98.25 | 98.25 | 100.0 |
| 2008-10-21 06:56:00 | SPY | ETF | 98.32 | 98.32 | 98.32 | 98.32 | 2500.0 |
| 2008-10-21 07:01:00 | SPY | ETF | 98.33 | 98.33 | 98.33 | 98.33 | 200.0 |
| 2008-10-21 07:02:00 | SPY | ETF | 98.3 | 98.4 | 98.3 | 98.38 | 5800.0 |
| 2008-10-21 07:03:00 | SPY | ETF | 98.31 | 98.31 | 98.3 | 98.3 | 2000.0 |
| 2008-10-21 07:04:00 | SPY | ETF | 98.3 | 98.33 | 98.3 | 98.31 | 12600.0 |
| 2008-10-21 07:05:00 | SPY | ETF | 98.4 | 98.4 | 98.4 | 98.4 | 500.0 |
| 2008-10-21 07:06:00 | SPY | ETF | 98.32 | 98.32 | 98.29 | 98.3 | 50500.0 |
| 2008-10-21 07:09:00 | SPY | ETF | 98.3 | 98.43 | 98.3 | 98.43 | 15000.0 |
| 2008-10-21 07:11:00 | SPY | ETF | 98.4 | 98.4 | 98.4 | 98.4 | 4100.0 |
| 2008-10-21 07:12:00 | SPY | ETF | 98.35 | 98.35 | 98.35 | 98.35 | 1000.0 |
| 2008-10-21 07:13:00 | SPY | ETF | 98.35 | 98.35 | 98.35 | 98.35 | 1100.0 |
| 2008-10-21 07:14:00 | SPY | ETF | 98.35 | 98.35 | 98.32 | 98.32 | 6500.0 |
| 2008-10-21 07:15:00 | SPY | ETF | 98.2 | 98.27 | 98.2 | 98.23 | 4100.0 |
| 2008-10-21 07:16:00 | SPY | ETF | 98.26 | 98.32 | 98.19 | 98.32 | 27700.0 |
| 2008-10-21 07:17:00 | SPY | ETF | 98.21 | 98.36 | 98.19 | 98.35 | 5800.0 |
| 2008-10-21 07:18:00 | SPY | ETF | 98.22 | 98.35 | 98.21 | 98.28 | 4800.0 |
| 2008-10-21 07:19:00 | SPY | ETF | 98.22 | 98.28 | 98.16 | 98.21 | 11100.0 |
| 2008-10-21 07:20:00 | SPY | ETF | 98.21 | 98.21 | 98.15 | 98.2 | 5103.0 |
| 2008-10-21 07:21:00 | SPY | ETF | 98.18 | 98.18 | 98.0 | 98.03 | 32630.0 |
| 2008-10-21 07:22:00 | SPY | ETF | 98.03 | 98.11 | 98.02 | 98.11 | 8078.0 |
| 2008-10-21 07:23:00 | SPY | ETF | 98.11 | 98.11 | 98.11 | 98.11 | 2300.0 |
| 2008-10-21 07:24:00 | SPY | ETF | 98.08 | 98.1 | 98.06 | 98.09 | 5500.0 |
| 2008-10-21 07:25:00 | SPY | ETF | 98.04 | 98.09 | 97.95 | 98.01 | 13399.0 |
| 2008-10-21 07:26:00 | SPY | ETF | 97.98 | 98.02 | 97.98 | 98.02 | 2900.0 |
| 2008-10-21 07:27:00 | SPY | ETF | 98.01 | 98.01 | 97.88 | 97.9 | 29201.0 |
| 2008-10-21 07:28:00 | SPY | ETF | 97.85 | 97.86 | 97.8 | 97.8 | 20600.0 |
| 2008-10-21 07:29:00 | SPY | ETF | 97.9 | 97.9 | 97.9 | 97.9 | 500.0 |
| 2008-10-21 07:30:00 | SPY | ETF | 98.0 | 98.03 | 97.98 | 97.98 | 10200.0 |
| 2008-10-21 07:31:00 | SPY | ETF | 97.9 | 97.9 | 97.75 | 97.75 | 18400.0 |
| 2008-10-21 07:32:00 | SPY | ETF | 97.8 | 97.84 | 97.75 | 97.77 | 22600.0 |
> showing 50 of 78,235 rows — these rows as CSV