PREVIEW / etf_30min / 2001-08-28
file: by_date/etf_30min/2001/2001-08-28.parquet size: 15 KB rows: 378
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-08-28 09:30:00 | SPY | ETF | 118.28 | 118.49 | 118.14 | 118.2 | 1176300.0 |
| 2001-08-28 10:00:00 | SPY | ETF | 118.21 | 118.22 | 117.54 | 117.59 | 1448400.0 |
| 2001-08-28 10:30:00 | SPY | ETF | 117.62 | 117.62 | 117.05 | 117.21 | 1266100.0 |
| 2001-08-28 11:00:00 | SPY | ETF | 117.19 | 117.29 | 116.96 | 117.26 | 1247300.0 |
| 2001-08-28 11:30:00 | SPY | ETF | 117.26 | 117.36 | 117.03 | 117.1 | 387700.0 |
| 2001-08-28 12:00:00 | SPY | ETF | 117.12 | 117.21 | 117.01 | 117.11 | 161600.0 |
| 2001-08-28 12:30:00 | SPY | ETF | 117.13 | 117.3 | 117.13 | 117.14 | 116000.0 |
| 2001-08-28 13:00:00 | SPY | ETF | 117.17 | 117.5 | 117.02 | 117.37 | 520800.0 |
| 2001-08-28 13:30:00 | SPY | ETF | 117.39 | 117.59 | 117.21 | 117.52 | 519900.0 |
| 2001-08-28 14:00:00 | SPY | ETF | 117.56 | 117.58 | 116.81 | 116.84 | 436200.0 |
| 2001-08-28 14:30:00 | SPY | ETF | 116.84 | 116.98 | 116.66 | 116.9 | 854000.0 |
| 2001-08-28 15:00:00 | SPY | ETF | 116.91 | 117.08 | 116.72 | 116.74 | 641300.0 |
| 2001-08-28 15:30:00 | SPY | ETF | 116.74 | 116.96 | 116.59 | 116.64 | 1835900.0 |
| 2001-08-28 16:00:00 | SPY | ETF | 116.65 | 116.67 | 116.58 | 116.62 | 1170000.0 |
| 2001-08-28 16:30:00 | SPY | ETF | 116.59 | 116.65 | 116.59 | 116.65 | 2100.0 |
| 2001-08-28 17:00:00 | SPY | ETF | 116.59 | 116.59 | 116.59 | 116.59 | 200.0 |
| 2001-08-28 09:30:00 | QQQ | ETF | 39.32 | 39.44 | 39.08 | 39.16 | 7387700.0 |
| 2001-08-28 10:00:00 | QQQ | ETF | 39.16 | 39.17 | 38.55 | 38.6 | 8191700.0 |
| 2001-08-28 10:30:00 | QQQ | ETF | 38.59 | 38.65 | 38.31 | 38.48 | 9163900.0 |
| 2001-08-28 11:00:00 | QQQ | ETF | 38.48 | 38.63 | 38.36 | 38.58 | 3133600.0 |
| 2001-08-28 11:30:00 | QQQ | ETF | 38.58 | 38.65 | 38.38 | 38.49 | 3081900.0 |
| 2001-08-28 12:00:00 | QQQ | ETF | 38.47 | 38.56 | 38.33 | 38.42 | 2495500.0 |
| 2001-08-28 12:30:00 | QQQ | ETF | 38.41 | 38.56 | 38.39 | 38.5 | 1601800.0 |
| 2001-08-28 13:00:00 | QQQ | ETF | 38.5 | 38.87 | 38.35 | 38.71 | 3495600.0 |
| 2001-08-28 13:30:00 | QQQ | ETF | 38.72 | 38.89 | 38.52 | 38.83 | 3781100.0 |
| 2001-08-28 14:00:00 | QQQ | ETF | 38.83 | 38.85 | 38.14 | 38.19 | 4677000.0 |
| 2001-08-28 14:30:00 | QQQ | ETF | 38.2 | 38.24 | 38.02 | 38.14 | 4498700.0 |
| 2001-08-28 15:00:00 | QQQ | ETF | 38.13 | 38.32 | 38.01 | 38.12 | 3132800.0 |
| 2001-08-28 15:30:00 | QQQ | ETF | 38.14 | 38.27 | 38.02 | 38.07 | 5442200.0 |
| 2001-08-28 16:00:00 | QQQ | ETF | 38.1 | 38.51 | 38.0 | 38.1 | 1253600.0 |
| 2001-08-28 16:30:00 | QQQ | ETF | 38.1 | 38.15 | 38.08 | 38.15 | 84900.0 |
| 2001-08-28 17:00:00 | QQQ | ETF | 38.11 | 38.16 | 38.08 | 38.13 | 21100.0 |
| 2001-08-28 17:30:00 | QQQ | ETF | 38.13 | 38.16 | 38.12 | 38.15 | 13900.0 |
| 2001-08-28 18:00:00 | QQQ | ETF | 38.16 | 38.17 | 38.12 | 38.15 | 7800.0 |
| 2001-08-28 09:30:00 | IWM | ETF | 47.825 | 47.85 | 47.75 | 47.85 | 39200.0 |
| 2001-08-28 10:00:00 | IWM | ETF | 47.705 | 47.725 | 47.64 | 47.725 | 5200.0 |
| 2001-08-28 10:30:00 | IWM | ETF | 47.565 | 47.565 | 47.44 | 47.44 | 53400.0 |
| 2001-08-28 11:00:00 | IWM | ETF | 47.47 | 47.47 | 47.385 | 47.44 | 7000.0 |
| 2001-08-28 11:30:00 | IWM | ETF | 47.445 | 47.495 | 47.3 | 47.475 | 47000.0 |
| 2001-08-28 12:00:00 | IWM | ETF | 47.35 | 47.45 | 47.35 | 47.45 | 7000.0 |
| 2001-08-28 12:30:00 | IWM | ETF | 47.28 | 47.415 | 47.255 | 47.375 | 427200.0 |
| 2001-08-28 13:00:00 | IWM | ETF | 47.4 | 47.5 | 47.4 | 47.49 | 19600.0 |
| 2001-08-28 13:30:00 | IWM | ETF | 47.5 | 47.55 | 47.495 | 47.55 | 7200.0 |
| 2001-08-28 14:00:00 | IWM | ETF | 47.565 | 47.565 | 47.45 | 47.45 | 10000.0 |
| 2001-08-28 14:30:00 | IWM | ETF | 47.4 | 47.41 | 47.325 | 47.405 | 75600.0 |
| 2001-08-28 15:00:00 | IWM | ETF | 47.415 | 47.44 | 47.275 | 47.425 | 28400.0 |
| 2001-08-28 15:30:00 | IWM | ETF | 47.375 | 47.455 | 47.25 | 47.25 | 205800.0 |
| 2001-08-28 16:00:00 | IWM | ETF | 47.255 | 47.35 | 47.255 | 47.35 | 7600.0 |
| 2001-08-28 09:30:00 | DIA | ETF | 103.99 | 103.99 | 103.71 | 103.73 | 205600.0 |
| 2001-08-28 10:00:00 | DIA | ETF | 103.73 | 103.73 | 103.1 | 103.18 | 278000.0 |
> showing 50 of 378 rows — these rows as CSV