PREVIEW / etf_1hour / 2018-10-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-18.parquet
  size:    314 KB
  rows:    10,349

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-18 04:00:00	SPY	ETF	280.43	280.5	280.16	280.35	30240.0
2018-10-18 05:00:00	SPY	ETF	280.12	280.39	279.84	280.33	30119.0
2018-10-18 06:00:00	SPY	ETF	280.31	280.35	279.7	279.76	64531.0
2018-10-18 07:00:00	SPY	ETF	279.77	280.08	279.49	279.61	184213.0
2018-10-18 08:00:00	SPY	ETF	279.85	280.43	279.39	279.85	361011.0
2018-10-18 09:00:00	SPY	ETF	279.8	279.88	278.485	278.74	7679984.0
2018-10-18 10:00:00	SPY	ETF	278.72	280.07	278.33	279.89	12264451.0
2018-10-18 11:00:00	SPY	ETF	279.89	280.0	276.09	276.54	21109812.0
2018-10-18 12:00:00	SPY	ETF	276.53	277.9319	276.22	277.18	15749963.0
2018-10-18 13:00:00	SPY	ETF	277.16	277.39	274.97	275.405	20457456.0
2018-10-18 14:00:00	SPY	ETF	275.39	277.07	275.29	276.39	14447486.0
2018-10-18 15:00:00	SPY	ETF	276.39	277.02	275.57	276.47	28592048.0
2018-10-18 16:00:00	SPY	ETF	276.46	279.25	276.33	276.81	10993707.0
2018-10-18 17:00:00	SPY	ETF	276.81	276.88	276.4	276.82	222956.0
2018-10-18 18:00:00	SPY	ETF	276.81	276.84	276.46	276.69	220908.0
2018-10-18 19:00:00	SPY	ETF	276.68	276.76	276.4	276.55	51538.0
2018-10-18 04:00:00	QQQ	ETF	177.39	177.39	177.22	177.29	25848.0
2018-10-18 05:00:00	QQQ	ETF	177.19	177.29	176.91	177.29	55986.0
2018-10-18 06:00:00	QQQ	ETF	177.23	177.23	176.79	176.79	24214.0
2018-10-18 07:00:00	QQQ	ETF	176.83	177.0	176.62	176.64	104419.0
2018-10-18 08:00:00	QQQ	ETF	176.85	177.5	176.51	176.94	380405.0
2018-10-18 09:00:00	QQQ	ETF	176.93	176.95	175.6375	175.8	5683908.0
2018-10-18 10:00:00	QQQ	ETF	175.8	176.29	175.24	176.08	7091889.0
2018-10-18 11:00:00	QQQ	ETF	176.1	176.225	173.19	173.54	12554179.0
2018-10-18 12:00:00	QQQ	ETF	173.53	174.69	173.33	173.94	8130364.0
2018-10-18 13:00:00	QQQ	ETF	173.93	174.06	172.44	172.96	11934368.0
2018-10-18 14:00:00	QQQ	ETF	172.95	174.1	172.87	173.58	9625245.0
2018-10-18 15:00:00	QQQ	ETF	173.57	173.8	172.99	173.34	13509326.0
2018-10-18 16:00:00	QQQ	ETF	173.34	173.95	173.18	173.88	2760638.0
2018-10-18 17:00:00	QQQ	ETF	173.93	173.93	173.18	173.8	217398.0
2018-10-18 18:00:00	QQQ	ETF	173.87	173.91	173.34	173.62	165118.0
2018-10-18 19:00:00	QQQ	ETF	173.74	173.79	173.54	173.61	76006.0
2018-10-18 05:00:00	IWM	ETF	157.66	157.66	157.66	157.66	125.0
2018-10-18 06:00:00	IWM	ETF	157.88	157.88	157.58	157.58	5286.0
2018-10-18 07:00:00	IWM	ETF	157.6	157.68	157.6	157.68	4900.0
2018-10-18 08:00:00	IWM	ETF	157.46	157.67	157.35	157.67	7146.0
2018-10-18 09:00:00	IWM	ETF	157.61	157.62	156.86	156.86	1993086.0
2018-10-18 10:00:00	IWM	ETF	156.86	157.63	156.69	157.29	2675059.0
2018-10-18 11:00:00	IWM	ETF	157.29	157.38	155.43	155.58	3796767.0
2018-10-18 12:00:00	IWM	ETF	155.57	156.14	155.36	155.81	2680348.0
2018-10-18 13:00:00	IWM	ETF	155.8	155.88	154.3735	154.58	3959837.0
2018-10-18 14:00:00	IWM	ETF	154.57	155.53	154.54	155.2095	2995986.0
2018-10-18 15:00:00	IWM	ETF	155.21	155.36	154.73	155.07	4970953.0
2018-10-18 16:00:00	IWM	ETF	155.05	155.42	154.96	155.25	1662428.0
2018-10-18 17:00:00	IWM	ETF	155.28	157.9442	155.0	155.29	322097.0
2018-10-18 18:00:00	IWM	ETF	155.23	155.23	155.1	155.19	2300.0
2018-10-18 19:00:00	IWM	ETF	155.2	155.2	155.01	155.01	1300.0
2018-10-18 07:00:00	DIA	ETF	256.68	256.68	256.42	256.46	1500.0
2018-10-18 08:00:00	DIA	ETF	256.4	256.56	256.25	256.54	5522.0
2018-10-18 09:00:00	DIA	ETF	256.16	256.24	255.28	255.39	536895.0

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

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