PREVIEW / etf_1hour / 2014-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2014/2014-07-03.parquet
  size:    152 KB
  rows:    4,827

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-07-03 04:00:00	SPY	ETF	197.38	197.38	197.38	197.38	183.0
2014-07-03 05:00:00	SPY	ETF	197.32	197.45	197.24	197.4	2100.0
2014-07-03 06:00:00	SPY	ETF	197.46	197.46	197.42	197.43	1994.0
2014-07-03 07:00:00	SPY	ETF	197.44	197.53	197.42	197.45	130550.0
2014-07-03 08:00:00	SPY	ETF	197.45	197.84	197.14	197.78	2201516.0
2014-07-03 09:00:00	SPY	ETF	197.78	197.99	197.64	197.795	9591670.0
2014-07-03 10:00:00	SPY	ETF	197.79	197.97	197.665	197.9	7624857.0
2014-07-03 11:00:00	SPY	ETF	197.9	198.15	197.85	198.13	6514923.0
2014-07-03 12:00:00	SPY	ETF	198.129	198.29	198.06	198.24	15579139.0
2014-07-03 13:00:00	SPY	ETF	198.24	198.27	197.226	198.13	4108152.0
2014-07-03 14:00:00	SPY	ETF	198.13	198.15	198.02	198.07	161764.0
2014-07-03 15:00:00	SPY	ETF	198.12	198.12	198.02	198.05	33187.0
2014-07-03 16:00:00	SPY	ETF	198.08	198.08	198.05	198.05	12048.0
2014-07-03 04:00:00	QQQ	ETF	95.11	95.11	95.11	95.11	350.0
2014-07-03 07:00:00	QQQ	ETF	95.22	95.22	95.2	95.2	1600.0
2014-07-03 08:00:00	QQQ	ETF	95.18	95.41	95.11	95.38	350813.0
2014-07-03 09:00:00	QQQ	ETF	95.39	95.43	95.15	95.271	3564558.0
2014-07-03 10:00:00	QQQ	ETF	95.27	95.43	95.23	95.41	3032330.0
2014-07-03 11:00:00	QQQ	ETF	95.42	95.56	95.37	95.56	2405094.0
2014-07-03 12:00:00	QQQ	ETF	95.56	95.68	95.54	95.65	3850309.0
2014-07-03 13:00:00	QQQ	ETF	95.66	95.75	95.1141	95.6999	1800397.0
2014-07-03 14:00:00	QQQ	ETF	95.7	95.7	95.62	95.63	6647.0
2014-07-03 15:00:00	QQQ	ETF	95.62	95.7	95.62	95.69	4026.0
2014-07-03 16:00:00	QQQ	ETF	95.64	95.7	95.64	95.66	1058.0
2014-07-03 08:00:00	IWM	ETF	119.27	119.54	118.94	119.54	544506.0
2014-07-03 09:00:00	IWM	ETF	119.56	119.83	119.25	119.4	3459412.0
2014-07-03 10:00:00	IWM	ETF	119.42	119.85	119.32	119.85	3493342.0
2014-07-03 11:00:00	IWM	ETF	119.85	119.91	119.7	119.77	2278739.0
2014-07-03 12:00:00	IWM	ETF	119.78	119.85	119.7	119.79	3514624.0
2014-07-03 13:00:00	IWM	ETF	119.79	119.86	119.645	119.7	733017.0
2014-07-03 14:00:00	IWM	ETF	119.8	119.8	119.6	119.6	1410.0
2014-07-03 16:00:00	IWM	ETF	119.66	119.68	119.66	119.68	200.0
2014-07-03 08:00:00	DIA	ETF	169.5	169.85	169.41	169.78	61912.0
2014-07-03 09:00:00	DIA	ETF	169.78	170.19	169.72	170.05	672589.0
2014-07-03 10:00:00	DIA	ETF	170.05	170.2	169.92	170.08	309684.0
2014-07-03 11:00:00	DIA	ETF	170.09	170.28	170.01	170.277	287569.0
2014-07-03 12:00:00	DIA	ETF	170.28	170.39	170.06	170.33	638310.0
2014-07-03 13:00:00	DIA	ETF	170.32	170.5	170.08	170.47	68648.0
2014-07-03 14:00:00	DIA	ETF	170.2	170.2	170.2	170.2	307.0
2014-07-03 07:00:00	GLD	ETF	126.94	127.06	126.91	127.04	12450.0
2014-07-03 08:00:00	GLD	ETF	127.08	127.16	126.01	126.69	237119.0
2014-07-03 09:00:00	GLD	ETF	126.73	127.11	126.61	126.87	953470.0
2014-07-03 10:00:00	GLD	ETF	126.87	127.29	126.75	127.15	1107651.0
2014-07-03 11:00:00	GLD	ETF	127.168	127.18	126.69	126.98	684616.0
2014-07-03 12:00:00	GLD	ETF	126.97	127.14	126.97	127.05	1073311.0
2014-07-03 13:00:00	GLD	ETF	127.03	127.19	127.0	127.07	261323.0
2014-07-03 14:00:00	GLD	ETF	127.0999	127.0999	127.02	127.02	2386.0
2014-07-03 07:00:00	TLT	ETF	111.02	111.08	111.02	111.03	6161.0
2014-07-03 08:00:00	TLT	ETF	111.04	111.23	110.13	110.37	569961.0
2014-07-03 09:00:00	TLT	ETF	110.35	110.56	110.3	110.49	1378085.0

> showing 50 of 4,827 rows — these rows as CSV

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