PREVIEW / etf_30min / 2002-04-18
file: by_date/etf_30min/2002/2002-04-18.parquet size: 18 KB rows: 490
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-04-18 09:30:00 | SPY | ETF | 112.9 | 113.43 | 112.9 | 113.4 | 1137600.0 |
| 2002-04-18 10:00:00 | SPY | ETF | 113.39 | 113.46 | 112.41 | 112.49 | 2467200.0 |
| 2002-04-18 10:30:00 | SPY | ETF | 112.46 | 112.69 | 112.34 | 112.57 | 1696400.0 |
| 2002-04-18 11:00:00 | SPY | ETF | 112.62 | 112.74 | 112.5 | 112.62 | 617900.0 |
| 2002-04-18 11:30:00 | SPY | ETF | 112.63 | 112.76 | 112.0 | 112.08 | 1902000.0 |
| 2002-04-18 12:00:00 | SPY | ETF | 112.08 | 112.51 | 111.15 | 112.3 | 8629000.0 |
| 2002-04-18 12:30:00 | SPY | ETF | 112.3 | 112.5 | 112.15 | 112.49 | 1975500.0 |
| 2002-04-18 13:00:00 | SPY | ETF | 112.49 | 112.65 | 112.44 | 112.5 | 917500.0 |
| 2002-04-18 13:30:00 | SPY | ETF | 112.5 | 112.52 | 112.26 | 112.42 | 369300.0 |
| 2002-04-18 14:00:00 | SPY | ETF | 112.4 | 112.8 | 112.35 | 112.8 | 733800.0 |
| 2002-04-18 14:30:00 | SPY | ETF | 112.81 | 112.96 | 112.61 | 112.62 | 1183200.0 |
| 2002-04-18 15:00:00 | SPY | ETF | 112.62 | 112.76 | 112.53 | 112.73 | 522900.0 |
| 2002-04-18 15:30:00 | SPY | ETF | 112.72 | 112.98 | 112.65 | 112.75 | 670800.0 |
| 2002-04-18 16:00:00 | SPY | ETF | 112.75 | 112.85 | 112.17 | 112.17 | 917700.0 |
| 2002-04-18 16:30:00 | SPY | ETF | 112.01 | 112.35 | 112.0 | 112.15 | 212900.0 |
| 2002-04-18 09:30:00 | QQQ | ETF | 34.78 | 35.13 | 34.74 | 35.1 | 8537800.0 |
| 2002-04-18 10:00:00 | QQQ | ETF | 35.12 | 35.15 | 34.5 | 34.56 | 9999900.0 |
| 2002-04-18 10:30:00 | QQQ | ETF | 34.56 | 34.62 | 34.39 | 34.53 | 5480300.0 |
| 2002-04-18 11:00:00 | QQQ | ETF | 34.54 | 34.64 | 34.45 | 34.54 | 2916100.0 |
| 2002-04-18 11:30:00 | QQQ | ETF | 34.54 | 34.7 | 34.0 | 34.35 | 5788600.0 |
| 2002-04-18 12:00:00 | QQQ | ETF | 34.35 | 34.6 | 34.0 | 34.46 | 20191700.0 |
| 2002-04-18 12:30:00 | QQQ | ETF | 34.46 | 34.61 | 34.4 | 34.56 | 5885800.0 |
| 2002-04-18 13:00:00 | QQQ | ETF | 34.56 | 34.67 | 34.52 | 34.57 | 3027600.0 |
| 2002-04-18 13:30:00 | QQQ | ETF | 34.57 | 34.6 | 34.47 | 34.56 | 1683300.0 |
| 2002-04-18 14:00:00 | QQQ | ETF | 34.56 | 34.82 | 34.51 | 34.82 | 4748700.0 |
| 2002-04-18 14:30:00 | QQQ | ETF | 34.81 | 34.9 | 34.66 | 34.7 | 4152300.0 |
| 2002-04-18 15:00:00 | QQQ | ETF | 34.69 | 34.8 | 34.65 | 34.8 | 2060100.0 |
| 2002-04-18 15:30:00 | QQQ | ETF | 34.77 | 34.85 | 34.7 | 34.76 | 4947200.0 |
| 2002-04-18 16:00:00 | QQQ | ETF | 34.75 | 34.82 | 33.96 | 34.0 | 4590900.0 |
| 2002-04-18 16:30:00 | QQQ | ETF | 34.0 | 34.34 | 34.0 | 34.0 | 209900.0 |
| 2002-04-18 09:30:00 | IWM | ETF | 51.775 | 51.865 | 51.675 | 51.865 | 50000.0 |
| 2002-04-18 10:00:00 | IWM | ETF | 51.825 | 51.825 | 51.335 | 51.335 | 118000.0 |
| 2002-04-18 10:30:00 | IWM | ETF | 51.335 | 51.4 | 51.125 | 51.385 | 274200.0 |
| 2002-04-18 11:00:00 | IWM | ETF | 51.415 | 51.445 | 51.36 | 51.425 | 24400.0 |
| 2002-04-18 11:30:00 | IWM | ETF | 51.425 | 51.46 | 51.325 | 51.345 | 834800.0 |
| 2002-04-18 12:00:00 | IWM | ETF | 51.4 | 51.4 | 51.075 | 51.275 | 83800.0 |
| 2002-04-18 12:30:00 | IWM | ETF | 51.375 | 51.39 | 51.315 | 51.39 | 27400.0 |
| 2002-04-18 13:00:00 | IWM | ETF | 51.385 | 51.43 | 51.36 | 51.43 | 65200.0 |
| 2002-04-18 13:30:00 | IWM | ETF | 51.45 | 51.45 | 51.35 | 51.425 | 8800.0 |
| 2002-04-18 14:00:00 | IWM | ETF | 51.42 | 51.5 | 51.35 | 51.5 | 384800.0 |
| 2002-04-18 14:30:00 | IWM | ETF | 51.475 | 51.625 | 51.475 | 51.55 | 339200.0 |
| 2002-04-18 15:00:00 | IWM | ETF | 51.515 | 51.555 | 51.465 | 51.555 | 22000.0 |
| 2002-04-18 15:30:00 | IWM | ETF | 51.54 | 51.625 | 51.51 | 51.56 | 46600.0 |
| 2002-04-18 16:00:00 | IWM | ETF | 51.57 | 51.605 | 51.49 | 51.49 | 1400.0 |
| 2002-04-18 09:30:00 | DIA | ETF | 102.4 | 102.75 | 102.4 | 102.6 | 294200.0 |
| 2002-04-18 10:00:00 | DIA | ETF | 102.6 | 102.61 | 101.63 | 101.64 | 1048800.0 |
| 2002-04-18 10:30:00 | DIA | ETF | 101.69 | 101.93 | 101.58 | 101.85 | 341700.0 |
| 2002-04-18 11:00:00 | DIA | ETF | 101.82 | 101.99 | 101.8 | 101.92 | 362900.0 |
| 2002-04-18 11:30:00 | DIA | ETF | 101.86 | 102.14 | 101.52 | 101.57 | 363100.0 |
| 2002-04-18 12:00:00 | DIA | ETF | 101.62 | 101.93 | 100.62 | 101.7 | 1307400.0 |
> showing 50 of 490 rows — these rows as CSV