PREVIEW / etf_1hour / 2020-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-11.parquet
  size:    402 KB
  rows:    13,996

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-11 04:00:00	SPY	ETF	313.45	313.87	312.34	312.85	230456.0
2020-06-11 05:00:00	SPY	ETF	312.79	314.83	312.6	314.58	207305.0
2020-06-11 06:00:00	SPY	ETF	314.7	314.75	313.2	313.3	202301.0
2020-06-11 07:00:00	SPY	ETF	313.4	313.69	311.77	312.411	1037636.0
2020-06-11 08:00:00	SPY	ETF	318.2822	318.2822	310.17	310.82	2829413.0
2020-06-11 09:00:00	SPY	ETF	310.87	312.15	310.01	311.65	21351325.0
2020-06-11 10:00:00	SPY	ETF	311.66	311.96	308.92	309.1	16779393.0
2020-06-11 11:00:00	SPY	ETF	309.08	309.56	307.16	308.01	18407658.0
2020-06-11 12:00:00	SPY	ETF	308.0	308.02	303.75	304.23	25217688.0
2020-06-11 13:00:00	SPY	ETF	304.22	305.87	303.77	304.72	17450105.0
2020-06-11 14:00:00	SPY	ETF	304.71	304.77	301.0641	301.77	26726166.0
2020-06-11 15:00:00	SPY	ETF	301.7899	302.9	300.01	300.62	58403128.0
2020-06-11 16:00:00	SPY	ETF	300.61	319.1184	300.38	301.77	17297286.0
2020-06-11 17:00:00	SPY	ETF	301.75	302.16	300.61	301.69	777022.0
2020-06-11 18:00:00	SPY	ETF	301.6	302.85	300.71	302.85	451284.0
2020-06-11 19:00:00	SPY	ETF	302.77	303.5	302.01	303.08	504486.0
2020-06-11 04:00:00	QQQ	ETF	243.01	243.52	242.25	242.33	84038.0
2020-06-11 05:00:00	QQQ	ETF	242.39	243.75	242.38	243.7	53777.0
2020-06-11 06:00:00	QQQ	ETF	243.82	243.82	242.72	242.73	179596.0
2020-06-11 07:00:00	QQQ	ETF	242.86	243.12	242.09	242.64	403406.0
2020-06-11 08:00:00	QQQ	ETF	242.8	244.97	241.52	242.44	984073.0
2020-06-11 09:00:00	QQQ	ETF	242.44	242.93	241.04	242.47	7853330.0
2020-06-11 10:00:00	QQQ	ETF	242.48	243.59	241.3	241.48	6897478.0
2020-06-11 11:00:00	QQQ	ETF	241.49	242.15	240.35	240.99	6044699.0
2020-06-11 12:00:00	QQQ	ETF	240.97	240.99	236.83	236.93	7929810.0
2020-06-11 13:00:00	QQQ	ETF	236.92	238.78	236.77	237.824	6522538.0
2020-06-11 14:00:00	QQQ	ETF	237.79	237.86	234.76	235.3898	8019785.0
2020-06-11 15:00:00	QQQ	ETF	235.37	236.4956	233.96	234.12	16061988.0
2020-06-11 16:00:00	QQQ	ETF	234.12	235.09	233.98	234.8	2061321.0
2020-06-11 17:00:00	QQQ	ETF	234.78	235.05	234.02	234.96	77295.0
2020-06-11 18:00:00	QQQ	ETF	234.85	235.7	234.27	235.7	136075.0
2020-06-11 19:00:00	QQQ	ETF	235.74	236.64	235.16	236.19	208873.0
2020-06-11 04:00:00	IWM	ETF	141.06	141.78	140.56	140.91	29732.0
2020-06-11 05:00:00	IWM	ETF	140.97	142.36	140.97	142.36	37065.0
2020-06-11 06:00:00	IWM	ETF	142.43	142.54	141.41	141.46	64949.0
2020-06-11 07:00:00	IWM	ETF	141.55	142.02	140.05	140.82	620384.0
2020-06-11 08:00:00	IWM	ETF	140.8	142.83	139.1	139.69	1108838.0
2020-06-11 09:00:00	IWM	ETF	139.64	140.89	139.24	140.655	10865451.0
2020-06-11 10:00:00	IWM	ETF	140.67	141.0323	138.95	139.07	6735903.0
2020-06-11 11:00:00	IWM	ETF	139.07	139.17	137.665	138.23	6176809.0
2020-06-11 12:00:00	IWM	ETF	138.22	138.31	136.59	136.83	6574135.0
2020-06-11 13:00:00	IWM	ETF	136.9	138.02	136.73	137.51	4472596.0
2020-06-11 14:00:00	IWM	ETF	137.51	137.64	135.46	135.8	6665801.0
2020-06-11 15:00:00	IWM	ETF	135.76	136.435	134.77	135.19	13704178.0
2020-06-11 16:00:00	IWM	ETF	135.2	135.8398	134.85	135.65	2159048.0
2020-06-11 17:00:00	IWM	ETF	135.65	135.99	135.03	135.89	412572.0
2020-06-11 18:00:00	IWM	ETF	135.74	136.2	135.03	136.2	80300.0
2020-06-11 19:00:00	IWM	ETF	136.25	137.03	136.04	136.8	58783.0
2020-06-11 04:00:00	DIA	ETF	265.8	265.8	263.98	263.98	22883.0
2020-06-11 05:00:00	DIA	ETF	264.44	265.69	264.44	265.69	13300.0

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

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