PREVIEW / etf_1min / 2013-07-25
file: by_date/etf_1min/2013/2013-07-25.parquet size: 2.1 MB rows: 108,256
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 |
|---|---|---|---|---|---|---|---|
| 2013-07-25 04:02:00 | SPY | ETF | 168.38 | 168.38 | 168.38 | 168.38 | 300.0 |
| 2013-07-25 04:04:00 | SPY | ETF | 168.38 | 168.38 | 168.38 | 168.38 | 600.0 |
| 2013-07-25 04:05:00 | SPY | ETF | 168.4 | 168.4 | 168.38 | 168.38 | 4000.0 |
| 2013-07-25 04:06:00 | SPY | ETF | 168.35 | 168.35 | 168.35 | 168.35 | 900.0 |
| 2013-07-25 04:15:00 | SPY | ETF | 168.4 | 168.4 | 168.4 | 168.4 | 200.0 |
| 2013-07-25 04:18:00 | SPY | ETF | 168.45 | 168.5 | 168.45 | 168.5 | 5400.0 |
| 2013-07-25 04:23:00 | SPY | ETF | 168.45 | 168.45 | 168.45 | 168.45 | 100.0 |
| 2013-07-25 04:24:00 | SPY | ETF | 168.4 | 168.4 | 168.4 | 168.4 | 600.0 |
| 2013-07-25 04:27:00 | SPY | ETF | 168.45 | 168.45 | 168.45 | 168.45 | 100.0 |
| 2013-07-25 04:28:00 | SPY | ETF | 168.35 | 168.4 | 168.35 | 168.4 | 400.0 |
| 2013-07-25 04:30:00 | SPY | ETF | 168.36 | 168.36 | 168.36 | 168.36 | 5000.0 |
| 2013-07-25 04:35:00 | SPY | ETF | 168.38 | 168.38 | 168.38 | 168.38 | 2500.0 |
| 2013-07-25 04:37:00 | SPY | ETF | 168.33 | 168.33 | 168.3 | 168.3 | 600.0 |
| 2013-07-25 04:40:00 | SPY | ETF | 168.27 | 168.28 | 168.27 | 168.28 | 200.0 |
| 2013-07-25 04:46:00 | SPY | ETF | 168.25 | 168.25 | 168.25 | 168.25 | 200.0 |
| 2013-07-25 04:47:00 | SPY | ETF | 168.25 | 168.25 | 168.25 | 168.25 | 100.0 |
| 2013-07-25 04:48:00 | SPY | ETF | 168.27 | 168.27 | 168.27 | 168.27 | 200.0 |
| 2013-07-25 04:49:00 | SPY | ETF | 168.25 | 168.25 | 168.23 | 168.23 | 300.0 |
| 2013-07-25 04:51:00 | SPY | ETF | 168.22 | 168.22 | 168.22 | 168.22 | 100.0 |
| 2013-07-25 04:53:00 | SPY | ETF | 168.2 | 168.2 | 168.07 | 168.07 | 2300.0 |
| 2013-07-25 04:54:00 | SPY | ETF | 168.08 | 168.08 | 168.08 | 168.08 | 200.0 |
| 2013-07-25 04:55:00 | SPY | ETF | 168.05 | 168.05 | 168.01 | 168.01 | 600.0 |
| 2013-07-25 04:56:00 | SPY | ETF | 168.03 | 168.03 | 168.03 | 168.03 | 200.0 |
| 2013-07-25 04:57:00 | SPY | ETF | 168.07 | 168.07 | 168.07 | 168.07 | 5100.0 |
| 2013-07-25 04:59:00 | SPY | ETF | 168.05 | 168.05 | 168.05 | 168.05 | 100.0 |
| 2013-07-25 05:00:00 | SPY | ETF | 168.04 | 168.04 | 168.04 | 168.04 | 20100.0 |
| 2013-07-25 05:04:00 | SPY | ETF | 168.1 | 168.1 | 168.1 | 168.1 | 400.0 |
| 2013-07-25 05:06:00 | SPY | ETF | 168.1 | 168.1 | 168.1 | 168.1 | 4700.0 |
| 2013-07-25 05:08:00 | SPY | ETF | 168.07 | 168.1 | 168.07 | 168.1 | 5100.0 |
| 2013-07-25 05:11:00 | SPY | ETF | 168.07 | 168.07 | 168.05 | 168.05 | 5500.0 |
| 2013-07-25 05:12:00 | SPY | ETF | 168.02 | 168.02 | 168.02 | 168.02 | 100.0 |
| 2013-07-25 05:13:00 | SPY | ETF | 168.02 | 168.02 | 168.02 | 168.02 | 100.0 |
| 2013-07-25 05:17:00 | SPY | ETF | 168.0 | 168.0 | 168.0 | 168.0 | 680.0 |
| 2013-07-25 05:18:00 | SPY | ETF | 167.97 | 167.97 | 167.8 | 167.8 | 21900.0 |
| 2013-07-25 05:19:00 | SPY | ETF | 167.79 | 167.85 | 167.79 | 167.82 | 700.0 |
| 2013-07-25 05:20:00 | SPY | ETF | 167.8 | 167.8 | 167.72 | 167.72 | 1100.0 |
| 2013-07-25 05:21:00 | SPY | ETF | 167.75 | 167.77 | 167.75 | 167.77 | 300.0 |
| 2013-07-25 05:23:00 | SPY | ETF | 167.75 | 167.75 | 167.75 | 167.75 | 100.0 |
| 2013-07-25 05:25:00 | SPY | ETF | 167.7 | 167.7 | 167.67 | 167.68 | 600.0 |
| 2013-07-25 05:26:00 | SPY | ETF | 167.65 | 167.65 | 167.65 | 167.65 | 200.0 |
| 2013-07-25 05:27:00 | SPY | ETF | 167.65 | 167.65 | 167.64 | 167.64 | 1400.0 |
| 2013-07-25 05:30:00 | SPY | ETF | 167.7 | 167.7 | 167.7 | 167.7 | 200.0 |
| 2013-07-25 05:31:00 | SPY | ETF | 167.75 | 167.82 | 167.75 | 167.82 | 47800.0 |
| 2013-07-25 05:32:00 | SPY | ETF | 167.84 | 167.84 | 167.83 | 167.84 | 7500.0 |
| 2013-07-25 05:33:00 | SPY | ETF | 167.85 | 167.85 | 167.85 | 167.85 | 500.0 |
| 2013-07-25 05:34:00 | SPY | ETF | 167.87 | 167.87 | 167.87 | 167.87 | 400.0 |
| 2013-07-25 05:36:00 | SPY | ETF | 167.87 | 167.87 | 167.87 | 167.87 | 400.0 |
| 2013-07-25 05:41:00 | SPY | ETF | 167.88 | 167.88 | 167.88 | 167.88 | 780.0 |
| 2013-07-25 05:42:00 | SPY | ETF | 167.85 | 167.85 | 167.85 | 167.85 | 700.0 |
| 2013-07-25 05:44:00 | SPY | ETF | 167.82 | 167.82 | 167.82 | 167.82 | 150.0 |
> showing 50 of 108,256 rows — these rows as CSV