PREVIEW / etf_30min / 2001-08-03
file: by_date/etf_30min/2001/2001-08-03.parquet size: 14 KB rows: 355
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-08-03 09:30:00 | SPY | ETF | 122.36 | 122.36 | 121.51 | 121.6 | 1607800.0 |
| 2001-08-03 10:00:00 | SPY | ETF | 121.63 | 121.63 | 120.95 | 121.09 | 934500.0 |
| 2001-08-03 10:30:00 | SPY | ETF | 121.07 | 121.29 | 120.9 | 121.2 | 459400.0 |
| 2001-08-03 11:00:00 | SPY | ETF | 121.18 | 121.46 | 121.15 | 121.38 | 729200.0 |
| 2001-08-03 11:30:00 | SPY | ETF | 121.39 | 121.48 | 121.15 | 121.21 | 899800.0 |
| 2001-08-03 12:00:00 | SPY | ETF | 121.22 | 121.49 | 121.18 | 121.45 | 586900.0 |
| 2001-08-03 12:30:00 | SPY | ETF | 121.46 | 121.47 | 121.16 | 121.39 | 741800.0 |
| 2001-08-03 13:00:00 | SPY | ETF | 121.37 | 121.49 | 121.12 | 121.28 | 582400.0 |
| 2001-08-03 13:30:00 | SPY | ETF | 121.28 | 121.4 | 121.06 | 121.32 | 477400.0 |
| 2001-08-03 14:00:00 | SPY | ETF | 121.32 | 121.42 | 121.15 | 121.4 | 320500.0 |
| 2001-08-03 14:30:00 | SPY | ETF | 121.4 | 121.47 | 121.18 | 121.2 | 302800.0 |
| 2001-08-03 15:00:00 | SPY | ETF | 121.21 | 121.79 | 121.2 | 121.72 | 801100.0 |
| 2001-08-03 15:30:00 | SPY | ETF | 121.72 | 121.98 | 121.7 | 121.87 | 1282200.0 |
| 2001-08-03 16:00:00 | SPY | ETF | 121.92 | 121.99 | 121.27 | 121.99 | 670100.0 |
| 2001-08-03 16:30:00 | SPY | ETF | 122.01 | 122.01 | 121.78 | 121.78 | 50600.0 |
| 2001-08-03 17:30:00 | SPY | ETF | 121.75 | 121.75 | 121.75 | 121.75 | 200.0 |
| 2001-08-03 18:00:00 | SPY | ETF | 121.75 | 121.75 | 121.75 | 121.75 | 1400.0 |
| 2001-08-03 09:30:00 | QQQ | ETF | 43.53 | 43.53 | 43.0 | 43.2 | 15107300.0 |
| 2001-08-03 10:00:00 | QQQ | ETF | 43.14 | 43.25 | 42.56 | 42.83 | 6553100.0 |
| 2001-08-03 10:30:00 | QQQ | ETF | 42.9 | 42.95 | 42.58 | 42.79 | 4060600.0 |
| 2001-08-03 11:00:00 | QQQ | ETF | 42.77 | 42.99 | 42.68 | 42.94 | 3225300.0 |
| 2001-08-03 11:30:00 | QQQ | ETF | 42.96 | 42.99 | 42.73 | 42.8 | 2701900.0 |
| 2001-08-03 12:00:00 | QQQ | ETF | 42.8 | 42.9 | 42.75 | 42.87 | 1419700.0 |
| 2001-08-03 12:30:00 | QQQ | ETF | 42.85 | 42.89 | 42.66 | 42.82 | 1220200.0 |
| 2001-08-03 13:00:00 | QQQ | ETF | 42.78 | 42.89 | 42.7 | 42.78 | 1507400.0 |
| 2001-08-03 13:30:00 | QQQ | ETF | 42.78 | 42.82 | 42.62 | 42.78 | 1620700.0 |
| 2001-08-03 14:00:00 | QQQ | ETF | 42.78 | 42.88 | 42.66 | 42.87 | 1518800.0 |
| 2001-08-03 14:30:00 | QQQ | ETF | 42.82 | 42.96 | 42.8 | 42.82 | 1824800.0 |
| 2001-08-03 15:00:00 | QQQ | ETF | 42.81 | 43.12 | 42.79 | 43.07 | 2156300.0 |
| 2001-08-03 15:30:00 | QQQ | ETF | 43.09 | 43.18 | 42.94 | 43.05 | 4023000.0 |
| 2001-08-03 16:00:00 | QQQ | ETF | 43.03 | 43.2 | 42.99 | 43.15 | 1510400.0 |
| 2001-08-03 16:30:00 | QQQ | ETF | 43.15 | 43.18 | 43.1 | 43.1 | 167500.0 |
| 2001-08-03 17:00:00 | QQQ | ETF | 43.1 | 43.12 | 43.0 | 43.0 | 32800.0 |
| 2001-08-03 17:30:00 | QQQ | ETF | 43.0 | 43.1 | 43.0 | 43.05 | 6400.0 |
| 2001-08-03 18:00:00 | QQQ | ETF | 43.05 | 43.08 | 43.03 | 43.07 | 4300.0 |
| 2001-08-03 09:30:00 | IWM | ETF | 48.75 | 48.75 | 48.255 | 48.325 | 28800.0 |
| 2001-08-03 10:00:00 | IWM | ETF | 48.155 | 48.295 | 48.05 | 48.245 | 96000.0 |
| 2001-08-03 10:30:00 | IWM | ETF | 48.24 | 48.245 | 48.055 | 48.245 | 24400.0 |
| 2001-08-03 11:00:00 | IWM | ETF | 48.245 | 48.315 | 48.245 | 48.315 | 31200.0 |
| 2001-08-03 11:30:00 | IWM | ETF | 48.39 | 48.4 | 48.365 | 48.365 | 1800.0 |
| 2001-08-03 12:00:00 | IWM | ETF | 48.42 | 48.42 | 48.405 | 48.405 | 1800.0 |
| 2001-08-03 12:30:00 | IWM | ETF | 48.42 | 48.49 | 48.305 | 48.375 | 6600.0 |
| 2001-08-03 13:00:00 | IWM | ETF | 48.395 | 48.5 | 48.38 | 48.38 | 5200.0 |
| 2001-08-03 13:30:00 | IWM | ETF | 48.38 | 48.45 | 48.33 | 48.42 | 12400.0 |
| 2001-08-03 14:00:00 | IWM | ETF | 48.375 | 48.42 | 48.375 | 48.405 | 2200.0 |
| 2001-08-03 14:30:00 | IWM | ETF | 48.4 | 48.4 | 48.4 | 48.4 | 400.0 |
| 2001-08-03 15:00:00 | IWM | ETF | 48.42 | 48.42 | 48.42 | 48.42 | 4000.0 |
| 2001-08-03 15:30:00 | IWM | ETF | 48.77 | 48.895 | 48.575 | 48.575 | 75200.0 |
| 2001-08-03 09:30:00 | DIA | ETF | 105.7 | 105.7 | 104.88 | 104.88 | 317100.0 |
| 2001-08-03 10:00:00 | DIA | ETF | 104.83 | 104.85 | 104.36 | 104.65 | 250600.0 |
> showing 50 of 355 rows — these rows as CSV