PREVIEW / etf_1hour / 2019-08-01

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-08-01.parquet
  size:    349 KB
  rows:    11,424

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-08-01 04:00:00	SPY	ETF	297.76	297.9	297.39	297.76	27221.0
2019-08-01 05:00:00	SPY	ETF	297.73	298.38	297.73	298.32	56042.0
2019-08-01 06:00:00	SPY	ETF	298.31	298.37	298.08	298.11	19280.0
2019-08-01 07:00:00	SPY	ETF	298.05	298.29	297.8	297.93	217121.0
2019-08-01 08:00:00	SPY	ETF	297.913	298.26	297.3	297.78	511603.0
2019-08-01 09:00:00	SPY	ETF	297.75	298.81	297.27	298.66	8452298.0
2019-08-01 10:00:00	SPY	ETF	298.66	300.28	298.34	300.24	10529892.0
2019-08-01 11:00:00	SPY	ETF	300.24	300.87	299.98	300.42	8697246.0
2019-08-01 12:00:00	SPY	ETF	300.42	300.61	300.07	300.38	4995857.0
2019-08-01 13:00:00	SPY	ETF	300.38	300.48	295.17	296.41	31186172.0
2019-08-01 14:00:00	SPY	ETF	296.4	296.54	293.96	295.2	33933647.0
2019-08-01 15:00:00	SPY	ETF	295.21	295.96	294.4	294.88	29946615.0
2019-08-01 16:00:00	SPY	ETF	294.92	297.5254	294.26	294.33	11379413.0
2019-08-01 17:00:00	SPY	ETF	294.32	294.84	294.07	294.41	158700.0
2019-08-01 18:00:00	SPY	ETF	294.4	294.84	293.72	293.92	152179.0
2019-08-01 19:00:00	SPY	ETF	294.04	294.26	293.99	294.06	102583.0
2019-08-01 04:00:00	QQQ	ETF	191.5	191.57	191.21	191.49	48919.0
2019-08-01 05:00:00	QQQ	ETF	191.47	192.04	191.47	191.99	24137.0
2019-08-01 06:00:00	QQQ	ETF	191.96	192.07	191.85	191.85	27070.0
2019-08-01 07:00:00	QQQ	ETF	191.86	191.99	191.59	191.67	184869.0
2019-08-01 08:00:00	QQQ	ETF	191.67	191.9	190.75	191.67	197686.0
2019-08-01 09:00:00	QQQ	ETF	191.61	193.07	191.27	192.92	5052604.0
2019-08-01 10:00:00	QQQ	ETF	192.91	194.57	192.86	194.53	6844323.0
2019-08-01 11:00:00	QQQ	ETF	194.525	194.98	194.36	194.55	4317602.0
2019-08-01 12:00:00	QQQ	ETF	194.56	194.77	194.32	194.53	1583943.0
2019-08-01 13:00:00	QQQ	ETF	194.53	194.615	190.42	191.44	13326404.0
2019-08-01 14:00:00	QQQ	ETF	191.44	191.59	189.23	190.28	12127547.0
2019-08-01 15:00:00	QQQ	ETF	190.28	190.96	189.7	190.11	10326863.0
2019-08-01 16:00:00	QQQ	ETF	190.12	190.7437	189.51	189.54	2865735.0
2019-08-01 17:00:00	QQQ	ETF	189.69	190.15	189.51	189.75	134527.0
2019-08-01 18:00:00	QQQ	ETF	189.75	190.15	189.18	189.45	263200.0
2019-08-01 19:00:00	QQQ	ETF	189.46	189.64	189.4	189.47	33450.0
2019-08-01 04:00:00	IWM	ETF	156.96	156.96	156.85	156.85	500.0
2019-08-01 05:00:00	IWM	ETF	157.0	157.23	157.0	157.15	9700.0
2019-08-01 06:00:00	IWM	ETF	157.18	157.18	157.18	157.18	300.0
2019-08-01 07:00:00	IWM	ETF	157.1	157.25	156.99	157.03	9860.0
2019-08-01 08:00:00	IWM	ETF	157.11	157.23	156.79	156.86	65388.0
2019-08-01 09:00:00	IWM	ETF	156.9	157.81	156.58	157.46	4220758.0
2019-08-01 10:00:00	IWM	ETF	157.46	158.02	157.11	157.67	2998630.0
2019-08-01 11:00:00	IWM	ETF	157.66	158.17	157.21	157.72	3306588.0
2019-08-01 12:00:00	IWM	ETF	157.7334	157.74	157.21	157.33	1688660.0
2019-08-01 13:00:00	IWM	ETF	157.33	157.37	154.3	155.2	6950087.0
2019-08-01 14:00:00	IWM	ETF	155.18	155.23	153.59	154.53	5976551.0
2019-08-01 15:00:00	IWM	ETF	154.55	154.87	153.95	154.28	8071950.0
2019-08-01 16:00:00	IWM	ETF	154.28	154.61	153.86	153.86	1350283.0
2019-08-01 17:00:00	IWM	ETF	153.81	153.99	153.81	153.99	3619.0
2019-08-01 18:00:00	IWM	ETF	153.97	154.29	153.56	153.78	13160.0
2019-08-01 19:00:00	IWM	ETF	153.78	153.92	153.72	153.92	3100.0
2019-08-01 05:00:00	DIA	ETF	269.31	269.31	269.31	269.31	100.0
2019-08-01 07:00:00	DIA	ETF	269.27	269.4	269.22	269.4	420.0

> showing 50 of 11,424 rows — these rows as CSV

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