PREVIEW / etf_1hour / 2020-07-06

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-06.parquet
  size:    375 KB
  rows:    13,070

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
2020-07-06 04:00:00	SPY	ETF	316.61	317.13	316.44	316.49	66232.0
2020-07-06 05:00:00	SPY	ETF	316.44	316.61	315.87	316.54	82834.0
2020-07-06 06:00:00	SPY	ETF	316.67	317.27	316.47	316.63	186616.0
2020-07-06 07:00:00	SPY	ETF	316.63	316.86	316.27	316.77	344238.0
2020-07-06 08:00:00	SPY	ETF	316.5499	317.13	316.1	317.08	706652.0
2020-07-06 09:00:00	SPY	ETF	317.04	317.08	315.87	316.72	6393759.0
2020-07-06 10:00:00	SPY	ETF	317.07	317.68	315.56	316.9	10395595.0
2020-07-06 11:00:00	SPY	ETF	316.93	317.23	316.44	316.445	6521885.0
2020-07-06 12:00:00	SPY	ETF	316.445	316.58	316.0	316.48	4426847.0
2020-07-06 13:00:00	SPY	ETF	316.485	316.68	316.02	316.629	3931523.0
2020-07-06 14:00:00	SPY	ETF	316.62	316.635	315.56	315.99	6426520.0
2020-07-06 15:00:00	SPY	ETF	315.98	317.24	315.63	316.99	14021789.0
2020-07-06 16:00:00	SPY	ETF	316.98	317.41	316.76	316.95	6288095.0
2020-07-06 17:00:00	SPY	ETF	316.98	317.06	316.86	317.03	96033.0
2020-07-06 18:00:00	SPY	ETF	317.03	317.4	316.77	317.26	113452.0
2020-07-06 19:00:00	SPY	ETF	317.27	317.91	317.25	317.73	444767.0
2020-07-06 04:00:00	QQQ	ETF	255.45	255.98	255.45	255.69	59436.0
2020-07-06 05:00:00	QQQ	ETF	255.63	255.72	255.35	255.68	34659.0
2020-07-06 06:00:00	QQQ	ETF	255.6	255.92	255.47	255.63	65053.0
2020-07-06 07:00:00	QQQ	ETF	255.62	255.75	255.5	255.68	184387.0
2020-07-06 08:00:00	QQQ	ETF	255.54	256.07	255.49	255.89	150442.0
2020-07-06 09:00:00	QQQ	ETF	255.88	256.64	255.35	256.6001	3415588.0
2020-07-06 10:00:00	QQQ	ETF	256.61	257.95	256.39	257.939	4914487.0
2020-07-06 11:00:00	QQQ	ETF	257.94	258.928	257.87	258.34	3285325.0
2020-07-06 12:00:00	QQQ	ETF	258.347	258.44	257.54	258.16	2670939.0
2020-07-06 13:00:00	QQQ	ETF	258.19	258.2297	257.33	257.7	2328847.0
2020-07-06 14:00:00	QQQ	ETF	257.7	257.73	256.58	257.44	3237984.0
2020-07-06 15:00:00	QQQ	ETF	257.44	258.55	256.8	258.39	5167029.0
2020-07-06 16:00:00	QQQ	ETF	258.37	258.67	257.0336	258.51	972377.0
2020-07-06 17:00:00	QQQ	ETF	258.58	258.65	258.41	258.58	46694.0
2020-07-06 18:00:00	QQQ	ETF	258.61	259.12	258.44	259.03	85573.0
2020-07-06 19:00:00	QQQ	ETF	259.03	259.7	259.03	259.5	205916.0
2020-07-06 04:00:00	IWM	ETF	145.47	145.58	145.1	145.12	13930.0
2020-07-06 05:00:00	IWM	ETF	145.1	145.48	144.6	145.32	22144.0
2020-07-06 06:00:00	IWM	ETF	145.23	145.75	145.23	145.35	55209.0
2020-07-06 07:00:00	IWM	ETF	145.23	145.63	145.0	145.53	150398.0
2020-07-06 08:00:00	IWM	ETF	145.2099	146.06	145.09	146.06	234574.0
2020-07-06 09:00:00	IWM	ETF	146.05	146.05	144.61	145.06	2806321.0
2020-07-06 10:00:00	IWM	ETF	145.38	145.6966	143.09	144.275	3417823.0
2020-07-06 11:00:00	IWM	ETF	144.275	144.3	143.1087	143.11	2113688.0
2020-07-06 12:00:00	IWM	ETF	143.11	143.49	142.93	143.29	1932819.0
2020-07-06 13:00:00	IWM	ETF	143.29	144.008	142.99	143.84	1603818.0
2020-07-06 14:00:00	IWM	ETF	143.84	143.84	143.03	143.25	1597419.0
2020-07-06 15:00:00	IWM	ETF	143.23	143.73	143.13	143.42	2992735.0
2020-07-06 16:00:00	IWM	ETF	143.42	143.75	143.27	143.58	596449.0
2020-07-06 17:00:00	IWM	ETF	143.6	143.6	143.46	143.6	6522.0
2020-07-06 18:00:00	IWM	ETF	143.6	143.71	143.39	143.71	22921.0
2020-07-06 19:00:00	IWM	ETF	143.66	144.33	143.66	143.98	50035.0
2020-07-06 04:00:00	DIA	ETF	263.0	263.13	262.34	262.34	8249.0
2020-07-06 05:00:00	DIA	ETF	262.23	262.34	261.8	262.25	4415.0

> showing 50 of 13,070 rows — these rows as CSV

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