PREVIEW / etf_30min / 2004-10-29
file: by_date/etf_30min/2004/2004-10-29.parquet size: 36 KB rows: 1,251
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 |
|---|---|---|---|---|---|---|---|
| 2004-10-29 08:00:00 | SPY | ETF | 113.26 | 113.3 | 113.23 | 113.24 | 14300.0 |
| 2004-10-29 08:30:00 | SPY | ETF | 113.22 | 113.26 | 112.94 | 113.13 | 279900.0 |
| 2004-10-29 09:00:00 | SPY | ETF | 113.14 | 113.16 | 113.09 | 113.09 | 15900.0 |
| 2004-10-29 09:30:00 | SPY | ETF | 113.12 | 113.62 | 113.12 | 113.61 | 6213700.0 |
| 2004-10-29 10:00:00 | SPY | ETF | 113.62 | 113.64 | 113.0 | 113.07 | 5271000.0 |
| 2004-10-29 10:30:00 | SPY | ETF | 113.08 | 113.22 | 112.95 | 112.95 | 4893300.0 |
| 2004-10-29 11:00:00 | SPY | ETF | 113.01 | 113.16 | 112.9 | 113.1 | 3524100.0 |
| 2004-10-29 11:30:00 | SPY | ETF | 113.09 | 113.16 | 112.9 | 113.12 | 2014000.0 |
| 2004-10-29 12:00:00 | SPY | ETF | 113.11 | 113.2 | 113.04 | 113.14 | 1282700.0 |
| 2004-10-29 12:30:00 | SPY | ETF | 113.13 | 113.14 | 112.99 | 113.05 | 1014300.0 |
| 2004-10-29 13:00:00 | SPY | ETF | 113.04 | 113.28 | 113.03 | 113.28 | 901100.0 |
| 2004-10-29 13:30:00 | SPY | ETF | 113.27 | 113.41 | 113.02 | 113.03 | 2663500.0 |
| 2004-10-29 14:00:00 | SPY | ETF | 113.03 | 113.22 | 113.01 | 113.08 | 1665600.0 |
| 2004-10-29 14:30:00 | SPY | ETF | 113.07 | 113.21 | 113.03 | 113.17 | 1300300.0 |
| 2004-10-29 15:00:00 | SPY | ETF | 113.18 | 113.3 | 113.13 | 113.19 | 2410500.0 |
| 2004-10-29 15:30:00 | SPY | ETF | 113.22 | 113.52 | 113.17 | 113.38 | 6985100.0 |
| 2004-10-29 16:00:00 | SPY | ETF | 113.38 | 113.48 | 113.2 | 113.28 | 4472000.0 |
| 2004-10-29 16:30:00 | SPY | ETF | 113.26 | 113.35 | 113.19 | 113.19 | 69500.0 |
| 2004-10-29 17:00:00 | SPY | ETF | 113.18 | 113.19 | 113.15 | 113.16 | 4500.0 |
| 2004-10-29 17:30:00 | SPY | ETF | 113.19 | 113.19 | 113.19 | 113.19 | 1900.0 |
| 2004-10-29 18:00:00 | SPY | ETF | 113.2 | 113.2 | 113.18 | 113.18 | 1100.0 |
| 2004-10-29 08:00:00 | QQQ | ETF | 36.96 | 37.0 | 36.96 | 36.98 | 39700.0 |
| 2004-10-29 08:30:00 | QQQ | ETF | 36.96 | 36.96 | 36.84 | 36.9 | 258000.0 |
| 2004-10-29 09:00:00 | QQQ | ETF | 36.9 | 36.91 | 36.88 | 36.9 | 163600.0 |
| 2004-10-29 09:30:00 | QQQ | ETF | 36.91 | 37.23 | 36.9 | 37.204 | 16448100.0 |
| 2004-10-29 10:00:00 | QQQ | ETF | 37.204 | 37.24 | 36.81 | 36.86 | 20212100.0 |
| 2004-10-29 10:30:00 | QQQ | ETF | 36.86 | 36.957 | 36.72 | 36.72 | 8655400.0 |
| 2004-10-29 11:00:00 | QQQ | ETF | 36.74 | 36.84 | 36.67 | 36.811 | 9685000.0 |
| 2004-10-29 11:30:00 | QQQ | ETF | 36.811 | 36.85 | 36.733 | 36.83 | 4471400.0 |
| 2004-10-29 12:00:00 | QQQ | ETF | 36.823 | 36.87 | 36.79 | 36.822 | 5506500.0 |
| 2004-10-29 12:30:00 | QQQ | ETF | 36.822 | 36.83 | 36.76 | 36.8 | 2506700.0 |
| 2004-10-29 13:00:00 | QQQ | ETF | 36.8 | 36.92 | 36.783 | 36.92 | 2796400.0 |
| 2004-10-29 13:30:00 | QQQ | ETF | 36.91 | 36.94 | 36.8 | 36.8 | 4584500.0 |
| 2004-10-29 14:00:00 | QQQ | ETF | 36.8 | 36.88 | 36.77 | 36.804 | 3638900.0 |
| 2004-10-29 14:30:00 | QQQ | ETF | 36.8 | 36.91 | 36.79 | 36.887 | 2302200.0 |
| 2004-10-29 15:00:00 | QQQ | ETF | 36.888 | 36.94 | 36.83 | 36.85 | 4402500.0 |
| 2004-10-29 15:30:00 | QQQ | ETF | 36.85 | 36.94 | 36.83 | 36.91 | 7361900.0 |
| 2004-10-29 16:00:00 | QQQ | ETF | 36.91 | 36.95 | 36.85 | 36.86 | 4043400.0 |
| 2004-10-29 16:30:00 | QQQ | ETF | 36.86 | 36.9765 | 36.82 | 36.85 | 727900.0 |
| 2004-10-29 17:00:00 | QQQ | ETF | 36.85 | 36.9 | 36.83 | 36.9 | 19500.0 |
| 2004-10-29 08:00:00 | IWM | ETF | 58.28 | 58.28 | 58.28 | 58.28 | 2400.0 |
| 2004-10-29 08:30:00 | IWM | ETF | 58.25 | 58.32 | 58.0 | 58.175 | 48000.0 |
| 2004-10-29 09:00:00 | IWM | ETF | 58.205 | 58.205 | 58.175 | 58.2 | 18800.0 |
| 2004-10-29 09:30:00 | IWM | ETF | 58.245 | 58.56 | 58.245 | 58.37 | 2248600.0 |
| 2004-10-29 10:00:00 | IWM | ETF | 58.4 | 58.44 | 58.025 | 58.115 | 1824600.0 |
| 2004-10-29 10:30:00 | IWM | ETF | 58.13 | 58.215 | 58.04 | 58.06 | 700000.0 |
| 2004-10-29 11:00:00 | IWM | ETF | 58.075 | 58.075 | 57.875 | 58.02 | 1272000.0 |
| 2004-10-29 11:30:00 | IWM | ETF | 58.025 | 58.13 | 57.965 | 58.125 | 802800.0 |
| 2004-10-29 12:00:00 | IWM | ETF | 58.13 | 58.16 | 58.04 | 58.125 | 620600.0 |
| 2004-10-29 12:30:00 | IWM | ETF | 58.125 | 58.155 | 58.06 | 58.13 | 202000.0 |
> showing 50 of 1,251 rows — these rows as CSV