PREVIEW / etf_1min / 2014-10-21
file: by_date/etf_1min/2014/2014-10-21.parquet size: 2.7 MB rows: 137,952
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-10-21 04:00:00 | SPY | ETF | 190.36 | 190.36 | 190.36 | 190.36 | 210.0 |
| 2014-10-21 04:01:00 | SPY | ETF | 190.41 | 190.63 | 190.41 | 190.63 | 703.0 |
| 2014-10-21 04:03:00 | SPY | ETF | 190.5 | 190.5 | 190.5 | 190.5 | 200.0 |
| 2014-10-21 04:05:00 | SPY | ETF | 190.46 | 190.46 | 190.46 | 190.46 | 400.0 |
| 2014-10-21 04:09:00 | SPY | ETF | 190.47 | 190.47 | 190.47 | 190.47 | 100.0 |
| 2014-10-21 04:10:00 | SPY | ETF | 190.54 | 190.54 | 190.54 | 190.54 | 150.0 |
| 2014-10-21 04:11:00 | SPY | ETF | 190.5 | 190.5 | 190.47 | 190.47 | 200.0 |
| 2014-10-21 04:12:00 | SPY | ETF | 190.46 | 190.46 | 190.46 | 190.46 | 200.0 |
| 2014-10-21 04:15:00 | SPY | ETF | 190.42 | 190.42 | 190.42 | 190.42 | 100.0 |
| 2014-10-21 04:25:00 | SPY | ETF | 190.4 | 190.4 | 190.4 | 190.4 | 200.0 |
| 2014-10-21 04:26:00 | SPY | ETF | 190.45 | 190.49 | 190.44 | 190.49 | 949.0 |
| 2014-10-21 04:31:00 | SPY | ETF | 190.56 | 190.56 | 190.56 | 190.56 | 1901.0 |
| 2014-10-21 04:39:00 | SPY | ETF | 190.61 | 190.61 | 190.61 | 190.61 | 379.0 |
| 2014-10-21 04:44:00 | SPY | ETF | 190.58 | 190.58 | 190.58 | 190.58 | 165.0 |
| 2014-10-21 04:46:00 | SPY | ETF | 190.6 | 190.62 | 190.6 | 190.62 | 250.0 |
| 2014-10-21 04:48:00 | SPY | ETF | 190.75 | 190.75 | 190.75 | 190.75 | 200.0 |
| 2014-10-21 04:49:00 | SPY | ETF | 190.78 | 190.78 | 190.78 | 190.78 | 100.0 |
| 2014-10-21 04:50:00 | SPY | ETF | 190.75 | 190.75 | 190.75 | 190.75 | 1000.0 |
| 2014-10-21 04:51:00 | SPY | ETF | 190.75 | 190.75 | 190.75 | 190.75 | 149.0 |
| 2014-10-21 04:54:00 | SPY | ETF | 190.81 | 190.81 | 190.78 | 190.78 | 3101.0 |
| 2014-10-21 04:56:00 | SPY | ETF | 190.8 | 190.8 | 190.8 | 190.8 | 200.0 |
| 2014-10-21 04:58:00 | SPY | ETF | 190.78 | 190.78 | 190.73 | 190.73 | 2196.0 |
| 2014-10-21 04:59:00 | SPY | ETF | 190.78 | 190.78 | 190.78 | 190.78 | 244.0 |
| 2014-10-21 05:01:00 | SPY | ETF | 190.7 | 190.72 | 190.7 | 190.72 | 5600.0 |
| 2014-10-21 05:02:00 | SPY | ETF | 190.69 | 190.7 | 190.69 | 190.7 | 3227.0 |
| 2014-10-21 05:03:00 | SPY | ETF | 190.67 | 190.67 | 190.67 | 190.67 | 600.0 |
| 2014-10-21 05:04:00 | SPY | ETF | 190.69 | 190.69 | 190.69 | 190.69 | 100.0 |
| 2014-10-21 05:05:00 | SPY | ETF | 190.7 | 190.72 | 190.7 | 190.72 | 1504.0 |
| 2014-10-21 05:09:00 | SPY | ETF | 190.65 | 190.65 | 190.65 | 190.65 | 100.0 |
| 2014-10-21 05:10:00 | SPY | ETF | 190.64 | 190.64 | 190.64 | 190.64 | 100.0 |
| 2014-10-21 05:17:00 | SPY | ETF | 190.58 | 190.58 | 190.58 | 190.58 | 170.0 |
| 2014-10-21 05:21:00 | SPY | ETF | 190.5 | 190.5 | 190.5 | 190.5 | 1000.0 |
| 2014-10-21 05:22:00 | SPY | ETF | 190.5 | 190.5 | 190.5 | 190.5 | 2050.0 |
| 2014-10-21 05:25:00 | SPY | ETF | 190.45 | 190.48 | 190.45 | 190.48 | 620.0 |
| 2014-10-21 05:26:00 | SPY | ETF | 190.48 | 190.48 | 190.48 | 190.48 | 4000.0 |
| 2014-10-21 05:29:00 | SPY | ETF | 190.6 | 190.6 | 190.6 | 190.6 | 2500.0 |
| 2014-10-21 05:30:00 | SPY | ETF | 190.69 | 190.7 | 190.69 | 190.7 | 1115.0 |
| 2014-10-21 05:31:00 | SPY | ETF | 190.8 | 190.8 | 190.77 | 190.8 | 622.0 |
| 2014-10-21 05:32:00 | SPY | ETF | 190.85 | 190.99 | 190.84 | 190.84 | 2471.0 |
| 2014-10-21 05:33:00 | SPY | ETF | 190.85 | 190.85 | 190.78 | 190.78 | 5100.0 |
| 2014-10-21 05:35:00 | SPY | ETF | 190.85 | 190.85 | 190.85 | 190.85 | 239.0 |
| 2014-10-21 05:36:00 | SPY | ETF | 190.83 | 190.83 | 190.83 | 190.83 | 249.0 |
| 2014-10-21 05:38:00 | SPY | ETF | 190.8 | 190.8 | 190.8 | 190.8 | 100.0 |
| 2014-10-21 05:39:00 | SPY | ETF | 190.9 | 190.93 | 190.9 | 190.92 | 700.0 |
| 2014-10-21 05:41:00 | SPY | ETF | 190.92 | 190.99 | 190.92 | 190.98 | 7598.0 |
| 2014-10-21 05:42:00 | SPY | ETF | 191.05 | 191.14 | 191.05 | 191.14 | 875.0 |
| 2014-10-21 05:43:00 | SPY | ETF | 191.15 | 191.16 | 191.15 | 191.16 | 1500.0 |
| 2014-10-21 05:44:00 | SPY | ETF | 191.17 | 191.23 | 191.14 | 191.23 | 1087.0 |
| 2014-10-21 05:45:00 | SPY | ETF | 191.17 | 191.17 | 191.17 | 191.17 | 2043.0 |
| 2014-10-21 05:46:00 | SPY | ETF | 191.19 | 191.19 | 191.19 | 191.19 | 200.0 |
> showing 50 of 137,952 rows — these rows as CSV