PREVIEW / etf_30min / 2005-05-18
file: by_date/etf_30min/2005/2005-05-18.parquet size: 46 KB rows: 1,566
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-05-18 05:00:00 | SPY | ETF | 117.51 | 117.51 | 117.51 | 117.51 | 1500.0 |
| 2005-05-18 07:00:00 | SPY | ETF | 117.48 | 117.53 | 117.48 | 117.52 | 31100.0 |
| 2005-05-18 07:30:00 | SPY | ETF | 117.55 | 117.55 | 117.51 | 117.54 | 33000.0 |
| 2005-05-18 08:00:00 | SPY | ETF | 117.56 | 117.7 | 117.53 | 117.64 | 133000.0 |
| 2005-05-18 08:30:00 | SPY | ETF | 117.64 | 118.13 | 117.64 | 118.08 | 971600.0 |
| 2005-05-18 09:00:00 | SPY | ETF | 118.09 | 118.15 | 118.03 | 118.06 | 329300.0 |
| 2005-05-18 09:30:00 | SPY | ETF | 118.07 | 118.35 | 118.01 | 118.1 | 12215600.0 |
| 2005-05-18 10:00:00 | SPY | ETF | 118.1 | 118.46 | 118.08 | 118.45 | 7127300.0 |
| 2005-05-18 10:30:00 | SPY | ETF | 118.46 | 118.57 | 118.35 | 118.45 | 8860900.0 |
| 2005-05-18 11:00:00 | SPY | ETF | 118.44 | 118.53 | 118.34 | 118.43 | 3918500.0 |
| 2005-05-18 11:30:00 | SPY | ETF | 118.43 | 118.58 | 118.37 | 118.47 | 3101000.0 |
| 2005-05-18 12:00:00 | SPY | ETF | 118.49 | 118.91 | 118.49 | 118.77 | 4817100.0 |
| 2005-05-18 12:30:00 | SPY | ETF | 118.78 | 119.04 | 118.74 | 118.99 | 5494100.0 |
| 2005-05-18 13:00:00 | SPY | ETF | 118.99 | 119.08 | 118.76 | 118.87 | 6669000.0 |
| 2005-05-18 13:30:00 | SPY | ETF | 118.87 | 118.99 | 118.66 | 118.68 | 3685300.0 |
| 2005-05-18 14:00:00 | SPY | ETF | 118.68 | 118.91 | 118.65 | 118.85 | 3263700.0 |
| 2005-05-18 14:30:00 | SPY | ETF | 118.84 | 119.05 | 118.7 | 118.93 | 3116100.0 |
| 2005-05-18 15:00:00 | SPY | ETF | 118.92 | 119.0 | 118.78 | 118.8 | 3222400.0 |
| 2005-05-18 15:30:00 | SPY | ETF | 118.79 | 118.88 | 118.66 | 118.79 | 6134000.0 |
| 2005-05-18 16:00:00 | SPY | ETF | 118.79 | 118.9 | 118.76 | 118.87 | 1212400.0 |
| 2005-05-18 16:30:00 | SPY | ETF | 118.8 | 118.82 | 118.77 | 118.78 | 306000.0 |
| 2005-05-18 17:00:00 | SPY | ETF | 118.77 | 118.8 | 118.74 | 118.74 | 110600.0 |
| 2005-05-18 17:30:00 | SPY | ETF | 118.77 | 118.77 | 118.75 | 118.75 | 200.0 |
| 2005-05-18 18:00:00 | SPY | ETF | 118.74 | 118.78 | 118.74 | 118.78 | 8000.0 |
| 2005-05-18 18:30:00 | SPY | ETF | 118.78 | 118.79 | 118.78 | 118.79 | 2900.0 |
| 2005-05-18 19:00:00 | SPY | ETF | 118.76 | 118.76 | 118.76 | 118.76 | 700.0 |
| 2005-05-18 19:30:00 | SPY | ETF | 118.77 | 118.77 | 118.77 | 118.77 | 400.0 |
| 2005-05-18 09:30:00 | QQQ | ETF | 36.8 | 36.88 | 36.71 | 36.76 | 20636900.0 |
| 2005-05-18 10:00:00 | QQQ | ETF | 36.76 | 36.91 | 36.75 | 36.89 | 8900200.0 |
| 2005-05-18 10:30:00 | QQQ | ETF | 36.89 | 36.98 | 36.88 | 36.94 | 8797300.0 |
| 2005-05-18 11:00:00 | QQQ | ETF | 36.95 | 37.01 | 36.93 | 37.0 | 7836400.0 |
| 2005-05-18 11:30:00 | QQQ | ETF | 37.0 | 37.07 | 36.99 | 37.05 | 7786600.0 |
| 2005-05-18 12:00:00 | QQQ | ETF | 37.05 | 37.2 | 37.05 | 37.17 | 9454300.0 |
| 2005-05-18 12:30:00 | QQQ | ETF | 37.18 | 37.4 | 37.15 | 37.31 | 11049800.0 |
| 2005-05-18 13:00:00 | QQQ | ETF | 37.32 | 37.36 | 37.19 | 37.25 | 9603800.0 |
| 2005-05-18 13:30:00 | QQQ | ETF | 37.26 | 37.33 | 37.2 | 37.22 | 8238900.0 |
| 2005-05-18 14:00:00 | QQQ | ETF | 37.22 | 37.29 | 37.2 | 37.27 | 4811900.0 |
| 2005-05-18 14:30:00 | QQQ | ETF | 37.27 | 37.33 | 37.22 | 37.31 | 5910400.0 |
| 2005-05-18 15:00:00 | QQQ | ETF | 37.3 | 37.34 | 37.25 | 37.25 | 5298000.0 |
| 2005-05-18 15:30:00 | QQQ | ETF | 37.26 | 37.26 | 37.18 | 37.19 | 12673500.0 |
| 2005-05-18 08:30:00 | IWM | ETF | 59.5 | 59.67 | 59.5 | 59.66 | 4800.0 |
| 2005-05-18 09:00:00 | IWM | ETF | 59.67 | 59.715 | 59.63 | 59.64 | 3400.0 |
| 2005-05-18 09:30:00 | IWM | ETF | 59.62 | 59.875 | 59.605 | 59.655 | 4736600.0 |
| 2005-05-18 10:00:00 | IWM | ETF | 59.655 | 59.98 | 59.62 | 59.97 | 4671000.0 |
| 2005-05-18 10:30:00 | IWM | ETF | 59.97 | 60.105 | 59.88 | 60.055 | 3799200.0 |
| 2005-05-18 11:00:00 | IWM | ETF | 60.05 | 60.085 | 59.925 | 60.02 | 2911000.0 |
| 2005-05-18 11:30:00 | IWM | ETF | 60.02 | 60.15 | 59.94 | 60.115 | 1858400.0 |
| 2005-05-18 12:00:00 | IWM | ETF | 60.1105 | 60.45 | 60.11 | 60.42 | 3611800.0 |
| 2005-05-18 12:30:00 | IWM | ETF | 60.42 | 60.56 | 60.385 | 60.505 | 1766800.0 |
| 2005-05-18 13:00:00 | IWM | ETF | 60.5 | 60.55 | 60.33 | 60.335 | 2133400.0 |
> showing 50 of 1,566 rows — these rows as CSV