PREVIEW / etf_1hour / 2020-10-13

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-10-13.parquet
  size:    374 KB
  rows:    12,676

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-10-13 04:00:00	SPY	ETF	351.21	352.54	351.21	352.54	118516.0
2020-10-13 05:00:00	SPY	ETF	352.51	353.03	352.51	352.87	53311.0
2020-10-13 06:00:00	SPY	ETF	352.57	352.96	352.05	352.17	70941.0
2020-10-13 07:00:00	SPY	ETF	352.13	353.14	352.11	352.77	333642.0
2020-10-13 08:00:00	SPY	ETF	352.8701	353.1	351.4	352.16	541614.0
2020-10-13 09:00:00	SPY	ETF	352.16	352.44	351.081	351.84	8332576.0
2020-10-13 10:00:00	SPY	ETF	351.83	352.08	350.57	351.37	12099844.0
2020-10-13 11:00:00	SPY	ETF	351.41	352.4651	351.073	351.45	12683999.0
2020-10-13 12:00:00	SPY	ETF	351.467	351.64	350.6414	351.33	4352506.0
2020-10-13 13:00:00	SPY	ETF	351.32	351.62	349.77	349.95	5799359.0
2020-10-13 14:00:00	SPY	ETF	349.96	350.57	349.09	350.03	9951642.0
2020-10-13 15:00:00	SPY	ETF	350.02	351.51	349.9	350.15	11631623.0
2020-10-13 16:00:00	SPY	ETF	350.16	350.9953	349.95	350.05	4787397.0
2020-10-13 17:00:00	SPY	ETF	350.15	350.22	350.05	350.18	966571.0
2020-10-13 18:00:00	SPY	ETF	350.14	350.82	350.07	350.65	94568.0
2020-10-13 19:00:00	SPY	ETF	350.69	350.91	350.64	350.77	55895.0
2020-10-13 04:00:00	QQQ	ETF	294.02	296.5	294.02	296.44	123603.0
2020-10-13 05:00:00	QQQ	ETF	296.43	297.61	296.1	297.58	213290.0
2020-10-13 06:00:00	QQQ	ETF	297.77	298.67	296.76	297.07	309126.0
2020-10-13 07:00:00	QQQ	ETF	297.05	298.11	296.53	297.38	690313.0
2020-10-13 08:00:00	QQQ	ETF	297.3401	298.55	294.08	296.35	504978.0
2020-10-13 09:00:00	QQQ	ETF	296.3	296.82	293.4	294.893	6275592.0
2020-10-13 10:00:00	QQQ	ETF	294.92	295.69	293.4646	295.63	6679648.0
2020-10-13 11:00:00	QQQ	ETF	295.635	297.0496	295.2	295.88	5340063.0
2020-10-13 12:00:00	QQQ	ETF	295.8543	296.1699	294.42	295.41	2889232.0
2020-10-13 13:00:00	QQQ	ETF	295.39	296.08	293.35	293.62	4501608.0
2020-10-13 14:00:00	QQQ	ETF	293.63	294.72	293.11	294.52	4944561.0
2020-10-13 15:00:00	QQQ	ETF	294.53	296.21	294.361	294.44	7692921.0
2020-10-13 16:00:00	QQQ	ETF	294.43	295.04	294.31	294.56	8669117.0
2020-10-13 17:00:00	QQQ	ETF	294.61	294.78	294.52	294.65	24790.0
2020-10-13 18:00:00	QQQ	ETF	294.66	295.37	294.55	295.19	92533.0
2020-10-13 19:00:00	QQQ	ETF	295.15	295.55	295.15	295.39	81960.0
2020-10-13 04:00:00	IWM	ETF	162.69	162.95	162.59	162.8	17939.0
2020-10-13 05:00:00	IWM	ETF	162.79	162.87	162.62	162.66	14469.0
2020-10-13 06:00:00	IWM	ETF	162.62	162.63	162.3	162.46	29847.0
2020-10-13 07:00:00	IWM	ETF	162.5	163.16	162.5	162.82	347866.0
2020-10-13 08:00:00	IWM	ETF	162.9901	163.03	162.3704	162.7	135120.0
2020-10-13 09:00:00	IWM	ETF	162.66	162.91	161.48	162.3	3679993.0
2020-10-13 10:00:00	IWM	ETF	162.33	162.64	161.68	162.265	2606380.0
2020-10-13 11:00:00	IWM	ETF	162.3	162.55	162.025	162.38	1429245.0
2020-10-13 12:00:00	IWM	ETF	162.41	163.1	162.13	163.03	1406810.0
2020-10-13 13:00:00	IWM	ETF	163.0235	163.22	162.6	162.65	1567586.0
2020-10-13 14:00:00	IWM	ETF	162.655	162.93	162.13	162.42	2358593.0
2020-10-13 15:00:00	IWM	ETF	162.415	163.11	162.38	162.67	3110904.0
2020-10-13 16:00:00	IWM	ETF	162.7	162.75	162.45	162.55	961399.0
2020-10-13 17:00:00	IWM	ETF	162.52	162.66	162.51	162.55	1000.0
2020-10-13 18:00:00	IWM	ETF	162.58	162.83	162.51	162.82	17598.0
2020-10-13 19:00:00	IWM	ETF	162.75	162.83	162.73	162.78	10375.0
2020-10-13 04:00:00	DIA	ETF	287.95	288.21	287.85	288.18	2745.0
2020-10-13 05:00:00	DIA	ETF	288.24	288.29	287.97	287.97	500.0

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

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