PREVIEW / etf_1hour / 2019-02-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-02-04.parquet
  size:    320 KB
  rows:    10,557

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
2019-02-04 04:00:00	SPY	ETF	269.9	270.3	269.89	270.3	8607.0
2019-02-04 05:00:00	SPY	ETF	270.34	270.52	270.2	270.39	11566.0
2019-02-04 06:00:00	SPY	ETF	270.2	270.34	270.12	270.16	17344.0
2019-02-04 07:00:00	SPY	ETF	270.12	270.45	270.12	270.37	57832.0
2019-02-04 08:00:00	SPY	ETF	270.39	270.4	269.86	270.06	117779.0
2019-02-04 09:00:00	SPY	ETF	270.03	270.32	269.6285	269.995	4803895.0
2019-02-04 10:00:00	SPY	ETF	269.99	270.25	269.36	270.17	6953083.0
2019-02-04 11:00:00	SPY	ETF	270.17	270.96	270.15	270.905	7061007.0
2019-02-04 12:00:00	SPY	ETF	270.9	271.02	270.76	270.92	3707081.0
2019-02-04 13:00:00	SPY	ETF	270.93	271.43	270.9	271.39	5007611.0
2019-02-04 14:00:00	SPY	ETF	271.39	271.56	271.21	271.4192	6155693.0
2019-02-04 15:00:00	SPY	ETF	271.41	272.02	271.2	272.0	15983169.0
2019-02-04 16:00:00	SPY	ETF	272.0	272.13	270.1811	271.81	7950110.0
2019-02-04 17:00:00	SPY	ETF	271.79	271.96	271.58	271.58	108662.0
2019-02-04 18:00:00	SPY	ETF	271.66	271.84	271.53	271.54	56705.0
2019-02-04 19:00:00	SPY	ETF	271.62	271.83	271.35	271.44	48823.0
2019-02-04 04:00:00	QQQ	ETF	167.3	167.52	167.3	167.45	5222.0
2019-02-04 05:00:00	QQQ	ETF	167.58	167.7	167.48	167.5	64320.0
2019-02-04 06:00:00	QQQ	ETF	167.48	167.55	167.47	167.53	4457.0
2019-02-04 07:00:00	QQQ	ETF	167.53	167.66	167.53	167.63	23192.0
2019-02-04 08:00:00	QQQ	ETF	167.4999	167.65	167.23	167.36	106096.0
2019-02-04 09:00:00	QQQ	ETF	167.34	168.22	167.32	168.0958	3306037.0
2019-02-04 10:00:00	QQQ	ETF	168.1	168.84	167.78	168.6601	4276289.0
2019-02-04 11:00:00	QQQ	ETF	168.7	169.16	168.69	169.065	2951582.0
2019-02-04 12:00:00	QQQ	ETF	169.07	169.13	168.9115	169.0368	1374193.0
2019-02-04 13:00:00	QQQ	ETF	169.0382	169.29	168.94	169.26	1416353.0
2019-02-04 14:00:00	QQQ	ETF	169.26	169.38	169.08	169.24	1820555.0
2019-02-04 15:00:00	QQQ	ETF	169.235	169.5	168.97	169.5	4459507.0
2019-02-04 16:00:00	QQQ	ETF	169.51	169.93	168.82	169.06	2189923.0
2019-02-04 17:00:00	QQQ	ETF	169.15	169.53	168.8	168.95	153081.0
2019-02-04 18:00:00	QQQ	ETF	168.9	169.0	168.82	168.87	113909.0
2019-02-04 19:00:00	QQQ	ETF	168.95	169.04	168.69	168.73	7797.0
2019-02-04 04:00:00	IWM	ETF	149.33	149.33	149.33	149.33	167.0
2019-02-04 05:00:00	IWM	ETF	149.43	149.43	149.4	149.41	1400.0
2019-02-04 06:00:00	IWM	ETF	149.41	149.45	149.4	149.4	6300.0
2019-02-04 07:00:00	IWM	ETF	149.41	149.52	149.4	149.45	9500.0
2019-02-04 08:00:00	IWM	ETF	149.49	149.49	149.34	149.4	35107.0
2019-02-04 09:00:00	IWM	ETF	149.4	149.71	148.99	149.24	2033364.0
2019-02-04 10:00:00	IWM	ETF	149.24	150.0	148.875	149.81	2665314.0
2019-02-04 11:00:00	IWM	ETF	149.8	150.345	149.75	150.29	2096927.0
2019-02-04 12:00:00	IWM	ETF	150.3	150.49	150.26	150.395	1159799.0
2019-02-04 13:00:00	IWM	ETF	150.4	150.58	150.34	150.51	1052520.0
2019-02-04 14:00:00	IWM	ETF	150.52	150.64	150.44	150.555	988694.0
2019-02-04 15:00:00	IWM	ETF	150.56	150.95	150.32	150.95	3582758.0
2019-02-04 16:00:00	IWM	ETF	150.95	150.97	150.1153	150.79	2824957.0
2019-02-04 17:00:00	IWM	ETF	150.8	150.96	149.3442	150.78	315625.0
2019-02-04 18:00:00	IWM	ETF	150.77	150.91	150.71	150.75	96193.0
2019-02-04 19:00:00	IWM	ETF	150.84	150.88	150.71	150.72	34217.0
2019-02-04 04:00:00	DIA	ETF	250.37	250.41	250.33	250.41	2178.0
2019-02-04 07:00:00	DIA	ETF	250.62	250.62	250.6	250.6	350.0

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

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