PREVIEW / etf_30min / 2004-02-13
file: by_date/etf_30min/2004/2004-02-13.parquet size: 35 KB rows: 1,197
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-02-13 08:00:00 | SPY | ETF | 115.86 | 115.94 | 115.86 | 115.92 | 2400.0 |
| 2004-02-13 08:30:00 | SPY | ETF | 115.86 | 115.9 | 115.85 | 115.85 | 1900.0 |
| 2004-02-13 09:00:00 | SPY | ETF | 115.8 | 115.84 | 115.79 | 115.83 | 8500.0 |
| 2004-02-13 09:30:00 | SPY | ETF | 115.82 | 116.14 | 115.62 | 116.14 | 9519300.0 |
| 2004-02-13 10:00:00 | SPY | ETF | 116.08 | 116.2 | 115.6 | 115.73 | 5236800.0 |
| 2004-02-13 10:30:00 | SPY | ETF | 115.72 | 115.74 | 115.03 | 115.13 | 4541300.0 |
| 2004-02-13 11:00:00 | SPY | ETF | 115.12 | 115.31 | 115.07 | 115.19 | 1974100.0 |
| 2004-02-13 11:30:00 | SPY | ETF | 115.2 | 115.39 | 115.09 | 115.1 | 2594300.0 |
| 2004-02-13 12:00:00 | SPY | ETF | 115.11 | 115.24 | 114.75 | 114.88 | 4749800.0 |
| 2004-02-13 12:30:00 | SPY | ETF | 114.96 | 115.04 | 114.81 | 115.0 | 1227300.0 |
| 2004-02-13 13:00:00 | SPY | ETF | 115.0 | 115.12 | 114.94 | 114.96 | 1090700.0 |
| 2004-02-13 13:30:00 | SPY | ETF | 114.96 | 115.07 | 114.94 | 115.02 | 1117300.0 |
| 2004-02-13 14:00:00 | SPY | ETF | 115.04 | 115.25 | 115.0 | 115.21 | 1813200.0 |
| 2004-02-13 14:30:00 | SPY | ETF | 115.2 | 115.23 | 114.95 | 114.96 | 1146000.0 |
| 2004-02-13 15:00:00 | SPY | ETF | 114.97 | 115.05 | 114.89 | 115.02 | 1386800.0 |
| 2004-02-13 15:30:00 | SPY | ETF | 115.02 | 115.16 | 114.97 | 115.12 | 2280300.0 |
| 2004-02-13 16:00:00 | SPY | ETF | 115.12 | 115.14 | 114.62 | 115.08 | 1120400.0 |
| 2004-02-13 16:30:00 | SPY | ETF | 115.02 | 115.08 | 114.94 | 114.96 | 36200.0 |
| 2004-02-13 17:00:00 | SPY | ETF | 114.91 | 115.0 | 114.9 | 115.0 | 14800.0 |
| 2004-02-13 17:30:00 | SPY | ETF | 115.0 | 115.0 | 114.96 | 115.0 | 1600.0 |
| 2004-02-13 18:00:00 | SPY | ETF | 114.98 | 115.0 | 114.98 | 115.0 | 1000.0 |
| 2004-02-13 08:00:00 | QQQ | ETF | 37.4 | 37.44 | 37.39 | 37.4 | 31600.0 |
| 2004-02-13 08:30:00 | QQQ | ETF | 37.4 | 37.42 | 37.37 | 37.37 | 133200.0 |
| 2004-02-13 09:00:00 | QQQ | ETF | 37.37 | 37.4 | 37.34 | 37.39 | 170500.0 |
| 2004-02-13 09:30:00 | QQQ | ETF | 37.39 | 37.558 | 37.35 | 37.55 | 12994100.0 |
| 2004-02-13 10:00:00 | QQQ | ETF | 37.55 | 37.58 | 37.28 | 37.35 | 9426300.0 |
| 2004-02-13 10:30:00 | QQQ | ETF | 37.35 | 37.36 | 36.92 | 36.993 | 16594100.0 |
| 2004-02-13 11:00:00 | QQQ | ETF | 36.993 | 37.08 | 36.97 | 36.99 | 5828300.0 |
| 2004-02-13 11:30:00 | QQQ | ETF | 37.024 | 37.11 | 36.97 | 36.98 | 5408400.0 |
| 2004-02-13 12:00:00 | QQQ | ETF | 36.97 | 37.0 | 36.767 | 36.806 | 7506100.0 |
| 2004-02-13 12:30:00 | QQQ | ETF | 36.8 | 36.891 | 36.76 | 36.873 | 4374500.0 |
| 2004-02-13 13:00:00 | QQQ | ETF | 36.875 | 36.93 | 36.869 | 36.87 | 2335200.0 |
| 2004-02-13 13:30:00 | QQQ | ETF | 36.88 | 36.92 | 36.86 | 36.904 | 2400000.0 |
| 2004-02-13 14:00:00 | QQQ | ETF | 36.904 | 36.99 | 36.89 | 36.98 | 4430600.0 |
| 2004-02-13 14:30:00 | QQQ | ETF | 36.99 | 37.0 | 36.88 | 36.892 | 2620300.0 |
| 2004-02-13 15:00:00 | QQQ | ETF | 36.893 | 36.94 | 36.87 | 36.93 | 3256900.0 |
| 2004-02-13 15:30:00 | QQQ | ETF | 36.93 | 37.02 | 36.92 | 36.96 | 5483100.0 |
| 2004-02-13 16:00:00 | QQQ | ETF | 36.96 | 36.99 | 36.91 | 36.96 | 2726000.0 |
| 2004-02-13 16:30:00 | QQQ | ETF | 36.95 | 36.96 | 36.91 | 36.947 | 117500.0 |
| 2004-02-13 17:00:00 | QQQ | ETF | 36.94 | 36.95 | 36.93 | 36.95 | 57100.0 |
| 2004-02-13 17:30:00 | QQQ | ETF | 36.93 | 36.94 | 36.92 | 36.94 | 18400.0 |
| 2004-02-13 18:00:00 | QQQ | ETF | 36.94 | 36.96 | 36.94 | 36.96 | 15700.0 |
| 2004-02-13 18:30:00 | QQQ | ETF | 36.96 | 36.96 | 36.94 | 36.95 | 5200.0 |
| 2004-02-13 19:00:00 | QQQ | ETF | 36.97 | 36.97 | 36.97 | 36.97 | 4300.0 |
| 2004-02-13 19:30:00 | QQQ | ETF | 36.99 | 36.99 | 36.98 | 36.98 | 2800.0 |
| 2004-02-13 08:30:00 | IWM | ETF | 59.18 | 59.185 | 59.18 | 59.185 | 1400.0 |
| 2004-02-13 09:00:00 | IWM | ETF | 59.095 | 59.125 | 59.095 | 59.11 | 17000.0 |
| 2004-02-13 09:30:00 | IWM | ETF | 59.1135 | 59.25 | 58.965 | 59.25 | 1451600.0 |
| 2004-02-13 10:00:00 | IWM | ETF | 59.25 | 59.37 | 58.95 | 59.03 | 555800.0 |
| 2004-02-13 10:30:00 | IWM | ETF | 59.025 | 59.025 | 58.425 | 58.525 | 1100000.0 |
> showing 50 of 1,197 rows — these rows as CSV