PREVIEW / etf_30min / 2002-11-05
file: by_date/etf_30min/2002/2002-11-05.parquet size: 21 KB rows: 610
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-11-05 08:00:00 | SPY | ETF | 90.91 | 90.91 | 90.91 | 90.91 | 100.0 |
| 2002-11-05 08:30:00 | SPY | ETF | 91.0 | 91.05 | 90.95 | 91.05 | 4600.0 |
| 2002-11-05 09:00:00 | SPY | ETF | 91.05 | 91.11 | 90.91 | 90.91 | 3400.0 |
| 2002-11-05 09:30:00 | SPY | ETF | 90.84 | 91.38 | 90.84 | 91.3 | 5084100.0 |
| 2002-11-05 10:00:00 | SPY | ETF | 91.33 | 91.69 | 91.12 | 91.45 | 4011000.0 |
| 2002-11-05 10:30:00 | SPY | ETF | 91.44 | 91.85 | 91.21 | 91.81 | 1282500.0 |
| 2002-11-05 11:00:00 | SPY | ETF | 91.83 | 91.86 | 91.52 | 91.75 | 1979800.0 |
| 2002-11-05 11:30:00 | SPY | ETF | 91.78 | 91.78 | 91.5 | 91.5 | 1129600.0 |
| 2002-11-05 12:00:00 | SPY | ETF | 91.51 | 91.58 | 91.23 | 91.37 | 1478700.0 |
| 2002-11-05 12:30:00 | SPY | ETF | 91.33 | 91.69 | 91.29 | 91.55 | 1535000.0 |
| 2002-11-05 13:00:00 | SPY | ETF | 91.53 | 91.59 | 91.13 | 91.2 | 1254400.0 |
| 2002-11-05 13:30:00 | SPY | ETF | 91.2 | 91.25 | 90.93 | 91.15 | 1404000.0 |
| 2002-11-05 14:00:00 | SPY | ETF | 91.12 | 91.51 | 91.08 | 91.49 | 1911000.0 |
| 2002-11-05 14:30:00 | SPY | ETF | 91.48 | 91.83 | 91.35 | 91.74 | 1588000.0 |
| 2002-11-05 15:00:00 | SPY | ETF | 91.79 | 91.82 | 91.4 | 91.51 | 1106000.0 |
| 2002-11-05 15:30:00 | SPY | ETF | 91.5 | 92.07 | 91.48 | 91.97 | 2996300.0 |
| 2002-11-05 16:00:00 | SPY | ETF | 91.96 | 92.05 | 91.76 | 91.95 | 5893900.0 |
| 2002-11-05 16:30:00 | SPY | ETF | 91.86 | 92.0 | 91.86 | 91.93 | 573100.0 |
| 2002-11-05 17:00:00 | SPY | ETF | 91.92 | 92.0 | 91.92 | 91.96 | 14700.0 |
| 2002-11-05 17:30:00 | SPY | ETF | 91.94 | 91.99 | 91.92 | 91.92 | 9700.0 |
| 2002-11-05 18:00:00 | SPY | ETF | 91.96 | 92.02 | 91.91 | 92.02 | 10500.0 |
| 2002-11-05 08:00:00 | QQQ | ETF | 25.7 | 25.72 | 25.7 | 25.71 | 8400.0 |
| 2002-11-05 08:30:00 | QQQ | ETF | 25.71 | 25.75 | 25.71 | 25.71 | 9100.0 |
| 2002-11-05 09:00:00 | QQQ | ETF | 25.75 | 25.79 | 25.71 | 25.71 | 14400.0 |
| 2002-11-05 09:30:00 | QQQ | ETF | 25.71 | 26.09 | 25.7 | 25.91 | 14888600.0 |
| 2002-11-05 10:00:00 | QQQ | ETF | 25.97 | 26.08 | 25.71 | 25.88 | 8079200.0 |
| 2002-11-05 10:30:00 | QQQ | ETF | 25.88 | 26.1 | 25.77 | 26.03 | 7376800.0 |
| 2002-11-05 11:00:00 | QQQ | ETF | 26.04 | 26.07 | 25.86 | 25.99 | 2919300.0 |
| 2002-11-05 11:30:00 | QQQ | ETF | 25.98 | 26.08 | 25.93 | 25.94 | 4455100.0 |
| 2002-11-05 12:00:00 | QQQ | ETF | 25.95 | 25.95 | 25.77 | 25.83 | 5119200.0 |
| 2002-11-05 12:30:00 | QQQ | ETF | 25.79 | 25.92 | 25.76 | 25.82 | 1993800.0 |
| 2002-11-05 13:00:00 | QQQ | ETF | 25.84 | 25.9 | 25.65 | 25.67 | 3141100.0 |
| 2002-11-05 13:30:00 | QQQ | ETF | 25.68 | 25.7 | 25.56 | 25.67 | 3196200.0 |
| 2002-11-05 14:00:00 | QQQ | ETF | 25.67 | 25.89 | 25.65 | 25.87 | 4575200.0 |
| 2002-11-05 14:30:00 | QQQ | ETF | 25.87 | 26.03 | 25.8 | 25.99 | 5221400.0 |
| 2002-11-05 15:00:00 | QQQ | ETF | 25.98 | 26.02 | 25.85 | 25.89 | 4132200.0 |
| 2002-11-05 15:30:00 | QQQ | ETF | 25.88 | 26.14 | 25.87 | 26.1 | 6228900.0 |
| 2002-11-05 16:00:00 | QQQ | ETF | 26.09 | 26.17 | 26.06 | 26.12 | 1995500.0 |
| 2002-11-05 16:30:00 | QQQ | ETF | 26.13 | 26.19 | 26.11 | 26.17 | 125500.0 |
| 2002-11-05 17:00:00 | QQQ | ETF | 26.17 | 26.25 | 26.16 | 26.2 | 129900.0 |
| 2002-11-05 17:30:00 | QQQ | ETF | 26.18 | 26.22 | 26.17 | 26.2 | 91300.0 |
| 2002-11-05 18:00:00 | QQQ | ETF | 26.18 | 26.2 | 26.17 | 26.18 | 13000.0 |
| 2002-11-05 19:30:00 | QQQ | ETF | 26.17 | 26.18 | 26.17 | 26.18 | 300.0 |
| 2002-11-05 09:30:00 | IWM | ETF | 38.525 | 38.55 | 38.375 | 38.535 | 250200.0 |
| 2002-11-05 10:00:00 | IWM | ETF | 38.625 | 38.625 | 38.35 | 38.445 | 308800.0 |
| 2002-11-05 10:30:00 | IWM | ETF | 38.39 | 38.525 | 38.385 | 38.515 | 177000.0 |
| 2002-11-05 11:00:00 | IWM | ETF | 38.515 | 38.525 | 38.4 | 38.49 | 338000.0 |
| 2002-11-05 11:30:00 | IWM | ETF | 38.465 | 38.465 | 38.37 | 38.37 | 96600.0 |
| 2002-11-05 12:00:00 | IWM | ETF | 38.375 | 38.375 | 38.265 | 38.265 | 105600.0 |
| 2002-11-05 12:30:00 | IWM | ETF | 38.315 | 38.38 | 38.27 | 38.335 | 30000.0 |
> showing 50 of 610 rows — these rows as CSV