PREVIEW / etf_30min / 2006-05-03
file: by_date/etf_30min/2006/2006-05-03.parquet size: 62 KB rows: 2,258
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-03 05:30:00 | SPY | ETF | 131.18 | 131.18 | 131.18 | 131.18 | 100.0 |
| 2006-05-03 06:30:00 | SPY | ETF | 131.16 | 131.19 | 131.16 | 131.18 | 6000.0 |
| 2006-05-03 07:00:00 | SPY | ETF | 131.1 | 131.15 | 131.1 | 131.15 | 7100.0 |
| 2006-05-03 07:30:00 | SPY | ETF | 131.15 | 131.33 | 131.15 | 131.28 | 65200.0 |
| 2006-05-03 08:00:00 | SPY | ETF | 131.3 | 131.33 | 131.08 | 131.23 | 185200.0 |
| 2006-05-03 08:30:00 | SPY | ETF | 131.26 | 131.27 | 131.22 | 131.24 | 86600.0 |
| 2006-05-03 09:00:00 | SPY | ETF | 131.24 | 131.3 | 131.21 | 131.22 | 172300.0 |
| 2006-05-03 09:30:00 | SPY | ETF | 131.22 | 131.32 | 131.02 | 131.11 | 5541100.0 |
| 2006-05-03 10:00:00 | SPY | ETF | 131.11 | 131.12 | 130.79 | 130.97 | 6724500.0 |
| 2006-05-03 10:30:00 | SPY | ETF | 130.96 | 131.09 | 130.65 | 130.75 | 8882600.0 |
| 2006-05-03 11:00:00 | SPY | ETF | 130.75 | 130.99 | 130.68 | 130.82 | 5051200.0 |
| 2006-05-03 11:30:00 | SPY | ETF | 130.81 | 130.93 | 130.63 | 130.83 | 4854200.0 |
| 2006-05-03 12:00:00 | SPY | ETF | 130.85 | 130.99 | 130.75 | 130.78 | 1541400.0 |
| 2006-05-03 12:30:00 | SPY | ETF | 130.78 | 130.89 | 130.72 | 130.81 | 1110900.0 |
| 2006-05-03 13:00:00 | SPY | ETF | 130.79 | 130.95 | 130.77 | 130.83 | 1084000.0 |
| 2006-05-03 13:30:00 | SPY | ETF | 130.83 | 130.86 | 130.57 | 130.6999 | 4721000.0 |
| 2006-05-03 14:00:00 | SPY | ETF | 130.68 | 130.75 | 130.45 | 130.56 | 4365600.0 |
| 2006-05-03 14:30:00 | SPY | ETF | 130.56 | 130.74 | 130.47 | 130.5625 | 3806700.0 |
| 2006-05-03 15:00:00 | SPY | ETF | 130.56 | 130.8 | 130.51 | 130.72 | 3272600.0 |
| 2006-05-03 15:30:00 | SPY | ETF | 130.7 | 131.0 | 130.7 | 130.91 | 4557600.0 |
| 2006-05-03 16:00:00 | SPY | ETF | 130.9 | 130.95 | 130.62 | 130.9 | 1106500.0 |
| 2006-05-03 16:30:00 | SPY | ETF | 130.86 | 130.89 | 130.81 | 130.85 | 132400.0 |
| 2006-05-03 17:00:00 | SPY | ETF | 130.85 | 130.9 | 130.83 | 130.9 | 36800.0 |
| 2006-05-03 17:30:00 | SPY | ETF | 130.86 | 130.9 | 130.86 | 130.9 | 2300.0 |
| 2006-05-03 18:00:00 | SPY | ETF | 130.91 | 130.92 | 130.89 | 130.89 | 2300.0 |
| 2006-05-03 19:30:00 | SPY | ETF | 130.9 | 130.9 | 130.9 | 130.9 | 400.0 |
| 2006-05-03 09:30:00 | QQQ | ETF | 41.58 | 41.64 | 41.51 | 41.53 | 9146000.0 |
| 2006-05-03 10:00:00 | QQQ | ETF | 41.53 | 41.55 | 41.4 | 41.47 | 8196200.0 |
| 2006-05-03 10:30:00 | QQQ | ETF | 41.47 | 41.53 | 41.37 | 41.42 | 6583500.0 |
| 2006-05-03 11:00:00 | QQQ | ETF | 41.42 | 41.55 | 41.42 | 41.48 | 7473100.0 |
| 2006-05-03 11:30:00 | QQQ | ETF | 41.48 | 41.51 | 41.41 | 41.47 | 3965300.0 |
| 2006-05-03 12:00:00 | QQQ | ETF | 41.48 | 41.5 | 41.44 | 41.45 | 3848400.0 |
| 2006-05-03 12:30:00 | QQQ | ETF | 41.45 | 41.48 | 41.41 | 41.46 | 1898400.0 |
| 2006-05-03 13:00:00 | QQQ | ETF | 41.46 | 41.52 | 41.45 | 41.48 | 1120900.0 |
| 2006-05-03 13:30:00 | QQQ | ETF | 41.48 | 41.49 | 41.34 | 41.4 | 4028300.0 |
| 2006-05-03 14:00:00 | QQQ | ETF | 41.4 | 41.42 | 41.28 | 41.32 | 5777700.0 |
| 2006-05-03 14:30:00 | QQQ | ETF | 41.32 | 41.41 | 41.28 | 41.34 | 5789400.0 |
| 2006-05-03 15:00:00 | QQQ | ETF | 41.34 | 41.43 | 41.33 | 41.41 | 2221100.0 |
| 2006-05-03 15:30:00 | QQQ | ETF | 41.41 | 41.54 | 41.41 | 41.49 | 8258000.0 |
| 2006-05-03 08:00:00 | IWM | ETF | 76.14 | 76.3 | 76.14 | 76.3 | 1001900.0 |
| 2006-05-03 08:30:00 | IWM | ETF | 76.26 | 76.26 | 76.22 | 76.22 | 4200.0 |
| 2006-05-03 09:00:00 | IWM | ETF | 76.23 | 76.3 | 76.2 | 76.2 | 29900.0 |
| 2006-05-03 09:30:00 | IWM | ETF | 76.24 | 76.37 | 75.98 | 76.01 | 5214800.0 |
| 2006-05-03 10:00:00 | IWM | ETF | 76.0 | 76.05 | 75.75 | 75.98 | 2921600.0 |
| 2006-05-03 10:30:00 | IWM | ETF | 75.97 | 76.15 | 75.87 | 76.15 | 1693500.0 |
| 2006-05-03 11:00:00 | IWM | ETF | 76.16 | 76.34 | 76.05 | 76.11 | 3089500.0 |
| 2006-05-03 11:30:00 | IWM | ETF | 76.1101 | 76.23 | 76.0 | 76.12 | 1396100.0 |
| 2006-05-03 12:00:00 | IWM | ETF | 76.11 | 76.17 | 76.0 | 76.07 | 1125000.0 |
| 2006-05-03 12:30:00 | IWM | ETF | 76.08 | 76.16 | 76.03 | 76.11 | 636500.0 |
| 2006-05-03 13:00:00 | IWM | ETF | 76.11 | 76.2681 | 76.08 | 76.14 | 1145400.0 |
> showing 50 of 2,258 rows — these rows as CSV