PREVIEW / etf_30min / 2004-04-12
file: by_date/etf_30min/2004/2004-04-12.parquet size: 34 KB rows: 1,206
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-12 08:00:00 | SPY | ETF | 114.7 | 114.76 | 114.7 | 114.74 | 22200.0 |
| 2004-04-12 08:30:00 | SPY | ETF | 114.72 | 114.72 | 114.65 | 114.69 | 4700.0 |
| 2004-04-12 09:00:00 | SPY | ETF | 114.69 | 114.69 | 114.48 | 114.56 | 41200.0 |
| 2004-04-12 09:30:00 | SPY | ETF | 114.58 | 114.83 | 114.57 | 114.8 | 2283800.0 |
| 2004-04-12 10:00:00 | SPY | ETF | 114.8 | 115.0 | 114.78 | 114.92 | 2831900.0 |
| 2004-04-12 10:30:00 | SPY | ETF | 114.92 | 115.08 | 114.91 | 115.06 | 1500700.0 |
| 2004-04-12 11:00:00 | SPY | ETF | 115.06 | 115.08 | 114.82 | 114.86 | 1301000.0 |
| 2004-04-12 11:30:00 | SPY | ETF | 114.89 | 114.92 | 114.76 | 114.9 | 969400.0 |
| 2004-04-12 12:00:00 | SPY | ETF | 114.9 | 114.97 | 114.84 | 114.93 | 540800.0 |
| 2004-04-12 12:30:00 | SPY | ETF | 114.89 | 114.93 | 114.79 | 114.82 | 556300.0 |
| 2004-04-12 13:00:00 | SPY | ETF | 114.82 | 114.89 | 114.64 | 114.7 | 912500.0 |
| 2004-04-12 13:30:00 | SPY | ETF | 114.7 | 114.8 | 114.67 | 114.77 | 634600.0 |
| 2004-04-12 14:00:00 | SPY | ETF | 114.79 | 114.92 | 114.74 | 114.82 | 1189300.0 |
| 2004-04-12 14:30:00 | SPY | ETF | 114.81 | 114.87 | 114.73 | 114.77 | 393500.0 |
| 2004-04-12 15:00:00 | SPY | ETF | 114.78 | 114.89 | 114.69 | 114.83 | 1182300.0 |
| 2004-04-12 15:30:00 | SPY | ETF | 114.83 | 114.95 | 114.79 | 114.85 | 1434200.0 |
| 2004-04-12 16:00:00 | SPY | ETF | 114.86 | 114.99 | 114.77 | 114.85 | 631500.0 |
| 2004-04-12 16:30:00 | SPY | ETF | 114.85 | 114.89 | 114.84 | 114.89 | 8400.0 |
| 2004-04-12 17:00:00 | SPY | ETF | 114.94 | 114.95 | 114.9 | 114.9 | 14700.0 |
| 2004-04-12 17:30:00 | SPY | ETF | 114.88 | 114.88 | 114.85 | 114.85 | 1400.0 |
| 2004-04-12 18:00:00 | SPY | ETF | 114.9 | 114.9 | 114.9 | 114.9 | 600.0 |
| 2004-04-12 19:00:00 | SPY | ETF | 114.87 | 115.02 | 114.87 | 114.98 | 11200.0 |
| 2004-04-12 08:00:00 | QQQ | ETF | 37.1 | 37.17 | 37.1 | 37.15 | 50400.0 |
| 2004-04-12 08:30:00 | QQQ | ETF | 37.16 | 37.16 | 37.12 | 37.13 | 72800.0 |
| 2004-04-12 09:00:00 | QQQ | ETF | 37.13 | 37.13 | 36.96 | 37.0 | 267100.0 |
| 2004-04-12 09:30:00 | QQQ | ETF | 37.027 | 37.11 | 36.98 | 37.06 | 5598600.0 |
| 2004-04-12 10:00:00 | QQQ | ETF | 37.061 | 37.2 | 37.06 | 37.14 | 6017100.0 |
| 2004-04-12 10:30:00 | QQQ | ETF | 37.15 | 37.22 | 37.14 | 37.2 | 2855400.0 |
| 2004-04-12 11:00:00 | QQQ | ETF | 37.2 | 37.22 | 37.1 | 37.144 | 3128300.0 |
| 2004-04-12 11:30:00 | QQQ | ETF | 37.143 | 37.18 | 37.07 | 37.17 | 2625500.0 |
| 2004-04-12 12:00:00 | QQQ | ETF | 37.17 | 37.19 | 37.11 | 37.153 | 1163300.0 |
| 2004-04-12 12:30:00 | QQQ | ETF | 37.152 | 37.17 | 37.11 | 37.13 | 2398900.0 |
| 2004-04-12 13:00:00 | QQQ | ETF | 37.13 | 37.16 | 37.07 | 37.09 | 2599600.0 |
| 2004-04-12 13:30:00 | QQQ | ETF | 37.09 | 37.13 | 37.09 | 37.13 | 1168300.0 |
| 2004-04-12 14:00:00 | QQQ | ETF | 37.13 | 37.19 | 37.11 | 37.15 | 2473900.0 |
| 2004-04-12 14:30:00 | QQQ | ETF | 37.14 | 37.17 | 37.09 | 37.09 | 2213500.0 |
| 2004-04-12 15:00:00 | QQQ | ETF | 37.103 | 37.18 | 37.07 | 37.153 | 3313500.0 |
| 2004-04-12 15:30:00 | QQQ | ETF | 37.15 | 37.24 | 37.14 | 37.16 | 5924800.0 |
| 2004-04-12 16:00:00 | QQQ | ETF | 37.13 | 37.203 | 37.13 | 37.16 | 3300600.0 |
| 2004-04-12 16:30:00 | QQQ | ETF | 37.16 | 37.19 | 37.04 | 37.19 | 38400.0 |
| 2004-04-12 17:00:00 | QQQ | ETF | 37.19 | 37.19 | 37.163 | 37.17 | 15700.0 |
| 2004-04-12 17:30:00 | QQQ | ETF | 37.17 | 37.19 | 37.16 | 37.17 | 23800.0 |
| 2004-04-12 18:00:00 | QQQ | ETF | 37.16 | 37.19 | 37.15 | 37.19 | 15700.0 |
| 2004-04-12 18:30:00 | QQQ | ETF | 37.19 | 37.19 | 37.19 | 37.19 | 2000.0 |
| 2004-04-12 19:00:00 | QQQ | ETF | 37.19 | 37.26 | 37.18 | 37.26 | 98100.0 |
| 2004-04-12 19:30:00 | QQQ | ETF | 37.24 | 37.25 | 37.18 | 37.2 | 13700.0 |
| 2004-04-12 09:30:00 | IWM | ETF | 59.65 | 60.0 | 59.65 | 60.0 | 549000.0 |
| 2004-04-12 10:00:00 | IWM | ETF | 60.0 | 60.145 | 59.97 | 59.97 | 574200.0 |
| 2004-04-12 10:30:00 | IWM | ETF | 59.99 | 60.055 | 59.945 | 59.99 | 189400.0 |
| 2004-04-12 11:00:00 | IWM | ETF | 59.965 | 59.975 | 59.755 | 59.82 | 929600.0 |
> showing 50 of 1,206 rows — these rows as CSV