PREVIEW / etf_1min / 2008-07-15
file: by_date/etf_1min/2008/2008-07-15.parquet size: 1.4 MB rows: 85,628
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 |
|---|---|---|---|---|---|---|---|
| 2008-07-15 04:15:00 | SPY | ETF | 121.89 | 121.9 | 121.89 | 121.9 | 1200.0 |
| 2008-07-15 04:22:00 | SPY | ETF | 121.85 | 121.85 | 121.85 | 121.85 | 200.0 |
| 2008-07-15 04:38:00 | SPY | ETF | 121.81 | 121.81 | 121.81 | 121.81 | 100.0 |
| 2008-07-15 05:45:00 | SPY | ETF | 121.83 | 121.83 | 121.83 | 121.83 | 1000.0 |
| 2008-07-15 05:47:00 | SPY | ETF | 121.8 | 121.8 | 121.8 | 121.8 | 100.0 |
| 2008-07-15 05:57:00 | SPY | ETF | 121.65 | 121.65 | 121.65 | 121.65 | 200.0 |
| 2008-07-15 06:01:00 | SPY | ETF | 121.58 | 121.58 | 121.58 | 121.58 | 500.0 |
| 2008-07-15 06:02:00 | SPY | ETF | 121.59 | 121.59 | 121.59 | 121.59 | 500.0 |
| 2008-07-15 06:09:00 | SPY | ETF | 121.6 | 121.6 | 121.6 | 121.6 | 1000.0 |
| 2008-07-15 06:16:00 | SPY | ETF | 121.65 | 121.65 | 121.65 | 121.65 | 500.0 |
| 2008-07-15 06:19:00 | SPY | ETF | 121.58 | 121.59 | 121.58 | 121.59 | 1000.0 |
| 2008-07-15 06:20:00 | SPY | ETF | 121.63 | 121.63 | 121.63 | 121.63 | 52000.0 |
| 2008-07-15 06:21:00 | SPY | ETF | 121.63 | 121.63 | 121.63 | 121.63 | 87000.0 |
| 2008-07-15 06:23:00 | SPY | ETF | 121.55 | 121.55 | 121.55 | 121.55 | 1000.0 |
| 2008-07-15 06:27:00 | SPY | ETF | 121.63 | 121.63 | 121.63 | 121.63 | 1000.0 |
| 2008-07-15 06:29:00 | SPY | ETF | 121.61 | 121.61 | 121.61 | 121.61 | 41000.0 |
| 2008-07-15 06:30:00 | SPY | ETF | 121.6 | 121.6 | 121.55 | 121.55 | 49500.0 |
| 2008-07-15 06:31:00 | SPY | ETF | 121.56 | 121.56 | 121.56 | 121.56 | 500.0 |
| 2008-07-15 06:32:00 | SPY | ETF | 121.55 | 121.55 | 121.5 | 121.5 | 25000.0 |
| 2008-07-15 06:34:00 | SPY | ETF | 121.5 | 121.51 | 121.44 | 121.44 | 72600.0 |
| 2008-07-15 06:35:00 | SPY | ETF | 121.45 | 121.45 | 121.45 | 121.45 | 500.0 |
| 2008-07-15 06:36:00 | SPY | ETF | 121.44 | 121.45 | 121.42 | 121.45 | 209000.0 |
| 2008-07-15 06:37:00 | SPY | ETF | 121.43 | 121.43 | 121.37 | 121.37 | 91200.0 |
| 2008-07-15 06:38:00 | SPY | ETF | 121.33 | 121.33 | 121.31 | 121.33 | 400.0 |
| 2008-07-15 06:40:00 | SPY | ETF | 121.37 | 121.37 | 121.34 | 121.34 | 1000.0 |
| 2008-07-15 06:41:00 | SPY | ETF | 121.33 | 121.33 | 121.25 | 121.25 | 300.0 |
| 2008-07-15 06:42:00 | SPY | ETF | 121.23 | 121.23 | 121.21 | 121.21 | 2000.0 |
| 2008-07-15 06:43:00 | SPY | ETF | 121.18 | 121.25 | 121.18 | 121.23 | 79100.0 |
| 2008-07-15 06:45:00 | SPY | ETF | 121.27 | 121.27 | 121.27 | 121.27 | 1000.0 |
| 2008-07-15 06:46:00 | SPY | ETF | 121.27 | 121.27 | 121.27 | 121.27 | 100.0 |
| 2008-07-15 06:48:00 | SPY | ETF | 121.31 | 121.32 | 121.3 | 121.3 | 240000.0 |
| 2008-07-15 06:49:00 | SPY | ETF | 121.24 | 121.24 | 121.05 | 121.05 | 30900.0 |
| 2008-07-15 06:50:00 | SPY | ETF | 121.09 | 121.1 | 121.05 | 121.1 | 25900.0 |
| 2008-07-15 06:51:00 | SPY | ETF | 121.1 | 121.1 | 121.09 | 121.09 | 200100.0 |
| 2008-07-15 06:52:00 | SPY | ETF | 121.04 | 121.04 | 121.04 | 121.04 | 1000.0 |
| 2008-07-15 06:53:00 | SPY | ETF | 121.15 | 121.15 | 121.15 | 121.15 | 1000.0 |
| 2008-07-15 06:54:00 | SPY | ETF | 121.18 | 121.18 | 121.17 | 121.17 | 2500.0 |
| 2008-07-15 06:55:00 | SPY | ETF | 121.17 | 121.17 | 121.17 | 121.17 | 100.0 |
| 2008-07-15 06:56:00 | SPY | ETF | 121.17 | 121.17 | 121.17 | 121.17 | 47900.0 |
| 2008-07-15 06:57:00 | SPY | ETF | 121.22 | 121.24 | 121.22 | 121.24 | 1900.0 |
| 2008-07-15 06:58:00 | SPY | ETF | 121.22 | 121.22 | 121.19 | 121.19 | 300.0 |
| 2008-07-15 06:59:00 | SPY | ETF | 121.16 | 121.17 | 121.16 | 121.17 | 52100.0 |
| 2008-07-15 07:00:00 | SPY | ETF | 121.19 | 121.24 | 121.18 | 121.18 | 15600.0 |
| 2008-07-15 07:01:00 | SPY | ETF | 121.21 | 121.24 | 121.16 | 121.24 | 11000.0 |
| 2008-07-15 07:02:00 | SPY | ETF | 121.26 | 121.26 | 121.26 | 121.26 | 5000.0 |
| 2008-07-15 07:04:00 | SPY | ETF | 121.26 | 121.26 | 121.26 | 121.26 | 285.0 |
| 2008-07-15 07:05:00 | SPY | ETF | 121.24 | 121.24 | 121.23 | 121.23 | 9300.0 |
| 2008-07-15 07:06:00 | SPY | ETF | 121.27 | 121.27 | 121.27 | 121.27 | 5000.0 |
| 2008-07-15 07:07:00 | SPY | ETF | 121.28 | 121.33 | 121.25 | 121.25 | 106900.0 |
| 2008-07-15 07:08:00 | SPY | ETF | 121.25 | 121.25 | 121.25 | 121.25 | 26800.0 |
> showing 50 of 85,628 rows — these rows as CSV