PREVIEW / etf_1hour / 2018-10-31

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-31.parquet
  size:    324 KB
  rows:    10,576

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-31 04:00:00	SPY	ETF	269.1	269.94	269.0	269.86	54061.0
2018-10-31 05:00:00	SPY	ETF	269.89	269.89	269.12	269.25	127704.0
2018-10-31 06:00:00	SPY	ETF	269.25	269.96	269.25	269.8	126395.0
2018-10-31 07:00:00	SPY	ETF	269.76	270.26	269.71	270.11	351191.0
2018-10-31 08:00:00	SPY	ETF	269.89	270.91	268.38	270.79	944704.0
2018-10-31 09:00:00	SPY	ETF	270.81	271.65	270.12	271.51	12163474.0
2018-10-31 10:00:00	SPY	ETF	271.51	272.45	271.06	271.46	13863100.0
2018-10-31 11:00:00	SPY	ETF	271.48	272.0	270.8	271.23	11667544.0
2018-10-31 12:00:00	SPY	ETF	271.25	272.24	270.365	272.01	9446845.0
2018-10-31 13:00:00	SPY	ETF	272.02	272.77	271.81	272.42	8606617.0
2018-10-31 14:00:00	SPY	ETF	272.42	273.2	272.09	272.865	12169723.0
2018-10-31 15:00:00	SPY	ETF	272.86	273.23	270.54	270.69	39376670.0
2018-10-31 16:00:00	SPY	ETF	270.69	271.05	270.0	270.14	14832239.0
2018-10-31 17:00:00	SPY	ETF	270.13	270.7244	270.08	270.19	215746.0
2018-10-31 18:00:00	SPY	ETF	270.19	270.75	270.15	270.57	513764.0
2018-10-31 19:00:00	SPY	ETF	270.61	270.88	270.45	270.77	98361.0
2018-10-31 04:00:00	QQQ	ETF	167.29	167.74	167.22	167.74	17373.0
2018-10-31 05:00:00	QQQ	ETF	167.75	167.75	167.14	167.18	28344.0
2018-10-31 06:00:00	QQQ	ETF	167.24	167.75	167.08	167.53	47075.0
2018-10-31 07:00:00	QQQ	ETF	167.51	167.91	167.41	167.8	257665.0
2018-10-31 08:00:00	QQQ	ETF	167.78	168.6	166.34	168.38	1142350.0
2018-10-31 09:00:00	QQQ	ETF	168.37	169.95	168.28	169.87	10170721.0
2018-10-31 10:00:00	QQQ	ETF	169.88	170.885	169.69	169.795	12380061.0
2018-10-31 11:00:00	QQQ	ETF	169.8	170.36	168.88	169.37	6944151.0
2018-10-31 12:00:00	QQQ	ETF	169.36	170.44	168.65	170.23	5426528.0
2018-10-31 13:00:00	QQQ	ETF	170.24	171.09	170.15	170.54	4530449.0
2018-10-31 14:00:00	QQQ	ETF	170.53	171.25	170.26	170.82	5792397.0
2018-10-31 15:00:00	QQQ	ETF	170.82	171.14	169.63	169.66	12954496.0
2018-10-31 16:00:00	QQQ	ETF	169.66	169.82	169.21	169.3	4071872.0
2018-10-31 17:00:00	QQQ	ETF	169.35	169.82	169.29	169.29	506240.0
2018-10-31 18:00:00	QQQ	ETF	169.34	169.82	169.34	169.63	217323.0
2018-10-31 19:00:00	QQQ	ETF	169.66	169.69	169.46	169.65	37678.0
2018-10-31 04:00:00	IWM	ETF	150.19	151.0	150.19	150.99	13973.0
2018-10-31 05:00:00	IWM	ETF	150.95	150.95	150.9	150.9	5450.0
2018-10-31 06:00:00	IWM	ETF	150.77	151.07	150.74	150.98	14400.0
2018-10-31 07:00:00	IWM	ETF	150.98	151.2	150.9	151.11	46283.0
2018-10-31 08:00:00	IWM	ETF	150.97	151.68	150.05	151.49	132499.0
2018-10-31 09:00:00	IWM	ETF	151.5	151.58	150.705	151.37	3026315.0
2018-10-31 10:00:00	IWM	ETF	151.38	151.86	150.64	151.06	4199276.0
2018-10-31 11:00:00	IWM	ETF	151.07	151.38	150.745	150.93	2499694.0
2018-10-31 12:00:00	IWM	ETF	150.93	151.23	150.24	151.08	2731629.0
2018-10-31 13:00:00	IWM	ETF	151.09	151.415	150.58	150.97	2579904.0
2018-10-31 14:00:00	IWM	ETF	150.97	151.3385	150.81	151.1	2033873.0
2018-10-31 15:00:00	IWM	ETF	151.1	151.3401	150.06	150.22	7476744.0
2018-10-31 16:00:00	IWM	ETF	150.2056	150.38	149.85	150.01	2700048.0
2018-10-31 17:00:00	IWM	ETF	149.91	150.05	149.91	150.03	1116300.0
2018-10-31 18:00:00	IWM	ETF	150.03	150.32	150.03	150.24	182648.0
2018-10-31 19:00:00	IWM	ETF	150.34	150.42	150.33	150.42	1800.0
2018-10-31 04:00:00	DIA	ETF	249.8	250.0	249.8	249.96	7100.0
2018-10-31 05:00:00	DIA	ETF	250.0	250.0	249.86	249.86	797.0

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

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