PREVIEW / etf_1hour / 2018-06-14

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-06-14.parquet
  size:    296 KB
  rows:    9,723

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-06-14 04:00:00	SPY	ETF	277.81	277.85	277.38	277.8	44617.0
2018-06-14 05:00:00	SPY	ETF	277.83	277.95	277.73	277.82	9954.0
2018-06-14 06:00:00	SPY	ETF	277.73	277.98	277.68	277.83	44531.0
2018-06-14 07:00:00	SPY	ETF	277.89	278.42	277.76	278.28	280284.0
2018-06-14 08:00:00	SPY	ETF	278.28	278.84	277.23	278.65	1257192.0
2018-06-14 09:00:00	SPY	ETF	278.66	279.12	278.57	278.7	8298246.0
2018-06-14 10:00:00	SPY	ETF	278.7	279.33	278.29	278.3	11743597.0
2018-06-14 11:00:00	SPY	ETF	278.29	278.9	278.0599	278.77	8016814.0
2018-06-14 12:00:00	SPY	ETF	278.77	278.89	278.44	278.46	4575591.0
2018-06-14 13:00:00	SPY	ETF	278.47	279.05	278.39	278.7	5043693.0
2018-06-14 14:00:00	SPY	ETF	278.7	278.8062	278.315	278.36	4430354.0
2018-06-14 15:00:00	SPY	ETF	278.36	278.95	278.27	278.72	14399413.0
2018-06-14 16:00:00	SPY	ETF	278.7	278.84	278.03	278.75	9199288.0
2018-06-14 17:00:00	SPY	ETF	278.74	278.8	278.61	278.61	6555693.0
2018-06-14 18:00:00	SPY	ETF	278.66	278.72	278.44	278.6	144164.0
2018-06-14 19:00:00	SPY	ETF	278.6	278.71	278.54	278.71	12587.0
2018-06-14 04:00:00	QQQ	ETF	175.42	175.53	175.28	175.41	14656.0
2018-06-14 05:00:00	QQQ	ETF	175.53	175.61	175.37	175.39	21550.0
2018-06-14 06:00:00	QQQ	ETF	175.4	175.69	175.4	175.53	8600.0
2018-06-14 07:00:00	QQQ	ETF	175.6	176.24	175.54	176.1	114301.0
2018-06-14 08:00:00	QQQ	ETF	175.86	176.49	175.61	176.41	339982.0
2018-06-14 09:00:00	QQQ	ETF	176.41	177.16	176.36	176.8	4112398.0
2018-06-14 10:00:00	QQQ	ETF	176.8	177.6333	176.8	176.97	5050066.0
2018-06-14 11:00:00	QQQ	ETF	176.9784	177.6999	176.72	177.46	5039340.0
2018-06-14 12:00:00	QQQ	ETF	177.46	177.6	177.335	177.375	1911158.0
2018-06-14 13:00:00	QQQ	ETF	177.37	177.89	177.31	177.64	2741076.0
2018-06-14 14:00:00	QQQ	ETF	177.64	177.705	177.115	177.16	2719336.0
2018-06-14 15:00:00	QQQ	ETF	177.1601	177.72	177.15	177.6	5115790.0
2018-06-14 16:00:00	QQQ	ETF	177.6	177.72	177.55	177.69	1225115.0
2018-06-14 17:00:00	QQQ	ETF	177.69	177.69	177.6	177.62	1871.0
2018-06-14 18:00:00	QQQ	ETF	177.61	177.63	177.46	177.5	32958.0
2018-06-14 19:00:00	QQQ	ETF	177.56	177.67	177.54	177.67	15612.0
2018-06-14 04:00:00	IWM	ETF	166.73	166.73	166.73	166.73	500.0
2018-06-14 05:00:00	IWM	ETF	166.7	166.7	166.7	166.7	500.0
2018-06-14 06:00:00	IWM	ETF	166.8	166.8	166.71	166.74	10494.0
2018-06-14 07:00:00	IWM	ETF	166.77	167.09	166.75	167.05	48876.0
2018-06-14 08:00:00	IWM	ETF	166.84	167.35	166.82	167.19	50775.0
2018-06-14 09:00:00	IWM	ETF	167.26	167.65	167.2	167.3	2093170.0
2018-06-14 10:00:00	IWM	ETF	167.3	167.81	166.73	166.73	4284814.0
2018-06-14 11:00:00	IWM	ETF	166.72	167.63	166.61	167.55	1593924.0
2018-06-14 12:00:00	IWM	ETF	167.54	167.8399	167.26	167.31	1516956.0
2018-06-14 13:00:00	IWM	ETF	167.32	167.58	167.22	167.29	1422118.0
2018-06-14 14:00:00	IWM	ETF	167.3	167.49	167.13	167.3	1431842.0
2018-06-14 15:00:00	IWM	ETF	167.31	167.83	167.255	167.76	3018198.0
2018-06-14 16:00:00	IWM	ETF	167.77	167.96	167.76	167.96	857572.0
2018-06-14 17:00:00	IWM	ETF	167.96	167.96	167.81	167.82	8017.0
2018-06-14 18:00:00	IWM	ETF	167.82	167.86	167.74	167.78	14981.0
2018-06-14 19:00:00	IWM	ETF	167.79	167.79	167.76	167.76	2000.0
2018-06-14 07:00:00	DIA	ETF	252.14	252.5	252.14	252.5	1255.0
2018-06-14 08:00:00	DIA	ETF	252.65	253.1	252.65	252.92	15511.0

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

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