PREVIEW / etf_1min / 2009-02-20
file: by_date/etf_1min/2009/2009-02-20.parquet size: 1.8 MB rows: 102,478
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 |
|---|---|---|---|---|---|---|---|
| 2009-02-20 04:15:00 | SPY | ETF | 77.4 | 77.46 | 77.4 | 77.41 | 790.0 |
| 2009-02-20 04:17:00 | SPY | ETF | 77.39 | 77.39 | 77.39 | 77.39 | 100.0 |
| 2009-02-20 04:18:00 | SPY | ETF | 77.39 | 77.39 | 77.33 | 77.33 | 500.0 |
| 2009-02-20 04:19:00 | SPY | ETF | 77.31 | 77.31 | 77.29 | 77.29 | 300.0 |
| 2009-02-20 04:20:00 | SPY | ETF | 77.26 | 77.39 | 77.26 | 77.36 | 729.0 |
| 2009-02-20 04:23:00 | SPY | ETF | 77.3 | 77.3 | 77.3 | 77.3 | 100.0 |
| 2009-02-20 04:34:00 | SPY | ETF | 77.36 | 77.36 | 77.36 | 77.36 | 100.0 |
| 2009-02-20 04:39:00 | SPY | ETF | 77.07 | 77.07 | 77.07 | 77.07 | 100.0 |
| 2009-02-20 04:40:00 | SPY | ETF | 77.14 | 77.14 | 77.05 | 77.05 | 3400.0 |
| 2009-02-20 04:41:00 | SPY | ETF | 77.11 | 77.11 | 77.06 | 77.06 | 450.0 |
| 2009-02-20 04:42:00 | SPY | ETF | 77.06 | 77.06 | 77.01 | 77.01 | 750.0 |
| 2009-02-20 04:44:00 | SPY | ETF | 77.0 | 77.06 | 77.0 | 77.06 | 500.0 |
| 2009-02-20 04:46:00 | SPY | ETF | 76.99 | 76.99 | 76.96 | 76.97 | 300.0 |
| 2009-02-20 04:47:00 | SPY | ETF | 77.06 | 77.06 | 77.02 | 77.02 | 300.0 |
| 2009-02-20 04:48:00 | SPY | ETF | 77.11 | 77.11 | 77.11 | 77.11 | 100.0 |
| 2009-02-20 04:49:00 | SPY | ETF | 77.11 | 77.16 | 77.1 | 77.1 | 300.0 |
| 2009-02-20 04:52:00 | SPY | ETF | 77.09 | 77.09 | 77.09 | 77.09 | 300.0 |
| 2009-02-20 04:54:00 | SPY | ETF | 77.11 | 77.11 | 77.06 | 77.06 | 200.0 |
| 2009-02-20 05:04:00 | SPY | ETF | 77.11 | 77.11 | 77.02 | 77.02 | 700.0 |
| 2009-02-20 05:11:00 | SPY | ETF | 77.06 | 77.06 | 77.06 | 77.06 | 100.0 |
| 2009-02-20 05:13:00 | SPY | ETF | 77.06 | 77.06 | 77.04 | 77.04 | 200.0 |
| 2009-02-20 05:16:00 | SPY | ETF | 77.05 | 77.05 | 77.05 | 77.05 | 100.0 |
| 2009-02-20 05:17:00 | SPY | ETF | 77.09 | 77.09 | 77.09 | 77.09 | 100.0 |
| 2009-02-20 05:19:00 | SPY | ETF | 77.01 | 77.01 | 77.01 | 77.01 | 100.0 |
| 2009-02-20 05:35:00 | SPY | ETF | 77.18 | 77.18 | 77.18 | 77.18 | 100.0 |
| 2009-02-20 05:38:00 | SPY | ETF | 77.25 | 77.25 | 77.25 | 77.25 | 100.0 |
| 2009-02-20 05:39:00 | SPY | ETF | 77.25 | 77.25 | 77.25 | 77.25 | 100.0 |
| 2009-02-20 05:44:00 | SPY | ETF | 77.27 | 77.27 | 77.27 | 77.27 | 200.0 |
| 2009-02-20 05:45:00 | SPY | ETF | 77.34 | 77.34 | 77.34 | 77.34 | 500.0 |
| 2009-02-20 05:46:00 | SPY | ETF | 77.34 | 77.34 | 77.34 | 77.34 | 500.0 |
| 2009-02-20 05:51:00 | SPY | ETF | 77.21 | 77.21 | 77.21 | 77.21 | 500.0 |
| 2009-02-20 05:52:00 | SPY | ETF | 77.21 | 77.21 | 77.21 | 77.21 | 100.0 |
| 2009-02-20 05:53:00 | SPY | ETF | 77.21 | 77.21 | 77.2 | 77.2 | 1500.0 |
| 2009-02-20 05:57:00 | SPY | ETF | 77.09 | 77.09 | 77.09 | 77.09 | 100.0 |
| 2009-02-20 06:02:00 | SPY | ETF | 77.2 | 77.2 | 77.2 | 77.2 | 150.0 |
| 2009-02-20 06:09:00 | SPY | ETF | 77.26 | 77.26 | 77.26 | 77.26 | 100.0 |
| 2009-02-20 06:14:00 | SPY | ETF | 77.32 | 77.32 | 77.32 | 77.32 | 100.0 |
| 2009-02-20 06:15:00 | SPY | ETF | 77.36 | 77.36 | 77.36 | 77.36 | 200.0 |
| 2009-02-20 06:22:00 | SPY | ETF | 77.31 | 77.31 | 77.31 | 77.31 | 600.0 |
| 2009-02-20 06:27:00 | SPY | ETF | 77.33 | 77.33 | 77.33 | 77.33 | 400.0 |
| 2009-02-20 06:39:00 | SPY | ETF | 77.36 | 77.36 | 77.36 | 77.36 | 150.0 |
| 2009-02-20 06:40:00 | SPY | ETF | 77.38 | 77.38 | 77.38 | 77.38 | 500.0 |
| 2009-02-20 06:42:00 | SPY | ETF | 77.33 | 77.33 | 77.33 | 77.33 | 100.0 |
| 2009-02-20 06:47:00 | SPY | ETF | 77.33 | 77.33 | 77.33 | 77.33 | 2401.0 |
| 2009-02-20 06:53:00 | SPY | ETF | 77.37 | 77.37 | 77.37 | 77.37 | 400.0 |
| 2009-02-20 06:56:00 | SPY | ETF | 77.32 | 77.32 | 77.32 | 77.32 | 100.0 |
| 2009-02-20 06:57:00 | SPY | ETF | 77.28 | 77.28 | 77.28 | 77.28 | 369.0 |
| 2009-02-20 06:58:00 | SPY | ETF | 77.32 | 77.32 | 77.32 | 77.32 | 369.0 |
| 2009-02-20 06:59:00 | SPY | ETF | 77.3 | 77.3 | 77.25 | 77.25 | 1107.0 |
| 2009-02-20 07:00:00 | SPY | ETF | 77.24 | 77.29 | 77.21 | 77.24 | 35000.0 |
> showing 50 of 102,478 rows — these rows as CSV