PREVIEW / etf_30min / 2003-10-21
file: by_date/etf_30min/2003/2003-10-21.parquet size: 26 KB rows: 805
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 |
|---|---|---|---|---|---|---|---|
| 2003-10-21 08:00:00 | SPY | ETF | 105.08 | 105.22 | 105.08 | 105.15 | 50100.0 |
| 2003-10-21 08:30:00 | SPY | ETF | 105.1 | 105.12 | 104.87 | 104.88 | 69800.0 |
| 2003-10-21 09:00:00 | SPY | ETF | 104.91 | 104.93 | 104.86 | 104.86 | 116700.0 |
| 2003-10-21 09:30:00 | SPY | ETF | 104.82 | 104.89 | 104.6 | 104.89 | 2736000.0 |
| 2003-10-21 10:00:00 | SPY | ETF | 104.9 | 105.14 | 104.66 | 104.94 | 2182200.0 |
| 2003-10-21 10:30:00 | SPY | ETF | 104.943 | 104.99 | 104.655 | 104.72 | 1522100.0 |
| 2003-10-21 11:00:00 | SPY | ETF | 104.72 | 104.88 | 104.66 | 104.74 | 910500.0 |
| 2003-10-21 11:30:00 | SPY | ETF | 104.74 | 105.03 | 104.73 | 104.97 | 849200.0 |
| 2003-10-21 12:00:00 | SPY | ETF | 104.99 | 105.28 | 104.97 | 105.15 | 2711900.0 |
| 2003-10-21 12:30:00 | SPY | ETF | 105.14 | 105.21 | 105.11 | 105.19 | 950000.0 |
| 2003-10-21 13:00:00 | SPY | ETF | 105.2 | 105.2 | 104.97 | 105.13 | 1357700.0 |
| 2003-10-21 13:30:00 | SPY | ETF | 105.12 | 105.25 | 105.07 | 105.18 | 912100.0 |
| 2003-10-21 14:00:00 | SPY | ETF | 105.19 | 105.23 | 104.93 | 105.04 | 1071100.0 |
| 2003-10-21 14:30:00 | SPY | ETF | 105.07 | 105.27 | 105.07 | 105.23 | 2522300.0 |
| 2003-10-21 15:00:00 | SPY | ETF | 105.21 | 105.24 | 104.91 | 105.02 | 1919100.0 |
| 2003-10-21 15:30:00 | SPY | ETF | 105.0 | 105.23 | 104.79 | 104.96 | 4176600.0 |
| 2003-10-21 16:00:00 | SPY | ETF | 104.96 | 105.0 | 104.68 | 104.87 | 1437600.0 |
| 2003-10-21 16:30:00 | SPY | ETF | 104.87 | 104.94 | 104.81 | 104.91 | 76200.0 |
| 2003-10-21 17:00:00 | SPY | ETF | 104.88 | 104.89 | 104.77 | 104.77 | 22200.0 |
| 2003-10-21 17:30:00 | SPY | ETF | 104.77 | 104.77 | 104.76 | 104.76 | 800.0 |
| 2003-10-21 18:00:00 | SPY | ETF | 104.76 | 104.76 | 104.75 | 104.75 | 15400.0 |
| 2003-10-21 18:30:00 | SPY | ETF | 104.78 | 104.78 | 104.78 | 104.78 | 1000.0 |
| 2003-10-21 19:00:00 | SPY | ETF | 104.78 | 104.78 | 104.73 | 104.74 | 2100.0 |
| 2003-10-21 19:30:00 | SPY | ETF | 104.72 | 104.75 | 104.72 | 104.75 | 1200.0 |
| 2003-10-21 08:00:00 | QQQ | ETF | 35.24 | 35.28 | 35.23 | 35.26 | 60200.0 |
| 2003-10-21 08:30:00 | QQQ | ETF | 35.24 | 35.24 | 35.14 | 35.15 | 65900.0 |
| 2003-10-21 09:00:00 | QQQ | ETF | 35.15 | 35.17 | 35.11 | 35.11 | 113800.0 |
| 2003-10-21 09:30:00 | QQQ | ETF | 35.14 | 35.18 | 34.939 | 35.14 | 13008000.0 |
| 2003-10-21 10:00:00 | QQQ | ETF | 35.14 | 35.28 | 35.03 | 35.17 | 8921000.0 |
| 2003-10-21 10:30:00 | QQQ | ETF | 35.2 | 35.26 | 35.105 | 35.12 | 5204000.0 |
| 2003-10-21 11:00:00 | QQQ | ETF | 35.12 | 35.26 | 35.103 | 35.21 | 5836100.0 |
| 2003-10-21 11:30:00 | QQQ | ETF | 35.19 | 35.35 | 35.18 | 35.34 | 4365500.0 |
| 2003-10-21 12:00:00 | QQQ | ETF | 35.33 | 35.433 | 35.31 | 35.34 | 4737700.0 |
| 2003-10-21 12:30:00 | QQQ | ETF | 35.34 | 35.41 | 35.33 | 35.384 | 1424900.0 |
| 2003-10-21 13:00:00 | QQQ | ETF | 35.39 | 35.4 | 35.28 | 35.341 | 2668200.0 |
| 2003-10-21 13:30:00 | QQQ | ETF | 35.34 | 35.42 | 35.3 | 35.39 | 3923800.0 |
| 2003-10-21 14:00:00 | QQQ | ETF | 35.41 | 35.42 | 35.31 | 35.368 | 2097000.0 |
| 2003-10-21 14:30:00 | QQQ | ETF | 35.37 | 35.45 | 35.33 | 35.42 | 2986600.0 |
| 2003-10-21 15:00:00 | QQQ | ETF | 35.422 | 35.43 | 35.28 | 35.35 | 3702500.0 |
| 2003-10-21 15:30:00 | QQQ | ETF | 35.357 | 35.44 | 35.25 | 35.36 | 8336700.0 |
| 2003-10-21 16:00:00 | QQQ | ETF | 35.35 | 35.38 | 35.18 | 35.26 | 3430900.0 |
| 2003-10-21 16:30:00 | QQQ | ETF | 35.27 | 35.28 | 35.24 | 35.28 | 388000.0 |
| 2003-10-21 17:00:00 | QQQ | ETF | 35.27 | 35.283 | 35.19 | 35.19 | 559200.0 |
| 2003-10-21 17:30:00 | QQQ | ETF | 35.18 | 35.299 | 35.15 | 35.15 | 688800.0 |
| 2003-10-21 18:00:00 | QQQ | ETF | 35.19 | 35.2 | 35.16 | 35.19 | 344300.0 |
| 2003-10-21 18:30:00 | QQQ | ETF | 35.18 | 35.18 | 35.14 | 35.16 | 19100.0 |
| 2003-10-21 19:00:00 | QQQ | ETF | 35.17 | 35.17 | 35.16 | 35.16 | 16600.0 |
| 2003-10-21 19:30:00 | QQQ | ETF | 35.16 | 35.16 | 35.15 | 35.15 | 16900.0 |
| 2003-10-21 09:30:00 | IWM | ETF | 51.99 | 52.22 | 51.99 | 52.185 | 403800.0 |
| 2003-10-21 10:00:00 | IWM | ETF | 52.19 | 52.46 | 52.01 | 52.355 | 877600.0 |
> showing 50 of 805 rows — these rows as CSV