PREVIEW / etf_5min / 2005-11-02
file: by_date/etf_5min/2005/2005-11-02.parquet size: 148 KB rows: 7,416
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 |
|---|---|---|---|---|---|---|---|
| 2005-11-02 07:00:00 | SPY | ETF | 120.6 | 120.6 | 120.6 | 120.6 | 300.0 |
| 2005-11-02 07:05:00 | SPY | ETF | 120.58 | 120.59 | 120.58 | 120.59 | 25000.0 |
| 2005-11-02 07:25:00 | SPY | ETF | 120.5 | 120.5 | 120.5 | 120.5 | 1100.0 |
| 2005-11-02 07:30:00 | SPY | ETF | 120.43 | 120.43 | 120.43 | 120.43 | 2300.0 |
| 2005-11-02 07:35:00 | SPY | ETF | 120.45 | 120.45 | 120.45 | 120.45 | 5000.0 |
| 2005-11-02 07:50:00 | SPY | ETF | 120.44 | 120.44 | 120.42 | 120.42 | 12300.0 |
| 2005-11-02 08:00:00 | SPY | ETF | 120.37 | 120.61 | 120.31 | 120.33 | 52200.0 |
| 2005-11-02 08:05:00 | SPY | ETF | 120.36 | 120.36 | 120.21 | 120.21 | 18100.0 |
| 2005-11-02 08:10:00 | SPY | ETF | 120.26 | 120.29 | 120.21 | 120.29 | 149000.0 |
| 2005-11-02 08:15:00 | SPY | ETF | 120.26 | 120.26 | 120.24 | 120.25 | 9000.0 |
| 2005-11-02 08:20:00 | SPY | ETF | 120.25 | 120.26 | 120.22 | 120.25 | 80200.0 |
| 2005-11-02 08:25:00 | SPY | ETF | 120.23 | 120.29 | 120.23 | 120.29 | 97600.0 |
| 2005-11-02 08:30:00 | SPY | ETF | 120.28 | 120.29 | 120.28 | 120.28 | 49800.0 |
| 2005-11-02 08:35:00 | SPY | ETF | 120.28 | 120.44 | 120.27 | 120.3 | 659800.0 |
| 2005-11-02 08:40:00 | SPY | ETF | 120.3 | 120.31 | 120.27 | 120.27 | 16800.0 |
| 2005-11-02 08:45:00 | SPY | ETF | 120.28 | 120.28 | 120.28 | 120.28 | 26300.0 |
| 2005-11-02 08:50:00 | SPY | ETF | 120.3 | 120.3 | 120.3 | 120.3 | 500.0 |
| 2005-11-02 08:55:00 | SPY | ETF | 120.3 | 120.3 | 120.26 | 120.27 | 23300.0 |
| 2005-11-02 09:00:00 | SPY | ETF | 120.27 | 120.34 | 120.27 | 120.34 | 21400.0 |
| 2005-11-02 09:05:00 | SPY | ETF | 120.32 | 120.34 | 120.31 | 120.34 | 33500.0 |
| 2005-11-02 09:10:00 | SPY | ETF | 120.32 | 120.32 | 120.23 | 120.25 | 77100.0 |
| 2005-11-02 09:15:00 | SPY | ETF | 120.24 | 120.26 | 120.23 | 120.25 | 25100.0 |
| 2005-11-02 09:20:00 | SPY | ETF | 120.26 | 120.28 | 120.25 | 120.28 | 8800.0 |
| 2005-11-02 09:25:00 | SPY | ETF | 120.24 | 120.25 | 120.17 | 120.17 | 88600.0 |
| 2005-11-02 09:30:00 | SPY | ETF | 120.17 | 120.34 | 120.13 | 120.29 | 986900.0 |
| 2005-11-02 09:35:00 | SPY | ETF | 120.28 | 120.44 | 120.28 | 120.4 | 933800.0 |
| 2005-11-02 09:40:00 | SPY | ETF | 120.41 | 120.6 | 120.36 | 120.6 | 1740200.0 |
| 2005-11-02 09:45:00 | SPY | ETF | 120.6 | 120.77 | 120.5 | 120.7 | 2104600.0 |
| 2005-11-02 09:50:00 | SPY | ETF | 120.69 | 120.74 | 120.62 | 120.67 | 705400.0 |
| 2005-11-02 09:55:00 | SPY | ETF | 120.68 | 120.73 | 120.6 | 120.63 | 558300.0 |
| 2005-11-02 10:00:00 | SPY | ETF | 120.64 | 120.77 | 120.62 | 120.65 | 483100.0 |
| 2005-11-02 10:05:00 | SPY | ETF | 120.66 | 120.76 | 120.65 | 120.71 | 660300.0 |
| 2005-11-02 10:10:00 | SPY | ETF | 120.71 | 120.74 | 120.59 | 120.67 | 1012500.0 |
| 2005-11-02 10:15:00 | SPY | ETF | 120.68 | 120.74 | 120.64 | 120.65 | 370000.0 |
| 2005-11-02 10:20:00 | SPY | ETF | 120.66 | 120.74 | 120.58 | 120.74 | 635200.0 |
| 2005-11-02 10:25:00 | SPY | ETF | 120.73 | 120.74 | 120.58 | 120.68 | 265000.0 |
| 2005-11-02 10:30:00 | SPY | ETF | 120.69 | 120.9 | 120.58 | 120.82 | 1916000.0 |
| 2005-11-02 10:35:00 | SPY | ETF | 120.83 | 120.85 | 120.7 | 120.72 | 930800.0 |
| 2005-11-02 10:40:00 | SPY | ETF | 120.72 | 120.95 | 120.7 | 120.9199 | 2232000.0 |
| 2005-11-02 10:45:00 | SPY | ETF | 120.92 | 121.07 | 120.91 | 121.03 | 3395500.0 |
| 2005-11-02 10:50:00 | SPY | ETF | 121.03 | 121.05 | 120.94 | 121.01 | 519100.0 |
| 2005-11-02 10:55:00 | SPY | ETF | 121.0 | 121.04 | 120.94 | 120.98 | 409300.0 |
| 2005-11-02 11:00:00 | SPY | ETF | 120.98 | 121.16 | 120.96 | 121.06 | 1149300.0 |
| 2005-11-02 11:05:00 | SPY | ETF | 121.052 | 121.1 | 121.04 | 121.05 | 347300.0 |
| 2005-11-02 11:10:00 | SPY | ETF | 121.06 | 121.15 | 121.01 | 121.04 | 1596900.0 |
| 2005-11-02 11:15:00 | SPY | ETF | 121.05 | 121.2 | 121.02 | 121.2 | 2127100.0 |
| 2005-11-02 11:20:00 | SPY | ETF | 121.19 | 121.22 | 121.11 | 121.2 | 1423900.0 |
| 2005-11-02 11:25:00 | SPY | ETF | 121.21 | 121.23 | 121.15 | 121.22 | 447900.0 |
| 2005-11-02 11:30:00 | SPY | ETF | 121.2 | 121.3 | 121.18 | 121.28 | 557300.0 |
| 2005-11-02 11:35:00 | SPY | ETF | 121.28 | 121.34 | 121.25 | 121.29 | 1497200.0 |
> showing 50 of 7,416 rows — these rows as CSV