PREVIEW / etf_1min / 2015-07-20
file: by_date/etf_1min/2015/2015-07-20.parquet size: 2.4 MB rows: 127,336
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 |
|---|---|---|---|---|---|---|---|
| 2015-07-20 04:05:00 | SPY | ETF | 212.64 | 212.64 | 212.64 | 212.64 | 100.0 |
| 2015-07-20 04:07:00 | SPY | ETF | 212.7 | 212.7 | 212.7 | 212.7 | 500.0 |
| 2015-07-20 04:08:00 | SPY | ETF | 212.7 | 212.7 | 212.7 | 212.7 | 1400.0 |
| 2015-07-20 04:28:00 | SPY | ETF | 212.67 | 212.67 | 212.67 | 212.67 | 2500.0 |
| 2015-07-20 04:29:00 | SPY | ETF | 212.65 | 212.65 | 212.62 | 212.62 | 1500.0 |
| 2015-07-20 04:32:00 | SPY | ETF | 212.66 | 212.66 | 212.66 | 212.66 | 300.0 |
| 2015-07-20 04:41:00 | SPY | ETF | 212.59 | 212.59 | 212.59 | 212.59 | 300.0 |
| 2015-07-20 04:43:00 | SPY | ETF | 212.63 | 212.63 | 212.63 | 212.63 | 201.0 |
| 2015-07-20 04:45:00 | SPY | ETF | 212.62 | 212.63 | 212.62 | 212.63 | 60100.0 |
| 2015-07-20 04:47:00 | SPY | ETF | 212.67 | 212.67 | 212.67 | 212.67 | 168.0 |
| 2015-07-20 04:48:00 | SPY | ETF | 212.68 | 212.72 | 212.68 | 212.72 | 1102.0 |
| 2015-07-20 04:49:00 | SPY | ETF | 212.76 | 212.81 | 212.76 | 212.81 | 1400.0 |
| 2015-07-20 04:52:00 | SPY | ETF | 212.76 | 212.76 | 212.76 | 212.76 | 300.0 |
| 2015-07-20 04:55:00 | SPY | ETF | 212.75 | 212.75 | 212.75 | 212.75 | 300.0 |
| 2015-07-20 05:00:00 | SPY | ETF | 212.74 | 212.74 | 212.74 | 212.74 | 300.0 |
| 2015-07-20 05:04:00 | SPY | ETF | 212.77 | 212.77 | 212.72 | 212.72 | 801.0 |
| 2015-07-20 05:05:00 | SPY | ETF | 212.69 | 212.69 | 212.69 | 212.69 | 500.0 |
| 2015-07-20 05:07:00 | SPY | ETF | 212.69 | 212.69 | 212.69 | 212.69 | 500.0 |
| 2015-07-20 05:12:00 | SPY | ETF | 212.64 | 212.64 | 212.64 | 212.64 | 800.0 |
| 2015-07-20 05:17:00 | SPY | ETF | 212.65 | 212.65 | 212.64 | 212.64 | 900.0 |
| 2015-07-20 05:27:00 | SPY | ETF | 212.64 | 212.64 | 212.64 | 212.64 | 600.0 |
| 2015-07-20 05:38:00 | SPY | ETF | 212.66 | 212.74 | 212.66 | 212.69 | 900.0 |
| 2015-07-20 05:45:00 | SPY | ETF | 212.66 | 212.66 | 212.64 | 212.64 | 307.0 |
| 2015-07-20 05:56:00 | SPY | ETF | 212.7 | 212.7 | 212.69 | 212.69 | 500.0 |
| 2015-07-20 05:59:00 | SPY | ETF | 212.7 | 212.71 | 212.7 | 212.71 | 301.0 |
| 2015-07-20 06:03:00 | SPY | ETF | 212.71 | 212.74 | 212.71 | 212.73 | 16800.0 |
| 2015-07-20 06:04:00 | SPY | ETF | 212.77 | 212.77 | 212.76 | 212.76 | 7950.0 |
| 2015-07-20 06:05:00 | SPY | ETF | 212.77 | 212.77 | 212.77 | 212.77 | 6300.0 |
| 2015-07-20 06:06:00 | SPY | ETF | 212.78 | 212.78 | 212.76 | 212.78 | 3660.0 |
| 2015-07-20 06:09:00 | SPY | ETF | 212.78 | 212.78 | 212.78 | 212.78 | 200.0 |
| 2015-07-20 06:11:00 | SPY | ETF | 212.78 | 212.78 | 212.78 | 212.78 | 200.0 |
| 2015-07-20 06:14:00 | SPY | ETF | 212.78 | 212.78 | 212.78 | 212.78 | 100.0 |
| 2015-07-20 06:17:00 | SPY | ETF | 212.79 | 212.8 | 212.79 | 212.8 | 400.0 |
| 2015-07-20 06:22:00 | SPY | ETF | 212.8 | 212.8 | 212.8 | 212.8 | 2000.0 |
| 2015-07-20 06:28:00 | SPY | ETF | 212.71 | 212.71 | 212.66 | 212.66 | 1090.0 |
| 2015-07-20 06:29:00 | SPY | ETF | 212.69 | 212.69 | 212.69 | 212.69 | 400.0 |
| 2015-07-20 06:31:00 | SPY | ETF | 212.7 | 212.7 | 212.7 | 212.7 | 200.0 |
| 2015-07-20 06:35:00 | SPY | ETF | 212.69 | 212.69 | 212.69 | 212.69 | 300.0 |
| 2015-07-20 06:36:00 | SPY | ETF | 212.66 | 212.66 | 212.66 | 212.66 | 829.0 |
| 2015-07-20 06:50:00 | SPY | ETF | 212.68 | 212.68 | 212.68 | 212.68 | 200.0 |
| 2015-07-20 07:00:00 | SPY | ETF | 212.65 | 212.65 | 212.65 | 212.65 | 300.0 |
| 2015-07-20 07:03:00 | SPY | ETF | 212.65 | 212.65 | 212.65 | 212.65 | 153.0 |
| 2015-07-20 07:07:00 | SPY | ETF | 212.64 | 212.64 | 212.64 | 212.64 | 300.0 |
| 2015-07-20 07:10:00 | SPY | ETF | 212.63 | 212.65 | 212.63 | 212.65 | 1962.0 |
| 2015-07-20 07:11:00 | SPY | ETF | 212.62 | 212.62 | 212.62 | 212.62 | 301.0 |
| 2015-07-20 07:13:00 | SPY | ETF | 212.63 | 212.63 | 212.63 | 212.63 | 170.0 |
| 2015-07-20 07:14:00 | SPY | ETF | 212.63 | 212.63 | 212.63 | 212.63 | 100.0 |
| 2015-07-20 07:15:00 | SPY | ETF | 212.65 | 212.65 | 212.65 | 212.65 | 101.0 |
| 2015-07-20 07:21:00 | SPY | ETF | 212.63 | 212.63 | 212.62 | 212.62 | 301.0 |
| 2015-07-20 07:22:00 | SPY | ETF | 212.62 | 212.64 | 212.62 | 212.64 | 230.0 |
> showing 50 of 127,336 rows — these rows as CSV