PREVIEW / etf_30min / 2006-03-23
file: by_date/etf_30min/2006/2006-03-23.parquet size: 59 KB rows: 2,183
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 |
|---|---|---|---|---|---|---|---|
| 2006-03-23 07:00:00 | SPY | ETF | 130.19 | 130.21 | 130.18 | 130.19 | 2600.0 |
| 2006-03-23 07:30:00 | SPY | ETF | 130.28 | 130.28 | 130.21 | 130.28 | 31100.0 |
| 2006-03-23 08:00:00 | SPY | ETF | 130.29 | 130.3 | 130.19 | 130.3 | 360400.0 |
| 2006-03-23 08:30:00 | SPY | ETF | 130.28 | 130.28 | 130.23 | 130.27 | 76300.0 |
| 2006-03-23 09:00:00 | SPY | ETF | 130.27 | 130.34 | 130.27 | 130.28 | 147200.0 |
| 2006-03-23 09:30:00 | SPY | ETF | 130.24 | 130.34 | 130.16 | 130.27 | 3844700.0 |
| 2006-03-23 10:00:00 | SPY | ETF | 130.29 | 130.35 | 129.97 | 130.07 | 5542900.0 |
| 2006-03-23 10:30:00 | SPY | ETF | 130.07 | 130.1 | 129.71 | 129.83 | 6158800.0 |
| 2006-03-23 11:00:00 | SPY | ETF | 129.83 | 130.08 | 129.66 | 130.01 | 4276500.0 |
| 2006-03-23 11:30:00 | SPY | ETF | 130.01 | 130.3935 | 129.86 | 129.98 | 5528800.0 |
| 2006-03-23 12:00:00 | SPY | ETF | 129.99 | 130.0 | 129.84 | 129.93 | 1620500.0 |
| 2006-03-23 12:30:00 | SPY | ETF | 129.92 | 130.23 | 129.9 | 130.11 | 2195100.0 |
| 2006-03-23 13:00:00 | SPY | ETF | 130.11 | 130.18 | 129.98 | 130.09 | 1117900.0 |
| 2006-03-23 13:30:00 | SPY | ETF | 130.09 | 130.17 | 129.97 | 130.13 | 1850900.0 |
| 2006-03-23 14:00:00 | SPY | ETF | 130.15 | 130.21 | 129.81 | 130.0 | 2707800.0 |
| 2006-03-23 14:30:00 | SPY | ETF | 130.0 | 130.17 | 129.67 | 129.84 | 2208600.0 |
| 2006-03-23 15:00:00 | SPY | ETF | 129.84 | 130.08 | 129.75 | 130.07 | 2043100.0 |
| 2006-03-23 15:30:00 | SPY | ETF | 130.09 | 130.1 | 129.96 | 130.08 | 4210400.0 |
| 2006-03-23 16:00:00 | SPY | ETF | 130.08 | 130.2 | 130.0088 | 130.09 | 951000.0 |
| 2006-03-23 16:30:00 | SPY | ETF | 130.13 | 130.13 | 130.08 | 130.09 | 78300.0 |
| 2006-03-23 17:00:00 | SPY | ETF | 130.08 | 130.16 | 130.08 | 130.13 | 12100.0 |
| 2006-03-23 17:30:00 | SPY | ETF | 130.08 | 130.21 | 129.95 | 129.96 | 362400.0 |
| 2006-03-23 18:00:00 | SPY | ETF | 129.96 | 130.04 | 129.93 | 130.04 | 116900.0 |
| 2006-03-23 18:30:00 | SPY | ETF | 130.0 | 130.0 | 129.94 | 130.0 | 3800.0 |
| 2006-03-23 19:00:00 | SPY | ETF | 129.94 | 129.99 | 129.94 | 129.99 | 4300.0 |
| 2006-03-23 19:30:00 | SPY | ETF | 130.0 | 130.0 | 129.97 | 130.0 | 2200.0 |
| 2006-03-23 09:30:00 | QQQ | ETF | 41.09 | 41.21 | 41.05 | 41.17 | 7124100.0 |
| 2006-03-23 10:00:00 | QQQ | ETF | 41.18 | 41.22 | 40.97 | 41.01 | 7867500.0 |
| 2006-03-23 10:30:00 | QQQ | ETF | 41.0 | 41.02 | 40.82 | 40.93 | 10314800.0 |
| 2006-03-23 11:00:00 | QQQ | ETF | 40.93 | 41.04 | 40.84 | 41.03 | 7147300.0 |
| 2006-03-23 11:30:00 | QQQ | ETF | 41.04 | 41.06 | 40.96 | 40.99 | 4134600.0 |
| 2006-03-23 12:00:00 | QQQ | ETF | 40.99 | 41.01 | 40.92 | 40.98 | 2177200.0 |
| 2006-03-23 12:30:00 | QQQ | ETF | 40.99 | 41.14 | 40.97 | 41.04 | 3513800.0 |
| 2006-03-23 13:00:00 | QQQ | ETF | 41.03 | 41.1 | 40.99 | 41.06 | 1983200.0 |
| 2006-03-23 13:30:00 | QQQ | ETF | 41.06 | 41.11 | 41.0 | 41.1 | 2210600.0 |
| 2006-03-23 14:00:00 | QQQ | ETF | 41.1 | 41.12 | 40.92 | 40.99 | 5440700.0 |
| 2006-03-23 14:30:00 | QQQ | ETF | 40.99 | 41.0 | 40.87 | 40.94 | 2672800.0 |
| 2006-03-23 15:00:00 | QQQ | ETF | 40.93 | 41.09 | 40.9 | 41.09 | 4561700.0 |
| 2006-03-23 15:30:00 | QQQ | ETF | 41.09 | 41.1 | 41.03 | 41.09 | 4595200.0 |
| 2006-03-23 07:30:00 | IWM | ETF | 74.0 | 74.0 | 74.0 | 74.0 | 100.0 |
| 2006-03-23 08:00:00 | IWM | ETF | 74.12 | 74.12 | 74.0 | 74.03 | 7200.0 |
| 2006-03-23 08:30:00 | IWM | ETF | 74.03 | 74.04 | 74.03 | 74.03 | 1600.0 |
| 2006-03-23 09:00:00 | IWM | ETF | 74.03 | 74.08 | 73.99 | 74.01 | 382600.0 |
| 2006-03-23 09:30:00 | IWM | ETF | 74.03 | 74.22 | 73.86 | 74.15 | 2821300.0 |
| 2006-03-23 10:00:00 | IWM | ETF | 74.15 | 74.27 | 73.88 | 74.03 | 1706000.0 |
| 2006-03-23 10:30:00 | IWM | ETF | 74.02 | 74.06 | 73.75 | 73.94 | 1673200.0 |
| 2006-03-23 11:00:00 | IWM | ETF | 73.94 | 74.29 | 73.8 | 74.19 | 1987200.0 |
| 2006-03-23 11:30:00 | IWM | ETF | 74.2 | 74.25 | 74.05 | 74.15 | 654500.0 |
| 2006-03-23 12:00:00 | IWM | ETF | 74.14 | 74.18 | 74.03 | 74.11 | 1288300.0 |
| 2006-03-23 12:30:00 | IWM | ETF | 74.1 | 74.34 | 74.1 | 74.24 | 1075700.0 |
> showing 50 of 2,183 rows — these rows as CSV