PREVIEW / etf_1hour / 2015-03-09

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-09.parquet
  size:    242 KB
  rows:    7,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
2015-03-09 04:00:00	SPY	ETF	207.5	207.5	207.49	207.49	255.0
2015-03-09 05:00:00	SPY	ETF	207.3	207.33	207.25	207.25	6565.0
2015-03-09 06:00:00	SPY	ETF	207.23	207.35	207.21	207.24	89300.0
2015-03-09 07:00:00	SPY	ETF	207.32	207.76	207.22	207.7	347537.0
2015-03-09 08:00:00	SPY	ETF	207.74	207.96	207.3	207.88	833668.0
2015-03-09 09:00:00	SPY	ETF	207.89	208.04	207.58	207.97	12837339.0
2015-03-09 10:00:00	SPY	ETF	207.96	208.25	207.79	208.07	11690381.0
2015-03-09 11:00:00	SPY	ETF	208.07	208.34	207.88	208.07	9693444.0
2015-03-09 12:00:00	SPY	ETF	208.07	208.32	207.86	208.2664	8223781.0
2015-03-09 13:00:00	SPY	ETF	208.27	208.79	208.18	208.62	7251257.0
2015-03-09 14:00:00	SPY	ETF	208.62	208.65	208.2	208.58	10297429.0
2015-03-09 15:00:00	SPY	ETF	208.57	208.695	208.32	208.38	18048474.0
2015-03-09 16:00:00	SPY	ETF	208.39	208.45	207.95	208.32	5406704.0
2015-03-09 17:00:00	SPY	ETF	208.36	208.36	208.27	208.3	170105.0
2015-03-09 18:00:00	SPY	ETF	208.3	208.31	208.2	208.22	72159.0
2015-03-09 19:00:00	SPY	ETF	208.22	208.22	208.16	208.2	101013.0
2015-03-09 04:00:00	QQQ	ETF	107.5	107.5	107.5	107.5	100.0
2015-03-09 05:00:00	QQQ	ETF	107.55	107.55	107.42	107.42	500.0
2015-03-09 06:00:00	QQQ	ETF	107.4	107.4	107.34	107.34	2200.0
2015-03-09 07:00:00	QQQ	ETF	107.4	107.62	107.4	107.62	70656.0
2015-03-09 08:00:00	QQQ	ETF	107.62	107.74	107.57	107.71	236962.0
2015-03-09 09:00:00	QQQ	ETF	107.71	107.73	107.19	107.55	2993897.0
2015-03-09 10:00:00	QQQ	ETF	107.54	107.62	107.3	107.39	3376374.0
2015-03-09 11:00:00	QQQ	ETF	107.39	107.65	107.26	107.44	2344134.0
2015-03-09 12:00:00	QQQ	ETF	107.45	107.54	107.28	107.48	1648295.0
2015-03-09 13:00:00	QQQ	ETF	107.49	107.9857	107.48	107.8311	2291885.0
2015-03-09 14:00:00	QQQ	ETF	107.83	107.89	107.3	107.6	3113800.0
2015-03-09 15:00:00	QQQ	ETF	107.61	107.91	107.585	107.7	4566136.0
2015-03-09 16:00:00	QQQ	ETF	107.7	107.8	107.6722	107.72	541598.0
2015-03-09 17:00:00	QQQ	ETF	107.711	107.711	107.711	107.711	100.0
2015-03-09 18:00:00	QQQ	ETF	107.73	107.75	107.69	107.7	4673.0
2015-03-09 19:00:00	QQQ	ETF	107.68	107.681	107.68	107.68	13700.0
2015-03-09 04:00:00	IWM	ETF	121.25	121.25	121.25	121.25	100.0
2015-03-09 05:00:00	IWM	ETF	121.19	121.19	121.19	121.19	257.0
2015-03-09 07:00:00	IWM	ETF	121.23	121.43	121.23	121.42	75764.0
2015-03-09 08:00:00	IWM	ETF	121.41	121.6	121.17	121.58	235816.0
2015-03-09 09:00:00	IWM	ETF	121.59	121.68	121.31	121.6	2606341.0
2015-03-09 10:00:00	IWM	ETF	121.59	121.67	121.181	121.39	2187547.0
2015-03-09 11:00:00	IWM	ETF	121.38	121.57	121.17	121.275	1994603.0
2015-03-09 12:00:00	IWM	ETF	121.28	121.52	121.12	121.46	1439546.0
2015-03-09 13:00:00	IWM	ETF	121.46	121.87	121.41	121.78	1743668.0
2015-03-09 14:00:00	IWM	ETF	121.78	121.855	121.5	121.6328	1494873.0
2015-03-09 15:00:00	IWM	ETF	121.64	121.92	121.58	121.68	3656073.0
2015-03-09 16:00:00	IWM	ETF	121.68	121.75	121.66	121.67	1590969.0
2015-03-09 17:00:00	IWM	ETF	121.75	121.75	121.75	121.75	1113.0
2015-03-09 18:00:00	IWM	ETF	121.7	121.7	121.68	121.68	500.0
2015-03-09 19:00:00	IWM	ETF	121.68	121.68	121.68	121.68	560.0
2015-03-09 08:00:00	DIA	ETF	178.94	178.94	178.79	178.8	400.0
2015-03-09 09:00:00	DIA	ETF	178.63	179.19	178.53	179.19	613487.0
2015-03-09 10:00:00	DIA	ETF	179.19	179.54	179.05	179.39	684216.0

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

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