PREVIEW / etf_1hour / 2020-06-16

all etf 1-hour files

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

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-06-16 04:00:00	SPY	ETF	310.17	311.18	309.5	311.06	207783.0
2020-06-16 05:00:00	SPY	ETF	311.21	311.39	310.68	311.1	56316.0
2020-06-16 06:00:00	SPY	ETF	311.2	312.1	310.88	311.69	360196.0
2020-06-16 07:00:00	SPY	ETF	311.75	312.1	311.1	312.05	853916.0
2020-06-16 08:00:00	SPY	ETF	312.8	316.96	310.36	316.26	4174722.0
2020-06-16 09:00:00	SPY	ETF	316.26	316.44	313.77	314.54	14477584.0
2020-06-16 10:00:00	SPY	ETF	314.54	315.64	309.06	309.43	24654015.0
2020-06-16 11:00:00	SPY	ETF	309.44	313.7	307.67	312.26	28048562.0
2020-06-16 12:00:00	SPY	ETF	312.27	314.18	311.17	313.48	12286419.0
2020-06-16 13:00:00	SPY	ETF	313.48	314.94	312.14	312.695	7696506.0
2020-06-16 14:00:00	SPY	ETF	312.7	314.37	312.21	313.07	12193785.0
2020-06-16 15:00:00	SPY	ETF	313.07	313.32	310.61	312.93	24031532.0
2020-06-16 16:00:00	SPY	ETF	312.92	313.31	312.49	312.95	7506230.0
2020-06-16 17:00:00	SPY	ETF	312.91	312.99	312.43	312.61	204391.0
2020-06-16 18:00:00	SPY	ETF	312.56	312.87	311.321	312.87	275743.0
2020-06-16 19:00:00	SPY	ETF	312.79	313.97	312.79	313.85	287200.0
2020-06-16 04:00:00	QQQ	ETF	241.02	241.85	240.78	241.85	38661.0
2020-06-16 05:00:00	QQQ	ETF	241.89	242.07	241.64	241.66	34570.0
2020-06-16 06:00:00	QQQ	ETF	241.65	242.47	241.61	242.12	25775.0
2020-06-16 07:00:00	QQQ	ETF	242.05	242.45	241.55	242.39	180175.0
2020-06-16 08:00:00	QQQ	ETF	241.8001	244.3	241.12	244.03	750762.0
2020-06-16 09:00:00	QQQ	ETF	244.06	244.27	242.885	243.73	5497372.0
2020-06-16 10:00:00	QQQ	ETF	243.73	244.39	240.03	240.19	8521693.0
2020-06-16 11:00:00	QQQ	ETF	240.15	243.29	239.1	242.54	8476608.0
2020-06-16 12:00:00	QQQ	ETF	242.57	243.51	241.53	243.13	3869799.0
2020-06-16 13:00:00	QQQ	ETF	243.12	243.54	242.25	242.65	2801015.0
2020-06-16 14:00:00	QQQ	ETF	242.65	243.61	242.05	242.6	4427577.0
2020-06-16 15:00:00	QQQ	ETF	242.6	243.0	241.01	242.95	8060064.0
2020-06-16 16:00:00	QQQ	ETF	242.96	243.43	242.79	243.34	856424.0
2020-06-16 17:00:00	QQQ	ETF	243.29	243.38	242.77	242.85	56092.0
2020-06-16 18:00:00	QQQ	ETF	242.9	243.36	242.34	243.36	126419.0
2020-06-16 19:00:00	QQQ	ETF	243.32	244.0	243.32	243.9	119783.0
2020-06-16 04:00:00	IWM	ETF	143.12	143.9	142.82	143.9	23143.0
2020-06-16 05:00:00	IWM	ETF	143.96	144.32	143.56	144.32	46421.0
2020-06-16 06:00:00	IWM	ETF	144.18	144.99	144.18	144.61	35311.0
2020-06-16 07:00:00	IWM	ETF	144.53	145.09	144.1	145.06	139261.0
2020-06-16 08:00:00	IWM	ETF	144.2	147.54	143.13	147.38	1318971.0
2020-06-16 09:00:00	IWM	ETF	147.25	147.34	144.96	145.94	5763066.0
2020-06-16 10:00:00	IWM	ETF	145.97	146.42	142.31	142.36	7681200.0
2020-06-16 11:00:00	IWM	ETF	142.31	145.03	141.03	144.1	7565364.0
2020-06-16 12:00:00	IWM	ETF	144.11	145.43	143.26	144.59	4347815.0
2020-06-16 13:00:00	IWM	ETF	144.56	145.04	143.96	144.45	2737854.0
2020-06-16 14:00:00	IWM	ETF	144.46	145.4	144.05	144.92	3657474.0
2020-06-16 15:00:00	IWM	ETF	144.92	144.96	143.52	144.4	6603439.0
2020-06-16 16:00:00	IWM	ETF	144.4	144.61	144.07	144.5	1224466.0
2020-06-16 17:00:00	IWM	ETF	144.41	144.41	143.65	143.84	57662.0
2020-06-16 18:00:00	IWM	ETF	144.0	144.38	143.12	144.21	72494.0
2020-06-16 19:00:00	IWM	ETF	144.2	144.87	144.17	144.8499	24027.0
2020-06-16 04:00:00	DIA	ETF	261.51	262.89	261.3	262.82	13845.0
2020-06-16 05:00:00	DIA	ETF	262.87	263.18	262.8	263.12	6186.0

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

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