PREVIEW / etf_30min / 2001-05-23
file: by_date/etf_30min/2001/2001-05-23.parquet size: 15 KB rows: 387
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-05-23 09:30:00 | SPY | ETF | 131.05 | 131.05 | 130.31 | 130.4 | 1383100.0 |
| 2001-05-23 10:00:00 | SPY | ETF | 130.38 | 130.48 | 129.95 | 130.11 | 1150900.0 |
| 2001-05-23 10:30:00 | SPY | ETF | 130.11 | 130.22 | 129.8 | 130.18 | 730800.0 |
| 2001-05-23 11:00:00 | SPY | ETF | 130.17 | 130.19 | 129.45 | 129.48 | 780600.0 |
| 2001-05-23 11:30:00 | SPY | ETF | 129.54 | 129.91 | 129.47 | 129.86 | 839500.0 |
| 2001-05-23 12:00:00 | SPY | ETF | 129.9 | 130.14 | 129.81 | 129.85 | 698900.0 |
| 2001-05-23 12:30:00 | SPY | ETF | 129.83 | 130.2 | 129.77 | 129.96 | 319000.0 |
| 2001-05-23 13:00:00 | SPY | ETF | 129.98 | 130.1 | 129.61 | 129.76 | 322700.0 |
| 2001-05-23 13:30:00 | SPY | ETF | 129.77 | 129.89 | 129.46 | 129.65 | 395600.0 |
| 2001-05-23 14:00:00 | SPY | ETF | 129.68 | 130.0 | 129.45 | 129.78 | 461500.0 |
| 2001-05-23 14:30:00 | SPY | ETF | 129.83 | 130.14 | 129.56 | 129.95 | 979200.0 |
| 2001-05-23 15:00:00 | SPY | ETF | 129.98 | 130.12 | 129.45 | 129.61 | 777500.0 |
| 2001-05-23 15:30:00 | SPY | ETF | 129.67 | 129.69 | 129.29 | 129.29 | 1842900.0 |
| 2001-05-23 16:00:00 | SPY | ETF | 129.29 | 129.5 | 129.22 | 129.22 | 1166200.0 |
| 2001-05-23 16:30:00 | SPY | ETF | 129.28 | 129.28 | 129.2 | 129.2 | 26400.0 |
| 2001-05-23 17:00:00 | SPY | ETF | 129.18 | 129.27 | 129.18 | 129.27 | 300.0 |
| 2001-05-23 17:30:00 | SPY | ETF | 129.18 | 129.18 | 129.18 | 129.18 | 200.0 |
| 2001-05-23 09:30:00 | QQQ | ETF | 50.44 | 50.45 | 49.77 | 49.8 | 10449700.0 |
| 2001-05-23 10:00:00 | QQQ | ETF | 49.79 | 49.99 | 49.4 | 49.58 | 7924100.0 |
| 2001-05-23 10:30:00 | QQQ | ETF | 49.58 | 49.83 | 49.37 | 49.8 | 4945600.0 |
| 2001-05-23 11:00:00 | QQQ | ETF | 49.82 | 49.87 | 49.21 | 49.25 | 4200600.0 |
| 2001-05-23 11:30:00 | QQQ | ETF | 49.25 | 49.6 | 49.16 | 49.54 | 3858500.0 |
| 2001-05-23 12:00:00 | QQQ | ETF | 49.55 | 49.77 | 49.47 | 49.5 | 3234500.0 |
| 2001-05-23 12:30:00 | QQQ | ETF | 49.5 | 49.9 | 49.47 | 49.8 | 2183600.0 |
| 2001-05-23 13:00:00 | QQQ | ETF | 49.82 | 49.94 | 49.42 | 49.56 | 3395500.0 |
| 2001-05-23 13:30:00 | QQQ | ETF | 49.55 | 49.64 | 49.3 | 49.37 | 2415000.0 |
| 2001-05-23 14:00:00 | QQQ | ETF | 49.35 | 49.45 | 49.14 | 49.35 | 2795900.0 |
| 2001-05-23 14:30:00 | QQQ | ETF | 49.34 | 49.72 | 49.16 | 49.52 | 4904900.0 |
| 2001-05-23 15:00:00 | QQQ | ETF | 49.53 | 49.68 | 49.08 | 49.24 | 2997400.0 |
| 2001-05-23 15:30:00 | QQQ | ETF | 49.21 | 49.25 | 48.77 | 48.8 | 8090500.0 |
| 2001-05-23 16:00:00 | QQQ | ETF | 48.8 | 49.25 | 48.64 | 48.69 | 2031900.0 |
| 2001-05-23 16:30:00 | QQQ | ETF | 48.7 | 48.75 | 48.57 | 48.59 | 43400.0 |
| 2001-05-23 17:00:00 | QQQ | ETF | 48.6 | 48.64 | 48.52 | 48.62 | 17400.0 |
| 2001-05-23 17:30:00 | QQQ | ETF | 48.62 | 48.66 | 48.56 | 48.56 | 9000.0 |
| 2001-05-23 18:00:00 | QQQ | ETF | 48.8 | 48.8 | 48.57 | 48.65 | 7600.0 |
| 2001-05-23 09:30:00 | IWM | ETF | 51.325 | 51.475 | 51.15 | 51.15 | 44600.0 |
| 2001-05-23 10:00:00 | IWM | ETF | 51.15 | 51.15 | 50.73 | 50.925 | 132800.0 |
| 2001-05-23 10:30:00 | IWM | ETF | 50.925 | 50.925 | 50.6 | 50.925 | 67800.0 |
| 2001-05-23 11:00:00 | IWM | ETF | 50.925 | 50.945 | 50.775 | 50.78 | 14600.0 |
| 2001-05-23 11:30:00 | IWM | ETF | 50.775 | 50.87 | 50.775 | 50.87 | 14400.0 |
| 2001-05-23 12:00:00 | IWM | ETF | 50.895 | 50.975 | 50.895 | 50.97 | 12600.0 |
| 2001-05-23 12:30:00 | IWM | ETF | 50.945 | 51.045 | 50.9 | 51.045 | 33000.0 |
| 2001-05-23 13:00:00 | IWM | ETF | 51.045 | 51.045 | 50.9 | 50.9 | 5200.0 |
| 2001-05-23 13:30:00 | IWM | ETF | 50.925 | 50.95 | 50.775 | 50.8 | 24000.0 |
| 2001-05-23 14:00:00 | IWM | ETF | 50.99 | 50.99 | 50.725 | 50.8 | 25400.0 |
| 2001-05-23 14:30:00 | IWM | ETF | 50.805 | 51.015 | 50.805 | 51.015 | 19000.0 |
| 2001-05-23 15:00:00 | IWM | ETF | 51.015 | 51.015 | 50.9 | 50.9 | 11000.0 |
| 2001-05-23 15:30:00 | IWM | ETF | 50.925 | 50.925 | 50.575 | 50.575 | 131200.0 |
| 2001-05-23 16:00:00 | IWM | ETF | 50.575 | 50.65 | 50.5 | 50.5 | 13200.0 |
| 2001-05-23 09:30:00 | DIA | ETF | 112.3 | 112.5 | 112.01 | 112.01 | 933800.0 |
> showing 50 of 387 rows — these rows as CSV