PREVIEW / etf_30min / 2001-06-15
file: by_date/etf_30min/2001/2001-06-15.parquet size: 15 KB rows: 387
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 |
|---|---|---|---|---|---|---|---|
| 2001-06-15 09:30:00 | SPY | ETF | 120.91 | 121.47 | 120.7 | 120.7 | 1952100.0 |
| 2001-06-15 10:00:00 | SPY | ETF | 120.7 | 121.1 | 120.4 | 120.95 | 868400.0 |
| 2001-06-15 10:30:00 | SPY | ETF | 120.98 | 122.18 | 120.9 | 121.8 | 1673700.0 |
| 2001-06-15 11:00:00 | SPY | ETF | 121.72 | 122.36 | 121.72 | 122.16 | 800400.0 |
| 2001-06-15 11:30:00 | SPY | ETF | 122.16 | 122.27 | 121.56 | 121.72 | 642400.0 |
| 2001-06-15 12:00:00 | SPY | ETF | 121.63 | 122.06 | 121.61 | 121.83 | 281900.0 |
| 2001-06-15 12:30:00 | SPY | ETF | 121.8 | 122.4 | 121.78 | 122.31 | 607100.0 |
| 2001-06-15 13:00:00 | SPY | ETF | 122.34 | 122.36 | 121.85 | 122.0 | 376400.0 |
| 2001-06-15 13:30:00 | SPY | ETF | 122.04 | 122.36 | 121.99 | 122.3 | 348800.0 |
| 2001-06-15 14:00:00 | SPY | ETF | 122.3 | 122.3 | 121.7 | 121.73 | 169700.0 |
| 2001-06-15 14:30:00 | SPY | ETF | 121.76 | 121.89 | 121.5 | 121.73 | 319500.0 |
| 2001-06-15 15:00:00 | SPY | ETF | 121.75 | 122.21 | 121.75 | 121.86 | 640000.0 |
| 2001-06-15 15:30:00 | SPY | ETF | 121.9 | 121.92 | 121.32 | 121.62 | 1022000.0 |
| 2001-06-15 16:00:00 | SPY | ETF | 121.62 | 122.01 | 121.56 | 121.91 | 389100.0 |
| 2001-06-15 17:30:00 | SPY | ETF | 121.35 | 121.35 | 121.35 | 121.35 | 200.0 |
| 2001-06-15 09:30:00 | QQQ | ETF | 41.8 | 42.3 | 41.5 | 41.5 | 12532200.0 |
| 2001-06-15 10:00:00 | QQQ | ETF | 41.56 | 41.87 | 41.28 | 41.59 | 8177600.0 |
| 2001-06-15 10:30:00 | QQQ | ETF | 41.61 | 42.44 | 41.55 | 42.17 | 8810900.0 |
| 2001-06-15 11:00:00 | QQQ | ETF | 42.16 | 43.07 | 42.13 | 42.9 | 10177700.0 |
| 2001-06-15 11:30:00 | QQQ | ETF | 42.89 | 42.95 | 42.29 | 42.37 | 7690500.0 |
| 2001-06-15 12:00:00 | QQQ | ETF | 42.39 | 42.66 | 42.3 | 42.41 | 2748500.0 |
| 2001-06-15 12:30:00 | QQQ | ETF | 42.4 | 43.0 | 42.4 | 42.89 | 4678000.0 |
| 2001-06-15 13:00:00 | QQQ | ETF | 42.85 | 42.89 | 42.4 | 42.51 | 3023700.0 |
| 2001-06-15 13:30:00 | QQQ | ETF | 42.51 | 42.85 | 42.47 | 42.75 | 2895600.0 |
| 2001-06-15 14:00:00 | QQQ | ETF | 42.75 | 42.79 | 42.15 | 42.24 | 3277500.0 |
| 2001-06-15 14:30:00 | QQQ | ETF | 42.24 | 42.39 | 42.0 | 42.3 | 4112700.0 |
| 2001-06-15 15:00:00 | QQQ | ETF | 42.29 | 42.64 | 42.29 | 42.31 | 3467700.0 |
| 2001-06-15 15:30:00 | QQQ | ETF | 42.31 | 42.5 | 42.1 | 42.49 | 6671300.0 |
| 2001-06-15 16:00:00 | QQQ | ETF | 42.46 | 42.78 | 42.44 | 42.6 | 1628900.0 |
| 2001-06-15 16:30:00 | QQQ | ETF | 42.49 | 42.63 | 42.49 | 42.57 | 50800.0 |
| 2001-06-15 17:00:00 | QQQ | ETF | 42.59 | 42.66 | 42.58 | 42.6 | 18400.0 |
| 2001-06-15 17:30:00 | QQQ | ETF | 42.65 | 42.7 | 42.56 | 42.7 | 5300.0 |
| 2001-06-15 18:00:00 | QQQ | ETF | 42.59 | 42.64 | 42.56 | 42.64 | 5500.0 |
| 2001-06-15 09:30:00 | IWM | ETF | 49.0 | 49.275 | 48.925 | 49.105 | 81200.0 |
| 2001-06-15 10:00:00 | IWM | ETF | 49.175 | 49.175 | 48.965 | 49.035 | 27800.0 |
| 2001-06-15 10:30:00 | IWM | ETF | 49.035 | 49.325 | 49.035 | 49.325 | 31600.0 |
| 2001-06-15 11:00:00 | IWM | ETF | 49.305 | 49.515 | 49.305 | 49.515 | 119600.0 |
| 2001-06-15 11:30:00 | IWM | ETF | 49.465 | 49.5 | 49.375 | 49.38 | 23600.0 |
| 2001-06-15 12:00:00 | IWM | ETF | 49.41 | 49.465 | 49.385 | 49.385 | 5800.0 |
| 2001-06-15 12:30:00 | IWM | ETF | 49.38 | 49.52 | 49.37 | 49.5 | 15400.0 |
| 2001-06-15 13:00:00 | IWM | ETF | 49.5 | 49.575 | 49.465 | 49.485 | 11400.0 |
| 2001-06-15 13:30:00 | IWM | ETF | 49.45 | 49.495 | 49.45 | 49.45 | 69800.0 |
| 2001-06-15 14:00:00 | IWM | ETF | 49.455 | 49.5 | 49.425 | 49.425 | 68400.0 |
| 2001-06-15 14:30:00 | IWM | ETF | 49.42 | 49.42 | 49.345 | 49.345 | 8000.0 |
| 2001-06-15 15:00:00 | IWM | ETF | 49.35 | 49.425 | 49.35 | 49.39 | 16400.0 |
| 2001-06-15 15:30:00 | IWM | ETF | 49.385 | 49.395 | 49.25 | 49.285 | 323000.0 |
| 2001-06-15 16:00:00 | IWM | ETF | 49.28 | 49.375 | 49.28 | 49.375 | 6800.0 |
| 2001-06-15 09:30:00 | DIA | ETF | 106.4 | 106.8 | 106.0 | 106.0 | 947700.0 |
| 2001-06-15 10:00:00 | DIA | ETF | 106.0 | 106.29 | 105.65 | 106.25 | 615000.0 |
| 2001-06-15 10:30:00 | DIA | ETF | 106.25 | 107.03 | 106.21 | 106.8 | 433100.0 |
> showing 50 of 387 rows — these rows as CSV