PREVIEW / etf_1hour / 2020-07-29

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-07-29.parquet
  size:    360 KB
  rows:    12,349

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-07-29 04:00:00	SPY	ETF	321.93	322.23	321.78	321.93	14602.0
2020-07-29 05:00:00	SPY	ETF	321.9	322.01	321.56	321.93	7412.0
2020-07-29 06:00:00	SPY	ETF	322.01	322.13	321.78	321.78	17532.0
2020-07-29 07:00:00	SPY	ETF	321.8	322.19	321.68	322.07	87225.0
2020-07-29 08:00:00	SPY	ETF	321.8099	322.62	320.7	322.33	233055.0
2020-07-29 09:00:00	SPY	ETF	322.29	322.97	322.075	322.81	3902005.0
2020-07-29 10:00:00	SPY	ETF	322.81	323.77	322.76	323.75	4666740.0
2020-07-29 11:00:00	SPY	ETF	323.74	323.86	323.34	323.67	4149015.0
2020-07-29 12:00:00	SPY	ETF	323.67	324.12	323.23	323.96	5828653.0
2020-07-29 13:00:00	SPY	ETF	323.96	324.3	323.78	324.03	2806428.0
2020-07-29 14:00:00	SPY	ETF	324.02	325.44	323.62	324.54	7272827.0
2020-07-29 15:00:00	SPY	ETF	324.54	325.73	323.872	325.09	15291624.0
2020-07-29 16:00:00	SPY	ETF	325.08	325.71	324.645	325.65	3118631.0
2020-07-29 17:00:00	SPY	ETF	325.59	325.7	325.55	325.66	118506.0
2020-07-29 18:00:00	SPY	ETF	325.65	325.69	325.3	325.3	93211.0
2020-07-29 19:00:00	SPY	ETF	325.41	325.44	325.1	325.14	48665.0
2020-07-29 04:00:00	QQQ	ETF	258.34	258.44	257.95	258.19	18897.0
2020-07-29 05:00:00	QQQ	ETF	258.21	258.27	257.75	258.27	17492.0
2020-07-29 06:00:00	QQQ	ETF	258.34	258.6	258.22	258.22	25207.0
2020-07-29 07:00:00	QQQ	ETF	258.22	258.58	258.14	258.48	73516.0
2020-07-29 08:00:00	QQQ	ETF	258.53	259.0	256.55	258.61	244442.0
2020-07-29 09:00:00	QQQ	ETF	258.54	258.89	257.91	258.58	3108198.0
2020-07-29 10:00:00	QQQ	ETF	258.6102	259.695	258.56	259.53	2606126.0
2020-07-29 11:00:00	QQQ	ETF	259.53	259.608	259.05	259.19	1378269.0
2020-07-29 12:00:00	QQQ	ETF	259.1704	259.42	258.21	259.2	2844556.0
2020-07-29 13:00:00	QQQ	ETF	259.2	259.38	258.765	258.98	1392430.0
2020-07-29 14:00:00	QQQ	ETF	258.97	260.66	258.6	259.51	3255529.0
2020-07-29 15:00:00	QQQ	ETF	259.52	260.41	258.84	259.83	6954825.0
2020-07-29 16:00:00	QQQ	ETF	259.81	260.98	259.58	260.98	1086230.0
2020-07-29 17:00:00	QQQ	ETF	260.96	260.96	260.72	260.86	57856.0
2020-07-29 18:00:00	QQQ	ETF	260.88	261.03	260.51	260.54	105090.0
2020-07-29 19:00:00	QQQ	ETF	260.54	260.7	260.42	260.55	94515.0
2020-07-29 04:00:00	IWM	ETF	146.7	146.74	146.55	146.55	1102.0
2020-07-29 05:00:00	IWM	ETF	146.7	146.7	146.55	146.7	1077.0
2020-07-29 06:00:00	IWM	ETF	146.71	146.79	146.54	146.57	3908.0
2020-07-29 07:00:00	IWM	ETF	146.59	146.73	146.51	146.61	15239.0
2020-07-29 08:00:00	IWM	ETF	146.71	146.92	146.26	146.92	18422.0
2020-07-29 09:00:00	IWM	ETF	146.92	147.96	146.88	147.6	1463420.0
2020-07-29 10:00:00	IWM	ETF	147.635	148.01	147.46	147.8	1621027.0
2020-07-29 11:00:00	IWM	ETF	147.8	148.3392	147.72	148.22	985563.0
2020-07-29 12:00:00	IWM	ETF	148.23	148.63	148.18	148.305	1055144.0
2020-07-29 13:00:00	IWM	ETF	148.32	148.475	148.12	148.36	930671.0
2020-07-29 14:00:00	IWM	ETF	148.38	149.01	148.26	148.64	1655384.0
2020-07-29 15:00:00	IWM	ETF	148.65	149.4486	148.34	149.31	4367604.0
2020-07-29 16:00:00	IWM	ETF	149.31	149.39	148.94	149.22	3164921.0
2020-07-29 17:00:00	IWM	ETF	149.12	149.3	149.12	149.17	9219.0
2020-07-29 18:00:00	IWM	ETF	149.2	149.2	149.08	149.18	4011.0
2020-07-29 19:00:00	IWM	ETF	149.25	149.29	149.05	149.06	2690.0
2020-07-29 07:00:00	DIA	ETF	264.12	264.36	263.87	264.3	27459.0
2020-07-29 08:00:00	DIA	ETF	264.15	264.82	264.0899	264.45	2940.0

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

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