PREVIEW / etf_1hour / 2015-03-10

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-03-10.parquet
  size:    245 KB
  rows:    7,852

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-03-10 04:00:00	SPY	ETF	207.96	207.96	207.38	207.44	26166.0
2015-03-10 05:00:00	SPY	ETF	207.48	207.48	207.19	207.24	52803.0
2015-03-10 06:00:00	SPY	ETF	207.16	207.16	206.74	207.05	187926.0
2015-03-10 07:00:00	SPY	ETF	207.05	207.09	206.42	206.53	530565.0
2015-03-10 08:00:00	SPY	ETF	206.56	207.09	206.13	206.57	1973199.0
2015-03-10 09:00:00	SPY	ETF	206.57	206.84	206.02	206.3201	14053980.0
2015-03-10 10:00:00	SPY	ETF	206.32	206.51	205.7	206.08	22686979.0
2015-03-10 11:00:00	SPY	ETF	206.08	206.66	205.57	205.58	18235063.0
2015-03-10 12:00:00	SPY	ETF	205.58	205.8	205.32	205.56	19038872.0
2015-03-10 13:00:00	SPY	ETF	205.57	205.98	205.48	205.68	13371891.0
2015-03-10 14:00:00	SPY	ETF	205.67	205.92	205.22	205.2601	15007098.0
2015-03-10 15:00:00	SPY	ETF	205.26	205.74	204.97	204.98	33126891.0
2015-03-10 16:00:00	SPY	ETF	204.97	208.3738	204.67	205.0	13676779.0
2015-03-10 17:00:00	SPY	ETF	204.93	204.98	204.88	204.94	1414773.0
2015-03-10 18:00:00	SPY	ETF	204.93	204.97	204.87	204.94	224127.0
2015-03-10 19:00:00	SPY	ETF	204.96	205.21	204.91	205.18	160977.0
2015-03-10 04:00:00	QQQ	ETF	107.38	107.38	107.38	107.38	2500.0
2015-03-10 05:00:00	QQQ	ETF	107.31	107.31	107.25	107.29	11501.0
2015-03-10 06:00:00	QQQ	ETF	107.28	107.28	106.92	107.13	79936.0
2015-03-10 07:00:00	QQQ	ETF	107.06	107.06	106.86	106.92	72966.0
2015-03-10 08:00:00	QQQ	ETF	106.92	107.0	106.7	106.93	305033.0
2015-03-10 09:00:00	QQQ	ETF	106.94	107.04	106.39	106.5162	4908066.0
2015-03-10 10:00:00	QQQ	ETF	106.51	106.65	105.96	106.19	4847359.0
2015-03-10 11:00:00	QQQ	ETF	106.18	106.56	105.99	105.99	3317379.0
2015-03-10 12:00:00	QQQ	ETF	105.985	106.15	105.85	106.03	3617523.0
2015-03-10 13:00:00	QQQ	ETF	106.03	106.299	105.98	106.18	3055091.0
2015-03-10 14:00:00	QQQ	ETF	106.17	106.325	105.88	105.91	2885544.0
2015-03-10 15:00:00	QQQ	ETF	105.91	106.17	105.72	105.75	5905726.0
2015-03-10 16:00:00	QQQ	ETF	105.74	107.7093	105.66	105.8	2849758.0
2015-03-10 17:00:00	QQQ	ETF	105.8	105.82	105.79	105.79	25625.0
2015-03-10 18:00:00	QQQ	ETF	105.81	105.82	105.76	105.81	32016.0
2015-03-10 19:00:00	QQQ	ETF	105.81	105.93	105.79	105.91	37230.0
2015-03-10 04:00:00	IWM	ETF	121.14	121.14	121.14	121.14	100.0
2015-03-10 05:00:00	IWM	ETF	121.05	121.05	121.05	121.05	100.0
2015-03-10 06:00:00	IWM	ETF	120.77	120.81	120.77	120.81	1000.0
2015-03-10 07:00:00	IWM	ETF	120.73	120.73	120.24	120.32	41599.0
2015-03-10 08:00:00	IWM	ETF	120.33	120.42	120.15	120.26	311959.0
2015-03-10 09:00:00	IWM	ETF	120.27	120.72	119.87	120.13	4181238.0
2015-03-10 10:00:00	IWM	ETF	120.13	120.38	119.83	120.29	4434319.0
2015-03-10 11:00:00	IWM	ETF	120.28	120.55	120.08	120.08	2898559.0
2015-03-10 12:00:00	IWM	ETF	120.085	120.38	120.0	120.29	2470094.0
2015-03-10 13:00:00	IWM	ETF	120.3	120.6	120.3	120.53	1400508.0
2015-03-10 14:00:00	IWM	ETF	120.52	120.63	120.31	120.514	1963584.0
2015-03-10 15:00:00	IWM	ETF	120.51	120.7	120.15	120.29	5169294.0
2015-03-10 16:00:00	IWM	ETF	120.29	120.33	120.0687	120.31	1021986.0
2015-03-10 17:00:00	IWM	ETF	120.34	120.4	120.33	120.4	10531.0
2015-03-10 19:00:00	IWM	ETF	120.36	120.36	120.36	120.36	11286.0
2015-03-10 07:00:00	DIA	ETF	178.2	178.22	178.15	178.18	11200.0
2015-03-10 08:00:00	DIA	ETF	178.37	178.37	177.78	178.2	12390.0
2015-03-10 09:00:00	DIA	ETF	178.28	178.62	177.72	177.94	910449.0

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

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