PREVIEW / etf_30min / 2005-03-14
file: by_date/etf_30min/2005/2005-03-14.parquet size: 43 KB rows: 1,467
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-03-14 08:00:00 | SPY | ETF | 120.5 | 120.67 | 120.48 | 120.67 | 66200.0 |
| 2005-03-14 08:30:00 | SPY | ETF | 120.65 | 120.74 | 120.65 | 120.72 | 144600.0 |
| 2005-03-14 09:00:00 | SPY | ETF | 120.73 | 120.75 | 120.55 | 120.61 | 72800.0 |
| 2005-03-14 09:30:00 | SPY | ETF | 120.61 | 120.73 | 120.52 | 120.533 | 4109400.0 |
| 2005-03-14 10:00:00 | SPY | ETF | 120.53 | 120.69 | 120.48 | 120.66 | 2987700.0 |
| 2005-03-14 10:30:00 | SPY | ETF | 120.66 | 120.86 | 120.59 | 120.68 | 3482300.0 |
| 2005-03-14 11:00:00 | SPY | ETF | 120.72 | 120.84 | 120.59 | 120.72 | 2359100.0 |
| 2005-03-14 11:30:00 | SPY | ETF | 120.73 | 120.76 | 120.57 | 120.7 | 1150700.0 |
| 2005-03-14 12:00:00 | SPY | ETF | 120.7 | 120.82 | 120.65 | 120.66 | 2044200.0 |
| 2005-03-14 12:30:00 | SPY | ETF | 120.65 | 120.72 | 120.55 | 120.6 | 1326800.0 |
| 2005-03-14 13:00:00 | SPY | ETF | 120.6 | 120.79 | 120.38 | 120.42 | 2950600.0 |
| 2005-03-14 13:30:00 | SPY | ETF | 120.41 | 120.51 | 120.28 | 120.47 | 1677500.0 |
| 2005-03-14 14:00:00 | SPY | ETF | 120.48 | 120.59 | 120.38 | 120.39 | 1310700.0 |
| 2005-03-14 14:30:00 | SPY | ETF | 120.39 | 120.55 | 120.32 | 120.53 | 1710100.0 |
| 2005-03-14 15:00:00 | SPY | ETF | 120.51 | 120.95 | 120.51 | 120.91 | 3794000.0 |
| 2005-03-14 15:30:00 | SPY | ETF | 120.9 | 121.06 | 120.82 | 121.05 | 4846800.0 |
| 2005-03-14 16:00:00 | SPY | ETF | 121.05 | 121.14 | 121.0 | 121.08 | 567300.0 |
| 2005-03-14 16:30:00 | SPY | ETF | 121.08 | 121.16 | 121.08 | 121.14 | 181600.0 |
| 2005-03-14 17:00:00 | SPY | ETF | 121.14 | 121.21 | 121.13 | 121.2 | 6800.0 |
| 2005-03-14 17:30:00 | SPY | ETF | 121.2 | 121.21 | 121.18 | 121.18 | 1700.0 |
| 2005-03-14 18:00:00 | SPY | ETF | 121.22 | 121.22 | 121.18 | 121.2 | 1500.0 |
| 2005-03-14 19:30:00 | SPY | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 400.0 |
| 2005-03-14 09:30:00 | QQQ | ETF | 37.23 | 37.3 | 37.17 | 37.21 | 7910700.0 |
| 2005-03-14 10:00:00 | QQQ | ETF | 37.2 | 37.29 | 37.16 | 37.26 | 4948500.0 |
| 2005-03-14 10:30:00 | QQQ | ETF | 37.26 | 37.35 | 37.2 | 37.27 | 5403800.0 |
| 2005-03-14 11:00:00 | QQQ | ETF | 37.27 | 37.31 | 37.15 | 37.2 | 4070400.0 |
| 2005-03-14 11:30:00 | QQQ | ETF | 37.19 | 37.2 | 37.08 | 37.14 | 4244400.0 |
| 2005-03-14 12:00:00 | QQQ | ETF | 37.14 | 37.23 | 37.13 | 37.17 | 3094100.0 |
| 2005-03-14 12:30:00 | QQQ | ETF | 37.17 | 37.2 | 37.13 | 37.14 | 2062400.0 |
| 2005-03-14 13:00:00 | QQQ | ETF | 37.14 | 37.18 | 37.05 | 37.08 | 4333700.0 |
| 2005-03-14 13:30:00 | QQQ | ETF | 37.08 | 37.12 | 37.03 | 37.09 | 2835900.0 |
| 2005-03-14 14:00:00 | QQQ | ETF | 37.1 | 37.16 | 37.09 | 37.1 | 3647100.0 |
| 2005-03-14 14:30:00 | QQQ | ETF | 37.1 | 37.15 | 37.08 | 37.14 | 2621600.0 |
| 2005-03-14 15:00:00 | QQQ | ETF | 37.14 | 37.3 | 37.13 | 37.29 | 5266800.0 |
| 2005-03-14 15:30:00 | QQQ | ETF | 37.3 | 37.36 | 37.2 | 37.33 | 7693600.0 |
| 2005-03-14 09:00:00 | IWM | ETF | 62.7 | 62.705 | 62.65 | 62.685 | 46400.0 |
| 2005-03-14 09:30:00 | IWM | ETF | 62.73 | 62.835 | 62.59 | 62.595 | 2314600.0 |
| 2005-03-14 10:00:00 | IWM | ETF | 62.595 | 62.75 | 62.555 | 62.735 | 2083400.0 |
| 2005-03-14 10:30:00 | IWM | ETF | 62.73 | 62.89 | 62.695 | 62.825 | 1093800.0 |
| 2005-03-14 11:00:00 | IWM | ETF | 62.825 | 62.9 | 62.69 | 62.745 | 706200.0 |
| 2005-03-14 11:30:00 | IWM | ETF | 62.745 | 62.75 | 62.61 | 62.695 | 693000.0 |
| 2005-03-14 12:00:00 | IWM | ETF | 62.7 | 62.815 | 62.68 | 62.7 | 340400.0 |
| 2005-03-14 12:30:00 | IWM | ETF | 62.67 | 62.775 | 62.605 | 62.67 | 1114400.0 |
| 2005-03-14 13:00:00 | IWM | ETF | 62.66 | 62.725 | 62.5 | 62.535 | 577200.0 |
| 2005-03-14 13:30:00 | IWM | ETF | 62.53 | 62.565 | 62.435 | 62.45 | 1129600.0 |
| 2005-03-14 14:00:00 | IWM | ETF | 62.465 | 62.55 | 62.465 | 62.52 | 498800.0 |
| 2005-03-14 14:30:00 | IWM | ETF | 62.505 | 62.62 | 62.48 | 62.545 | 707200.0 |
| 2005-03-14 15:00:00 | IWM | ETF | 62.545 | 62.845 | 62.54 | 62.83 | 1105600.0 |
| 2005-03-14 15:30:00 | IWM | ETF | 62.835 | 62.915 | 62.765 | 62.845 | 1823400.0 |
| 2005-03-14 16:00:00 | IWM | ETF | 62.865 | 63.01 | 62.855 | 62.95 | 435600.0 |
> showing 50 of 1,467 rows — these rows as CSV