PREVIEW / etf_1hour / 2019-05-10

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-10.parquet
  size:    319 KB
  rows:    10,591

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-05-10 04:00:00	SPY	ETF	286.4	286.52	285.85	286.25	30085.0
2019-05-10 05:00:00	SPY	ETF	286.33	286.66	286.11	286.2	44304.0
2019-05-10 06:00:00	SPY	ETF	286.2	287.02	285.99	286.15	240198.0
2019-05-10 07:00:00	SPY	ETF	286.17	286.28	285.23	285.33	1031790.0
2019-05-10 08:00:00	SPY	ETF	286.17	287.0	284.57	285.22	1548856.0
2019-05-10 09:00:00	SPY	ETF	285.2	286.36	285.15	285.5815	7620926.0
2019-05-10 10:00:00	SPY	ETF	285.575	285.64	282.56	282.93	15617219.0
2019-05-10 11:00:00	SPY	ETF	282.91	283.7	282.3	283.16	15022801.0
2019-05-10 12:00:00	SPY	ETF	283.14	285.63	283.12	285.365	12656660.0
2019-05-10 13:00:00	SPY	ETF	285.38	286.88	285.19	286.604	11370321.0
2019-05-10 14:00:00	SPY	ETF	286.62	287.41	286.01	287.09	9168741.0
2019-05-10 15:00:00	SPY	ETF	287.1	288.94	287.1	288.02	26398649.0
2019-05-10 16:00:00	SPY	ETF	288.02	288.56	287.4741	288.37	10297883.0
2019-05-10 17:00:00	SPY	ETF	288.37	288.44	288.01	288.42	194767.0
2019-05-10 18:00:00	SPY	ETF	288.42	288.46	288.33	288.44	26232.0
2019-05-10 19:00:00	SPY	ETF	288.45	288.49	288.3	288.49	36241.0
2019-05-10 04:00:00	QQQ	ETF	184.48	184.75	184.24	184.57	27670.0
2019-05-10 05:00:00	QQQ	ETF	184.6	184.97	184.55	184.6	29910.0
2019-05-10 06:00:00	QQQ	ETF	184.55	185.21	184.4	184.5	70687.0
2019-05-10 07:00:00	QQQ	ETF	184.53	184.63	183.83	183.88	320316.0
2019-05-10 08:00:00	QQQ	ETF	183.89	185.12	183.19	183.68	645314.0
2019-05-10 09:00:00	QQQ	ETF	183.68	184.71	183.65	183.79	4319950.0
2019-05-10 10:00:00	QQQ	ETF	183.7951	183.83	181.21	181.61	9033546.0
2019-05-10 11:00:00	QQQ	ETF	181.6	182.16	181.0302	181.58	8654373.0
2019-05-10 12:00:00	QQQ	ETF	181.58	183.46	181.57	183.235	6349017.0
2019-05-10 13:00:00	QQQ	ETF	183.235	184.375	183.1	184.28	6623892.0
2019-05-10 14:00:00	QQQ	ETF	184.26	184.64	183.67	184.46	3912445.0
2019-05-10 15:00:00	QQQ	ETF	184.48	185.89	184.47	185.01	10653776.0
2019-05-10 16:00:00	QQQ	ETF	185.02	185.42	184.88	185.27	1355249.0
2019-05-10 17:00:00	QQQ	ETF	185.19	185.31	185.0	185.27	19173.0
2019-05-10 18:00:00	QQQ	ETF	185.25	185.4	185.22	185.4	10565.0
2019-05-10 19:00:00	QQQ	ETF	185.39	185.39	185.1	185.2	17347.0
2019-05-10 04:00:00	IWM	ETF	156.4	156.4	155.76	155.8	5450.0
2019-05-10 05:00:00	IWM	ETF	156.09	156.14	156.07	156.07	3488.0
2019-05-10 06:00:00	IWM	ETF	155.96	156.3	155.93	155.94	9177.0
2019-05-10 07:00:00	IWM	ETF	155.89	155.89	155.34	155.34	62218.0
2019-05-10 08:00:00	IWM	ETF	155.83	156.25	155.1	155.44	91066.0
2019-05-10 09:00:00	IWM	ETF	155.47	156.13	155.38	155.8	1710125.0
2019-05-10 10:00:00	IWM	ETF	155.76	155.83	153.81	153.885	4679662.0
2019-05-10 11:00:00	IWM	ETF	153.87	154.53	153.67	154.28	4436188.0
2019-05-10 12:00:00	IWM	ETF	154.26	155.55	154.26	155.44	2713272.0
2019-05-10 13:00:00	IWM	ETF	155.44	156.21	155.35	155.925	2689219.0
2019-05-10 14:00:00	IWM	ETF	155.92	156.24	155.5805	155.99	1554996.0
2019-05-10 15:00:00	IWM	ETF	155.99	156.83	155.98	156.55	4064291.0
2019-05-10 16:00:00	IWM	ETF	156.55	157.1	156.53	156.96	1167455.0
2019-05-10 17:00:00	IWM	ETF	156.96	156.96	156.86	156.94	2700.0
2019-05-10 18:00:00	IWM	ETF	156.9	156.97	156.9	156.97	2000.0
2019-05-10 19:00:00	IWM	ETF	156.99	156.99	156.8	156.81	3224.0
2019-05-10 07:00:00	DIA	ETF	257.95	257.96	257.46	257.47	4000.0
2019-05-10 08:00:00	DIA	ETF	257.61	257.97	256.87	257.32	19543.0

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

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