PREVIEW / etf_30min / 2005-11-07
file: by_date/etf_30min/2005/2005-11-07.parquet size: 50 KB rows: 1,790
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-11-07 07:00:00 | SPY | ETF | 122.25 | 122.25 | 122.25 | 122.25 | 200.0 |
| 2005-11-07 07:30:00 | SPY | ETF | 122.3 | 122.35 | 122.3 | 122.32 | 3800.0 |
| 2005-11-07 08:00:00 | SPY | ETF | 122.3 | 122.35 | 122.14 | 122.3 | 62800.0 |
| 2005-11-07 08:30:00 | SPY | ETF | 122.32 | 122.47 | 122.32 | 122.46 | 409300.0 |
| 2005-11-07 09:00:00 | SPY | ETF | 122.44 | 122.47 | 122.37 | 122.39 | 317700.0 |
| 2005-11-07 09:30:00 | SPY | ETF | 122.4 | 122.53 | 122.17 | 122.21 | 5611300.0 |
| 2005-11-07 10:00:00 | SPY | ETF | 122.2 | 122.3 | 121.85 | 121.94 | 8409400.0 |
| 2005-11-07 10:30:00 | SPY | ETF | 121.94 | 122.15 | 121.91 | 122.14 | 2854800.0 |
| 2005-11-07 11:00:00 | SPY | ETF | 122.13 | 122.19 | 121.88 | 122.0 | 1888400.0 |
| 2005-11-07 11:30:00 | SPY | ETF | 122.0 | 122.22 | 121.99 | 122.12 | 1380700.0 |
| 2005-11-07 12:00:00 | SPY | ETF | 122.11 | 122.36 | 122.1 | 122.25 | 3099400.0 |
| 2005-11-07 12:30:00 | SPY | ETF | 122.2599 | 122.29 | 122.06 | 122.26 | 2049200.0 |
| 2005-11-07 13:00:00 | SPY | ETF | 122.27 | 122.28 | 122.1 | 122.23 | 2126900.0 |
| 2005-11-07 13:30:00 | SPY | ETF | 122.23 | 122.36 | 122.16 | 122.23 | 2104800.0 |
| 2005-11-07 14:00:00 | SPY | ETF | 122.23 | 122.57 | 122.11 | 122.54 | 3541500.0 |
| 2005-11-07 14:30:00 | SPY | ETF | 122.53 | 122.62 | 122.44 | 122.54 | 3694800.0 |
| 2005-11-07 15:00:00 | SPY | ETF | 122.55 | 122.58 | 122.21 | 122.24 | 3522000.0 |
| 2005-11-07 15:30:00 | SPY | ETF | 122.24 | 122.5 | 122.23 | 122.44 | 4019200.0 |
| 2005-11-07 16:00:00 | SPY | ETF | 122.43 | 122.43 | 122.19 | 122.19 | 622500.0 |
| 2005-11-07 16:30:00 | SPY | ETF | 122.2 | 122.22 | 122.15 | 122.21 | 97800.0 |
| 2005-11-07 17:00:00 | SPY | ETF | 122.22 | 122.22 | 122.22 | 122.22 | 100.0 |
| 2005-11-07 17:30:00 | SPY | ETF | 122.23 | 122.27 | 122.22 | 122.23 | 10900.0 |
| 2005-11-07 18:00:00 | SPY | ETF | 122.2 | 122.21 | 122.19 | 122.19 | 600.0 |
| 2005-11-07 19:30:00 | SPY | ETF | 122.22 | 122.22 | 122.22 | 122.22 | 200.0 |
| 2005-11-07 09:30:00 | QQQ | ETF | 40.2 | 40.29 | 40.1 | 40.11 | 12332500.0 |
| 2005-11-07 10:00:00 | QQQ | ETF | 40.12 | 40.18 | 39.95 | 40.02 | 8147300.0 |
| 2005-11-07 10:30:00 | QQQ | ETF | 40.01 | 40.1 | 40.0 | 40.09 | 3492800.0 |
| 2005-11-07 11:00:00 | QQQ | ETF | 40.09 | 40.13 | 40.02 | 40.06 | 3204100.0 |
| 2005-11-07 11:30:00 | QQQ | ETF | 40.05 | 40.15 | 40.05 | 40.09 | 2926600.0 |
| 2005-11-07 12:00:00 | QQQ | ETF | 40.09 | 40.22 | 40.09 | 40.17 | 2984900.0 |
| 2005-11-07 12:30:00 | QQQ | ETF | 40.16 | 40.2 | 40.09 | 40.19 | 4677200.0 |
| 2005-11-07 13:00:00 | QQQ | ETF | 40.19 | 40.2 | 40.11 | 40.15 | 2997300.0 |
| 2005-11-07 13:30:00 | QQQ | ETF | 40.15 | 40.21 | 40.12 | 40.14 | 2399600.0 |
| 2005-11-07 14:00:00 | QQQ | ETF | 40.15 | 40.26 | 40.11 | 40.24 | 5168500.0 |
| 2005-11-07 14:30:00 | QQQ | ETF | 40.24 | 40.27 | 40.17 | 40.2 | 5025700.0 |
| 2005-11-07 15:00:00 | QQQ | ETF | 40.2 | 40.23 | 40.06 | 40.06 | 4886500.0 |
| 2005-11-07 15:30:00 | QQQ | ETF | 40.06 | 40.15 | 40.06 | 40.13 | 4096700.0 |
| 2005-11-07 08:00:00 | IWM | ETF | 65.59 | 65.66 | 65.58 | 65.66 | 214500.0 |
| 2005-11-07 08:30:00 | IWM | ETF | 65.73 | 65.83 | 65.72 | 65.76 | 29100.0 |
| 2005-11-07 09:00:00 | IWM | ETF | 65.75 | 65.76 | 65.73 | 65.73 | 2400.0 |
| 2005-11-07 09:30:00 | IWM | ETF | 65.73 | 65.9 | 65.5 | 65.6 | 2007400.0 |
| 2005-11-07 10:00:00 | IWM | ETF | 65.61 | 65.66 | 65.28 | 65.33 | 1853200.0 |
| 2005-11-07 10:30:00 | IWM | ETF | 65.32 | 65.56 | 65.3 | 65.54 | 662400.0 |
| 2005-11-07 11:00:00 | IWM | ETF | 65.54 | 65.55 | 65.26 | 65.38 | 740800.0 |
| 2005-11-07 11:30:00 | IWM | ETF | 65.39 | 65.55 | 65.37 | 65.39 | 523700.0 |
| 2005-11-07 12:00:00 | IWM | ETF | 65.4 | 65.65 | 65.34 | 65.61 | 1127400.0 |
| 2005-11-07 12:30:00 | IWM | ETF | 65.61 | 65.76 | 65.49 | 65.74 | 1826500.0 |
| 2005-11-07 13:00:00 | IWM | ETF | 65.74 | 65.76 | 65.59 | 65.63 | 639000.0 |
| 2005-11-07 13:30:00 | IWM | ETF | 65.63 | 65.72 | 65.57 | 65.57 | 660000.0 |
| 2005-11-07 14:00:00 | IWM | ETF | 65.56 | 65.93 | 65.51 | 65.93 | 1763300.0 |
> showing 50 of 1,790 rows — these rows as CSV