PREVIEW / etf_1hour / 2020-11-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-02.parquet
  size:    384 KB
  rows:    13,315

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-02 04:00:00	SPY	ETF	328.52	330.59	328.4	330.18	75491.0
2020-11-02 05:00:00	SPY	ETF	330.2	332.12	330.19	331.74	85502.0
2020-11-02 06:00:00	SPY	ETF	331.66	331.76	331.01	331.14	198578.0
2020-11-02 07:00:00	SPY	ETF	331.09	331.25	329.8	330.13	817381.0
2020-11-02 08:00:00	SPY	ETF	330.95	331.6	326.54	330.05	748503.0
2020-11-02 09:00:00	SPY	ETF	330.06	330.995	328.965	330.76	8620338.0
2020-11-02 10:00:00	SPY	ETF	330.81	332.36	330.05	330.219	10000386.0
2020-11-02 11:00:00	SPY	ETF	330.21	331.08	329.42	330.5103	8711463.0
2020-11-02 12:00:00	SPY	ETF	330.53	330.83	328.73	329.31	6106000.0
2020-11-02 13:00:00	SPY	ETF	329.32	329.47	327.24	327.405	9237956.0
2020-11-02 14:00:00	SPY	ETF	327.4	330.0	327.24	329.44	9824086.0
2020-11-02 15:00:00	SPY	ETF	329.44	330.42	328.58	330.21	20473149.0
2020-11-02 16:00:00	SPY	ETF	330.2	330.66	329.8	330.36	9179271.0
2020-11-02 17:00:00	SPY	ETF	330.3898	330.45	330.2	330.43	209108.0
2020-11-02 18:00:00	SPY	ETF	330.37	331.27	330.21	330.94	190598.0
2020-11-02 19:00:00	SPY	ETF	330.96	331.7	330.5	331.5801	130646.0
2020-11-02 04:00:00	QQQ	ETF	271.46	272.74	271.32	272.16	93403.0
2020-11-02 05:00:00	QQQ	ETF	272.29	273.46	272.27	273.12	56176.0
2020-11-02 06:00:00	QQQ	ETF	273.11	273.19	272.5	272.56	65258.0
2020-11-02 07:00:00	QQQ	ETF	272.57	272.64	271.36	271.47	289075.0
2020-11-02 08:00:00	QQQ	ETF	272.09	273.0	269.8	271.59	404768.0
2020-11-02 09:00:00	QQQ	ETF	271.65	273.52	271.01	272.64	4916540.0
2020-11-02 10:00:00	QQQ	ETF	272.65	273.44	271.0	271.31	5573995.0
2020-11-02 11:00:00	QQQ	ETF	271.3	271.65	269.62	270.22	3860212.0
2020-11-02 12:00:00	QQQ	ETF	270.245	270.5677	268.48	268.99	3626157.0
2020-11-02 13:00:00	QQQ	ETF	268.99	269.13	266.97	267.1132	3883739.0
2020-11-02 14:00:00	QQQ	ETF	267.12	269.08	266.98	268.63	4402038.0
2020-11-02 15:00:00	QQQ	ETF	268.61	270.09	268.31	270.05	5742071.0
2020-11-02 16:00:00	QQQ	ETF	270.02	270.54	269.3505	270.12	1376370.0
2020-11-02 17:00:00	QQQ	ETF	270.15	270.19	269.61	270.0	138585.0
2020-11-02 18:00:00	QQQ	ETF	270.0	270.68	269.97	270.5	155937.0
2020-11-02 19:00:00	QQQ	ETF	270.5	271.16	270.16	271.12	140845.0
2020-11-02 04:00:00	IWM	ETF	153.71	155.0	153.67	154.68	34310.0
2020-11-02 05:00:00	IWM	ETF	154.72	155.62	154.68	155.51	18847.0
2020-11-02 06:00:00	IWM	ETF	155.55	155.77	155.18	155.28	28446.0
2020-11-02 07:00:00	IWM	ETF	155.32	155.36	154.77	154.96	67725.0
2020-11-02 08:00:00	IWM	ETF	155.5804	155.5804	153.43	154.82	101164.0
2020-11-02 09:00:00	IWM	ETF	154.88	155.31	154.13	155.15	2444697.0
2020-11-02 10:00:00	IWM	ETF	155.21	155.67	154.65	154.81	3002116.0
2020-11-02 11:00:00	IWM	ETF	154.79	155.45	154.66	155.26	1935745.0
2020-11-02 12:00:00	IWM	ETF	155.27	155.72	154.51	154.67	1921423.0
2020-11-02 13:00:00	IWM	ETF	154.68	154.75	153.71	153.745	2104679.0
2020-11-02 14:00:00	IWM	ETF	153.76	155.5	153.665	155.21	2250533.0
2020-11-02 15:00:00	IWM	ETF	155.21	155.89	155.025	155.8	5165024.0
2020-11-02 16:00:00	IWM	ETF	155.82	156.15	155.71	155.82	1024386.0
2020-11-02 17:00:00	IWM	ETF	155.7	155.91	155.7	155.9	14672.0
2020-11-02 18:00:00	IWM	ETF	155.85	156.46	155.82	156.1	39118.0
2020-11-02 19:00:00	IWM	ETF	156.11	156.34	155.85	156.34	17949.0
2020-11-02 04:00:00	DIA	ETF	267.0	268.73	267.0	268.47	3400.0
2020-11-02 05:00:00	DIA	ETF	268.82	269.78	268.67	269.78	2275.0

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

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