PREVIEW / etf_1hour / 2019-06-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-07.parquet
  size:    328 KB
  rows:    10,812

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
2019-06-07 04:00:00	SPY	ETF	285.38	285.77	285.38	285.65	13142.0
2019-06-07 05:00:00	SPY	ETF	285.65	285.8	285.57	285.65	37111.0
2019-06-07 06:00:00	SPY	ETF	285.65	285.9	285.58	285.84	61341.0
2019-06-07 07:00:00	SPY	ETF	285.84	285.87	285.61	285.62	244380.0
2019-06-07 08:00:00	SPY	ETF	285.6217	286.36	284.88	285.5	2462249.0
2019-06-07 09:00:00	SPY	ETF	285.51	287.1	285.39	287.05	9124048.0
2019-06-07 10:00:00	SPY	ETF	287.06	288.74	287.0	288.73	12584341.0
2019-06-07 11:00:00	SPY	ETF	288.73	288.85	287.7	287.85	8959542.0
2019-06-07 12:00:00	SPY	ETF	287.85	288.5	287.63	288.5	5915547.0
2019-06-07 13:00:00	SPY	ETF	288.49	288.59	287.92	288.295	4184554.0
2019-06-07 14:00:00	SPY	ETF	288.29	288.38	287.72	287.76	7169578.0
2019-06-07 15:00:00	SPY	ETF	287.755	288.28	287.5101	287.63	15695786.0
2019-06-07 16:00:00	SPY	ETF	287.63	287.99	287.35	287.98	6389350.0
2019-06-07 17:00:00	SPY	ETF	287.99	287.99	287.65	287.88	90361.0
2019-06-07 18:00:00	SPY	ETF	287.87	287.96	287.87	287.96	9468.0
2019-06-07 19:00:00	SPY	ETF	287.96	288.13	287.94	288.04	32040.0
2019-06-07 04:00:00	QQQ	ETF	177.87	178.34	177.87	178.28	81062.0
2019-06-07 05:00:00	QQQ	ETF	178.25	178.46	178.25	178.33	10560.0
2019-06-07 06:00:00	QQQ	ETF	178.3	178.57	178.25	178.48	11250.0
2019-06-07 07:00:00	QQQ	ETF	178.54	178.56	178.27	178.28	126835.0
2019-06-07 08:00:00	QQQ	ETF	178.4101	178.89	177.74	178.3	1058398.0
2019-06-07 09:00:00	QQQ	ETF	178.27	179.87	178.16	179.82	7084407.0
2019-06-07 10:00:00	QQQ	ETF	179.83	181.6	179.82	181.5988	7216009.0
2019-06-07 11:00:00	QQQ	ETF	181.6	181.7666	180.85	181.0599	5467794.0
2019-06-07 12:00:00	QQQ	ETF	181.03	181.44	180.9	181.42	2728005.0
2019-06-07 13:00:00	QQQ	ETF	181.43	181.5	181.07	181.38	2265128.0
2019-06-07 14:00:00	QQQ	ETF	181.38	181.47	180.945	180.985	2458756.0
2019-06-07 15:00:00	QQQ	ETF	180.98	181.33	180.9	181.01	7956065.0
2019-06-07 16:00:00	QQQ	ETF	181.01	181.18	180.76	181.18	2637004.0
2019-06-07 17:00:00	QQQ	ETF	181.04	181.09	181.0	181.02	7291.0
2019-06-07 18:00:00	QQQ	ETF	181.08	181.2	181.03	181.16	9060.0
2019-06-07 19:00:00	QQQ	ETF	181.16	181.22	181.06	181.22	9267.0
2019-06-07 04:00:00	IWM	ETF	150.32	150.37	150.32	150.37	1400.0
2019-06-07 05:00:00	IWM	ETF	150.4	150.4	150.4	150.4	200.0
2019-06-07 06:00:00	IWM	ETF	150.26	150.44	150.26	150.44	2700.0
2019-06-07 07:00:00	IWM	ETF	150.42	150.47	150.38	150.38	22220.0
2019-06-07 08:00:00	IWM	ETF	150.37	150.43	149.69	150.09	362250.0
2019-06-07 09:00:00	IWM	ETF	150.08	150.78	150.02	150.59	1852070.0
2019-06-07 10:00:00	IWM	ETF	150.6	151.51	150.21	151.4489	3257128.0
2019-06-07 11:00:00	IWM	ETF	151.44	151.46	150.42	150.64	2003080.0
2019-06-07 12:00:00	IWM	ETF	150.64	151.31	150.45	151.31	1171976.0
2019-06-07 13:00:00	IWM	ETF	151.31	151.355	150.99	151.295	709432.0
2019-06-07 14:00:00	IWM	ETF	151.3	151.3	150.8	150.93	1347957.0
2019-06-07 15:00:00	IWM	ETF	150.9233	151.335	150.79	150.81	3149385.0
2019-06-07 16:00:00	IWM	ETF	150.82	150.8789	150.66	150.8	875786.0
2019-06-07 17:00:00	IWM	ETF	150.8	150.8	150.7	150.78	1700.0
2019-06-07 18:00:00	IWM	ETF	150.76	150.78	150.76	150.78	1100.0
2019-06-07 19:00:00	IWM	ETF	150.78	150.86	150.78	150.86	1210.0
2019-06-07 04:00:00	DIA	ETF	258.52	258.52	258.52	258.52	200.0
2019-06-07 07:00:00	DIA	ETF	258.66	258.66	258.47	258.47	2650.0

> showing 50 of 10,812 rows — these rows as CSV

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