PREVIEW / etf_5min / 2014-02-05
file: by_date/etf_5min/2014/2014-02-05.parquet size: 1.0 MB rows: 44,597
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-05 04:00:00 | SPY | ETF | 174.76 | 174.77 | 174.69 | 174.69 | 18835.0 |
| 2014-02-05 04:05:00 | SPY | ETF | 174.7 | 174.74 | 174.69 | 174.74 | 5250.0 |
| 2014-02-05 04:10:00 | SPY | ETF | 174.74 | 174.79 | 174.74 | 174.79 | 3350.0 |
| 2014-02-05 04:15:00 | SPY | ETF | 174.84 | 174.92 | 174.84 | 174.88 | 1854.0 |
| 2014-02-05 04:20:00 | SPY | ETF | 174.88 | 174.89 | 174.88 | 174.89 | 1045.0 |
| 2014-02-05 04:25:00 | SPY | ETF | 174.89 | 174.9 | 174.89 | 174.9 | 550.0 |
| 2014-02-05 04:35:00 | SPY | ETF | 174.86 | 174.86 | 174.84 | 174.84 | 4222.0 |
| 2014-02-05 04:40:00 | SPY | ETF | 174.88 | 174.88 | 174.83 | 174.83 | 8281.0 |
| 2014-02-05 04:45:00 | SPY | ETF | 174.82 | 174.83 | 174.82 | 174.83 | 41400.0 |
| 2014-02-05 04:50:00 | SPY | ETF | 174.83 | 174.83 | 174.8 | 174.8 | 22309.0 |
| 2014-02-05 04:55:00 | SPY | ETF | 174.8 | 174.8 | 174.79 | 174.79 | 37800.0 |
| 2014-02-05 05:00:00 | SPY | ETF | 174.75 | 174.75 | 174.61 | 174.61 | 19691.0 |
| 2014-02-05 05:05:00 | SPY | ETF | 174.71 | 174.77 | 174.7 | 174.77 | 2028.0 |
| 2014-02-05 05:10:00 | SPY | ETF | 174.79 | 174.79 | 174.75 | 174.75 | 600.0 |
| 2014-02-05 05:15:00 | SPY | ETF | 174.79 | 174.87 | 174.79 | 174.84 | 7192.0 |
| 2014-02-05 05:20:00 | SPY | ETF | 174.74 | 174.74 | 174.74 | 174.74 | 101.0 |
| 2014-02-05 05:25:00 | SPY | ETF | 174.83 | 174.83 | 174.83 | 174.83 | 181.0 |
| 2014-02-05 05:30:00 | SPY | ETF | 174.81 | 174.81 | 174.81 | 174.81 | 2046.0 |
| 2014-02-05 05:35:00 | SPY | ETF | 174.83 | 174.84 | 174.83 | 174.84 | 2248.0 |
| 2014-02-05 05:40:00 | SPY | ETF | 174.84 | 174.88 | 174.74 | 174.74 | 3029.0 |
| 2014-02-05 05:50:00 | SPY | ETF | 174.78 | 174.78 | 174.73 | 174.73 | 350.0 |
| 2014-02-05 05:55:00 | SPY | ETF | 174.71 | 174.71 | 174.62 | 174.62 | 298.0 |
| 2014-02-05 06:05:00 | SPY | ETF | 174.6 | 174.6 | 174.52 | 174.53 | 7510.0 |
| 2014-02-05 06:10:00 | SPY | ETF | 174.54 | 174.62 | 174.54 | 174.6 | 1609.0 |
| 2014-02-05 06:15:00 | SPY | ETF | 174.61 | 174.61 | 174.54 | 174.54 | 1000.0 |
| 2014-02-05 06:20:00 | SPY | ETF | 174.56 | 174.56 | 174.42 | 174.48 | 21889.0 |
| 2014-02-05 06:25:00 | SPY | ETF | 174.5 | 174.52 | 174.5 | 174.52 | 400.0 |
| 2014-02-05 06:30:00 | SPY | ETF | 174.55 | 174.59 | 174.5 | 174.59 | 5822.0 |
| 2014-02-05 06:35:00 | SPY | ETF | 174.61 | 174.61 | 174.59 | 174.59 | 5755.0 |
| 2014-02-05 06:40:00 | SPY | ETF | 174.66 | 174.76 | 174.66 | 174.76 | 1205.0 |
| 2014-02-05 06:45:00 | SPY | ETF | 174.76 | 174.76 | 174.69 | 174.69 | 4050.0 |
| 2014-02-05 06:50:00 | SPY | ETF | 174.7 | 174.7 | 174.64 | 174.64 | 17413.0 |
| 2014-02-05 06:55:00 | SPY | ETF | 174.57 | 174.57 | 174.52 | 174.52 | 17380.0 |
| 2014-02-05 07:00:00 | SPY | ETF | 174.55 | 174.55 | 174.3 | 174.43 | 74740.0 |
| 2014-02-05 07:05:00 | SPY | ETF | 174.43 | 174.54 | 174.39 | 174.54 | 56224.0 |
| 2014-02-05 07:10:00 | SPY | ETF | 174.57 | 174.71 | 174.57 | 174.6 | 26343.0 |
| 2014-02-05 07:15:00 | SPY | ETF | 174.62 | 174.63 | 174.54 | 174.54 | 36874.0 |
| 2014-02-05 07:20:00 | SPY | ETF | 174.54 | 174.66 | 174.54 | 174.63 | 7619.0 |
| 2014-02-05 07:25:00 | SPY | ETF | 174.61 | 174.61 | 174.53 | 174.55 | 434.0 |
| 2014-02-05 07:30:00 | SPY | ETF | 174.57 | 174.63 | 174.57 | 174.62 | 10461.0 |
| 2014-02-05 07:35:00 | SPY | ETF | 174.59 | 174.61 | 174.49 | 174.49 | 90254.0 |
| 2014-02-05 07:40:00 | SPY | ETF | 174.52 | 174.52 | 174.47 | 174.47 | 31400.0 |
| 2014-02-05 07:45:00 | SPY | ETF | 174.47 | 174.47 | 174.39 | 174.4 | 59819.0 |
| 2014-02-05 07:50:00 | SPY | ETF | 174.4 | 174.45 | 174.38 | 174.42 | 111707.0 |
| 2014-02-05 07:55:00 | SPY | ETF | 174.39 | 174.39 | 174.31 | 174.37 | 106300.0 |
| 2014-02-05 08:00:00 | SPY | ETF | 174.37 | 174.61 | 174.34 | 174.42 | 201342.0 |
| 2014-02-05 08:05:00 | SPY | ETF | 174.419 | 174.42 | 174.32 | 174.34 | 184745.0 |
| 2014-02-05 08:10:00 | SPY | ETF | 174.34 | 174.38 | 174.22 | 174.27 | 112177.0 |
| 2014-02-05 08:15:00 | SPY | ETF | 174.27 | 174.63 | 174.04 | 174.05 | 445830.0 |
| 2014-02-05 08:20:00 | SPY | ETF | 174.04 | 174.13 | 173.94 | 174.05 | 512536.0 |
> showing 50 of 44,597 rows — these rows as CSV