PREVIEW / etf_5min / 2014-05-12
file: by_date/etf_5min/2014/2014-05-12.parquet size: 989 KB rows: 42,779
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-05-12 04:00:00 | SPY | ETF | 188.2 | 188.2 | 188.2 | 188.2 | 700.0 |
| 2014-05-12 04:05:00 | SPY | ETF | 188.19 | 188.19 | 188.19 | 188.19 | 1030.0 |
| 2014-05-12 04:15:00 | SPY | ETF | 188.19 | 188.22 | 188.19 | 188.22 | 589.0 |
| 2014-05-12 04:20:00 | SPY | ETF | 188.21 | 188.21 | 188.21 | 188.21 | 291.0 |
| 2014-05-12 04:25:00 | SPY | ETF | 188.22 | 188.22 | 188.22 | 188.22 | 141.0 |
| 2014-05-12 04:55:00 | SPY | ETF | 188.19 | 188.19 | 188.19 | 188.19 | 400.0 |
| 2014-05-12 05:10:00 | SPY | ETF | 188.23 | 188.23 | 188.23 | 188.23 | 500.0 |
| 2014-05-12 05:15:00 | SPY | ETF | 188.21 | 188.25 | 188.21 | 188.25 | 8596.0 |
| 2014-05-12 05:20:00 | SPY | ETF | 188.23 | 188.23 | 188.23 | 188.23 | 110.0 |
| 2014-05-12 05:35:00 | SPY | ETF | 188.14 | 188.24 | 188.14 | 188.24 | 2500.0 |
| 2014-05-12 05:40:00 | SPY | ETF | 188.22 | 188.22 | 188.22 | 188.22 | 136.0 |
| 2014-05-12 05:45:00 | SPY | ETF | 188.23 | 188.3 | 188.23 | 188.3 | 3011.0 |
| 2014-05-12 05:50:00 | SPY | ETF | 188.29 | 188.29 | 188.29 | 188.29 | 100.0 |
| 2014-05-12 05:55:00 | SPY | ETF | 188.34 | 188.34 | 188.34 | 188.34 | 432.0 |
| 2014-05-12 06:00:00 | SPY | ETF | 188.34 | 188.34 | 188.34 | 188.34 | 2000.0 |
| 2014-05-12 06:10:00 | SPY | ETF | 188.32 | 188.32 | 188.32 | 188.32 | 131.0 |
| 2014-05-12 06:15:00 | SPY | ETF | 188.3 | 188.3 | 188.27 | 188.28 | 8450.0 |
| 2014-05-12 06:20:00 | SPY | ETF | 188.32 | 188.36 | 188.32 | 188.36 | 2200.0 |
| 2014-05-12 06:25:00 | SPY | ETF | 188.38 | 188.5 | 188.38 | 188.5 | 3183.0 |
| 2014-05-12 06:30:00 | SPY | ETF | 188.51 | 188.51 | 188.51 | 188.51 | 895.0 |
| 2014-05-12 06:35:00 | SPY | ETF | 188.52 | 188.58 | 188.52 | 188.56 | 10710.0 |
| 2014-05-12 06:40:00 | SPY | ETF | 188.6 | 188.62 | 188.55 | 188.6 | 1800.0 |
| 2014-05-12 06:45:00 | SPY | ETF | 188.61 | 188.63 | 188.59 | 188.59 | 1700.0 |
| 2014-05-12 06:50:00 | SPY | ETF | 188.63 | 188.65 | 188.63 | 188.65 | 26600.0 |
| 2014-05-12 06:55:00 | SPY | ETF | 188.64 | 188.68 | 188.64 | 188.68 | 5344.0 |
| 2014-05-12 07:00:00 | SPY | ETF | 188.69 | 188.73 | 188.66 | 188.7 | 10977.0 |
| 2014-05-12 07:05:00 | SPY | ETF | 188.69 | 188.71 | 188.66 | 188.7 | 49507.0 |
| 2014-05-12 07:10:00 | SPY | ETF | 188.7 | 188.72 | 188.61 | 188.61 | 9641.0 |
| 2014-05-12 07:15:00 | SPY | ETF | 188.62 | 188.65 | 188.62 | 188.65 | 10028.0 |
| 2014-05-12 07:20:00 | SPY | ETF | 188.63 | 188.63 | 188.59 | 188.62 | 12860.0 |
| 2014-05-12 07:25:00 | SPY | ETF | 188.62 | 188.63 | 188.6 | 188.63 | 600.0 |
| 2014-05-12 07:30:00 | SPY | ETF | 188.61 | 188.64 | 188.6 | 188.64 | 15127.0 |
| 2014-05-12 07:35:00 | SPY | ETF | 188.65 | 188.65 | 188.61 | 188.63 | 3254.0 |
| 2014-05-12 07:40:00 | SPY | ETF | 188.62 | 188.62 | 188.58 | 188.59 | 23100.0 |
| 2014-05-12 07:45:00 | SPY | ETF | 188.59 | 188.62 | 188.58 | 188.58 | 6950.0 |
| 2014-05-12 07:50:00 | SPY | ETF | 188.6 | 188.6 | 188.58 | 188.58 | 3320.0 |
| 2014-05-12 07:55:00 | SPY | ETF | 188.58 | 188.58 | 188.54 | 188.56 | 8770.0 |
| 2014-05-12 08:00:00 | SPY | ETF | 188.55 | 188.73 | 188.55 | 188.56 | 27503.0 |
| 2014-05-12 08:05:00 | SPY | ETF | 188.56 | 188.6 | 188.55 | 188.56 | 28005.0 |
| 2014-05-12 08:10:00 | SPY | ETF | 188.55 | 188.56 | 188.53 | 188.54 | 9983.0 |
| 2014-05-12 08:15:00 | SPY | ETF | 188.54 | 188.56 | 188.5 | 188.5 | 23883.0 |
| 2014-05-12 08:20:00 | SPY | ETF | 188.5 | 188.54 | 188.5 | 188.53 | 24753.0 |
| 2014-05-12 08:25:00 | SPY | ETF | 188.53 | 188.58 | 188.53 | 188.58 | 14870.0 |
| 2014-05-12 08:30:00 | SPY | ETF | 188.56 | 188.56 | 188.56 | 188.56 | 6108.0 |
| 2014-05-12 08:35:00 | SPY | ETF | 188.57 | 188.61 | 188.57 | 188.6 | 32898.0 |
| 2014-05-12 08:40:00 | SPY | ETF | 188.62 | 188.62 | 188.41 | 188.6 | 28050.0 |
| 2014-05-12 08:45:00 | SPY | ETF | 188.61 | 188.61 | 188.6 | 188.61 | 4490.0 |
| 2014-05-12 08:50:00 | SPY | ETF | 188.6 | 188.6 | 188.57 | 188.57 | 53639.0 |
| 2014-05-12 08:55:00 | SPY | ETF | 188.58 | 188.62 | 188.57 | 188.62 | 22370.0 |
| 2014-05-12 09:00:00 | SPY | ETF | 188.61 | 188.62 | 188.58 | 188.58 | 7800.0 |
> showing 50 of 42,779 rows — these rows as CSV