PREVIEW / etf_1hour / 2019-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-28.parquet
  size:    342 KB
  rows:    11,247

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-10-28 04:00:00	SPY	ETF	302.14	302.47	302.11	302.15	13679.0
2019-10-28 05:00:00	SPY	ETF	302.08	302.19	302.0	302.19	10000.0
2019-10-28 06:00:00	SPY	ETF	302.17	302.4	302.16	302.29	23550.0
2019-10-28 07:00:00	SPY	ETF	302.25	302.53	302.25	302.44	44354.0
2019-10-28 08:00:00	SPY	ETF	302.46	302.96	302.13	302.94	245728.0
2019-10-28 09:00:00	SPY	ETF	302.94	303.66	302.78	303.51	5244265.0
2019-10-28 10:00:00	SPY	ETF	303.52	303.85	303.27	303.3336	5122347.0
2019-10-28 11:00:00	SPY	ETF	303.3415	303.47	303.05	303.29	4087541.0
2019-10-28 12:00:00	SPY	ETF	303.3076	303.54	303.15	303.19	2576664.0
2019-10-28 13:00:00	SPY	ETF	303.2	303.53	303.17	303.44	3172440.0
2019-10-28 14:00:00	SPY	ETF	303.43	303.61	303.37	303.51	4551841.0
2019-10-28 15:00:00	SPY	ETF	303.5	303.695	303.26	303.36	11114540.0
2019-10-28 16:00:00	SPY	ETF	303.35	303.5	303.1	303.29	4396230.0
2019-10-28 17:00:00	SPY	ETF	303.36	303.36	303.22	303.35	32076.0
2019-10-28 18:00:00	SPY	ETF	303.39	303.39	303.25	303.31	42630.0
2019-10-28 19:00:00	SPY	ETF	303.31	303.51	303.26	303.5	20551.0
2019-10-28 04:00:00	QQQ	ETF	196.08	196.57	196.04	196.23	10725.0
2019-10-28 05:00:00	QQQ	ETF	196.2	196.2	196.07	196.19	15865.0
2019-10-28 06:00:00	QQQ	ETF	196.18	196.25	196.13	196.16	22101.0
2019-10-28 07:00:00	QQQ	ETF	196.14	196.44	196.14	196.32	88172.0
2019-10-28 08:00:00	QQQ	ETF	196.32	196.65	195.64	196.64	333402.0
2019-10-28 09:00:00	QQQ	ETF	196.6	197.15	196.53	196.99	2233098.0
2019-10-28 10:00:00	QQQ	ETF	196.99	197.4199	196.91	197.2	2033274.0
2019-10-28 11:00:00	QQQ	ETF	197.205	197.57	197.12	197.4525	1536045.0
2019-10-28 12:00:00	QQQ	ETF	197.46	197.68	197.31	197.42	1124052.0
2019-10-28 13:00:00	QQQ	ETF	197.42	197.6	197.355	197.49	1614530.0
2019-10-28 14:00:00	QQQ	ETF	197.48	197.73	197.44	197.63	1191590.0
2019-10-28 15:00:00	QQQ	ETF	197.63	197.83	197.53	197.59	3330438.0
2019-10-28 16:00:00	QQQ	ETF	197.6	197.7	196.86	197.41	1782843.0
2019-10-28 17:00:00	QQQ	ETF	197.35	197.52	197.26	197.35	22219.0
2019-10-28 18:00:00	QQQ	ETF	197.38	197.43	197.29	197.35	18374.0
2019-10-28 19:00:00	QQQ	ETF	197.35	197.53	197.35	197.5	11441.0
2019-10-28 04:00:00	IWM	ETF	155.38	155.41	155.33	155.33	1100.0
2019-10-28 05:00:00	IWM	ETF	155.27	155.3	155.27	155.3	2898.0
2019-10-28 06:00:00	IWM	ETF	155.31	155.47	155.3	155.4	11800.0
2019-10-28 07:00:00	IWM	ETF	155.57	155.59	155.5	155.5	2945.0
2019-10-28 08:00:00	IWM	ETF	155.58	155.69	155.41	155.69	35988.0
2019-10-28 09:00:00	IWM	ETF	155.64	156.43	155.59	156.285	1371000.0
2019-10-28 10:00:00	IWM	ETF	156.282	156.98	156.24	156.55	2135938.0
2019-10-28 11:00:00	IWM	ETF	156.55	156.61	156.13	156.49	1471631.0
2019-10-28 12:00:00	IWM	ETF	156.49	156.98	156.45	156.675	1138815.0
2019-10-28 13:00:00	IWM	ETF	156.68	156.71	156.419	156.6	881031.0
2019-10-28 14:00:00	IWM	ETF	156.59	156.71	156.44	156.56	868885.0
2019-10-28 15:00:00	IWM	ETF	156.57	156.72	156.3	156.32	3425421.0
2019-10-28 16:00:00	IWM	ETF	156.34	156.6	156.25	156.47	906718.0
2019-10-28 17:00:00	IWM	ETF	156.55	156.55	156.4	156.4	2927.0
2019-10-28 18:00:00	IWM	ETF	156.49	156.64	156.34	156.4	41360.0
2019-10-28 19:00:00	IWM	ETF	156.4	156.49	156.4	156.47	1000.0
2019-10-28 04:00:00	DIA	ETF	270.15	270.17	270.15	270.17	200.0
2019-10-28 06:00:00	DIA	ETF	270.15	270.17	270.15	270.17	1100.0

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

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