PREVIEW / etf_1hour / 2019-01-29

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-01-29.parquet
  size:    317 KB
  rows:    10,368

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-01-29 04:00:00	SPY	ETF	263.37	263.68	263.32	263.57	7689.0
2019-01-29 05:00:00	SPY	ETF	263.57	263.82	263.45	263.58	17929.0
2019-01-29 06:00:00	SPY	ETF	263.62	263.83	263.37	263.81	18250.0
2019-01-29 07:00:00	SPY	ETF	263.81	264.15	263.65	264.02	187386.0
2019-01-29 08:00:00	SPY	ETF	263.76	264.28	262.85	264.2	270485.0
2019-01-29 09:00:00	SPY	ETF	264.2	264.49	263.56	264.2	5665644.0
2019-01-29 10:00:00	SPY	ETF	264.2	264.55	262.48	262.73	11404808.0
2019-01-29 11:00:00	SPY	ETF	262.73	263.49	262.53	263.4	8854960.0
2019-01-29 12:00:00	SPY	ETF	263.39	263.98	263.2385	263.5	5547318.0
2019-01-29 13:00:00	SPY	ETF	263.49	263.99	263.3	263.8655	4057690.0
2019-01-29 14:00:00	SPY	ETF	263.8699	263.8699	262.965	263.0	5462482.0
2019-01-29 15:00:00	SPY	ETF	263.0	263.59	262.9	263.43	14647159.0
2019-01-29 16:00:00	SPY	ETF	263.44	264.4	263.2	264.35	7112817.0
2019-01-29 17:00:00	SPY	ETF	264.22	264.69	264.2	264.42	538893.0
2019-01-29 18:00:00	SPY	ETF	264.5	264.6	263.58	264.05	788724.0
2019-01-29 19:00:00	SPY	ETF	264.05	264.11	263.74	263.95	180214.0
2019-01-29 04:00:00	QQQ	ETF	162.52	162.76	162.52	162.7	17397.0
2019-01-29 05:00:00	QQQ	ETF	162.7	162.94	162.66	162.74	95212.0
2019-01-29 06:00:00	QQQ	ETF	162.74	163.0	162.57	163.0	78174.0
2019-01-29 07:00:00	QQQ	ETF	162.98	163.35	162.91	163.31	132793.0
2019-01-29 08:00:00	QQQ	ETF	163.17	163.51	162.24	163.44	148796.0
2019-01-29 09:00:00	QQQ	ETF	163.44	163.49	162.45	162.72	2313176.0
2019-01-29 10:00:00	QQQ	ETF	162.71	163.11	160.99	161.21	5003526.0
2019-01-29 11:00:00	QQQ	ETF	161.22	161.7	161.05	161.5386	3311645.0
2019-01-29 12:00:00	QQQ	ETF	161.54	162.07	161.4154	161.84	2176249.0
2019-01-29 13:00:00	QQQ	ETF	161.835	162.03	161.59	161.971	1529042.0
2019-01-29 14:00:00	QQQ	ETF	161.97	161.97	161.26	161.2923	2084925.0
2019-01-29 15:00:00	QQQ	ETF	161.29	161.695	161.2	161.51	5062422.0
2019-01-29 16:00:00	QQQ	ETF	161.51	162.68	161.03	162.55	1824371.0
2019-01-29 17:00:00	QQQ	ETF	162.54	163.1	162.33	162.9	223119.0
2019-01-29 18:00:00	QQQ	ETF	162.82	163.05	162.54	162.54	119806.0
2019-01-29 19:00:00	QQQ	ETF	162.54	162.58	162.3	162.53	178291.0
2019-01-29 05:00:00	IWM	ETF	146.36	146.36	146.36	146.36	100.0
2019-01-29 07:00:00	IWM	ETF	146.29	146.58	146.29	146.56	20800.0
2019-01-29 08:00:00	IWM	ETF	146.5	146.95	146.5	146.8	75674.0
2019-01-29 09:00:00	IWM	ETF	146.76	146.82	146.22	146.5796	1244949.0
2019-01-29 10:00:00	IWM	ETF	146.57	146.81	145.88	145.995	2330831.0
2019-01-29 11:00:00	IWM	ETF	146.0	146.65	145.88	146.575	1668707.0
2019-01-29 12:00:00	IWM	ETF	146.58	146.74	146.34	146.35	1146129.0
2019-01-29 13:00:00	IWM	ETF	146.34	146.79	146.2	146.7847	807843.0
2019-01-29 14:00:00	IWM	ETF	146.79	146.8	146.26	146.28	960563.0
2019-01-29 15:00:00	IWM	ETF	146.29	146.58	146.19	146.2	2316732.0
2019-01-29 16:00:00	IWM	ETF	146.21	146.62	146.1	146.54	573617.0
2019-01-29 17:00:00	IWM	ETF	146.5401	146.7	146.54	146.61	23760.0
2019-01-29 18:00:00	IWM	ETF	146.62	146.63	146.2	146.48	23781.0
2019-01-29 19:00:00	IWM	ETF	146.32	146.38	146.3	146.38	5040.0
2019-01-29 04:00:00	DIA	ETF	244.66	244.84	244.66	244.84	200.0
2019-01-29 05:00:00	DIA	ETF	245.06	245.12	245.06	245.12	362.0
2019-01-29 06:00:00	DIA	ETF	244.7	244.7	244.62	244.62	1027.0
2019-01-29 07:00:00	DIA	ETF	245.08	245.6	245.08	245.6	6017.0

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

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