PREVIEW / etf_30min / 2004-05-18
file: by_date/etf_30min/2004/2004-05-18.parquet size: 34 KB rows: 1,160
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-18 08:00:00 | SPY | ETF | 109.68 | 109.78 | 109.67 | 109.68 | 38600.0 |
| 2004-05-18 08:30:00 | SPY | ETF | 109.67 | 109.7 | 109.55 | 109.61 | 67200.0 |
| 2004-05-18 09:00:00 | SPY | ETF | 109.61 | 109.61 | 109.5 | 109.5 | 57500.0 |
| 2004-05-18 09:30:00 | SPY | ETF | 109.49 | 109.72 | 109.33 | 109.44 | 4482200.0 |
| 2004-05-18 10:00:00 | SPY | ETF | 109.46 | 109.71 | 109.34 | 109.52 | 2717900.0 |
| 2004-05-18 10:30:00 | SPY | ETF | 109.53 | 109.9 | 109.45 | 109.78 | 2497500.0 |
| 2004-05-18 11:00:00 | SPY | ETF | 109.78 | 109.89 | 109.66 | 109.72 | 2017900.0 |
| 2004-05-18 11:30:00 | SPY | ETF | 109.71 | 109.8 | 109.64 | 109.72 | 1427200.0 |
| 2004-05-18 12:00:00 | SPY | ETF | 109.73 | 109.94 | 109.69 | 109.87 | 1706800.0 |
| 2004-05-18 12:30:00 | SPY | ETF | 109.87 | 109.92 | 109.73 | 109.76 | 965100.0 |
| 2004-05-18 13:00:00 | SPY | ETF | 109.76 | 109.81 | 109.6 | 109.74 | 1092500.0 |
| 2004-05-18 13:30:00 | SPY | ETF | 109.73 | 109.85 | 109.54 | 109.56 | 1416000.0 |
| 2004-05-18 14:00:00 | SPY | ETF | 109.56 | 109.87 | 109.51 | 109.81 | 1763700.0 |
| 2004-05-18 14:30:00 | SPY | ETF | 109.81 | 109.86 | 109.67 | 109.67 | 1267700.0 |
| 2004-05-18 15:00:00 | SPY | ETF | 109.68 | 109.79 | 109.6 | 109.76 | 1725400.0 |
| 2004-05-18 15:30:00 | SPY | ETF | 109.75 | 109.81 | 109.64 | 109.69 | 2949100.0 |
| 2004-05-18 16:00:00 | SPY | ETF | 109.69 | 109.77 | 109.56 | 109.61 | 1844200.0 |
| 2004-05-18 16:30:00 | SPY | ETF | 109.66 | 109.75 | 109.62 | 109.62 | 122500.0 |
| 2004-05-18 17:00:00 | SPY | ETF | 109.66 | 109.72 | 109.6 | 109.7 | 23400.0 |
| 2004-05-18 17:30:00 | SPY | ETF | 109.69 | 109.72 | 109.69 | 109.7 | 10100.0 |
| 2004-05-18 18:00:00 | SPY | ETF | 109.7 | 109.7 | 109.64 | 109.65 | 6100.0 |
| 2004-05-18 19:30:00 | SPY | ETF | 109.72 | 109.74 | 109.69 | 109.74 | 3400.0 |
| 2004-05-18 08:00:00 | QQQ | ETF | 34.66 | 34.73 | 34.65 | 34.69 | 163300.0 |
| 2004-05-18 08:30:00 | QQQ | ETF | 34.69 | 34.7 | 34.64 | 34.66 | 148400.0 |
| 2004-05-18 09:00:00 | QQQ | ETF | 34.65 | 34.68 | 34.65 | 34.65 | 129900.0 |
| 2004-05-18 09:30:00 | QQQ | ETF | 34.66 | 34.78 | 34.6 | 34.684 | 15641900.0 |
| 2004-05-18 10:00:00 | QQQ | ETF | 34.68 | 34.77 | 34.62 | 34.69 | 10341700.0 |
| 2004-05-18 10:30:00 | QQQ | ETF | 34.695 | 34.82 | 34.66 | 34.78 | 9029500.0 |
| 2004-05-18 11:00:00 | QQQ | ETF | 34.77 | 34.827 | 34.72 | 34.75 | 5567500.0 |
| 2004-05-18 11:30:00 | QQQ | ETF | 34.75 | 34.79 | 34.72 | 34.775 | 3463300.0 |
| 2004-05-18 12:00:00 | QQQ | ETF | 34.77 | 34.9 | 34.74 | 34.85 | 6667700.0 |
| 2004-05-18 12:30:00 | QQQ | ETF | 34.849 | 34.88 | 34.79 | 34.81 | 2816300.0 |
| 2004-05-18 13:00:00 | QQQ | ETF | 34.81 | 34.84 | 34.73 | 34.743 | 4053500.0 |
| 2004-05-18 13:30:00 | QQQ | ETF | 34.747 | 34.81 | 34.68 | 34.69 | 3391800.0 |
| 2004-05-18 14:00:00 | QQQ | ETF | 34.7 | 34.83 | 34.67 | 34.783 | 6352200.0 |
| 2004-05-18 14:30:00 | QQQ | ETF | 34.786 | 34.82 | 34.73 | 34.74 | 4450400.0 |
| 2004-05-18 15:00:00 | QQQ | ETF | 34.74 | 34.8 | 34.7 | 34.77 | 5383000.0 |
| 2004-05-18 15:30:00 | QQQ | ETF | 34.79 | 34.83 | 34.71 | 34.763 | 9297100.0 |
| 2004-05-18 16:00:00 | QQQ | ETF | 34.77 | 34.826 | 34.665 | 34.72 | 6683200.0 |
| 2004-05-18 16:30:00 | QQQ | ETF | 34.75 | 34.87 | 34.74 | 34.76 | 1196500.0 |
| 2004-05-18 17:00:00 | QQQ | ETF | 34.76 | 34.83 | 34.76 | 34.79 | 50400.0 |
| 2004-05-18 17:30:00 | QQQ | ETF | 34.8 | 34.83 | 34.79 | 34.8 | 14900.0 |
| 2004-05-18 18:00:00 | QQQ | ETF | 34.806 | 34.82 | 34.8 | 34.82 | 23100.0 |
| 2004-05-18 18:30:00 | QQQ | ETF | 34.82 | 34.82 | 34.8 | 34.8 | 1400.0 |
| 2004-05-18 19:00:00 | QQQ | ETF | 34.8 | 34.82 | 34.8 | 34.82 | 4300.0 |
| 2004-05-18 19:30:00 | QQQ | ETF | 34.82 | 34.83 | 34.81 | 34.81 | 8800.0 |
| 2004-05-18 08:30:00 | IWM | ETF | 54.01 | 54.03 | 53.95 | 53.95 | 6600.0 |
| 2004-05-18 09:00:00 | IWM | ETF | 53.93 | 53.99 | 53.85 | 53.855 | 13800.0 |
| 2004-05-18 09:30:00 | IWM | ETF | 53.785 | 53.93 | 53.515 | 53.605 | 1888200.0 |
| 2004-05-18 10:00:00 | IWM | ETF | 53.67 | 53.785 | 53.59 | 53.645 | 554000.0 |
> showing 50 of 1,160 rows — these rows as CSV