PREVIEW / etf_1hour / 2014-06-12

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-12.parquet
  size:    218 KB
  rows:    6,850

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-06-12 04:00:00	SPY	ETF	195.11	195.19	195.07	195.19	1817.0
2014-06-12 05:00:00	SPY	ETF	195.15	195.28	195.05	195.28	4931.0
2014-06-12 06:00:00	SPY	ETF	195.22	195.22	195.01	195.05	33872.0
2014-06-12 07:00:00	SPY	ETF	195.07	195.16	195.03	195.07	128828.0
2014-06-12 08:00:00	SPY	ETF	195.16	195.16	194.56	194.76	939296.0
2014-06-12 09:00:00	SPY	ETF	194.77	194.8	194.41	194.5	8982644.0
2014-06-12 10:00:00	SPY	ETF	194.51	194.7	194.0	194.15	12190821.0
2014-06-12 11:00:00	SPY	ETF	194.16	194.49	194.085	194.229	8265724.0
2014-06-12 12:00:00	SPY	ETF	194.2201	194.42	193.92	194.05	7337974.0
2014-06-12 13:00:00	SPY	ETF	194.051	194.1	193.35	193.47	14018214.0
2014-06-12 14:00:00	SPY	ETF	193.47	193.69	193.39	193.46	9754223.0
2014-06-12 15:00:00	SPY	ETF	193.46	193.65	193.11	193.53	23269953.0
2014-06-12 16:00:00	SPY	ETF	193.53	194.9461	193.5	193.76	14658313.0
2014-06-12 17:00:00	SPY	ETF	193.77	193.77	193.7	193.71	74558.0
2014-06-12 18:00:00	SPY	ETF	193.76	193.79	193.6	193.62	69051.0
2014-06-12 19:00:00	SPY	ETF	193.64	193.68	193.49	193.49	154921.0
2014-06-12 04:00:00	QQQ	ETF	92.93	92.93	92.93	92.93	100.0
2014-06-12 06:00:00	QQQ	ETF	92.89	92.89	92.89	92.89	1274.0
2014-06-12 07:00:00	QQQ	ETF	92.91	92.91	92.91	92.91	31600.0
2014-06-12 08:00:00	QQQ	ETF	92.89	92.9	92.77	92.77	71929.0
2014-06-12 09:00:00	QQQ	ETF	92.75	92.79	92.49	92.65	3236268.0
2014-06-12 10:00:00	QQQ	ETF	92.64	92.78	92.29	92.43	4430882.0
2014-06-12 11:00:00	QQQ	ETF	92.435	92.64	92.38	92.485	2658143.0
2014-06-12 12:00:00	QQQ	ETF	92.485	92.56	92.201	92.3195	2238842.0
2014-06-12 13:00:00	QQQ	ETF	92.315	92.34	91.89	91.98	3851685.0
2014-06-12 14:00:00	QQQ	ETF	91.97	92.05	91.83	91.91	2870494.0
2014-06-12 15:00:00	QQQ	ETF	91.91	92.06	91.73	92.06	6217972.0
2014-06-12 16:00:00	QQQ	ETF	92.06	92.8569	92.0213	92.28	6688384.0
2014-06-12 17:00:00	QQQ	ETF	92.29	92.3	92.22	92.3	13696.0
2014-06-12 18:00:00	QQQ	ETF	92.28	92.3	92.26	92.27	18661.0
2014-06-12 19:00:00	QQQ	ETF	92.22	92.25	92.2	92.22	41213.0
2014-06-12 06:00:00	IWM	ETF	116.46	116.46	116.23	116.23	2100.0
2014-06-12 07:00:00	IWM	ETF	116.16	116.19	116.16	116.19	13200.0
2014-06-12 08:00:00	IWM	ETF	116.1	116.19	115.79	115.8	234490.0
2014-06-12 09:00:00	IWM	ETF	115.77	115.84	115.14	115.48	5029783.0
2014-06-12 10:00:00	IWM	ETF	115.48	115.82	115.15	115.46	4325846.0
2014-06-12 11:00:00	IWM	ETF	115.46	115.9199	115.35	115.65	3095531.0
2014-06-12 12:00:00	IWM	ETF	115.65	115.91	115.4	115.54	2913050.0
2014-06-12 13:00:00	IWM	ETF	115.54	115.61	114.91	115.05	5301708.0
2014-06-12 14:00:00	IWM	ETF	115.04	115.37	114.975	115.12	3507623.0
2014-06-12 15:00:00	IWM	ETF	115.12	115.4	114.925	115.4	6885368.0
2014-06-12 16:00:00	IWM	ETF	115.4	115.6884	114.995	115.52	1310557.0
2014-06-12 17:00:00	IWM	ETF	115.51	115.51	115.46	115.47	1315.0
2014-06-12 18:00:00	IWM	ETF	115.47	115.47	115.44	115.47	700.0
2014-06-12 19:00:00	IWM	ETF	115.44	115.45	115.41	115.41	772.0
2014-06-12 07:00:00	DIA	ETF	168.58	168.58	168.57	168.57	1900.0
2014-06-12 08:00:00	DIA	ETF	168.62	168.62	168.38	168.38	4317.0
2014-06-12 09:00:00	DIA	ETF	168.23	168.34	167.97	168.04	884366.0
2014-06-12 10:00:00	DIA	ETF	168.0428	168.2	167.6772	167.73	455178.0
2014-06-12 11:00:00	DIA	ETF	167.73	168.01	167.67	167.79	236519.0

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

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