PREVIEW / etf_1hour / 2019-05-07

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-05-07.parquet
  size:    337 KB
  rows:    11,071

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-05-07 04:00:00	SPY	ETF	291.81	292.07	291.48	291.48	34989.0
2019-05-07 05:00:00	SPY	ETF	291.41	291.46	291.15	291.4	6475.0
2019-05-07 06:00:00	SPY	ETF	291.39	291.43	290.88	290.91	106913.0
2019-05-07 07:00:00	SPY	ETF	290.93	291.25	290.43	290.55	503396.0
2019-05-07 08:00:00	SPY	ETF	290.55	292.5	290.4	290.79	737698.0
2019-05-07 09:00:00	SPY	ETF	290.79	290.81	289.1	289.81	14075057.0
2019-05-07 10:00:00	SPY	ETF	289.81	289.82	288.27	288.4732	17914166.0
2019-05-07 11:00:00	SPY	ETF	288.47	289.06	287.81	288.16	16971039.0
2019-05-07 12:00:00	SPY	ETF	288.15	289.11	287.7	288.41	10008812.0
2019-05-07 13:00:00	SPY	ETF	288.41	288.49	286.66	287.2325	13995989.0
2019-05-07 14:00:00	SPY	ETF	287.24	287.65	286.26	287.02	16288653.0
2019-05-07 15:00:00	SPY	ETF	287.01	288.2	285.81	288.04	30539224.0
2019-05-07 16:00:00	SPY	ETF	288.03	288.69	287.1757	288.59	15954747.0
2019-05-07 17:00:00	SPY	ETF	288.54	288.6	287.93	288.43	2383075.0
2019-05-07 18:00:00	SPY	ETF	288.49	288.55	287.93	288.27	416644.0
2019-05-07 19:00:00	SPY	ETF	288.27	288.39	287.95	288.05	108117.0
2019-05-07 04:00:00	QQQ	ETF	189.42	189.44	188.97	188.97	13474.0
2019-05-07 05:00:00	QQQ	ETF	189.0	189.03	188.69	188.91	26363.0
2019-05-07 06:00:00	QQQ	ETF	188.9	188.96	188.47	188.49	22416.0
2019-05-07 07:00:00	QQQ	ETF	188.52	188.75	188.04	188.1	168252.0
2019-05-07 08:00:00	QQQ	ETF	188.09	189.75	187.87	188.34	476197.0
2019-05-07 09:00:00	QQQ	ETF	188.35	188.67	187.26	187.61	6834981.0
2019-05-07 10:00:00	QQQ	ETF	187.59	187.64	186.26	186.52	7200065.0
2019-05-07 11:00:00	QQQ	ETF	186.51	187.07	185.95	186.42	5735527.0
2019-05-07 12:00:00	QQQ	ETF	186.4	187.12	186.09	186.44	2781846.0
2019-05-07 13:00:00	QQQ	ETF	186.44	186.5233	185.12	185.5	4855385.0
2019-05-07 14:00:00	QQQ	ETF	185.5	185.88	184.64	185.27	6433150.0
2019-05-07 15:00:00	QQQ	ETF	185.27	186.27	184.51	186.26	12688634.0
2019-05-07 16:00:00	QQQ	ETF	186.26	186.78	186.1905	186.65	2402639.0
2019-05-07 17:00:00	QQQ	ETF	186.68	186.7	186.47	186.53	61990.0
2019-05-07 18:00:00	QQQ	ETF	186.6	186.65	186.22	186.49	101052.0
2019-05-07 19:00:00	QQQ	ETF	186.42	186.46	186.16	186.24	34061.0
2019-05-07 04:00:00	IWM	ETF	159.92	159.92	159.72	159.72	11450.0
2019-05-07 05:00:00	IWM	ETF	159.8	159.9	159.8	159.87	3212.0
2019-05-07 07:00:00	IWM	ETF	159.57	159.8	159.34	159.34	49698.0
2019-05-07 08:00:00	IWM	ETF	159.4001	159.72	159.4	159.64	77744.0
2019-05-07 09:00:00	IWM	ETF	159.57	159.87	159.05	159.3	2104173.0
2019-05-07 10:00:00	IWM	ETF	159.3	159.33	158.08	158.12	3015566.0
2019-05-07 11:00:00	IWM	ETF	158.11	158.71	157.83	158.12	2598999.0
2019-05-07 12:00:00	IWM	ETF	158.1	158.89	157.79	158.34	1601956.0
2019-05-07 13:00:00	IWM	ETF	158.33	158.36	156.91	157.38	2718871.0
2019-05-07 14:00:00	IWM	ETF	157.38	157.69	156.76	157.25	2405256.0
2019-05-07 15:00:00	IWM	ETF	157.25	157.62	156.25	157.52	5702593.0
2019-05-07 16:00:00	IWM	ETF	157.53	158.1	157.4407	157.93	1300662.0
2019-05-07 17:00:00	IWM	ETF	157.95	157.99	157.81	157.83	5008.0
2019-05-07 18:00:00	IWM	ETF	157.92	157.92	157.53	157.88	12760.0
2019-05-07 19:00:00	IWM	ETF	157.8	157.84	157.64	157.67	3733.0
2019-05-07 06:00:00	DIA	ETF	263.0	263.0	262.75	262.75	300.0
2019-05-07 07:00:00	DIA	ETF	262.66	262.66	262.66	262.66	400.0
2019-05-07 08:00:00	DIA	ETF	262.42	262.87	262.42	262.6	20368.0

> showing 50 of 11,071 rows — these rows as CSV

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