PREVIEW / etf_30min / 2002-02-06
file: by_date/etf_30min/2002/2002-02-06.parquet size: 18 KB rows: 481
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-02-06 09:30:00 | SPY | ETF | 109.65 | 109.74 | 109.19 | 109.3 | 4027500.0 |
| 2002-02-06 10:00:00 | SPY | ETF | 109.22 | 109.69 | 108.75 | 108.89 | 2026500.0 |
| 2002-02-06 10:30:00 | SPY | ETF | 108.92 | 109.03 | 108.06 | 108.56 | 4438400.0 |
| 2002-02-06 11:00:00 | SPY | ETF | 108.6 | 108.85 | 108.1 | 108.14 | 2148100.0 |
| 2002-02-06 11:30:00 | SPY | ETF | 108.19 | 108.69 | 108.11 | 108.65 | 1852300.0 |
| 2002-02-06 12:00:00 | SPY | ETF | 108.6 | 108.81 | 108.22 | 108.74 | 2100700.0 |
| 2002-02-06 12:30:00 | SPY | ETF | 108.75 | 109.34 | 108.69 | 108.98 | 3352700.0 |
| 2002-02-06 13:00:00 | SPY | ETF | 108.95 | 109.5 | 108.87 | 109.35 | 1434700.0 |
| 2002-02-06 13:30:00 | SPY | ETF | 109.32 | 109.56 | 108.86 | 108.92 | 1392400.0 |
| 2002-02-06 14:00:00 | SPY | ETF | 108.9 | 109.23 | 108.74 | 109.13 | 1384400.0 |
| 2002-02-06 14:30:00 | SPY | ETF | 109.13 | 109.19 | 108.57 | 108.73 | 1413600.0 |
| 2002-02-06 15:00:00 | SPY | ETF | 108.78 | 109.05 | 108.64 | 108.89 | 1674600.0 |
| 2002-02-06 15:30:00 | SPY | ETF | 108.93 | 109.03 | 108.51 | 108.7 | 1391800.0 |
| 2002-02-06 16:00:00 | SPY | ETF | 108.72 | 109.21 | 108.55 | 108.96 | 721100.0 |
| 2002-02-06 16:30:00 | SPY | ETF | 108.8 | 109.11 | 108.7 | 108.7 | 27400.0 |
| 2002-02-06 17:00:00 | SPY | ETF | 109.05 | 109.09 | 108.75 | 108.75 | 19100.0 |
| 2002-02-06 17:30:00 | SPY | ETF | 108.78 | 108.81 | 108.33 | 108.38 | 78800.0 |
| 2002-02-06 18:00:00 | SPY | ETF | 108.25 | 108.36 | 108.05 | 108.16 | 98900.0 |
| 2002-02-06 09:30:00 | QQQ | ETF | 36.84 | 36.89 | 36.35 | 36.4 | 10702500.0 |
| 2002-02-06 10:00:00 | QQQ | ETF | 36.43 | 36.67 | 36.05 | 36.13 | 9200000.0 |
| 2002-02-06 10:30:00 | QQQ | ETF | 36.15 | 36.2 | 35.7 | 35.98 | 12248600.0 |
| 2002-02-06 11:00:00 | QQQ | ETF | 35.94 | 36.13 | 35.72 | 35.75 | 6698200.0 |
| 2002-02-06 11:30:00 | QQQ | ETF | 35.75 | 36.05 | 35.71 | 36.01 | 4116600.0 |
| 2002-02-06 12:00:00 | QQQ | ETF | 36.01 | 36.2 | 35.81 | 36.18 | 4703900.0 |
| 2002-02-06 12:30:00 | QQQ | ETF | 36.17 | 36.49 | 36.13 | 36.33 | 8004900.0 |
| 2002-02-06 13:00:00 | QQQ | ETF | 36.28 | 36.54 | 36.18 | 36.49 | 6035900.0 |
| 2002-02-06 13:30:00 | QQQ | ETF | 36.53 | 36.62 | 36.12 | 36.12 | 5027600.0 |
| 2002-02-06 14:00:00 | QQQ | ETF | 36.15 | 36.35 | 36.08 | 36.3 | 3786100.0 |
| 2002-02-06 14:30:00 | QQQ | ETF | 36.27 | 36.31 | 35.89 | 36.02 | 5717100.0 |
| 2002-02-06 15:00:00 | QQQ | ETF | 36.03 | 36.2 | 35.98 | 36.1 | 5141800.0 |
| 2002-02-06 15:30:00 | QQQ | ETF | 36.1 | 36.21 | 35.84 | 36.0 | 9412700.0 |
| 2002-02-06 16:00:00 | QQQ | ETF | 36.04 | 36.42 | 35.89 | 36.41 | 3255000.0 |
| 2002-02-06 16:30:00 | QQQ | ETF | 36.42 | 36.49 | 36.27 | 36.3 | 1328700.0 |
| 2002-02-06 17:00:00 | QQQ | ETF | 36.3 | 36.31 | 35.87 | 35.88 | 691200.0 |
| 2002-02-06 17:30:00 | QQQ | ETF | 35.89 | 36.05 | 35.57 | 35.57 | 1698400.0 |
| 2002-02-06 18:00:00 | QQQ | ETF | 35.57 | 35.6 | 35.4 | 35.45 | 210200.0 |
| 2002-02-06 09:30:00 | IWM | ETF | 46.525 | 46.725 | 46.44 | 46.52 | 110400.0 |
| 2002-02-06 10:00:00 | IWM | ETF | 46.39 | 46.5 | 46.08 | 46.08 | 56600.0 |
| 2002-02-06 10:30:00 | IWM | ETF | 46.13 | 46.2 | 45.81 | 46.0 | 141400.0 |
| 2002-02-06 11:00:00 | IWM | ETF | 46.0 | 46.02 | 45.85 | 45.85 | 187200.0 |
| 2002-02-06 11:30:00 | IWM | ETF | 45.85 | 46.015 | 45.85 | 46.005 | 82600.0 |
| 2002-02-06 12:00:00 | IWM | ETF | 46.025 | 46.085 | 45.92 | 46.085 | 117600.0 |
| 2002-02-06 12:30:00 | IWM | ETF | 46.085 | 46.28 | 46.045 | 46.15 | 227000.0 |
| 2002-02-06 13:00:00 | IWM | ETF | 46.175 | 46.29 | 46.12 | 46.2 | 30600.0 |
| 2002-02-06 13:30:00 | IWM | ETF | 46.18 | 46.36 | 46.16 | 46.16 | 24400.0 |
| 2002-02-06 14:00:00 | IWM | ETF | 46.155 | 46.225 | 46.085 | 46.11 | 9200.0 |
| 2002-02-06 14:30:00 | IWM | ETF | 46.11 | 46.18 | 45.99 | 45.99 | 49200.0 |
| 2002-02-06 15:00:00 | IWM | ETF | 46.0 | 46.085 | 46.0 | 46.045 | 22600.0 |
| 2002-02-06 15:30:00 | IWM | ETF | 46.08 | 46.1 | 45.775 | 45.805 | 183000.0 |
| 2002-02-06 16:00:00 | IWM | ETF | 45.895 | 46.0 | 45.875 | 46.0 | 36400.0 |
> showing 50 of 481 rows — these rows as CSV