PREVIEW / etf_5min / 2012-07-11
file: by_date/etf_5min/2012/2012-07-11.parquet size: 816 KB rows: 34,088
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 |
|---|---|---|---|---|---|---|---|
| 2012-07-11 04:10:00 | SPY | ETF | 134.16 | 134.29 | 134.16 | 134.26 | 2600.0 |
| 2012-07-11 04:15:00 | SPY | ETF | 134.23 | 134.23 | 134.23 | 134.23 | 500.0 |
| 2012-07-11 04:20:00 | SPY | ETF | 134.23 | 134.23 | 134.2 | 134.2 | 10400.0 |
| 2012-07-11 04:30:00 | SPY | ETF | 134.3 | 134.3 | 134.28 | 134.28 | 1100.0 |
| 2012-07-11 04:35:00 | SPY | ETF | 134.3 | 134.34 | 134.3 | 134.34 | 4300.0 |
| 2012-07-11 04:40:00 | SPY | ETF | 134.38 | 134.41 | 134.38 | 134.41 | 200.0 |
| 2012-07-11 04:45:00 | SPY | ETF | 134.4 | 134.5 | 134.4 | 134.49 | 5465.0 |
| 2012-07-11 04:50:00 | SPY | ETF | 134.5 | 134.5 | 134.5 | 134.5 | 100.0 |
| 2012-07-11 04:55:00 | SPY | ETF | 134.55 | 134.58 | 134.55 | 134.58 | 200.0 |
| 2012-07-11 05:00:00 | SPY | ETF | 134.58 | 134.6 | 134.55 | 134.59 | 5422.0 |
| 2012-07-11 05:15:00 | SPY | ETF | 134.57 | 134.57 | 134.5 | 134.5 | 300.0 |
| 2012-07-11 05:20:00 | SPY | ETF | 134.48 | 134.48 | 134.46 | 134.46 | 500.0 |
| 2012-07-11 05:25:00 | SPY | ETF | 134.5 | 134.5 | 134.5 | 134.5 | 100.0 |
| 2012-07-11 05:45:00 | SPY | ETF | 134.46 | 134.46 | 134.46 | 134.46 | 100.0 |
| 2012-07-11 06:00:00 | SPY | ETF | 134.48 | 134.48 | 134.44 | 134.45 | 15160.0 |
| 2012-07-11 06:10:00 | SPY | ETF | 134.43 | 134.43 | 134.35 | 134.35 | 1300.0 |
| 2012-07-11 06:15:00 | SPY | ETF | 134.35 | 134.35 | 134.35 | 134.35 | 8800.0 |
| 2012-07-11 06:20:00 | SPY | ETF | 134.45 | 134.45 | 134.45 | 134.45 | 100.0 |
| 2012-07-11 06:25:00 | SPY | ETF | 134.44 | 134.45 | 134.44 | 134.45 | 300.0 |
| 2012-07-11 06:30:00 | SPY | ETF | 134.45 | 134.59 | 134.45 | 134.53 | 24800.0 |
| 2012-07-11 06:35:00 | SPY | ETF | 134.54 | 134.55 | 134.54 | 134.55 | 850.0 |
| 2012-07-11 06:40:00 | SPY | ETF | 134.61 | 134.69 | 134.61 | 134.62 | 3930.0 |
| 2012-07-11 06:45:00 | SPY | ETF | 134.63 | 134.7 | 134.6 | 134.7 | 19770.0 |
| 2012-07-11 06:50:00 | SPY | ETF | 134.71 | 134.76 | 134.7 | 134.76 | 12615.0 |
| 2012-07-11 06:55:00 | SPY | ETF | 134.7 | 134.7 | 134.65 | 134.7 | 405.0 |
| 2012-07-11 07:00:00 | SPY | ETF | 134.71 | 134.76 | 134.66 | 134.72 | 24595.0 |
| 2012-07-11 07:05:00 | SPY | ETF | 134.74 | 134.84 | 134.74 | 134.74 | 26360.0 |
| 2012-07-11 07:10:00 | SPY | ETF | 134.74 | 134.74 | 134.67 | 134.67 | 59598.0 |
| 2012-07-11 07:15:00 | SPY | ETF | 134.69 | 134.71 | 134.69 | 134.69 | 11200.0 |
| 2012-07-11 07:20:00 | SPY | ETF | 134.68 | 134.68 | 134.64 | 134.66 | 1100.0 |
| 2012-07-11 07:25:00 | SPY | ETF | 134.65 | 134.65 | 134.62 | 134.62 | 3200.0 |
| 2012-07-11 07:30:00 | SPY | ETF | 134.61 | 134.65 | 134.6 | 134.65 | 2301.0 |
| 2012-07-11 07:35:00 | SPY | ETF | 134.62 | 134.62 | 134.6 | 134.6 | 824.0 |
| 2012-07-11 07:40:00 | SPY | ETF | 134.62 | 134.65 | 134.6 | 134.63 | 3000.0 |
| 2012-07-11 07:45:00 | SPY | ETF | 134.65 | 134.67 | 134.62 | 134.62 | 37000.0 |
| 2012-07-11 07:50:00 | SPY | ETF | 134.64 | 134.65 | 134.62 | 134.62 | 6600.0 |
| 2012-07-11 07:55:00 | SPY | ETF | 134.6 | 134.6 | 134.44 | 134.47 | 10388.0 |
| 2012-07-11 08:00:00 | SPY | ETF | 134.51 | 134.64 | 134.37 | 134.4 | 79882.0 |
| 2012-07-11 08:05:00 | SPY | ETF | 134.38 | 134.48 | 134.38 | 134.48 | 175302.0 |
| 2012-07-11 08:10:00 | SPY | ETF | 134.47 | 134.49 | 134.31 | 134.4 | 931336.0 |
| 2012-07-11 08:15:00 | SPY | ETF | 134.39 | 134.45 | 134.35 | 134.37 | 26023.0 |
| 2012-07-11 08:20:00 | SPY | ETF | 134.35 | 134.42 | 134.33 | 134.39 | 39735.0 |
| 2012-07-11 08:25:00 | SPY | ETF | 134.36 | 134.4 | 134.27 | 134.29 | 48910.0 |
| 2012-07-11 08:30:00 | SPY | ETF | 134.31 | 134.43 | 134.27 | 134.43 | 116670.0 |
| 2012-07-11 08:35:00 | SPY | ETF | 134.41 | 134.42 | 134.36 | 134.4 | 55789.0 |
| 2012-07-11 08:40:00 | SPY | ETF | 134.4 | 134.48 | 134.37 | 134.46 | 73479.0 |
| 2012-07-11 08:45:00 | SPY | ETF | 134.46 | 134.48 | 134.38 | 134.41 | 156373.0 |
| 2012-07-11 08:50:00 | SPY | ETF | 134.39 | 134.4 | 134.3 | 134.32 | 120362.0 |
| 2012-07-11 08:55:00 | SPY | ETF | 134.31 | 134.37 | 134.29 | 134.3 | 75188.0 |
| 2012-07-11 09:00:00 | SPY | ETF | 134.31 | 134.33 | 134.24 | 134.27 | 165550.0 |
> showing 50 of 34,088 rows — these rows as CSV