PREVIEW / etf_30min / 2005-07-15
file: by_date/etf_30min/2005/2005-07-15.parquet size: 44 KB rows: 1,557
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 |
|---|---|---|---|---|---|---|---|
| 2005-07-15 07:00:00 | SPY | ETF | 122.89 | 122.89 | 122.79 | 122.79 | 900.0 |
| 2005-07-15 07:30:00 | SPY | ETF | 122.8 | 122.8 | 122.8 | 122.8 | 1900.0 |
| 2005-07-15 08:00:00 | SPY | ETF | 122.81 | 122.94 | 122.8 | 122.94 | 100700.0 |
| 2005-07-15 08:30:00 | SPY | ETF | 122.94 | 122.98 | 122.72 | 122.74 | 881900.0 |
| 2005-07-15 09:00:00 | SPY | ETF | 122.79 | 122.85 | 122.76 | 122.78 | 189700.0 |
| 2005-07-15 09:30:00 | SPY | ETF | 122.79 | 122.84 | 122.52 | 122.57 | 13477500.0 |
| 2005-07-15 10:00:00 | SPY | ETF | 122.57 | 122.58 | 122.42 | 122.52 | 3685100.0 |
| 2005-07-15 10:30:00 | SPY | ETF | 122.52 | 122.64 | 122.44 | 122.5 | 2544700.0 |
| 2005-07-15 11:00:00 | SPY | ETF | 122.52 | 122.69 | 122.48 | 122.6 | 2832400.0 |
| 2005-07-15 11:30:00 | SPY | ETF | 122.6 | 122.63 | 122.44 | 122.54 | 1815300.0 |
| 2005-07-15 12:00:00 | SPY | ETF | 122.53 | 122.57 | 122.36 | 122.51 | 4697300.0 |
| 2005-07-15 12:30:00 | SPY | ETF | 122.52 | 122.55 | 122.41 | 122.47 | 1602400.0 |
| 2005-07-15 13:00:00 | SPY | ETF | 122.46 | 122.62 | 122.46 | 122.54 | 3986900.0 |
| 2005-07-15 13:30:00 | SPY | ETF | 122.55 | 122.63 | 122.53 | 122.58 | 1007800.0 |
| 2005-07-15 14:00:00 | SPY | ETF | 122.58 | 122.82 | 122.55 | 122.78 | 4179500.0 |
| 2005-07-15 14:30:00 | SPY | ETF | 122.86 | 123.04 | 122.6339 | 122.96 | 3797400.0 |
| 2005-07-15 15:00:00 | SPY | ETF | 122.95 | 122.99 | 122.73 | 122.75 | 2136000.0 |
| 2005-07-15 15:30:00 | SPY | ETF | 122.76 | 122.88 | 122.7 | 122.78 | 5996900.0 |
| 2005-07-15 16:00:00 | SPY | ETF | 122.77 | 122.88 | 122.77 | 122.81 | 1372500.0 |
| 2005-07-15 16:30:00 | SPY | ETF | 122.81 | 122.85 | 122.78 | 122.79 | 19700.0 |
| 2005-07-15 17:00:00 | SPY | ETF | 122.8 | 122.82 | 122.76 | 122.82 | 43300.0 |
| 2005-07-15 18:00:00 | SPY | ETF | 122.8 | 122.8 | 122.8 | 122.8 | 200.0 |
| 2005-07-15 18:30:00 | SPY | ETF | 122.8 | 122.8 | 122.79 | 122.79 | 200.0 |
| 2005-07-15 09:30:00 | QQQ | ETF | 38.84 | 38.86 | 38.69 | 38.72 | 10559800.0 |
| 2005-07-15 10:00:00 | QQQ | ETF | 38.71 | 38.75 | 38.66 | 38.69 | 7122600.0 |
| 2005-07-15 10:30:00 | QQQ | ETF | 38.69 | 38.74 | 38.65 | 38.69 | 4324000.0 |
| 2005-07-15 11:00:00 | QQQ | ETF | 38.69 | 38.79 | 38.69 | 38.77 | 3969500.0 |
| 2005-07-15 11:30:00 | QQQ | ETF | 38.77 | 38.79 | 38.7 | 38.74 | 3324500.0 |
| 2005-07-15 12:00:00 | QQQ | ETF | 38.75 | 38.76 | 38.69 | 38.76 | 3298900.0 |
| 2005-07-15 12:30:00 | QQQ | ETF | 38.75 | 38.76 | 38.7 | 38.72 | 1168300.0 |
| 2005-07-15 13:00:00 | QQQ | ETF | 38.72 | 38.79 | 38.71 | 38.76 | 1398700.0 |
| 2005-07-15 13:30:00 | QQQ | ETF | 38.77 | 38.78 | 38.73 | 38.77 | 2580300.0 |
| 2005-07-15 14:00:00 | QQQ | ETF | 38.77 | 38.87 | 38.75 | 38.82 | 4708700.0 |
| 2005-07-15 14:30:00 | QQQ | ETF | 38.82 | 38.99 | 38.8 | 38.99 | 9265300.0 |
| 2005-07-15 15:00:00 | QQQ | ETF | 38.99 | 39.0 | 38.88 | 38.89 | 5300500.0 |
| 2005-07-15 15:30:00 | QQQ | ETF | 38.89 | 38.91 | 38.85 | 38.88 | 7044800.0 |
| 2005-07-15 08:30:00 | IWM | ETF | 65.97 | 65.97 | 65.9 | 65.9 | 6000.0 |
| 2005-07-15 09:00:00 | IWM | ETF | 65.91 | 65.91 | 65.91 | 65.91 | 2000.0 |
| 2005-07-15 09:30:00 | IWM | ETF | 65.95 | 65.95 | 65.53 | 65.68 | 2072700.0 |
| 2005-07-15 10:00:00 | IWM | ETF | 65.69 | 65.7 | 65.42 | 65.5 | 2232000.0 |
| 2005-07-15 10:30:00 | IWM | ETF | 65.5 | 65.61 | 65.46 | 65.52 | 1645200.0 |
| 2005-07-15 11:00:00 | IWM | ETF | 65.53 | 65.79 | 65.53 | 65.72 | 1568600.0 |
| 2005-07-15 11:30:00 | IWM | ETF | 65.72 | 65.74 | 65.53 | 65.6 | 678600.0 |
| 2005-07-15 12:00:00 | IWM | ETF | 65.6 | 65.64 | 65.49 | 65.61 | 378300.0 |
| 2005-07-15 12:30:00 | IWM | ETF | 65.61 | 65.67 | 65.59 | 65.66 | 310800.0 |
| 2005-07-15 13:00:00 | IWM | ETF | 65.66 | 65.76 | 65.64 | 65.72 | 541100.0 |
| 2005-07-15 13:30:00 | IWM | ETF | 65.71 | 65.78 | 65.68 | 65.74 | 247200.0 |
| 2005-07-15 14:00:00 | IWM | ETF | 65.74 | 65.94 | 65.71 | 65.94 | 968500.0 |
| 2005-07-15 14:30:00 | IWM | ETF | 65.95 | 66.16 | 65.86 | 66.14 | 2237700.0 |
| 2005-07-15 15:00:00 | IWM | ETF | 66.14 | 66.2 | 65.99 | 65.99 | 1228500.0 |
> showing 50 of 1,557 rows — these rows as CSV