PREVIEW / etf_1hour / 2014-04-01

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-04-01.parquet
  size:    218 KB
  rows:    6,939

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-04-01 04:00:00	SPY	ETF	187.2	187.28	187.17	187.24	30499.0
2014-04-01 05:00:00	SPY	ETF	187.23	187.25	187.18	187.22	4437.0
2014-04-01 06:00:00	SPY	ETF	187.2	187.49	187.18	187.47	73382.0
2014-04-01 07:00:00	SPY	ETF	187.45	187.47	187.33	187.46	218156.0
2014-04-01 08:00:00	SPY	ETF	187.37	187.5	187.34	187.4	527672.0
2014-04-01 09:00:00	SPY	ETF	187.41	188.0	187.04	187.96	15584735.0
2014-04-01 10:00:00	SPY	ETF	187.95	188.23	187.69	187.8	14207333.0
2014-04-01 11:00:00	SPY	ETF	187.8	187.89	187.58	187.6	9345730.0
2014-04-01 12:00:00	SPY	ETF	187.601	187.81	187.45	187.69	6902315.0
2014-04-01 13:00:00	SPY	ETF	187.69	187.88	187.51	187.86	6752530.0
2014-04-01 14:00:00	SPY	ETF	187.855	188.04	187.82	188.0001	9358807.0
2014-04-01 15:00:00	SPY	ETF	188.01	188.36	187.9	188.25	16784801.0
2014-04-01 16:00:00	SPY	ETF	188.25	188.38	187.0015	188.34	8156640.0
2014-04-01 17:00:00	SPY	ETF	188.34	188.34	188.26	188.28	480386.0
2014-04-01 18:00:00	SPY	ETF	188.28	188.36	188.22	188.26	122788.0
2014-04-01 19:00:00	SPY	ETF	188.27	188.3	188.23	188.29	111030.0
2014-04-01 04:00:00	QQQ	ETF	87.72	87.72	87.72	87.72	6300.0
2014-04-01 05:00:00	QQQ	ETF	87.73	87.73	87.73	87.73	1000.0
2014-04-01 06:00:00	QQQ	ETF	87.69	87.95	87.69	87.95	113920.0
2014-04-01 07:00:00	QQQ	ETF	87.93	87.97	87.83	87.97	203355.0
2014-04-01 08:00:00	QQQ	ETF	87.66	87.95	87.66	87.91	394258.0
2014-04-01 09:00:00	QQQ	ETF	87.92	88.79	87.67	88.74	6647149.0
2014-04-01 10:00:00	QQQ	ETF	88.73	89.04	88.72	88.91	6810928.0
2014-04-01 11:00:00	QQQ	ETF	88.89	88.94	88.74	88.76	3600712.0
2014-04-01 12:00:00	QQQ	ETF	88.76	88.85	88.66	88.75	2242467.0
2014-04-01 13:00:00	QQQ	ETF	88.74	88.88	88.61	88.859	3058462.0
2014-04-01 14:00:00	QQQ	ETF	88.85	89.0	88.83	88.99	2034691.0
2014-04-01 15:00:00	QQQ	ETF	88.98	89.27	88.905	89.21	5662414.0
2014-04-01 16:00:00	QQQ	ETF	89.21	89.28	87.7106	89.27	2476547.0
2014-04-01 17:00:00	QQQ	ETF	89.28	89.29	89.24	89.28	7600.0
2014-04-01 18:00:00	QQQ	ETF	89.27	89.28	89.22	89.22	16825.0
2014-04-01 19:00:00	QQQ	ETF	89.21	89.22	89.19	89.22	43959.0
2014-04-01 07:00:00	IWM	ETF	116.55	116.67	116.53	116.64	228260.0
2014-04-01 08:00:00	IWM	ETF	116.56	116.66	116.41	116.42	108890.0
2014-04-01 09:00:00	IWM	ETF	116.42	117.41	116.42	117.24	6917754.0
2014-04-01 10:00:00	IWM	ETF	117.21	117.79	117.11	117.27	7476979.0
2014-04-01 11:00:00	IWM	ETF	117.26	117.31	116.95	117.03	4501648.0
2014-04-01 12:00:00	IWM	ETF	117.03	117.2	116.91	117.07	3348450.0
2014-04-01 13:00:00	IWM	ETF	117.07	117.15	116.86	117.1333	2472922.0
2014-04-01 14:00:00	IWM	ETF	117.13	117.72	117.1	117.69	4298781.0
2014-04-01 15:00:00	IWM	ETF	117.69	118.06	117.585	117.9	10774805.0
2014-04-01 16:00:00	IWM	ETF	117.9	118.22	117.647	118.13	2654629.0
2014-04-01 17:00:00	IWM	ETF	118.1	118.12	118.05	118.05	8572.0
2014-04-01 18:00:00	IWM	ETF	118.06	118.12	118.06	118.07	16974.0
2014-04-01 19:00:00	IWM	ETF	118.08	118.15	118.06	118.15	19200.0
2014-04-01 06:00:00	DIA	ETF	164.46	164.46	164.46	164.46	100.0
2014-04-01 07:00:00	DIA	ETF	164.6	164.63	164.6	164.6	1500.0
2014-04-01 08:00:00	DIA	ETF	164.58	164.65	164.54	164.61	11108.0
2014-04-01 09:00:00	DIA	ETF	164.61	165.16	164.58	165.13	932254.0
2014-04-01 10:00:00	DIA	ETF	165.1	165.31	164.84	164.8881	842225.0

> showing 50 of 6,939 rows — these rows as CSV

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