PREVIEW / etf_30min / 2006-05-11
file: by_date/etf_30min/2006/2006-05-11.parquet size: 69 KB rows: 2,362
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-05-11 06:00:00 | SPY | ETF | 132.72 | 132.72 | 132.72 | 132.72 | 500.0 |
| 2006-05-11 06:30:00 | SPY | ETF | 132.65 | 132.65 | 132.65 | 132.65 | 400.0 |
| 2006-05-11 07:00:00 | SPY | ETF | 132.66 | 132.66 | 132.66 | 132.66 | 1000.0 |
| 2006-05-11 07:30:00 | SPY | ETF | 132.65 | 132.65 | 132.55 | 132.55 | 143500.0 |
| 2006-05-11 08:00:00 | SPY | ETF | 132.56 | 132.65 | 132.53 | 132.6 | 741100.0 |
| 2006-05-11 08:30:00 | SPY | ETF | 132.62 | 132.79 | 132.61 | 132.64 | 446600.0 |
| 2006-05-11 09:00:00 | SPY | ETF | 132.59 | 132.62 | 132.49 | 132.5 | 181900.0 |
| 2006-05-11 09:30:00 | SPY | ETF | 132.51 | 132.55 | 131.9 | 132.06 | 6359700.0 |
| 2006-05-11 10:00:00 | SPY | ETF | 132.05 | 132.51 | 131.86 | 131.92 | 6766400.0 |
| 2006-05-11 10:30:00 | SPY | ETF | 131.92 | 131.96 | 131.5 | 131.55 | 6134900.0 |
| 2006-05-11 11:00:00 | SPY | ETF | 131.55 | 131.73 | 131.21 | 131.27 | 7589100.0 |
| 2006-05-11 11:30:00 | SPY | ETF | 131.27 | 131.46 | 131.2 | 131.26 | 6186800.0 |
| 2006-05-11 12:00:00 | SPY | ETF | 131.26 | 131.31 | 131.02 | 131.07 | 4139900.0 |
| 2006-05-11 12:30:00 | SPY | ETF | 131.07 | 131.2855 | 130.98 | 131.2376 | 4140100.0 |
| 2006-05-11 13:00:00 | SPY | ETF | 131.24 | 131.24 | 130.77 | 130.9 | 5868100.0 |
| 2006-05-11 13:30:00 | SPY | ETF | 130.9 | 131.02 | 130.76 | 130.96 | 5430300.0 |
| 2006-05-11 14:00:00 | SPY | ETF | 130.98 | 131.14 | 130.9 | 131.04 | 3937700.0 |
| 2006-05-11 14:30:00 | SPY | ETF | 131.04 | 131.1 | 130.6 | 130.7 | 3883400.0 |
| 2006-05-11 15:00:00 | SPY | ETF | 130.7 | 130.92 | 130.6 | 130.62 | 5428600.0 |
| 2006-05-11 15:30:00 | SPY | ETF | 130.62 | 130.8 | 130.52 | 130.78 | 6848700.0 |
| 2006-05-11 16:00:00 | SPY | ETF | 130.78 | 131.0 | 130.74 | 130.96 | 1721500.0 |
| 2006-05-11 16:30:00 | SPY | ETF | 130.96 | 130.99 | 130.91 | 130.95 | 365800.0 |
| 2006-05-11 17:00:00 | SPY | ETF | 130.97 | 131.0 | 130.93 | 131.0 | 103200.0 |
| 2006-05-11 17:30:00 | SPY | ETF | 130.99 | 131.0 | 130.96 | 131.0 | 22600.0 |
| 2006-05-11 18:00:00 | SPY | ETF | 131.0 | 131.0 | 131.0 | 131.0 | 18600.0 |
| 2006-05-11 18:30:00 | SPY | ETF | 131.0 | 131.01 | 130.99 | 131.01 | 9500.0 |
| 2006-05-11 19:30:00 | SPY | ETF | 130.98 | 130.98 | 130.98 | 130.98 | 3700.0 |
| 2006-05-11 09:30:00 | QQQ | ETF | 41.63 | 41.65 | 41.33 | 41.37 | 12637600.0 |
| 2006-05-11 10:00:00 | QQQ | ETF | 41.37 | 41.46 | 41.26 | 41.31 | 7985200.0 |
| 2006-05-11 10:30:00 | QQQ | ETF | 41.31 | 41.33 | 41.02 | 41.04 | 25142900.0 |
| 2006-05-11 11:00:00 | QQQ | ETF | 41.04 | 41.1 | 40.78 | 40.81 | 13640200.0 |
| 2006-05-11 11:30:00 | QQQ | ETF | 40.81 | 40.93 | 40.7 | 40.84 | 7737500.0 |
| 2006-05-11 12:00:00 | QQQ | ETF | 40.84 | 40.91 | 40.79 | 40.84 | 9622500.0 |
| 2006-05-11 12:30:00 | QQQ | ETF | 40.85 | 40.95 | 40.82 | 40.94 | 5219900.0 |
| 2006-05-11 13:00:00 | QQQ | ETF | 40.94 | 40.95 | 40.76 | 40.82 | 6468100.0 |
| 2006-05-11 13:30:00 | QQQ | ETF | 40.83 | 40.86 | 40.78 | 40.84 | 3409200.0 |
| 2006-05-11 14:00:00 | QQQ | ETF | 40.83 | 40.94 | 40.82 | 40.9 | 4959400.0 |
| 2006-05-11 14:30:00 | QQQ | ETF | 40.91 | 40.91 | 40.68 | 40.71 | 10119500.0 |
| 2006-05-11 15:00:00 | QQQ | ETF | 40.72 | 40.82 | 40.67 | 40.7 | 9255700.0 |
| 2006-05-11 15:30:00 | QQQ | ETF | 40.7 | 40.79 | 40.63 | 40.73 | 14741400.0 |
| 2006-05-11 08:00:00 | IWM | ETF | 77.19 | 77.25 | 77.19 | 77.25 | 3200.0 |
| 2006-05-11 08:30:00 | IWM | ETF | 77.27 | 77.35 | 77.18 | 77.18 | 13500.0 |
| 2006-05-11 09:00:00 | IWM | ETF | 77.15 | 77.15 | 77.12 | 77.12 | 23000.0 |
| 2006-05-11 09:30:00 | IWM | ETF | 77.12 | 77.16 | 76.66 | 76.72 | 1906600.0 |
| 2006-05-11 10:00:00 | IWM | ETF | 76.7 | 76.86 | 76.6 | 76.7 | 2685400.0 |
| 2006-05-11 10:30:00 | IWM | ETF | 76.7 | 76.75 | 76.35 | 76.39 | 3010200.0 |
| 2006-05-11 11:00:00 | IWM | ETF | 76.39 | 76.5 | 76.13 | 76.14 | 1448700.0 |
| 2006-05-11 11:30:00 | IWM | ETF | 76.14 | 76.27 | 75.88 | 75.89 | 4978600.0 |
| 2006-05-11 12:00:00 | IWM | ETF | 75.91 | 76.01 | 75.74 | 75.75 | 6440300.0 |
| 2006-05-11 12:30:00 | IWM | ETF | 75.75 | 75.9 | 75.68 | 75.85 | 2036900.0 |
> showing 50 of 2,362 rows — these rows as CSV