PREVIEW / etf_1hour / 2018-04-16

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-04-16.parquet
  size:    294 KB
  rows:    9,645

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-04-16 04:00:00	SPY	ETF	266.0	266.43	266.0	266.43	6340.0
2018-04-16 05:00:00	SPY	ETF	266.41	266.96	266.41	266.96	49511.0
2018-04-16 06:00:00	SPY	ETF	266.92	267.01	266.69	266.84	79958.0
2018-04-16 07:00:00	SPY	ETF	266.91	267.01	266.5	266.63	260545.0
2018-04-16 08:00:00	SPY	ETF	266.64	267.19	265.8	267.17	992604.0
2018-04-16 09:00:00	SPY	ETF	267.19	267.29	266.07	266.44	6537999.0
2018-04-16 10:00:00	SPY	ETF	266.43	267.2	266.39	266.75	7533518.0
2018-04-16 11:00:00	SPY	ETF	266.77	267.13	266.4	267.0	4423006.0
2018-04-16 12:00:00	SPY	ETF	267.0	267.94	266.93	267.73	6443128.0
2018-04-16 13:00:00	SPY	ETF	267.72	268.2	267.72	268.0501	6220508.0
2018-04-16 14:00:00	SPY	ETF	268.06	268.11	267.38	267.63	6872914.0
2018-04-16 15:00:00	SPY	ETF	267.63	267.88	267.13	267.32	14670880.0
2018-04-16 16:00:00	SPY	ETF	267.33	267.87	267.3045	267.44	7489947.0
2018-04-16 17:00:00	SPY	ETF	267.52	267.57	267.4	267.41	132587.0
2018-04-16 18:00:00	SPY	ETF	267.47	267.74	267.38	267.73	553990.0
2018-04-16 19:00:00	SPY	ETF	267.68	267.83	267.57	267.63	37652.0
2018-04-16 04:00:00	QQQ	ETF	161.88	162.29	161.88	162.25	8359.0
2018-04-16 05:00:00	QQQ	ETF	162.18	162.72	162.18	162.69	9220.0
2018-04-16 06:00:00	QQQ	ETF	162.56	162.72	162.41	162.64	28880.0
2018-04-16 07:00:00	QQQ	ETF	162.59	162.6	162.25	162.33	230189.0
2018-04-16 08:00:00	QQQ	ETF	162.36	162.79	162.25	162.79	260482.0
2018-04-16 09:00:00	QQQ	ETF	162.77	162.79	161.6	161.81	3385761.0
2018-04-16 10:00:00	QQQ	ETF	161.82	162.56	161.81	162.05	3221253.0
2018-04-16 11:00:00	QQQ	ETF	162.06	162.2892	161.48	162.2559	2161885.0
2018-04-16 12:00:00	QQQ	ETF	162.27	162.97	162.27	162.905	2601911.0
2018-04-16 13:00:00	QQQ	ETF	162.905	163.19	162.88	163.0	3022431.0
2018-04-16 14:00:00	QQQ	ETF	163.0	163.06	162.57	162.7	1863947.0
2018-04-16 15:00:00	QQQ	ETF	162.695	162.85	162.285	162.54	5664469.0
2018-04-16 16:00:00	QQQ	ETF	162.56	163.41	162.54	163.02	1852727.0
2018-04-16 17:00:00	QQQ	ETF	163.15	163.15	162.95	163.0	24306.0
2018-04-16 18:00:00	QQQ	ETF	163.03	163.14	162.93	163.02	20180.0
2018-04-16 19:00:00	QQQ	ETF	163.0	163.22	163.0	163.02	27450.0
2018-04-16 04:00:00	IWM	ETF	154.6	154.6	154.6	154.6	988.0
2018-04-16 06:00:00	IWM	ETF	154.89	154.89	154.89	154.89	500.0
2018-04-16 07:00:00	IWM	ETF	154.54	154.6	154.46	154.53	81592.0
2018-04-16 08:00:00	IWM	ETF	154.5	154.9	154.43	154.9	73272.0
2018-04-16 09:00:00	IWM	ETF	154.9	154.98	154.11	154.22	1442389.0
2018-04-16 10:00:00	IWM	ETF	154.24	155.06	154.24	154.6	2019379.0
2018-04-16 11:00:00	IWM	ETF	154.6	155.18	154.51	154.91	1050570.0
2018-04-16 12:00:00	IWM	ETF	154.96	155.4	154.96	155.27	1130971.0
2018-04-16 13:00:00	IWM	ETF	155.28	155.78	155.28	155.69	1858279.0
2018-04-16 14:00:00	IWM	ETF	155.68	155.82	155.34	155.55	1587872.0
2018-04-16 15:00:00	IWM	ETF	155.54	155.73	155.34	155.36	2864074.0
2018-04-16 16:00:00	IWM	ETF	155.36	155.68	155.3	155.35	1651718.0
2018-04-16 17:00:00	IWM	ETF	155.37	155.37	155.34	155.34	64969.0
2018-04-16 18:00:00	IWM	ETF	155.37	155.52	155.31	155.52	40244.0
2018-04-16 19:00:00	IWM	ETF	155.53	155.53	155.4	155.4	10736.0
2018-04-16 04:00:00	DIA	ETF	243.64	244.62	243.64	244.62	300.0
2018-04-16 05:00:00	DIA	ETF	244.6	244.6	244.6	244.6	200.0
2018-04-16 07:00:00	DIA	ETF	245.16	245.16	244.9	245.0	3980.0

> showing 50 of 9,645 rows — these rows as CSV

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