PREVIEW / etf_1hour / 2020-06-15

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-06-15.parquet
  size:    376 KB
  rows:    13,008

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-15 04:00:00	SPY	ETF	296.36	298.62	295.91	298.52	254616.0
2020-06-15 05:00:00	SPY	ETF	298.49	299.32	297.51	299.23	118635.0
2020-06-15 06:00:00	SPY	ETF	299.11	299.54	297.13	297.3	189439.0
2020-06-15 07:00:00	SPY	ETF	297.24	299.28	296.98	298.25	869114.0
2020-06-15 08:00:00	SPY	ETF	298.29	301.05	295.39	298.09	1092264.0
2020-06-15 09:00:00	SPY	ETF	298.05	300.11	296.74	299.95	14082596.0
2020-06-15 10:00:00	SPY	ETF	299.94	301.7593	299.27	300.93	20667957.0
2020-06-15 11:00:00	SPY	ETF	300.93	302.63	300.75	301.915	15203440.0
2020-06-15 12:00:00	SPY	ETF	301.89	304.42	301.645	304.37	12281031.0
2020-06-15 13:00:00	SPY	ETF	304.36	305.31	303.81	304.06	11418487.0
2020-06-15 14:00:00	SPY	ETF	304.06	308.28	304.0597	306.73	25144600.0
2020-06-15 15:00:00	SPY	ETF	306.74	307.785	304.54	307.03	24942695.0
2020-06-15 16:00:00	SPY	ETF	307.03	308.06	306.4624	308.0	6575404.0
2020-06-15 17:00:00	SPY	ETF	307.99	308.15	307.05	308.15	864445.0
2020-06-15 18:00:00	SPY	ETF	308.15	308.91	307.05	308.36	365793.0
2020-06-15 19:00:00	SPY	ETF	308.41	310.17	307.5	310.15	447161.0
2020-06-15 04:00:00	QQQ	ETF	230.75	231.89	230.44	231.89	53177.0
2020-06-15 05:00:00	QQQ	ETF	231.76	232.55	231.27	232.44	46878.0
2020-06-15 06:00:00	QQQ	ETF	232.46	232.82	231.47	231.47	67673.0
2020-06-15 07:00:00	QQQ	ETF	231.48	232.87	231.35	232.47	265288.0
2020-06-15 08:00:00	QQQ	ETF	232.49	233.25	229.5	232.43	326518.0
2020-06-15 09:00:00	QQQ	ETF	232.47	234.305	231.47	234.24	6408621.0
2020-06-15 10:00:00	QQQ	ETF	234.22	235.19	233.27	234.07	6667585.0
2020-06-15 11:00:00	QQQ	ETF	234.07	235.27	233.92	234.95	4569914.0
2020-06-15 12:00:00	QQQ	ETF	234.93	236.46	234.77	236.46	3732846.0
2020-06-15 13:00:00	QQQ	ETF	236.45	237.04	236.22	236.8432	3047355.0
2020-06-15 14:00:00	QQQ	ETF	236.89	239.45	236.89	238.72	7084800.0
2020-06-15 15:00:00	QQQ	ETF	238.7	239.3	237.34	238.66	6632996.0
2020-06-15 16:00:00	QQQ	ETF	238.66	239.55	238.61	239.53	848793.0
2020-06-15 17:00:00	QQQ	ETF	239.5	239.65	239.31	239.44	47533.0
2020-06-15 18:00:00	QQQ	ETF	239.43	240.02	238.75	239.61	77032.0
2020-06-15 19:00:00	QQQ	ETF	239.67	241.09	239.2601	241.03	121251.0
2020-06-15 04:00:00	IWM	ETF	132.68	134.35	132.48	134.34	26843.0
2020-06-15 05:00:00	IWM	ETF	134.37	134.79	133.34	134.61	21227.0
2020-06-15 06:00:00	IWM	ETF	134.6	135.16	133.41	133.52	100695.0
2020-06-15 07:00:00	IWM	ETF	133.53	134.62	133.44	133.94	356168.0
2020-06-15 08:00:00	IWM	ETF	133.96	135.04	131.05	133.75	446255.0
2020-06-15 09:00:00	IWM	ETF	133.65	135.59	133.27	135.06	5351560.0
2020-06-15 10:00:00	IWM	ETF	135.03	137.0387	134.64	136.69	5696549.0
2020-06-15 11:00:00	IWM	ETF	136.7	138.28	136.62	137.57	5457284.0
2020-06-15 12:00:00	IWM	ETF	137.55	139.75	137.4	139.72	4066074.0
2020-06-15 13:00:00	IWM	ETF	139.73	140.895	138.83	138.885	4403182.0
2020-06-15 14:00:00	IWM	ETF	138.905	142.06	138.885	140.32	9366803.0
2020-06-15 15:00:00	IWM	ETF	140.31	141.21	139.31	141.07	6772926.0
2020-06-15 16:00:00	IWM	ETF	141.07	141.5	137.8778	141.5	2187127.0
2020-06-15 17:00:00	IWM	ETF	141.41	141.64	141.26	141.47	28192.0
2020-06-15 18:00:00	IWM	ETF	141.47	142.28	140.99	142.05	121350.0
2020-06-15 19:00:00	IWM	ETF	141.72	142.849	141.32	142.73	52254.0
2020-06-15 04:00:00	DIA	ETF	250.0	250.78	248.33	250.78	14131.0
2020-06-15 05:00:00	DIA	ETF	250.21	251.56	249.84	251.51	10252.0

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

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