PREVIEW / etf_1hour / 2020-05-22

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-05-22.parquet
  size:    347 KB
  rows:    12,057

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-05-22 04:00:00	SPY	ETF	291.45	292.58	291.2	292.52	80109.0
2020-05-22 05:00:00	SPY	ETF	292.62	293.04	292.28	292.33	89083.0
2020-05-22 06:00:00	SPY	ETF	292.38	293.25	292.37	293.04	172744.0
2020-05-22 07:00:00	SPY	ETF	293.03	294.64	293.01	294.45	653762.0
2020-05-22 08:00:00	SPY	ETF	294.5	294.92	291.0	294.41	638717.0
2020-05-22 09:00:00	SPY	ETF	294.39	294.92	293.37	294.28	7010934.0
2020-05-22 10:00:00	SPY	ETF	294.28	294.53	293.22	293.46	9782974.0
2020-05-22 11:00:00	SPY	ETF	293.43	294.65	293.28	293.975	5952512.0
2020-05-22 12:00:00	SPY	ETF	293.975	294.73	293.667	294.43	4419279.0
2020-05-22 13:00:00	SPY	ETF	294.42	294.83	294.3	294.75	5043127.0
2020-05-22 14:00:00	SPY	ETF	294.76	295.45	294.715	295.04	5491516.0
2020-05-22 15:00:00	SPY	ETF	295.03	295.63	294.25	295.42	15872695.0
2020-05-22 16:00:00	SPY	ETF	295.41	296.1	295.32	295.99	6732509.0
2020-05-22 17:00:00	SPY	ETF	295.95	296.07	295.44	295.83	688592.0
2020-05-22 18:00:00	SPY	ETF	295.85	296.1	295.81	295.91	75584.0
2020-05-22 19:00:00	SPY	ETF	295.9	295.97	295.35	295.6	192347.0
2020-05-22 04:00:00	QQQ	ETF	226.34	226.96	225.98	226.96	37921.0
2020-05-22 05:00:00	QQQ	ETF	226.97	227.27	226.73	226.8	20491.0
2020-05-22 06:00:00	QQQ	ETF	226.74	227.43	226.74	227.18	37226.0
2020-05-22 07:00:00	QQQ	ETF	227.21	228.43	227.21	228.32	234304.0
2020-05-22 08:00:00	QQQ	ETF	227.5899	228.59	226.05	228.24	363321.0
2020-05-22 09:00:00	QQQ	ETF	228.21	229.42	227.5	229.29	4318205.0
2020-05-22 10:00:00	QQQ	ETF	229.32	229.355	228.0	228.1923	3960961.0
2020-05-22 11:00:00	QQQ	ETF	228.16	228.6999	227.915	228.54	2741148.0
2020-05-22 12:00:00	QQQ	ETF	228.57	229.295	228.33	228.98	2418354.0
2020-05-22 13:00:00	QQQ	ETF	228.9631	229.592	228.9631	229.36	2541657.0
2020-05-22 14:00:00	QQQ	ETF	229.37	229.87	229.29	229.51	2777782.0
2020-05-22 15:00:00	QQQ	ETF	229.51	229.8	228.82	229.6	4189159.0
2020-05-22 16:00:00	QQQ	ETF	229.59	229.96	228.9341	229.96	780490.0
2020-05-22 17:00:00	QQQ	ETF	229.97	229.97	229.66	229.74	54945.0
2020-05-22 18:00:00	QQQ	ETF	229.77	229.86	229.7	229.7	12127.0
2020-05-22 19:00:00	QQQ	ETF	229.71	229.73	229.6	229.7	28643.0
2020-05-22 04:00:00	IWM	ETF	131.81	133.0	131.68	132.95	13259.0
2020-05-22 05:00:00	IWM	ETF	132.98	133.29	132.98	133.03	30100.0
2020-05-22 06:00:00	IWM	ETF	133.0	133.58	132.99	133.29	8093.0
2020-05-22 07:00:00	IWM	ETF	133.55	134.58	133.48	134.29	129334.0
2020-05-22 08:00:00	IWM	ETF	133.7599	134.71	131.53	134.5	136024.0
2020-05-22 09:00:00	IWM	ETF	134.63	135.05	133.78	134.13	3754192.0
2020-05-22 10:00:00	IWM	ETF	134.14	134.16	133.07	133.18	4379464.0
2020-05-22 11:00:00	IWM	ETF	133.17	133.98	133.02	133.74	2187105.0
2020-05-22 12:00:00	IWM	ETF	133.77	134.305	133.47	134.16	1317459.0
2020-05-22 13:00:00	IWM	ETF	134.165	134.285	133.74	134.18	2007026.0
2020-05-22 14:00:00	IWM	ETF	134.19	134.725	134.16	134.655	1653754.0
2020-05-22 15:00:00	IWM	ETF	134.65	135.01	134.18	134.83	3339007.0
2020-05-22 16:00:00	IWM	ETF	134.89	135.3	134.82	135.16	1040257.0
2020-05-22 17:00:00	IWM	ETF	135.06	135.12	135.03	135.03	13827.0
2020-05-22 18:00:00	IWM	ETF	135.09	135.09	135.01	135.01	7547.0
2020-05-22 19:00:00	IWM	ETF	135.02	135.02	134.8701	134.98	15413.0
2020-05-22 04:00:00	DIA	ETF	242.19	243.08	242.19	243.06	8528.0
2020-05-22 05:00:00	DIA	ETF	243.46	243.49	243.46	243.49	500.0

> showing 50 of 12,057 rows — these rows as CSV

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