PREVIEW / etf_30min / 2005-07-22
file: by_date/etf_30min/2005/2005-07-22.parquet size: 45 KB rows: 1,607
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-07-22 05:30:00 | SPY | ETF | 122.8 | 122.8 | 122.8 | 122.8 | 1000.0 |
| 2005-07-22 06:00:00 | SPY | ETF | 122.6 | 122.6 | 122.6 | 122.6 | 1000.0 |
| 2005-07-22 07:00:00 | SPY | ETF | 122.63 | 122.63 | 122.63 | 122.63 | 400.0 |
| 2005-07-22 07:30:00 | SPY | ETF | 122.68 | 122.75 | 122.68 | 122.75 | 2200.0 |
| 2005-07-22 08:00:00 | SPY | ETF | 122.75 | 122.79 | 122.73 | 122.79 | 77600.0 |
| 2005-07-22 08:30:00 | SPY | ETF | 122.79 | 123.01 | 122.79 | 122.95 | 472000.0 |
| 2005-07-22 09:00:00 | SPY | ETF | 122.95 | 122.98 | 122.83 | 122.88 | 412900.0 |
| 2005-07-22 09:30:00 | SPY | ETF | 122.88 | 123.21 | 122.84 | 123.09 | 6514000.0 |
| 2005-07-22 10:00:00 | SPY | ETF | 123.1 | 123.14 | 122.85 | 122.91 | 4108500.0 |
| 2005-07-22 10:30:00 | SPY | ETF | 122.9 | 122.94 | 122.63 | 122.76 | 5378600.0 |
| 2005-07-22 11:00:00 | SPY | ETF | 122.74 | 123.02 | 122.74 | 122.92 | 4204500.0 |
| 2005-07-22 11:30:00 | SPY | ETF | 122.92 | 122.94 | 122.76 | 122.87 | 614300.0 |
| 2005-07-22 12:00:00 | SPY | ETF | 122.88 | 123.02 | 122.82 | 122.88 | 1575500.0 |
| 2005-07-22 12:30:00 | SPY | ETF | 122.9 | 122.91 | 122.68 | 122.73 | 2119700.0 |
| 2005-07-22 13:00:00 | SPY | ETF | 122.73 | 122.92 | 122.69 | 122.86 | 1383700.0 |
| 2005-07-22 13:30:00 | SPY | ETF | 122.88 | 122.99 | 122.88 | 122.93 | 1163000.0 |
| 2005-07-22 14:00:00 | SPY | ETF | 122.94 | 122.99 | 122.83 | 122.89 | 1308100.0 |
| 2005-07-22 14:30:00 | SPY | ETF | 122.88 | 123.45 | 122.79 | 123.35 | 8654400.0 |
| 2005-07-22 15:00:00 | SPY | ETF | 123.36 | 123.46 | 123.26 | 123.39 | 2222800.0 |
| 2005-07-22 15:30:00 | SPY | ETF | 123.39 | 123.51 | 123.27 | 123.43 | 6722000.0 |
| 2005-07-22 16:00:00 | SPY | ETF | 123.45 | 123.6 | 123.41 | 123.53 | 3632200.0 |
| 2005-07-22 16:30:00 | SPY | ETF | 123.54 | 123.65 | 123.53 | 123.65 | 32100.0 |
| 2005-07-22 17:00:00 | SPY | ETF | 123.65 | 123.65 | 123.58 | 123.6 | 5100.0 |
| 2005-07-22 17:30:00 | SPY | ETF | 123.6 | 123.6 | 123.6 | 123.6 | 100.0 |
| 2005-07-22 18:00:00 | SPY | ETF | 123.58 | 123.6 | 123.58 | 123.58 | 5600.0 |
| 2005-07-22 18:30:00 | SPY | ETF | 123.58 | 123.58 | 123.58 | 123.58 | 1000.0 |
| 2005-07-22 19:30:00 | SPY | ETF | 123.54 | 123.56 | 123.54 | 123.56 | 1700.0 |
| 2005-07-22 09:30:00 | QQQ | ETF | 39.46 | 39.59 | 39.45 | 39.52 | 9856100.0 |
| 2005-07-22 10:00:00 | QQQ | ETF | 39.52 | 39.55 | 39.38 | 39.39 | 7499800.0 |
| 2005-07-22 10:30:00 | QQQ | ETF | 39.39 | 39.41 | 39.25 | 39.3 | 8750900.0 |
| 2005-07-22 11:00:00 | QQQ | ETF | 39.3 | 39.37 | 39.3 | 39.35 | 3775700.0 |
| 2005-07-22 11:30:00 | QQQ | ETF | 39.35 | 39.38 | 39.3 | 39.34 | 3966900.0 |
| 2005-07-22 12:00:00 | QQQ | ETF | 39.34 | 39.39 | 39.32 | 39.34 | 2439400.0 |
| 2005-07-22 12:30:00 | QQQ | ETF | 39.33 | 39.35 | 39.24 | 39.27 | 4010700.0 |
| 2005-07-22 13:00:00 | QQQ | ETF | 39.28 | 39.36 | 39.28 | 39.35 | 1804800.0 |
| 2005-07-22 13:30:00 | QQQ | ETF | 39.34 | 39.39 | 39.34 | 39.39 | 1344300.0 |
| 2005-07-22 14:00:00 | QQQ | ETF | 39.39 | 39.39 | 39.28 | 39.28 | 1861900.0 |
| 2005-07-22 14:30:00 | QQQ | ETF | 39.29 | 39.47 | 39.22 | 39.42 | 9447300.0 |
| 2005-07-22 15:00:00 | QQQ | ETF | 39.43 | 39.49 | 39.42 | 39.48 | 3628100.0 |
| 2005-07-22 15:30:00 | QQQ | ETF | 39.49 | 39.49 | 39.35 | 39.42 | 4703400.0 |
| 2005-07-22 07:30:00 | IWM | ETF | 66.35 | 66.35 | 66.35 | 66.35 | 2000.0 |
| 2005-07-22 08:00:00 | IWM | ETF | 66.32 | 66.42 | 66.32 | 66.42 | 12000.0 |
| 2005-07-22 08:30:00 | IWM | ETF | 66.44 | 66.44 | 66.44 | 66.44 | 100.0 |
| 2005-07-22 09:00:00 | IWM | ETF | 66.47 | 66.47 | 66.47 | 66.47 | 1000.0 |
| 2005-07-22 09:30:00 | IWM | ETF | 66.45 | 66.91 | 66.39 | 66.87 | 3847000.0 |
| 2005-07-22 10:00:00 | IWM | ETF | 66.87 | 66.94 | 66.57 | 66.58 | 2247200.0 |
| 2005-07-22 10:30:00 | IWM | ETF | 66.59 | 66.68 | 66.37 | 66.41 | 2323000.0 |
| 2005-07-22 11:00:00 | IWM | ETF | 66.41 | 66.63 | 66.39 | 66.52 | 1074300.0 |
| 2005-07-22 11:30:00 | IWM | ETF | 66.52 | 66.57 | 66.43 | 66.54 | 450300.0 |
| 2005-07-22 12:00:00 | IWM | ETF | 66.54 | 66.76 | 66.5 | 66.61 | 998300.0 |
> showing 50 of 1,607 rows — these rows as CSV