PREVIEW / etf_30min / 2001-08-08
file: by_date/etf_30min/2001/2001-08-08.parquet size: 15 KB rows: 345
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-08 09:30:00 | SPY | ETF | 120.12 | 120.5 | 120.05 | 120.48 | 783400.0 |
| 2001-08-08 10:00:00 | SPY | ETF | 120.45 | 120.74 | 120.23 | 120.72 | 1167600.0 |
| 2001-08-08 10:30:00 | SPY | ETF | 120.71 | 120.98 | 120.55 | 120.94 | 595200.0 |
| 2001-08-08 11:00:00 | SPY | ETF | 120.95 | 121.16 | 120.86 | 120.91 | 939900.0 |
| 2001-08-08 11:30:00 | SPY | ETF | 120.93 | 120.93 | 120.64 | 120.77 | 1068200.0 |
| 2001-08-08 12:00:00 | SPY | ETF | 120.76 | 120.77 | 120.57 | 120.62 | 395400.0 |
| 2001-08-08 12:30:00 | SPY | ETF | 120.61 | 120.64 | 120.41 | 120.56 | 459000.0 |
| 2001-08-08 13:00:00 | SPY | ETF | 120.54 | 120.58 | 120.23 | 120.32 | 482600.0 |
| 2001-08-08 13:30:00 | SPY | ETF | 120.34 | 120.48 | 120.01 | 120.07 | 661000.0 |
| 2001-08-08 14:00:00 | SPY | ETF | 120.09 | 120.09 | 119.39 | 119.5 | 1711800.0 |
| 2001-08-08 14:30:00 | SPY | ETF | 119.48 | 119.49 | 119.07 | 119.29 | 1195800.0 |
| 2001-08-08 15:00:00 | SPY | ETF | 119.3 | 119.3 | 118.72 | 118.75 | 1549400.0 |
| 2001-08-08 15:30:00 | SPY | ETF | 118.74 | 118.81 | 118.43 | 118.65 | 2241600.0 |
| 2001-08-08 16:00:00 | SPY | ETF | 118.71 | 118.73 | 118.5 | 118.56 | 1060400.0 |
| 2001-08-08 16:30:00 | SPY | ETF | 118.5 | 118.64 | 118.5 | 118.64 | 30300.0 |
| 2001-08-08 17:30:00 | SPY | ETF | 118.5 | 118.5 | 118.5 | 118.5 | 100.0 |
| 2001-08-08 09:30:00 | QQQ | ETF | 41.85 | 42.2 | 41.72 | 42.12 | 7483300.0 |
| 2001-08-08 10:00:00 | QQQ | ETF | 42.13 | 42.45 | 41.95 | 42.45 | 5649300.0 |
| 2001-08-08 10:30:00 | QQQ | ETF | 42.43 | 42.55 | 42.26 | 42.45 | 6941600.0 |
| 2001-08-08 11:00:00 | QQQ | ETF | 42.45 | 42.65 | 42.42 | 42.51 | 3729900.0 |
| 2001-08-08 11:30:00 | QQQ | ETF | 42.52 | 42.52 | 42.25 | 42.36 | 2887600.0 |
| 2001-08-08 12:00:00 | QQQ | ETF | 42.36 | 42.38 | 42.13 | 42.18 | 2671100.0 |
| 2001-08-08 12:30:00 | QQQ | ETF | 42.17 | 42.2 | 41.96 | 42.0 | 2336900.0 |
| 2001-08-08 13:00:00 | QQQ | ETF | 42.0 | 42.03 | 41.66 | 41.77 | 3979300.0 |
| 2001-08-08 13:30:00 | QQQ | ETF | 41.78 | 41.86 | 41.3 | 41.46 | 4358700.0 |
| 2001-08-08 14:00:00 | QQQ | ETF | 41.47 | 41.5 | 41.01 | 41.13 | 7635000.0 |
| 2001-08-08 14:30:00 | QQQ | ETF | 41.1 | 41.15 | 40.55 | 40.71 | 8615800.0 |
| 2001-08-08 15:00:00 | QQQ | ETF | 40.69 | 40.77 | 40.31 | 40.46 | 9371500.0 |
| 2001-08-08 15:30:00 | QQQ | ETF | 40.46 | 40.59 | 40.3 | 40.49 | 6393900.0 |
| 2001-08-08 16:00:00 | QQQ | ETF | 40.5 | 42.4 | 40.41 | 40.5 | 1035200.0 |
| 2001-08-08 16:30:00 | QQQ | ETF | 40.5 | 40.57 | 40.4 | 40.51 | 185300.0 |
| 2001-08-08 17:00:00 | QQQ | ETF | 40.53 | 40.55 | 40.45 | 40.5 | 50200.0 |
| 2001-08-08 17:30:00 | QQQ | ETF | 40.5 | 40.52 | 40.4 | 40.45 | 7500.0 |
| 2001-08-08 18:00:00 | QQQ | ETF | 40.49 | 40.5 | 40.41 | 40.41 | 13900.0 |
| 2001-08-08 09:30:00 | IWM | ETF | 47.5 | 47.795 | 47.5 | 47.795 | 28600.0 |
| 2001-08-08 10:00:00 | IWM | ETF | 47.875 | 48.095 | 47.825 | 48.095 | 26600.0 |
| 2001-08-08 10:30:00 | IWM | ETF | 48.095 | 48.095 | 48.07 | 48.07 | 6600.0 |
| 2001-08-08 11:00:00 | IWM | ETF | 48.095 | 48.16 | 48.095 | 48.16 | 11200.0 |
| 2001-08-08 11:30:00 | IWM | ETF | 48.07 | 48.07 | 47.995 | 47.995 | 1600.0 |
| 2001-08-08 12:00:00 | IWM | ETF | 47.94 | 47.94 | 47.87 | 47.87 | 1200.0 |
| 2001-08-08 12:30:00 | IWM | ETF | 47.85 | 47.87 | 47.85 | 47.87 | 1800.0 |
| 2001-08-08 13:00:00 | IWM | ETF | 47.86 | 47.86 | 47.705 | 47.705 | 2200.0 |
| 2001-08-08 13:30:00 | IWM | ETF | 47.775 | 47.785 | 47.625 | 47.625 | 21000.0 |
| 2001-08-08 14:00:00 | IWM | ETF | 47.625 | 47.625 | 47.34 | 47.435 | 44400.0 |
| 2001-08-08 14:30:00 | IWM | ETF | 47.35 | 47.4 | 47.17 | 47.175 | 602800.0 |
| 2001-08-08 15:00:00 | IWM | ETF | 47.17 | 47.225 | 47.005 | 47.225 | 126600.0 |
| 2001-08-08 15:30:00 | IWM | ETF | 47.06 | 47.12 | 46.875 | 47.075 | 88000.0 |
| 2001-08-08 16:00:00 | IWM | ETF | 47.0 | 47.025 | 46.875 | 46.875 | 71800.0 |
| 2001-08-08 09:30:00 | DIA | ETF | 104.19 | 104.38 | 104.0 | 104.38 | 351800.0 |
| 2001-08-08 10:00:00 | DIA | ETF | 104.38 | 104.6 | 104.16 | 104.55 | 252800.0 |
> showing 50 of 345 rows — these rows as CSV