PREVIEW / etf_1hour / 2015-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-12-07.parquet
  size:    246 KB
  rows:    7,834

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-12-07 04:00:00	SPY	ETF	209.9	210.25	209.86	210.06	50463.0
2015-12-07 05:00:00	SPY	ETF	209.95	210.08	209.91	210.04	6040.0
2015-12-07 06:00:00	SPY	ETF	209.95	210.04	209.78	209.95	43147.0
2015-12-07 07:00:00	SPY	ETF	210.0	210.15	209.85	209.87	198849.0
2015-12-07 08:00:00	SPY	ETF	210.0	210.08	209.08	209.16	988998.0
2015-12-07 09:00:00	SPY	ETF	209.15	209.32	208.575	208.6445	15571024.0
2015-12-07 10:00:00	SPY	ETF	208.64	208.68	207.5	207.8002	19859315.0
2015-12-07 11:00:00	SPY	ETF	207.8	209.7295	207.2	208.08	13923319.0
2015-12-07 12:00:00	SPY	ETF	208.08	208.11	207.32	207.4799	8645412.0
2015-12-07 13:00:00	SPY	ETF	207.48	209.7295	207.285	207.84	9155998.0
2015-12-07 14:00:00	SPY	ETF	207.835	208.19	207.55	207.575	8607007.0
2015-12-07 15:00:00	SPY	ETF	207.58	209.7295	207.34	208.29	18895097.0
2015-12-07 16:00:00	SPY	ETF	208.29	208.92	208.27	208.85	5073615.0
2015-12-07 17:00:00	SPY	ETF	208.81	208.85	208.71	208.71	172032.0
2015-12-07 18:00:00	SPY	ETF	208.71	208.85	208.6	208.6	193463.0
2015-12-07 19:00:00	SPY	ETF	208.6	208.62	208.48	208.52	79856.0
2015-12-07 05:00:00	QQQ	ETF	115.33	115.33	115.33	115.33	500.0
2015-12-07 06:00:00	QQQ	ETF	115.32	115.32	115.32	115.32	300.0
2015-12-07 07:00:00	QQQ	ETF	115.33	115.45	115.33	115.38	39710.0
2015-12-07 08:00:00	QQQ	ETF	115.31	115.39	115.05	115.1	148016.0
2015-12-07 09:00:00	QQQ	ETF	115.1	115.29	114.64	114.82	3948729.0
2015-12-07 10:00:00	QQQ	ETF	114.82	114.89	114.28	114.43	4342937.0
2015-12-07 11:00:00	QQQ	ETF	114.43	114.65	114.09	114.58	3607532.0
2015-12-07 12:00:00	QQQ	ETF	114.57	115.1688	114.14	114.165	2107873.0
2015-12-07 13:00:00	QQQ	ETF	114.175	114.49	114.07	114.435	2797597.0
2015-12-07 14:00:00	QQQ	ETF	114.44	114.684	114.199	114.21	2339019.0
2015-12-07 15:00:00	QQQ	ETF	114.205	115.1688	114.08	114.62	4589205.0
2015-12-07 16:00:00	QQQ	ETF	114.6	114.86	114.6	114.84	802254.0
2015-12-07 17:00:00	QQQ	ETF	114.8	114.81	114.78	114.78	7475.0
2015-12-07 18:00:00	QQQ	ETF	114.77	114.85	114.75	114.75	3444.0
2015-12-07 19:00:00	QQQ	ETF	114.69	114.69	114.62	114.62	8974.0
2015-12-07 07:00:00	IWM	ETF	118.0	118.15	118.0	118.08	4000.0
2015-12-07 08:00:00	IWM	ETF	118.04	118.04	117.59	117.63	115878.0
2015-12-07 09:00:00	IWM	ETF	117.65	117.72	116.54	116.57	3679524.0
2015-12-07 10:00:00	IWM	ETF	116.57	116.71	116.08	116.27	4691829.0
2015-12-07 11:00:00	IWM	ETF	116.25	116.74	116.0	116.65	2873078.0
2015-12-07 12:00:00	IWM	ETF	116.65	116.65	115.58	115.775	3076607.0
2015-12-07 13:00:00	IWM	ETF	115.78	116.15	115.5139	115.77	3238137.0
2015-12-07 14:00:00	IWM	ETF	115.77	115.99	115.56	115.63	3133701.0
2015-12-07 15:00:00	IWM	ETF	115.635	116.01	115.54	115.96	5869081.0
2015-12-07 16:00:00	IWM	ETF	115.97	116.5	115.96	116.2	660739.0
2015-12-07 17:00:00	IWM	ETF	116.2	116.25	116.19	116.19	14396.0
2015-12-07 18:00:00	IWM	ETF	116.17	116.25	116.16	116.22	2185.0
2015-12-07 19:00:00	IWM	ETF	116.15	116.15	116.15	116.15	100.0
2015-12-07 06:00:00	DIA	ETF	178.6	178.6	178.6	178.6	300.0
2015-12-07 07:00:00	DIA	ETF	178.6	178.6	178.6	178.6	200.0
2015-12-07 08:00:00	DIA	ETF	178.4	178.4	177.89	177.89	2254.0
2015-12-07 09:00:00	DIA	ETF	178.06	178.08	177.57	177.63	1158310.0
2015-12-07 10:00:00	DIA	ETF	177.62	177.67	176.56	176.88	1313471.0
2015-12-07 11:00:00	DIA	ETF	176.86	177.25	176.42	177.2	599653.0

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

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