PREVIEW / etf_30min / 2008-02-28
file: by_date/etf_30min/2008/2008-02-28.parquet size: 154 KB rows: 5,636
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-02-28 04:00:00 | SPY | ETF | 137.68 | 137.68 | 137.68 | 137.68 | 1000.0 |
| 2008-02-28 04:30:00 | SPY | ETF | 137.5 | 137.53 | 137.5 | 137.53 | 1100.0 |
| 2008-02-28 05:30:00 | SPY | ETF | 137.51 | 137.61 | 137.4 | 137.52 | 8100.0 |
| 2008-02-28 06:00:00 | SPY | ETF | 137.58 | 137.61 | 137.41 | 137.57 | 19200.0 |
| 2008-02-28 06:30:00 | SPY | ETF | 137.59 | 137.78 | 137.59 | 137.75 | 77200.0 |
| 2008-02-28 07:00:00 | SPY | ETF | 137.8 | 137.83 | 137.53 | 137.76 | 90200.0 |
| 2008-02-28 07:30:00 | SPY | ETF | 137.65 | 137.76 | 137.47 | 137.47 | 478800.0 |
| 2008-02-28 08:00:00 | SPY | ETF | 137.51 | 137.62 | 137.36 | 137.58 | 1377100.0 |
| 2008-02-28 08:30:00 | SPY | ETF | 137.55 | 137.66 | 137.04 | 137.11 | 6960800.0 |
| 2008-02-28 09:00:00 | SPY | ETF | 137.1 | 137.35 | 137.08 | 137.25 | 1786600.0 |
| 2008-02-28 09:30:00 | SPY | ETF | 137.24 | 137.59 | 137.05 | 137.4 | 19804379.0 |
| 2008-02-28 10:00:00 | SPY | ETF | 137.41 | 137.77 | 137.22 | 137.74 | 13685940.0 |
| 2008-02-28 10:30:00 | SPY | ETF | 137.74 | 137.96 | 137.46 | 137.5 | 13708713.0 |
| 2008-02-28 11:00:00 | SPY | ETF | 137.49 | 137.56 | 136.75 | 136.84 | 18572717.0 |
| 2008-02-28 11:30:00 | SPY | ETF | 136.84 | 136.97 | 136.55 | 136.95 | 11727182.0 |
| 2008-02-28 12:00:00 | SPY | ETF | 136.96 | 137.01 | 136.65 | 136.9 | 4570468.0 |
| 2008-02-28 12:30:00 | SPY | ETF | 136.9 | 137.16 | 136.83 | 136.9 | 4575565.0 |
| 2008-02-28 13:00:00 | SPY | ETF | 136.9 | 137.3 | 136.71 | 136.8 | 7153544.0 |
| 2008-02-28 13:30:00 | SPY | ETF | 136.79 | 137.12 | 136.7 | 137.1 | 5185845.0 |
| 2008-02-28 14:00:00 | SPY | ETF | 137.09 | 137.59 | 136.8 | 137.45 | 9578353.0 |
| 2008-02-28 14:30:00 | SPY | ETF | 137.44 | 137.67 | 137.29 | 137.64 | 11006866.0 |
| 2008-02-28 15:00:00 | SPY | ETF | 137.63 | 137.66 | 136.86 | 136.93 | 11365030.0 |
| 2008-02-28 15:30:00 | SPY | ETF | 136.93 | 137.24 | 136.83 | 136.99 | 15301044.0 |
| 2008-02-28 16:00:00 | SPY | ETF | 136.9601 | 137.1 | 136.66 | 136.79 | 6455700.0 |
| 2008-02-28 16:30:00 | SPY | ETF | 136.8 | 138.2546 | 136.55 | 136.57 | 3517300.0 |
| 2008-02-28 17:00:00 | SPY | ETF | 136.59 | 136.82 | 136.57 | 136.81 | 392900.0 |
| 2008-02-28 17:30:00 | SPY | ETF | 136.7 | 136.7 | 136.58 | 136.66 | 172800.0 |
| 2008-02-28 18:00:00 | SPY | ETF | 136.62 | 136.66 | 136.23 | 136.35 | 605900.0 |
| 2008-02-28 18:30:00 | SPY | ETF | 136.39 | 136.48 | 136.3 | 136.3 | 152900.0 |
| 2008-02-28 19:00:00 | SPY | ETF | 136.38 | 136.38 | 136.21 | 136.31 | 64000.0 |
| 2008-02-28 19:30:00 | SPY | ETF | 136.28 | 136.28 | 136.03 | 136.1 | 96100.0 |
| 2008-02-28 05:30:00 | QQQ | ETF | 44.17 | 44.17 | 44.17 | 44.17 | 1000.0 |
| 2008-02-28 06:00:00 | QQQ | ETF | 44.2 | 44.2 | 44.18 | 44.18 | 18000.0 |
| 2008-02-28 07:00:00 | QQQ | ETF | 44.28 | 44.28 | 44.16 | 44.21 | 168361.0 |
| 2008-02-28 07:30:00 | QQQ | ETF | 44.23 | 44.25 | 44.16 | 44.16 | 97136.0 |
| 2008-02-28 08:00:00 | QQQ | ETF | 44.16 | 44.2 | 44.09 | 44.09 | 959532.0 |
| 2008-02-28 08:30:00 | QQQ | ETF | 44.11 | 44.15 | 44.0 | 44.07 | 1334612.0 |
| 2008-02-28 09:00:00 | QQQ | ETF | 44.07 | 44.13 | 44.03 | 44.11 | 579878.0 |
| 2008-02-28 09:30:00 | QQQ | ETF | 44.11 | 44.35 | 44.07 | 44.25 | 21558885.0 |
| 2008-02-28 10:00:00 | QQQ | ETF | 44.25 | 44.39 | 44.18 | 44.37 | 11635904.0 |
| 2008-02-28 10:30:00 | QQQ | ETF | 44.38 | 44.53 | 44.29 | 44.36 | 14329371.0 |
| 2008-02-28 11:00:00 | QQQ | ETF | 44.35 | 44.38 | 44.04 | 44.0999 | 13635187.0 |
| 2008-02-28 11:30:00 | QQQ | ETF | 44.095 | 44.12 | 43.95 | 44.09 | 10233235.0 |
| 2008-02-28 12:00:00 | QQQ | ETF | 44.09 | 44.19 | 44.0 | 44.1299 | 4713768.0 |
| 2008-02-28 12:30:00 | QQQ | ETF | 44.13 | 44.22 | 44.11 | 44.12 | 3331521.0 |
| 2008-02-28 13:00:00 | QQQ | ETF | 44.12 | 44.25 | 44.07 | 44.102 | 2295313.0 |
| 2008-02-28 13:30:00 | QQQ | ETF | 44.1 | 44.22 | 44.06 | 44.2001 | 2597447.0 |
| 2008-02-28 14:00:00 | QQQ | ETF | 44.21 | 44.4 | 44.1 | 44.37 | 7361720.0 |
| 2008-02-28 14:30:00 | QQQ | ETF | 44.37 | 44.48 | 44.3 | 44.4799 | 7936930.0 |
| 2008-02-28 15:00:00 | QQQ | ETF | 44.48 | 44.48 | 44.19 | 44.2301 | 8538863.0 |
> showing 50 of 5,636 rows — these rows as CSV