PREVIEW / etf_30min / 2005-03-22
file: by_date/etf_30min/2005/2005-03-22.parquet size: 45 KB rows: 1,525
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 |
|---|---|---|---|---|---|---|---|
| 2005-03-22 08:00:00 | SPY | ETF | 118.18 | 118.28 | 118.17 | 118.2 | 144400.0 |
| 2005-03-22 08:30:00 | SPY | ETF | 118.23 | 118.38 | 118.19 | 118.31 | 123200.0 |
| 2005-03-22 09:00:00 | SPY | ETF | 118.31 | 118.36 | 118.29 | 118.36 | 174900.0 |
| 2005-03-22 09:30:00 | SPY | ETF | 118.37 | 118.68 | 118.33 | 118.56 | 7126700.0 |
| 2005-03-22 10:00:00 | SPY | ETF | 118.57 | 118.67 | 118.38 | 118.57 | 4775300.0 |
| 2005-03-22 10:30:00 | SPY | ETF | 118.56 | 118.76 | 118.56 | 118.74 | 3891700.0 |
| 2005-03-22 11:00:00 | SPY | ETF | 118.74 | 118.75 | 118.53 | 118.56 | 2715200.0 |
| 2005-03-22 11:30:00 | SPY | ETF | 118.56 | 118.7 | 118.54 | 118.65 | 1028400.0 |
| 2005-03-22 12:00:00 | SPY | ETF | 118.65 | 118.74 | 118.63 | 118.7 | 753700.0 |
| 2005-03-22 12:30:00 | SPY | ETF | 118.69 | 118.71 | 118.64 | 118.68 | 746500.0 |
| 2005-03-22 13:00:00 | SPY | ETF | 118.66 | 118.77 | 118.65 | 118.75 | 1309100.0 |
| 2005-03-22 13:30:00 | SPY | ETF | 118.74 | 118.85 | 118.72 | 118.82 | 1759200.0 |
| 2005-03-22 14:00:00 | SPY | ETF | 118.82 | 118.93 | 118.28 | 118.38 | 15304600.0 |
| 2005-03-22 14:30:00 | SPY | ETF | 118.37 | 118.81 | 117.64 | 117.94 | 20695800.0 |
| 2005-03-22 15:00:00 | SPY | ETF | 117.95 | 117.98 | 117.41 | 117.59 | 11427800.0 |
| 2005-03-22 15:30:00 | SPY | ETF | 117.55 | 117.6 | 117.06 | 117.13 | 9504700.0 |
| 2005-03-22 16:00:00 | SPY | ETF | 117.11 | 117.24 | 116.52 | 116.9 | 7118800.0 |
| 2005-03-22 16:30:00 | SPY | ETF | 116.9 | 117.0 | 116.79 | 116.99 | 160800.0 |
| 2005-03-22 17:00:00 | SPY | ETF | 116.97 | 116.97 | 116.85 | 116.89 | 503800.0 |
| 2005-03-22 17:30:00 | SPY | ETF | 116.85 | 116.94 | 116.85 | 116.92 | 15800.0 |
| 2005-03-22 18:00:00 | SPY | ETF | 116.92 | 116.95 | 116.92 | 116.93 | 83200.0 |
| 2005-03-22 18:30:00 | SPY | ETF | 116.92 | 116.95 | 116.92 | 116.95 | 5800.0 |
| 2005-03-22 19:00:00 | SPY | ETF | 116.95 | 116.96 | 116.93 | 116.93 | 2700.0 |
| 2005-03-22 19:30:00 | SPY | ETF | 116.99 | 117.0 | 116.93 | 116.93 | 1200.0 |
| 2005-03-22 09:30:00 | QQQ | ETF | 36.63 | 38.67 | 36.59 | 36.64 | 9487800.0 |
| 2005-03-22 10:00:00 | QQQ | ETF | 36.64 | 36.67 | 36.52 | 36.6 | 6601800.0 |
| 2005-03-22 10:30:00 | QQQ | ETF | 36.6 | 36.66 | 36.58 | 36.65 | 4810200.0 |
| 2005-03-22 11:00:00 | QQQ | ETF | 36.65 | 36.66 | 36.58 | 36.61 | 3235800.0 |
| 2005-03-22 11:30:00 | QQQ | ETF | 36.6 | 36.62 | 36.58 | 36.59 | 2055100.0 |
| 2005-03-22 12:00:00 | QQQ | ETF | 36.59 | 36.6 | 36.58 | 36.59 | 1854100.0 |
| 2005-03-22 12:30:00 | QQQ | ETF | 36.59 | 36.6 | 36.58 | 36.59 | 1025300.0 |
| 2005-03-22 13:00:00 | QQQ | ETF | 36.58 | 36.62 | 36.57 | 36.61 | 1258700.0 |
| 2005-03-22 13:30:00 | QQQ | ETF | 36.62 | 36.71 | 36.61 | 36.7 | 4454100.0 |
| 2005-03-22 14:00:00 | QQQ | ETF | 36.69 | 36.75 | 36.51 | 36.56 | 16388400.0 |
| 2005-03-22 14:30:00 | QQQ | ETF | 36.57 | 36.62 | 36.28 | 36.38 | 18983300.0 |
| 2005-03-22 15:00:00 | QQQ | ETF | 36.38 | 36.38 | 36.12 | 36.22 | 17710600.0 |
| 2005-03-22 15:30:00 | QQQ | ETF | 36.22 | 36.26 | 36.11 | 36.12 | 15223900.0 |
| 2005-03-22 08:30:00 | IWM | ETF | 62.075 | 62.075 | 62.075 | 62.075 | 3000.0 |
| 2005-03-22 09:00:00 | IWM | ETF | 61.995 | 62.04 | 61.99 | 62.04 | 7000.0 |
| 2005-03-22 09:30:00 | IWM | ETF | 62.05 | 62.34 | 61.945 | 62.34 | 2493200.0 |
| 2005-03-22 10:00:00 | IWM | ETF | 62.345 | 62.44 | 62.275 | 62.39 | 1560600.0 |
| 2005-03-22 10:30:00 | IWM | ETF | 62.4 | 62.495 | 62.35 | 62.48 | 1799200.0 |
| 2005-03-22 11:00:00 | IWM | ETF | 62.49 | 62.49 | 62.4 | 62.4 | 1196800.0 |
| 2005-03-22 11:30:00 | IWM | ETF | 62.4 | 62.465 | 62.395 | 62.44 | 536400.0 |
| 2005-03-22 12:00:00 | IWM | ETF | 62.44 | 62.46 | 62.4 | 62.425 | 854200.0 |
| 2005-03-22 12:30:00 | IWM | ETF | 62.43 | 62.45 | 62.415 | 62.42 | 208400.0 |
| 2005-03-22 13:00:00 | IWM | ETF | 62.415 | 62.555 | 62.41 | 62.51 | 1024400.0 |
| 2005-03-22 13:30:00 | IWM | ETF | 62.51 | 62.665 | 62.5 | 62.6245 | 3202000.0 |
| 2005-03-22 14:00:00 | IWM | ETF | 62.625 | 62.755 | 62.395 | 62.425 | 5008600.0 |
| 2005-03-22 14:30:00 | IWM | ETF | 62.43 | 62.57 | 61.75 | 62.14 | 3881000.0 |
> showing 50 of 1,525 rows — these rows as CSV