PREVIEW / etf_1hour / 2018-12-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-12.parquet
  size:    321 KB
  rows:    10,581

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-12-12 04:00:00	SPY	ETF	265.5	266.95	265.5	266.82	74558.0
2018-12-12 05:00:00	SPY	ETF	266.72	266.81	266.44	266.61	37308.0
2018-12-12 06:00:00	SPY	ETF	266.6	266.6	266.09	266.44	130648.0
2018-12-12 07:00:00	SPY	ETF	266.36	267.15	266.06	266.72	274255.0
2018-12-12 08:00:00	SPY	ETF	266.32	267.99	264.96	267.68	1150895.0
2018-12-12 09:00:00	SPY	ETF	267.68	267.7	266.47	267.0697	10442414.0
2018-12-12 10:00:00	SPY	ETF	267.075	268.24	266.705	268.11	14304172.0
2018-12-12 11:00:00	SPY	ETF	268.11	268.48	267.5	268.36	8493215.0
2018-12-12 12:00:00	SPY	ETF	268.37	268.77	267.87	268.66	8183114.0
2018-12-12 13:00:00	SPY	ETF	268.66	268.9485	267.92	268.22	5615823.0
2018-12-12 14:00:00	SPY	ETF	268.2	268.26	265.93	266.81	15393082.0
2018-12-12 15:00:00	SPY	ETF	266.815	269.0	265.37	265.51	22544743.0
2018-12-12 16:00:00	SPY	ETF	265.51	265.9374	265.03	265.42	9507308.0
2018-12-12 17:00:00	SPY	ETF	265.42	265.65	265.25	265.61	168014.0
2018-12-12 18:00:00	SPY	ETF	265.63	266.18	265.53	266.14	134075.0
2018-12-12 19:00:00	SPY	ETF	266.16	266.18	265.86	265.86	89700.0
2018-12-12 04:00:00	QQQ	ETF	164.7	165.9	164.7	165.74	86239.0
2018-12-12 05:00:00	QQQ	ETF	165.77	165.83	165.5	165.6	34836.0
2018-12-12 06:00:00	QQQ	ETF	165.49	165.5	165.2	165.27	16145.0
2018-12-12 07:00:00	QQQ	ETF	165.35	165.9	165.15	165.57	121714.0
2018-12-12 08:00:00	QQQ	ETF	165.35	166.41	163.61	166.27	1237929.0
2018-12-12 09:00:00	QQQ	ETF	166.27	166.32	165.34	166.11	5707067.0
2018-12-12 10:00:00	QQQ	ETF	166.11	166.97	165.89	166.8799	7599706.0
2018-12-12 11:00:00	QQQ	ETF	166.88	167.47	166.68	167.32	4969756.0
2018-12-12 12:00:00	QQQ	ETF	167.33	167.51	166.86	167.43	4140987.0
2018-12-12 13:00:00	QQQ	ETF	167.43	167.6	166.9	167.045	3231361.0
2018-12-12 14:00:00	QQQ	ETF	167.04	167.09	165.34	165.95	6760344.0
2018-12-12 15:00:00	QQQ	ETF	165.94	166.4	164.96	165.04	8023537.0
2018-12-12 16:00:00	QQQ	ETF	165.04	165.19	164.59	164.99	4240167.0
2018-12-12 17:00:00	QQQ	ETF	165.0	165.14	164.87	165.13	39290.0
2018-12-12 18:00:00	QQQ	ETF	165.17	165.69	165.12	165.64	43176.0
2018-12-12 19:00:00	QQQ	ETF	165.63	165.65	165.44	165.46	28027.0
2018-12-12 04:00:00	IWM	ETF	144.24	145.0	144.24	145.0	2497.0
2018-12-12 05:00:00	IWM	ETF	144.68	144.79	144.6	144.6	14594.0
2018-12-12 06:00:00	IWM	ETF	144.65	144.65	144.45	144.48	12586.0
2018-12-12 07:00:00	IWM	ETF	144.55	145.01	144.5	144.77	24559.0
2018-12-12 08:00:00	IWM	ETF	144.4801	145.28	143.45	145.15	107964.0
2018-12-12 09:00:00	IWM	ETF	145.2	145.4	144.76	145.32	1970497.0
2018-12-12 10:00:00	IWM	ETF	145.32	146.75	145.01	146.465	3808630.0
2018-12-12 11:00:00	IWM	ETF	146.46	146.58	145.64	146.32	2785807.0
2018-12-12 12:00:00	IWM	ETF	146.32	146.5	145.72	146.38	1976056.0
2018-12-12 13:00:00	IWM	ETF	146.38	146.76	146.18	146.44	2667966.0
2018-12-12 14:00:00	IWM	ETF	146.44	146.48	145.16	145.52	2812798.0
2018-12-12 15:00:00	IWM	ETF	145.52	145.83	144.79	144.81	4337846.0
2018-12-12 16:00:00	IWM	ETF	144.81	146.5916	144.58	144.66	2059947.0
2018-12-12 17:00:00	IWM	ETF	144.9017	144.91	144.75	144.91	169200.0
2018-12-12 18:00:00	IWM	ETF	144.89	145.13	144.89	145.07	10352.0
2018-12-12 19:00:00	IWM	ETF	145.05	145.14	144.97	145.0	7600.0
2018-12-12 04:00:00	DIA	ETF	245.92	246.94	245.92	246.94	1630.0
2018-12-12 05:00:00	DIA	ETF	246.84	246.84	246.84	246.84	100.0

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

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