PREVIEW / etf_1hour / 2018-04-05

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-05.parquet
  size:    302 KB
  rows:    9,920

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
2018-04-05 04:00:00	SPY	ETF	265.7	265.83	265.13	265.24	40037.0
2018-04-05 05:00:00	SPY	ETF	265.1	265.28	264.7	265.28	27544.0
2018-04-05 06:00:00	SPY	ETF	265.15	265.34	264.99	264.99	43519.0
2018-04-05 07:00:00	SPY	ETF	265.02	265.47	264.92	265.24	224232.0
2018-04-05 08:00:00	SPY	ETF	265.3	266.33	264.97	265.54	708207.0
2018-04-05 09:00:00	SPY	ETF	265.55	265.69	264.55	265.4308	8504746.0
2018-04-05 10:00:00	SPY	ETF	265.4301	265.5995	264.73	264.96	10823872.0
2018-04-05 11:00:00	SPY	ETF	264.97	266.64	264.97	266.59	11658820.0
2018-04-05 12:00:00	SPY	ETF	266.59	266.64	265.54	266.07	7757789.0
2018-04-05 13:00:00	SPY	ETF	266.06	266.39	264.32	265.16	9798241.0
2018-04-05 14:00:00	SPY	ETF	265.17	266.32	264.83	266.25	9204998.0
2018-04-05 15:00:00	SPY	ETF	266.2478	266.6	265.23	265.65	16130946.0
2018-04-05 16:00:00	SPY	ETF	265.64	266.3	256.25	265.62	4601235.0
2018-04-05 17:00:00	SPY	ETF	265.57	265.84	265.5	265.64	117907.0
2018-04-05 18:00:00	SPY	ETF	265.68	265.78	262.55	262.68	231236.0
2018-04-05 19:00:00	SPY	ETF	262.61	262.86	261.51	262.66	1459224.0
2018-04-05 04:00:00	QQQ	ETF	161.27	161.4	160.99	161.15	23769.0
2018-04-05 05:00:00	QQQ	ETF	161.0	161.07	160.6	161.07	29330.0
2018-04-05 06:00:00	QQQ	ETF	161.04	161.12	160.76	160.95	38167.0
2018-04-05 07:00:00	QQQ	ETF	160.95	161.44	160.94	161.24	133164.0
2018-04-05 08:00:00	QQQ	ETF	161.33	161.69	160.94	161.4	275896.0
2018-04-05 09:00:00	QQQ	ETF	161.39	161.58	160.27	160.97	6317426.0
2018-04-05 10:00:00	QQQ	ETF	160.98	161.1	160.22	160.6	5128462.0
2018-04-05 11:00:00	QQQ	ETF	160.61	161.52	160.61	161.39	4324520.0
2018-04-05 12:00:00	QQQ	ETF	161.39	161.41	160.47	160.96	3294915.0
2018-04-05 13:00:00	QQQ	ETF	160.97	161.18	159.48	160.17	6149603.0
2018-04-05 14:00:00	QQQ	ETF	160.2	160.92	160.01	160.89	4642283.0
2018-04-05 15:00:00	QQQ	ETF	160.89	161.265	160.27	160.6	6203482.0
2018-04-05 16:00:00	QQQ	ETF	160.6	160.97	160.42	160.62	1738629.0
2018-04-05 17:00:00	QQQ	ETF	160.57	160.67	160.56	160.67	56518.0
2018-04-05 18:00:00	QQQ	ETF	160.64	160.69	158.55	158.55	128973.0
2018-04-05 19:00:00	QQQ	ETF	158.57	158.89	157.87	158.63	241013.0
2018-04-05 04:00:00	IWM	ETF	152.81	153.08	152.81	152.82	2841.0
2018-04-05 05:00:00	IWM	ETF	152.65	152.71	152.45	152.71	6731.0
2018-04-05 06:00:00	IWM	ETF	152.66	152.75	152.58	152.58	5106.0
2018-04-05 07:00:00	IWM	ETF	152.6	152.91	152.6	152.73	8989.0
2018-04-05 08:00:00	IWM	ETF	152.76	153.15	152.68	153.03	59739.0
2018-04-05 09:00:00	IWM	ETF	152.99	153.17	152.32	152.89	2911697.0
2018-04-05 10:00:00	IWM	ETF	152.89	153.08	152.49	152.67	1850562.0
2018-04-05 11:00:00	IWM	ETF	152.68	153.6099	152.68	153.5	1532554.0
2018-04-05 12:00:00	IWM	ETF	153.5	153.51	153.03	153.32	1146544.0
2018-04-05 13:00:00	IWM	ETF	153.34	153.42	152.61	152.89	1174713.0
2018-04-05 14:00:00	IWM	ETF	152.92	153.315	152.67	153.27	1213811.0
2018-04-05 15:00:00	IWM	ETF	153.28	153.54	152.87	153.36	3009204.0
2018-04-05 16:00:00	IWM	ETF	153.35	153.5	153.06	153.4	1201329.0
2018-04-05 17:00:00	IWM	ETF	153.42	153.42	153.04	153.39	442528.0
2018-04-05 18:00:00	IWM	ETF	153.43	153.44	152.0	152.0	20789.0
2018-04-05 19:00:00	IWM	ETF	151.94	152.06	151.56	152.04	15079.0
2018-04-05 04:00:00	DIA	ETF	243.92	243.92	243.78	243.78	234.0
2018-04-05 07:00:00	DIA	ETF	243.32	243.58	243.08	243.37	6400.0

> showing 50 of 9,920 rows — these rows as CSV

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