PREVIEW / etf_1min / 2014-12-18
file: by_date/etf_1min/2014/2014-12-18.parquet size: 2.8 MB rows: 147,030
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 |
|---|---|---|---|---|---|---|---|
| 2014-12-18 04:00:00 | SPY | ETF | 202.59 | 203.03 | 202.59 | 203.03 | 793.0 |
| 2014-12-18 04:02:00 | SPY | ETF | 203.31 | 203.43 | 203.31 | 203.43 | 4500.0 |
| 2014-12-18 04:03:00 | SPY | ETF | 203.37 | 203.43 | 203.37 | 203.43 | 3250.0 |
| 2014-12-18 04:04:00 | SPY | ETF | 203.3 | 203.45 | 203.3 | 203.38 | 10658.0 |
| 2014-12-18 04:05:00 | SPY | ETF | 203.41 | 203.41 | 203.41 | 203.41 | 500.0 |
| 2014-12-18 04:08:00 | SPY | ETF | 203.47 | 203.47 | 203.41 | 203.47 | 15525.0 |
| 2014-12-18 04:09:00 | SPY | ETF | 203.5 | 203.72 | 203.5 | 203.72 | 4285.0 |
| 2014-12-18 04:10:00 | SPY | ETF | 203.58 | 203.62 | 203.58 | 203.62 | 1000.0 |
| 2014-12-18 04:12:00 | SPY | ETF | 203.5 | 203.52 | 203.5 | 203.52 | 10200.0 |
| 2014-12-18 04:19:00 | SPY | ETF | 203.52 | 203.52 | 203.52 | 203.52 | 100.0 |
| 2014-12-18 04:20:00 | SPY | ETF | 203.55 | 203.55 | 203.55 | 203.55 | 200.0 |
| 2014-12-18 04:22:00 | SPY | ETF | 203.52 | 203.52 | 203.5 | 203.5 | 10200.0 |
| 2014-12-18 04:28:00 | SPY | ETF | 203.6 | 203.63 | 203.58 | 203.63 | 15900.0 |
| 2014-12-18 04:29:00 | SPY | ETF | 203.58 | 203.75 | 203.58 | 203.75 | 12225.0 |
| 2014-12-18 04:30:00 | SPY | ETF | 203.77 | 204.0 | 203.77 | 203.97 | 3925.0 |
| 2014-12-18 04:31:00 | SPY | ETF | 204.01 | 204.01 | 204.01 | 204.01 | 525.0 |
| 2014-12-18 04:32:00 | SPY | ETF | 204.03 | 204.03 | 204.0 | 204.02 | 6550.0 |
| 2014-12-18 04:33:00 | SPY | ETF | 204.05 | 204.1 | 204.05 | 204.1 | 880.0 |
| 2014-12-18 04:34:00 | SPY | ETF | 204.03 | 204.1 | 204.03 | 204.1 | 1110.0 |
| 2014-12-18 04:35:00 | SPY | ETF | 204.07 | 204.08 | 204.07 | 204.08 | 1025.0 |
| 2014-12-18 04:36:00 | SPY | ETF | 204.0 | 204.04 | 204.0 | 204.04 | 26040.0 |
| 2014-12-18 04:37:00 | SPY | ETF | 204.02 | 204.17 | 204.02 | 204.17 | 1400.0 |
| 2014-12-18 04:38:00 | SPY | ETF | 203.97 | 203.97 | 203.97 | 203.97 | 1075.0 |
| 2014-12-18 04:39:00 | SPY | ETF | 203.81 | 203.81 | 203.81 | 203.81 | 425.0 |
| 2014-12-18 04:40:00 | SPY | ETF | 203.8 | 203.8 | 203.8 | 203.8 | 1050.0 |
| 2014-12-18 04:41:00 | SPY | ETF | 203.82 | 203.82 | 203.82 | 203.82 | 200.0 |
| 2014-12-18 04:43:00 | SPY | ETF | 203.79 | 203.79 | 203.78 | 203.78 | 350.0 |
| 2014-12-18 04:44:00 | SPY | ETF | 203.85 | 203.85 | 203.85 | 203.85 | 500.0 |
| 2014-12-18 04:46:00 | SPY | ETF | 203.92 | 203.92 | 203.85 | 203.85 | 700.0 |
| 2014-12-18 04:47:00 | SPY | ETF | 203.82 | 203.82 | 203.79 | 203.82 | 3525.0 |
| 2014-12-18 04:49:00 | SPY | ETF | 203.78 | 203.78 | 203.78 | 203.78 | 250.0 |
| 2014-12-18 04:50:00 | SPY | ETF | 203.82 | 203.82 | 203.82 | 203.82 | 2220.0 |
| 2014-12-18 04:51:00 | SPY | ETF | 203.77 | 203.77 | 203.68 | 203.7 | 5102.0 |
| 2014-12-18 04:52:00 | SPY | ETF | 203.73 | 203.75 | 203.73 | 203.75 | 1400.0 |
| 2014-12-18 04:53:00 | SPY | ETF | 203.81 | 203.81 | 203.81 | 203.81 | 502.0 |
| 2014-12-18 04:54:00 | SPY | ETF | 203.64 | 203.65 | 203.6 | 203.6 | 1725.0 |
| 2014-12-18 05:00:00 | SPY | ETF | 203.8 | 203.8 | 203.8 | 203.8 | 380.0 |
| 2014-12-18 05:05:00 | SPY | ETF | 203.86 | 203.87 | 203.85 | 203.87 | 402.0 |
| 2014-12-18 05:06:00 | SPY | ETF | 203.89 | 203.89 | 203.89 | 203.89 | 100.0 |
| 2014-12-18 05:07:00 | SPY | ETF | 203.95 | 203.99 | 203.95 | 203.97 | 1602.0 |
| 2014-12-18 05:09:00 | SPY | ETF | 204.0 | 204.0 | 203.98 | 204.0 | 770.0 |
| 2014-12-18 05:10:00 | SPY | ETF | 204.06 | 204.1 | 204.06 | 204.1 | 490.0 |
| 2014-12-18 05:11:00 | SPY | ETF | 204.01 | 204.06 | 204.01 | 204.06 | 2000.0 |
| 2014-12-18 05:12:00 | SPY | ETF | 204.07 | 204.09 | 204.07 | 204.09 | 1800.0 |
| 2014-12-18 05:13:00 | SPY | ETF | 204.11 | 204.14 | 204.05 | 204.05 | 4100.0 |
| 2014-12-18 05:14:00 | SPY | ETF | 204.04 | 204.05 | 204.04 | 204.05 | 600.0 |
| 2014-12-18 05:16:00 | SPY | ETF | 204.1 | 204.15 | 204.1 | 204.15 | 1500.0 |
| 2014-12-18 05:17:00 | SPY | ETF | 204.16 | 204.21 | 204.16 | 204.17 | 1750.0 |
| 2014-12-18 05:18:00 | SPY | ETF | 204.26 | 204.61 | 204.26 | 204.5 | 65685.0 |
| 2014-12-18 05:19:00 | SPY | ETF | 204.51 | 204.51 | 204.49 | 204.49 | 9332.0 |
> showing 50 of 147,030 rows — these rows as CSV