PREVIEW / etf_1hour / 2015-03-26

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-26.parquet
  size:    243 KB
  rows:    7,780

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-03-26 04:00:00	SPY	ETF	205.49	205.49	204.29	204.29	51170.0
2015-03-26 05:00:00	SPY	ETF	204.3	204.38	203.84	204.17	263421.0
2015-03-26 06:00:00	SPY	ETF	204.14	204.56	204.06	204.44	158580.0
2015-03-26 07:00:00	SPY	ETF	204.45	204.68	204.23	204.39	686218.0
2015-03-26 08:00:00	SPY	ETF	204.36	205.85	204.0	204.79	1664715.0
2015-03-26 09:00:00	SPY	ETF	204.81	205.76	204.5	204.79	20855937.0
2015-03-26 10:00:00	SPY	ETF	204.78	205.3824	204.12	205.23	27290039.0
2015-03-26 11:00:00	SPY	ETF	205.23	205.82	204.69	205.81	17046312.0
2015-03-26 12:00:00	SPY	ETF	205.82	205.9	205.249	205.77	13447236.0
2015-03-26 13:00:00	SPY	ETF	205.76	206.37	205.17	206.17	13211828.0
2015-03-26 14:00:00	SPY	ETF	206.17	206.22	205.37	205.39	14984529.0
2015-03-26 15:00:00	SPY	ETF	205.37	205.9	205.17	205.28	27558798.0
2015-03-26 16:00:00	SPY	ETF	205.28	205.6941	205.105	205.45	11427165.0
2015-03-26 17:00:00	SPY	ETF	205.45	205.48	205.41	205.45	103418.0
2015-03-26 18:00:00	SPY	ETF	205.46	205.54	205.43	205.46	53001.0
2015-03-26 19:00:00	SPY	ETF	205.43	205.5	205.39	205.5	85895.0
2015-03-26 04:00:00	QQQ	ETF	105.1	105.1	104.6	104.6	10054.0
2015-03-26 05:00:00	QQQ	ETF	104.61	104.61	104.2	104.35	66650.0
2015-03-26 06:00:00	QQQ	ETF	104.25	104.44	104.23	104.41	85539.0
2015-03-26 07:00:00	QQQ	ETF	104.38	104.49	104.31	104.39	119941.0
2015-03-26 08:00:00	QQQ	ETF	104.39	105.27	104.22	104.63	757748.0
2015-03-26 09:00:00	QQQ	ETF	104.62	105.24	104.24	104.58	11382237.0
2015-03-26 10:00:00	QQQ	ETF	104.57	105.06	104.25	105.06	8017463.0
2015-03-26 11:00:00	QQQ	ETF	105.05	105.37	104.73	105.37	4863044.0
2015-03-26 12:00:00	QQQ	ETF	105.37	105.44	105.0	105.35	3106417.0
2015-03-26 13:00:00	QQQ	ETF	105.35	105.7	105.0	105.57	3388856.0
2015-03-26 14:00:00	QQQ	ETF	105.57	105.6099	105.17	105.18	3307108.0
2015-03-26 15:00:00	QQQ	ETF	105.17	105.44	105.06	105.11	5397337.0
2015-03-26 16:00:00	QQQ	ETF	105.1	105.27	104.8117	105.26	1577083.0
2015-03-26 17:00:00	QQQ	ETF	105.27	105.28	105.1	105.22	837170.0
2015-03-26 18:00:00	QQQ	ETF	105.26	105.33	105.26	105.3	27261.0
2015-03-26 19:00:00	QQQ	ETF	105.28	105.3	105.25	105.3	4191.0
2015-03-26 04:00:00	IWM	ETF	121.89	121.89	121.86	121.86	200.0
2015-03-26 05:00:00	IWM	ETF	121.7	121.7	121.65	121.65	500.0
2015-03-26 06:00:00	IWM	ETF	121.66	121.9	121.66	121.8	1040.0
2015-03-26 07:00:00	IWM	ETF	121.71	121.89	121.71	121.71	10400.0
2015-03-26 08:00:00	IWM	ETF	121.73	122.15	121.53	122.13	283588.0
2015-03-26 09:00:00	IWM	ETF	122.1	122.5	121.9	121.92	4460444.0
2015-03-26 10:00:00	IWM	ETF	121.919	122.36	121.54	122.16	4809898.0
2015-03-26 11:00:00	IWM	ETF	122.16	122.286	121.635	122.2769	2778569.0
2015-03-26 12:00:00	IWM	ETF	122.28	122.34	121.93	122.2935	1638320.0
2015-03-26 13:00:00	IWM	ETF	122.3	122.91	122.14	122.76	2048361.0
2015-03-26 14:00:00	IWM	ETF	122.755	122.8	122.14	122.15	2000133.0
2015-03-26 15:00:00	IWM	ETF	122.145	122.39	122.065	122.32	3226275.0
2015-03-26 16:00:00	IWM	ETF	122.32	122.46	122.21	122.3	693665.0
2015-03-26 17:00:00	IWM	ETF	122.28	122.32	122.28	122.32	691400.0
2015-03-26 18:00:00	IWM	ETF	122.3	122.4	122.27	122.4	4564.0
2015-03-26 19:00:00	IWM	ETF	122.42	122.43	122.3	122.3	2153.0
2015-03-26 04:00:00	DIA	ETF	176.54	176.54	176.54	176.54	145.0
2015-03-26 05:00:00	DIA	ETF	175.5	175.5	175.5	175.5	5000.0

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

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