PREVIEW / etf_1hour / 2018-07-18

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-07-18.parquet
  size:    295 KB
  rows:    9,688

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
2018-07-18 04:00:00	SPY	ETF	280.89	280.89	280.38	280.52	23232.0
2018-07-18 05:00:00	SPY	ETF	280.56	280.69	280.56	280.69	7055.0
2018-07-18 06:00:00	SPY	ETF	280.64	280.68	280.45	280.55	13796.0
2018-07-18 07:00:00	SPY	ETF	280.51	280.57	280.37	280.4	123092.0
2018-07-18 08:00:00	SPY	ETF	280.4101	280.76	280.16	280.36	452772.0
2018-07-18 09:00:00	SPY	ETF	280.34	280.75	280.26	280.41	4886608.0
2018-07-18 10:00:00	SPY	ETF	280.41	280.5	280.06	280.43	5356074.0
2018-07-18 11:00:00	SPY	ETF	280.43	281.1046	280.34	281.05	4321354.0
2018-07-18 12:00:00	SPY	ETF	281.05	281.17	280.89	280.9601	3355505.0
2018-07-18 13:00:00	SPY	ETF	280.96	281.02	280.64	280.82	2582199.0
2018-07-18 14:00:00	SPY	ETF	280.815	281.09	280.78	281.0	3529716.0
2018-07-18 15:00:00	SPY	ETF	280.995	281.18	280.94	281.05	11050252.0
2018-07-18 16:00:00	SPY	ETF	281.05	281.08	280.84	280.87	8038621.0
2018-07-18 17:00:00	SPY	ETF	280.94	281.06	280.89	280.91	128378.0
2018-07-18 18:00:00	SPY	ETF	280.9	280.97	280.83	280.97	74641.0
2018-07-18 19:00:00	SPY	ETF	280.98	281.05	280.96	281.03	25084.0
2018-07-18 20:00:00	SPY	ETF	281.06	281.06	281.0503	281.0503	70000.0
2018-07-18 04:00:00	QQQ	ETF	180.3	180.3	180.16	180.25	11219.0
2018-07-18 05:00:00	QQQ	ETF	180.24	180.35	180.24	180.34	8040.0
2018-07-18 06:00:00	QQQ	ETF	180.28	180.3	180.15	180.17	11759.0
2018-07-18 07:00:00	QQQ	ETF	180.16	180.23	180.05	180.11	60895.0
2018-07-18 08:00:00	QQQ	ETF	180.27	180.42	179.94	180.11	178278.0
2018-07-18 09:00:00	QQQ	ETF	180.14	180.44	179.6	179.86	2945680.0
2018-07-18 10:00:00	QQQ	ETF	179.85	180.0	179.38	179.73	3834569.0
2018-07-18 11:00:00	QQQ	ETF	179.73	180.12	179.6	180.055	2233928.0
2018-07-18 12:00:00	QQQ	ETF	180.055	180.14	179.74	180.03	1591819.0
2018-07-18 13:00:00	QQQ	ETF	180.0284	180.1598	179.8501	180.05	1253325.0
2018-07-18 14:00:00	QQQ	ETF	180.0516	180.2233	179.89	180.01	2123741.0
2018-07-18 15:00:00	QQQ	ETF	180.0016	180.13	179.9	179.93	2924418.0
2018-07-18 16:00:00	QQQ	ETF	179.93	179.97	179.76	179.81	815649.0
2018-07-18 17:00:00	QQQ	ETF	179.84	179.89	179.8	179.89	13996.0
2018-07-18 18:00:00	QQQ	ETF	179.85	179.94	179.81	179.9	24045.0
2018-07-18 19:00:00	QQQ	ETF	179.94	180.03	179.93	179.99	12632.0
2018-07-18 06:00:00	IWM	ETF	167.56	167.56	167.41	167.41	400.0
2018-07-18 07:00:00	IWM	ETF	167.46	167.46	167.31	167.41	2168.0
2018-07-18 08:00:00	IWM	ETF	167.36	167.36	167.12	167.23	6912.0
2018-07-18 09:00:00	IWM	ETF	167.23	167.52	166.91	167.15	1602017.0
2018-07-18 10:00:00	IWM	ETF	167.14	167.15	166.57	166.93	2484347.0
2018-07-18 11:00:00	IWM	ETF	166.92	167.666	166.91	167.635	1792898.0
2018-07-18 12:00:00	IWM	ETF	167.64	167.7	167.395	167.53	868026.0
2018-07-18 13:00:00	IWM	ETF	167.53	167.59	167.09	167.27	894050.0
2018-07-18 14:00:00	IWM	ETF	167.27	167.8764	167.25	167.83	1091026.0
2018-07-18 15:00:00	IWM	ETF	167.8251	168.06	167.7425	167.98	2490073.0
2018-07-18 16:00:00	IWM	ETF	167.98	168.03	167.87	167.91	398835.0
2018-07-18 18:00:00	IWM	ETF	167.92	167.98	167.91	167.98	2857.0
2018-07-18 19:00:00	IWM	ETF	168.04	168.05	168.01	168.05	4275.0
2018-07-18 07:00:00	DIA	ETF	251.33	251.33	251.33	251.33	100.0
2018-07-18 08:00:00	DIA	ETF	251.28	251.56	251.02	251.32	8008.0
2018-07-18 09:00:00	DIA	ETF	251.3	251.58	251.02	251.45	287563.0
2018-07-18 10:00:00	DIA	ETF	251.46	251.67	251.2	251.57	297955.0

> showing 50 of 9,688 rows — these rows as CSV

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