PREVIEW / etf_30min / 2002-06-05
file: by_date/etf_30min/2002/2002-06-05.parquet size: 18 KB rows: 503
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-06-05 09:30:00 | SPY | ETF | 104.95 | 105.08 | 104.63 | 105.07 | 2857100.0 |
| 2002-06-05 10:00:00 | SPY | ETF | 105.05 | 105.55 | 104.87 | 105.04 | 2160300.0 |
| 2002-06-05 10:30:00 | SPY | ETF | 105.06 | 105.17 | 104.78 | 104.86 | 1300500.0 |
| 2002-06-05 11:00:00 | SPY | ETF | 104.88 | 105.13 | 104.5 | 104.58 | 976000.0 |
| 2002-06-05 11:30:00 | SPY | ETF | 104.6 | 104.74 | 104.35 | 104.57 | 908700.0 |
| 2002-06-05 12:00:00 | SPY | ETF | 104.58 | 104.75 | 104.48 | 104.68 | 516400.0 |
| 2002-06-05 12:30:00 | SPY | ETF | 104.65 | 105.06 | 104.65 | 104.95 | 829000.0 |
| 2002-06-05 13:00:00 | SPY | ETF | 104.91 | 105.16 | 104.77 | 105.1 | 435900.0 |
| 2002-06-05 13:30:00 | SPY | ETF | 105.11 | 105.26 | 104.76 | 104.93 | 498900.0 |
| 2002-06-05 14:00:00 | SPY | ETF | 104.95 | 105.16 | 104.81 | 105.06 | 551700.0 |
| 2002-06-05 14:30:00 | SPY | ETF | 105.07 | 105.2 | 104.83 | 105.05 | 798900.0 |
| 2002-06-05 15:00:00 | SPY | ETF | 105.03 | 105.45 | 104.94 | 105.33 | 1046900.0 |
| 2002-06-05 15:30:00 | SPY | ETF | 105.32 | 105.62 | 105.22 | 105.5 | 2224100.0 |
| 2002-06-05 16:00:00 | SPY | ETF | 105.47 | 105.67 | 105.32 | 105.58 | 1396400.0 |
| 2002-06-05 16:30:00 | SPY | ETF | 105.6 | 105.69 | 105.6 | 105.63 | 9900.0 |
| 2002-06-05 17:00:00 | SPY | ETF | 105.68 | 105.68 | 105.63 | 105.63 | 22500.0 |
| 2002-06-05 17:30:00 | SPY | ETF | 105.66 | 105.66 | 105.66 | 105.66 | 100.0 |
| 2002-06-05 18:00:00 | SPY | ETF | 105.69 | 105.69 | 105.55 | 105.68 | 600.0 |
| 2002-06-05 09:30:00 | QQQ | ETF | 29.42 | 29.68 | 29.2 | 29.49 | 14168900.0 |
| 2002-06-05 10:00:00 | QQQ | ETF | 29.49 | 29.8 | 29.36 | 29.51 | 13580100.0 |
| 2002-06-05 10:30:00 | QQQ | ETF | 29.5 | 29.6 | 29.27 | 29.3 | 6035900.0 |
| 2002-06-05 11:00:00 | QQQ | ETF | 29.29 | 29.44 | 29.05 | 29.07 | 5783100.0 |
| 2002-06-05 11:30:00 | QQQ | ETF | 29.19 | 29.19 | 28.98 | 29.12 | 5904500.0 |
| 2002-06-05 12:00:00 | QQQ | ETF | 29.12 | 29.2 | 28.97 | 29.16 | 3309100.0 |
| 2002-06-05 12:30:00 | QQQ | ETF | 29.17 | 29.33 | 29.14 | 29.24 | 3910000.0 |
| 2002-06-05 13:00:00 | QQQ | ETF | 29.24 | 29.39 | 29.11 | 29.36 | 2752900.0 |
| 2002-06-05 13:30:00 | QQQ | ETF | 29.35 | 29.45 | 29.16 | 29.22 | 3669900.0 |
| 2002-06-05 14:00:00 | QQQ | ETF | 29.22 | 29.34 | 29.15 | 29.29 | 3138400.0 |
| 2002-06-05 14:30:00 | QQQ | ETF | 29.24 | 29.43 | 29.16 | 29.29 | 4236800.0 |
| 2002-06-05 15:00:00 | QQQ | ETF | 29.34 | 29.72 | 29.2 | 29.64 | 8745500.0 |
| 2002-06-05 15:30:00 | QQQ | ETF | 29.63 | 29.75 | 29.49 | 29.71 | 11053000.0 |
| 2002-06-05 16:00:00 | QQQ | ETF | 29.72 | 29.75 | 29.65 | 29.65 | 3152000.0 |
| 2002-06-05 16:30:00 | QQQ | ETF | 29.7 | 29.85 | 29.45 | 29.74 | 831600.0 |
| 2002-06-05 17:00:00 | QQQ | ETF | 29.74 | 29.74 | 29.7 | 29.7 | 40000.0 |
| 2002-06-05 17:30:00 | QQQ | ETF | 29.69 | 29.74 | 29.69 | 29.73 | 20600.0 |
| 2002-06-05 18:00:00 | QQQ | ETF | 29.73 | 29.75 | 29.72 | 29.72 | 8000.0 |
| 2002-06-05 09:30:00 | IWM | ETF | 47.275 | 47.275 | 47.0 | 47.075 | 463800.0 |
| 2002-06-05 10:00:00 | IWM | ETF | 47.155 | 47.425 | 47.125 | 47.205 | 125800.0 |
| 2002-06-05 10:30:00 | IWM | ETF | 47.16 | 47.23 | 47.05 | 47.1 | 142000.0 |
| 2002-06-05 11:00:00 | IWM | ETF | 47.125 | 47.125 | 46.995 | 46.995 | 20800.0 |
| 2002-06-05 11:30:00 | IWM | ETF | 46.995 | 47.01 | 46.86 | 46.925 | 37200.0 |
| 2002-06-05 12:00:00 | IWM | ETF | 46.925 | 46.935 | 46.9 | 46.91 | 65800.0 |
| 2002-06-05 12:30:00 | IWM | ETF | 47.03 | 47.105 | 47.03 | 47.03 | 2400.0 |
| 2002-06-05 13:00:00 | IWM | ETF | 47.025 | 47.075 | 47.005 | 47.025 | 71200.0 |
| 2002-06-05 13:30:00 | IWM | ETF | 47.075 | 47.14 | 47.035 | 47.05 | 16000.0 |
| 2002-06-05 14:00:00 | IWM | ETF | 47.1 | 47.125 | 47.065 | 47.065 | 50600.0 |
| 2002-06-05 14:30:00 | IWM | ETF | 47.1 | 47.235 | 47.06 | 47.115 | 179600.0 |
| 2002-06-05 15:00:00 | IWM | ETF | 47.115 | 47.245 | 47.1 | 47.245 | 47600.0 |
| 2002-06-05 15:30:00 | IWM | ETF | 47.25 | 47.3 | 47.15 | 47.26 | 242600.0 |
| 2002-06-05 16:00:00 | IWM | ETF | 47.33 | 47.35 | 47.22 | 47.28 | 26600.0 |
> showing 50 of 503 rows — these rows as CSV