PREVIEW / etf_30min / 2008-01-30
file: by_date/etf_30min/2008/2008-01-30.parquet size: 158 KB rows: 5,778
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-01-30 04:00:00 | SPY | ETF | 135.4 | 135.4 | 135.4 | 135.4 | 200.0 |
| 2008-01-30 04:30:00 | SPY | ETF | 135.36 | 135.36 | 135.36 | 135.36 | 1500.0 |
| 2008-01-30 05:00:00 | SPY | ETF | 135.51 | 135.51 | 135.5 | 135.5 | 36000.0 |
| 2008-01-30 05:30:00 | SPY | ETF | 135.5 | 135.54 | 135.5 | 135.54 | 14100.0 |
| 2008-01-30 06:00:00 | SPY | ETF | 135.78 | 135.88 | 135.78 | 135.85 | 6900.0 |
| 2008-01-30 06:30:00 | SPY | ETF | 135.93 | 135.93 | 135.78 | 135.82 | 35900.0 |
| 2008-01-30 07:00:00 | SPY | ETF | 135.73 | 135.76 | 135.47 | 135.5 | 205400.0 |
| 2008-01-30 07:30:00 | SPY | ETF | 135.39 | 135.62 | 135.34 | 135.48 | 157600.0 |
| 2008-01-30 08:00:00 | SPY | ETF | 135.5 | 136.15 | 135.16 | 136.09 | 5060200.0 |
| 2008-01-30 08:30:00 | SPY | ETF | 136.06 | 136.2 | 135.57 | 135.58 | 1700200.0 |
| 2008-01-30 09:00:00 | SPY | ETF | 135.6 | 135.79 | 135.55 | 135.63 | 561600.0 |
| 2008-01-30 09:30:00 | SPY | ETF | 135.58 | 135.82 | 135.23 | 135.76 | 19946938.0 |
| 2008-01-30 10:00:00 | SPY | ETF | 135.76 | 136.15 | 135.73 | 135.97 | 16081979.0 |
| 2008-01-30 10:30:00 | SPY | ETF | 135.98 | 136.19 | 135.81 | 136.06 | 5751924.0 |
| 2008-01-30 11:00:00 | SPY | ETF | 136.06 | 136.11 | 135.57 | 135.61 | 8323280.0 |
| 2008-01-30 11:30:00 | SPY | ETF | 135.6 | 135.84 | 135.46 | 135.67 | 6888825.0 |
| 2008-01-30 12:00:00 | SPY | ETF | 135.65 | 135.87 | 135.58 | 135.68 | 6642130.0 |
| 2008-01-30 12:30:00 | SPY | ETF | 135.68 | 135.77 | 135.56 | 135.73 | 2184562.0 |
| 2008-01-30 13:00:00 | SPY | ETF | 135.73 | 136.0 | 135.4868 | 135.87 | 4914615.0 |
| 2008-01-30 13:30:00 | SPY | ETF | 135.87 | 135.91 | 135.57 | 135.67 | 7408172.0 |
| 2008-01-30 14:00:00 | SPY | ETF | 135.67 | 137.78 | 135.56 | 137.42 | 61098104.0 |
| 2008-01-30 14:30:00 | SPY | ETF | 137.42 | 138.1 | 136.4 | 138.08 | 52722048.0 |
| 2008-01-30 15:00:00 | SPY | ETF | 138.08 | 138.54 | 137.02 | 137.22 | 42360359.0 |
| 2008-01-30 15:30:00 | SPY | ETF | 137.22 | 137.41 | 135.05 | 135.36 | 69107942.0 |
| 2008-01-30 16:00:00 | SPY | ETF | 135.31 | 136.901 | 134.58 | 134.78 | 9411700.0 |
| 2008-01-30 16:30:00 | SPY | ETF | 134.78 | 134.81 | 134.32 | 134.44 | 5481500.0 |
| 2008-01-30 17:00:00 | SPY | ETF | 134.45 | 134.45 | 133.57 | 133.68 | 2280100.0 |
| 2008-01-30 17:30:00 | SPY | ETF | 133.75 | 133.8 | 133.35 | 133.49 | 303100.0 |
| 2008-01-30 18:00:00 | SPY | ETF | 133.49 | 133.6 | 133.2 | 133.55 | 333200.0 |
| 2008-01-30 18:30:00 | SPY | ETF | 133.51 | 133.59 | 133.41 | 133.49 | 57200.0 |
| 2008-01-30 19:00:00 | SPY | ETF | 133.53 | 133.66 | 133.45 | 133.61 | 35100.0 |
| 2008-01-30 19:30:00 | SPY | ETF | 133.61 | 133.8 | 133.47 | 133.8 | 41100.0 |
| 2008-01-30 04:30:00 | QQQ | ETF | 44.13 | 44.13 | 44.13 | 44.13 | 2000.0 |
| 2008-01-30 05:30:00 | QQQ | ETF | 44.2 | 44.2 | 44.2 | 44.2 | 300.0 |
| 2008-01-30 06:00:00 | QQQ | ETF | 44.2 | 44.2 | 44.2 | 44.2 | 7200.0 |
| 2008-01-30 06:30:00 | QQQ | ETF | 44.22 | 44.22 | 44.21 | 44.21 | 43300.0 |
| 2008-01-30 07:00:00 | QQQ | ETF | 44.21 | 44.23 | 44.16 | 44.18 | 171284.0 |
| 2008-01-30 07:30:00 | QQQ | ETF | 44.18 | 44.2 | 44.15 | 44.17 | 207800.0 |
| 2008-01-30 08:00:00 | QQQ | ETF | 44.17 | 44.42 | 44.09 | 44.27 | 1023035.0 |
| 2008-01-30 08:30:00 | QQQ | ETF | 44.27 | 44.28 | 44.14 | 44.2 | 643592.0 |
| 2008-01-30 09:00:00 | QQQ | ETF | 44.22 | 44.29 | 44.19 | 44.25 | 464461.0 |
| 2008-01-30 09:30:00 | QQQ | ETF | 44.24 | 44.5 | 44.18 | 44.43 | 10983992.0 |
| 2008-01-30 10:00:00 | QQQ | ETF | 44.44 | 44.61 | 44.34 | 44.57 | 15330611.0 |
| 2008-01-30 10:30:00 | QQQ | ETF | 44.57 | 44.67 | 44.53 | 44.64 | 6288318.0 |
| 2008-01-30 11:00:00 | QQQ | ETF | 44.64 | 44.67 | 44.47 | 44.48 | 5818876.0 |
| 2008-01-30 11:30:00 | QQQ | ETF | 44.48 | 44.54 | 44.4 | 44.46 | 5761410.0 |
| 2008-01-30 12:00:00 | QQQ | ETF | 44.46 | 44.48 | 44.41 | 44.422 | 4098425.0 |
| 2008-01-30 12:30:00 | QQQ | ETF | 44.42 | 44.43 | 44.35 | 44.38 | 2338404.0 |
| 2008-01-30 13:00:00 | QQQ | ETF | 44.38 | 44.46 | 44.33 | 44.36 | 2505284.0 |
| 2008-01-30 13:30:00 | QQQ | ETF | 44.36 | 44.39 | 44.28 | 44.34 | 6464793.0 |
> showing 50 of 5,778 rows — these rows as CSV