PREVIEW / etf_1hour / 2019-04-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-04-03.parquet
  size:    327 KB
  rows:    10,848

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
2019-04-03 04:00:00	SPY	ETF	286.93	287.24	286.93	287.1	16778.0
2019-04-03 05:00:00	SPY	ETF	287.1	287.14	286.96	287.0	10302.0
2019-04-03 06:00:00	SPY	ETF	286.96	287.02	286.85	287.0	92774.0
2019-04-03 07:00:00	SPY	ETF	286.9	287.25	286.89	287.2	143487.0
2019-04-03 08:00:00	SPY	ETF	287.17	287.46	286.9	287.26	490338.0
2019-04-03 09:00:00	SPY	ETF	287.28	287.43	286.73	286.77	6510319.0
2019-04-03 10:00:00	SPY	ETF	286.76	287.38	286.36	287.31	8627288.0
2019-04-03 11:00:00	SPY	ETF	287.32	287.76	287.3	287.62	6317227.0
2019-04-03 12:00:00	SPY	ETF	287.63	287.75	287.22	287.35	3499283.0
2019-04-03 13:00:00	SPY	ETF	287.35	287.51	286.44	286.5	9415225.0
2019-04-03 14:00:00	SPY	ETF	286.5	286.765	286.17	286.3277	7333374.0
2019-04-03 15:00:00	SPY	ETF	286.3238	286.725	285.75	286.52	16125693.0
2019-04-03 16:00:00	SPY	ETF	286.52	286.86	286.4053	286.8	8148844.0
2019-04-03 17:00:00	SPY	ETF	286.75	286.9	286.75	286.9	107839.0
2019-04-03 18:00:00	SPY	ETF	286.89	286.95	286.7	286.73	105289.0
2019-04-03 19:00:00	SPY	ETF	286.74	286.88	286.65	286.68	43075.0
2019-04-03 04:00:00	QQQ	ETF	183.92	183.98	183.75	183.78	20220.0
2019-04-03 05:00:00	QQQ	ETF	183.74	183.81	183.67	183.69	23007.0
2019-04-03 06:00:00	QQQ	ETF	183.63	183.68	183.57	183.68	12554.0
2019-04-03 07:00:00	QQQ	ETF	183.57	183.79	183.56	183.74	186573.0
2019-04-03 08:00:00	QQQ	ETF	183.71	183.93	183.555	183.76	231978.0
2019-04-03 09:00:00	QQQ	ETF	183.78	183.88	183.45	183.73	3212819.0
2019-04-03 10:00:00	QQQ	ETF	183.73	184.39	183.42	184.3744	4601245.0
2019-04-03 11:00:00	QQQ	ETF	184.38	184.91	184.38	184.7999	5007701.0
2019-04-03 12:00:00	QQQ	ETF	184.7953	184.92	184.44	184.505	2483981.0
2019-04-03 13:00:00	QQQ	ETF	184.5	184.59	183.62	183.68	3007840.0
2019-04-03 14:00:00	QQQ	ETF	183.67	183.94	183.49	183.66	3115274.0
2019-04-03 15:00:00	QQQ	ETF	183.66	183.89	183.2089	183.78	5179656.0
2019-04-03 16:00:00	QQQ	ETF	183.77	184.13	183.74	184.06	945710.0
2019-04-03 17:00:00	QQQ	ETF	184.07	184.33	184.04	184.18	12940.0
2019-04-03 18:00:00	QQQ	ETF	184.12	184.13	183.95	183.99	18032.0
2019-04-03 19:00:00	QQQ	ETF	183.98	184.1	183.9	184.02	30761.0
2019-04-03 04:00:00	IWM	ETF	154.92	155.08	154.92	155.02	3333.0
2019-04-03 05:00:00	IWM	ETF	155.06	155.06	155.02	155.04	7072.0
2019-04-03 06:00:00	IWM	ETF	155.0	155.0	154.98	155.0	3400.0
2019-04-03 07:00:00	IWM	ETF	155.03	155.22	155.01	155.21	14548.0
2019-04-03 08:00:00	IWM	ETF	155.22	155.62	155.2	155.58	131925.0
2019-04-03 09:00:00	IWM	ETF	155.6	156.15	155.32	155.75	3238252.0
2019-04-03 10:00:00	IWM	ETF	155.73	155.89	155.165	155.67	3269760.0
2019-04-03 11:00:00	IWM	ETF	155.685	156.13	155.04	155.55	2684495.0
2019-04-03 12:00:00	IWM	ETF	155.56	156.02	155.53	155.71	1711391.0
2019-04-03 13:00:00	IWM	ETF	155.7	155.87	155.14	155.17	1388527.0
2019-04-03 14:00:00	IWM	ETF	155.16	155.43	154.95	155.23	1743079.0
2019-04-03 15:00:00	IWM	ETF	155.22	155.36	154.73	155.15	2730888.0
2019-04-03 16:00:00	IWM	ETF	155.15	155.4	155.13	155.36	1155047.0
2019-04-03 17:00:00	IWM	ETF	155.4	155.4	155.4	155.4	300.0
2019-04-03 18:00:00	IWM	ETF	155.44	155.45	155.39	155.39	2900.0
2019-04-03 19:00:00	IWM	ETF	155.41	155.41	155.25	155.25	6700.0
2019-04-03 06:00:00	DIA	ETF	262.4	262.4	262.4	262.4	250.0
2019-04-03 07:00:00	DIA	ETF	262.45	262.66	262.45	262.51	1240.0

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

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