PREVIEW / etf_30min / 2004-04-28
file: by_date/etf_30min/2004/2004-04-28.parquet size: 37 KB rows: 1,209
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-04-28 08:00:00 | SPY | ETF | 113.93 | 114.01 | 113.87 | 113.9 | 4400.0 |
| 2004-04-28 08:30:00 | SPY | ETF | 113.9 | 113.9 | 113.8 | 113.83 | 77100.0 |
| 2004-04-28 09:00:00 | SPY | ETF | 113.82 | 113.87 | 113.77 | 113.87 | 113300.0 |
| 2004-04-28 09:30:00 | SPY | ETF | 113.89 | 113.9 | 113.27 | 113.53 | 5412700.0 |
| 2004-04-28 10:00:00 | SPY | ETF | 113.52 | 113.58 | 113.25 | 113.48 | 2931700.0 |
| 2004-04-28 10:30:00 | SPY | ETF | 113.49 | 113.5 | 113.12 | 113.19 | 3086400.0 |
| 2004-04-28 11:00:00 | SPY | ETF | 113.17 | 113.27 | 112.78 | 112.8 | 3196000.0 |
| 2004-04-28 11:30:00 | SPY | ETF | 112.8 | 113.13 | 112.75 | 113.09 | 3342900.0 |
| 2004-04-28 12:00:00 | SPY | ETF | 113.08 | 113.15 | 113.01 | 113.07 | 1254000.0 |
| 2004-04-28 12:30:00 | SPY | ETF | 113.07 | 113.31 | 113.04 | 113.28 | 1957100.0 |
| 2004-04-28 13:00:00 | SPY | ETF | 113.27 | 113.3 | 112.97 | 113.03 | 1087800.0 |
| 2004-04-28 13:30:00 | SPY | ETF | 113.05 | 113.08 | 112.82 | 113.05 | 2446900.0 |
| 2004-04-28 14:00:00 | SPY | ETF | 113.06 | 113.23 | 112.95 | 113.08 | 1428800.0 |
| 2004-04-28 14:30:00 | SPY | ETF | 113.09 | 113.28 | 112.75 | 112.86 | 2866900.0 |
| 2004-04-28 15:00:00 | SPY | ETF | 112.87 | 113.0 | 112.5 | 112.59 | 4026500.0 |
| 2004-04-28 15:30:00 | SPY | ETF | 112.58 | 112.82 | 112.54 | 112.58 | 4211900.0 |
| 2004-04-28 16:00:00 | SPY | ETF | 112.58 | 112.88 | 112.53 | 112.53 | 1987300.0 |
| 2004-04-28 16:30:00 | SPY | ETF | 112.6 | 112.8 | 112.6 | 112.74 | 120000.0 |
| 2004-04-28 17:00:00 | SPY | ETF | 112.7 | 112.78 | 112.69 | 112.74 | 173000.0 |
| 2004-04-28 17:30:00 | SPY | ETF | 112.76 | 112.76 | 112.72 | 112.72 | 500.0 |
| 2004-04-28 18:00:00 | SPY | ETF | 112.76 | 112.78 | 112.76 | 112.78 | 5300.0 |
| 2004-04-28 18:30:00 | SPY | ETF | 112.76 | 112.76 | 112.73 | 112.73 | 1500.0 |
| 2004-04-28 19:30:00 | SPY | ETF | 112.73 | 112.77 | 112.7 | 112.77 | 6500.0 |
| 2004-04-28 08:00:00 | QQQ | ETF | 36.78 | 36.78 | 36.7 | 36.75 | 149100.0 |
| 2004-04-28 08:30:00 | QQQ | ETF | 36.73 | 36.73 | 36.67 | 36.69 | 184900.0 |
| 2004-04-28 09:00:00 | QQQ | ETF | 36.69 | 36.71 | 36.68 | 36.71 | 103800.0 |
| 2004-04-28 09:30:00 | QQQ | ETF | 36.71 | 36.72 | 36.4 | 36.47 | 16846300.0 |
| 2004-04-28 10:00:00 | QQQ | ETF | 36.473 | 36.55 | 36.31 | 36.53 | 10765500.0 |
| 2004-04-28 10:30:00 | QQQ | ETF | 36.528 | 36.56 | 36.33 | 36.353 | 6677300.0 |
| 2004-04-28 11:00:00 | QQQ | ETF | 36.354 | 36.45 | 36.21 | 36.22 | 8061000.0 |
| 2004-04-28 11:30:00 | QQQ | ETF | 36.23 | 36.4 | 36.2 | 36.36 | 6528200.0 |
| 2004-04-28 12:00:00 | QQQ | ETF | 36.37 | 36.39 | 36.31 | 36.357 | 2907200.0 |
| 2004-04-28 12:30:00 | QQQ | ETF | 36.354 | 36.47 | 36.34 | 36.46 | 2576500.0 |
| 2004-04-28 13:00:00 | QQQ | ETF | 36.467 | 36.471 | 36.33 | 36.343 | 3302200.0 |
| 2004-04-28 13:30:00 | QQQ | ETF | 36.34 | 36.39 | 36.25 | 36.38 | 3504600.0 |
| 2004-04-28 14:00:00 | QQQ | ETF | 36.367 | 36.44 | 36.31 | 36.351 | 2662200.0 |
| 2004-04-28 14:30:00 | QQQ | ETF | 36.351 | 36.44 | 36.16 | 36.22 | 9019900.0 |
| 2004-04-28 15:00:00 | QQQ | ETF | 36.22 | 36.26 | 36.019 | 36.076 | 9815500.0 |
| 2004-04-28 15:30:00 | QQQ | ETF | 36.074 | 36.16 | 36.05 | 36.08 | 9638800.0 |
| 2004-04-28 16:00:00 | QQQ | ETF | 36.077 | 36.221 | 36.05 | 36.17 | 2516900.0 |
| 2004-04-28 16:30:00 | QQQ | ETF | 36.16 | 36.18 | 36.133 | 36.14 | 153800.0 |
| 2004-04-28 17:00:00 | QQQ | ETF | 36.14 | 36.16 | 36.13 | 36.16 | 78200.0 |
| 2004-04-28 17:30:00 | QQQ | ETF | 36.15 | 36.16 | 36.14 | 36.14 | 9000.0 |
| 2004-04-28 18:00:00 | QQQ | ETF | 36.14 | 36.16 | 36.14 | 36.15 | 15700.0 |
| 2004-04-28 18:30:00 | QQQ | ETF | 36.18 | 36.18 | 36.18 | 36.18 | 3000.0 |
| 2004-04-28 19:00:00 | QQQ | ETF | 36.18 | 36.18 | 36.15 | 36.16 | 4600.0 |
| 2004-04-28 19:30:00 | QQQ | ETF | 36.14 | 36.17 | 36.14 | 36.17 | 7200.0 |
| 2004-04-28 08:00:00 | IWM | ETF | 58.675 | 58.68 | 58.675 | 58.68 | 5000.0 |
| 2004-04-28 08:30:00 | IWM | ETF | 58.6 | 58.605 | 58.6 | 58.605 | 4000.0 |
| 2004-04-28 09:00:00 | IWM | ETF | 58.54 | 58.61 | 58.54 | 58.61 | 5400.0 |
> showing 50 of 1,209 rows — these rows as CSV