PREVIEW / etf_1hour / 2015-05-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-05-28.parquet
  size:    236 KB
  rows:    7,511

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
2015-05-28 04:00:00	SPY	ETF	212.28	212.45	212.25	212.45	4223.0
2015-05-28 05:00:00	SPY	ETF	212.42	212.43	212.25	212.43	64813.0
2015-05-28 06:00:00	SPY	ETF	212.46	212.52	212.35	212.38	19326.0
2015-05-28 07:00:00	SPY	ETF	212.44	212.51	212.11	212.19	425595.0
2015-05-28 08:00:00	SPY	ETF	212.48	212.5	212.09	212.19	653425.0
2015-05-28 09:00:00	SPY	ETF	212.19	212.59	211.82	211.85	12182400.0
2015-05-28 10:00:00	SPY	ETF	211.87	212.21	211.63	211.88	11980346.0
2015-05-28 11:00:00	SPY	ETF	211.88	212.34	211.66	211.84	10317099.0
2015-05-28 12:00:00	SPY	ETF	211.84	212.15	211.72	211.89	8616282.0
2015-05-28 13:00:00	SPY	ETF	211.89	212.26	211.84	212.1	6605942.0
2015-05-28 14:00:00	SPY	ETF	212.095	212.53	212.0	212.45	5092693.0
2015-05-28 15:00:00	SPY	ETF	212.45	212.58	212.3	212.49	11831737.0
2015-05-28 16:00:00	SPY	ETF	212.48	212.81	212.37	212.81	4759590.0
2015-05-28 17:00:00	SPY	ETF	212.81	212.82	212.74	212.74	98072.0
2015-05-28 18:00:00	SPY	ETF	212.75	212.75	212.69	212.72	55464.0
2015-05-28 19:00:00	SPY	ETF	212.73	212.76	212.68	212.73	50054.0
2015-05-28 06:00:00	QQQ	ETF	110.77	110.77	110.73	110.76	20500.0
2015-05-28 07:00:00	QQQ	ETF	110.8	110.83	110.65	110.73	38908.0
2015-05-28 08:00:00	QQQ	ETF	110.72	110.83	110.62	110.72	76043.0
2015-05-28 09:00:00	QQQ	ETF	110.72	111.01	110.43	110.48	3942053.0
2015-05-28 10:00:00	QQQ	ETF	110.49	110.7	110.37	110.5956	2808369.0
2015-05-28 11:00:00	QQQ	ETF	110.595	110.81	110.43	110.54	2038559.0
2015-05-28 12:00:00	QQQ	ETF	110.54	110.71	110.48	110.53	1000738.0
2015-05-28 13:00:00	QQQ	ETF	110.52	110.69	110.5	110.59	959039.0
2015-05-28 14:00:00	QQQ	ETF	110.6	110.81	110.56	110.72	1019573.0
2015-05-28 15:00:00	QQQ	ETF	110.73	110.8	110.6139	110.72	2170197.0
2015-05-28 16:00:00	QQQ	ETF	110.72	110.92	110.67	110.9	342951.0
2015-05-28 17:00:00	QQQ	ETF	110.9	110.91	110.879	110.88	20050.0
2015-05-28 18:00:00	QQQ	ETF	110.86	110.86	110.86	110.86	400.0
2015-05-28 19:00:00	QQQ	ETF	110.87	110.87	110.83	110.86	3565.0
2015-05-28 07:00:00	IWM	ETF	124.59	124.59	124.48	124.54	19600.0
2015-05-28 08:00:00	IWM	ETF	124.51	124.53	124.36	124.36	127149.0
2015-05-28 09:00:00	IWM	ETF	124.42	124.71	123.77	123.99	2648145.0
2015-05-28 10:00:00	IWM	ETF	123.99	124.34	123.81	124.27	3970635.0
2015-05-28 11:00:00	IWM	ETF	124.28	124.51	124.01	124.17	2120706.0
2015-05-28 12:00:00	IWM	ETF	124.175	124.365	124.105	124.19	914875.0
2015-05-28 13:00:00	IWM	ETF	124.185	124.34	124.09	124.26	787769.0
2015-05-28 14:00:00	IWM	ETF	124.27	124.47	124.21	124.44	972339.0
2015-05-28 15:00:00	IWM	ETF	124.44	124.69	124.38	124.67	2539354.0
2015-05-28 16:00:00	IWM	ETF	124.67	124.8	124.63	124.741	2850238.0
2015-05-28 17:00:00	IWM	ETF	124.74	124.75	124.72	124.72	4285.0
2015-05-28 07:00:00	DIA	ETF	181.05	181.05	181.05	181.05	100.0
2015-05-28 08:00:00	DIA	ETF	181.26	181.52	180.88	181.0	2584.0
2015-05-28 09:00:00	DIA	ETF	181.01	181.29	180.77	180.8	643486.0
2015-05-28 10:00:00	DIA	ETF	180.81	181.14	180.65	180.85	980021.0
2015-05-28 11:00:00	DIA	ETF	180.85	181.23	180.71	180.83	639142.0
2015-05-28 12:00:00	DIA	ETF	180.83	181.0526	180.74	180.91	334300.0
2015-05-28 13:00:00	DIA	ETF	180.89	181.11	180.81	180.97	277247.0
2015-05-28 14:00:00	DIA	ETF	180.98	181.27	180.88	181.24	253330.0
2015-05-28 15:00:00	DIA	ETF	181.22	181.33	181.09	181.3	397737.0

> showing 50 of 7,511 rows — these rows as CSV

> unlock the full archive -- $79 one-time