PREVIEW / etf_1hour / 2019-11-21

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-11-21.parquet
  size:    331 KB
  rows:    11,001

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-11-21 04:00:00	SPY	ETF	310.42	310.51	310.32	310.41	12625.0
2019-11-21 05:00:00	SPY	ETF	310.4	311.22	310.4	310.77	36128.0
2019-11-21 06:00:00	SPY	ETF	310.77	310.92	310.63	310.88	55052.0
2019-11-21 07:00:00	SPY	ETF	310.86	310.92	310.6	310.85	203424.0
2019-11-21 08:00:00	SPY	ETF	310.81	311.48	309.97	310.99	819973.0
2019-11-21 09:00:00	SPY	ETF	310.97	311.11	310.05	310.29	5140844.0
2019-11-21 10:00:00	SPY	ETF	310.3	310.56	309.39	310.07	11317994.0
2019-11-21 11:00:00	SPY	ETF	310.0739	310.3999	309.74	309.84	4329796.0
2019-11-21 12:00:00	SPY	ETF	309.84	310.63	309.76	310.5	3299018.0
2019-11-21 13:00:00	SPY	ETF	310.5	310.63	310.32	310.38	2796654.0
2019-11-21 14:00:00	SPY	ETF	310.375	310.83	310.12	310.695	4104851.0
2019-11-21 15:00:00	SPY	ETF	310.71	310.75	309.88	310.29	13805326.0
2019-11-21 16:00:00	SPY	ETF	310.29	310.57	310.13	310.46	7820485.0
2019-11-21 17:00:00	SPY	ETF	310.48	310.5	310.25	310.37	173703.0
2019-11-21 18:00:00	SPY	ETF	310.4	310.46	310.19	310.19	75861.0
2019-11-21 19:00:00	SPY	ETF	310.2	310.68	310.1	310.57	57184.0
2019-11-21 04:00:00	QQQ	ETF	201.67	201.78	201.0	201.7	16829.0
2019-11-21 05:00:00	QQQ	ETF	201.72	202.33	201.72	201.93	15327.0
2019-11-21 06:00:00	QQQ	ETF	201.89	202.07	201.82	202.07	8406.0
2019-11-21 07:00:00	QQQ	ETF	202.03	202.06	201.8	201.96	53704.0
2019-11-21 08:00:00	QQQ	ETF	202.01	202.51	201.8602	202.1	218559.0
2019-11-21 09:00:00	QQQ	ETF	202.1	202.21	201.41	201.68	2190066.0
2019-11-21 10:00:00	QQQ	ETF	201.69	202.04	201.1	201.52	3548826.0
2019-11-21 11:00:00	QQQ	ETF	201.52	201.81	201.1	201.125	1567468.0
2019-11-21 12:00:00	QQQ	ETF	201.12	201.649	201.07	201.61	1108196.0
2019-11-21 13:00:00	QQQ	ETF	201.61	201.75	201.53	201.59	616836.0
2019-11-21 14:00:00	QQQ	ETF	201.6	202.07	201.37	201.94	1308489.0
2019-11-21 15:00:00	QQQ	ETF	201.95	201.977	201.32	201.68	2183282.0
2019-11-21 16:00:00	QQQ	ETF	201.67	201.81	201.5	201.81	1438623.0
2019-11-21 17:00:00	QQQ	ETF	201.7701	201.82	201.7	201.75	13587.0
2019-11-21 18:00:00	QQQ	ETF	201.8	201.86	201.62	201.63	30778.0
2019-11-21 19:00:00	QQQ	ETF	201.62	202.0	201.54	201.92	31650.0
2019-11-21 05:00:00	IWM	ETF	158.58	158.74	158.58	158.7	10050.0
2019-11-21 06:00:00	IWM	ETF	158.69	158.69	158.69	158.69	3000.0
2019-11-21 07:00:00	IWM	ETF	158.71	158.76	158.6	158.76	13903.0
2019-11-21 08:00:00	IWM	ETF	158.7	159.13	158.44	158.96	98802.0
2019-11-21 09:00:00	IWM	ETF	158.98	159.01	158.1	158.24	1445454.0
2019-11-21 10:00:00	IWM	ETF	158.24	158.25	157.23	157.53	2284848.0
2019-11-21 11:00:00	IWM	ETF	157.54	157.69	157.335	157.42	1113202.0
2019-11-21 12:00:00	IWM	ETF	157.41	157.9	157.33	157.9	1037317.0
2019-11-21 13:00:00	IWM	ETF	157.89	157.97	157.82	157.82	735929.0
2019-11-21 14:00:00	IWM	ETF	157.81	158.0	157.61	157.955	895539.0
2019-11-21 15:00:00	IWM	ETF	157.955	157.97	157.67	157.74	3529216.0
2019-11-21 16:00:00	IWM	ETF	157.73	157.8	157.57	157.66	2020559.0
2019-11-21 17:00:00	IWM	ETF	157.7	157.7	157.6999	157.6999	1600.0
2019-11-21 18:00:00	IWM	ETF	157.7	157.71	157.58	157.58	17019.0
2019-11-21 19:00:00	IWM	ETF	157.57	157.83	157.52	157.83	16729.0
2019-11-21 05:00:00	DIA	ETF	278.1	278.48	278.1	278.21	2800.0
2019-11-21 07:00:00	DIA	ETF	278.11	278.11	278.04	278.04	3400.0
2019-11-21 08:00:00	DIA	ETF	277.92	278.65	277.85	278.35	7000.0

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

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