PREVIEW / etf_30min / 2005-03-01
file: by_date/etf_30min/2005/2005-03-01.parquet size: 42 KB rows: 1,472
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-01 08:00:00 | SPY | ETF | 120.86 | 120.91 | 120.86 | 120.89 | 96800.0 |
| 2005-03-01 08:30:00 | SPY | ETF | 120.91 | 120.91 | 120.82 | 120.82 | 13300.0 |
| 2005-03-01 09:00:00 | SPY | ETF | 120.83 | 120.84 | 120.78 | 120.8 | 88500.0 |
| 2005-03-01 09:30:00 | SPY | ETF | 120.78 | 121.21 | 120.78 | 121.12 | 6177600.0 |
| 2005-03-01 10:00:00 | SPY | ETF | 121.12 | 121.48 | 121.03 | 121.21 | 8212300.0 |
| 2005-03-01 10:30:00 | SPY | ETF | 121.21 | 121.41 | 121.18 | 121.27 | 3329200.0 |
| 2005-03-01 11:00:00 | SPY | ETF | 121.27 | 121.28 | 121.01 | 121.06 | 2389600.0 |
| 2005-03-01 11:30:00 | SPY | ETF | 121.06 | 121.4 | 121.0 | 121.38 | 2133400.0 |
| 2005-03-01 12:00:00 | SPY | ETF | 121.34 | 121.36 | 121.21 | 121.25 | 2421100.0 |
| 2005-03-01 12:30:00 | SPY | ETF | 121.25 | 121.27 | 121.05 | 121.16 | 3008000.0 |
| 2005-03-01 13:00:00 | SPY | ETF | 121.17 | 121.25 | 120.91 | 120.98 | 2087400.0 |
| 2005-03-01 13:30:00 | SPY | ETF | 120.98 | 121.23 | 120.96 | 121.16 | 2096100.0 |
| 2005-03-01 14:00:00 | SPY | ETF | 121.17 | 121.33 | 121.15 | 121.19 | 2170800.0 |
| 2005-03-01 14:30:00 | SPY | ETF | 121.2 | 121.27 | 121.1 | 121.26 | 1394000.0 |
| 2005-03-01 15:00:00 | SPY | ETF | 121.26 | 121.47 | 121.25 | 121.47 | 3766000.0 |
| 2005-03-01 15:30:00 | SPY | ETF | 121.48 | 121.52 | 121.25 | 121.29 | 4129800.0 |
| 2005-03-01 16:00:00 | SPY | ETF | 121.29 | 121.35 | 120.6205 | 121.3 | 2064100.0 |
| 2005-03-01 16:30:00 | SPY | ETF | 121.29 | 121.29 | 121.01 | 121.03 | 245000.0 |
| 2005-03-01 17:00:00 | SPY | ETF | 121.03 | 121.06 | 121.01 | 121.03 | 24500.0 |
| 2005-03-01 17:30:00 | SPY | ETF | 121.03 | 121.24 | 121.01 | 121.24 | 11500.0 |
| 2005-03-01 18:00:00 | SPY | ETF | 121.05 | 121.05 | 121.03 | 121.03 | 1000.0 |
| 2005-03-01 19:30:00 | SPY | ETF | 121.03 | 121.03 | 121.0 | 121.0 | 2700.0 |
| 2005-03-01 09:30:00 | QQQ | ETF | 37.36 | 37.55 | 37.36 | 37.5 | 12677100.0 |
| 2005-03-01 10:00:00 | QQQ | ETF | 37.49 | 37.65 | 37.44 | 37.56 | 10920700.0 |
| 2005-03-01 10:30:00 | QQQ | ETF | 37.56 | 37.66 | 37.54 | 37.6 | 5369900.0 |
| 2005-03-01 11:00:00 | QQQ | ETF | 37.6 | 37.6 | 37.44 | 37.47 | 4576500.0 |
| 2005-03-01 11:30:00 | QQQ | ETF | 37.47 | 37.58 | 37.36 | 37.53 | 4937200.0 |
| 2005-03-01 12:00:00 | QQQ | ETF | 37.53 | 37.53 | 37.44 | 37.47 | 3757900.0 |
| 2005-03-01 12:30:00 | QQQ | ETF | 37.47 | 37.49 | 37.38 | 37.46 | 6242300.0 |
| 2005-03-01 13:00:00 | QQQ | ETF | 37.46 | 37.49 | 37.33 | 37.36 | 2840600.0 |
| 2005-03-01 13:30:00 | QQQ | ETF | 37.35 | 37.55 | 37.35 | 37.5 | 4048300.0 |
| 2005-03-01 14:00:00 | QQQ | ETF | 37.51 | 37.58 | 37.5 | 37.55 | 3756400.0 |
| 2005-03-01 14:30:00 | QQQ | ETF | 37.55 | 37.57 | 37.5 | 37.57 | 2982900.0 |
| 2005-03-01 15:00:00 | QQQ | ETF | 37.57 | 37.67 | 37.54 | 37.65 | 4859400.0 |
| 2005-03-01 15:30:00 | QQQ | ETF | 37.66 | 37.7 | 37.62 | 37.63 | 6146700.0 |
| 2005-03-01 09:00:00 | IWM | ETF | 63.315 | 63.315 | 63.24 | 63.245 | 33200.0 |
| 2005-03-01 09:30:00 | IWM | ETF | 63.33 | 63.52 | 63.32 | 63.44 | 3293200.0 |
| 2005-03-01 10:00:00 | IWM | ETF | 63.44 | 63.665 | 63.275 | 63.33 | 1399600.0 |
| 2005-03-01 10:30:00 | IWM | ETF | 63.34 | 63.5 | 63.24 | 63.4 | 703800.0 |
| 2005-03-01 11:00:00 | IWM | ETF | 63.39 | 63.405 | 63.14 | 63.2 | 780600.0 |
| 2005-03-01 11:30:00 | IWM | ETF | 63.195 | 63.6 | 63.195 | 63.515 | 1293000.0 |
| 2005-03-01 12:00:00 | IWM | ETF | 63.515 | 63.54 | 63.415 | 63.49 | 701800.0 |
| 2005-03-01 12:30:00 | IWM | ETF | 63.48 | 63.51 | 63.28 | 63.46 | 1674400.0 |
| 2005-03-01 13:00:00 | IWM | ETF | 63.46 | 63.54 | 63.295 | 63.32 | 466600.0 |
| 2005-03-01 13:30:00 | IWM | ETF | 63.33 | 63.55 | 63.32 | 63.485 | 1159400.0 |
| 2005-03-01 14:00:00 | IWM | ETF | 63.49 | 63.69 | 63.49 | 63.585 | 1132400.0 |
| 2005-03-01 14:30:00 | IWM | ETF | 63.6 | 63.64 | 63.46 | 63.56 | 617000.0 |
| 2005-03-01 15:00:00 | IWM | ETF | 63.56 | 63.79 | 63.505 | 63.75 | 2120200.0 |
| 2005-03-01 15:30:00 | IWM | ETF | 63.75 | 63.79 | 63.605 | 63.64 | 2348000.0 |
| 2005-03-01 16:00:00 | IWM | ETF | 63.62 | 63.695 | 63.605 | 63.63 | 566800.0 |
> showing 50 of 1,472 rows — these rows as CSV