PREVIEW / etf_1hour / 2014-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-06-19.parquet
  size:    221 KB
  rows:    7,023

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-19 04:00:00	SPY	ETF	196.36	196.36	196.31	196.31	1320.0
2014-06-19 05:00:00	SPY	ETF	196.53	196.53	196.28	196.36	2300.0
2014-06-19 06:00:00	SPY	ETF	196.36	196.38	196.24	196.27	4960.0
2014-06-19 07:00:00	SPY	ETF	196.3	196.33	196.24	196.28	43874.0
2014-06-19 08:00:00	SPY	ETF	196.28	196.48	196.26	196.4	559619.0
2014-06-19 09:00:00	SPY	ETF	196.4	196.6	196.275	196.32	8406869.0
2014-06-19 10:00:00	SPY	ETF	196.33	196.46	196.04	196.06	11656556.0
2014-06-19 11:00:00	SPY	ETF	196.05	196.21	195.99	196.165	12968094.0
2014-06-19 12:00:00	SPY	ETF	196.17	196.25	195.99	196.02	5869230.0
2014-06-19 13:00:00	SPY	ETF	196.03	196.15	195.8	196.1	11007446.0
2014-06-19 14:00:00	SPY	ETF	196.11	196.28	196.05	196.25	8068029.0
2014-06-19 15:00:00	SPY	ETF	196.25	196.54	196.23	196.49	17720201.0
2014-06-19 16:00:00	SPY	ETF	196.5	196.5378	196.35	196.37	9053472.0
2014-06-19 17:00:00	SPY	ETF	196.37	196.38	196.3	196.35	104162.0
2014-06-19 18:00:00	SPY	ETF	196.35	196.37	196.31	196.32	76978.0
2014-06-19 19:00:00	SPY	ETF	196.33	196.35	196.31	196.31	19710.0
2014-06-19 04:00:00	QQQ	ETF	92.93	92.93	92.93	92.93	100.0
2014-06-19 08:00:00	QQQ	ETF	93.05	93.11	93.02	93.09	171024.0
2014-06-19 09:00:00	QQQ	ETF	93.09	93.17	92.905	92.931	2792807.0
2014-06-19 10:00:00	QQQ	ETF	92.94	93.08	92.73	92.77	3669888.0
2014-06-19 11:00:00	QQQ	ETF	92.77	92.86	92.75	92.79	1777455.0
2014-06-19 12:00:00	QQQ	ETF	92.8	92.89	92.605	92.625	1621631.0
2014-06-19 13:00:00	QQQ	ETF	92.6201	92.68	92.49	92.62	2841504.0
2014-06-19 14:00:00	QQQ	ETF	92.625	92.825	92.58	92.79	1969094.0
2014-06-19 15:00:00	QQQ	ETF	92.8	92.94	92.79	92.91	3937559.0
2014-06-19 16:00:00	QQQ	ETF	92.92	93.0221	92.78	92.83	7043893.0
2014-06-19 17:00:00	QQQ	ETF	92.82	92.82	92.78	92.79	25565.0
2014-06-19 18:00:00	QQQ	ETF	92.78	92.8	92.78	92.8	4690.0
2014-06-19 19:00:00	QQQ	ETF	92.78	92.79	92.76	92.76	5010.0
2014-06-19 04:00:00	IWM	ETF	117.82	118.1	117.82	118.1	500.0
2014-06-19 06:00:00	IWM	ETF	118.0	118.0	118.0	118.0	100.0
2014-06-19 07:00:00	IWM	ETF	117.93	118.0	117.93	118.0	2680.0
2014-06-19 08:00:00	IWM	ETF	118.03	118.15	118.01	118.12	61172.0
2014-06-19 09:00:00	IWM	ETF	118.11	118.24	117.69	117.73	3899399.0
2014-06-19 10:00:00	IWM	ETF	117.74	117.96	117.44	117.44	5394612.0
2014-06-19 11:00:00	IWM	ETF	117.45	117.59	117.41	117.48	3731059.0
2014-06-19 12:00:00	IWM	ETF	117.49	117.635	117.2955	117.35	1995840.0
2014-06-19 13:00:00	IWM	ETF	117.35	117.45	117.1	117.4	2698762.0
2014-06-19 14:00:00	IWM	ETF	117.4	117.66	117.33	117.6	2824884.0
2014-06-19 15:00:00	IWM	ETF	117.6	117.88	117.54	117.862	5150985.0
2014-06-19 16:00:00	IWM	ETF	117.88	117.9772	117.54	117.54	868248.0
2014-06-19 17:00:00	IWM	ETF	117.76	117.77	117.66	117.69	15502.0
2014-06-19 18:00:00	IWM	ETF	117.67	117.67	117.67	117.67	100.0
2014-06-19 08:00:00	DIA	ETF	169.0	169.0	169.0	169.0	150.0
2014-06-19 09:00:00	DIA	ETF	169.0	169.19	168.7999	168.99	629598.0
2014-06-19 10:00:00	DIA	ETF	169.0	169.14	168.77	168.77	482581.0
2014-06-19 11:00:00	DIA	ETF	168.78	168.84	168.64	168.73	455191.0
2014-06-19 12:00:00	DIA	ETF	168.72	168.845	168.692	168.73	182694.0
2014-06-19 13:00:00	DIA	ETF	168.72	168.82	168.54	168.8	252885.0
2014-06-19 14:00:00	DIA	ETF	168.79	168.94	168.76	168.91	194317.0

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

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