PREVIEW / etf_5min / 2014-04-24
file: by_date/etf_5min/2014/2014-04-24.parquet size: 968 KB rows: 41,839
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-04-24 04:15:00 | SPY | ETF | 188.52 | 188.52 | 188.52 | 188.52 | 240.0 |
| 2014-04-24 04:25:00 | SPY | ETF | 188.5 | 188.5 | 188.5 | 188.5 | 1075.0 |
| 2014-04-24 04:35:00 | SPY | ETF | 188.51 | 188.51 | 188.51 | 188.51 | 335.0 |
| 2014-04-24 04:40:00 | SPY | ETF | 188.5 | 188.5 | 188.5 | 188.5 | 466.0 |
| 2014-04-24 04:50:00 | SPY | ETF | 188.5 | 188.5 | 188.5 | 188.5 | 100.0 |
| 2014-04-24 04:55:00 | SPY | ETF | 188.53 | 188.53 | 188.52 | 188.52 | 626.0 |
| 2014-04-24 05:00:00 | SPY | ETF | 188.52 | 188.52 | 188.52 | 188.52 | 1199.0 |
| 2014-04-24 05:05:00 | SPY | ETF | 188.43 | 188.48 | 188.43 | 188.48 | 800.0 |
| 2014-04-24 05:10:00 | SPY | ETF | 188.53 | 188.53 | 188.49 | 188.49 | 2387.0 |
| 2014-04-24 05:20:00 | SPY | ETF | 188.52 | 188.52 | 188.52 | 188.52 | 139.0 |
| 2014-04-24 05:25:00 | SPY | ETF | 188.52 | 188.53 | 188.52 | 188.53 | 1341.0 |
| 2014-04-24 05:30:00 | SPY | ETF | 188.5 | 188.5 | 188.5 | 188.5 | 400.0 |
| 2014-04-24 05:35:00 | SPY | ETF | 188.52 | 188.52 | 188.52 | 188.52 | 119.0 |
| 2014-04-24 05:45:00 | SPY | ETF | 188.48 | 188.48 | 188.48 | 188.48 | 398.0 |
| 2014-04-24 06:00:00 | SPY | ETF | 188.44 | 188.53 | 188.44 | 188.53 | 3677.0 |
| 2014-04-24 06:05:00 | SPY | ETF | 188.58 | 188.6 | 188.58 | 188.59 | 5400.0 |
| 2014-04-24 06:15:00 | SPY | ETF | 188.61 | 188.63 | 188.61 | 188.63 | 2143.0 |
| 2014-04-24 06:20:00 | SPY | ETF | 188.64 | 188.68 | 188.64 | 188.68 | 6500.0 |
| 2014-04-24 06:25:00 | SPY | ETF | 188.68 | 188.68 | 188.65 | 188.65 | 850.0 |
| 2014-04-24 06:30:00 | SPY | ETF | 188.65 | 188.65 | 188.65 | 188.65 | 100.0 |
| 2014-04-24 06:40:00 | SPY | ETF | 188.69 | 188.69 | 188.63 | 188.63 | 3300.0 |
| 2014-04-24 06:45:00 | SPY | ETF | 188.6 | 188.6 | 188.58 | 188.58 | 502.0 |
| 2014-04-24 06:50:00 | SPY | ETF | 188.58 | 188.58 | 188.58 | 188.58 | 200.0 |
| 2014-04-24 07:00:00 | SPY | ETF | 188.63 | 188.64 | 188.57 | 188.57 | 2382.0 |
| 2014-04-24 07:05:00 | SPY | ETF | 188.59 | 188.6 | 188.5 | 188.5 | 40068.0 |
| 2014-04-24 07:10:00 | SPY | ETF | 188.49 | 188.52 | 188.46 | 188.5 | 12200.0 |
| 2014-04-24 07:15:00 | SPY | ETF | 188.5 | 188.5 | 188.41 | 188.48 | 18617.0 |
| 2014-04-24 07:20:00 | SPY | ETF | 188.43 | 188.48 | 188.41 | 188.48 | 10540.0 |
| 2014-04-24 07:25:00 | SPY | ETF | 188.48 | 188.5 | 188.43 | 188.46 | 6032.0 |
| 2014-04-24 07:30:00 | SPY | ETF | 188.48 | 188.57 | 188.48 | 188.53 | 46104.0 |
| 2014-04-24 07:35:00 | SPY | ETF | 188.52 | 188.62 | 188.5 | 188.57 | 76300.0 |
| 2014-04-24 07:40:00 | SPY | ETF | 188.6 | 188.67 | 188.58 | 188.61 | 55240.0 |
| 2014-04-24 07:45:00 | SPY | ETF | 188.6 | 188.62 | 188.57 | 188.58 | 95000.0 |
| 2014-04-24 07:50:00 | SPY | ETF | 188.57 | 188.61 | 188.55 | 188.57 | 27503.0 |
| 2014-04-24 07:55:00 | SPY | ETF | 188.54 | 188.54 | 188.41 | 188.46 | 80729.0 |
| 2014-04-24 08:00:00 | SPY | ETF | 188.6 | 188.63 | 188.42 | 188.48 | 45675.0 |
| 2014-04-24 08:05:00 | SPY | ETF | 188.45 | 188.48 | 188.44 | 188.45 | 38700.0 |
| 2014-04-24 08:10:00 | SPY | ETF | 188.45 | 188.48 | 188.43 | 188.47 | 62888.0 |
| 2014-04-24 08:15:00 | SPY | ETF | 188.48 | 188.58 | 188.46 | 188.57 | 47104.0 |
| 2014-04-24 08:20:00 | SPY | ETF | 188.58 | 188.58 | 188.53 | 188.53 | 56490.0 |
| 2014-04-24 08:25:00 | SPY | ETF | 188.52 | 188.61 | 188.52 | 188.61 | 15260.0 |
| 2014-04-24 08:30:00 | SPY | ETF | 188.6 | 188.7 | 188.58 | 188.66 | 186754.0 |
| 2014-04-24 08:35:00 | SPY | ETF | 188.67 | 188.67 | 188.62 | 188.66 | 75693.0 |
| 2014-04-24 08:40:00 | SPY | ETF | 188.66 | 188.76 | 188.65 | 188.76 | 170037.0 |
| 2014-04-24 08:45:00 | SPY | ETF | 188.76 | 188.79 | 188.73 | 188.73 | 94629.0 |
| 2014-04-24 08:50:00 | SPY | ETF | 188.73 | 188.74 | 188.67 | 188.67 | 115202.0 |
| 2014-04-24 08:55:00 | SPY | ETF | 188.66 | 188.68 | 188.51 | 188.52 | 143441.0 |
| 2014-04-24 09:00:00 | SPY | ETF | 188.52 | 188.54 | 188.44 | 188.45 | 214358.0 |
| 2014-04-24 09:05:00 | SPY | ETF | 188.44 | 188.47 | 188.32 | 188.4 | 215241.0 |
| 2014-04-24 09:10:00 | SPY | ETF | 188.4 | 188.46 | 188.37 | 188.4 | 52048.0 |
> showing 50 of 41,839 rows — these rows as CSV