PREVIEW / etf_1min / 2011-08-24
file: by_date/etf_1min/2011/2011-08-24.parquet size: 2.2 MB rows: 112,682
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-24 04:00:00 | SPY | ETF | 115.45 | 115.45 | 114.99 | 114.99 | 2350.0 |
| 2011-08-24 04:01:00 | SPY | ETF | 115.12 | 115.12 | 115.05 | 115.05 | 12651.0 |
| 2011-08-24 04:02:00 | SPY | ETF | 115.12 | 115.12 | 115.12 | 115.12 | 100.0 |
| 2011-08-24 04:03:00 | SPY | ETF | 115.34 | 115.34 | 115.34 | 115.34 | 314.0 |
| 2011-08-24 04:04:00 | SPY | ETF | 115.3 | 115.3 | 115.3 | 115.3 | 100.0 |
| 2011-08-24 04:05:00 | SPY | ETF | 115.22 | 115.22 | 115.22 | 115.22 | 600.0 |
| 2011-08-24 04:06:00 | SPY | ETF | 115.4 | 115.4 | 115.4 | 115.4 | 100.0 |
| 2011-08-24 04:10:00 | SPY | ETF | 115.3 | 115.3 | 115.2 | 115.2 | 600.0 |
| 2011-08-24 04:15:00 | SPY | ETF | 115.39 | 115.39 | 115.39 | 115.39 | 100.0 |
| 2011-08-24 04:16:00 | SPY | ETF | 115.34 | 115.34 | 115.34 | 115.34 | 200.0 |
| 2011-08-24 04:20:00 | SPY | ETF | 115.67 | 115.67 | 115.67 | 115.67 | 200.0 |
| 2011-08-24 04:27:00 | SPY | ETF | 115.58 | 115.58 | 115.58 | 115.58 | 200.0 |
| 2011-08-24 04:35:00 | SPY | ETF | 115.5 | 115.5 | 115.5 | 115.5 | 200.0 |
| 2011-08-24 04:47:00 | SPY | ETF | 115.54 | 115.54 | 115.54 | 115.54 | 133.0 |
| 2011-08-24 05:00:00 | SPY | ETF | 115.46 | 115.46 | 115.46 | 115.46 | 200.0 |
| 2011-08-24 05:02:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 300.0 |
| 2011-08-24 05:05:00 | SPY | ETF | 115.63 | 115.63 | 115.63 | 115.63 | 100.0 |
| 2011-08-24 05:08:00 | SPY | ETF | 115.75 | 115.75 | 115.75 | 115.75 | 2000.0 |
| 2011-08-24 05:12:00 | SPY | ETF | 115.9 | 115.9 | 115.9 | 115.9 | 200.0 |
| 2011-08-24 05:13:00 | SPY | ETF | 115.87 | 115.87 | 115.81 | 115.81 | 600.0 |
| 2011-08-24 05:14:00 | SPY | ETF | 115.8 | 115.8 | 115.8 | 115.8 | 100.0 |
| 2011-08-24 05:16:00 | SPY | ETF | 115.82 | 115.82 | 115.8 | 115.8 | 1300.0 |
| 2011-08-24 05:21:00 | SPY | ETF | 115.78 | 115.78 | 115.78 | 115.78 | 100.0 |
| 2011-08-24 05:24:00 | SPY | ETF | 115.8 | 115.8 | 115.8 | 115.8 | 200.0 |
| 2011-08-24 05:32:00 | SPY | ETF | 115.79 | 115.79 | 115.79 | 115.79 | 500.0 |
| 2011-08-24 05:33:00 | SPY | ETF | 115.8 | 115.8 | 115.8 | 115.8 | 100.0 |
| 2011-08-24 05:35:00 | SPY | ETF | 115.83 | 115.83 | 115.83 | 115.83 | 100.0 |
| 2011-08-24 05:38:00 | SPY | ETF | 115.77 | 115.77 | 115.77 | 115.77 | 138.0 |
| 2011-08-24 05:41:00 | SPY | ETF | 115.71 | 115.71 | 115.71 | 115.71 | 100.0 |
| 2011-08-24 05:42:00 | SPY | ETF | 115.7 | 115.7 | 115.7 | 115.7 | 100.0 |
| 2011-08-24 05:43:00 | SPY | ETF | 115.71 | 115.71 | 115.71 | 115.71 | 100.0 |
| 2011-08-24 05:44:00 | SPY | ETF | 115.64 | 115.64 | 115.64 | 115.64 | 300.0 |
| 2011-08-24 05:45:00 | SPY | ETF | 115.5 | 115.5 | 115.5 | 115.5 | 200.0 |
| 2011-08-24 05:54:00 | SPY | ETF | 115.74 | 115.74 | 115.74 | 115.74 | 800.0 |
| 2011-08-24 06:07:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 200.0 |
| 2011-08-24 06:08:00 | SPY | ETF | 115.67 | 115.68 | 115.67 | 115.68 | 10000.0 |
| 2011-08-24 06:18:00 | SPY | ETF | 115.6 | 115.6 | 115.6 | 115.6 | 200.0 |
| 2011-08-24 06:20:00 | SPY | ETF | 115.59 | 115.59 | 115.59 | 115.59 | 5100.0 |
| 2011-08-24 06:21:00 | SPY | ETF | 115.51 | 115.51 | 115.51 | 115.51 | 150.0 |
| 2011-08-24 06:35:00 | SPY | ETF | 115.66 | 115.66 | 115.66 | 115.66 | 100.0 |
| 2011-08-24 06:36:00 | SPY | ETF | 115.57 | 115.57 | 115.57 | 115.57 | 100.0 |
| 2011-08-24 06:39:00 | SPY | ETF | 115.58 | 115.58 | 115.58 | 115.58 | 2500.0 |
| 2011-08-24 06:41:00 | SPY | ETF | 115.52 | 115.52 | 115.52 | 115.52 | 100.0 |
| 2011-08-24 06:43:00 | SPY | ETF | 115.59 | 115.59 | 115.45 | 115.45 | 4400.0 |
| 2011-08-24 06:45:00 | SPY | ETF | 115.49 | 115.54 | 115.49 | 115.54 | 1100.0 |
| 2011-08-24 06:46:00 | SPY | ETF | 115.48 | 115.48 | 115.41 | 115.41 | 5800.0 |
| 2011-08-24 06:47:00 | SPY | ETF | 115.41 | 115.41 | 115.32 | 115.33 | 2433.0 |
| 2011-08-24 06:48:00 | SPY | ETF | 115.3 | 115.3 | 115.25 | 115.29 | 2500.0 |
| 2011-08-24 06:50:00 | SPY | ETF | 115.34 | 115.34 | 115.34 | 115.34 | 100.0 |
| 2011-08-24 06:51:00 | SPY | ETF | 115.36 | 115.36 | 115.22 | 115.22 | 1800.0 |
> showing 50 of 112,682 rows — these rows as CSV