PREVIEW / etf_30min / 2008-12-24
file: by_date/etf_30min/2008/2008-12-24.parquet size: 121 KB rows: 3,769
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-12-24 04:00:00 | SPY | ETF | 86.15 | 86.15 | 86.15 | 86.15 | 400.0 |
| 2008-12-24 04:30:00 | SPY | ETF | 86.12 | 86.12 | 86.12 | 86.12 | 100.0 |
| 2008-12-24 05:00:00 | SPY | ETF | 86.18 | 86.18 | 86.15 | 86.15 | 300.0 |
| 2008-12-24 05:30:00 | SPY | ETF | 86.19 | 86.19 | 86.19 | 86.19 | 100.0 |
| 2008-12-24 06:00:00 | SPY | ETF | 86.24 | 86.3 | 86.24 | 86.3 | 400.0 |
| 2008-12-24 06:30:00 | SPY | ETF | 86.25 | 86.25 | 86.2 | 86.2 | 5100.0 |
| 2008-12-24 07:00:00 | SPY | ETF | 86.19 | 86.21 | 86.05 | 86.05 | 21099.0 |
| 2008-12-24 07:30:00 | SPY | ETF | 86.02 | 86.05 | 85.88 | 85.88 | 32219.0 |
| 2008-12-24 08:00:00 | SPY | ETF | 85.88 | 86.1 | 85.84 | 86.03 | 143736.0 |
| 2008-12-24 08:30:00 | SPY | ETF | 86.03 | 86.4 | 85.97 | 86.4 | 506935.0 |
| 2008-12-24 09:00:00 | SPY | ETF | 86.38 | 86.49 | 86.35 | 86.46 | 414986.0 |
| 2008-12-24 09:30:00 | SPY | ETF | 86.45 | 86.58 | 86.12 | 86.13 | 16051206.0 |
| 2008-12-24 10:00:00 | SPY | ETF | 86.13 | 86.56 | 86.0 | 86.5 | 9166111.0 |
| 2008-12-24 10:30:00 | SPY | ETF | 86.49 | 86.7 | 86.36 | 86.55 | 8736226.0 |
| 2008-12-24 11:00:00 | SPY | ETF | 86.54 | 86.77 | 86.51 | 86.53 | 5669009.0 |
| 2008-12-24 11:30:00 | SPY | ETF | 86.53 | 86.74 | 86.43 | 86.65 | 5452488.0 |
| 2008-12-24 12:00:00 | SPY | ETF | 86.65 | 86.73 | 86.52 | 86.61 | 3885871.0 |
| 2008-12-24 12:30:00 | SPY | ETF | 86.6 | 86.87 | 86.5 | 86.64 | 10645072.0 |
| 2008-12-24 13:00:00 | SPY | ETF | 86.63 | 86.76 | 86.4869 | 86.66 | 1052856.0 |
| 2008-12-24 13:30:00 | SPY | ETF | 86.65 | 86.67 | 86.5 | 86.55 | 36184.0 |
| 2008-12-24 14:00:00 | SPY | ETF | 86.53 | 86.67 | 86.52 | 86.55 | 12000.0 |
| 2008-12-24 14:30:00 | SPY | ETF | 86.55 | 86.55 | 86.52 | 86.52 | 8800.0 |
| 2008-12-24 15:00:00 | SPY | ETF | 86.51 | 86.51 | 86.45 | 86.47 | 7282.0 |
| 2008-12-24 15:30:00 | SPY | ETF | 86.47 | 86.56 | 86.47 | 86.56 | 750.0 |
| 2008-12-24 16:00:00 | SPY | ETF | 86.59 | 86.59 | 86.59 | 86.59 | 300.0 |
| 2008-12-24 16:30:00 | SPY | ETF | 86.59 | 86.63 | 86.59 | 86.63 | 1300.0 |
| 2008-12-24 04:00:00 | QQQ | ETF | 29.16 | 29.16 | 29.16 | 29.16 | 400.0 |
| 2008-12-24 04:30:00 | QQQ | ETF | 29.08 | 29.1 | 29.08 | 29.1 | 200.0 |
| 2008-12-24 06:30:00 | QQQ | ETF | 29.14 | 29.14 | 29.14 | 29.14 | 100.0 |
| 2008-12-24 07:30:00 | QQQ | ETF | 29.1 | 29.12 | 29.05 | 29.05 | 23433.0 |
| 2008-12-24 08:00:00 | QQQ | ETF | 29.06 | 29.1 | 29.05 | 29.08 | 348024.0 |
| 2008-12-24 08:30:00 | QQQ | ETF | 29.08 | 29.2 | 29.05 | 29.18 | 395069.0 |
| 2008-12-24 09:00:00 | QQQ | ETF | 29.17 | 29.21 | 29.15 | 29.2 | 87306.0 |
| 2008-12-24 09:30:00 | QQQ | ETF | 29.2 | 29.21 | 29.01 | 29.03 | 4275942.0 |
| 2008-12-24 10:00:00 | QQQ | ETF | 29.03 | 29.15 | 28.98 | 29.13 | 3897811.0 |
| 2008-12-24 10:30:00 | QQQ | ETF | 29.12 | 29.2 | 29.11 | 29.12 | 2755912.0 |
| 2008-12-24 11:00:00 | QQQ | ETF | 29.12 | 29.17 | 29.09 | 29.098 | 1737147.0 |
| 2008-12-24 11:30:00 | QQQ | ETF | 29.09 | 29.14 | 29.06 | 29.1 | 2456149.0 |
| 2008-12-24 12:00:00 | QQQ | ETF | 29.105 | 29.11 | 29.04 | 29.0706 | 1987922.0 |
| 2008-12-24 12:30:00 | QQQ | ETF | 29.08 | 29.18 | 29.07 | 29.09 | 3392100.0 |
| 2008-12-24 13:00:00 | QQQ | ETF | 29.09 | 29.14 | 28.95 | 29.01 | 288379.0 |
| 2008-12-24 13:30:00 | QQQ | ETF | 29.01 | 29.01 | 28.96 | 28.99 | 12387.0 |
| 2008-12-24 14:00:00 | QQQ | ETF | 29.03 | 29.03 | 29.02 | 29.02 | 800.0 |
| 2008-12-24 14:30:00 | QQQ | ETF | 29.02 | 29.02 | 28.97 | 28.97 | 6500.0 |
| 2008-12-24 15:00:00 | QQQ | ETF | 28.97 | 29.0 | 28.97 | 29.0 | 3830.0 |
| 2008-12-24 15:30:00 | QQQ | ETF | 29.01 | 29.01 | 29.01 | 29.01 | 200.0 |
| 2008-12-24 16:00:00 | QQQ | ETF | 29.03 | 29.03 | 29.01 | 29.01 | 2500.0 |
| 2008-12-24 16:30:00 | QQQ | ETF | 29.02 | 29.05 | 29.02 | 29.05 | 4274.0 |
| 2008-12-24 04:00:00 | IWM | ETF | 46.53 | 46.53 | 46.53 | 46.53 | 100.0 |
| 2008-12-24 05:00:00 | IWM | ETF | 46.46 | 46.46 | 46.46 | 46.46 | 100.0 |
> showing 50 of 3,769 rows — these rows as CSV