PREVIEW / etf_1hour / 2020-11-05

all etf 1-hour files

  file:    by_date/etf_1hour/2020/2020-11-05.parquet
  size:    395 KB
  rows:    13,614

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-11-05 04:00:00	SPY	ETF	347.87	349.05	347.28	349.0	81138.0
2020-11-05 05:00:00	SPY	ETF	349.0	350.66	348.81	350.66	146986.0
2020-11-05 06:00:00	SPY	ETF	350.59	350.77	349.71	349.99	184942.0
2020-11-05 07:00:00	SPY	ETF	349.96	350.3	349.06	350.12	423177.0
2020-11-05 08:00:00	SPY	ETF	350.11	350.64	345.75	349.39	475627.0
2020-11-05 09:00:00	SPY	ETF	349.4	350.71	348.46	349.85	12783580.0
2020-11-05 10:00:00	SPY	ETF	349.85	352.19	349.8	351.66	12271748.0
2020-11-05 11:00:00	SPY	ETF	351.66	351.918	350.19	350.27	6791127.0
2020-11-05 12:00:00	SPY	ETF	350.28	350.77	348.86	350.51	6526065.0
2020-11-05 13:00:00	SPY	ETF	350.51	351.37	350.46	351.15	7015753.0
2020-11-05 14:00:00	SPY	ETF	351.15	352.06	350.85	351.72	8026061.0
2020-11-05 15:00:00	SPY	ETF	351.72	351.79	349.47	350.21	19972043.0
2020-11-05 16:00:00	SPY	ETF	350.2	351.39	350.14	351.08	4867895.0
2020-11-05 17:00:00	SPY	ETF	351.08	351.1	350.75	350.9	121621.0
2020-11-05 18:00:00	SPY	ETF	350.9	350.9	348.31	349.88	531087.0
2020-11-05 19:00:00	SPY	ETF	349.94	350.11	348.76	348.9	378486.0
2020-11-05 04:00:00	QQQ	ETF	293.36	294.46	292.96	294.36	194673.0
2020-11-05 05:00:00	QQQ	ETF	294.35	295.41	294.35	295.17	163150.0
2020-11-05 06:00:00	QQQ	ETF	295.28	295.53	294.31	294.32	176930.0
2020-11-05 07:00:00	QQQ	ETF	294.31	294.63	293.76	294.55	443346.0
2020-11-05 08:00:00	QQQ	ETF	293.9948	295.03	290.75	294.08	633053.0
2020-11-05 09:00:00	QQQ	ETF	294.0	294.8	292.0	294.29	8069966.0
2020-11-05 10:00:00	QQQ	ETF	294.28	295.32	292.83	294.3997	7321520.0
2020-11-05 11:00:00	QQQ	ETF	294.39	294.64	293.1	293.16	3863438.0
2020-11-05 12:00:00	QQQ	ETF	293.17	294.13	292.05	293.47	4471528.0
2020-11-05 13:00:00	QQQ	ETF	293.49	294.33	293.3646	294.15	2239084.0
2020-11-05 14:00:00	QQQ	ETF	294.13	295.39	293.86	295.18	3637846.0
2020-11-05 15:00:00	QQQ	ETF	295.16	295.27	293.16	294.31	7093438.0
2020-11-05 16:00:00	QQQ	ETF	294.31	295.36	294.23	294.87	3154365.0
2020-11-05 17:00:00	QQQ	ETF	294.84	295.0	294.53	294.69	79237.0
2020-11-05 18:00:00	QQQ	ETF	294.69	294.81	293.47	294.3	210179.0
2020-11-05 19:00:00	QQQ	ETF	294.31	294.61	293.13	293.14	215228.0
2020-11-05 04:00:00	IWM	ETF	161.02	161.47	160.82	161.3	13156.0
2020-11-05 05:00:00	IWM	ETF	161.25	162.33	161.2	162.32	81531.0
2020-11-05 06:00:00	IWM	ETF	162.3	162.86	161.91	162.2	135828.0
2020-11-05 07:00:00	IWM	ETF	162.23	162.43	161.64	162.35	98862.0
2020-11-05 08:00:00	IWM	ETF	161.8699	162.5	160.78	161.94	261069.0
2020-11-05 09:00:00	IWM	ETF	161.94	163.64	161.35	163.19	3427540.0
2020-11-05 10:00:00	IWM	ETF	163.16	164.91	163.15	164.87	5030868.0
2020-11-05 11:00:00	IWM	ETF	164.86	164.95	164.17	164.72	3423614.0
2020-11-05 12:00:00	IWM	ETF	164.73	164.84	164.02	164.82	2086339.0
2020-11-05 13:00:00	IWM	ETF	164.83	165.23	164.77	165.07	2221435.0
2020-11-05 14:00:00	IWM	ETF	165.06	165.28	164.64	165.21	3036061.0
2020-11-05 15:00:00	IWM	ETF	165.205	165.58	164.66	164.97	4692245.0
2020-11-05 16:00:00	IWM	ETF	164.98	165.54	164.86	165.4	1204546.0
2020-11-05 17:00:00	IWM	ETF	165.36	165.49	165.08	165.16	26437.0
2020-11-05 18:00:00	IWM	ETF	165.12	165.12	163.7	164.43	121891.0
2020-11-05 19:00:00	IWM	ETF	164.4	164.55	163.71	163.76	66168.0
2020-11-05 04:00:00	DIA	ETF	280.85	281.95	280.85	281.68	1400.0
2020-11-05 05:00:00	DIA	ETF	281.83	282.47	281.83	282.47	9668.0

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

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