PREVIEW / etf_1hour / 2019-12-03

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-12-03.parquet
  size:    360 KB
  rows:    11,660

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-03 04:00:00	SPY	ETF	312.05	312.27	311.69	311.9	15023.0
2019-12-03 05:00:00	SPY	ETF	312.06	312.14	310.3	310.4	74989.0
2019-12-03 06:00:00	SPY	ETF	310.52	310.87	310.37	310.84	44331.0
2019-12-03 07:00:00	SPY	ETF	310.86	310.86	309.78	309.9	436902.0
2019-12-03 08:00:00	SPY	ETF	309.9	312.25	308.9	308.97	1931175.0
2019-12-03 09:00:00	SPY	ETF	308.99	309.0	307.13	308.15	14928122.0
2019-12-03 10:00:00	SPY	ETF	308.15	308.57	307.37	307.98	13575860.0
2019-12-03 11:00:00	SPY	ETF	307.97	308.43	307.59	308.2	9429855.0
2019-12-03 12:00:00	SPY	ETF	308.21	308.54	307.92	308.45	5107199.0
2019-12-03 13:00:00	SPY	ETF	308.45	309.13	308.415	308.79	5915599.0
2019-12-03 14:00:00	SPY	ETF	308.79	308.96	308.32	308.69	4716558.0
2019-12-03 15:00:00	SPY	ETF	308.7	309.64	308.52	309.47	12400990.0
2019-12-03 16:00:00	SPY	ETF	309.48	309.56	308.2157	309.34	4700243.0
2019-12-03 17:00:00	SPY	ETF	309.35	309.46	309.3	309.42	80697.0
2019-12-03 18:00:00	SPY	ETF	309.36	309.65	309.28	309.6	299366.0
2019-12-03 19:00:00	SPY	ETF	309.64	309.8	309.07	309.25	83049.0
2019-12-03 04:00:00	QQQ	ETF	203.18	203.31	202.95	203.13	24176.0
2019-12-03 05:00:00	QQQ	ETF	203.15	203.22	201.75	201.84	85552.0
2019-12-03 06:00:00	QQQ	ETF	201.88	202.22	201.77	202.22	62796.0
2019-12-03 07:00:00	QQQ	ETF	202.22	202.23	201.22	201.35	296278.0
2019-12-03 08:00:00	QQQ	ETF	201.9	203.14	200.52	200.56	840067.0
2019-12-03 09:00:00	QQQ	ETF	200.56	200.58	199.23	200.08	5798369.0
2019-12-03 10:00:00	QQQ	ETF	200.06	200.5	199.615	199.84	5278533.0
2019-12-03 11:00:00	QQQ	ETF	199.85	200.27	199.61	200.105	3531713.0
2019-12-03 12:00:00	QQQ	ETF	200.1	200.43	199.88	200.39	1553731.0
2019-12-03 13:00:00	QQQ	ETF	200.39	200.9621	200.37	200.66	1949949.0
2019-12-03 14:00:00	QQQ	ETF	200.66	200.83	200.36	200.7166	1482017.0
2019-12-03 15:00:00	QQQ	ETF	200.7166	201.49	200.54	201.4	4032783.0
2019-12-03 16:00:00	QQQ	ETF	201.41	201.4515	201.05	201.35	1599421.0
2019-12-03 17:00:00	QQQ	ETF	201.39	201.45	201.31	201.39	23005.0
2019-12-03 18:00:00	QQQ	ETF	201.4	201.51	201.31	201.45	15933.0
2019-12-03 19:00:00	QQQ	ETF	201.5	201.6	201.09	201.2	53682.0
2019-12-03 04:00:00	IWM	ETF	160.68	160.68	160.4	160.45	5800.0
2019-12-03 05:00:00	IWM	ETF	160.68	160.68	159.61	159.61	27615.0
2019-12-03 06:00:00	IWM	ETF	159.7	159.98	159.69	159.98	1807.0
2019-12-03 07:00:00	IWM	ETF	159.98	159.99	159.33	159.44	108712.0
2019-12-03 08:00:00	IWM	ETF	159.8501	159.8601	158.98	159.01	148885.0
2019-12-03 09:00:00	IWM	ETF	159.02	159.05	158.1	159.02	2891797.0
2019-12-03 10:00:00	IWM	ETF	159.01	159.05	158.38	158.87	2664976.0
2019-12-03 11:00:00	IWM	ETF	158.84	159.32	158.55	159.13	1320739.0
2019-12-03 12:00:00	IWM	ETF	159.12	159.31	158.9202	159.2151	903933.0
2019-12-03 13:00:00	IWM	ETF	159.21	159.51	159.21	159.3138	855815.0
2019-12-03 14:00:00	IWM	ETF	159.32	159.405	158.97	159.16	876750.0
2019-12-03 15:00:00	IWM	ETF	159.17	159.76	159.08	159.69	2468212.0
2019-12-03 16:00:00	IWM	ETF	159.71	159.89	159.6254	159.74	720609.0
2019-12-03 17:00:00	IWM	ETF	159.78	159.78	159.75	159.75	400.0
2019-12-03 18:00:00	IWM	ETF	159.76	159.95	159.68	159.8	18190.0
2019-12-03 19:00:00	IWM	ETF	159.95	160.01	159.66	159.7	15000.0
2019-12-03 04:00:00	DIA	ETF	278.48	278.48	278.48	278.48	100.0
2019-12-03 05:00:00	DIA	ETF	277.5	277.5	277.29	277.29	700.0

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

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