PREVIEW / etf_1min / 2011-08-26
file: by_date/etf_1min/2011/2011-08-26.parquet size: 2.1 MB rows: 107,808
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 |
|---|---|---|---|---|---|---|---|
| 2011-08-26 04:12:00 | SPY | ETF | 116.4 | 116.4 | 116.4 | 116.4 | 400.0 |
| 2011-08-26 04:28:00 | SPY | ETF | 116.43 | 116.43 | 116.43 | 116.43 | 200.0 |
| 2011-08-26 04:31:00 | SPY | ETF | 116.65 | 116.65 | 116.65 | 116.65 | 5000.0 |
| 2011-08-26 04:32:00 | SPY | ETF | 116.72 | 116.72 | 116.72 | 116.72 | 100.0 |
| 2011-08-26 04:51:00 | SPY | ETF | 116.53 | 116.53 | 116.53 | 116.53 | 4000.0 |
| 2011-08-26 04:53:00 | SPY | ETF | 116.38 | 116.38 | 116.38 | 116.38 | 500.0 |
| 2011-08-26 04:55:00 | SPY | ETF | 116.41 | 116.41 | 116.41 | 116.41 | 500.0 |
| 2011-08-26 05:22:00 | SPY | ETF | 116.47 | 116.47 | 116.47 | 116.47 | 200.0 |
| 2011-08-26 05:32:00 | SPY | ETF | 116.56 | 116.56 | 116.56 | 116.56 | 400.0 |
| 2011-08-26 05:43:00 | SPY | ETF | 116.55 | 116.55 | 116.55 | 116.55 | 600.0 |
| 2011-08-26 05:48:00 | SPY | ETF | 116.58 | 116.63 | 116.58 | 116.63 | 600.0 |
| 2011-08-26 05:51:00 | SPY | ETF | 116.56 | 116.56 | 116.56 | 116.56 | 300.0 |
| 2011-08-26 05:55:00 | SPY | ETF | 116.53 | 116.53 | 116.45 | 116.45 | 600.0 |
| 2011-08-26 05:56:00 | SPY | ETF | 116.43 | 116.43 | 116.43 | 116.43 | 100.0 |
| 2011-08-26 06:00:00 | SPY | ETF | 116.41 | 116.41 | 116.41 | 116.41 | 100.0 |
| 2011-08-26 06:13:00 | SPY | ETF | 116.36 | 116.36 | 116.36 | 116.36 | 3000.0 |
| 2011-08-26 06:28:00 | SPY | ETF | 116.26 | 116.26 | 116.26 | 116.26 | 100.0 |
| 2011-08-26 06:36:00 | SPY | ETF | 116.26 | 116.26 | 116.26 | 116.26 | 300.0 |
| 2011-08-26 06:42:00 | SPY | ETF | 116.35 | 116.35 | 116.35 | 116.35 | 100.0 |
| 2011-08-26 06:45:00 | SPY | ETF | 116.43 | 116.43 | 116.43 | 116.43 | 100.0 |
| 2011-08-26 06:47:00 | SPY | ETF | 116.4 | 116.46 | 116.4 | 116.4 | 500.0 |
| 2011-08-26 06:49:00 | SPY | ETF | 116.37 | 116.4 | 116.37 | 116.4 | 1600.0 |
| 2011-08-26 06:58:00 | SPY | ETF | 116.35 | 116.35 | 116.35 | 116.35 | 300.0 |
| 2011-08-26 06:59:00 | SPY | ETF | 116.37 | 116.37 | 116.37 | 116.37 | 200.0 |
| 2011-08-26 07:00:00 | SPY | ETF | 116.4 | 116.42 | 116.4 | 116.42 | 1600.0 |
| 2011-08-26 07:01:00 | SPY | ETF | 116.42 | 116.42 | 116.4 | 116.4 | 700.0 |
| 2011-08-26 07:02:00 | SPY | ETF | 116.35 | 116.35 | 116.33 | 116.33 | 1838.0 |
| 2011-08-26 07:03:00 | SPY | ETF | 116.31 | 116.31 | 116.29 | 116.29 | 600.0 |
| 2011-08-26 07:04:00 | SPY | ETF | 116.26 | 116.26 | 116.26 | 116.26 | 1000.0 |
| 2011-08-26 07:05:00 | SPY | ETF | 116.29 | 116.32 | 116.29 | 116.3 | 2200.0 |
| 2011-08-26 07:06:00 | SPY | ETF | 116.32 | 116.32 | 116.32 | 116.32 | 100.0 |
| 2011-08-26 07:07:00 | SPY | ETF | 116.34 | 116.37 | 116.34 | 116.37 | 10300.0 |
| 2011-08-26 07:08:00 | SPY | ETF | 116.38 | 116.38 | 116.38 | 116.38 | 300.0 |
| 2011-08-26 07:11:00 | SPY | ETF | 116.35 | 116.35 | 116.33 | 116.33 | 700.0 |
| 2011-08-26 07:12:00 | SPY | ETF | 116.3 | 116.32 | 116.3 | 116.32 | 300.0 |
| 2011-08-26 07:13:00 | SPY | ETF | 116.31 | 116.31 | 116.25 | 116.25 | 1032.0 |
| 2011-08-26 07:14:00 | SPY | ETF | 116.23 | 116.23 | 116.23 | 116.23 | 1600.0 |
| 2011-08-26 07:16:00 | SPY | ETF | 116.24 | 116.24 | 116.24 | 116.24 | 9000.0 |
| 2011-08-26 07:17:00 | SPY | ETF | 116.26 | 116.26 | 116.26 | 116.26 | 1500.0 |
| 2011-08-26 07:19:00 | SPY | ETF | 116.12 | 116.12 | 116.06 | 116.08 | 15100.0 |
| 2011-08-26 07:20:00 | SPY | ETF | 116.12 | 116.12 | 116.12 | 116.12 | 100.0 |
| 2011-08-26 07:21:00 | SPY | ETF | 116.13 | 116.13 | 116.13 | 116.13 | 15000.0 |
| 2011-08-26 07:23:00 | SPY | ETF | 116.13 | 116.13 | 116.13 | 116.13 | 5535.0 |
| 2011-08-26 07:25:00 | SPY | ETF | 116.11 | 116.11 | 116.07 | 116.07 | 3200.0 |
| 2011-08-26 07:26:00 | SPY | ETF | 116.08 | 116.14 | 116.08 | 116.14 | 16090.0 |
| 2011-08-26 07:27:00 | SPY | ETF | 116.17 | 116.21 | 116.17 | 116.18 | 50300.0 |
| 2011-08-26 07:29:00 | SPY | ETF | 116.19 | 116.19 | 116.16 | 116.19 | 42430.0 |
| 2011-08-26 07:30:00 | SPY | ETF | 116.16 | 116.16 | 116.06 | 116.09 | 2600.0 |
| 2011-08-26 07:31:00 | SPY | ETF | 116.09 | 116.09 | 116.09 | 116.09 | 500.0 |
| 2011-08-26 07:32:00 | SPY | ETF | 116.0 | 116.0 | 116.0 | 116.0 | 5900.0 |
> showing 50 of 107,808 rows — these rows as CSV