PREVIEW / etf_30min / 2002-07-10
file: by_date/etf_30min/2002/2002-07-10.parquet size: 20 KB rows: 542
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-07-10 09:30:00 | SPY | ETF | 96.0 | 96.07 | 94.77 | 95.35 | 4573400.0 |
| 2002-07-10 10:00:00 | SPY | ETF | 95.33 | 95.97 | 95.15 | 95.49 | 3637500.0 |
| 2002-07-10 10:30:00 | SPY | ETF | 95.48 | 95.62 | 95.0 | 95.41 | 2032500.0 |
| 2002-07-10 11:00:00 | SPY | ETF | 95.38 | 95.41 | 94.26 | 94.48 | 2346800.0 |
| 2002-07-10 11:30:00 | SPY | ETF | 94.49 | 94.63 | 94.06 | 94.12 | 2317000.0 |
| 2002-07-10 12:00:00 | SPY | ETF | 94.12 | 94.15 | 93.74 | 94.03 | 2941200.0 |
| 2002-07-10 12:30:00 | SPY | ETF | 94.01 | 94.5 | 93.74 | 94.5 | 2207800.0 |
| 2002-07-10 13:00:00 | SPY | ETF | 94.46 | 94.7 | 93.99 | 94.05 | 1491200.0 |
| 2002-07-10 13:30:00 | SPY | ETF | 94.0 | 94.18 | 93.27 | 93.41 | 2103100.0 |
| 2002-07-10 14:00:00 | SPY | ETF | 93.35 | 93.45 | 92.65 | 92.79 | 3829000.0 |
| 2002-07-10 14:30:00 | SPY | ETF | 92.8 | 93.52 | 92.57 | 93.41 | 4339700.0 |
| 2002-07-10 15:00:00 | SPY | ETF | 93.46 | 93.5 | 92.22 | 92.77 | 6348500.0 |
| 2002-07-10 15:30:00 | SPY | ETF | 92.84 | 93.14 | 92.2 | 92.29 | 5695000.0 |
| 2002-07-10 16:00:00 | SPY | ETF | 92.24 | 93.6 | 91.94 | 91.94 | 2310500.0 |
| 2002-07-10 16:30:00 | SPY | ETF | 92.03 | 92.69 | 91.95 | 92.14 | 2698900.0 |
| 2002-07-10 17:00:00 | SPY | ETF | 92.12 | 92.48 | 92.12 | 92.21 | 22800.0 |
| 2002-07-10 17:30:00 | SPY | ETF | 92.2 | 92.26 | 92.1 | 92.1 | 17100.0 |
| 2002-07-10 18:00:00 | SPY | ETF | 92.2 | 92.2 | 92.12 | 92.16 | 8300.0 |
| 2002-07-10 09:30:00 | QQQ | ETF | 24.99 | 25.03 | 24.5 | 24.78 | 16462200.0 |
| 2002-07-10 10:00:00 | QQQ | ETF | 24.78 | 24.99 | 24.68 | 24.77 | 8477900.0 |
| 2002-07-10 10:30:00 | QQQ | ETF | 24.76 | 24.89 | 24.55 | 24.79 | 7187600.0 |
| 2002-07-10 11:00:00 | QQQ | ETF | 24.8 | 24.82 | 24.35 | 24.45 | 7670600.0 |
| 2002-07-10 11:30:00 | QQQ | ETF | 24.45 | 24.57 | 24.36 | 24.4 | 6573600.0 |
| 2002-07-10 12:00:00 | QQQ | ETF | 24.41 | 24.49 | 24.3 | 24.44 | 4740600.0 |
| 2002-07-10 12:30:00 | QQQ | ETF | 24.46 | 24.65 | 24.33 | 24.62 | 4394300.0 |
| 2002-07-10 13:00:00 | QQQ | ETF | 24.61 | 24.75 | 24.45 | 24.46 | 6752600.0 |
| 2002-07-10 13:30:00 | QQQ | ETF | 24.46 | 24.53 | 24.21 | 24.24 | 5879900.0 |
| 2002-07-10 14:00:00 | QQQ | ETF | 24.24 | 24.45 | 24.01 | 24.01 | 8310800.0 |
| 2002-07-10 14:30:00 | QQQ | ETF | 24.02 | 24.34 | 23.96 | 24.28 | 9185800.0 |
| 2002-07-10 15:00:00 | QQQ | ETF | 24.29 | 24.33 | 23.96 | 24.13 | 10102900.0 |
| 2002-07-10 15:30:00 | QQQ | ETF | 24.14 | 24.19 | 23.83 | 23.94 | 12371800.0 |
| 2002-07-10 16:00:00 | QQQ | ETF | 23.9 | 24.38 | 23.85 | 23.9 | 3894500.0 |
| 2002-07-10 16:30:00 | QQQ | ETF | 23.92 | 24.1 | 23.86 | 23.92 | 366900.0 |
| 2002-07-10 17:00:00 | QQQ | ETF | 23.94 | 24.01 | 23.93 | 23.96 | 168600.0 |
| 2002-07-10 17:30:00 | QQQ | ETF | 23.97 | 24.01 | 23.92 | 24.0 | 108500.0 |
| 2002-07-10 18:00:00 | QQQ | ETF | 24.0 | 24.01 | 23.95 | 23.98 | 63200.0 |
| 2002-07-10 09:30:00 | IWM | ETF | 42.945 | 42.945 | 42.38 | 42.61 | 222600.0 |
| 2002-07-10 10:00:00 | IWM | ETF | 42.56 | 42.75 | 42.56 | 42.62 | 285400.0 |
| 2002-07-10 10:30:00 | IWM | ETF | 42.61 | 42.615 | 42.325 | 42.48 | 199800.0 |
| 2002-07-10 11:00:00 | IWM | ETF | 42.475 | 42.48 | 42.195 | 42.195 | 151800.0 |
| 2002-07-10 11:30:00 | IWM | ETF | 42.255 | 42.315 | 42.175 | 42.175 | 128400.0 |
| 2002-07-10 12:00:00 | IWM | ETF | 42.25 | 42.25 | 42.075 | 42.2 | 169000.0 |
| 2002-07-10 12:30:00 | IWM | ETF | 42.19 | 42.315 | 42.115 | 42.3 | 104000.0 |
| 2002-07-10 13:00:00 | IWM | ETF | 42.35 | 42.42 | 42.25 | 42.25 | 87200.0 |
| 2002-07-10 13:30:00 | IWM | ETF | 42.255 | 42.285 | 42.065 | 42.11 | 57600.0 |
| 2002-07-10 14:00:00 | IWM | ETF | 42.12 | 42.12 | 41.89 | 41.92 | 108000.0 |
| 2002-07-10 14:30:00 | IWM | ETF | 41.845 | 42.0 | 41.825 | 42.0 | 115000.0 |
| 2002-07-10 15:00:00 | IWM | ETF | 42.0 | 42.015 | 41.825 | 41.89 | 129200.0 |
| 2002-07-10 15:30:00 | IWM | ETF | 41.89 | 41.945 | 41.675 | 41.68 | 251600.0 |
| 2002-07-10 16:00:00 | IWM | ETF | 41.775 | 41.855 | 41.705 | 41.71 | 39600.0 |
> showing 50 of 542 rows — these rows as CSV