PREVIEW / etf_30min / 2001-07-25
file: by_date/etf_30min/2001/2001-07-25.parquet size: 15 KB rows: 371
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 |
|---|---|---|---|---|---|---|---|
| 2001-07-25 09:30:00 | SPY | ETF | 117.92 | 118.14 | 117.46 | 117.63 | 1119500.0 |
| 2001-07-25 10:00:00 | SPY | ETF | 117.62 | 118.54 | 117.51 | 118.53 | 2291400.0 |
| 2001-07-25 10:30:00 | SPY | ETF | 118.53 | 118.7 | 118.31 | 118.52 | 891600.0 |
| 2001-07-25 11:00:00 | SPY | ETF | 118.52 | 118.57 | 117.96 | 118.01 | 364300.0 |
| 2001-07-25 11:30:00 | SPY | ETF | 118.06 | 118.28 | 117.86 | 117.89 | 436600.0 |
| 2001-07-25 12:00:00 | SPY | ETF | 117.89 | 118.08 | 117.8 | 117.97 | 290400.0 |
| 2001-07-25 12:30:00 | SPY | ETF | 117.89 | 117.94 | 117.57 | 117.92 | 853000.0 |
| 2001-07-25 13:00:00 | SPY | ETF | 117.92 | 118.09 | 117.76 | 117.83 | 411300.0 |
| 2001-07-25 13:30:00 | SPY | ETF | 117.85 | 118.25 | 117.71 | 118.06 | 441800.0 |
| 2001-07-25 14:00:00 | SPY | ETF | 118.08 | 118.57 | 117.96 | 118.54 | 682100.0 |
| 2001-07-25 14:30:00 | SPY | ETF | 118.55 | 118.86 | 118.46 | 118.73 | 814300.0 |
| 2001-07-25 15:00:00 | SPY | ETF | 118.7 | 119.0 | 118.56 | 118.91 | 640200.0 |
| 2001-07-25 15:30:00 | SPY | ETF | 118.97 | 119.48 | 118.92 | 119.3 | 1849600.0 |
| 2001-07-25 16:00:00 | SPY | ETF | 119.26 | 119.4 | 118.18 | 118.18 | 478400.0 |
| 2001-07-25 16:30:00 | SPY | ETF | 119.15 | 119.23 | 119.15 | 119.21 | 25000.0 |
| 2001-07-25 17:00:00 | SPY | ETF | 119.17 | 119.17 | 119.17 | 119.17 | 2000.0 |
| 2001-07-25 17:30:00 | SPY | ETF | 119.12 | 119.2 | 119.12 | 119.2 | 500.0 |
| 2001-07-25 18:00:00 | SPY | ETF | 119.2 | 119.4 | 119.06 | 119.06 | 2200.0 |
| 2001-07-25 09:30:00 | QQQ | ETF | 40.14 | 40.37 | 39.75 | 39.88 | 7089800.0 |
| 2001-07-25 10:00:00 | QQQ | ETF | 39.9 | 40.65 | 39.75 | 40.6 | 6922400.0 |
| 2001-07-25 10:30:00 | QQQ | ETF | 40.65 | 40.72 | 40.36 | 40.51 | 6276500.0 |
| 2001-07-25 11:00:00 | QQQ | ETF | 40.51 | 40.55 | 40.11 | 40.15 | 4350500.0 |
| 2001-07-25 11:30:00 | QQQ | ETF | 40.18 | 40.35 | 40.0 | 40.03 | 2458000.0 |
| 2001-07-25 12:00:00 | QQQ | ETF | 40.0 | 40.11 | 39.87 | 39.9 | 2691600.0 |
| 2001-07-25 12:30:00 | QQQ | ETF | 39.94 | 39.94 | 39.6 | 39.78 | 4074200.0 |
| 2001-07-25 13:00:00 | QQQ | ETF | 39.78 | 39.9 | 39.5 | 39.54 | 3676700.0 |
| 2001-07-25 13:30:00 | QQQ | ETF | 39.55 | 39.82 | 39.4 | 39.67 | 4120200.0 |
| 2001-07-25 14:00:00 | QQQ | ETF | 39.68 | 40.16 | 39.6 | 40.1 | 4921200.0 |
| 2001-07-25 14:30:00 | QQQ | ETF | 40.1 | 40.42 | 40.05 | 40.37 | 5556200.0 |
| 2001-07-25 15:00:00 | QQQ | ETF | 40.34 | 40.37 | 40.0 | 40.19 | 5557800.0 |
| 2001-07-25 15:30:00 | QQQ | ETF | 40.22 | 40.67 | 40.19 | 40.57 | 6688000.0 |
| 2001-07-25 16:00:00 | QQQ | ETF | 40.54 | 40.65 | 40.41 | 40.5 | 867000.0 |
| 2001-07-25 16:30:00 | QQQ | ETF | 40.55 | 40.71 | 40.5 | 40.63 | 59700.0 |
| 2001-07-25 17:00:00 | QQQ | ETF | 40.6 | 40.67 | 40.55 | 40.66 | 63000.0 |
| 2001-07-25 17:30:00 | QQQ | ETF | 40.66 | 40.8 | 40.65 | 40.66 | 138700.0 |
| 2001-07-25 18:00:00 | QQQ | ETF | 40.65 | 40.7 | 40.59 | 40.7 | 21000.0 |
| 2001-07-25 09:30:00 | IWM | ETF | 47.45 | 47.45 | 47.055 | 47.195 | 18000.0 |
| 2001-07-25 10:00:00 | IWM | ETF | 47.225 | 47.375 | 47.225 | 47.375 | 113200.0 |
| 2001-07-25 10:30:00 | IWM | ETF | 47.425 | 47.5 | 47.425 | 47.44 | 6000.0 |
| 2001-07-25 11:00:00 | IWM | ETF | 47.44 | 47.44 | 47.205 | 47.315 | 16000.0 |
| 2001-07-25 11:30:00 | IWM | ETF | 47.295 | 47.295 | 47.135 | 47.205 | 6400.0 |
| 2001-07-25 12:00:00 | IWM | ETF | 47.2 | 47.245 | 47.11 | 47.11 | 1400.0 |
| 2001-07-25 12:30:00 | IWM | ETF | 47.225 | 47.225 | 46.955 | 47.07 | 79000.0 |
| 2001-07-25 13:00:00 | IWM | ETF | 47.05 | 47.1 | 46.965 | 47.075 | 9400.0 |
| 2001-07-25 13:30:00 | IWM | ETF | 47.075 | 47.125 | 46.955 | 47.125 | 59200.0 |
| 2001-07-25 14:00:00 | IWM | ETF | 47.1 | 47.24 | 46.96 | 47.24 | 6600.0 |
| 2001-07-25 14:30:00 | IWM | ETF | 47.24 | 47.295 | 47.2 | 47.295 | 36400.0 |
| 2001-07-25 15:00:00 | IWM | ETF | 47.295 | 47.36 | 47.275 | 47.36 | 37800.0 |
| 2001-07-25 15:30:00 | IWM | ETF | 47.36 | 47.65 | 47.36 | 47.625 | 194400.0 |
| 2001-07-25 16:00:00 | IWM | ETF | 47.625 | 47.625 | 47.615 | 47.625 | 18000.0 |
> showing 50 of 371 rows — these rows as CSV