PREVIEW / etf_1hour / 2015-09-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-23.parquet
  size:    238 KB
  rows:    7,574

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
2015-09-23 04:00:00	SPY	ETF	193.58	194.65	193.5	194.4	83886.0
2015-09-23 05:00:00	SPY	ETF	194.43	194.57	194.2	194.44	36062.0
2015-09-23 06:00:00	SPY	ETF	194.33	194.5	194.05	194.49	29107.0
2015-09-23 07:00:00	SPY	ETF	194.53	194.97	193.91	194.14	472372.0
2015-09-23 08:00:00	SPY	ETF	194.14	194.97	192.22	194.24	941970.0
2015-09-23 09:00:00	SPY	ETF	194.23	194.4	193.43	193.83	10473593.0
2015-09-23 10:00:00	SPY	ETF	193.82	194.67	193.76	194.43	10673544.0
2015-09-23 11:00:00	SPY	ETF	194.435	194.48	193.05	193.27	16394467.0
2015-09-23 12:00:00	SPY	ETF	193.27	193.4	192.91	193.33	9729633.0
2015-09-23 13:00:00	SPY	ETF	193.33	194.03	193.11	193.795	10050085.0
2015-09-23 14:00:00	SPY	ETF	193.79	194.255	193.35	193.5575	9497427.0
2015-09-23 15:00:00	SPY	ETF	193.55	193.9	193.28	193.57	17383976.0
2015-09-23 16:00:00	SPY	ETF	193.58	193.96	193.51	193.94	3748125.0
2015-09-23 17:00:00	SPY	ETF	193.93	193.95	193.89	193.95	158054.0
2015-09-23 18:00:00	SPY	ETF	193.95	194.18	193.88	193.88	104834.0
2015-09-23 19:00:00	SPY	ETF	193.88	193.98	193.7	193.76	106138.0
2015-09-23 04:00:00	QQQ	ETF	104.14	104.7	104.14	104.63	53150.0
2015-09-23 05:00:00	QQQ	ETF	104.6	104.64	104.46	104.56	40550.0
2015-09-23 06:00:00	QQQ	ETF	104.56	104.58	104.4	104.58	12690.0
2015-09-23 07:00:00	QQQ	ETF	104.6	104.86	104.34	104.41	146894.0
2015-09-23 08:00:00	QQQ	ETF	104.44	104.71	104.37	104.52	151472.0
2015-09-23 09:00:00	QQQ	ETF	104.5	104.56	103.775	104.06	3177186.0
2015-09-23 10:00:00	QQQ	ETF	104.08	104.66	104.04	104.56	3083904.0
2015-09-23 11:00:00	QQQ	ETF	104.56	104.61	103.73	103.91	2869812.0
2015-09-23 12:00:00	QQQ	ETF	103.91	104.11	103.64	104.07	1832971.0
2015-09-23 13:00:00	QQQ	ETF	104.06	104.38	103.87	104.31	2077761.0
2015-09-23 14:00:00	QQQ	ETF	104.3	104.595	103.99	104.08	2618756.0
2015-09-23 15:00:00	QQQ	ETF	104.08	104.37	103.94	104.14	3459871.0
2015-09-23 16:00:00	QQQ	ETF	104.14	104.28	104.11	104.27	495197.0
2015-09-23 17:00:00	QQQ	ETF	104.28	104.3	104.19	104.19	15425.0
2015-09-23 18:00:00	QQQ	ETF	104.27	104.46	104.25	104.4	24936.0
2015-09-23 19:00:00	QQQ	ETF	104.3	104.31	104.2	104.22	14200.0
2015-09-23 04:00:00	IWM	ETF	113.68	113.75	113.68	113.75	1199.0
2015-09-23 06:00:00	IWM	ETF	114.24	114.24	114.24	114.24	100.0
2015-09-23 07:00:00	IWM	ETF	114.31	114.52	114.06	114.1	118046.0
2015-09-23 08:00:00	IWM	ETF	114.06	114.29	114.06	114.14	43538.0
2015-09-23 09:00:00	IWM	ETF	114.11	114.14	113.54	113.84	1867850.0
2015-09-23 10:00:00	IWM	ETF	113.84	114.42	113.77	114.2	2613914.0
2015-09-23 11:00:00	IWM	ETF	114.21	114.26	113.19	113.3699	2774782.0
2015-09-23 12:00:00	IWM	ETF	113.36	113.52	113.07	113.46	2106802.0
2015-09-23 13:00:00	IWM	ETF	113.47	113.74	113.25	113.61	1843946.0
2015-09-23 14:00:00	IWM	ETF	113.62	113.91	113.16	113.27	2994926.0
2015-09-23 15:00:00	IWM	ETF	113.27	113.62	113.18	113.46	3427327.0
2015-09-23 16:00:00	IWM	ETF	113.46	113.5329	113.31	113.49	1460353.0
2015-09-23 17:00:00	IWM	ETF	113.53	113.53	113.42	113.42	927309.0
2015-09-23 18:00:00	IWM	ETF	113.59	113.59	113.59	113.59	9800.0
2015-09-23 19:00:00	IWM	ETF	113.57	113.67	113.57	113.57	15399.0
2015-09-23 04:00:00	DIA	ETF	163.38	163.41	163.38	163.41	200.0
2015-09-23 07:00:00	DIA	ETF	163.77	164.0	163.31	163.31	980.0
2015-09-23 08:00:00	DIA	ETF	163.58	163.66	162.584	163.41	30800.0

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

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