PREVIEW / etf_1hour / 2001-03-08
file: by_date/etf_1hour/2001/2001-03-08.parquet size: 11 KB rows: 220
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-03-08 09:00:00 | SPY | ETF | 126.6 | 127.21 | 126.45 | 127.0 | 949800.0 |
| 2001-03-08 10:00:00 | SPY | ETF | 127.08 | 127.08 | 126.21 | 126.44 | 1016800.0 |
| 2001-03-08 11:00:00 | SPY | ETF | 126.43 | 127.22 | 126.14 | 127.05 | 902800.0 |
| 2001-03-08 12:00:00 | SPY | ETF | 127.07 | 127.07 | 126.47 | 126.57 | 658300.0 |
| 2001-03-08 13:00:00 | SPY | ETF | 126.56 | 126.84 | 126.31 | 126.64 | 393800.0 |
| 2001-03-08 14:00:00 | SPY | ETF | 126.54 | 126.66 | 126.2 | 126.5 | 246400.0 |
| 2001-03-08 15:00:00 | SPY | ETF | 126.5 | 127.06 | 126.25 | 126.9 | 1217200.0 |
| 2001-03-08 16:00:00 | SPY | ETF | 126.85 | 127.19 | 126.78 | 127.0 | 420500.0 |
| 2001-03-08 17:00:00 | SPY | ETF | 126.52 | 126.52 | 126.12 | 126.12 | 50100.0 |
| 2001-03-08 09:00:00 | QQQ | ETF | 49.35 | 49.8 | 49.18 | 49.35 | 5731600.0 |
| 2001-03-08 10:00:00 | QQQ | ETF | 49.31 | 49.42 | 48.37 | 48.62 | 11153700.0 |
| 2001-03-08 11:00:00 | QQQ | ETF | 48.6 | 49.25 | 48.38 | 49.07 | 7491600.0 |
| 2001-03-08 12:00:00 | QQQ | ETF | 49.07 | 49.15 | 48.5 | 48.65 | 3300900.0 |
| 2001-03-08 13:00:00 | QQQ | ETF | 48.65 | 48.87 | 48.4 | 48.77 | 3649700.0 |
| 2001-03-08 14:00:00 | QQQ | ETF | 48.74 | 48.76 | 48.1 | 48.5 | 5052800.0 |
| 2001-03-08 15:00:00 | QQQ | ETF | 48.53 | 48.85 | 48.15 | 48.27 | 7388000.0 |
| 2001-03-08 16:00:00 | QQQ | ETF | 48.25 | 49.19 | 48.15 | 48.53 | 1549100.0 |
| 2001-03-08 17:00:00 | QQQ | ETF | 48.51 | 48.53 | 47.19 | 47.55 | 1183800.0 |
| 2001-03-08 18:00:00 | QQQ | ETF | 47.51 | 47.6 | 47.34 | 47.5 | 67100.0 |
| 2001-03-08 09:00:00 | IWM | ETF | 48.295 | 48.305 | 48.21 | 48.305 | 8800.0 |
| 2001-03-08 10:00:00 | IWM | ETF | 48.34 | 48.4 | 48.025 | 48.165 | 130400.0 |
| 2001-03-08 11:00:00 | IWM | ETF | 48.17 | 48.25 | 48.01 | 48.25 | 203600.0 |
| 2001-03-08 12:00:00 | IWM | ETF | 48.15 | 48.3 | 48.075 | 48.075 | 410400.0 |
| 2001-03-08 13:00:00 | IWM | ETF | 48.125 | 48.2 | 48.0 | 48.175 | 18000.0 |
| 2001-03-08 14:00:00 | IWM | ETF | 48.16 | 48.175 | 47.975 | 47.975 | 3600.0 |
| 2001-03-08 15:00:00 | IWM | ETF | 48.115 | 48.15 | 47.915 | 47.95 | 52000.0 |
| 2001-03-08 16:00:00 | IWM | ETF | 48.0 | 48.0 | 47.9 | 47.9 | 2400.0 |
| 2001-03-08 09:00:00 | DIA | ETF | 107.01 | 107.89 | 107.01 | 107.85 | 474300.0 |
| 2001-03-08 10:00:00 | DIA | ETF | 107.9 | 107.9 | 107.17 | 107.38 | 322200.0 |
| 2001-03-08 11:00:00 | DIA | ETF | 107.36 | 108.02 | 107.26 | 107.87 | 349300.0 |
| 2001-03-08 12:00:00 | DIA | ETF | 107.87 | 108.0 | 107.56 | 107.71 | 247000.0 |
| 2001-03-08 13:00:00 | DIA | ETF | 107.66 | 107.96 | 107.56 | 107.81 | 143200.0 |
| 2001-03-08 14:00:00 | DIA | ETF | 107.91 | 108.16 | 107.65 | 108.01 | 192500.0 |
| 2001-03-08 15:00:00 | DIA | ETF | 107.95 | 108.78 | 107.93 | 108.54 | 628000.0 |
| 2001-03-08 16:00:00 | DIA | ETF | 108.54 | 108.73 | 108.13 | 108.13 | 93600.0 |
| 2001-03-08 17:00:00 | DIA | ETF | 108.5 | 108.5 | 108.4 | 108.4 | 2400.0 |
| 2001-03-08 18:00:00 | DIA | ETF | 108.01 | 108.01 | 108.01 | 108.01 | 300.0 |
> showing 37 of 220 rows — these rows as CSV