PREVIEW / etf_30min / 2002-05-16
file: by_date/etf_30min/2002/2002-05-16.parquet size: 18 KB rows: 500
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-05-16 09:30:00 | SPY | ETF | 109.7 | 109.97 | 109.33 | 109.55 | 2859900.0 |
| 2002-05-16 10:00:00 | SPY | ETF | 109.49 | 109.96 | 109.48 | 109.85 | 1717100.0 |
| 2002-05-16 10:30:00 | SPY | ETF | 109.82 | 110.28 | 109.69 | 110.2 | 1612200.0 |
| 2002-05-16 11:00:00 | SPY | ETF | 110.17 | 110.29 | 109.95 | 110.04 | 1053900.0 |
| 2002-05-16 11:30:00 | SPY | ETF | 110.04 | 110.14 | 110.0 | 110.03 | 320900.0 |
| 2002-05-16 12:00:00 | SPY | ETF | 110.0 | 110.0 | 109.58 | 109.62 | 1936200.0 |
| 2002-05-16 12:30:00 | SPY | ETF | 109.68 | 109.94 | 109.64 | 109.87 | 397900.0 |
| 2002-05-16 13:00:00 | SPY | ETF | 109.88 | 110.0 | 109.8 | 109.86 | 243100.0 |
| 2002-05-16 13:30:00 | SPY | ETF | 109.88 | 110.07 | 109.88 | 110.02 | 615700.0 |
| 2002-05-16 14:00:00 | SPY | ETF | 110.0 | 110.38 | 109.99 | 110.19 | 2659900.0 |
| 2002-05-16 14:30:00 | SPY | ETF | 110.21 | 110.43 | 110.19 | 110.31 | 857500.0 |
| 2002-05-16 15:00:00 | SPY | ETF | 110.27 | 110.27 | 109.95 | 110.21 | 1041000.0 |
| 2002-05-16 15:30:00 | SPY | ETF | 110.18 | 110.36 | 110.09 | 110.35 | 1971500.0 |
| 2002-05-16 16:00:00 | SPY | ETF | 110.29 | 110.48 | 109.97 | 109.97 | 10010700.0 |
| 2002-05-16 16:30:00 | SPY | ETF | 110.37 | 110.45 | 110.34 | 110.45 | 22400.0 |
| 2002-05-16 17:00:00 | SPY | ETF | 110.45 | 110.5 | 110.45 | 110.5 | 7200.0 |
| 2002-05-16 17:30:00 | SPY | ETF | 110.5 | 110.55 | 110.5 | 110.55 | 6500.0 |
| 2002-05-16 18:00:00 | SPY | ETF | 110.6 | 110.73 | 110.59 | 110.73 | 2400.0 |
| 2002-05-16 09:30:00 | QQQ | ETF | 32.54 | 32.79 | 32.22 | 32.35 | 12536400.0 |
| 2002-05-16 10:00:00 | QQQ | ETF | 32.33 | 32.74 | 32.23 | 32.63 | 7682700.0 |
| 2002-05-16 10:30:00 | QQQ | ETF | 32.63 | 32.86 | 32.43 | 32.76 | 8845900.0 |
| 2002-05-16 11:00:00 | QQQ | ETF | 32.76 | 32.81 | 32.5 | 32.53 | 4668400.0 |
| 2002-05-16 11:30:00 | QQQ | ETF | 32.54 | 32.64 | 32.48 | 32.49 | 2435600.0 |
| 2002-05-16 12:00:00 | QQQ | ETF | 32.51 | 32.53 | 32.25 | 32.4 | 6665200.0 |
| 2002-05-16 12:30:00 | QQQ | ETF | 32.4 | 32.57 | 32.36 | 32.45 | 1953600.0 |
| 2002-05-16 13:00:00 | QQQ | ETF | 32.45 | 32.65 | 32.4 | 32.57 | 3120500.0 |
| 2002-05-16 13:30:00 | QQQ | ETF | 32.56 | 32.65 | 32.49 | 32.57 | 2069100.0 |
| 2002-05-16 14:00:00 | QQQ | ETF | 32.6 | 32.85 | 32.52 | 32.59 | 6788100.0 |
| 2002-05-16 14:30:00 | QQQ | ETF | 32.59 | 32.75 | 32.56 | 32.66 | 3217000.0 |
| 2002-05-16 15:00:00 | QQQ | ETF | 32.65 | 32.67 | 32.45 | 32.56 | 3688100.0 |
| 2002-05-16 15:30:00 | QQQ | ETF | 32.56 | 32.76 | 32.55 | 32.75 | 5372600.0 |
| 2002-05-16 16:00:00 | QQQ | ETF | 32.75 | 33.09 | 32.73 | 32.85 | 5081000.0 |
| 2002-05-16 16:30:00 | QQQ | ETF | 32.83 | 32.96 | 32.4 | 32.93 | 246700.0 |
| 2002-05-16 17:00:00 | QQQ | ETF | 32.93 | 33.02 | 32.62 | 33.02 | 819400.0 |
| 2002-05-16 17:30:00 | QQQ | ETF | 32.98 | 33.0 | 32.95 | 32.99 | 50100.0 |
| 2002-05-16 18:00:00 | QQQ | ETF | 32.99 | 33.04 | 32.95 | 33.03 | 85600.0 |
| 2002-05-16 09:30:00 | IWM | ETF | 51.175 | 51.175 | 50.855 | 50.93 | 90600.0 |
| 2002-05-16 10:00:00 | IWM | ETF | 50.895 | 50.96 | 50.79 | 50.92 | 170400.0 |
| 2002-05-16 10:30:00 | IWM | ETF | 50.95 | 50.97 | 50.8 | 50.925 | 228200.0 |
| 2002-05-16 11:00:00 | IWM | ETF | 50.94 | 50.975 | 50.815 | 50.845 | 61000.0 |
| 2002-05-16 11:30:00 | IWM | ETF | 50.845 | 50.85 | 50.78 | 50.82 | 37000.0 |
| 2002-05-16 12:00:00 | IWM | ETF | 50.79 | 50.79 | 50.575 | 50.655 | 109200.0 |
| 2002-05-16 12:30:00 | IWM | ETF | 50.625 | 50.67 | 50.585 | 50.66 | 29000.0 |
| 2002-05-16 13:00:00 | IWM | ETF | 50.65 | 50.67 | 50.615 | 50.655 | 32400.0 |
| 2002-05-16 13:30:00 | IWM | ETF | 50.65 | 50.72 | 50.625 | 50.64 | 98200.0 |
| 2002-05-16 14:00:00 | IWM | ETF | 50.64 | 50.73 | 50.615 | 50.65 | 90400.0 |
| 2002-05-16 14:30:00 | IWM | ETF | 50.67 | 50.67 | 50.6 | 50.645 | 30400.0 |
| 2002-05-16 15:00:00 | IWM | ETF | 50.645 | 50.645 | 50.375 | 50.4 | 206400.0 |
| 2002-05-16 15:30:00 | IWM | ETF | 50.46 | 50.515 | 50.38 | 50.43 | 132800.0 |
| 2002-05-16 16:00:00 | IWM | ETF | 50.575 | 51.175 | 50.545 | 51.175 | 22200.0 |
> showing 50 of 500 rows — these rows as CSV