PREVIEW / etf_30min / 2002-03-13
file: by_date/etf_30min/2002/2002-03-13.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-03-13 09:30:00 | SPY | ETF | 116.63 | 116.7 | 116.17 | 116.44 | 2664400.0 |
| 2002-03-13 10:00:00 | SPY | ETF | 116.37 | 116.72 | 116.34 | 116.72 | 1569100.0 |
| 2002-03-13 10:30:00 | SPY | ETF | 116.72 | 116.75 | 116.32 | 116.4 | 834700.0 |
| 2002-03-13 11:00:00 | SPY | ETF | 116.35 | 116.47 | 116.06 | 116.06 | 723100.0 |
| 2002-03-13 11:30:00 | SPY | ETF | 116.11 | 116.28 | 116.04 | 116.12 | 2721800.0 |
| 2002-03-13 12:00:00 | SPY | ETF | 116.11 | 116.27 | 115.95 | 116.2 | 603400.0 |
| 2002-03-13 12:30:00 | SPY | ETF | 116.15 | 116.34 | 116.13 | 116.22 | 268400.0 |
| 2002-03-13 13:00:00 | SPY | ETF | 116.23 | 116.4 | 116.12 | 116.35 | 598800.0 |
| 2002-03-13 13:30:00 | SPY | ETF | 116.34 | 116.4 | 115.82 | 115.97 | 1378700.0 |
| 2002-03-13 14:00:00 | SPY | ETF | 115.94 | 116.14 | 115.84 | 115.95 | 460900.0 |
| 2002-03-13 14:30:00 | SPY | ETF | 115.97 | 116.05 | 115.64 | 115.83 | 1781600.0 |
| 2002-03-13 15:00:00 | SPY | ETF | 115.79 | 116.09 | 115.75 | 115.96 | 796700.0 |
| 2002-03-13 15:30:00 | SPY | ETF | 116.02 | 116.17 | 115.89 | 115.95 | 863500.0 |
| 2002-03-13 16:00:00 | SPY | ETF | 115.9 | 116.05 | 115.77 | 116.02 | 1022900.0 |
| 2002-03-13 16:30:00 | SPY | ETF | 116.02 | 116.02 | 116.02 | 116.02 | 58800.0 |
| 2002-03-13 17:00:00 | SPY | ETF | 116.0 | 116.0 | 115.96 | 115.96 | 400.0 |
| 2002-03-13 17:30:00 | SPY | ETF | 116.05 | 116.05 | 116.05 | 116.05 | 200.0 |
| 2002-03-13 18:00:00 | SPY | ETF | 116.12 | 116.12 | 115.99 | 115.99 | 1100.0 |
| 2002-03-13 09:30:00 | QQQ | ETF | 37.41 | 37.54 | 37.22 | 37.33 | 11477100.0 |
| 2002-03-13 10:00:00 | QQQ | ETF | 37.34 | 37.62 | 37.27 | 37.6 | 9089500.0 |
| 2002-03-13 10:30:00 | QQQ | ETF | 37.58 | 37.66 | 37.35 | 37.38 | 5334500.0 |
| 2002-03-13 11:00:00 | QQQ | ETF | 37.39 | 37.45 | 37.17 | 37.19 | 4182500.0 |
| 2002-03-13 11:30:00 | QQQ | ETF | 37.2 | 37.3 | 37.15 | 37.18 | 4014700.0 |
| 2002-03-13 12:00:00 | QQQ | ETF | 37.18 | 37.26 | 37.06 | 37.21 | 3014000.0 |
| 2002-03-13 12:30:00 | QQQ | ETF | 37.22 | 37.31 | 37.17 | 37.2 | 2005900.0 |
| 2002-03-13 13:00:00 | QQQ | ETF | 37.2 | 37.34 | 37.15 | 37.32 | 1948500.0 |
| 2002-03-13 13:30:00 | QQQ | ETF | 37.32 | 37.36 | 36.97 | 37.05 | 5369000.0 |
| 2002-03-13 14:00:00 | QQQ | ETF | 37.05 | 37.12 | 36.96 | 37.04 | 3924600.0 |
| 2002-03-13 14:30:00 | QQQ | ETF | 37.04 | 37.1 | 36.87 | 36.98 | 4918000.0 |
| 2002-03-13 15:00:00 | QQQ | ETF | 36.96 | 37.15 | 36.92 | 37.08 | 4977800.0 |
| 2002-03-13 15:30:00 | QQQ | ETF | 37.08 | 37.17 | 36.96 | 37.02 | 5025200.0 |
| 2002-03-13 16:00:00 | QQQ | ETF | 37.03 | 37.1 | 36.98 | 37.05 | 2448000.0 |
| 2002-03-13 16:30:00 | QQQ | ETF | 37.05 | 37.09 | 37.0 | 37.08 | 48200.0 |
| 2002-03-13 17:00:00 | QQQ | ETF | 37.09 | 37.13 | 37.07 | 37.13 | 27800.0 |
| 2002-03-13 17:30:00 | QQQ | ETF | 37.13 | 37.14 | 37.11 | 37.11 | 43400.0 |
| 2002-03-13 18:00:00 | QQQ | ETF | 37.12 | 37.3 | 37.0 | 37.0 | 30600.0 |
| 2002-03-13 09:30:00 | IWM | ETF | 49.25 | 49.4 | 49.225 | 49.275 | 301400.0 |
| 2002-03-13 10:00:00 | IWM | ETF | 49.26 | 49.465 | 49.26 | 49.445 | 48600.0 |
| 2002-03-13 10:30:00 | IWM | ETF | 49.455 | 49.525 | 49.355 | 49.435 | 235200.0 |
| 2002-03-13 11:00:00 | IWM | ETF | 49.35 | 49.425 | 49.26 | 49.315 | 12400.0 |
| 2002-03-13 11:30:00 | IWM | ETF | 49.275 | 49.275 | 49.065 | 49.19 | 25200.0 |
| 2002-03-13 12:00:00 | IWM | ETF | 49.185 | 49.195 | 49.025 | 49.085 | 125400.0 |
| 2002-03-13 12:30:00 | IWM | ETF | 49.195 | 49.275 | 49.195 | 49.275 | 6400.0 |
| 2002-03-13 13:00:00 | IWM | ETF | 49.265 | 49.345 | 49.265 | 49.345 | 6200.0 |
| 2002-03-13 13:30:00 | IWM | ETF | 49.27 | 49.345 | 49.1 | 49.145 | 201800.0 |
| 2002-03-13 14:00:00 | IWM | ETF | 49.235 | 49.285 | 49.165 | 49.285 | 11400.0 |
| 2002-03-13 14:30:00 | IWM | ETF | 49.275 | 49.275 | 49.16 | 49.175 | 273800.0 |
| 2002-03-13 15:00:00 | IWM | ETF | 49.175 | 49.295 | 49.15 | 49.285 | 100400.0 |
| 2002-03-13 15:30:00 | IWM | ETF | 49.3 | 49.335 | 49.23 | 49.3 | 138000.0 |
| 2002-03-13 16:00:00 | IWM | ETF | 49.2 | 49.2 | 49.2 | 49.2 | 4000.0 |
> showing 50 of 509 rows — these rows as CSV