PREVIEW / etf_30min / 2002-07-24
file: by_date/etf_30min/2002/2002-07-24.parquet size: 20 KB rows: 554
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 |
|---|---|---|---|---|---|---|---|
| 2002-07-24 09:30:00 | SPY | ETF | 78.13 | 79.0 | 77.68 | 78.39 | 9010300.0 |
| 2002-07-24 10:00:00 | SPY | ETF | 78.38 | 79.15 | 78.1 | 79.03 | 5870000.0 |
| 2002-07-24 10:30:00 | SPY | ETF | 79.05 | 80.5 | 78.96 | 79.78 | 9362100.0 |
| 2002-07-24 11:00:00 | SPY | ETF | 79.85 | 81.1 | 79.45 | 80.95 | 5220000.0 |
| 2002-07-24 11:30:00 | SPY | ETF | 80.88 | 82.3 | 80.76 | 81.85 | 9038600.0 |
| 2002-07-24 12:00:00 | SPY | ETF | 81.87 | 82.64 | 81.5 | 81.7 | 7474300.0 |
| 2002-07-24 12:30:00 | SPY | ETF | 81.75 | 81.86 | 80.81 | 81.5 | 5919500.0 |
| 2002-07-24 13:00:00 | SPY | ETF | 81.43 | 81.76 | 80.8 | 81.2 | 4331600.0 |
| 2002-07-24 13:30:00 | SPY | ETF | 81.2 | 82.0 | 80.97 | 81.44 | 4491100.0 |
| 2002-07-24 14:00:00 | SPY | ETF | 81.46 | 82.2 | 81.44 | 81.77 | 6268300.0 |
| 2002-07-24 14:30:00 | SPY | ETF | 81.75 | 83.0 | 81.66 | 82.57 | 8055300.0 |
| 2002-07-24 15:00:00 | SPY | ETF | 82.5 | 84.7 | 82.4 | 83.9 | 10706400.0 |
| 2002-07-24 15:30:00 | SPY | ETF | 83.9 | 84.94 | 83.51 | 84.8 | 8063000.0 |
| 2002-07-24 16:00:00 | SPY | ETF | 84.75 | 85.12 | 84.65 | 84.72 | 1799800.0 |
| 2002-07-24 09:30:00 | QQQ | ETF | 21.81 | 22.19 | 21.64 | 21.91 | 24825600.0 |
| 2002-07-24 10:00:00 | QQQ | ETF | 21.91 | 22.25 | 21.86 | 22.24 | 16727300.0 |
| 2002-07-24 10:30:00 | QQQ | ETF | 22.24 | 22.69 | 22.15 | 22.4 | 17439800.0 |
| 2002-07-24 11:00:00 | QQQ | ETF | 22.39 | 22.75 | 22.1 | 22.62 | 12300400.0 |
| 2002-07-24 11:30:00 | QQQ | ETF | 22.67 | 22.92 | 22.45 | 22.68 | 14901400.0 |
| 2002-07-24 12:00:00 | QQQ | ETF | 22.62 | 22.92 | 22.5 | 22.61 | 11645900.0 |
| 2002-07-24 12:30:00 | QQQ | ETF | 22.61 | 22.66 | 22.31 | 22.51 | 7863500.0 |
| 2002-07-24 13:00:00 | QQQ | ETF | 22.51 | 22.63 | 22.31 | 22.47 | 5819200.0 |
| 2002-07-24 13:30:00 | QQQ | ETF | 22.44 | 22.68 | 22.37 | 22.52 | 7236700.0 |
| 2002-07-24 14:00:00 | QQQ | ETF | 22.52 | 22.75 | 22.41 | 22.48 | 6437600.0 |
| 2002-07-24 14:30:00 | QQQ | ETF | 22.47 | 22.91 | 22.45 | 22.76 | 12878600.0 |
| 2002-07-24 15:00:00 | QQQ | ETF | 22.76 | 23.39 | 22.65 | 23.14 | 21702700.0 |
| 2002-07-24 15:30:00 | QQQ | ETF | 23.13 | 23.65 | 23.05 | 23.62 | 16307100.0 |
| 2002-07-24 16:00:00 | QQQ | ETF | 23.62 | 23.66 | 23.51 | 23.62 | 1956500.0 |
| 2002-07-24 09:30:00 | IWM | ETF | 35.2 | 35.5 | 34.75 | 35.14 | 790600.0 |
| 2002-07-24 10:00:00 | IWM | ETF | 35.005 | 35.45 | 35.005 | 35.2 | 671000.0 |
| 2002-07-24 10:30:00 | IWM | ETF | 35.325 | 36.25 | 35.195 | 35.7 | 1836400.0 |
| 2002-07-24 11:00:00 | IWM | ETF | 35.7 | 36.495 | 35.7 | 36.485 | 278200.0 |
| 2002-07-24 11:30:00 | IWM | ETF | 36.25 | 36.73 | 36.15 | 36.725 | 262400.0 |
| 2002-07-24 12:00:00 | IWM | ETF | 36.6 | 36.8 | 36.505 | 36.66 | 221600.0 |
| 2002-07-24 12:30:00 | IWM | ETF | 36.6 | 36.66 | 36.3 | 36.515 | 101600.0 |
| 2002-07-24 13:00:00 | IWM | ETF | 36.525 | 36.58 | 36.325 | 36.475 | 49200.0 |
| 2002-07-24 13:30:00 | IWM | ETF | 36.595 | 36.65 | 36.3 | 36.545 | 170200.0 |
| 2002-07-24 14:00:00 | IWM | ETF | 36.535 | 36.8 | 36.455 | 36.575 | 397600.0 |
| 2002-07-24 14:30:00 | IWM | ETF | 36.575 | 37.1 | 36.5 | 36.995 | 579600.0 |
| 2002-07-24 15:00:00 | IWM | ETF | 37.115 | 37.495 | 36.9 | 37.37 | 441600.0 |
| 2002-07-24 15:30:00 | IWM | ETF | 37.225 | 37.75 | 37.165 | 37.675 | 303600.0 |
| 2002-07-24 16:00:00 | IWM | ETF | 37.6 | 38.0 | 37.55 | 38.0 | 36200.0 |
| 2002-07-24 09:30:00 | DIA | ETF | 75.75 | 76.95 | 75.28 | 76.15 | 2835200.0 |
| 2002-07-24 10:00:00 | DIA | ETF | 76.05 | 76.89 | 75.75 | 76.89 | 1723800.0 |
| 2002-07-24 10:30:00 | DIA | ETF | 76.84 | 78.3 | 76.84 | 77.5 | 2570700.0 |
| 2002-07-24 11:00:00 | DIA | ETF | 77.54 | 78.79 | 77.1 | 78.5 | 1729900.0 |
| 2002-07-24 11:30:00 | DIA | ETF | 78.6 | 79.68 | 78.4 | 79.39 | 1966400.0 |
| 2002-07-24 12:00:00 | DIA | ETF | 79.3 | 79.98 | 78.75 | 79.03 | 1666400.0 |
| 2002-07-24 12:30:00 | DIA | ETF | 79.0 | 79.15 | 78.19 | 79.0 | 968900.0 |
| 2002-07-24 13:00:00 | DIA | ETF | 78.92 | 79.19 | 78.2 | 78.85 | 830100.0 |
> showing 50 of 554 rows — these rows as CSV