PREVIEW / etf_1hour / 2015-01-23

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-23.parquet
  size:    240 KB
  rows:    7,762

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-01-23 04:00:00	SPY	ETF	206.05	206.32	205.86	206.12	7200.0
2015-01-23 05:00:00	SPY	ETF	206.22	206.22	205.91	205.93	67599.0
2015-01-23 06:00:00	SPY	ETF	206.06	206.36	206.0	206.22	102213.0
2015-01-23 07:00:00	SPY	ETF	206.12	206.62	206.05	206.46	592205.0
2015-01-23 08:00:00	SPY	ETF	206.45	206.5	205.74	205.77	1503856.0
2015-01-23 09:00:00	SPY	ETF	205.76	206.08	205.26	205.54	17528393.0
2015-01-23 10:00:00	SPY	ETF	205.54	205.88	205.02	205.68	17626966.0
2015-01-23 11:00:00	SPY	ETF	205.68	205.91	205.41	205.64	9882567.0
2015-01-23 12:00:00	SPY	ETF	205.63	206.1	205.51	205.92	7771077.0
2015-01-23 13:00:00	SPY	ETF	205.925	206.07	205.57	205.91	9260468.0
2015-01-23 14:00:00	SPY	ETF	205.92	206.02	205.38	205.396	9540042.0
2015-01-23 15:00:00	SPY	ETF	205.398	205.48	204.81	204.95	29819086.0
2015-01-23 16:00:00	SPY	ETF	204.96	205.092	204.69	204.75	9692978.0
2015-01-23 17:00:00	SPY	ETF	204.73	204.97	204.54	204.66	792226.0
2015-01-23 18:00:00	SPY	ETF	204.66	204.71	204.45	204.54	122614.0
2015-01-23 19:00:00	SPY	ETF	204.56	204.63	204.52	204.52	32127.0
2015-01-23 04:00:00	QQQ	ETF	104.1	104.1	104.0	104.0	900.0
2015-01-23 05:00:00	QQQ	ETF	103.98	103.98	103.96	103.96	300.0
2015-01-23 06:00:00	QQQ	ETF	104.03	104.15	104.02	104.13	12000.0
2015-01-23 07:00:00	QQQ	ETF	104.03	104.29	104.03	104.19	58643.0
2015-01-23 08:00:00	QQQ	ETF	104.2	104.25	103.97	104.06	88526.0
2015-01-23 09:00:00	QQQ	ETF	103.99	104.2099	103.72	104.17	5338651.0
2015-01-23 10:00:00	QQQ	ETF	104.16	104.31	103.75	104.108	4201257.0
2015-01-23 11:00:00	QQQ	ETF	104.1	104.32	103.99	104.1632	2204651.0
2015-01-23 12:00:00	QQQ	ETF	104.17	104.44	104.08	104.39	2554708.0
2015-01-23 13:00:00	QQQ	ETF	104.38	104.58	104.26	104.52	2384608.0
2015-01-23 14:00:00	QQQ	ETF	104.515	104.56	104.17	104.22	1720443.0
2015-01-23 15:00:00	QQQ	ETF	104.22	104.307	104.06	104.25	12950962.0
2015-01-23 16:00:00	QQQ	ETF	104.25	104.3	104.06	104.08	849624.0
2015-01-23 17:00:00	QQQ	ETF	104.1	104.1	104.07	104.1	12700.0
2015-01-23 18:00:00	QQQ	ETF	104.09	104.09	104.04	104.04	910.0
2015-01-23 19:00:00	QQQ	ETF	104.04	104.09	104.02	104.09	5900.0
2015-01-23 04:00:00	IWM	ETF	118.54	118.54	118.54	118.54	100.0
2015-01-23 07:00:00	IWM	ETF	118.42	118.92	118.42	118.79	49290.0
2015-01-23 08:00:00	IWM	ETF	118.78	118.8	118.35	118.35	330233.0
2015-01-23 09:00:00	IWM	ETF	118.33	118.45	117.89	118.25	4614152.0
2015-01-23 10:00:00	IWM	ETF	118.26	118.58	117.55	118.14	5698325.0
2015-01-23 11:00:00	IWM	ETF	118.14	118.77	118.01	118.26	3423886.0
2015-01-23 12:00:00	IWM	ETF	118.25	118.53	118.13	118.35	1739977.0
2015-01-23 13:00:00	IWM	ETF	118.34	118.39	118.1	118.231	1680374.0
2015-01-23 14:00:00	IWM	ETF	118.24	118.3	118.04	118.13	1870218.0
2015-01-23 15:00:00	IWM	ETF	118.14	118.35	117.99	118.11	4501653.0
2015-01-23 16:00:00	IWM	ETF	118.12	118.16	117.77	117.91	1057546.0
2015-01-23 17:00:00	IWM	ETF	117.9	117.99	117.89	117.99	5700.0
2015-01-23 19:00:00	IWM	ETF	117.95	117.95	117.95	117.95	100.0
2015-01-23 07:00:00	DIA	ETF	177.85	178.23	177.85	178.17	1350.0
2015-01-23 08:00:00	DIA	ETF	178.38	178.38	177.69	177.72	14150.0
2015-01-23 09:00:00	DIA	ETF	177.69	177.82	177.0801	177.34	1162424.0
2015-01-23 10:00:00	DIA	ETF	177.35	177.65	176.93	177.45	810258.0
2015-01-23 11:00:00	DIA	ETF	177.45	177.55	177.17	177.265	331033.0

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

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