PREVIEW / etf_1hour / 2018-05-25

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-25.parquet
  size:    287 KB
  rows:    9,451

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-05-25 04:00:00	SPY	ETF	273.2	273.61	273.2	273.61	23429.0
2018-05-25 05:00:00	SPY	ETF	273.68	273.69	273.41	273.51	10838.0
2018-05-25 06:00:00	SPY	ETF	273.46	273.61	273.31	273.45	50338.0
2018-05-25 07:00:00	SPY	ETF	273.42	273.52	272.49	272.54	205655.0
2018-05-25 08:00:00	SPY	ETF	272.54	273.65	272.05	272.11	704135.0
2018-05-25 09:00:00	SPY	ETF	272.1	272.53	271.81	272.29	7175481.0
2018-05-25 10:00:00	SPY	ETF	272.28	272.86	272.12	272.52	6789145.0
2018-05-25 11:00:00	SPY	ETF	272.52	272.73	272.32	272.39	5079011.0
2018-05-25 12:00:00	SPY	ETF	272.39	272.48	271.89	272.1068	5969896.0
2018-05-25 13:00:00	SPY	ETF	272.095	272.2353	271.7	271.78	3592998.0
2018-05-25 14:00:00	SPY	ETF	271.78	272.13	271.58	271.685	4142305.0
2018-05-25 15:00:00	SPY	ETF	271.69	272.39	271.58	272.18	10438800.0
2018-05-25 16:00:00	SPY	ETF	272.19	272.29	271.95	272.25	10475046.0
2018-05-25 17:00:00	SPY	ETF	272.27	272.34	272.19	272.34	67179.0
2018-05-25 18:00:00	SPY	ETF	272.27	272.33	272.21	272.27	10098.0
2018-05-25 19:00:00	SPY	ETF	272.27	272.31	272.23	272.3	19894.0
2018-05-25 04:00:00	QQQ	ETF	169.88	170.23	169.88	170.23	12156.0
2018-05-25 05:00:00	QQQ	ETF	170.24	170.28	170.15	170.28	5700.0
2018-05-25 06:00:00	QQQ	ETF	170.2	170.3	170.11	170.15	15690.0
2018-05-25 07:00:00	QQQ	ETF	170.14	170.21	169.6	169.64	74851.0
2018-05-25 08:00:00	QQQ	ETF	169.6999	170.14	169.41	169.47	290318.0
2018-05-25 09:00:00	QQQ	ETF	169.45	169.99	169.21	169.885	3393540.0
2018-05-25 10:00:00	QQQ	ETF	169.87	170.31	169.73	170.11	4499880.0
2018-05-25 11:00:00	QQQ	ETF	170.1111	170.33	169.89	170.0801	2511045.0
2018-05-25 12:00:00	QQQ	ETF	170.08	170.17	169.7	169.98	2274614.0
2018-05-25 13:00:00	QQQ	ETF	169.98	170.11	169.56	169.61	1707791.0
2018-05-25 14:00:00	QQQ	ETF	169.61	169.9076	169.52	169.6033	2593496.0
2018-05-25 15:00:00	QQQ	ETF	169.6	169.84	169.52	169.73	4261020.0
2018-05-25 16:00:00	QQQ	ETF	169.73	169.77	169.55	169.77	2002970.0
2018-05-25 17:00:00	QQQ	ETF	169.81	169.81	169.57	169.74	5145.0
2018-05-25 18:00:00	QQQ	ETF	169.78	169.78	169.65	169.69	20781.0
2018-05-25 19:00:00	QQQ	ETF	169.72	169.77	169.7	169.71	9725.0
2018-05-25 04:00:00	IWM	ETF	162.34	162.57	162.34	162.57	2100.0
2018-05-25 06:00:00	IWM	ETF	162.44	162.56	162.44	162.44	2147.0
2018-05-25 07:00:00	IWM	ETF	162.46	162.46	162.0	162.0	5125.0
2018-05-25 08:00:00	IWM	ETF	162.0	162.47	161.8	161.81	53882.0
2018-05-25 09:00:00	IWM	ETF	161.85	162.0941	161.47	161.85	1640097.0
2018-05-25 10:00:00	IWM	ETF	161.85	162.075	161.57	161.73	1417759.0
2018-05-25 11:00:00	IWM	ETF	161.72	162.16	161.69	162.01	1005109.0
2018-05-25 12:00:00	IWM	ETF	162.01	162.05	161.81	161.905	975360.0
2018-05-25 13:00:00	IWM	ETF	161.91	161.95	161.6012	161.65	835193.0
2018-05-25 14:00:00	IWM	ETF	161.66	161.78	161.48	161.56	667250.0
2018-05-25 15:00:00	IWM	ETF	161.555	161.97	161.4934	161.76	2503788.0
2018-05-25 16:00:00	IWM	ETF	161.76	161.8701	142.68	161.74	770544.0
2018-05-25 17:00:00	IWM	ETF	161.74	161.79	161.74	161.79	3551.0
2018-05-25 19:00:00	IWM	ETF	161.84	161.84	161.84	161.84	100.0
2018-05-25 04:00:00	DIA	ETF	248.39	248.39	248.39	248.39	100.0
2018-05-25 06:00:00	DIA	ETF	248.56	248.56	248.56	248.56	100.0
2018-05-25 07:00:00	DIA	ETF	248.48	248.48	247.92	247.92	19945.0
2018-05-25 08:00:00	DIA	ETF	247.79	247.79	247.37	247.38	279700.0

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

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