PREVIEW / etf_1hour / 2018-11-19

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-19.parquet
  size:    317 KB
  rows:    10,482

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-11-19 04:00:00	SPY	ETF	274.32	274.32	273.75	273.93	26398.0
2018-11-19 05:00:00	SPY	ETF	273.9	274.08	273.48	273.65	57445.0
2018-11-19 06:00:00	SPY	ETF	273.8	273.94	273.16	273.2	102189.0
2018-11-19 07:00:00	SPY	ETF	273.23	273.36	272.96	273.3	268210.0
2018-11-19 08:00:00	SPY	ETF	273.1501	274.0	272.97	273.12	463686.0
2018-11-19 09:00:00	SPY	ETF	273.11	273.38	272.12	272.545	7270945.0
2018-11-19 10:00:00	SPY	ETF	272.53	272.55	270.55	271.588	11496379.0
2018-11-19 11:00:00	SPY	ETF	271.585	271.79	269.08	269.51	10210809.0
2018-11-19 12:00:00	SPY	ETF	269.505	269.76	268.57	269.54	12093505.0
2018-11-19 13:00:00	SPY	ETF	269.54	269.76	268.3	268.71	10922871.0
2018-11-19 14:00:00	SPY	ETF	268.72	269.66	268.07	269.465	14768404.0
2018-11-19 15:00:00	SPY	ETF	269.455	270.25	268.31	269.12	20271192.0
2018-11-19 16:00:00	SPY	ETF	269.12	269.63	269.0772	269.63	12889610.0
2018-11-19 17:00:00	SPY	ETF	269.63	269.64	269.1	269.43	307716.0
2018-11-19 18:00:00	SPY	ETF	269.47	269.53	268.91	269.1	180574.0
2018-11-19 19:00:00	SPY	ETF	269.08	269.27	268.77	268.96	124573.0
2018-11-19 20:00:00	SPY	ETF	269.1	269.1	268.81	268.81	1000.0
2018-11-19 04:00:00	QQQ	ETF	168.58	168.58	168.0	168.08	35315.0
2018-11-19 05:00:00	QQQ	ETF	168.09	168.18	167.7	167.8	57321.0
2018-11-19 06:00:00	QQQ	ETF	167.94	168.02	167.21	167.26	121930.0
2018-11-19 07:00:00	QQQ	ETF	167.35	167.46	167.08	167.3	204928.0
2018-11-19 08:00:00	QQQ	ETF	167.3001	168.74	166.71	166.82	373832.0
2018-11-19 09:00:00	QQQ	ETF	166.82	166.95	165.07	165.49	5777899.0
2018-11-19 10:00:00	QQQ	ETF	165.48	165.5	163.74	164.78	10509918.0
2018-11-19 11:00:00	QQQ	ETF	164.76	164.96	162.68	163.09	6275037.0
2018-11-19 12:00:00	QQQ	ETF	163.05	163.25	162.45	162.79	6369444.0
2018-11-19 13:00:00	QQQ	ETF	162.79	163.19	161.94	162.26	6650700.0
2018-11-19 14:00:00	QQQ	ETF	162.26	162.93	161.77	162.72	7061095.0
2018-11-19 15:00:00	QQQ	ETF	162.72	163.335	161.54	162.04	14051542.0
2018-11-19 16:00:00	QQQ	ETF	162.06	162.56	161.99	162.54	2912181.0
2018-11-19 17:00:00	QQQ	ETF	162.44	162.53	162.0	162.39	118427.0
2018-11-19 18:00:00	QQQ	ETF	162.38	162.42	161.89	162.08	132262.0
2018-11-19 19:00:00	QQQ	ETF	162.03	162.2	161.89	161.96	77212.0
2018-11-19 20:00:00	QQQ	ETF	161.94	161.94	161.94	161.94	1000.0
2018-11-19 04:00:00	IWM	ETF	152.2	152.2	152.0	152.0	3716.0
2018-11-19 05:00:00	IWM	ETF	152.0	152.0	151.85	151.85	3214.0
2018-11-19 06:00:00	IWM	ETF	151.93	152.01	151.56	151.56	11444.0
2018-11-19 07:00:00	IWM	ETF	151.61	151.63	151.48	151.52	14000.0
2018-11-19 08:00:00	IWM	ETF	151.56	152.28	151.45	151.54	32091.0
2018-11-19 09:00:00	IWM	ETF	151.5	152.03	150.65	150.92	2333288.0
2018-11-19 10:00:00	IWM	ETF	150.91	150.99	149.81	150.97	2358630.0
2018-11-19 11:00:00	IWM	ETF	150.93	151.2	148.81	149.05	2660630.0
2018-11-19 12:00:00	IWM	ETF	149.05	149.69	148.56	149.53	2042576.0
2018-11-19 13:00:00	IWM	ETF	149.53	149.73	148.7	148.72	1639192.0
2018-11-19 14:00:00	IWM	ETF	148.74	149.13	148.37	148.97	2504581.0
2018-11-19 15:00:00	IWM	ETF	148.96	149.7231	148.63	148.86	4583490.0
2018-11-19 16:00:00	IWM	ETF	148.89	151.9479	148.86	149.25	1332718.0
2018-11-19 18:00:00	IWM	ETF	149.2	149.26	148.99	149.0	14300.0
2018-11-19 19:00:00	IWM	ETF	149.09	149.09	148.8	148.93	8649.0
2018-11-19 04:00:00	DIA	ETF	254.08	254.2	254.08	254.2	295.0

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

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