PREVIEW / etf_1hour / 2020-12-02

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-12-02.parquet
  size:    392 KB
  rows:    13,518

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-12-02 04:00:00	SPY	ETF	365.22	365.59	365.06	365.38	5127.0
2020-12-02 05:00:00	SPY	ETF	365.43	365.57	365.32	365.57	24316.0
2020-12-02 06:00:00	SPY	ETF	365.43	365.44	365.0	365.44	39139.0
2020-12-02 07:00:00	SPY	ETF	365.33	365.42	364.3	364.83	443637.0
2020-12-02 08:00:00	SPY	ETF	364.7	365.3804	364.27	364.91	365439.0
2020-12-02 09:00:00	SPY	ETF	364.9	365.505	364.2	365.41	5749380.0
2020-12-02 10:00:00	SPY	ETF	365.41	365.9	364.96	365.68	6218695.0
2020-12-02 11:00:00	SPY	ETF	365.7	366.41	365.69	366.23	4016088.0
2020-12-02 12:00:00	SPY	ETF	366.2311	366.46	365.92	366.0744	4256859.0
2020-12-02 13:00:00	SPY	ETF	366.08	366.36	365.64	365.69	3140157.0
2020-12-02 14:00:00	SPY	ETF	365.7	366.85	365.49	366.77	5263292.0
2020-12-02 15:00:00	SPY	ETF	366.75	366.96	366.23	366.7599	8643272.0
2020-12-02 16:00:00	SPY	ETF	366.75	367.21	366.64	366.96	5817840.0
2020-12-02 17:00:00	SPY	ETF	366.93	367.02	366.89	366.97	542599.0
2020-12-02 18:00:00	SPY	ETF	367.02	367.27	366.6	366.68	102571.0
2020-12-02 19:00:00	SPY	ETF	366.61	366.7	366.4	366.5	93187.0
2020-12-02 04:00:00	QQQ	ETF	303.52	303.61	303.34	303.47	17082.0
2020-12-02 05:00:00	QQQ	ETF	303.47	303.58	303.23	303.5	7392.0
2020-12-02 06:00:00	QQQ	ETF	303.55	303.56	303.03	303.33	68501.0
2020-12-02 07:00:00	QQQ	ETF	303.33	303.37	302.27	302.61	116834.0
2020-12-02 08:00:00	QQQ	ETF	303.2796	303.46	302.28	302.55	135725.0
2020-12-02 09:00:00	QQQ	ETF	302.48	302.51	300.35	301.82	3944852.0
2020-12-02 10:00:00	QQQ	ETF	301.83	303.33	301.55	302.74	3493523.0
2020-12-02 11:00:00	QQQ	ETF	302.75	303.9	302.75	303.86	1926763.0
2020-12-02 12:00:00	QQQ	ETF	303.8544	304.195	303.18	303.3245	2391470.0
2020-12-02 13:00:00	QQQ	ETF	303.33	303.94	302.73	303.05	1473190.0
2020-12-02 14:00:00	QQQ	ETF	303.055	303.92	302.81	303.91	1665945.0
2020-12-02 15:00:00	QQQ	ETF	303.92	304.16	303.27	303.85	2793670.0
2020-12-02 16:00:00	QQQ	ETF	303.85	304.2	303.791	303.98	847586.0
2020-12-02 17:00:00	QQQ	ETF	303.94	304.34	303.714	304.25	48290.0
2020-12-02 18:00:00	QQQ	ETF	304.25	304.5	303.97	304.07	108782.0
2020-12-02 19:00:00	QQQ	ETF	304.05	304.22	303.92	304.05	53260.0
2020-12-02 04:00:00	IWM	ETF	182.13	182.36	182.08	182.31	3810.0
2020-12-02 05:00:00	IWM	ETF	182.42	182.54	182.3	182.35	2600.0
2020-12-02 06:00:00	IWM	ETF	182.31	182.31	181.83	182.1	53675.0
2020-12-02 07:00:00	IWM	ETF	182.03	182.2	181.52	181.72	94231.0
2020-12-02 08:00:00	IWM	ETF	182.04	182.22	181.55	181.73	49387.0
2020-12-02 09:00:00	IWM	ETF	181.71	181.98	180.76	181.88	2711416.0
2020-12-02 10:00:00	IWM	ETF	181.9	182.64	181.66	182.05	2076414.0
2020-12-02 11:00:00	IWM	ETF	182.05	182.56	181.69	181.82	1571537.0
2020-12-02 12:00:00	IWM	ETF	181.805	182.425	181.74	182.18	1446364.0
2020-12-02 13:00:00	IWM	ETF	182.165	182.825	181.9	182.205	1583060.0
2020-12-02 14:00:00	IWM	ETF	182.21	183.13	182.0201	183.045	1706153.0
2020-12-02 15:00:00	IWM	ETF	183.04	183.48	182.8	182.89	3088335.0
2020-12-02 16:00:00	IWM	ETF	182.89	183.36	182.89	183.26	1792620.0
2020-12-02 17:00:00	IWM	ETF	183.44	183.5	183.23	183.33	83379.0
2020-12-02 18:00:00	IWM	ETF	183.38	183.43	182.85	182.89	73400.0
2020-12-02 19:00:00	IWM	ETF	182.86	182.94	182.75	182.79	22200.0
2020-12-02 04:00:00	DIA	ETF	297.31	297.63	297.26	297.61	1550.0
2020-12-02 05:00:00	DIA	ETF	297.57	297.72	297.56	297.72	1327.0

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

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