PREVIEW / etf_30min / 2004-03-24
file: by_date/etf_30min/2004/2004-03-24.parquet size: 35 KB rows: 1,158
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 |
|---|---|---|---|---|---|---|---|
| 2004-03-24 08:00:00 | SPY | ETF | 109.53 | 109.66 | 109.5 | 109.55 | 64500.0 |
| 2004-03-24 08:30:00 | SPY | ETF | 109.6 | 109.6 | 109.34 | 109.54 | 65400.0 |
| 2004-03-24 09:00:00 | SPY | ETF | 109.56 | 109.68 | 109.56 | 109.62 | 14700.0 |
| 2004-03-24 09:30:00 | SPY | ETF | 109.64 | 109.95 | 109.43 | 109.7 | 5446800.0 |
| 2004-03-24 10:00:00 | SPY | ETF | 109.7 | 109.83 | 109.38 | 109.6 | 3351900.0 |
| 2004-03-24 10:30:00 | SPY | ETF | 109.58 | 109.73 | 109.19 | 109.35 | 3757500.0 |
| 2004-03-24 11:00:00 | SPY | ETF | 109.33 | 109.69 | 108.85 | 109.63 | 8101200.0 |
| 2004-03-24 11:30:00 | SPY | ETF | 109.6 | 109.77 | 109.41 | 109.75 | 2528000.0 |
| 2004-03-24 12:00:00 | SPY | ETF | 109.74 | 110.0 | 109.72 | 109.98 | 2478000.0 |
| 2004-03-24 12:30:00 | SPY | ETF | 109.99 | 110.14 | 109.83 | 109.92 | 2547700.0 |
| 2004-03-24 13:00:00 | SPY | ETF | 109.92 | 109.96 | 109.73 | 109.91 | 2632800.0 |
| 2004-03-24 13:30:00 | SPY | ETF | 109.93 | 109.94 | 109.62 | 109.85 | 1075100.0 |
| 2004-03-24 14:00:00 | SPY | ETF | 109.85 | 109.88 | 109.55 | 109.69 | 2223000.0 |
| 2004-03-24 14:30:00 | SPY | ETF | 109.68 | 109.78 | 109.4 | 109.51 | 1549100.0 |
| 2004-03-24 15:00:00 | SPY | ETF | 109.52 | 109.56 | 109.15 | 109.28 | 2653600.0 |
| 2004-03-24 15:30:00 | SPY | ETF | 109.28 | 109.56 | 109.0 | 109.41 | 3806500.0 |
| 2004-03-24 16:00:00 | SPY | ETF | 109.41 | 109.6 | 109.36 | 109.6 | 1588400.0 |
| 2004-03-24 16:30:00 | SPY | ETF | 109.55 | 109.66 | 109.55 | 109.57 | 57100.0 |
| 2004-03-24 17:00:00 | SPY | ETF | 109.51 | 109.54 | 109.42 | 109.48 | 240500.0 |
| 2004-03-24 17:30:00 | SPY | ETF | 109.48 | 109.48 | 109.39 | 109.47 | 3200.0 |
| 2004-03-24 18:00:00 | SPY | ETF | 109.48 | 109.55 | 109.48 | 109.49 | 6500.0 |
| 2004-03-24 18:30:00 | SPY | ETF | 109.52 | 109.52 | 109.52 | 109.52 | 600.0 |
| 2004-03-24 19:00:00 | SPY | ETF | 109.55 | 109.55 | 109.55 | 109.55 | 100.0 |
| 2004-03-24 19:30:00 | SPY | ETF | 109.57 | 109.57 | 109.57 | 109.57 | 400.0 |
| 2004-03-24 08:00:00 | QQQ | ETF | 34.07 | 34.13 | 34.06 | 34.1 | 209400.0 |
| 2004-03-24 08:30:00 | QQQ | ETF | 34.09 | 34.12 | 34.02 | 34.12 | 114700.0 |
| 2004-03-24 09:00:00 | QQQ | ETF | 34.12 | 34.18 | 34.12 | 34.15 | 264800.0 |
| 2004-03-24 09:30:00 | QQQ | ETF | 34.15 | 34.296 | 34.09 | 34.25 | 10876700.0 |
| 2004-03-24 10:00:00 | QQQ | ETF | 34.247 | 34.33 | 34.078 | 34.242 | 12359300.0 |
| 2004-03-24 10:30:00 | QQQ | ETF | 34.22 | 34.34 | 34.13 | 34.176 | 7026700.0 |
| 2004-03-24 11:00:00 | QQQ | ETF | 34.17 | 34.33 | 34.01 | 34.28 | 11222600.0 |
| 2004-03-24 11:30:00 | QQQ | ETF | 34.283 | 34.39 | 34.23 | 34.38 | 6567300.0 |
| 2004-03-24 12:00:00 | QQQ | ETF | 34.38 | 34.54 | 34.37 | 34.51 | 7582200.0 |
| 2004-03-24 12:30:00 | QQQ | ETF | 34.52 | 34.63 | 34.49 | 34.528 | 7403400.0 |
| 2004-03-24 13:00:00 | QQQ | ETF | 34.53 | 34.56 | 34.41 | 34.546 | 6651000.0 |
| 2004-03-24 13:30:00 | QQQ | ETF | 34.55 | 34.61 | 34.43 | 34.56 | 3187300.0 |
| 2004-03-24 14:00:00 | QQQ | ETF | 34.56 | 34.59 | 34.44 | 34.479 | 4414000.0 |
| 2004-03-24 14:30:00 | QQQ | ETF | 34.48 | 34.52 | 34.38 | 34.44 | 4198800.0 |
| 2004-03-24 15:00:00 | QQQ | ETF | 34.43 | 34.48 | 34.26 | 34.36 | 6483800.0 |
| 2004-03-24 15:30:00 | QQQ | ETF | 34.352 | 34.46 | 34.22 | 34.41 | 9698400.0 |
| 2004-03-24 16:00:00 | QQQ | ETF | 34.41 | 34.45 | 34.36 | 34.4 | 2493000.0 |
| 2004-03-24 16:30:00 | QQQ | ETF | 34.407 | 34.44 | 34.39 | 34.43 | 465700.0 |
| 2004-03-24 17:00:00 | QQQ | ETF | 34.42 | 34.42 | 34.33 | 34.36 | 1157700.0 |
| 2004-03-24 17:30:00 | QQQ | ETF | 34.37 | 34.37 | 34.32 | 34.35 | 106800.0 |
| 2004-03-24 18:00:00 | QQQ | ETF | 34.35 | 34.38 | 34.337 | 34.34 | 30000.0 |
| 2004-03-24 18:30:00 | QQQ | ETF | 34.34 | 34.37 | 34.34 | 34.36 | 35200.0 |
| 2004-03-24 19:00:00 | QQQ | ETF | 34.36 | 34.38 | 34.36 | 34.38 | 22600.0 |
| 2004-03-24 19:30:00 | QQQ | ETF | 34.37 | 34.38 | 34.36 | 34.38 | 7600.0 |
| 2004-03-24 08:00:00 | IWM | ETF | 56.0 | 56.0 | 56.0 | 56.0 | 2200.0 |
| 2004-03-24 08:30:00 | IWM | ETF | 56.02 | 56.02 | 55.89 | 55.9 | 28400.0 |
> showing 50 of 1,158 rows — these rows as CSV