PREVIEW / etf_1min / 2011-08-16
file: by_date/etf_1min/2011/2011-08-16.parquet size: 2.2 MB rows: 119,751
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-16 04:00:00 | SPY | ETF | 119.76 | 119.76 | 119.44 | 119.44 | 2800.0 |
| 2011-08-16 04:02:00 | SPY | ETF | 119.46 | 119.46 | 119.41 | 119.44 | 2500.0 |
| 2011-08-16 04:03:00 | SPY | ETF | 119.44 | 119.44 | 119.38 | 119.38 | 835.0 |
| 2011-08-16 04:04:00 | SPY | ETF | 119.35 | 119.35 | 119.26 | 119.26 | 700.0 |
| 2011-08-16 04:05:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 4950.0 |
| 2011-08-16 04:06:00 | SPY | ETF | 119.13 | 119.13 | 119.13 | 119.13 | 100.0 |
| 2011-08-16 04:12:00 | SPY | ETF | 119.09 | 119.09 | 119.09 | 119.09 | 250.0 |
| 2011-08-16 04:13:00 | SPY | ETF | 119.02 | 119.02 | 119.01 | 119.01 | 300.0 |
| 2011-08-16 04:14:00 | SPY | ETF | 119.01 | 119.01 | 119.01 | 119.01 | 100.0 |
| 2011-08-16 04:15:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 100.0 |
| 2011-08-16 04:17:00 | SPY | ETF | 118.95 | 118.95 | 118.94 | 118.94 | 200.0 |
| 2011-08-16 04:23:00 | SPY | ETF | 118.9 | 118.9 | 118.9 | 118.9 | 100.0 |
| 2011-08-16 04:29:00 | SPY | ETF | 118.8 | 118.8 | 118.8 | 118.8 | 100.0 |
| 2011-08-16 04:31:00 | SPY | ETF | 118.8 | 118.85 | 118.78 | 118.85 | 7700.0 |
| 2011-08-16 04:32:00 | SPY | ETF | 118.83 | 118.83 | 118.83 | 118.83 | 1200.0 |
| 2011-08-16 04:35:00 | SPY | ETF | 118.92 | 118.97 | 118.92 | 118.97 | 300.0 |
| 2011-08-16 04:36:00 | SPY | ETF | 119.02 | 119.02 | 119.02 | 119.02 | 1000.0 |
| 2011-08-16 04:37:00 | SPY | ETF | 118.86 | 118.86 | 118.84 | 118.84 | 1300.0 |
| 2011-08-16 04:42:00 | SPY | ETF | 118.84 | 118.84 | 118.84 | 118.84 | 100.0 |
| 2011-08-16 04:47:00 | SPY | ETF | 118.91 | 118.91 | 118.91 | 118.91 | 2400.0 |
| 2011-08-16 04:58:00 | SPY | ETF | 118.85 | 118.85 | 118.85 | 118.85 | 600.0 |
| 2011-08-16 05:02:00 | SPY | ETF | 118.95 | 118.95 | 118.95 | 118.95 | 100.0 |
| 2011-08-16 05:10:00 | SPY | ETF | 119.06 | 119.08 | 119.06 | 119.08 | 900.0 |
| 2011-08-16 05:12:00 | SPY | ETF | 119.16 | 119.16 | 119.14 | 119.14 | 700.0 |
| 2011-08-16 05:20:00 | SPY | ETF | 119.16 | 119.16 | 119.16 | 119.16 | 3000.0 |
| 2011-08-16 05:21:00 | SPY | ETF | 119.04 | 119.04 | 119.04 | 119.04 | 400.0 |
| 2011-08-16 05:30:00 | SPY | ETF | 119.06 | 119.06 | 119.04 | 119.04 | 700.0 |
| 2011-08-16 05:34:00 | SPY | ETF | 118.92 | 118.92 | 118.92 | 118.92 | 7865.0 |
| 2011-08-16 05:38:00 | SPY | ETF | 119.25 | 119.25 | 119.25 | 119.25 | 10000.0 |
| 2011-08-16 05:39:00 | SPY | ETF | 119.26 | 119.26 | 119.25 | 119.25 | 5100.0 |
| 2011-08-16 05:44:00 | SPY | ETF | 119.2 | 119.2 | 119.2 | 119.2 | 200.0 |
| 2011-08-16 05:45:00 | SPY | ETF | 119.26 | 119.26 | 119.26 | 119.26 | 600.0 |
| 2011-08-16 05:47:00 | SPY | ETF | 119.14 | 119.14 | 119.14 | 119.14 | 5000.0 |
| 2011-08-16 05:48:00 | SPY | ETF | 119.21 | 119.23 | 119.21 | 119.23 | 3900.0 |
| 2011-08-16 05:57:00 | SPY | ETF | 119.17 | 119.17 | 119.17 | 119.17 | 5000.0 |
| 2011-08-16 06:00:00 | SPY | ETF | 119.16 | 119.16 | 119.12 | 119.12 | 7400.0 |
| 2011-08-16 06:01:00 | SPY | ETF | 119.12 | 119.12 | 119.12 | 119.12 | 3500.0 |
| 2011-08-16 06:12:00 | SPY | ETF | 119.08 | 119.11 | 119.08 | 119.11 | 200.0 |
| 2011-08-16 06:19:00 | SPY | ETF | 119.11 | 119.11 | 119.1 | 119.1 | 10150.0 |
| 2011-08-16 06:23:00 | SPY | ETF | 119.1 | 119.1 | 119.1 | 119.1 | 5100.0 |
| 2011-08-16 06:26:00 | SPY | ETF | 119.07 | 119.07 | 119.07 | 119.07 | 100.0 |
| 2011-08-16 06:29:00 | SPY | ETF | 119.12 | 119.12 | 119.12 | 119.12 | 300.0 |
| 2011-08-16 06:30:00 | SPY | ETF | 119.12 | 119.12 | 119.12 | 119.12 | 100.0 |
| 2011-08-16 06:31:00 | SPY | ETF | 119.14 | 119.16 | 119.14 | 119.16 | 500.0 |
| 2011-08-16 06:33:00 | SPY | ETF | 119.06 | 119.06 | 118.94 | 118.94 | 760.0 |
| 2011-08-16 06:34:00 | SPY | ETF | 118.91 | 118.91 | 118.91 | 118.91 | 100.0 |
| 2011-08-16 06:35:00 | SPY | ETF | 118.96 | 118.96 | 118.94 | 118.94 | 5000.0 |
| 2011-08-16 06:36:00 | SPY | ETF | 119.0 | 119.0 | 119.0 | 119.0 | 100.0 |
| 2011-08-16 06:37:00 | SPY | ETF | 118.99 | 118.99 | 118.96 | 118.96 | 49900.0 |
| 2011-08-16 06:38:00 | SPY | ETF | 118.89 | 118.89 | 118.89 | 118.89 | 1500.0 |
> showing 50 of 119,751 rows — these rows as CSV