PREVIEW / etf_1hour / 2020-06-19

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-19.parquet
  size:    363 KB
  rows:    12,487

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-19 04:00:00	SPY	ETF	312.12	312.12	311.27	311.92	47090.0
2020-06-19 05:00:00	SPY	ETF	312.05	313.09	311.8	312.64	63594.0
2020-06-19 06:00:00	SPY	ETF	312.59	313.18	312.08	312.48	79673.0
2020-06-19 07:00:00	SPY	ETF	312.47	313.13	312.2	313.11	213585.0
2020-06-19 08:00:00	SPY	ETF	313.09	313.78	311.5	313.64	784268.0
2020-06-19 09:00:00	SPY	ETF	313.6	314.49	312.71	312.96	12501594.0
2020-06-19 10:00:00	SPY	ETF	312.96	313.3796	312.08	312.275	9017325.0
2020-06-19 11:00:00	SPY	ETF	312.27	312.9581	311.56	311.69	18832936.0
2020-06-19 12:00:00	SPY	ETF	311.685	311.76	307.95	310.4245	22325600.0
2020-06-19 13:00:00	SPY	ETF	310.43	310.47	307.89	307.9	10564032.0
2020-06-19 14:00:00	SPY	ETF	307.91	309.63	306.53	309.42	15479985.0
2020-06-19 15:00:00	SPY	ETF	309.43	310.54	308.54	308.56	23490637.0
2020-06-19 16:00:00	SPY	ETF	308.56	309.3941	305.85	305.95	15097775.0
2020-06-19 17:00:00	SPY	ETF	306.0	308.64	305.94	306.76	4851599.0
2020-06-19 18:00:00	SPY	ETF	306.76	306.85	306.49	306.7	170484.0
2020-06-19 19:00:00	SPY	ETF	306.7	306.75	306.05	306.1	166180.0
2020-06-19 04:00:00	QQQ	ETF	245.92	245.98	245.38	245.73	38476.0
2020-06-19 05:00:00	QQQ	ETF	245.81	246.1	245.63	245.82	49486.0
2020-06-19 06:00:00	QQQ	ETF	245.78	246.15	245.68	245.93	34378.0
2020-06-19 07:00:00	QQQ	ETF	245.95	246.22	245.77	246.22	99208.0
2020-06-19 08:00:00	QQQ	ETF	245.99	246.68	244.41	246.56	460630.0
2020-06-19 09:00:00	QQQ	ETF	246.55	247.1	246.18	246.45	4859509.0
2020-06-19 10:00:00	QQQ	ETF	246.47	246.97	245.95	246.22	3529674.0
2020-06-19 11:00:00	QQQ	ETF	246.23	246.68	245.57	245.62	2908979.0
2020-06-19 12:00:00	QQQ	ETF	245.62	245.685	242.81	244.84	5611536.0
2020-06-19 13:00:00	QQQ	ETF	244.845	244.8812	243.19	243.1999	3046604.0
2020-06-19 14:00:00	QQQ	ETF	243.2	244.18	242.45	243.9601	4924266.0
2020-06-19 15:00:00	QQQ	ETF	243.97	244.86	243.505	244.16	6976697.0
2020-06-19 16:00:00	QQQ	ETF	244.15	244.27	242.35	242.61	3141479.0
2020-06-19 17:00:00	QQQ	ETF	242.62	244.24	242.51	243.0	981348.0
2020-06-19 18:00:00	QQQ	ETF	243.0	243.13	242.85	242.99	8618.0
2020-06-19 19:00:00	QQQ	ETF	242.9	243.0	242.62	242.64	13780.0
2020-06-19 04:00:00	IWM	ETF	142.94	143.15	142.5	143.14	22789.0
2020-06-19 05:00:00	IWM	ETF	143.14	143.92	143.1	143.6	14264.0
2020-06-19 06:00:00	IWM	ETF	143.5	143.91	143.18	143.45	31329.0
2020-06-19 07:00:00	IWM	ETF	143.43	143.85	143.32	143.82	75966.0
2020-06-19 08:00:00	IWM	ETF	143.93	144.3	143.4	143.89	274802.0
2020-06-19 09:00:00	IWM	ETF	143.8	144.51	142.65	142.89	3726452.0
2020-06-19 10:00:00	IWM	ETF	142.885	143.52	142.57	143.045	4152305.0
2020-06-19 11:00:00	IWM	ETF	143.05	143.47	142.51	142.545	3245765.0
2020-06-19 12:00:00	IWM	ETF	142.56	142.595	140.37	141.61	6329938.0
2020-06-19 13:00:00	IWM	ETF	141.615	141.63	140.17	140.19	2834218.0
2020-06-19 14:00:00	IWM	ETF	140.19	141.49	139.84	141.44	4219325.0
2020-06-19 15:00:00	IWM	ETF	141.43	142.04	140.84	140.91	7188155.0
2020-06-19 16:00:00	IWM	ETF	140.92	141.86	139.4999	139.87	4374327.0
2020-06-19 17:00:00	IWM	ETF	139.66	140.99	139.66	140.1	384565.0
2020-06-19 18:00:00	IWM	ETF	140.2	140.39	139.75	140.2	4649.0
2020-06-19 19:00:00	IWM	ETF	139.9	139.9	139.52	139.7	13730.0
2020-06-19 04:00:00	DIA	ETF	262.14	262.17	261.13	262.1	8100.0
2020-06-19 05:00:00	DIA	ETF	262.91	263.11	262.91	263.11	1285.0

> showing 50 of 12,487 rows — these rows as CSV

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