PREVIEW / etf_30min / 2002-04-16
file: by_date/etf_30min/2002/2002-04-16.parquet size: 18 KB rows: 509
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-04-16 09:30:00 | SPY | ETF | 111.7 | 112.4 | 111.67 | 112.26 | 2414200.0 |
| 2002-04-16 10:00:00 | SPY | ETF | 112.28 | 112.51 | 112.25 | 112.48 | 1324300.0 |
| 2002-04-16 10:30:00 | SPY | ETF | 112.47 | 112.68 | 112.45 | 112.61 | 1489500.0 |
| 2002-04-16 11:00:00 | SPY | ETF | 112.55 | 112.88 | 112.55 | 112.64 | 920900.0 |
| 2002-04-16 11:30:00 | SPY | ETF | 112.69 | 112.8 | 112.63 | 112.66 | 582700.0 |
| 2002-04-16 12:00:00 | SPY | ETF | 112.65 | 112.79 | 112.62 | 112.7 | 452400.0 |
| 2002-04-16 12:30:00 | SPY | ETF | 112.67 | 112.9 | 112.53 | 112.6 | 803800.0 |
| 2002-04-16 13:00:00 | SPY | ETF | 112.6 | 112.73 | 112.55 | 112.69 | 500600.0 |
| 2002-04-16 13:30:00 | SPY | ETF | 112.69 | 112.95 | 112.65 | 112.82 | 488300.0 |
| 2002-04-16 14:00:00 | SPY | ETF | 112.83 | 112.96 | 112.76 | 112.81 | 386600.0 |
| 2002-04-16 14:30:00 | SPY | ETF | 112.83 | 113.09 | 112.75 | 113.06 | 622200.0 |
| 2002-04-16 15:00:00 | SPY | ETF | 113.01 | 113.32 | 113.0 | 113.16 | 1638500.0 |
| 2002-04-16 15:30:00 | SPY | ETF | 113.16 | 113.22 | 112.97 | 113.12 | 1190800.0 |
| 2002-04-16 16:00:00 | SPY | ETF | 113.09 | 113.34 | 112.64 | 113.34 | 1048700.0 |
| 2002-04-16 16:30:00 | SPY | ETF | 113.39 | 113.65 | 113.33 | 113.65 | 183100.0 |
| 2002-04-16 17:00:00 | SPY | ETF | 113.65 | 113.72 | 113.39 | 113.39 | 235800.0 |
| 2002-04-16 17:30:00 | SPY | ETF | 113.33 | 113.56 | 113.33 | 113.56 | 39500.0 |
| 2002-04-16 18:00:00 | SPY | ETF | 113.53 | 113.57 | 113.42 | 113.57 | 19800.0 |
| 2002-04-16 09:30:00 | QQQ | ETF | 34.43 | 34.74 | 34.41 | 34.68 | 14065300.0 |
| 2002-04-16 10:00:00 | QQQ | ETF | 34.67 | 34.93 | 34.61 | 34.9 | 10241700.0 |
| 2002-04-16 10:30:00 | QQQ | ETF | 34.9 | 34.98 | 34.83 | 34.9 | 8579600.0 |
| 2002-04-16 11:00:00 | QQQ | ETF | 34.9 | 35.07 | 34.86 | 34.96 | 4017000.0 |
| 2002-04-16 11:30:00 | QQQ | ETF | 34.95 | 35.04 | 34.91 | 34.93 | 2583600.0 |
| 2002-04-16 12:00:00 | QQQ | ETF | 34.93 | 35.02 | 34.88 | 34.91 | 2093700.0 |
| 2002-04-16 12:30:00 | QQQ | ETF | 34.91 | 35.02 | 34.87 | 34.94 | 2448500.0 |
| 2002-04-16 13:00:00 | QQQ | ETF | 34.92 | 34.97 | 34.86 | 34.94 | 1771700.0 |
| 2002-04-16 13:30:00 | QQQ | ETF | 34.93 | 35.05 | 34.91 | 35.02 | 2353400.0 |
| 2002-04-16 14:00:00 | QQQ | ETF | 35.0 | 35.1 | 34.97 | 35.01 | 2512700.0 |
| 2002-04-16 14:30:00 | QQQ | ETF | 35.01 | 35.18 | 34.96 | 35.14 | 3824800.0 |
| 2002-04-16 15:00:00 | QQQ | ETF | 35.13 | 35.22 | 35.1 | 35.12 | 3552100.0 |
| 2002-04-16 15:30:00 | QQQ | ETF | 35.12 | 35.17 | 34.99 | 35.15 | 5368400.0 |
| 2002-04-16 16:00:00 | QQQ | ETF | 35.15 | 35.58 | 34.2 | 35.58 | 2628600.0 |
| 2002-04-16 16:30:00 | QQQ | ETF | 35.58 | 35.7 | 35.44 | 35.66 | 2509900.0 |
| 2002-04-16 17:00:00 | QQQ | ETF | 35.68 | 35.74 | 35.3 | 35.38 | 1331800.0 |
| 2002-04-16 17:30:00 | QQQ | ETF | 35.37 | 35.5 | 35.37 | 35.45 | 182300.0 |
| 2002-04-16 18:00:00 | QQQ | ETF | 35.45 | 35.57 | 35.41 | 35.57 | 86800.0 |
| 2002-04-16 09:30:00 | IWM | ETF | 51.45 | 51.62 | 51.375 | 51.55 | 128400.0 |
| 2002-04-16 10:00:00 | IWM | ETF | 51.7 | 51.71 | 51.55 | 51.62 | 28400.0 |
| 2002-04-16 10:30:00 | IWM | ETF | 51.625 | 51.74 | 51.605 | 51.62 | 103000.0 |
| 2002-04-16 11:00:00 | IWM | ETF | 51.615 | 51.75 | 51.615 | 51.655 | 129200.0 |
| 2002-04-16 11:30:00 | IWM | ETF | 51.68 | 51.745 | 51.635 | 51.7 | 258000.0 |
| 2002-04-16 12:00:00 | IWM | ETF | 51.695 | 51.7 | 51.635 | 51.7 | 22000.0 |
| 2002-04-16 12:30:00 | IWM | ETF | 51.7 | 51.825 | 51.7 | 51.715 | 40800.0 |
| 2002-04-16 13:00:00 | IWM | ETF | 51.76 | 51.765 | 51.68 | 51.765 | 16000.0 |
| 2002-04-16 13:30:00 | IWM | ETF | 51.705 | 51.845 | 51.705 | 51.845 | 19800.0 |
| 2002-04-16 14:00:00 | IWM | ETF | 51.865 | 51.875 | 51.825 | 51.865 | 59200.0 |
| 2002-04-16 14:30:00 | IWM | ETF | 51.855 | 51.945 | 51.78 | 51.945 | 54200.0 |
| 2002-04-16 15:00:00 | IWM | ETF | 51.89 | 52.035 | 51.885 | 52.02 | 153200.0 |
| 2002-04-16 15:30:00 | IWM | ETF | 52.025 | 52.105 | 51.955 | 52.105 | 231000.0 |
| 2002-04-16 16:00:00 | IWM | ETF | 52.12 | 52.15 | 52.06 | 52.06 | 40600.0 |
> showing 50 of 509 rows — these rows as CSV