PREVIEW / etf_1min / 2007-06-14
file: by_date/etf_1min/2007/2007-06-14.parquet size: 604 KB rows: 42,386
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 |
|---|---|---|---|---|---|---|---|
| 2007-06-14 06:06:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 15000.0 |
| 2007-06-14 06:33:00 | SPY | ETF | 151.91 | 151.91 | 151.91 | 151.91 | 200.0 |
| 2007-06-14 06:53:00 | SPY | ETF | 152.0 | 152.0 | 152.0 | 152.0 | 2000.0 |
| 2007-06-14 06:59:00 | SPY | ETF | 151.99 | 151.99 | 151.99 | 151.99 | 4000.0 |
| 2007-06-14 07:01:00 | SPY | ETF | 151.92 | 151.98 | 151.92 | 151.98 | 21100.0 |
| 2007-06-14 07:03:00 | SPY | ETF | 151.91 | 151.91 | 151.91 | 151.91 | 3000.0 |
| 2007-06-14 07:07:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 200.0 |
| 2007-06-14 07:08:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 2300.0 |
| 2007-06-14 07:15:00 | SPY | ETF | 151.95 | 151.95 | 151.95 | 151.95 | 100.0 |
| 2007-06-14 07:16:00 | SPY | ETF | 151.96 | 151.97 | 151.95 | 151.95 | 8100.0 |
| 2007-06-14 07:21:00 | SPY | ETF | 151.97 | 151.98 | 151.96 | 151.96 | 15100.0 |
| 2007-06-14 07:25:00 | SPY | ETF | 151.97 | 152.0 | 151.97 | 151.99 | 29000.0 |
| 2007-06-14 07:26:00 | SPY | ETF | 151.99 | 152.0 | 151.99 | 152.0 | 3500.0 |
| 2007-06-14 07:27:00 | SPY | ETF | 152.02 | 152.07 | 152.02 | 152.07 | 10200.0 |
| 2007-06-14 07:29:00 | SPY | ETF | 152.06 | 152.06 | 152.06 | 152.06 | 100.0 |
| 2007-06-14 07:30:00 | SPY | ETF | 152.07 | 152.09 | 152.06 | 152.07 | 2700.0 |
| 2007-06-14 07:31:00 | SPY | ETF | 152.07 | 152.1 | 152.02 | 152.1 | 49200.0 |
| 2007-06-14 07:32:00 | SPY | ETF | 152.09 | 152.09 | 152.09 | 152.09 | 1000.0 |
| 2007-06-14 07:33:00 | SPY | ETF | 152.14 | 152.14 | 152.11 | 152.11 | 3500.0 |
| 2007-06-14 07:34:00 | SPY | ETF | 152.1 | 152.1 | 152.1 | 152.1 | 1000.0 |
| 2007-06-14 07:35:00 | SPY | ETF | 152.13 | 152.14 | 152.13 | 152.14 | 1800.0 |
| 2007-06-14 07:36:00 | SPY | ETF | 152.14 | 152.14 | 152.14 | 152.14 | 300.0 |
| 2007-06-14 07:37:00 | SPY | ETF | 152.14 | 152.14 | 152.14 | 152.14 | 500.0 |
| 2007-06-14 07:39:00 | SPY | ETF | 152.15 | 152.15 | 152.15 | 152.15 | 1000.0 |
| 2007-06-14 07:40:00 | SPY | ETF | 152.19 | 152.19 | 152.16 | 152.18 | 12100.0 |
| 2007-06-14 07:41:00 | SPY | ETF | 152.14 | 152.14 | 152.13 | 152.13 | 4500.0 |
| 2007-06-14 07:42:00 | SPY | ETF | 152.18 | 152.18 | 152.18 | 152.18 | 500.0 |
| 2007-06-14 07:43:00 | SPY | ETF | 152.16 | 152.16 | 152.13 | 152.16 | 15000.0 |
| 2007-06-14 07:44:00 | SPY | ETF | 152.16 | 152.16 | 152.16 | 152.16 | 16700.0 |
| 2007-06-14 07:45:00 | SPY | ETF | 152.19 | 152.19 | 152.17 | 152.18 | 6700.0 |
| 2007-06-14 07:46:00 | SPY | ETF | 152.16 | 152.16 | 152.15 | 152.15 | 25000.0 |
| 2007-06-14 07:48:00 | SPY | ETF | 152.19 | 152.24 | 152.19 | 152.24 | 800.0 |
| 2007-06-14 07:49:00 | SPY | ETF | 152.25 | 152.25 | 152.22 | 152.25 | 17800.0 |
| 2007-06-14 07:50:00 | SPY | ETF | 152.26 | 152.26 | 152.25 | 152.25 | 4000.0 |
| 2007-06-14 07:51:00 | SPY | ETF | 152.25 | 152.28 | 152.25 | 152.28 | 29400.0 |
| 2007-06-14 07:52:00 | SPY | ETF | 152.27 | 152.3 | 152.27 | 152.3 | 9300.0 |
| 2007-06-14 07:53:00 | SPY | ETF | 152.28 | 152.28 | 152.28 | 152.28 | 100.0 |
| 2007-06-14 07:54:00 | SPY | ETF | 152.27 | 152.27 | 152.25 | 152.25 | 12200.0 |
| 2007-06-14 07:55:00 | SPY | ETF | 152.25 | 152.25 | 152.23 | 152.23 | 50500.0 |
| 2007-06-14 07:56:00 | SPY | ETF | 152.23 | 152.23 | 152.23 | 152.23 | 1000.0 |
| 2007-06-14 07:58:00 | SPY | ETF | 152.22 | 152.23 | 152.22 | 152.23 | 2000.0 |
| 2007-06-14 07:59:00 | SPY | ETF | 152.24 | 152.24 | 152.24 | 152.24 | 200.0 |
| 2007-06-14 08:00:00 | SPY | ETF | 152.28 | 152.3 | 151.94 | 151.94 | 451000.0 |
| 2007-06-14 08:01:00 | SPY | ETF | 152.32 | 152.32 | 152.32 | 152.32 | 2000.0 |
| 2007-06-14 08:02:00 | SPY | ETF | 152.27 | 152.32 | 152.27 | 152.32 | 12600.0 |
| 2007-06-14 08:03:00 | SPY | ETF | 152.31 | 152.32 | 152.3 | 152.3 | 2900.0 |
| 2007-06-14 08:04:00 | SPY | ETF | 152.28 | 152.33 | 152.27 | 152.33 | 22000.0 |
| 2007-06-14 08:05:00 | SPY | ETF | 152.32 | 152.33 | 152.32 | 152.33 | 11600.0 |
| 2007-06-14 08:06:00 | SPY | ETF | 152.31 | 152.31 | 152.31 | 152.31 | 100.0 |
| 2007-06-14 08:07:00 | SPY | ETF | 152.3 | 152.33 | 152.29 | 152.33 | 5400.0 |
> showing 50 of 42,386 rows — these rows as CSV