PREVIEW / etf_1min / 2008-07-03
file: by_date/etf_1min/2008/2008-07-03.parquet size: 809 KB rows: 45,369
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-03 04:36:00 | SPY | ETF | 126.52 | 126.52 | 126.52 | 126.52 | 100.0 |
| 2008-07-03 04:54:00 | SPY | ETF | 126.5 | 126.5 | 126.5 | 126.5 | 100.0 |
| 2008-07-03 05:12:00 | SPY | ETF | 126.66 | 126.66 | 126.66 | 126.66 | 100.0 |
| 2008-07-03 05:16:00 | SPY | ETF | 126.67 | 126.67 | 126.67 | 126.67 | 600.0 |
| 2008-07-03 05:23:00 | SPY | ETF | 126.4 | 126.4 | 126.4 | 126.4 | 100.0 |
| 2008-07-03 06:05:00 | SPY | ETF | 126.2 | 126.2 | 126.2 | 126.2 | 100.0 |
| 2008-07-03 06:06:00 | SPY | ETF | 126.16 | 126.16 | 126.14 | 126.14 | 2000.0 |
| 2008-07-03 06:20:00 | SPY | ETF | 126.23 | 126.23 | 126.23 | 126.23 | 100.0 |
| 2008-07-03 06:53:00 | SPY | ETF | 126.21 | 126.21 | 126.21 | 126.21 | 2500.0 |
| 2008-07-03 06:55:00 | SPY | ETF | 126.12 | 126.12 | 126.12 | 126.12 | 500.0 |
| 2008-07-03 06:59:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 10000.0 |
| 2008-07-03 07:00:00 | SPY | ETF | 126.12 | 126.12 | 126.12 | 126.12 | 100.0 |
| 2008-07-03 07:02:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 5100.0 |
| 2008-07-03 07:05:00 | SPY | ETF | 126.03 | 126.03 | 126.0 | 126.0 | 20000.0 |
| 2008-07-03 07:06:00 | SPY | ETF | 126.0 | 126.02 | 125.99 | 125.99 | 17305.0 |
| 2008-07-03 07:07:00 | SPY | ETF | 125.98 | 125.98 | 125.95 | 125.96 | 10800.0 |
| 2008-07-03 07:08:00 | SPY | ETF | 125.95 | 126.05 | 125.95 | 126.02 | 20100.0 |
| 2008-07-03 07:09:00 | SPY | ETF | 125.98 | 126.0 | 125.97 | 126.0 | 5200.0 |
| 2008-07-03 07:10:00 | SPY | ETF | 126.0 | 126.0 | 126.0 | 126.0 | 10000.0 |
| 2008-07-03 07:11:00 | SPY | ETF | 126.0 | 126.0 | 126.0 | 126.0 | 33300.0 |
| 2008-07-03 07:12:00 | SPY | ETF | 126.0 | 126.01 | 126.0 | 126.0 | 84700.0 |
| 2008-07-03 07:13:00 | SPY | ETF | 126.05 | 126.05 | 126.05 | 126.05 | 500.0 |
| 2008-07-03 07:14:00 | SPY | ETF | 126.1 | 126.11 | 126.1 | 126.11 | 27000.0 |
| 2008-07-03 07:15:00 | SPY | ETF | 126.07 | 126.21 | 126.07 | 126.21 | 1700.0 |
| 2008-07-03 07:16:00 | SPY | ETF | 126.16 | 126.16 | 126.16 | 126.16 | 200.0 |
| 2008-07-03 07:17:00 | SPY | ETF | 126.19 | 126.19 | 126.16 | 126.19 | 5394.0 |
| 2008-07-03 07:18:00 | SPY | ETF | 126.19 | 126.19 | 126.19 | 126.19 | 1694.0 |
| 2008-07-03 07:19:00 | SPY | ETF | 126.15 | 126.15 | 126.15 | 126.15 | 100.0 |
| 2008-07-03 07:21:00 | SPY | ETF | 126.13 | 126.13 | 126.13 | 126.13 | 400.0 |
| 2008-07-03 07:22:00 | SPY | ETF | 126.21 | 126.21 | 126.2 | 126.2 | 25000.0 |
| 2008-07-03 07:23:00 | SPY | ETF | 126.22 | 126.24 | 126.2 | 126.2 | 25318.0 |
| 2008-07-03 07:24:00 | SPY | ETF | 126.18 | 126.19 | 126.18 | 126.18 | 20000.0 |
| 2008-07-03 07:26:00 | SPY | ETF | 126.21 | 126.26 | 126.21 | 126.26 | 1600.0 |
| 2008-07-03 07:27:00 | SPY | ETF | 126.22 | 126.22 | 126.22 | 126.22 | 100.0 |
| 2008-07-03 07:28:00 | SPY | ETF | 126.21 | 126.21 | 126.21 | 126.21 | 1850.0 |
| 2008-07-03 07:29:00 | SPY | ETF | 126.23 | 126.23 | 126.23 | 126.23 | 500.0 |
| 2008-07-03 07:31:00 | SPY | ETF | 126.2 | 126.2 | 126.2 | 126.2 | 100.0 |
| 2008-07-03 07:32:00 | SPY | ETF | 126.19 | 126.19 | 126.18 | 126.18 | 55000.0 |
| 2008-07-03 07:34:00 | SPY | ETF | 126.16 | 126.16 | 126.15 | 126.15 | 24950.0 |
| 2008-07-03 07:36:00 | SPY | ETF | 126.08 | 126.08 | 126.08 | 126.08 | 100.0 |
| 2008-07-03 07:37:00 | SPY | ETF | 126.1 | 126.1 | 126.08 | 126.08 | 11000.0 |
| 2008-07-03 07:38:00 | SPY | ETF | 126.1 | 126.1 | 126.1 | 126.1 | 5200.0 |
| 2008-07-03 07:39:00 | SPY | ETF | 126.08 | 126.1 | 126.08 | 126.1 | 3300.0 |
| 2008-07-03 07:40:00 | SPY | ETF | 126.1 | 126.12 | 126.08 | 126.08 | 8992.0 |
| 2008-07-03 07:42:00 | SPY | ETF | 126.19 | 126.25 | 126.19 | 126.25 | 18500.0 |
| 2008-07-03 07:43:00 | SPY | ETF | 126.25 | 126.32 | 126.25 | 126.32 | 20900.0 |
| 2008-07-03 07:44:00 | SPY | ETF | 126.29 | 126.33 | 126.28 | 126.29 | 43800.0 |
| 2008-07-03 07:45:00 | SPY | ETF | 126.26 | 126.39 | 126.17 | 126.29 | 70900.0 |
| 2008-07-03 07:46:00 | SPY | ETF | 126.19 | 126.22 | 126.11 | 126.11 | 8300.0 |
| 2008-07-03 07:47:00 | SPY | ETF | 126.11 | 126.11 | 125.88 | 126.02 | 142100.0 |
> showing 50 of 45,369 rows — these rows as CSV