PREVIEW / etf_5min / 2014-02-28
file: by_date/etf_5min/2014/2014-02-28.parquet size: 1.0 MB rows: 44,017
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-28 04:00:00 | SPY | ETF | 185.75 | 185.75 | 185.75 | 185.75 | 341.0 |
| 2014-02-28 04:05:00 | SPY | ETF | 185.71 | 185.71 | 185.71 | 185.71 | 20000.0 |
| 2014-02-28 04:10:00 | SPY | ETF | 185.61 | 185.62 | 185.61 | 185.62 | 40200.0 |
| 2014-02-28 04:15:00 | SPY | ETF | 185.57 | 185.57 | 185.54 | 185.54 | 6375.0 |
| 2014-02-28 04:20:00 | SPY | ETF | 185.57 | 185.59 | 185.48 | 185.5 | 34173.0 |
| 2014-02-28 04:25:00 | SPY | ETF | 185.52 | 185.52 | 185.5 | 185.5 | 3215.0 |
| 2014-02-28 04:30:00 | SPY | ETF | 185.46 | 185.48 | 185.45 | 185.48 | 2742.0 |
| 2014-02-28 04:35:00 | SPY | ETF | 185.6 | 185.6 | 185.6 | 185.6 | 15000.0 |
| 2014-02-28 04:40:00 | SPY | ETF | 185.52 | 185.52 | 185.52 | 185.52 | 176.0 |
| 2014-02-28 04:45:00 | SPY | ETF | 185.53 | 185.6 | 185.53 | 185.6 | 5180.0 |
| 2014-02-28 04:50:00 | SPY | ETF | 185.67 | 185.67 | 185.67 | 185.67 | 3000.0 |
| 2014-02-28 05:00:00 | SPY | ETF | 185.68 | 185.69 | 185.63 | 185.63 | 7756.0 |
| 2014-02-28 05:10:00 | SPY | ETF | 185.63 | 185.65 | 185.63 | 185.65 | 3200.0 |
| 2014-02-28 05:15:00 | SPY | ETF | 185.57 | 185.57 | 185.57 | 185.57 | 129.0 |
| 2014-02-28 05:20:00 | SPY | ETF | 185.67 | 185.67 | 185.67 | 185.67 | 100.0 |
| 2014-02-28 05:45:00 | SPY | ETF | 185.63 | 185.63 | 185.61 | 185.61 | 648.0 |
| 2014-02-28 05:55:00 | SPY | ETF | 185.77 | 185.77 | 185.77 | 185.77 | 199.0 |
| 2014-02-28 06:00:00 | SPY | ETF | 185.72 | 185.72 | 185.66 | 185.66 | 638.0 |
| 2014-02-28 06:10:00 | SPY | ETF | 185.69 | 185.69 | 185.69 | 185.69 | 400.0 |
| 2014-02-28 06:15:00 | SPY | ETF | 185.66 | 185.66 | 185.66 | 185.66 | 100.0 |
| 2014-02-28 06:20:00 | SPY | ETF | 185.65 | 185.65 | 185.6 | 185.61 | 1515.0 |
| 2014-02-28 06:25:00 | SPY | ETF | 185.64 | 185.64 | 185.64 | 185.64 | 100.0 |
| 2014-02-28 06:30:00 | SPY | ETF | 185.65 | 185.65 | 185.59 | 185.59 | 3200.0 |
| 2014-02-28 06:35:00 | SPY | ETF | 185.6 | 185.6 | 185.58 | 185.58 | 260.0 |
| 2014-02-28 06:45:00 | SPY | ETF | 185.56 | 185.56 | 185.56 | 185.56 | 3000.0 |
| 2014-02-28 06:50:00 | SPY | ETF | 185.64 | 185.67 | 185.64 | 185.66 | 25627.0 |
| 2014-02-28 06:55:00 | SPY | ETF | 185.68 | 185.68 | 185.64 | 185.64 | 700.0 |
| 2014-02-28 07:00:00 | SPY | ETF | 185.61 | 185.64 | 185.57 | 185.57 | 14100.0 |
| 2014-02-28 07:05:00 | SPY | ETF | 185.55 | 185.56 | 185.5 | 185.52 | 32062.0 |
| 2014-02-28 07:10:00 | SPY | ETF | 185.51 | 185.62 | 185.51 | 185.62 | 16982.0 |
| 2014-02-28 07:15:00 | SPY | ETF | 185.61 | 185.62 | 185.61 | 185.61 | 500.0 |
| 2014-02-28 07:20:00 | SPY | ETF | 185.65 | 185.7 | 185.62 | 185.67 | 52841.0 |
| 2014-02-28 07:25:00 | SPY | ETF | 185.67 | 185.69 | 185.66 | 185.66 | 5916.0 |
| 2014-02-28 07:30:00 | SPY | ETF | 185.72 | 185.79 | 185.72 | 185.77 | 44782.0 |
| 2014-02-28 07:35:00 | SPY | ETF | 185.74 | 185.77 | 185.73 | 185.73 | 12960.0 |
| 2014-02-28 07:40:00 | SPY | ETF | 185.74 | 185.75 | 185.69 | 185.69 | 33955.0 |
| 2014-02-28 07:45:00 | SPY | ETF | 185.67 | 185.69 | 185.64 | 185.64 | 4770.0 |
| 2014-02-28 07:50:00 | SPY | ETF | 185.67 | 185.67 | 185.65 | 185.66 | 1532.0 |
| 2014-02-28 07:55:00 | SPY | ETF | 185.64 | 185.69 | 185.64 | 185.64 | 9816.0 |
| 2014-02-28 08:00:00 | SPY | ETF | 185.765 | 185.765 | 185.62 | 185.68 | 38008.0 |
| 2014-02-28 08:05:00 | SPY | ETF | 185.69 | 185.72 | 185.68 | 185.7 | 11653.0 |
| 2014-02-28 08:10:00 | SPY | ETF | 185.69 | 185.69 | 185.68 | 185.68 | 6692.0 |
| 2014-02-28 08:15:00 | SPY | ETF | 185.68 | 185.77 | 185.66 | 185.76 | 59065.0 |
| 2014-02-28 08:20:00 | SPY | ETF | 185.73 | 185.77 | 185.67 | 185.74 | 11233.0 |
| 2014-02-28 08:25:00 | SPY | ETF | 185.75 | 185.87 | 185.66 | 185.7 | 68192.0 |
| 2014-02-28 08:30:00 | SPY | ETF | 185.69 | 185.81 | 185.56 | 185.64 | 333359.0 |
| 2014-02-28 08:35:00 | SPY | ETF | 185.67 | 185.7 | 185.62 | 185.66 | 75107.0 |
| 2014-02-28 08:40:00 | SPY | ETF | 185.66 | 185.77 | 185.66 | 185.71 | 182271.0 |
| 2014-02-28 08:45:00 | SPY | ETF | 185.71 | 185.71 | 185.65 | 185.65 | 78081.0 |
| 2014-02-28 08:50:00 | SPY | ETF | 185.65 | 185.72 | 185.64 | 185.7 | 51975.0 |
> showing 50 of 44,017 rows — these rows as CSV