PREVIEW / etf_30min / 2004-03-25
file: by_date/etf_30min/2004/2004-03-25.parquet size: 35 KB rows: 1,161
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-25 08:00:00 | SPY | ETF | 110.11 | 110.11 | 110.03 | 110.05 | 29200.0 |
| 2004-03-25 08:30:00 | SPY | ETF | 110.11 | 110.14 | 110.04 | 110.07 | 47200.0 |
| 2004-03-25 09:00:00 | SPY | ETF | 110.04 | 110.14 | 110.03 | 110.09 | 28300.0 |
| 2004-03-25 09:30:00 | SPY | ETF | 110.08 | 110.2 | 109.95 | 110.0 | 4805100.0 |
| 2004-03-25 10:00:00 | SPY | ETF | 110.01 | 110.1 | 109.79 | 109.98 | 3079500.0 |
| 2004-03-25 10:30:00 | SPY | ETF | 109.97 | 110.26 | 109.86 | 110.14 | 2743300.0 |
| 2004-03-25 11:00:00 | SPY | ETF | 110.16 | 110.39 | 110.01 | 110.29 | 2349100.0 |
| 2004-03-25 11:30:00 | SPY | ETF | 110.3 | 110.43 | 110.22 | 110.35 | 1911700.0 |
| 2004-03-25 12:00:00 | SPY | ETF | 110.36 | 110.61 | 110.31 | 110.61 | 2077400.0 |
| 2004-03-25 12:30:00 | SPY | ETF | 110.62 | 110.87 | 110.52 | 110.72 | 3134300.0 |
| 2004-03-25 13:00:00 | SPY | ETF | 110.73 | 110.95 | 110.68 | 110.92 | 1478300.0 |
| 2004-03-25 13:30:00 | SPY | ETF | 110.91 | 110.98 | 110.78 | 110.98 | 3885900.0 |
| 2004-03-25 14:00:00 | SPY | ETF | 110.97 | 111.09 | 110.84 | 111.05 | 2574100.0 |
| 2004-03-25 14:30:00 | SPY | ETF | 111.02 | 111.07 | 110.81 | 110.91 | 3109200.0 |
| 2004-03-25 15:00:00 | SPY | ETF | 110.92 | 111.26 | 110.87 | 111.24 | 2470000.0 |
| 2004-03-25 15:30:00 | SPY | ETF | 111.23 | 111.3 | 111.0 | 111.11 | 3013600.0 |
| 2004-03-25 16:00:00 | SPY | ETF | 111.11 | 111.19 | 110.93 | 111.02 | 2521200.0 |
| 2004-03-25 16:30:00 | SPY | ETF | 111.02 | 111.06 | 111.0 | 111.06 | 76100.0 |
| 2004-03-25 17:00:00 | SPY | ETF | 111.01 | 111.08 | 111.01 | 111.07 | 20400.0 |
| 2004-03-25 17:30:00 | SPY | ETF | 111.07 | 111.1 | 111.07 | 111.1 | 3200.0 |
| 2004-03-25 18:00:00 | SPY | ETF | 111.06 | 111.08 | 111.05 | 111.06 | 105500.0 |
| 2004-03-25 18:30:00 | SPY | ETF | 111.06 | 111.08 | 111.06 | 111.08 | 1000.0 |
| 2004-03-25 19:00:00 | SPY | ETF | 111.06 | 111.09 | 111.06 | 111.09 | 6000.0 |
| 2004-03-25 19:30:00 | SPY | ETF | 111.08 | 111.09 | 111.01 | 111.03 | 5500.0 |
| 2004-03-25 08:00:00 | QQQ | ETF | 34.64 | 34.65 | 34.58 | 34.63 | 165900.0 |
| 2004-03-25 08:30:00 | QQQ | ETF | 34.64 | 34.65 | 34.58 | 34.6 | 310000.0 |
| 2004-03-25 09:00:00 | QQQ | ETF | 34.61 | 34.71 | 34.6 | 34.64 | 291700.0 |
| 2004-03-25 09:30:00 | QQQ | ETF | 34.65 | 34.85 | 34.63 | 34.76 | 18174900.0 |
| 2004-03-25 10:00:00 | QQQ | ETF | 34.75 | 34.87 | 34.663 | 34.85 | 10330500.0 |
| 2004-03-25 10:30:00 | QQQ | ETF | 34.836 | 34.96 | 34.79 | 34.94 | 7871600.0 |
| 2004-03-25 11:00:00 | QQQ | ETF | 34.95 | 35.0 | 34.88 | 34.97 | 6081300.0 |
| 2004-03-25 11:30:00 | QQQ | ETF | 34.97 | 35.02 | 34.93 | 34.99 | 4085600.0 |
| 2004-03-25 12:00:00 | QQQ | ETF | 34.9877 | 35.12 | 34.978 | 35.12 | 5554300.0 |
| 2004-03-25 12:30:00 | QQQ | ETF | 35.119 | 35.21 | 35.08 | 35.12 | 10514500.0 |
| 2004-03-25 13:00:00 | QQQ | ETF | 35.12 | 35.26 | 35.093 | 35.24 | 6189100.0 |
| 2004-03-25 13:30:00 | QQQ | ETF | 35.24 | 35.3 | 35.17 | 35.281 | 6862700.0 |
| 2004-03-25 14:00:00 | QQQ | ETF | 35.28 | 35.3 | 35.2 | 35.224 | 4975400.0 |
| 2004-03-25 14:30:00 | QQQ | ETF | 35.224 | 35.278 | 35.16 | 35.17 | 9326500.0 |
| 2004-03-25 15:00:00 | QQQ | ETF | 35.18 | 35.43 | 35.17 | 35.39 | 8781500.0 |
| 2004-03-25 15:30:00 | QQQ | ETF | 35.4 | 35.46 | 35.34 | 35.41 | 11397400.0 |
| 2004-03-25 16:00:00 | QQQ | ETF | 35.4 | 35.44 | 35.33 | 35.35 | 2818200.0 |
| 2004-03-25 16:30:00 | QQQ | ETF | 35.36 | 35.385 | 35.34 | 35.37 | 122500.0 |
| 2004-03-25 17:00:00 | QQQ | ETF | 35.38 | 35.43 | 35.37 | 35.426 | 416900.0 |
| 2004-03-25 17:30:00 | QQQ | ETF | 35.43 | 35.44 | 35.4 | 35.43 | 120400.0 |
| 2004-03-25 18:00:00 | QQQ | ETF | 35.4 | 35.42 | 35.37 | 35.38 | 14500.0 |
| 2004-03-25 18:30:00 | QQQ | ETF | 35.38 | 35.42 | 35.38 | 35.42 | 1800.0 |
| 2004-03-25 19:00:00 | QQQ | ETF | 35.42 | 35.42 | 35.4 | 35.4 | 5200.0 |
| 2004-03-25 19:30:00 | QQQ | ETF | 35.41 | 35.44 | 35.4 | 35.43 | 10700.0 |
| 2004-03-25 08:30:00 | IWM | ETF | 56.13 | 56.13 | 56.13 | 56.13 | 1000.0 |
| 2004-03-25 09:00:00 | IWM | ETF | 56.14 | 56.14 | 56.12 | 56.12 | 4000.0 |
> showing 50 of 1,161 rows — these rows as CSV