PREVIEW / etf_1hour / 2018-07-03

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-03.parquet
  size:    204 KB
  rows:    6,352

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-07-03 04:00:00	SPY	ETF	272.26	272.77	272.26	272.72	25115.0
2018-07-03 05:00:00	SPY	ETF	272.65	272.86	272.49	272.85	30566.0
2018-07-03 06:00:00	SPY	ETF	272.9	273.18	272.85	272.87	49907.0
2018-07-03 07:00:00	SPY	ETF	272.92	273.18	272.77	273.15	153586.0
2018-07-03 08:00:00	SPY	ETF	273.18	273.3	271.53	273.0	250599.0
2018-07-03 09:00:00	SPY	ETF	273.02	273.05	272.31	272.5601	6473427.0
2018-07-03 10:00:00	SPY	ETF	272.57	272.83	272.04	272.225	5836908.0
2018-07-03 11:00:00	SPY	ETF	272.22	272.51	272.04	272.31	7247590.0
2018-07-03 12:00:00	SPY	ETF	272.31	272.44	270.42	270.83	14844545.0
2018-07-03 13:00:00	SPY	ETF	270.82	271.05	270.39	270.46	3913249.0
2018-07-03 14:00:00	SPY	ETF	270.4546	270.9	270.38	270.5	129657.0
2018-07-03 15:00:00	SPY	ETF	270.49	270.52	270.2	270.3	54316.0
2018-07-03 16:00:00	SPY	ETF	270.34	270.6534	270.1	270.33	55384.0
2018-07-03 04:00:00	QQQ	ETF	173.0	173.39	173.0	173.37	8066.0
2018-07-03 05:00:00	QQQ	ETF	173.39	173.47	173.25	173.43	45604.0
2018-07-03 06:00:00	QQQ	ETF	173.46	173.76	173.46	173.65	20849.0
2018-07-03 07:00:00	QQQ	ETF	173.66	173.96	173.58	173.87	111825.0
2018-07-03 08:00:00	QQQ	ETF	172.8	173.95	172.8	173.65	205986.0
2018-07-03 09:00:00	QQQ	ETF	173.65	173.66	172.1275	172.45	4820321.0
2018-07-03 10:00:00	QQQ	ETF	172.45	172.95	172.22	172.41	4203634.0
2018-07-03 11:00:00	QQQ	ETF	172.42	172.54	171.94	172.18	2863326.0
2018-07-03 12:00:00	QQQ	ETF	172.18	172.28	170.63	170.79	7283819.0
2018-07-03 13:00:00	QQQ	ETF	170.8	170.91	170.56	170.6413	1472939.0
2018-07-03 14:00:00	QQQ	ETF	170.71	170.75	170.63	170.7	16094.0
2018-07-03 15:00:00	QQQ	ETF	170.71	170.73	170.56	170.6232	8568.0
2018-07-03 16:00:00	QQQ	ETF	170.67	170.8	170.67	170.69	2617.0
2018-07-03 05:00:00	IWM	ETF	164.61	164.71	164.59	164.65	7600.0
2018-07-03 06:00:00	IWM	ETF	164.86	164.86	164.84	164.84	700.0
2018-07-03 07:00:00	IWM	ETF	164.74	164.8	164.63	164.8	27432.0
2018-07-03 08:00:00	IWM	ETF	164.82	164.91	164.79	164.81	9417.0
2018-07-03 09:00:00	IWM	ETF	164.84	165.2	164.7	165.08	2549294.0
2018-07-03 10:00:00	IWM	ETF	165.1	165.701	165.09	165.26	2295421.0
2018-07-03 11:00:00	IWM	ETF	165.27	165.56	165.07	165.23	2169080.0
2018-07-03 12:00:00	IWM	ETF	165.24	165.29	164.81	164.96	4452770.0
2018-07-03 13:00:00	IWM	ETF	164.8701	165.19	164.8687	165.16	713186.0
2018-07-03 14:00:00	IWM	ETF	165.06	165.06	164.96	164.96	14142.0
2018-07-03 15:00:00	IWM	ETF	165.0059	165.0059	164.96	164.96	995.0
2018-07-03 16:00:00	IWM	ETF	164.96	164.96	164.8701	164.9	101966.0
2018-07-03 04:00:00	DIA	ETF	243.5	243.65	243.5	243.63	1960.0
2018-07-03 05:00:00	DIA	ETF	243.56	243.7	243.54	243.7	3000.0
2018-07-03 06:00:00	DIA	ETF	244.0	244.0	244.0	244.0	1000.0
2018-07-03 07:00:00	DIA	ETF	243.9	244.17	243.9	244.16	2957.0
2018-07-03 08:00:00	DIA	ETF	244.43	244.43	244.19	244.27	17479.0
2018-07-03 09:00:00	DIA	ETF	244.28	244.31	243.6	243.75	484913.0
2018-07-03 10:00:00	DIA	ETF	243.76	243.9	243.09	243.27	413060.0
2018-07-03 11:00:00	DIA	ETF	243.27	243.44	242.88	243.15	843861.0
2018-07-03 12:00:00	DIA	ETF	243.1499	243.25	241.35	241.84	1095477.0
2018-07-03 13:00:00	DIA	ETF	241.66	242.13	241.4	241.8	96962.0
2018-07-03 14:00:00	DIA	ETF	241.53	241.7	241.53	241.66	2400.0
2018-07-03 15:00:00	DIA	ETF	241.6002	241.66	241.485	241.485	1050.0

> showing 50 of 6,352 rows — these rows as CSV

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