PREVIEW / etf_1hour / 2015-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-09-11.parquet
  size:    233 KB
  rows:    7,443

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-11 04:00:00	SPY	ETF	195.68	195.68	194.54	194.7	29924.0
2015-09-11 05:00:00	SPY	ETF	194.56	195.36	194.54	195.33	73905.0
2015-09-11 06:00:00	SPY	ETF	195.4	195.47	194.76	194.76	51344.0
2015-09-11 07:00:00	SPY	ETF	194.8	195.3	194.6	195.2	177813.0
2015-09-11 08:00:00	SPY	ETF	195.19	196.45	194.62	194.82	1161927.0
2015-09-11 09:00:00	SPY	ETF	194.88	195.52	194.65	194.72	12843964.0
2015-09-11 10:00:00	SPY	ETF	194.7	195.27	194.53	194.801	12941621.0
2015-09-11 11:00:00	SPY	ETF	194.81	195.79	194.71	195.66	12231371.0
2015-09-11 12:00:00	SPY	ETF	195.665	196.33	195.62	196.14	10451444.0
2015-09-11 13:00:00	SPY	ETF	196.15	196.195	195.3	195.63	12293468.0
2015-09-11 14:00:00	SPY	ETF	195.62	196.26	195.35	196.04	12199414.0
2015-09-11 15:00:00	SPY	ETF	196.04	196.77	196.03	196.77	26973104.0
2015-09-11 16:00:00	SPY	ETF	196.76	197.0	196.67	196.9	16486584.0
2015-09-11 17:00:00	SPY	ETF	196.9	197.09	196.84	197.09	264080.0
2015-09-11 18:00:00	SPY	ETF	197.08	197.19	197.0	197.08	71368.0
2015-09-11 19:00:00	SPY	ETF	197.08	197.25	197.07	197.17	28870.0
2015-09-11 04:00:00	QQQ	ETF	104.51	104.51	104.11	104.12	10650.0
2015-09-11 05:00:00	QQQ	ETF	104.27	104.53	104.27	104.49	4291.0
2015-09-11 06:00:00	QQQ	ETF	104.45	104.55	104.26	104.26	2630.0
2015-09-11 07:00:00	QQQ	ETF	104.33	104.53	104.22	104.48	6710.0
2015-09-11 08:00:00	QQQ	ETF	104.46	104.68	104.26	104.32	142877.0
2015-09-11 09:00:00	QQQ	ETF	104.29	104.7699	104.25	104.32	4055251.0
2015-09-11 10:00:00	QQQ	ETF	104.32	104.67	104.21	104.38	4051122.0
2015-09-11 11:00:00	QQQ	ETF	104.38	104.88	104.25	104.81	3554916.0
2015-09-11 12:00:00	QQQ	ETF	104.82	105.29	104.79	105.19	2890085.0
2015-09-11 13:00:00	QQQ	ETF	105.2	105.2101	104.73	104.92	1913730.0
2015-09-11 14:00:00	QQQ	ETF	104.92	105.35	104.746	105.24	2387493.0
2015-09-11 15:00:00	QQQ	ETF	105.23	105.54	105.22	105.54	4336315.0
2015-09-11 16:00:00	QQQ	ETF	105.54	105.72	105.4607	105.7	1025809.0
2015-09-11 17:00:00	QQQ	ETF	105.71	105.76	105.63	105.69	67861.0
2015-09-11 18:00:00	QQQ	ETF	105.7	105.75	105.69	105.69	23045.0
2015-09-11 19:00:00	QQQ	ETF	105.73	105.75	105.67	105.67	14145.0
2015-09-11 04:00:00	IWM	ETF	113.98	113.98	113.98	113.98	100.0
2015-09-11 06:00:00	IWM	ETF	113.99	113.99	113.98	113.98	200.0
2015-09-11 07:00:00	IWM	ETF	113.86	114.22	113.86	114.22	8250.0
2015-09-11 08:00:00	IWM	ETF	114.19	114.31	113.88	113.92	270489.0
2015-09-11 09:00:00	IWM	ETF	113.95	114.29	113.82	113.88	2668736.0
2015-09-11 10:00:00	IWM	ETF	113.87	114.11	113.66	113.75	3476544.0
2015-09-11 11:00:00	IWM	ETF	113.78	114.68	113.69	114.48	4027381.0
2015-09-11 12:00:00	IWM	ETF	114.48	115.11	114.46	114.88	2537601.0
2015-09-11 13:00:00	IWM	ETF	114.89	114.9	114.33	114.5199	1588684.0
2015-09-11 14:00:00	IWM	ETF	114.52	114.83	114.39	114.69	2369934.0
2015-09-11 15:00:00	IWM	ETF	114.7	115.2	114.5014	115.2	4980870.0
2015-09-11 16:00:00	IWM	ETF	115.19	115.53	114.8676	115.53	749669.0
2015-09-11 17:00:00	IWM	ETF	115.5	115.53	115.4	115.4	57900.0
2015-09-11 18:00:00	IWM	ETF	115.41	115.54	115.41	115.5	7525.0
2015-09-11 19:00:00	IWM	ETF	115.5	115.51	115.5	115.5	4395.0
2015-09-11 04:00:00	DIA	ETF	162.4	162.5	162.4	162.5	400.0
2015-09-11 05:00:00	DIA	ETF	162.5	162.5	162.5	162.5	100.0
2015-09-11 07:00:00	DIA	ETF	162.89	162.89	162.8	162.8	4225.0

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

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