PREVIEW / etf_1hour / 2014-06-06

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-06.parquet
  size:    214 KB
  rows:    6,828

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-06 04:00:00	SPY	ETF	194.46	194.61	194.46	194.61	4301.0
2014-06-06 05:00:00	SPY	ETF	194.59	194.72	194.51	194.65	4920.0
2014-06-06 06:00:00	SPY	ETF	194.68	194.71	194.62	194.65	74725.0
2014-06-06 07:00:00	SPY	ETF	194.66	194.66	194.5	194.55	234717.0
2014-06-06 08:00:00	SPY	ETF	194.56	194.96	194.45	194.88	2427926.0
2014-06-06 09:00:00	SPY	ETF	194.87	195.19	194.75	195.18	9864825.0
2014-06-06 10:00:00	SPY	ETF	195.19	195.29	195.04	195.26	10419585.0
2014-06-06 11:00:00	SPY	ETF	195.26	195.4	195.18	195.22	7465191.0
2014-06-06 12:00:00	SPY	ETF	195.23	195.43	195.21	195.34	5177005.0
2014-06-06 13:00:00	SPY	ETF	195.34	195.4	195.23	195.33	4118629.0
2014-06-06 14:00:00	SPY	ETF	195.33	195.39	195.22	195.24	5338246.0
2014-06-06 15:00:00	SPY	ETF	195.24	195.38	195.09	195.38	18470875.0
2014-06-06 16:00:00	SPY	ETF	195.37	195.55	195.35	195.52	14255723.0
2014-06-06 17:00:00	SPY	ETF	195.52	195.58	195.52	195.57	128229.0
2014-06-06 18:00:00	SPY	ETF	195.55	195.61	195.55	195.56	13853.0
2014-06-06 19:00:00	SPY	ETF	195.59	195.63	195.56	195.59	21289.0
2014-06-06 04:00:00	QQQ	ETF	92.43	92.43	92.43	92.43	100.0
2014-06-06 06:00:00	QQQ	ETF	92.45	92.47	92.45	92.47	600.0
2014-06-06 07:00:00	QQQ	ETF	92.45	92.45	92.4	92.41	7500.0
2014-06-06 08:00:00	QQQ	ETF	92.39	92.65	92.33	92.64	457037.0
2014-06-06 09:00:00	QQQ	ETF	92.64	92.7	92.45	92.67	4233141.0
2014-06-06 10:00:00	QQQ	ETF	92.67	92.685	92.45	92.6499	3410287.0
2014-06-06 11:00:00	QQQ	ETF	92.65	92.7601	92.62	92.64	2436617.0
2014-06-06 12:00:00	QQQ	ETF	92.64	92.74	92.61	92.68	1112115.0
2014-06-06 13:00:00	QQQ	ETF	92.69	92.7	92.5301	92.62	1580211.0
2014-06-06 14:00:00	QQQ	ETF	92.62	92.72	92.59	92.68	1555430.0
2014-06-06 15:00:00	QQQ	ETF	92.6865	92.79	92.59	92.78	3758313.0
2014-06-06 16:00:00	QQQ	ETF	92.79	92.88	92.3272	92.88	1764562.0
2014-06-06 17:00:00	QQQ	ETF	92.88	92.89	92.87	92.87	19100.0
2014-06-06 18:00:00	QQQ	ETF	92.88	92.89	92.82	92.82	11732.0
2014-06-06 19:00:00	QQQ	ETF	92.82	92.88	92.79	92.88	6365.0
2014-06-06 05:00:00	IWM	ETF	115.0	115.02	115.0	115.02	1191.0
2014-06-06 07:00:00	IWM	ETF	115.0	115.01	114.83	114.95	11700.0
2014-06-06 08:00:00	IWM	ETF	114.9	115.36	114.5	115.23	492018.0
2014-06-06 09:00:00	IWM	ETF	115.18	115.84	115.11	115.81	7381644.0
2014-06-06 10:00:00	IWM	ETF	115.81	116.01	115.68	116.0	6600220.0
2014-06-06 11:00:00	IWM	ETF	116.005	116.24	115.86	115.89	5892679.0
2014-06-06 12:00:00	IWM	ETF	115.9	116.08	115.77	115.9565	3795146.0
2014-06-06 13:00:00	IWM	ETF	115.96	115.99	115.78	115.86	2547154.0
2014-06-06 14:00:00	IWM	ETF	115.85	115.92	115.76	115.81	2549873.0
2014-06-06 15:00:00	IWM	ETF	115.81	115.98	115.77	115.92	5975239.0
2014-06-06 16:00:00	IWM	ETF	115.92	116.13	115.6	116.13	3414419.0
2014-06-06 17:00:00	IWM	ETF	116.12	116.14	116.06	116.1	18575.0
2014-06-06 18:00:00	IWM	ETF	116.15	116.17	116.06	116.17	7545.0
2014-06-06 19:00:00	IWM	ETF	116.17	116.19	116.17	116.19	5506.0
2014-06-06 08:00:00	DIA	ETF	168.35	168.74	168.35	168.64	1297731.0
2014-06-06 09:00:00	DIA	ETF	168.65	168.87	168.46	168.86	545672.0
2014-06-06 10:00:00	DIA	ETF	168.87	168.98	168.78	168.93	545783.0
2014-06-06 11:00:00	DIA	ETF	168.91	168.96	168.83	168.87	258216.0
2014-06-06 12:00:00	DIA	ETF	168.86	169.04	168.86	168.98	343097.0

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

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