PREVIEW / etf_30min / 2005-10-07
file: by_date/etf_30min/2005/2005-10-07.parquet size: 46 KB rows: 1,699
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-10-07 06:00:00 | SPY | ETF | 119.5 | 119.5 | 119.5 | 119.5 | 25000.0 |
| 2005-10-07 07:00:00 | SPY | ETF | 119.49 | 119.53 | 119.49 | 119.53 | 9400.0 |
| 2005-10-07 07:30:00 | SPY | ETF | 119.46 | 119.48 | 119.4 | 119.4 | 15400.0 |
| 2005-10-07 08:00:00 | SPY | ETF | 119.4 | 119.54 | 119.3 | 119.35 | 674100.0 |
| 2005-10-07 08:30:00 | SPY | ETF | 119.41 | 119.62 | 119.1 | 119.46 | 6380200.0 |
| 2005-10-07 09:00:00 | SPY | ETF | 119.5 | 119.78 | 119.21 | 119.71 | 1982000.0 |
| 2005-10-07 09:30:00 | SPY | ETF | 119.7 | 120.05 | 119.59 | 119.75 | 15216600.0 |
| 2005-10-07 10:00:00 | SPY | ETF | 119.76 | 119.99 | 119.33 | 119.51 | 11049400.0 |
| 2005-10-07 10:30:00 | SPY | ETF | 119.52 | 119.64 | 119.13 | 119.47 | 6838500.0 |
| 2005-10-07 11:00:00 | SPY | ETF | 119.48 | 119.62 | 119.33 | 119.56 | 3005900.0 |
| 2005-10-07 11:30:00 | SPY | ETF | 119.55 | 119.83 | 119.41 | 119.65 | 4255400.0 |
| 2005-10-07 12:00:00 | SPY | ETF | 119.65 | 119.75 | 119.44 | 119.5 | 2406400.0 |
| 2005-10-07 12:30:00 | SPY | ETF | 119.5 | 119.63 | 119.43 | 119.48 | 1361100.0 |
| 2005-10-07 13:00:00 | SPY | ETF | 119.49 | 119.68 | 119.42 | 119.57 | 1866500.0 |
| 2005-10-07 13:30:00 | SPY | ETF | 119.57 | 119.63 | 119.43 | 119.49 | 1536500.0 |
| 2005-10-07 14:00:00 | SPY | ETF | 119.48 | 119.51 | 119.25 | 119.36 | 2807500.0 |
| 2005-10-07 14:30:00 | SPY | ETF | 119.37 | 119.66 | 119.3 | 119.44 | 3392400.0 |
| 2005-10-07 15:00:00 | SPY | ETF | 119.44 | 119.61 | 119.36 | 119.51 | 3848800.0 |
| 2005-10-07 15:30:00 | SPY | ETF | 119.51 | 119.72 | 119.45 | 119.68 | 4956100.0 |
| 2005-10-07 16:00:00 | SPY | ETF | 119.68 | 119.68 | 119.45 | 119.54 | 540800.0 |
| 2005-10-07 16:30:00 | SPY | ETF | 119.52 | 119.55 | 119.181 | 119.48 | 1719000.0 |
| 2005-10-07 17:00:00 | SPY | ETF | 119.5 | 119.56 | 119.5 | 119.56 | 2300.0 |
| 2005-10-07 17:30:00 | SPY | ETF | 119.53 | 119.53 | 119.53 | 119.53 | 500.0 |
| 2005-10-07 18:00:00 | SPY | ETF | 119.55 | 119.56 | 119.53 | 119.55 | 1500.0 |
| 2005-10-07 18:30:00 | SPY | ETF | 119.53 | 119.53 | 119.53 | 119.53 | 700.0 |
| 2005-10-07 19:00:00 | SPY | ETF | 119.52 | 119.52 | 119.52 | 119.52 | 300.0 |
| 2005-10-07 19:30:00 | SPY | ETF | 119.52 | 119.52 | 119.52 | 119.52 | 300.0 |
| 2005-10-07 09:30:00 | QQQ | ETF | 38.42 | 38.57 | 38.36 | 38.47 | 12943200.0 |
| 2005-10-07 10:00:00 | QQQ | ETF | 38.47 | 38.48 | 38.25 | 38.32 | 9660400.0 |
| 2005-10-07 10:30:00 | QQQ | ETF | 38.32 | 38.38 | 38.18 | 38.35 | 10864400.0 |
| 2005-10-07 11:00:00 | QQQ | ETF | 38.35 | 38.39 | 38.27 | 38.33 | 4981500.0 |
| 2005-10-07 11:30:00 | QQQ | ETF | 38.33 | 38.43 | 38.27 | 38.39 | 3988600.0 |
| 2005-10-07 12:00:00 | QQQ | ETF | 38.37 | 38.42 | 38.3 | 38.35 | 3405100.0 |
| 2005-10-07 12:30:00 | QQQ | ETF | 38.35 | 38.36 | 38.29 | 38.32 | 1945100.0 |
| 2005-10-07 13:00:00 | QQQ | ETF | 38.31 | 38.37 | 38.27 | 38.32 | 6271300.0 |
| 2005-10-07 13:30:00 | QQQ | ETF | 38.33 | 38.4 | 38.27 | 38.31 | 4203700.0 |
| 2005-10-07 14:00:00 | QQQ | ETF | 38.32 | 38.34 | 38.22 | 38.26 | 5732800.0 |
| 2005-10-07 14:30:00 | QQQ | ETF | 38.26 | 38.38 | 38.26 | 38.31 | 2878900.0 |
| 2005-10-07 15:00:00 | QQQ | ETF | 38.31 | 38.36 | 38.26 | 38.32 | 3788800.0 |
| 2005-10-07 15:30:00 | QQQ | ETF | 38.32 | 38.37 | 38.29 | 38.34 | 6104000.0 |
| 2005-10-07 08:00:00 | IWM | ETF | 63.74 | 63.81 | 63.71 | 63.8 | 22900.0 |
| 2005-10-07 08:30:00 | IWM | ETF | 63.64 | 63.86 | 63.53 | 63.84 | 65100.0 |
| 2005-10-07 09:00:00 | IWM | ETF | 63.88 | 64.0 | 63.86 | 64.0 | 131000.0 |
| 2005-10-07 09:30:00 | IWM | ETF | 64.0 | 64.18 | 63.77 | 64.06 | 3203900.0 |
| 2005-10-07 10:00:00 | IWM | ETF | 64.07 | 64.1 | 63.62 | 63.83 | 3668200.0 |
| 2005-10-07 10:30:00 | IWM | ETF | 63.83 | 63.95 | 63.6 | 63.69 | 1870600.0 |
| 2005-10-07 11:00:00 | IWM | ETF | 63.69 | 63.9388 | 63.66 | 63.93 | 2506700.0 |
| 2005-10-07 11:30:00 | IWM | ETF | 63.93 | 64.13 | 63.8 | 64.06 | 892900.0 |
| 2005-10-07 12:00:00 | IWM | ETF | 64.05 | 64.23 | 64.0 | 64.06 | 1402600.0 |
| 2005-10-07 12:30:00 | IWM | ETF | 64.06 | 64.14 | 64.01 | 64.01 | 671300.0 |
> showing 50 of 1,699 rows — these rows as CSV