PREVIEW / etf_1hour / 2020-07-31

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-31.parquet
  size:    371 KB
  rows:    12,667

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-31 04:00:00	SPY	ETF	325.69	326.42	325.45	325.95	35704.0
2020-07-31 05:00:00	SPY	ETF	325.7	326.06	325.35	325.35	17127.0
2020-07-31 06:00:00	SPY	ETF	325.51	325.67	325.13	325.67	63968.0
2020-07-31 07:00:00	SPY	ETF	325.38	326.04	325.25	325.99	154923.0
2020-07-31 08:00:00	SPY	ETF	325.7201	326.95	325.0	325.56	719782.0
2020-07-31 09:00:00	SPY	ETF	325.55	326.13	324.12	324.74	7051237.0
2020-07-31 10:00:00	SPY	ETF	324.78	324.79	322.4114	323.3	9475732.0
2020-07-31 11:00:00	SPY	ETF	323.32	324.44	323.0	323.242	8316731.0
2020-07-31 12:00:00	SPY	ETF	323.22	323.35	321.33	321.71	7725176.0
2020-07-31 13:00:00	SPY	ETF	321.68	323.02	321.55	322.58	5028493.0
2020-07-31 14:00:00	SPY	ETF	322.58	323.94	321.96	323.88	6361357.0
2020-07-31 15:00:00	SPY	ETF	323.88	326.61	323.68	326.55	20989392.0
2020-07-31 16:00:00	SPY	ETF	326.56	327.06	323.9622	326.95	15938429.0
2020-07-31 17:00:00	SPY	ETF	326.91	327.05	326.5	326.75	626213.0
2020-07-31 18:00:00	SPY	ETF	326.74	326.86	326.3	326.42	640667.0
2020-07-31 19:00:00	SPY	ETF	326.42	326.59	326.3	326.44	54341.0
2020-07-31 04:00:00	QQQ	ETF	265.48	266.33	265.46	266.03	24238.0
2020-07-31 05:00:00	QQQ	ETF	265.9	266.29	265.42	265.42	49332.0
2020-07-31 06:00:00	QQQ	ETF	265.49	265.84	265.4	265.6	28102.0
2020-07-31 07:00:00	QQQ	ETF	265.6	266.34	265.6	266.3	135712.0
2020-07-31 08:00:00	QQQ	ETF	266.29	266.75	265.1	266.02	510560.0
2020-07-31 09:00:00	QQQ	ETF	266.0	266.12	263.01	264.08	7893306.0
2020-07-31 10:00:00	QQQ	ETF	264.08	264.13	261.39	263.03	7289766.0
2020-07-31 11:00:00	QQQ	ETF	263.01	264.21	262.785	263.15	4674463.0
2020-07-31 12:00:00	QQQ	ETF	263.14	263.31	260.85	261.2668	5085592.0
2020-07-31 13:00:00	QQQ	ETF	261.28	262.8	261.14	262.25	3795332.0
2020-07-31 14:00:00	QQQ	ETF	262.22	263.67	261.4	263.52	4574213.0
2020-07-31 15:00:00	QQQ	ETF	263.52	265.87	263.2601	265.84	9978371.0
2020-07-31 16:00:00	QQQ	ETF	265.85	266.4	263.4278	266.39	1554375.0
2020-07-31 17:00:00	QQQ	ETF	266.34	266.36	265.79	266.1	173932.0
2020-07-31 18:00:00	QQQ	ETF	266.1	266.19	265.81	265.9	32784.0
2020-07-31 19:00:00	QQQ	ETF	265.9	266.0	265.8	265.95	31088.0
2020-07-31 04:00:00	IWM	ETF	148.2	148.65	147.95	148.08	10678.0
2020-07-31 05:00:00	IWM	ETF	147.95	148.02	147.55	147.55	13860.0
2020-07-31 06:00:00	IWM	ETF	147.62	147.72	147.4	147.52	16543.0
2020-07-31 07:00:00	IWM	ETF	147.59	147.97	147.55	147.97	162386.0
2020-07-31 08:00:00	IWM	ETF	147.59	148.0	147.57	147.75	153765.0
2020-07-31 09:00:00	IWM	ETF	147.8	148.42	147.59	148.06	2595766.0
2020-07-31 10:00:00	IWM	ETF	148.07	148.08	145.19	145.9	5164229.0
2020-07-31 11:00:00	IWM	ETF	145.9	146.33	145.12	145.2	3012874.0
2020-07-31 12:00:00	IWM	ETF	145.2	145.53	144.67	145.05	2757930.0
2020-07-31 13:00:00	IWM	ETF	145.03	146.26	144.95	145.905	1659249.0
2020-07-31 14:00:00	IWM	ETF	145.885	146.37	145.53	146.19	2004009.0
2020-07-31 15:00:00	IWM	ETF	146.195	147.41	146.09	147.34	4723281.0
2020-07-31 16:00:00	IWM	ETF	147.37	147.62	146.99	147.49	1524799.0
2020-07-31 17:00:00	IWM	ETF	147.54	147.54	147.21	147.36	14645.0
2020-07-31 18:00:00	IWM	ETF	147.36	147.48	147.32	147.48	1438.0
2020-07-31 19:00:00	IWM	ETF	147.31	147.31	147.18	147.24	4128.0
2020-07-31 04:00:00	DIA	ETF	263.9	264.02	263.82	263.99	2500.0
2020-07-31 05:00:00	DIA	ETF	263.82	264.11	263.31	263.31	19450.0

> showing 50 of 12,667 rows — these rows as CSV

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