PREVIEW / etf_1hour / 2015-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-11-05.parquet
  size:    240 KB
  rows:    7,629

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-11-05 04:00:00	SPY	ETF	210.12	210.39	210.12	210.29	2285.0
2015-11-05 05:00:00	SPY	ETF	210.33	210.7	210.33	210.55	10162.0
2015-11-05 06:00:00	SPY	ETF	210.55	210.89	210.5	210.72	46153.0
2015-11-05 07:00:00	SPY	ETF	210.74	211.12	210.72	211.05	362826.0
2015-11-05 08:00:00	SPY	ETF	210.43	211.04	210.23	210.67	775232.0
2015-11-05 09:00:00	SPY	ETF	210.67	210.89	210.21	210.8611	9141448.0
2015-11-05 10:00:00	SPY	ETF	210.86	210.98	209.09	209.415	17960831.0
2015-11-05 11:00:00	SPY	ETF	209.415	210.13	209.26	210.09	11551357.0
2015-11-05 12:00:00	SPY	ETF	210.09	210.41	209.86	210.38	6692831.0
2015-11-05 13:00:00	SPY	ETF	210.39	210.47	209.95	210.19	5083515.0
2015-11-05 14:00:00	SPY	ETF	210.19	210.33	209.63	209.92	7649883.0
2015-11-05 15:00:00	SPY	ETF	209.92	210.4	209.66	210.12	13171741.0
2015-11-05 16:00:00	SPY	ETF	210.12	210.23	209.93	210.21	4968046.0
2015-11-05 17:00:00	SPY	ETF	210.17	210.2335	210.1	210.15	137334.0
2015-11-05 18:00:00	SPY	ETF	210.14	210.15	209.87	209.92	134913.0
2015-11-05 19:00:00	SPY	ETF	209.91	209.98	209.79	209.95	87588.0
2015-11-05 04:00:00	QQQ	ETF	114.9	115.05	114.9	115.01	900.0
2015-11-05 05:00:00	QQQ	ETF	115.15	115.2	115.15	115.19	1950.0
2015-11-05 06:00:00	QQQ	ETF	115.19	115.32	115.15	115.3	4300.0
2015-11-05 07:00:00	QQQ	ETF	115.3	115.41	115.29	115.33	48501.0
2015-11-05 08:00:00	QQQ	ETF	115.33	115.33	115.21	115.22	77449.0
2015-11-05 09:00:00	QQQ	ETF	115.23	115.35	114.98	115.33	2549749.0
2015-11-05 10:00:00	QQQ	ETF	115.32	115.395	114.11	114.28	4774283.0
2015-11-05 11:00:00	QQQ	ETF	114.28	114.71	114.23	114.69	2586830.0
2015-11-05 12:00:00	QQQ	ETF	114.69	114.81	114.44	114.79	2045155.0
2015-11-05 13:00:00	QQQ	ETF	114.8	114.84	114.62	114.68	1482657.0
2015-11-05 14:00:00	QQQ	ETF	114.69	114.78	114.38	114.57	1704379.0
2015-11-05 15:00:00	QQQ	ETF	114.56	114.84	114.48	114.69	2722566.0
2015-11-05 16:00:00	QQQ	ETF	114.69	114.77	114.63	114.77	376490.0
2015-11-05 17:00:00	QQQ	ETF	114.76	114.76	114.71	114.74	3604.0
2015-11-05 18:00:00	QQQ	ETF	114.71	114.71	114.65	114.65	12973.0
2015-11-05 19:00:00	QQQ	ETF	114.65	114.68	114.61	114.66	12730.0
2015-11-05 04:00:00	IWM	ETF	118.21	118.21	118.21	118.21	1000.0
2015-11-05 05:00:00	IWM	ETF	118.46	118.46	118.46	118.46	100.0
2015-11-05 06:00:00	IWM	ETF	118.51	118.51	118.51	118.51	100.0
2015-11-05 07:00:00	IWM	ETF	118.5	118.62	118.5	118.61	2900.0
2015-11-05 08:00:00	IWM	ETF	118.63	118.63	118.37	118.41	16878.0
2015-11-05 09:00:00	IWM	ETF	118.42	118.44	117.86	118.305	2674049.0
2015-11-05 10:00:00	IWM	ETF	118.28	118.48	117.09	117.53	5293001.0
2015-11-05 11:00:00	IWM	ETF	117.54	117.98	117.46	117.88	2691819.0
2015-11-05 12:00:00	IWM	ETF	117.88	118.34	117.75	118.3	2285753.0
2015-11-05 13:00:00	IWM	ETF	118.32	118.6	118.21	118.41	2736245.0
2015-11-05 14:00:00	IWM	ETF	118.43	118.55	118.02	118.301	1702424.0
2015-11-05 15:00:00	IWM	ETF	118.31	118.56	118.18	118.35	4825873.0
2015-11-05 16:00:00	IWM	ETF	118.35	118.38	118.17	118.24	585617.0
2015-11-05 17:00:00	IWM	ETF	118.31	118.31	118.29	118.29	1300.0
2015-11-05 18:00:00	IWM	ETF	118.31	118.31	118.27	118.27	1905.0
2015-11-05 08:00:00	DIA	ETF	179.03	179.04	178.8	178.8	1500.0
2015-11-05 09:00:00	DIA	ETF	179.01	179.21	178.59	179.2	653119.0
2015-11-05 10:00:00	DIA	ETF	179.19	179.25	177.74	177.92	842803.0

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

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