PREVIEW / etf_1hour / 2020-11-04

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-04.parquet
  size:    391 KB
  rows:    13,437

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-11-04 04:00:00	SPY	ETF	337.8	340.77	337.3	338.16	310311.0
2020-11-04 05:00:00	SPY	ETF	337.85	338.22	335.78	337.8	206724.0
2020-11-04 06:00:00	SPY	ETF	337.55	338.93	337.01	338.15	408867.0
2020-11-04 07:00:00	SPY	ETF	338.02	342.12	337.5	341.73	1310970.0
2020-11-04 08:00:00	SPY	ETF	340.02	342.98	333.0	341.47	2387787.0
2020-11-04 09:00:00	SPY	ETF	341.4	342.54	338.9625	342.5	17544747.0
2020-11-04 10:00:00	SPY	ETF	342.49	346.475	342.33	345.85	22307731.0
2020-11-04 11:00:00	SPY	ETF	345.84	347.01	344.36	346.67	10102683.0
2020-11-04 12:00:00	SPY	ETF	346.67	347.94	346.3	346.76	9976337.0
2020-11-04 13:00:00	SPY	ETF	346.77	347.17	345.46	345.85	9832133.0
2020-11-04 14:00:00	SPY	ETF	345.88	346.49	344.81	345.32	13389817.0
2020-11-04 15:00:00	SPY	ETF	345.32	345.69	343.16	343.49	28867564.0
2020-11-04 16:00:00	SPY	ETF	343.48	345.0	343.18	344.05	7727084.0
2020-11-04 17:00:00	SPY	ETF	344.09	344.75	343.54	344.7	160708.0
2020-11-04 18:00:00	SPY	ETF	344.63	344.63	342.91	343.4	296282.0
2020-11-04 19:00:00	SPY	ETF	343.4	344.72	343.15	344.44	216068.0
2020-11-04 04:00:00	QQQ	ETF	281.53	283.69	280.9	282.29	393961.0
2020-11-04 05:00:00	QQQ	ETF	282.19	282.3	279.4	281.2	373714.0
2020-11-04 06:00:00	QQQ	ETF	281.1	282.26	279.57	281.35	472864.0
2020-11-04 07:00:00	QQQ	ETF	281.27	284.21	280.49	284.1	2243294.0
2020-11-04 08:00:00	QQQ	ETF	284.1	286.09	276.21	284.47	2530489.0
2020-11-04 09:00:00	QQQ	ETF	284.5	285.0	281.87	284.04	9122006.0
2020-11-04 10:00:00	QQQ	ETF	284.0	287.7149	283.74	287.35	11783987.0
2020-11-04 11:00:00	QQQ	ETF	287.33	288.07	285.65	287.8	5224352.0
2020-11-04 12:00:00	QQQ	ETF	287.8	288.77	287.11	287.85	4529068.0
2020-11-04 13:00:00	QQQ	ETF	287.89	288.33	286.53	287.38	5574125.0
2020-11-04 14:00:00	QQQ	ETF	287.39	288.0	286.3	287.36	4336188.0
2020-11-04 15:00:00	QQQ	ETF	287.37	287.85	286.03	286.85	8703860.0
2020-11-04 16:00:00	QQQ	ETF	286.85	288.85	286.68	288.2	2038027.0
2020-11-04 17:00:00	QQQ	ETF	288.27	288.55	286.9	288.4	383745.0
2020-11-04 18:00:00	QQQ	ETF	288.43	288.58	287.23	287.7	178661.0
2020-11-04 19:00:00	QQQ	ETF	287.7	288.69	287.66	288.64	236645.0
2020-11-04 04:00:00	IWM	ETF	156.91	158.41	156.7	157.04	110797.0
2020-11-04 05:00:00	IWM	ETF	157.0	157.65	156.44	157.48	194881.0
2020-11-04 06:00:00	IWM	ETF	157.52	159.09	157.52	158.44	231842.0
2020-11-04 07:00:00	IWM	ETF	158.52	160.47	158.199	160.1	437699.0
2020-11-04 08:00:00	IWM	ETF	160.1	161.0	154.8	158.51	1876281.0
2020-11-04 09:00:00	IWM	ETF	158.51	159.87	156.91	159.58	8486506.0
2020-11-04 10:00:00	IWM	ETF	159.56	161.655	158.6	160.81	6701249.0
2020-11-04 11:00:00	IWM	ETF	160.82	161.82	160.29	161.54	3188596.0
2020-11-04 12:00:00	IWM	ETF	161.53	162.35	161.44	161.47	2564427.0
2020-11-04 13:00:00	IWM	ETF	161.47	161.545	160.45	160.8	2652909.0
2020-11-04 14:00:00	IWM	ETF	160.82	161.125	160.07	160.47	3263974.0
2020-11-04 15:00:00	IWM	ETF	160.47	160.76	159.52	160.45	7085237.0
2020-11-04 16:00:00	IWM	ETF	160.46	161.1	160.11	160.32	1521756.0
2020-11-04 17:00:00	IWM	ETF	160.42	160.59	160.3	160.54	32971.0
2020-11-04 18:00:00	IWM	ETF	160.62	160.98	159.83	160.15	35423.0
2020-11-04 19:00:00	IWM	ETF	160.1	160.66	159.86	160.44	29665.0
2020-11-04 04:00:00	DIA	ETF	274.2	276.2	274.1	274.33	9242.0
2020-11-04 05:00:00	DIA	ETF	274.06	274.25	273.25	273.86	40534.0

> showing 50 of 13,437 rows — these rows as CSV

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