PREVIEW / etf_1hour / 2015-01-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-01-28.parquet
  size:    243 KB
  rows:    7,754

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-28 04:00:00	SPY	ETF	204.02	204.29	203.8	204.29	1850.0
2015-01-28 05:00:00	SPY	ETF	204.25	204.25	203.32	203.45	47780.0
2015-01-28 06:00:00	SPY	ETF	203.36	203.9	203.35	203.79	45816.0
2015-01-28 07:00:00	SPY	ETF	203.7	204.42	203.6	204.32	276044.0
2015-01-28 08:00:00	SPY	ETF	204.3	204.35	203.72	203.96	796148.0
2015-01-28 09:00:00	SPY	ETF	203.93	204.29	203.41	203.68	12590589.0
2015-01-28 10:00:00	SPY	ETF	203.69	203.97	202.24	202.37	19685919.0
2015-01-28 11:00:00	SPY	ETF	202.37	203.06	202.05	202.84	15294151.0
2015-01-28 12:00:00	SPY	ETF	202.85	203.48	202.816	203.13	7896523.0
2015-01-28 13:00:00	SPY	ETF	203.12	203.23	202.72	202.75	9437445.0
2015-01-28 14:00:00	SPY	ETF	202.78	203.57	201.51	202.21	29196031.0
2015-01-28 15:00:00	SPY	ETF	202.2	202.5	199.91	200.07	47015332.0
2015-01-28 16:00:00	SPY	ETF	200.04	204.0151	199.56	199.87	21590134.0
2015-01-28 17:00:00	SPY	ETF	199.88	199.9	199.67	199.82	263806.0
2015-01-28 18:00:00	SPY	ETF	199.83	200.06	199.83	200.06	474739.0
2015-01-28 19:00:00	SPY	ETF	200.06	200.1	199.97	200.07	272165.0
2015-01-28 04:00:00	QQQ	ETF	102.87	103.0	102.87	103.0	3060.0
2015-01-28 05:00:00	QQQ	ETF	102.8	102.8	102.62	102.62	12000.0
2015-01-28 06:00:00	QQQ	ETF	102.59	102.89	102.57	102.89	4290.0
2015-01-28 07:00:00	QQQ	ETF	102.76	103.2	102.76	103.14	179425.0
2015-01-28 08:00:00	QQQ	ETF	103.1	103.11	102.92	102.94	278039.0
2015-01-28 09:00:00	QQQ	ETF	102.94	103.18	102.605	102.8667	5622742.0
2015-01-28 10:00:00	QQQ	ETF	102.87	103.065	101.93	101.99	5403933.0
2015-01-28 11:00:00	QQQ	ETF	101.995	102.3332	101.75	102.2	3479646.0
2015-01-28 12:00:00	QQQ	ETF	102.22	102.71	102.2	102.59	2732384.0
2015-01-28 13:00:00	QQQ	ETF	102.589	102.66	102.37	102.37	1922075.0
2015-01-28 14:00:00	QQQ	ETF	102.4	102.82	101.65	102.09	7247020.0
2015-01-28 15:00:00	QQQ	ETF	102.095	102.27	100.9	100.93	10805331.0
2015-01-28 16:00:00	QQQ	ETF	100.92	102.1167	100.57	100.65	761562.0
2015-01-28 17:00:00	QQQ	ETF	100.7	101.05	100.63	100.75	89005.0
2015-01-28 18:00:00	QQQ	ETF	100.72	100.76	100.69	100.72	52598.0
2015-01-28 19:00:00	QQQ	ETF	100.8	100.86	100.78	100.86	18647.0
2015-01-28 04:00:00	IWM	ETF	119.66	119.66	119.66	119.66	100.0
2015-01-28 05:00:00	IWM	ETF	119.05	119.05	119.01	119.01	200.0
2015-01-28 06:00:00	IWM	ETF	119.01	119.01	119.01	119.01	900.0
2015-01-28 07:00:00	IWM	ETF	119.1	119.46	119.02	119.45	62530.0
2015-01-28 08:00:00	IWM	ETF	119.45	119.45	119.11	119.2	74262.0
2015-01-28 09:00:00	IWM	ETF	119.14	119.45	118.39	118.42	3432495.0
2015-01-28 10:00:00	IWM	ETF	118.42	118.75	117.11	117.38	5527871.0
2015-01-28 11:00:00	IWM	ETF	117.39	117.91	117.27	117.66	3782518.0
2015-01-28 12:00:00	IWM	ETF	117.66	118.44	117.65	118.205	2081867.0
2015-01-28 13:00:00	IWM	ETF	118.2	118.25	117.871	117.88	1523007.0
2015-01-28 14:00:00	IWM	ETF	117.9128	118.42	117.33	117.701	4351296.0
2015-01-28 15:00:00	IWM	ETF	117.715	117.885	116.32	116.67	9217243.0
2015-01-28 16:00:00	IWM	ETF	116.67	116.79	116.43	116.45	1057630.0
2015-01-28 17:00:00	IWM	ETF	116.54	116.54	116.46	116.46	28607.0
2015-01-28 18:00:00	IWM	ETF	116.5	116.74	116.5	116.74	4324.0
2015-01-28 19:00:00	IWM	ETF	116.74	116.85	116.74	116.85	2570.0
2015-01-28 05:00:00	DIA	ETF	174.0	174.0	173.68	173.68	1500.0
2015-01-28 06:00:00	DIA	ETF	173.65	173.65	173.65	173.65	100.0

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

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