PREVIEW / etf_30min / 2002-07-08
file: by_date/etf_30min/2002/2002-07-08.parquet size: 18 KB rows: 505
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-08 09:30:00 | SPY | ETF | 98.98 | 99.7 | 98.58 | 98.67 | 3226500.0 |
| 2002-07-08 10:00:00 | SPY | ETF | 98.68 | 99.08 | 98.39 | 98.58 | 1944100.0 |
| 2002-07-08 10:30:00 | SPY | ETF | 98.52 | 98.78 | 98.07 | 98.23 | 1823400.0 |
| 2002-07-08 11:00:00 | SPY | ETF | 98.26 | 98.53 | 98.09 | 98.47 | 1116000.0 |
| 2002-07-08 11:30:00 | SPY | ETF | 98.45 | 98.49 | 97.8 | 97.94 | 1260300.0 |
| 2002-07-08 12:00:00 | SPY | ETF | 97.94 | 98.05 | 97.67 | 97.95 | 647400.0 |
| 2002-07-08 12:30:00 | SPY | ETF | 97.96 | 98.35 | 97.82 | 98.28 | 582900.0 |
| 2002-07-08 13:00:00 | SPY | ETF | 98.28 | 98.34 | 97.85 | 97.98 | 629400.0 |
| 2002-07-08 13:30:00 | SPY | ETF | 97.96 | 98.67 | 97.95 | 98.41 | 1025700.0 |
| 2002-07-08 14:00:00 | SPY | ETF | 98.42 | 98.78 | 98.21 | 98.35 | 845700.0 |
| 2002-07-08 14:30:00 | SPY | ETF | 98.42 | 98.5 | 97.82 | 98.03 | 1007400.0 |
| 2002-07-08 15:00:00 | SPY | ETF | 98.02 | 98.3 | 97.66 | 97.72 | 1251700.0 |
| 2002-07-08 15:30:00 | SPY | ETF | 97.73 | 98.18 | 97.56 | 98.03 | 1983500.0 |
| 2002-07-08 16:00:00 | SPY | ETF | 98.0 | 98.3 | 97.84 | 98.0 | 878000.0 |
| 2002-07-08 16:30:00 | SPY | ETF | 98.12 | 98.13 | 98.07 | 98.11 | 2000.0 |
| 2002-07-08 17:00:00 | SPY | ETF | 98.18 | 98.2 | 98.08 | 98.08 | 8300.0 |
| 2002-07-08 17:30:00 | SPY | ETF | 98.08 | 98.13 | 98.07 | 98.13 | 2100.0 |
| 2002-07-08 18:00:00 | SPY | ETF | 98.12 | 98.29 | 98.12 | 98.19 | 2200.0 |
| 2002-07-08 09:30:00 | QQQ | ETF | 26.2 | 26.53 | 25.82 | 25.89 | 16051600.0 |
| 2002-07-08 10:00:00 | QQQ | ETF | 25.89 | 26.04 | 25.6 | 25.75 | 11038600.0 |
| 2002-07-08 10:30:00 | QQQ | ETF | 25.74 | 25.87 | 25.53 | 25.62 | 9986400.0 |
| 2002-07-08 11:00:00 | QQQ | ETF | 25.64 | 25.74 | 25.53 | 25.67 | 5074200.0 |
| 2002-07-08 11:30:00 | QQQ | ETF | 25.66 | 25.72 | 25.42 | 25.51 | 4891200.0 |
| 2002-07-08 12:00:00 | QQQ | ETF | 25.51 | 25.6 | 25.42 | 25.54 | 3975100.0 |
| 2002-07-08 12:30:00 | QQQ | ETF | 25.54 | 25.68 | 25.45 | 25.64 | 2683000.0 |
| 2002-07-08 13:00:00 | QQQ | ETF | 25.63 | 25.67 | 25.4 | 25.46 | 4446100.0 |
| 2002-07-08 13:30:00 | QQQ | ETF | 25.44 | 25.78 | 25.43 | 25.66 | 5264000.0 |
| 2002-07-08 14:00:00 | QQQ | ETF | 25.66 | 25.81 | 25.59 | 25.69 | 5150300.0 |
| 2002-07-08 14:30:00 | QQQ | ETF | 25.67 | 25.73 | 25.35 | 25.41 | 6703000.0 |
| 2002-07-08 15:00:00 | QQQ | ETF | 25.42 | 25.51 | 25.14 | 25.16 | 8887400.0 |
| 2002-07-08 15:30:00 | QQQ | ETF | 25.2 | 25.39 | 25.08 | 25.25 | 8721300.0 |
| 2002-07-08 16:00:00 | QQQ | ETF | 25.25 | 25.42 | 25.21 | 25.31 | 3002500.0 |
| 2002-07-08 16:30:00 | QQQ | ETF | 25.34 | 25.46 | 25.3 | 25.43 | 88800.0 |
| 2002-07-08 17:00:00 | QQQ | ETF | 25.41 | 25.47 | 25.38 | 25.39 | 86300.0 |
| 2002-07-08 17:30:00 | QQQ | ETF | 25.4 | 25.43 | 25.37 | 25.43 | 58900.0 |
| 2002-07-08 18:00:00 | QQQ | ETF | 25.43 | 25.49 | 25.4 | 25.44 | 18700.0 |
| 2002-07-08 09:30:00 | IWM | ETF | 43.875 | 44.12 | 43.6 | 43.6 | 309400.0 |
| 2002-07-08 10:00:00 | IWM | ETF | 43.57 | 43.8 | 43.525 | 43.655 | 114000.0 |
| 2002-07-08 10:30:00 | IWM | ETF | 43.75 | 43.78 | 43.575 | 43.78 | 43000.0 |
| 2002-07-08 11:00:00 | IWM | ETF | 43.775 | 44.025 | 43.67 | 44.0 | 118000.0 |
| 2002-07-08 11:30:00 | IWM | ETF | 43.93 | 43.985 | 43.765 | 43.81 | 52000.0 |
| 2002-07-08 12:00:00 | IWM | ETF | 43.805 | 43.83 | 43.66 | 43.81 | 187600.0 |
| 2002-07-08 12:30:00 | IWM | ETF | 43.81 | 43.84 | 43.75 | 43.84 | 105800.0 |
| 2002-07-08 13:00:00 | IWM | ETF | 43.84 | 43.855 | 43.79 | 43.8 | 33600.0 |
| 2002-07-08 13:30:00 | IWM | ETF | 43.805 | 43.95 | 43.8 | 43.865 | 27600.0 |
| 2002-07-08 14:00:00 | IWM | ETF | 43.885 | 43.98 | 43.885 | 43.925 | 46200.0 |
| 2002-07-08 14:30:00 | IWM | ETF | 43.905 | 43.935 | 43.75 | 43.75 | 74600.0 |
| 2002-07-08 15:00:00 | IWM | ETF | 43.73 | 43.85 | 43.4 | 43.44 | 208000.0 |
| 2002-07-08 15:30:00 | IWM | ETF | 43.44 | 43.44 | 43.15 | 43.15 | 164600.0 |
| 2002-07-08 16:00:00 | IWM | ETF | 43.295 | 43.295 | 43.025 | 43.2 | 293400.0 |
> showing 50 of 505 rows — these rows as CSV