PREVIEW / etf_30min / 2004-05-14
file: by_date/etf_30min/2004/2004-05-14.parquet size: 35 KB rows: 1,137
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-05-14 08:00:00 | SPY | ETF | 109.51 | 109.51 | 109.22 | 109.45 | 159700.0 |
| 2004-05-14 08:30:00 | SPY | ETF | 109.45 | 109.71 | 109.18 | 109.65 | 881200.0 |
| 2004-05-14 09:00:00 | SPY | ETF | 109.68 | 110.0 | 109.65 | 109.96 | 787200.0 |
| 2004-05-14 09:30:00 | SPY | ETF | 109.96 | 110.44 | 109.68 | 109.74 | 7568800.0 |
| 2004-05-14 10:00:00 | SPY | ETF | 109.75 | 109.8 | 109.27 | 109.57 | 6312300.0 |
| 2004-05-14 10:30:00 | SPY | ETF | 109.56 | 110.28 | 109.5 | 110.16 | 3958000.0 |
| 2004-05-14 11:00:00 | SPY | ETF | 110.19 | 110.265 | 109.9 | 109.92 | 2633000.0 |
| 2004-05-14 11:30:00 | SPY | ETF | 109.92 | 109.94 | 109.67 | 109.79 | 2113500.0 |
| 2004-05-14 12:00:00 | SPY | ETF | 109.79 | 110.25 | 109.75 | 110.17 | 2266300.0 |
| 2004-05-14 12:30:00 | SPY | ETF | 110.18 | 110.43 | 109.97 | 110.3 | 1416900.0 |
| 2004-05-14 13:00:00 | SPY | ETF | 110.31 | 110.7 | 110.27 | 110.38 | 4606600.0 |
| 2004-05-14 13:30:00 | SPY | ETF | 110.39 | 110.5 | 110.23 | 110.36 | 1634100.0 |
| 2004-05-14 14:00:00 | SPY | ETF | 110.36 | 110.74 | 110.3 | 110.52 | 2571400.0 |
| 2004-05-14 14:30:00 | SPY | ETF | 110.49 | 110.56 | 110.27 | 110.35 | 2806000.0 |
| 2004-05-14 15:00:00 | SPY | ETF | 110.36 | 110.36 | 109.99 | 110.17 | 3007100.0 |
| 2004-05-14 15:30:00 | SPY | ETF | 110.16 | 110.27 | 109.93 | 110.04 | 2794200.0 |
| 2004-05-14 16:00:00 | SPY | ETF | 110.02 | 110.15 | 109.94 | 110.02 | 1340700.0 |
| 2004-05-14 16:30:00 | SPY | ETF | 110.02 | 110.14 | 110.01 | 110.06 | 240600.0 |
| 2004-05-14 17:00:00 | SPY | ETF | 110.08 | 110.12 | 110.08 | 110.12 | 600.0 |
| 2004-05-14 18:00:00 | SPY | ETF | 110.05 | 110.05 | 110.05 | 110.05 | 500.0 |
| 2004-05-14 18:30:00 | SPY | ETF | 110.0 | 110.0 | 109.95 | 109.95 | 800.0 |
| 2004-05-14 19:00:00 | SPY | ETF | 110.03 | 110.03 | 110.03 | 110.03 | 1000.0 |
| 2004-05-14 19:30:00 | SPY | ETF | 110.05 | 110.05 | 110.05 | 110.05 | 500.0 |
| 2004-05-14 08:00:00 | QQQ | ETF | 34.95 | 34.95 | 34.86 | 34.93 | 168500.0 |
| 2004-05-14 08:30:00 | QQQ | ETF | 34.91 | 35.11 | 34.84 | 35.08 | 704000.0 |
| 2004-05-14 09:00:00 | QQQ | ETF | 35.07 | 35.25 | 35.06 | 35.21 | 454000.0 |
| 2004-05-14 09:30:00 | QQQ | ETF | 35.2 | 35.314 | 34.76 | 34.838 | 23224000.0 |
| 2004-05-14 10:00:00 | QQQ | ETF | 34.838 | 34.84 | 34.649 | 34.73 | 17872300.0 |
| 2004-05-14 10:30:00 | QQQ | ETF | 34.73 | 35.05 | 34.7 | 34.958 | 12973700.0 |
| 2004-05-14 11:00:00 | QQQ | ETF | 34.96 | 35.01 | 34.81 | 34.836 | 7458500.0 |
| 2004-05-14 11:30:00 | QQQ | ETF | 34.833 | 34.85 | 34.7 | 34.78 | 6288400.0 |
| 2004-05-14 12:00:00 | QQQ | ETF | 34.779 | 34.93 | 34.75 | 34.93 | 6182500.0 |
| 2004-05-14 12:30:00 | QQQ | ETF | 34.917 | 35.04 | 34.85 | 34.98 | 5111600.0 |
| 2004-05-14 13:00:00 | QQQ | ETF | 34.975 | 35.15 | 34.95 | 35.004 | 8364300.0 |
| 2004-05-14 13:30:00 | QQQ | ETF | 35.01 | 35.09 | 34.95 | 35.03 | 5337700.0 |
| 2004-05-14 14:00:00 | QQQ | ETF | 35.031 | 35.26 | 35.0 | 35.17 | 8158500.0 |
| 2004-05-14 14:30:00 | QQQ | ETF | 35.16 | 35.19 | 34.97 | 35.0 | 5259100.0 |
| 2004-05-14 15:00:00 | QQQ | ETF | 35.0 | 35.003 | 34.82 | 34.907 | 7560200.0 |
| 2004-05-14 15:30:00 | QQQ | ETF | 34.903 | 34.942 | 34.78 | 34.8 | 10399800.0 |
| 2004-05-14 16:00:00 | QQQ | ETF | 34.8 | 34.91 | 34.73 | 34.81 | 2657000.0 |
| 2004-05-14 16:30:00 | QQQ | ETF | 34.81 | 34.83 | 34.78 | 34.8 | 302800.0 |
| 2004-05-14 17:00:00 | QQQ | ETF | 34.8 | 34.81 | 34.765 | 34.81 | 52700.0 |
| 2004-05-14 17:30:00 | QQQ | ETF | 34.81 | 34.82 | 34.78 | 34.8 | 39900.0 |
| 2004-05-14 18:00:00 | QQQ | ETF | 34.81 | 34.82 | 34.8 | 34.8 | 25800.0 |
| 2004-05-14 18:30:00 | QQQ | ETF | 34.83 | 34.83 | 34.82 | 34.82 | 1400.0 |
| 2004-05-14 19:00:00 | QQQ | ETF | 34.82 | 34.83 | 34.82 | 34.83 | 6700.0 |
| 2004-05-14 19:30:00 | QQQ | ETF | 34.83 | 34.84 | 34.81 | 34.81 | 6900.0 |
| 2004-05-14 08:00:00 | IWM | ETF | 53.935 | 53.935 | 53.935 | 53.935 | 1000.0 |
| 2004-05-14 08:30:00 | IWM | ETF | 54.0 | 54.05 | 53.9 | 54.05 | 8600.0 |
| 2004-05-14 09:00:00 | IWM | ETF | 54.21 | 54.21 | 54.21 | 54.21 | 2000.0 |
> showing 50 of 1,137 rows — these rows as CSV