PREVIEW / etf_1hour / 2018-02-22

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-02-22.parquet
  size:    301 KB
  rows:    9,902

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-02-22 04:00:00	SPY	ETF	269.3	269.51	269.08	269.51	38914.0
2018-02-22 05:00:00	SPY	ETF	269.53	270.4	269.53	270.15	78354.0
2018-02-22 06:00:00	SPY	ETF	270.07	270.58	269.92	270.17	137881.0
2018-02-22 07:00:00	SPY	ETF	270.18	270.94	270.18	270.51	308620.0
2018-02-22 08:00:00	SPY	ETF	270.3	271.07	268.82	270.9	1225445.0
2018-02-22 09:00:00	SPY	ETF	270.93	272.27	270.76	271.23	8317767.0
2018-02-22 10:00:00	SPY	ETF	271.25	272.3385	270.82	271.74	9851054.0
2018-02-22 11:00:00	SPY	ETF	271.74	272.97	271.68	272.785	9279441.0
2018-02-22 12:00:00	SPY	ETF	272.79	273.05	271.505	271.76	13472410.0
2018-02-22 13:00:00	SPY	ETF	271.75	272.19	270.58	271.2	9830581.0
2018-02-22 14:00:00	SPY	ETF	271.2	271.94	270.24	270.33	8386233.0
2018-02-22 15:00:00	SPY	ETF	270.32	271.07	269.64	270.32	26179980.0
2018-02-22 16:00:00	SPY	ETF	270.32	271.8026	270.19	271.29	6991034.0
2018-02-22 17:00:00	SPY	ETF	271.29	271.3	271.13	271.16	1893270.0
2018-02-22 18:00:00	SPY	ETF	271.19	271.32	270.4	271.3	1912186.0
2018-02-22 19:00:00	SPY	ETF	271.23	271.84	270.99	271.75	92158.0
2018-02-22 04:00:00	QQQ	ETF	163.88	164.05	163.67	164.05	16842.0
2018-02-22 05:00:00	QQQ	ETF	164.1	164.67	164.06	164.5	44271.0
2018-02-22 06:00:00	QQQ	ETF	164.49	164.9	164.43	164.68	75902.0
2018-02-22 07:00:00	QQQ	ETF	164.65	165.26	164.65	165.06	222316.0
2018-02-22 08:00:00	QQQ	ETF	164.82	165.52	163.99	165.48	269139.0
2018-02-22 09:00:00	QQQ	ETF	165.5	166.17	165.23	165.48	3705711.0
2018-02-22 10:00:00	QQQ	ETF	165.49	166.35	165.2	165.89	4206457.0
2018-02-22 11:00:00	QQQ	ETF	165.89	166.42	165.81	166.22	2628784.0
2018-02-22 12:00:00	QQQ	ETF	166.21	166.38	165.16	165.4	2771766.0
2018-02-22 13:00:00	QQQ	ETF	165.4	165.66	164.52	165.08	4463680.0
2018-02-22 14:00:00	QQQ	ETF	165.08	165.65	164.635	164.7167	2865211.0
2018-02-22 15:00:00	QQQ	ETF	164.725	165.21	164.3769	164.86	6479101.0
2018-02-22 16:00:00	QQQ	ETF	164.87	166.16	164.8	165.53	1608877.0
2018-02-22 17:00:00	QQQ	ETF	165.54	165.54	165.36	165.4	29843.0
2018-02-22 18:00:00	QQQ	ETF	165.41	165.51	164.8	165.4	761300.0
2018-02-22 19:00:00	QQQ	ETF	165.45	165.7	165.23	165.64	81486.0
2018-02-22 04:00:00	IWM	ETF	151.96	151.96	151.35	151.58	6134.0
2018-02-22 05:00:00	IWM	ETF	151.75	152.25	151.75	152.15	10586.0
2018-02-22 06:00:00	IWM	ETF	152.07	152.42	151.98	152.21	21725.0
2018-02-22 07:00:00	IWM	ETF	152.4	152.67	152.395	152.41	176398.0
2018-02-22 08:00:00	IWM	ETF	152.38	152.84	152.25	152.71	115065.0
2018-02-22 09:00:00	IWM	ETF	152.72	153.3917	152.64	153.1	2256223.0
2018-02-22 10:00:00	IWM	ETF	153.1	153.39	152.89	153.03	1983193.0
2018-02-22 11:00:00	IWM	ETF	153.02	154.025	153.0	153.8	1545508.0
2018-02-22 12:00:00	IWM	ETF	153.81	153.91	153.06	153.18	1032866.0
2018-02-22 13:00:00	IWM	ETF	153.15	153.4	152.28	152.62	2079788.0
2018-02-22 14:00:00	IWM	ETF	152.61	153.02	152.13	152.18	1166488.0
2018-02-22 15:00:00	IWM	ETF	152.18	152.61	151.91	151.98	3183485.0
2018-02-22 16:00:00	IWM	ETF	152.01	152.94	151.98	152.89	520424.0
2018-02-22 17:00:00	IWM	ETF	152.89	152.89	152.66	152.77	2820.0
2018-02-22 18:00:00	IWM	ETF	152.73	152.84	152.6	152.81	13056.0
2018-02-22 19:00:00	IWM	ETF	152.88	153.14	152.66	152.99	15809.0
2018-02-22 04:00:00	DIA	ETF	246.9	246.9	246.9	246.9	100.0
2018-02-22 05:00:00	DIA	ETF	247.47	247.55	247.47	247.55	25300.0

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

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