PREVIEW / etf_1min / 2008-09-16
file: by_date/etf_1min/2008/2008-09-16.parquet size: 1.5 MB rows: 88,635
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-09-16 04:16:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 100.0 |
| 2008-09-16 04:25:00 | SPY | ETF | 119.33 | 119.33 | 119.33 | 119.33 | 100.0 |
| 2008-09-16 04:29:00 | SPY | ETF | 119.45 | 119.45 | 119.45 | 119.45 | 100.0 |
| 2008-09-16 05:07:00 | SPY | ETF | 119.88 | 119.88 | 119.88 | 119.88 | 1000.0 |
| 2008-09-16 05:09:00 | SPY | ETF | 119.79 | 119.79 | 119.79 | 119.79 | 100.0 |
| 2008-09-16 05:20:00 | SPY | ETF | 120.0 | 120.0 | 120.0 | 120.0 | 100.0 |
| 2008-09-16 05:32:00 | SPY | ETF | 120.16 | 120.16 | 120.16 | 120.16 | 2000.0 |
| 2008-09-16 05:35:00 | SPY | ETF | 120.0 | 120.0 | 120.0 | 120.0 | 500.0 |
| 2008-09-16 05:38:00 | SPY | ETF | 119.9 | 119.9 | 119.9 | 119.9 | 1000.0 |
| 2008-09-16 05:39:00 | SPY | ETF | 119.95 | 119.95 | 119.95 | 119.95 | 1000.0 |
| 2008-09-16 05:44:00 | SPY | ETF | 119.98 | 119.98 | 119.98 | 119.98 | 100.0 |
| 2008-09-16 05:47:00 | SPY | ETF | 120.02 | 120.02 | 120.02 | 120.02 | 400.0 |
| 2008-09-16 05:50:00 | SPY | ETF | 120.25 | 120.25 | 120.2 | 120.2 | 1200.0 |
| 2008-09-16 05:55:00 | SPY | ETF | 120.22 | 120.22 | 120.22 | 120.22 | 1000.0 |
| 2008-09-16 06:01:00 | SPY | ETF | 120.22 | 120.22 | 120.22 | 120.22 | 200.0 |
| 2008-09-16 06:07:00 | SPY | ETF | 120.17 | 120.17 | 120.02 | 120.02 | 5100.0 |
| 2008-09-16 06:10:00 | SPY | ETF | 119.9 | 119.9 | 119.9 | 119.9 | 100.0 |
| 2008-09-16 06:12:00 | SPY | ETF | 119.87 | 119.87 | 119.74 | 119.74 | 233000.0 |
| 2008-09-16 06:19:00 | SPY | ETF | 119.74 | 119.74 | 119.74 | 119.74 | 2500.0 |
| 2008-09-16 06:20:00 | SPY | ETF | 119.72 | 119.72 | 119.69 | 119.69 | 2990.0 |
| 2008-09-16 06:22:00 | SPY | ETF | 119.66 | 119.66 | 119.66 | 119.66 | 100.0 |
| 2008-09-16 06:23:00 | SPY | ETF | 119.65 | 119.65 | 119.65 | 119.65 | 50000.0 |
| 2008-09-16 06:24:00 | SPY | ETF | 119.55 | 119.56 | 119.55 | 119.56 | 50000.0 |
| 2008-09-16 06:27:00 | SPY | ETF | 119.58 | 119.58 | 119.3 | 119.3 | 382700.0 |
| 2008-09-16 06:28:00 | SPY | ETF | 119.3 | 119.3 | 119.3 | 119.3 | 2500.0 |
| 2008-09-16 06:29:00 | SPY | ETF | 119.25 | 119.25 | 119.21 | 119.21 | 10400.0 |
| 2008-09-16 06:30:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 1000.0 |
| 2008-09-16 06:31:00 | SPY | ETF | 119.16 | 119.16 | 119.16 | 119.16 | 1000.0 |
| 2008-09-16 06:32:00 | SPY | ETF | 119.23 | 119.23 | 119.23 | 119.23 | 2000.0 |
| 2008-09-16 06:35:00 | SPY | ETF | 119.2 | 119.2 | 119.1 | 119.1 | 3990.0 |
| 2008-09-16 06:36:00 | SPY | ETF | 119.21 | 119.21 | 119.1 | 119.1 | 7250.0 |
| 2008-09-16 06:37:00 | SPY | ETF | 119.12 | 119.12 | 119.09 | 119.12 | 4700.0 |
| 2008-09-16 06:40:00 | SPY | ETF | 119.09 | 119.12 | 119.09 | 119.12 | 2000.0 |
| 2008-09-16 06:42:00 | SPY | ETF | 119.11 | 119.11 | 119.11 | 119.11 | 2200.0 |
| 2008-09-16 06:43:00 | SPY | ETF | 119.1 | 119.1 | 119.1 | 119.1 | 500.0 |
| 2008-09-16 06:44:00 | SPY | ETF | 119.16 | 119.16 | 119.15 | 119.16 | 87500.0 |
| 2008-09-16 06:45:00 | SPY | ETF | 119.16 | 119.16 | 119.1 | 119.1 | 184000.0 |
| 2008-09-16 06:46:00 | SPY | ETF | 119.05 | 119.05 | 119.03 | 119.03 | 21950.0 |
| 2008-09-16 06:47:00 | SPY | ETF | 119.0 | 119.0 | 118.95 | 118.95 | 800.0 |
| 2008-09-16 06:48:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 4700.0 |
| 2008-09-16 06:49:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 83200.0 |
| 2008-09-16 06:50:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 118750.0 |
| 2008-09-16 06:52:00 | SPY | ETF | 119.11 | 119.11 | 119.11 | 119.11 | 500.0 |
| 2008-09-16 06:55:00 | SPY | ETF | 119.12 | 119.17 | 119.1 | 119.17 | 3400.0 |
| 2008-09-16 06:57:00 | SPY | ETF | 119.13 | 119.13 | 119.13 | 119.13 | 200.0 |
| 2008-09-16 06:58:00 | SPY | ETF | 119.1 | 119.1 | 119.09 | 119.09 | 699.0 |
| 2008-09-16 06:59:00 | SPY | ETF | 119.07 | 119.07 | 119.01 | 119.01 | 51100.0 |
| 2008-09-16 07:00:00 | SPY | ETF | 118.99 | 119.01 | 118.85 | 118.86 | 89747.0 |
| 2008-09-16 07:01:00 | SPY | ETF | 118.86 | 118.87 | 118.74 | 118.74 | 92506.0 |
| 2008-09-16 07:02:00 | SPY | ETF | 118.74 | 118.81 | 118.6 | 118.6 | 201513.0 |
> showing 50 of 88,635 rows — these rows as CSV