PREVIEW / etf_30min / 2005-08-08
file: by_date/etf_30min/2005/2005-08-08.parquet size: 46 KB rows: 1,603
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-08-08 06:30:00 | SPY | ETF | 123.24 | 123.24 | 123.24 | 123.24 | 25000.0 |
| 2005-08-08 07:00:00 | SPY | ETF | 123.21 | 123.22 | 123.21 | 123.22 | 1500.0 |
| 2005-08-08 07:30:00 | SPY | ETF | 123.14 | 123.15 | 123.14 | 123.15 | 7500.0 |
| 2005-08-08 08:00:00 | SPY | ETF | 123.13 | 123.19 | 123.11 | 123.19 | 48100.0 |
| 2005-08-08 08:30:00 | SPY | ETF | 123.18 | 123.25 | 123.15 | 123.2 | 320000.0 |
| 2005-08-08 09:00:00 | SPY | ETF | 123.2 | 123.22 | 123.17 | 123.17 | 52800.0 |
| 2005-08-08 09:30:00 | SPY | ETF | 123.17 | 123.32 | 123.09 | 123.26 | 5478500.0 |
| 2005-08-08 10:00:00 | SPY | ETF | 123.26 | 123.41 | 123.02 | 123.22 | 7039100.0 |
| 2005-08-08 10:30:00 | SPY | ETF | 123.21 | 123.22 | 122.76 | 122.81 | 6908400.0 |
| 2005-08-08 11:00:00 | SPY | ETF | 122.82 | 123.05 | 122.76 | 122.95 | 5147500.0 |
| 2005-08-08 11:30:00 | SPY | ETF | 122.96 | 123.04 | 122.82 | 122.92 | 1453500.0 |
| 2005-08-08 12:00:00 | SPY | ETF | 122.92 | 123.04 | 122.86 | 122.9 | 1107800.0 |
| 2005-08-08 12:30:00 | SPY | ETF | 122.89 | 122.94 | 122.79 | 122.91 | 724400.0 |
| 2005-08-08 13:00:00 | SPY | ETF | 122.912 | 122.98 | 122.62 | 122.71 | 2899200.0 |
| 2005-08-08 13:30:00 | SPY | ETF | 122.71 | 122.8 | 122.62 | 122.71 | 1204300.0 |
| 2005-08-08 14:00:00 | SPY | ETF | 122.72 | 122.73 | 122.38 | 122.49 | 3941800.0 |
| 2005-08-08 14:30:00 | SPY | ETF | 122.47 | 122.68 | 122.42 | 122.57 | 2126900.0 |
| 2005-08-08 15:00:00 | SPY | ETF | 122.57 | 122.65 | 122.44 | 122.53 | 2626800.0 |
| 2005-08-08 15:30:00 | SPY | ETF | 122.53 | 122.59 | 122.39 | 122.42 | 4314700.0 |
| 2005-08-08 16:00:00 | SPY | ETF | 122.39 | 122.68 | 122.39 | 122.6 | 661900.0 |
| 2005-08-08 16:30:00 | SPY | ETF | 122.62 | 122.65 | 122.45 | 122.65 | 241500.0 |
| 2005-08-08 17:00:00 | SPY | ETF | 122.63 | 122.63 | 122.57 | 122.57 | 1200.0 |
| 2005-08-08 17:30:00 | SPY | ETF | 122.58 | 122.62 | 122.58 | 122.6 | 3300.0 |
| 2005-08-08 18:00:00 | SPY | ETF | 122.59 | 122.59 | 122.56 | 122.56 | 500.0 |
| 2005-08-08 18:30:00 | SPY | ETF | 122.59 | 122.64 | 122.59 | 122.64 | 2900.0 |
| 2005-08-08 19:00:00 | SPY | ETF | 122.65 | 122.65 | 122.55 | 122.55 | 11800.0 |
| 2005-08-08 19:30:00 | SPY | ETF | 122.56 | 122.56 | 122.53 | 122.53 | 200.0 |
| 2005-08-08 09:30:00 | QQQ | ETF | 39.52 | 39.57 | 39.44 | 39.56 | 7592100.0 |
| 2005-08-08 10:00:00 | QQQ | ETF | 39.56 | 39.61 | 39.43 | 39.52 | 7523900.0 |
| 2005-08-08 10:30:00 | QQQ | ETF | 39.52 | 39.52 | 39.31 | 39.36 | 7740600.0 |
| 2005-08-08 11:00:00 | QQQ | ETF | 39.36 | 39.45 | 39.33 | 39.42 | 5604300.0 |
| 2005-08-08 11:30:00 | QQQ | ETF | 39.42 | 39.43 | 39.35 | 39.4 | 2969900.0 |
| 2005-08-08 12:00:00 | QQQ | ETF | 39.4 | 39.43 | 39.36 | 39.37 | 2160400.0 |
| 2005-08-08 12:30:00 | QQQ | ETF | 39.37 | 39.4 | 39.34 | 39.38 | 2023000.0 |
| 2005-08-08 13:00:00 | QQQ | ETF | 39.39 | 39.4 | 39.26 | 39.29 | 3467300.0 |
| 2005-08-08 13:30:00 | QQQ | ETF | 39.3 | 39.32 | 39.25 | 39.28 | 2961900.0 |
| 2005-08-08 14:00:00 | QQQ | ETF | 39.28 | 39.29 | 39.17 | 39.19 | 5178500.0 |
| 2005-08-08 14:30:00 | QQQ | ETF | 39.19 | 39.26 | 39.17 | 39.25 | 3285000.0 |
| 2005-08-08 15:00:00 | QQQ | ETF | 39.25 | 39.28 | 39.18 | 39.21 | 2743900.0 |
| 2005-08-08 15:30:00 | QQQ | ETF | 39.21 | 39.23 | 39.14 | 39.19 | 5575000.0 |
| 2005-08-08 08:00:00 | IWM | ETF | 66.12 | 66.12 | 66.12 | 66.12 | 200.0 |
| 2005-08-08 08:30:00 | IWM | ETF | 66.16 | 66.17 | 66.13 | 66.17 | 28700.0 |
| 2005-08-08 09:00:00 | IWM | ETF | 66.18 | 66.23 | 66.11 | 66.14 | 8400.0 |
| 2005-08-08 09:30:00 | IWM | ETF | 66.17 | 66.28 | 66.05 | 66.16 | 1989800.0 |
| 2005-08-08 10:00:00 | IWM | ETF | 66.17 | 66.37 | 66.08 | 66.12 | 1567000.0 |
| 2005-08-08 10:30:00 | IWM | ETF | 66.11 | 66.12 | 65.67 | 65.7 | 2599900.0 |
| 2005-08-08 11:00:00 | IWM | ETF | 65.7 | 65.86 | 65.69 | 65.8 | 3727600.0 |
| 2005-08-08 11:30:00 | IWM | ETF | 65.8 | 65.92 | 65.74 | 65.86 | 1110200.0 |
| 2005-08-08 12:00:00 | IWM | ETF | 65.87 | 65.95 | 65.84 | 65.85 | 774300.0 |
| 2005-08-08 12:30:00 | IWM | ETF | 65.85 | 65.92 | 65.81 | 65.9 | 358900.0 |
> showing 50 of 1,603 rows — these rows as CSV