PREVIEW / etf_1hour / 2018-01-11

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-01-11.parquet
  size:    309 KB
  rows:    10,117

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-01-11 04:00:00	SPY	ETF	274.69	274.69	274.53	274.56	19120.0
2018-01-11 05:00:00	SPY	ETF	274.53	274.58	274.41	274.56	30510.0
2018-01-11 06:00:00	SPY	ETF	274.59	274.69	274.58	274.6	15769.0
2018-01-11 07:00:00	SPY	ETF	274.58	274.94	274.58	274.83	436257.0
2018-01-11 08:00:00	SPY	ETF	274.8	274.88	274.61	274.61	251235.0
2018-01-11 09:00:00	SPY	ETF	274.63	275.07	274.56	275.07	4666309.0
2018-01-11 10:00:00	SPY	ETF	275.065	275.24	274.64	275.12	6524933.0
2018-01-11 11:00:00	SPY	ETF	275.12	275.3326	274.99	275.1945	5927717.0
2018-01-11 12:00:00	SPY	ETF	275.2	275.75	275.13	275.65	7758491.0
2018-01-11 13:00:00	SPY	ETF	275.66	275.83	275.52	275.55	8715664.0
2018-01-11 14:00:00	SPY	ETF	275.555	275.64	275.48	275.6	3787360.0
2018-01-11 15:00:00	SPY	ETF	275.6	276.09	275.55	276.08	15413759.0
2018-01-11 16:00:00	SPY	ETF	276.08	276.3	274.8904	276.24	6326145.0
2018-01-11 17:00:00	SPY	ETF	276.22	276.22	276.12	276.13	251593.0
2018-01-11 18:00:00	SPY	ETF	276.15	276.22	276.13	276.16	57263.0
2018-01-11 19:00:00	SPY	ETF	276.15	276.15	275.99	276.12	49535.0
2018-01-11 04:00:00	QQQ	ETF	162.39	162.42	162.38	162.42	22600.0
2018-01-11 05:00:00	QQQ	ETF	162.41	162.42	162.3	162.39	2700.0
2018-01-11 06:00:00	QQQ	ETF	162.42	162.5	162.4	162.48	9402.0
2018-01-11 07:00:00	QQQ	ETF	162.48	162.78	162.47	162.7	53277.0
2018-01-11 08:00:00	QQQ	ETF	162.18	162.72	162.18	162.5	110011.0
2018-01-11 09:00:00	QQQ	ETF	162.48	162.62	162.32	162.5936	1957433.0
2018-01-11 10:00:00	QQQ	ETF	162.585	162.76	162.21	162.54	2931774.0
2018-01-11 11:00:00	QQQ	ETF	162.54	162.71	162.51	162.6956	1328677.0
2018-01-11 12:00:00	QQQ	ETF	162.69	163.13	162.6	163.11	1850131.0
2018-01-11 13:00:00	QQQ	ETF	163.11	163.185	162.95	162.9962	1529230.0
2018-01-11 14:00:00	QQQ	ETF	163.0	163.05	162.9	162.965	1394591.0
2018-01-11 15:00:00	QQQ	ETF	162.96	163.3	162.91	163.3	3442221.0
2018-01-11 16:00:00	QQQ	ETF	163.28	163.56	162.4743	163.45	1065764.0
2018-01-11 17:00:00	QQQ	ETF	163.44	163.48	163.44	163.47	11759.0
2018-01-11 18:00:00	QQQ	ETF	163.46	163.46	163.37	163.4	32259.0
2018-01-11 19:00:00	QQQ	ETF	163.36	163.4	163.33	163.38	4300.0
2018-01-11 05:00:00	IWM	ETF	154.88	154.9	154.85	154.9	6138.0
2018-01-11 06:00:00	IWM	ETF	154.95	154.95	154.95	154.95	500.0
2018-01-11 07:00:00	IWM	ETF	154.99	155.28	154.99	155.15	27698.0
2018-01-11 08:00:00	IWM	ETF	155.15	155.16	154.95	154.98	114470.0
2018-01-11 09:00:00	IWM	ETF	154.98	156.0	154.98	155.87	2204373.0
2018-01-11 10:00:00	IWM	ETF	155.88	156.89	155.825	156.84	2738856.0
2018-01-11 11:00:00	IWM	ETF	156.85	157.03	156.72	156.9001	2766237.0
2018-01-11 12:00:00	IWM	ETF	156.91	157.51	156.765	157.505	2175136.0
2018-01-11 13:00:00	IWM	ETF	157.51	157.55	157.05	157.18	1383258.0
2018-01-11 14:00:00	IWM	ETF	157.19	157.6	157.1	157.56	1560522.0
2018-01-11 15:00:00	IWM	ETF	157.56	157.66	157.28	157.49	5080190.0
2018-01-11 16:00:00	IWM	ETF	157.48	157.62	156.69	157.4	2174837.0
2018-01-11 17:00:00	IWM	ETF	157.49	157.5	157.4	157.4	9871.0
2018-01-11 18:00:00	IWM	ETF	157.4	157.42	157.36	157.36	12403.0
2018-01-11 19:00:00	IWM	ETF	157.36	157.42	157.28	157.39	22296.0
2018-01-11 06:00:00	DIA	ETF	253.97	253.97	253.97	253.97	100.0
2018-01-11 07:00:00	DIA	ETF	254.0	254.0	254.0	254.0	500.0
2018-01-11 08:00:00	DIA	ETF	254.1	254.1	253.9	253.9	16622.0

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

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