PREVIEW / etf_1min / 2014-02-07
file: by_date/etf_1min/2014/2014-02-07.parquet size: 2.4 MB rows: 120,606
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-02-07 04:01:00 | SPY | ETF | 177.47 | 177.47 | 177.47 | 177.47 | 140.0 |
| 2014-02-07 04:05:00 | SPY | ETF | 177.5 | 177.5 | 177.5 | 177.5 | 139.0 |
| 2014-02-07 04:07:00 | SPY | ETF | 177.46 | 177.46 | 177.46 | 177.46 | 280.0 |
| 2014-02-07 04:08:00 | SPY | ETF | 177.49 | 177.49 | 177.49 | 177.49 | 220.0 |
| 2014-02-07 04:11:00 | SPY | ETF | 177.47 | 177.47 | 177.47 | 177.47 | 500.0 |
| 2014-02-07 04:12:00 | SPY | ETF | 177.49 | 177.49 | 177.49 | 177.49 | 180.0 |
| 2014-02-07 04:13:00 | SPY | ETF | 177.49 | 177.49 | 177.49 | 177.49 | 320.0 |
| 2014-02-07 04:14:00 | SPY | ETF | 177.49 | 177.5 | 177.49 | 177.5 | 1501.0 |
| 2014-02-07 04:17:00 | SPY | ETF | 177.5 | 177.5 | 177.5 | 177.5 | 500.0 |
| 2014-02-07 04:18:00 | SPY | ETF | 177.5 | 177.5 | 177.5 | 177.5 | 500.0 |
| 2014-02-07 04:19:00 | SPY | ETF | 177.51 | 177.51 | 177.51 | 177.51 | 500.0 |
| 2014-02-07 04:20:00 | SPY | ETF | 177.5 | 177.5 | 177.5 | 177.5 | 500.0 |
| 2014-02-07 04:21:00 | SPY | ETF | 177.52 | 177.6 | 177.52 | 177.6 | 14500.0 |
| 2014-02-07 04:22:00 | SPY | ETF | 177.6 | 177.62 | 177.6 | 177.62 | 1200.0 |
| 2014-02-07 04:23:00 | SPY | ETF | 177.62 | 177.62 | 177.62 | 177.62 | 600.0 |
| 2014-02-07 04:25:00 | SPY | ETF | 177.62 | 177.62 | 177.62 | 177.62 | 520.0 |
| 2014-02-07 04:26:00 | SPY | ETF | 177.64 | 177.68 | 177.64 | 177.68 | 1200.0 |
| 2014-02-07 04:27:00 | SPY | ETF | 177.72 | 177.72 | 177.7 | 177.71 | 20600.0 |
| 2014-02-07 04:29:00 | SPY | ETF | 177.6 | 177.6 | 177.6 | 177.6 | 400.0 |
| 2014-02-07 04:33:00 | SPY | ETF | 177.64 | 177.65 | 177.64 | 177.65 | 251.0 |
| 2014-02-07 04:35:00 | SPY | ETF | 177.65 | 177.65 | 177.65 | 177.65 | 200.0 |
| 2014-02-07 04:36:00 | SPY | ETF | 177.65 | 177.68 | 177.65 | 177.68 | 460.0 |
| 2014-02-07 04:40:00 | SPY | ETF | 177.76 | 177.78 | 177.76 | 177.78 | 600.0 |
| 2014-02-07 04:41:00 | SPY | ETF | 177.78 | 177.78 | 177.78 | 177.78 | 500.0 |
| 2014-02-07 04:43:00 | SPY | ETF | 177.7 | 177.7 | 177.7 | 177.7 | 500.0 |
| 2014-02-07 04:51:00 | SPY | ETF | 177.72 | 177.72 | 177.7 | 177.7 | 4200.0 |
| 2014-02-07 04:54:00 | SPY | ETF | 177.7 | 177.7 | 177.7 | 177.7 | 127.0 |
| 2014-02-07 04:56:00 | SPY | ETF | 177.75 | 177.78 | 177.75 | 177.77 | 10200.0 |
| 2014-02-07 04:59:00 | SPY | ETF | 177.76 | 177.76 | 177.76 | 177.76 | 234.0 |
| 2014-02-07 05:00:00 | SPY | ETF | 177.74 | 177.74 | 177.74 | 177.74 | 200.0 |
| 2014-02-07 05:01:00 | SPY | ETF | 177.72 | 177.72 | 177.72 | 177.72 | 100.0 |
| 2014-02-07 05:05:00 | SPY | ETF | 177.7 | 177.7 | 177.7 | 177.7 | 1000.0 |
| 2014-02-07 05:13:00 | SPY | ETF | 177.76 | 177.76 | 177.76 | 177.76 | 200.0 |
| 2014-02-07 05:35:00 | SPY | ETF | 177.69 | 177.69 | 177.69 | 177.69 | 250.0 |
| 2014-02-07 05:36:00 | SPY | ETF | 177.7 | 177.7 | 177.7 | 177.7 | 700.0 |
| 2014-02-07 05:38:00 | SPY | ETF | 177.68 | 177.68 | 177.68 | 177.68 | 220.0 |
| 2014-02-07 05:49:00 | SPY | ETF | 177.67 | 177.67 | 177.66 | 177.66 | 400.0 |
| 2014-02-07 05:53:00 | SPY | ETF | 177.64 | 177.64 | 177.64 | 177.64 | 40000.0 |
| 2014-02-07 05:54:00 | SPY | ETF | 177.63 | 177.63 | 177.63 | 177.63 | 200.0 |
| 2014-02-07 05:59:00 | SPY | ETF | 177.69 | 177.69 | 177.69 | 177.69 | 12800.0 |
| 2014-02-07 06:00:00 | SPY | ETF | 177.66 | 177.67 | 177.66 | 177.67 | 750.0 |
| 2014-02-07 06:02:00 | SPY | ETF | 177.68 | 177.68 | 177.68 | 177.68 | 600.0 |
| 2014-02-07 06:03:00 | SPY | ETF | 177.68 | 177.68 | 177.68 | 177.68 | 100.0 |
| 2014-02-07 06:04:00 | SPY | ETF | 177.69 | 177.69 | 177.69 | 177.69 | 274.0 |
| 2014-02-07 06:05:00 | SPY | ETF | 177.66 | 177.66 | 177.66 | 177.66 | 152.0 |
| 2014-02-07 06:08:00 | SPY | ETF | 177.66 | 177.66 | 177.65 | 177.65 | 1315.0 |
| 2014-02-07 06:11:00 | SPY | ETF | 177.66 | 177.66 | 177.66 | 177.66 | 1504.0 |
| 2014-02-07 06:16:00 | SPY | ETF | 177.65 | 177.65 | 177.65 | 177.65 | 121.0 |
| 2014-02-07 06:17:00 | SPY | ETF | 177.64 | 177.64 | 177.64 | 177.64 | 4000.0 |
| 2014-02-07 06:26:00 | SPY | ETF | 177.61 | 177.61 | 177.61 | 177.61 | 4000.0 |
> showing 50 of 120,606 rows — these rows as CSV