PREVIEW / etf_1hour / 2018-05-23

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-05-23.parquet
  size:    299 KB
  rows:    9,859

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-05-23 04:00:00	SPY	ETF	271.18	271.27	270.7	270.87	31681.0
2018-05-23 05:00:00	SPY	ETF	270.86	271.07	270.6	270.72	165376.0
2018-05-23 06:00:00	SPY	ETF	270.78	271.1	270.7	271.02	86899.0
2018-05-23 07:00:00	SPY	ETF	271.04	271.12	270.75	270.96	262861.0
2018-05-23 08:00:00	SPY	ETF	270.95	272.18	270.76	271.07	451555.0
2018-05-23 09:00:00	SPY	ETF	271.07	271.76	270.86	271.597	6699982.0
2018-05-23 10:00:00	SPY	ETF	271.61	272.22	270.99	271.24	8023553.0
2018-05-23 11:00:00	SPY	ETF	271.23	272.1	271.18	271.449	6305328.0
2018-05-23 12:00:00	SPY	ETF	271.45	271.96	271.1801	271.88	4491746.0
2018-05-23 13:00:00	SPY	ETF	271.87	271.9	271.39	271.69	3191550.0
2018-05-23 14:00:00	SPY	ETF	271.69	272.88	271.61	272.79	9751841.0
2018-05-23 15:00:00	SPY	ETF	272.79	273.39	272.66	273.38	13737695.0
2018-05-23 16:00:00	SPY	ETF	273.37	273.43	271.25	273.13	9440895.0
2018-05-23 17:00:00	SPY	ETF	273.12	273.15	273.03	273.06	186475.0
2018-05-23 18:00:00	SPY	ETF	273.08	273.2	273.06	273.11	35299.0
2018-05-23 19:00:00	SPY	ETF	273.17	273.17	273.02	273.05	31199.0
2018-05-23 04:00:00	QQQ	ETF	167.07	167.5	166.58	166.69	26001.0
2018-05-23 05:00:00	QQQ	ETF	166.69	166.8	166.49	166.55	33149.0
2018-05-23 06:00:00	QQQ	ETF	166.61	166.82	166.51	166.74	22592.0
2018-05-23 07:00:00	QQQ	ETF	166.74	166.88	166.62	166.72	98308.0
2018-05-23 08:00:00	QQQ	ETF	166.72	166.9	166.54	166.79	412570.0
2018-05-23 09:00:00	QQQ	ETF	166.77	167.665	166.64	167.47	3103378.0
2018-05-23 10:00:00	QQQ	ETF	167.47	168.075	167.155	167.38	3989865.0
2018-05-23 11:00:00	QQQ	ETF	167.37	168.2801	167.34	167.86	2750176.0
2018-05-23 12:00:00	QQQ	ETF	167.8733	168.459	167.7408	168.35	2126717.0
2018-05-23 13:00:00	QQQ	ETF	168.34	168.361	167.93	168.085	2062247.0
2018-05-23 14:00:00	QQQ	ETF	168.0808	169.06	168.0	169.05	4221739.0
2018-05-23 15:00:00	QQQ	ETF	169.05	169.61	168.93	169.6	5206678.0
2018-05-23 16:00:00	QQQ	ETF	169.6	169.63	169.36	169.51	1019298.0
2018-05-23 17:00:00	QQQ	ETF	169.45	169.55	169.44	169.44	7857.0
2018-05-23 18:00:00	QQQ	ETF	169.55	169.57	169.5	169.56	8625.0
2018-05-23 19:00:00	QQQ	ETF	169.56	169.56	169.35	169.38	16153.0
2018-05-23 04:00:00	IWM	ETF	161.16	161.23	161.0	161.08	2206.0
2018-05-23 05:00:00	IWM	ETF	161.15	161.15	160.98	161.11	10500.0
2018-05-23 06:00:00	IWM	ETF	161.11	161.23	161.01	161.22	28946.0
2018-05-23 07:00:00	IWM	ETF	161.24	161.29	161.11	161.17	32183.0
2018-05-23 08:00:00	IWM	ETF	161.24	161.39	135.5082	161.33	113174.0
2018-05-23 09:00:00	IWM	ETF	161.33	161.78	161.13	161.66	2684904.0
2018-05-23 10:00:00	IWM	ETF	161.67	162.21	161.48	161.61	2078588.0
2018-05-23 11:00:00	IWM	ETF	161.6	162.28	161.55	161.85	1584201.0
2018-05-23 12:00:00	IWM	ETF	161.85	162.02	161.54	161.655	1040890.0
2018-05-23 13:00:00	IWM	ETF	161.64	161.65	161.29	161.53	1008793.0
2018-05-23 14:00:00	IWM	ETF	161.54	162.03	161.46	161.8061	1630994.0
2018-05-23 15:00:00	IWM	ETF	161.81	162.0	161.61	161.98	2517599.0
2018-05-23 16:00:00	IWM	ETF	161.99	162.06	161.9298	162.05	425553.0
2018-05-23 17:00:00	IWM	ETF	162.05	162.07	162.05	162.07	325.0
2018-05-23 18:00:00	IWM	ETF	162.07	162.1	162.01	162.04	3400.0
2018-05-23 19:00:00	IWM	ETF	162.06	162.08	161.99	161.99	2166.0
2018-05-23 04:00:00	DIA	ETF	246.45	246.45	246.38	246.38	200.0
2018-05-23 05:00:00	DIA	ETF	246.3	246.58	246.3	246.4	460.0

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

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