PREVIEW / etf_1hour / 2019-12-04

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-04.parquet
  size:    345 KB
  rows:    11,310

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-12-04 04:00:00	SPY	ETF	309.14	310.98	309.14	310.85	83247.0
2019-12-04 05:00:00	SPY	ETF	310.74	310.76	310.42	310.46	29480.0
2019-12-04 06:00:00	SPY	ETF	310.4	310.82	310.4	310.79	52840.0
2019-12-04 07:00:00	SPY	ETF	310.82	310.95	310.65	310.75	186238.0
2019-12-04 08:00:00	SPY	ETF	308.74	310.9	308.48	310.61	713635.0
2019-12-04 09:00:00	SPY	ETF	310.61	311.825	310.32	311.67	9001907.0
2019-12-04 10:00:00	SPY	ETF	311.65	311.94	311.36	311.8	7275128.0
2019-12-04 11:00:00	SPY	ETF	311.8	311.97	311.44	311.59	5377103.0
2019-12-04 12:00:00	SPY	ETF	311.59	311.71	311.3144	311.675	3378528.0
2019-12-04 13:00:00	SPY	ETF	311.675	311.71	311.44	311.68	1845593.0
2019-12-04 14:00:00	SPY	ETF	311.68	312.12	311.66	312.03	4967641.0
2019-12-04 15:00:00	SPY	ETF	312.03	312.06	311.37	311.47	8581559.0
2019-12-04 16:00:00	SPY	ETF	311.46	311.53	309.4744	311.28	6422790.0
2019-12-04 17:00:00	SPY	ETF	311.24	311.33	311.21	311.31	152336.0
2019-12-04 18:00:00	SPY	ETF	311.3	311.46	311.16	311.18	125608.0
2019-12-04 19:00:00	SPY	ETF	311.15	311.32	311.05	311.18	49016.0
2019-12-04 04:00:00	QQQ	ETF	201.12	202.8	201.12	202.57	67071.0
2019-12-04 05:00:00	QQQ	ETF	202.57	202.57	202.29	202.32	27745.0
2019-12-04 06:00:00	QQQ	ETF	202.3	202.59	202.3	202.52	34510.0
2019-12-04 07:00:00	QQQ	ETF	202.55	202.66	202.39	202.47	104704.0
2019-12-04 08:00:00	QQQ	ETF	202.46	202.61	200.64	202.3702	309035.0
2019-12-04 09:00:00	QQQ	ETF	202.37	202.8724	202.14	202.73	2719290.0
2019-12-04 10:00:00	QQQ	ETF	202.73	202.91	202.42	202.76	1867742.0
2019-12-04 11:00:00	QQQ	ETF	202.77	202.91	202.49	202.5353	1129639.0
2019-12-04 12:00:00	QQQ	ETF	202.53	202.65	202.31	202.5879	1206352.0
2019-12-04 13:00:00	QQQ	ETF	202.6	202.61	202.37	202.515	680513.0
2019-12-04 14:00:00	QQQ	ETF	202.51	202.86	202.51	202.8	1461405.0
2019-12-04 15:00:00	QQQ	ETF	202.81	202.83	202.37	202.4	2388021.0
2019-12-04 16:00:00	QQQ	ETF	202.4	202.49	202.13	202.38	1064943.0
2019-12-04 17:00:00	QQQ	ETF	202.47	202.47	202.3	202.37	26241.0
2019-12-04 18:00:00	QQQ	ETF	202.38	202.53	202.25	202.28	40652.0
2019-12-04 19:00:00	QQQ	ETF	202.24	202.42	202.21	202.3	19000.0
2019-12-04 04:00:00	IWM	ETF	160.3	160.75	160.3	160.72	2400.0
2019-12-04 05:00:00	IWM	ETF	160.65	160.65	160.41	160.41	7653.0
2019-12-04 06:00:00	IWM	ETF	160.4	160.5	160.4	160.5	3200.0
2019-12-04 07:00:00	IWM	ETF	160.69	160.72	160.56	160.61	24615.0
2019-12-04 08:00:00	IWM	ETF	160.7	160.76	160.35	160.47	51239.0
2019-12-04 09:00:00	IWM	ETF	160.44	161.11	160.3	161.07	1423261.0
2019-12-04 10:00:00	IWM	ETF	161.05	161.22	160.73	160.845	1390614.0
2019-12-04 11:00:00	IWM	ETF	160.85	161.03	160.61	160.9	732862.0
2019-12-04 12:00:00	IWM	ETF	160.89	161.14	160.81	161.115	456742.0
2019-12-04 13:00:00	IWM	ETF	161.115	161.165	161.01	161.065	473703.0
2019-12-04 14:00:00	IWM	ETF	161.07	161.135	160.96	161.07	609720.0
2019-12-04 15:00:00	IWM	ETF	161.075	161.14	160.67	160.82	2423127.0
2019-12-04 16:00:00	IWM	ETF	160.81	160.89	160.42	160.76	741346.0
2019-12-04 17:00:00	IWM	ETF	160.8	160.8	160.72	160.72	5200.0
2019-12-04 18:00:00	IWM	ETF	160.73	160.87	160.73	160.74	11575.0
2019-12-04 19:00:00	IWM	ETF	160.78	160.78	160.65	160.72	6368.0
2019-12-04 04:00:00	DIA	ETF	276.84	276.84	276.31	276.31	1100.0
2019-12-04 05:00:00	DIA	ETF	276.68	276.68	276.68	276.68	300.0

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

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