PREVIEW / etf_30min / 2006-03-22
file: by_date/etf_30min/2006/2006-03-22.parquet size: 59 KB rows: 2,172
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-22 04:00:00 | SPY | ETF | 129.62 | 129.62 | 129.62 | 129.62 | 300.0 |
| 2006-03-22 06:30:00 | SPY | ETF | 129.68 | 129.68 | 129.68 | 129.68 | 3000.0 |
| 2006-03-22 07:00:00 | SPY | ETF | 129.68 | 129.68 | 129.68 | 129.68 | 2000.0 |
| 2006-03-22 07:30:00 | SPY | ETF | 129.69 | 129.7 | 129.51 | 129.53 | 104900.0 |
| 2006-03-22 08:00:00 | SPY | ETF | 129.55 | 129.69 | 129.48 | 129.56 | 216300.0 |
| 2006-03-22 08:30:00 | SPY | ETF | 129.55 | 129.63 | 129.52 | 129.62 | 236900.0 |
| 2006-03-22 09:00:00 | SPY | ETF | 129.62 | 129.67 | 129.47 | 129.5 | 244700.0 |
| 2006-03-22 09:30:00 | SPY | ETF | 129.51 | 129.76 | 129.45 | 129.72 | 7712900.0 |
| 2006-03-22 10:00:00 | SPY | ETF | 129.71 | 130.05 | 129.69 | 129.9 | 4965700.0 |
| 2006-03-22 10:30:00 | SPY | ETF | 129.9 | 130.1 | 129.74 | 129.75 | 3521500.0 |
| 2006-03-22 11:00:00 | SPY | ETF | 129.75 | 130.05 | 129.74 | 129.87 | 3448000.0 |
| 2006-03-22 11:30:00 | SPY | ETF | 129.89 | 130.19 | 129.85 | 130.11 | 3230500.0 |
| 2006-03-22 12:00:00 | SPY | ETF | 130.11 | 130.25 | 130.07 | 130.09 | 2266000.0 |
| 2006-03-22 12:30:00 | SPY | ETF | 130.08 | 130.15 | 130.03 | 130.14 | 2436000.0 |
| 2006-03-22 13:00:00 | SPY | ETF | 130.14 | 130.29 | 130.11 | 130.21 | 2067100.0 |
| 2006-03-22 13:30:00 | SPY | ETF | 130.21 | 130.33 | 130.16 | 130.25 | 2035500.0 |
| 2006-03-22 14:00:00 | SPY | ETF | 130.24 | 130.31 | 129.93 | 129.98 | 3170600.0 |
| 2006-03-22 14:30:00 | SPY | ETF | 129.98 | 130.22 | 129.92 | 130.13 | 2679800.0 |
| 2006-03-22 15:00:00 | SPY | ETF | 130.16 | 130.29 | 130.05 | 130.24 | 2366900.0 |
| 2006-03-22 15:30:00 | SPY | ETF | 130.24 | 130.51 | 130.23 | 130.4 | 4242500.0 |
| 2006-03-22 16:00:00 | SPY | ETF | 130.4 | 130.43 | 130.32 | 130.35 | 731000.0 |
| 2006-03-22 16:30:00 | SPY | ETF | 130.35 | 130.39 | 130.34 | 130.37 | 3627300.0 |
| 2006-03-22 17:00:00 | SPY | ETF | 130.37 | 130.4 | 130.34 | 130.34 | 53400.0 |
| 2006-03-22 17:30:00 | SPY | ETF | 130.4 | 130.4 | 130.34 | 130.34 | 500.0 |
| 2006-03-22 18:00:00 | SPY | ETF | 130.4 | 130.41 | 130.4 | 130.4 | 1200.0 |
| 2006-03-22 18:30:00 | SPY | ETF | 130.42 | 130.43 | 130.42 | 130.42 | 4700.0 |
| 2006-03-22 19:00:00 | SPY | ETF | 130.42 | 130.42 | 130.42 | 130.42 | 500.0 |
| 2006-03-22 19:30:00 | SPY | ETF | 130.43 | 130.43 | 130.43 | 130.43 | 100.0 |
| 2006-03-22 09:30:00 | QQQ | ETF | 40.88 | 41.08 | 40.86 | 41.0 | 15179200.0 |
| 2006-03-22 10:00:00 | QQQ | ETF | 41.0 | 41.21 | 40.99 | 41.09 | 13829400.0 |
| 2006-03-22 10:30:00 | QQQ | ETF | 41.09 | 41.14 | 40.93 | 40.93 | 10439400.0 |
| 2006-03-22 11:00:00 | QQQ | ETF | 40.93 | 41.18 | 40.93 | 41.02 | 13225100.0 |
| 2006-03-22 11:30:00 | QQQ | ETF | 41.03 | 41.18 | 41.01 | 41.12 | 5516800.0 |
| 2006-03-22 12:00:00 | QQQ | ETF | 41.12 | 41.21 | 41.12 | 41.15 | 5286800.0 |
| 2006-03-22 12:30:00 | QQQ | ETF | 41.15 | 41.2 | 41.12 | 41.16 | 3443600.0 |
| 2006-03-22 13:00:00 | QQQ | ETF | 41.17 | 41.22 | 41.14 | 41.21 | 4894000.0 |
| 2006-03-22 13:30:00 | QQQ | ETF | 41.21 | 41.25 | 41.15 | 41.19 | 4032300.0 |
| 2006-03-22 14:00:00 | QQQ | ETF | 41.18 | 41.22 | 41.04 | 41.07 | 4755500.0 |
| 2006-03-22 14:30:00 | QQQ | ETF | 41.06 | 41.16 | 41.0 | 41.11 | 3655200.0 |
| 2006-03-22 15:00:00 | QQQ | ETF | 41.11 | 41.18 | 41.01 | 41.14 | 8805200.0 |
| 2006-03-22 15:30:00 | QQQ | ETF | 41.14 | 41.28 | 41.14 | 41.21 | 9067500.0 |
| 2006-03-22 07:30:00 | IWM | ETF | 73.05 | 73.05 | 72.95 | 72.98 | 12100.0 |
| 2006-03-22 08:00:00 | IWM | ETF | 72.98 | 73.04 | 72.95 | 73.03 | 58100.0 |
| 2006-03-22 08:30:00 | IWM | ETF | 73.02 | 73.05 | 72.99 | 73.05 | 39200.0 |
| 2006-03-22 09:00:00 | IWM | ETF | 73.05 | 73.05 | 72.86 | 72.98 | 87200.0 |
| 2006-03-22 09:30:00 | IWM | ETF | 72.99 | 73.27 | 72.89 | 73.03 | 4622700.0 |
| 2006-03-22 10:00:00 | IWM | ETF | 73.02 | 73.47 | 73.0 | 73.34 | 2771800.0 |
| 2006-03-22 10:30:00 | IWM | ETF | 73.33 | 73.51 | 73.17 | 73.18 | 3418000.0 |
| 2006-03-22 11:00:00 | IWM | ETF | 73.18 | 73.49 | 73.18 | 73.37 | 1266600.0 |
| 2006-03-22 11:30:00 | IWM | ETF | 73.37 | 73.66 | 73.35 | 73.62 | 1781700.0 |
> showing 50 of 2,172 rows — these rows as CSV