PREVIEW / etf_30min / 2001-03-05
file: by_date/etf_30min/2001/2001-03-05.parquet size: 14 KB rows: 344
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-03-05 09:30:00 | SPY | ETF | 124.15 | 124.7 | 124.02 | 124.21 | 1020800.0 |
| 2001-03-05 10:00:00 | SPY | ETF | 124.35 | 124.78 | 124.1 | 124.1 | 498400.0 |
| 2001-03-05 10:30:00 | SPY | ETF | 124.1 | 124.3 | 123.81 | 124.19 | 577600.0 |
| 2001-03-05 11:00:00 | SPY | ETF | 124.24 | 124.68 | 124.0 | 124.06 | 242700.0 |
| 2001-03-05 11:30:00 | SPY | ETF | 124.16 | 124.38 | 124.05 | 124.1 | 176300.0 |
| 2001-03-05 12:00:00 | SPY | ETF | 124.12 | 124.5 | 124.02 | 124.1 | 190000.0 |
| 2001-03-05 12:30:00 | SPY | ETF | 124.0 | 124.19 | 123.85 | 124.18 | 196900.0 |
| 2001-03-05 13:00:00 | SPY | ETF | 124.2 | 124.59 | 123.96 | 124.35 | 274800.0 |
| 2001-03-05 13:30:00 | SPY | ETF | 124.3 | 124.64 | 124.1 | 124.1 | 236600.0 |
| 2001-03-05 14:00:00 | SPY | ETF | 124.2 | 124.59 | 124.06 | 124.2 | 610100.0 |
| 2001-03-05 14:30:00 | SPY | ETF | 124.2 | 124.54 | 124.09 | 124.1 | 61800.0 |
| 2001-03-05 15:00:00 | SPY | ETF | 124.22 | 124.68 | 124.07 | 124.55 | 199600.0 |
| 2001-03-05 15:30:00 | SPY | ETF | 124.49 | 124.71 | 124.22 | 124.4 | 297000.0 |
| 2001-03-05 16:00:00 | SPY | ETF | 124.42 | 124.75 | 124.34 | 124.53 | 615800.0 |
| 2001-03-05 17:00:00 | SPY | ETF | 124.45 | 125.0 | 124.45 | 125.0 | 200.0 |
| 2001-03-05 17:30:00 | SPY | ETF | 125.35 | 125.35 | 125.35 | 125.35 | 100.0 |
| 2001-03-05 09:30:00 | QQQ | ETF | 47.5 | 47.98 | 47.11 | 47.5 | 8786100.0 |
| 2001-03-05 10:00:00 | QQQ | ETF | 47.55 | 48.25 | 47.4 | 47.7 | 5026000.0 |
| 2001-03-05 10:30:00 | QQQ | ETF | 47.7 | 48.05 | 47.3 | 47.91 | 3693800.0 |
| 2001-03-05 11:00:00 | QQQ | ETF | 47.92 | 48.36 | 47.73 | 47.8 | 3128100.0 |
| 2001-03-05 11:30:00 | QQQ | ETF | 47.8 | 48.05 | 47.67 | 47.75 | 2932600.0 |
| 2001-03-05 12:00:00 | QQQ | ETF | 47.75 | 47.95 | 47.45 | 47.5 | 1756700.0 |
| 2001-03-05 12:30:00 | QQQ | ETF | 47.46 | 47.66 | 47.21 | 47.45 | 2138100.0 |
| 2001-03-05 13:00:00 | QQQ | ETF | 47.45 | 47.91 | 47.29 | 47.73 | 2105100.0 |
| 2001-03-05 13:30:00 | QQQ | ETF | 47.73 | 48.05 | 47.45 | 47.5 | 2106300.0 |
| 2001-03-05 14:00:00 | QQQ | ETF | 47.45 | 47.75 | 47.3 | 47.6 | 2376400.0 |
| 2001-03-05 14:30:00 | QQQ | ETF | 47.55 | 47.91 | 47.41 | 47.49 | 2354500.0 |
| 2001-03-05 15:00:00 | QQQ | ETF | 47.51 | 47.85 | 47.36 | 47.66 | 2204000.0 |
| 2001-03-05 15:30:00 | QQQ | ETF | 47.6 | 47.87 | 47.4 | 47.84 | 3309700.0 |
| 2001-03-05 16:00:00 | QQQ | ETF | 47.75 | 47.85 | 47.51 | 47.55 | 811900.0 |
| 2001-03-05 16:30:00 | QQQ | ETF | 47.63 | 47.82 | 47.56 | 47.77 | 94800.0 |
| 2001-03-05 17:00:00 | QQQ | ETF | 47.7 | 47.86 | 47.67 | 47.86 | 42500.0 |
| 2001-03-05 17:30:00 | QQQ | ETF | 47.86 | 48.0 | 47.82 | 47.9 | 50300.0 |
| 2001-03-05 18:00:00 | QQQ | ETF | 47.89 | 48.0 | 47.85 | 47.9 | 33800.0 |
| 2001-03-05 09:30:00 | IWM | ETF | 48.0 | 48.025 | 47.695 | 47.8 | 84800.0 |
| 2001-03-05 10:00:00 | IWM | ETF | 47.925 | 47.945 | 47.8 | 47.945 | 103000.0 |
| 2001-03-05 10:30:00 | IWM | ETF | 47.625 | 47.815 | 47.625 | 47.7 | 10800.0 |
| 2001-03-05 11:00:00 | IWM | ETF | 47.7 | 47.815 | 47.7 | 47.815 | 800.0 |
| 2001-03-05 11:30:00 | IWM | ETF | 47.7 | 47.795 | 47.58 | 47.795 | 2400.0 |
| 2001-03-05 12:00:00 | IWM | ETF | 47.55 | 47.55 | 47.55 | 47.55 | 400.0 |
| 2001-03-05 12:30:00 | IWM | ETF | 47.55 | 47.7 | 47.525 | 47.525 | 13600.0 |
| 2001-03-05 13:00:00 | IWM | ETF | 47.665 | 47.7 | 47.525 | 47.625 | 45200.0 |
| 2001-03-05 13:30:00 | IWM | ETF | 47.6 | 47.725 | 47.6 | 47.625 | 19000.0 |
| 2001-03-05 14:00:00 | IWM | ETF | 47.6 | 47.6 | 47.425 | 47.5 | 101200.0 |
| 2001-03-05 14:30:00 | IWM | ETF | 47.525 | 47.525 | 47.5 | 47.5 | 60200.0 |
| 2001-03-05 15:00:00 | IWM | ETF | 47.3 | 47.5 | 47.3 | 47.5 | 2800.0 |
| 2001-03-05 15:30:00 | IWM | ETF | 47.375 | 47.495 | 47.305 | 47.305 | 72800.0 |
| 2001-03-05 16:00:00 | IWM | ETF | 47.305 | 47.35 | 47.305 | 47.35 | 1000.0 |
| 2001-03-05 09:30:00 | DIA | ETF | 105.25 | 105.5 | 104.89 | 105.4 | 174900.0 |
| 2001-03-05 10:00:00 | DIA | ETF | 105.32 | 105.68 | 105.2 | 105.25 | 50600.0 |
> showing 50 of 344 rows — these rows as CSV