PREVIEW / etf_30min / 2004-03-22
file: by_date/etf_30min/2004/2004-03-22.parquet size: 37 KB rows: 1,228
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-22 08:00:00 | SPY | ETF | 110.16 | 110.32 | 110.16 | 110.32 | 36000.0 |
| 2004-03-22 08:30:00 | SPY | ETF | 110.33 | 110.41 | 110.33 | 110.41 | 39900.0 |
| 2004-03-22 09:00:00 | SPY | ETF | 110.42 | 110.54 | 110.31 | 110.53 | 95400.0 |
| 2004-03-22 09:30:00 | SPY | ETF | 110.54 | 110.57 | 109.91 | 109.93 | 6305700.0 |
| 2004-03-22 10:00:00 | SPY | ETF | 109.94 | 110.05 | 109.4 | 109.72 | 7406600.0 |
| 2004-03-22 10:30:00 | SPY | ETF | 109.71 | 110.07 | 109.59 | 110.03 | 3569900.0 |
| 2004-03-22 11:00:00 | SPY | ETF | 110.02 | 110.25 | 109.97 | 110.23 | 3612500.0 |
| 2004-03-22 11:30:00 | SPY | ETF | 110.23 | 110.34 | 109.88 | 110.05 | 3684100.0 |
| 2004-03-22 12:00:00 | SPY | ETF | 110.05 | 110.09 | 109.72 | 109.9 | 2243700.0 |
| 2004-03-22 12:30:00 | SPY | ETF | 109.9 | 110.06 | 109.84 | 110.0 | 1127500.0 |
| 2004-03-22 13:00:00 | SPY | ETF | 110.01 | 110.01 | 109.61 | 109.72 | 2004100.0 |
| 2004-03-22 13:30:00 | SPY | ETF | 109.76 | 109.89 | 109.5 | 109.65 | 2517500.0 |
| 2004-03-22 14:00:00 | SPY | ETF | 109.6 | 109.65 | 109.1 | 109.32 | 6797600.0 |
| 2004-03-22 14:30:00 | SPY | ETF | 109.3 | 109.82 | 109.28 | 109.52 | 4066300.0 |
| 2004-03-22 15:00:00 | SPY | ETF | 109.51 | 109.87 | 109.38 | 109.58 | 2893500.0 |
| 2004-03-22 15:30:00 | SPY | ETF | 109.58 | 109.87 | 109.42 | 109.75 | 3265800.0 |
| 2004-03-22 16:00:00 | SPY | ETF | 109.74 | 109.77 | 109.6 | 109.68 | 3889100.0 |
| 2004-03-22 16:30:00 | SPY | ETF | 109.68 | 109.71 | 109.63 | 109.7 | 10000.0 |
| 2004-03-22 17:00:00 | SPY | ETF | 109.68 | 109.72 | 109.62 | 109.7 | 46600.0 |
| 2004-03-22 17:30:00 | SPY | ETF | 109.7 | 109.7 | 109.68 | 109.68 | 5400.0 |
| 2004-03-22 18:00:00 | SPY | ETF | 109.68 | 109.68 | 109.68 | 109.68 | 500.0 |
| 2004-03-22 19:00:00 | SPY | ETF | 109.65 | 109.65 | 109.65 | 109.65 | 500.0 |
| 2004-03-22 19:30:00 | SPY | ETF | 109.62 | 109.62 | 109.6 | 109.6 | 1900.0 |
| 2004-03-22 08:00:00 | QQQ | ETF | 34.36 | 34.5 | 34.32 | 34.4 | 468700.0 |
| 2004-03-22 08:30:00 | QQQ | ETF | 34.4 | 34.48 | 34.4 | 34.47 | 205800.0 |
| 2004-03-22 09:00:00 | QQQ | ETF | 34.48 | 34.53 | 34.45 | 34.53 | 414000.0 |
| 2004-03-22 09:30:00 | QQQ | ETF | 34.53 | 34.55 | 34.31 | 34.33 | 18548600.0 |
| 2004-03-22 10:00:00 | QQQ | ETF | 34.33 | 34.37 | 34.17 | 34.26 | 12524400.0 |
| 2004-03-22 10:30:00 | QQQ | ETF | 34.261 | 34.4 | 34.2 | 34.36 | 9942300.0 |
| 2004-03-22 11:00:00 | QQQ | ETF | 34.382 | 34.44 | 34.34 | 34.44 | 8681900.0 |
| 2004-03-22 11:30:00 | QQQ | ETF | 34.42 | 34.47 | 34.28 | 34.37 | 5961500.0 |
| 2004-03-22 12:00:00 | QQQ | ETF | 34.342 | 34.37 | 34.19 | 34.2518 | 3604000.0 |
| 2004-03-22 12:30:00 | QQQ | ETF | 34.25 | 34.33 | 34.22 | 34.308 | 1967600.0 |
| 2004-03-22 13:00:00 | QQQ | ETF | 34.3 | 34.32 | 34.08 | 34.144 | 5533400.0 |
| 2004-03-22 13:30:00 | QQQ | ETF | 34.143 | 34.24 | 34.11 | 34.17 | 4985000.0 |
| 2004-03-22 14:00:00 | QQQ | ETF | 34.17 | 34.18 | 34.03 | 34.08 | 11203700.0 |
| 2004-03-22 14:30:00 | QQQ | ETF | 34.08 | 34.29 | 34.07 | 34.15 | 9617800.0 |
| 2004-03-22 15:00:00 | QQQ | ETF | 34.15 | 34.332 | 34.13 | 34.193 | 8139200.0 |
| 2004-03-22 15:30:00 | QQQ | ETF | 34.192 | 34.36 | 34.11 | 34.343 | 13984400.0 |
| 2004-03-22 16:00:00 | QQQ | ETF | 34.344 | 34.35 | 34.28 | 34.3 | 2877000.0 |
| 2004-03-22 16:30:00 | QQQ | ETF | 34.29 | 34.33 | 34.25 | 34.32 | 116600.0 |
| 2004-03-22 17:00:00 | QQQ | ETF | 34.32 | 34.34 | 34.29 | 34.3 | 422100.0 |
| 2004-03-22 17:30:00 | QQQ | ETF | 34.3 | 34.36 | 34.29 | 34.32 | 660900.0 |
| 2004-03-22 18:00:00 | QQQ | ETF | 34.3 | 34.32 | 34.3 | 34.3 | 19100.0 |
| 2004-03-22 18:30:00 | QQQ | ETF | 34.3 | 34.31 | 34.3 | 34.3 | 10700.0 |
| 2004-03-22 19:00:00 | QQQ | ETF | 34.32 | 34.32 | 34.28 | 34.28 | 6100.0 |
| 2004-03-22 19:30:00 | QQQ | ETF | 34.28 | 34.28 | 34.26 | 34.26 | 24100.0 |
| 2004-03-22 08:00:00 | IWM | ETF | 56.25 | 56.69 | 56.125 | 56.275 | 5200.0 |
| 2004-03-22 08:30:00 | IWM | ETF | 56.285 | 56.345 | 56.285 | 56.345 | 2000.0 |
| 2004-03-22 09:00:00 | IWM | ETF | 56.305 | 56.405 | 56.29 | 56.405 | 39400.0 |
> showing 50 of 1,228 rows — these rows as CSV