PREVIEW / etf_1hour / 2020-09-11

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-09-11.parquet
  size:    362 KB
  rows:    12,394

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-09-11 04:00:00	SPY	ETF	336.17	337.42	336.17	336.85	32510.0
2020-09-11 05:00:00	SPY	ETF	336.66	337.61	336.66	337.5	14594.0
2020-09-11 06:00:00	SPY	ETF	337.56	337.56	336.53	336.85	113616.0
2020-09-11 07:00:00	SPY	ETF	336.89	337.25	336.18	336.7	219842.0
2020-09-11 08:00:00	SPY	ETF	336.65	337.24	335.34	335.65	426034.0
2020-09-11 09:00:00	SPY	ETF	335.63	336.53	333.94	334.18	6911627.0
2020-09-11 10:00:00	SPY	ETF	334.17	336.59	333.71	335.62	11164930.0
2020-09-11 11:00:00	SPY	ETF	335.65	336.97	334.7	334.8	8486399.0
2020-09-11 12:00:00	SPY	ETF	334.785	335.86	333.06	333.14	8649366.0
2020-09-11 13:00:00	SPY	ETF	333.14	333.53	331.0	331.475	11143519.0
2020-09-11 14:00:00	SPY	ETF	331.48	334.32	331.125	333.62	8624817.0
2020-09-11 15:00:00	SPY	ETF	333.6	335.36	332.36	334.08	18292797.0
2020-09-11 16:00:00	SPY	ETF	334.09	334.8	333.23	333.88	8768762.0
2020-09-11 17:00:00	SPY	ETF	333.89	334.06	333.67	333.95	711147.0
2020-09-11 18:00:00	SPY	ETF	333.92	333.96	333.7101	333.75	20024.0
2020-09-11 19:00:00	SPY	ETF	333.81	333.97	333.61	333.91	31101.0
2020-09-11 04:00:00	QQQ	ETF	275.42	277.0	275.42	276.03	72825.0
2020-09-11 05:00:00	QQQ	ETF	276.15	276.55	275.94	276.22	25651.0
2020-09-11 06:00:00	QQQ	ETF	276.33	276.33	274.55	274.83	186879.0
2020-09-11 07:00:00	QQQ	ETF	274.85	275.56	274.26	275.3	280716.0
2020-09-11 08:00:00	QQQ	ETF	274.77	276.56	273.4	273.57	541967.0
2020-09-11 09:00:00	QQQ	ETF	273.54	275.22	271.46	271.78	5846035.0
2020-09-11 10:00:00	QQQ	ETF	271.77	274.67	270.78	273.4	10167398.0
2020-09-11 11:00:00	QQQ	ETF	273.4	274.79	271.22	271.25	6561602.0
2020-09-11 12:00:00	QQQ	ETF	271.24	272.28	268.81	268.9	7040019.0
2020-09-11 13:00:00	QQQ	ETF	268.87	269.39	266.9	267.6287	10109135.0
2020-09-11 14:00:00	QQQ	ETF	267.65	270.61	267.44	269.47	7522859.0
2020-09-11 15:00:00	QQQ	ETF	269.47	271.49	268.25	270.46	8439444.0
2020-09-11 16:00:00	QQQ	ETF	270.44	270.79	269.66	270.14	1692391.0
2020-09-11 17:00:00	QQQ	ETF	270.25	270.45	269.9	269.95	74016.0
2020-09-11 18:00:00	QQQ	ETF	269.97	270.14	269.81	269.89	14778.0
2020-09-11 19:00:00	QQQ	ETF	269.81	269.88	269.67	269.75	20557.0
2020-09-11 04:00:00	IWM	ETF	151.0	151.5	151.0	151.28	9149.0
2020-09-11 05:00:00	IWM	ETF	151.2	151.54	151.2	151.43	8534.0
2020-09-11 06:00:00	IWM	ETF	151.5	151.53	151.29	151.45	9665.0
2020-09-11 07:00:00	IWM	ETF	151.4	151.41	150.91	151.1	26410.0
2020-09-11 08:00:00	IWM	ETF	151.4004	151.4004	150.65	150.74	31609.0
2020-09-11 09:00:00	IWM	ETF	150.83	151.18	149.69	149.83	1466250.0
2020-09-11 10:00:00	IWM	ETF	149.81	150.91	149.73	150.23	2488943.0
2020-09-11 11:00:00	IWM	ETF	150.31	150.95	149.87	149.96	1497853.0
2020-09-11 12:00:00	IWM	ETF	149.965	150.48	149.2	149.24	1437021.0
2020-09-11 13:00:00	IWM	ETF	149.24	149.38	147.83	147.84	2769587.0
2020-09-11 14:00:00	IWM	ETF	147.85	149.15	147.675	148.91	2241003.0
2020-09-11 15:00:00	IWM	ETF	148.89	149.75	148.44	149.14	4182015.0
2020-09-11 16:00:00	IWM	ETF	149.14	149.28	148.74	148.82	1397241.0
2020-09-11 17:00:00	IWM	ETF	148.76	148.92	148.73	148.92	8682.0
2020-09-11 18:00:00	IWM	ETF	148.95	148.95	148.95	148.95	550.0
2020-09-11 19:00:00	IWM	ETF	148.94	148.95	148.94	148.95	879.0
2020-09-11 04:00:00	DIA	ETF	277.33	277.84	277.33	277.84	500.0
2020-09-11 05:00:00	DIA	ETF	278.18	278.18	277.89	277.89	400.0

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

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