PREVIEW / etf_1hour / 2018-10-17

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-17.parquet
  size:    314 KB
  rows:    10,377

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-10-17 04:00:00	SPY	ETF	280.9	281.0	280.53	280.58	56664.0
2018-10-17 05:00:00	SPY	ETF	280.6	280.61	280.09	280.3	90803.0
2018-10-17 06:00:00	SPY	ETF	280.25	280.29	279.93	280.22	125654.0
2018-10-17 07:00:00	SPY	ETF	280.28	280.46	279.79	279.9	228980.0
2018-10-17 08:00:00	SPY	ETF	279.9	281.43	279.64	280.05	522810.0
2018-10-17 09:00:00	SPY	ETF	280.04	280.51	279.13	279.1308	9101058.0
2018-10-17 10:00:00	SPY	ETF	279.14	279.48	277.56	278.21	18610647.0
2018-10-17 11:00:00	SPY	ETF	278.205	280.4308	277.79	280.27	12890671.0
2018-10-17 12:00:00	SPY	ETF	280.28	281.0	279.98	280.66	12402486.0
2018-10-17 13:00:00	SPY	ETF	280.67	281.15	280.52	280.765	9150845.0
2018-10-17 14:00:00	SPY	ETF	280.78	280.97	279.19	280.675	12265602.0
2018-10-17 15:00:00	SPY	ETF	280.68	280.79	279.39	280.4	21114932.0
2018-10-17 16:00:00	SPY	ETF	280.41	280.98	280.357	280.82	10885196.0
2018-10-17 17:00:00	SPY	ETF	280.8	280.8	280.51	280.51	128558.0
2018-10-17 18:00:00	SPY	ETF	280.55	280.61	280.17	280.27	193211.0
2018-10-17 19:00:00	SPY	ETF	280.27	280.27	279.9	279.98	110415.0
2018-10-17 04:00:00	QQQ	ETF	178.57	178.57	178.28	178.32	81866.0
2018-10-17 05:00:00	QQQ	ETF	178.33	178.33	178.01	178.16	121892.0
2018-10-17 06:00:00	QQQ	ETF	178.16	178.31	177.9	178.24	124414.0
2018-10-17 07:00:00	QQQ	ETF	178.27	178.4	177.79	177.85	170200.0
2018-10-17 08:00:00	QQQ	ETF	178.3699	178.4	177.6	177.86	424693.0
2018-10-17 09:00:00	QQQ	ETF	177.85	178.2585	176.4875	176.61	7489346.0
2018-10-17 10:00:00	QQQ	ETF	176.6	176.86	175.47	176.01	11221923.0
2018-10-17 11:00:00	QQQ	ETF	176.0	177.24	175.71	177.09	7835434.0
2018-10-17 12:00:00	QQQ	ETF	177.11	177.55	176.66	177.22	5991327.0
2018-10-17 13:00:00	QQQ	ETF	177.23	177.9454	177.08	177.25	5625987.0
2018-10-17 14:00:00	QQQ	ETF	177.27	177.59	176.1	177.38	7849824.0
2018-10-17 15:00:00	QQQ	ETF	177.38	177.5	176.71	177.3	8562259.0
2018-10-17 16:00:00	QQQ	ETF	177.3	177.78	177.2679	177.72	1479295.0
2018-10-17 17:00:00	QQQ	ETF	177.75	177.75	177.59	177.6	20850.0
2018-10-17 18:00:00	QQQ	ETF	177.55	177.57	177.18	177.32	51749.0
2018-10-17 19:00:00	QQQ	ETF	177.29	177.29	176.89	176.97	45666.0
2018-10-17 05:00:00	IWM	ETF	158.3	158.3	158.12	158.12	3300.0
2018-10-17 06:00:00	IWM	ETF	158.01	158.15	157.93	158.13	16025.0
2018-10-17 07:00:00	IWM	ETF	158.11	158.26	157.72	157.73	47761.0
2018-10-17 08:00:00	IWM	ETF	158.64	158.64	157.68	158.02	128455.0
2018-10-17 09:00:00	IWM	ETF	158.0	158.2199	157.19	157.29	2938691.0
2018-10-17 10:00:00	IWM	ETF	157.29	157.45	155.885	156.52	5220481.0
2018-10-17 11:00:00	IWM	ETF	156.51	157.44	156.31	157.395	2730573.0
2018-10-17 12:00:00	IWM	ETF	157.46	158.11	157.26	157.93	2287120.0
2018-10-17 13:00:00	IWM	ETF	157.93	158.16	157.82	157.98	1414731.0
2018-10-17 14:00:00	IWM	ETF	157.96	158.21	157.2	158.07	2602650.0
2018-10-17 15:00:00	IWM	ETF	158.07	158.19	157.68	158.03	3408792.0
2018-10-17 16:00:00	IWM	ETF	157.9401	158.32	157.94	158.19	931677.0
2018-10-17 17:00:00	IWM	ETF	158.29	158.29	158.29	158.29	133.0
2018-10-17 18:00:00	IWM	ETF	158.14	158.14	157.86	157.86	5100.0
2018-10-17 19:00:00	IWM	ETF	157.84	157.84	157.76	157.76	4700.0
2018-10-17 05:00:00	DIA	ETF	257.46	257.46	256.99	256.99	1500.0
2018-10-17 06:00:00	DIA	ETF	257.02	257.21	257.02	257.21	425.0
2018-10-17 07:00:00	DIA	ETF	257.32	257.32	256.68	256.76	3558.0

> showing 50 of 10,377 rows — these rows as CSV

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