PREVIEW / etf_1hour / 2002-12-17
file: by_date/etf_1hour/2002/2002-12-17.parquet size: 16 KB rows: 397
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-12-17 08:00:00 | SPY | ETF | 91.4 | 91.73 | 91.34 | 91.39 | 32500.0 |
| 2002-12-17 09:00:00 | SPY | ETF | 91.43 | 91.67 | 91.21 | 91.54 | 3633200.0 |
| 2002-12-17 10:00:00 | SPY | ETF | 91.55 | 91.74 | 90.92 | 91.04 | 6277200.0 |
| 2002-12-17 11:00:00 | SPY | ETF | 91.02 | 91.36 | 90.96 | 91.29 | 3642900.0 |
| 2002-12-17 12:00:00 | SPY | ETF | 91.3 | 91.38 | 91.08 | 91.28 | 1714300.0 |
| 2002-12-17 13:00:00 | SPY | ETF | 91.28 | 91.38 | 91.03 | 91.12 | 2099700.0 |
| 2002-12-17 14:00:00 | SPY | ETF | 91.15 | 91.37 | 91.02 | 91.14 | 3287900.0 |
| 2002-12-17 15:00:00 | SPY | ETF | 91.14 | 91.21 | 90.74 | 90.9 | 4523300.0 |
| 2002-12-17 16:00:00 | SPY | ETF | 90.88 | 91.0 | 90.7 | 90.99 | 1670400.0 |
| 2002-12-17 17:00:00 | SPY | ETF | 90.94 | 90.94 | 90.62 | 90.83 | 228900.0 |
| 2002-12-17 18:00:00 | SPY | ETF | 90.87 | 90.92 | 90.73 | 90.73 | 14100.0 |
| 2002-12-17 19:00:00 | SPY | ETF | 90.87 | 90.87 | 90.8 | 90.8 | 500.0 |
| 2002-12-17 08:00:00 | QQQ | ETF | 25.8 | 25.94 | 25.75 | 25.82 | 110000.0 |
| 2002-12-17 09:00:00 | QQQ | ETF | 25.81 | 26.1 | 25.7 | 26.07 | 9327000.0 |
| 2002-12-17 10:00:00 | QQQ | ETF | 26.07 | 26.2 | 25.72 | 25.76 | 16081000.0 |
| 2002-12-17 11:00:00 | QQQ | ETF | 25.77 | 26.03 | 25.75 | 26.02 | 7119000.0 |
| 2002-12-17 12:00:00 | QQQ | ETF | 26.01 | 26.09 | 25.91 | 26.02 | 2889400.0 |
| 2002-12-17 13:00:00 | QQQ | ETF | 26.02 | 26.08 | 25.86 | 25.9 | 3029200.0 |
| 2002-12-17 14:00:00 | QQQ | ETF | 25.89 | 25.98 | 25.82 | 25.86 | 5250300.0 |
| 2002-12-17 15:00:00 | QQQ | ETF | 25.91 | 25.92 | 25.66 | 25.86 | 9165700.0 |
| 2002-12-17 16:00:00 | QQQ | ETF | 25.87 | 25.95 | 25.78 | 25.94 | 1580500.0 |
| 2002-12-17 17:00:00 | QQQ | ETF | 25.93 | 25.94 | 25.59 | 25.75 | 1611700.0 |
| 2002-12-17 18:00:00 | QQQ | ETF | 25.74 | 25.87 | 25.72 | 25.77 | 190000.0 |
| 2002-12-17 19:00:00 | QQQ | ETF | 25.77 | 25.94 | 25.77 | 25.88 | 190000.0 |
| 2002-12-17 09:00:00 | IWM | ETF | 39.225 | 39.26 | 39.0 | 39.205 | 412800.0 |
| 2002-12-17 10:00:00 | IWM | ETF | 39.16 | 39.27 | 39.0 | 39.01 | 393400.0 |
| 2002-12-17 11:00:00 | IWM | ETF | 39.005 | 39.115 | 38.955 | 39.09 | 111000.0 |
| 2002-12-17 12:00:00 | IWM | ETF | 39.105 | 39.125 | 38.98 | 39.08 | 51200.0 |
| 2002-12-17 13:00:00 | IWM | ETF | 39.1 | 39.125 | 39.005 | 39.015 | 134200.0 |
| 2002-12-17 14:00:00 | IWM | ETF | 39.015 | 39.15 | 38.975 | 39.03 | 153800.0 |
| 2002-12-17 15:00:00 | IWM | ETF | 39.015 | 39.04 | 38.74 | 38.85 | 570000.0 |
| 2002-12-17 16:00:00 | IWM | ETF | 38.875 | 38.95 | 38.79 | 38.8 | 110600.0 |
| 2002-12-17 19:00:00 | IWM | ETF | 38.81 | 38.81 | 38.81 | 38.81 | 200.0 |
| 2002-12-17 08:00:00 | DIA | ETF | 86.4 | 86.54 | 86.2 | 86.2 | 13900.0 |
| 2002-12-17 09:00:00 | DIA | ETF | 86.25 | 86.54 | 86.07 | 86.45 | 815200.0 |
| 2002-12-17 10:00:00 | DIA | ETF | 86.43 | 86.69 | 85.91 | 86.0 | 791900.0 |
| 2002-12-17 11:00:00 | DIA | ETF | 85.98 | 86.28 | 85.91 | 86.21 | 448100.0 |
| 2002-12-17 12:00:00 | DIA | ETF | 86.2 | 86.27 | 85.89 | 85.99 | 365800.0 |
| 2002-12-17 13:00:00 | DIA | ETF | 86.0 | 86.08 | 85.77 | 85.84 | 268000.0 |
| 2002-12-17 14:00:00 | DIA | ETF | 85.85 | 86.1 | 85.72 | 85.85 | 384400.0 |
| 2002-12-17 15:00:00 | DIA | ETF | 85.88 | 85.9 | 85.48 | 85.61 | 621300.0 |
| 2002-12-17 16:00:00 | DIA | ETF | 85.62 | 85.69 | 85.54 | 85.65 | 113800.0 |
| 2002-12-17 17:00:00 | DIA | ETF | 85.62 | 85.67 | 85.45 | 85.6 | 8900.0 |
| 2002-12-17 18:00:00 | DIA | ETF | 85.6 | 85.65 | 85.6 | 85.65 | 4100.0 |
| 2002-12-17 19:00:00 | DIA | ETF | 85.55 | 85.55 | 85.55 | 85.55 | 200.0 |
| 2002-12-17 09:00:00 | TLT | ETF | 86.3 | 86.35 | 86.09 | 86.19 | 13400.0 |
| 2002-12-17 10:00:00 | TLT | ETF | 86.2 | 86.2 | 85.92 | 85.96 | 23200.0 |
| 2002-12-17 11:00:00 | TLT | ETF | 85.95 | 85.95 | 85.68 | 85.68 | 6300.0 |
| 2002-12-17 12:00:00 | TLT | ETF | 85.78 | 86.06 | 85.78 | 86.0 | 5800.0 |
| 2002-12-17 13:00:00 | TLT | ETF | 85.95 | 86.0 | 85.95 | 85.98 | 103600.0 |
> showing 50 of 397 rows — these rows as CSV