PREVIEW / etf_1hour / 2019-06-11

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-06-11.parquet
  size:    327 KB
  rows:    10,768

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-11 04:00:00	SPY	ETF	289.82	290.25	289.82	290.17	14288.0
2019-06-11 05:00:00	SPY	ETF	290.14	290.6	290.11	290.57	25356.0
2019-06-11 06:00:00	SPY	ETF	290.57	290.64	290.42	290.42	18248.0
2019-06-11 07:00:00	SPY	ETF	290.37	290.56	290.26	290.46	164437.0
2019-06-11 08:00:00	SPY	ETF	290.54	291.03	289.5	290.85	1139854.0
2019-06-11 09:00:00	SPY	ETF	290.86	291.4	290.32	290.575	7490445.0
2019-06-11 10:00:00	SPY	ETF	290.56	290.81	289.38	289.73	7989448.0
2019-06-11 11:00:00	SPY	ETF	289.73	289.98	289.06	289.19	6783761.0
2019-06-11 12:00:00	SPY	ETF	289.185	289.23	288.2	288.24	6021979.0
2019-06-11 13:00:00	SPY	ETF	288.24	289.175	288.1805	289.14	5057771.0
2019-06-11 14:00:00	SPY	ETF	289.1432	289.48	288.5	288.72	5890321.0
2019-06-11 15:00:00	SPY	ETF	288.71	289.12	288.38	288.89	9174631.0
2019-06-11 16:00:00	SPY	ETF	288.9	289.432	288.77	289.02	8040902.0
2019-06-11 17:00:00	SPY	ETF	289.02	289.06	288.9	288.95	148371.0
2019-06-11 18:00:00	SPY	ETF	288.9	288.99	288.75	288.91	57314.0
2019-06-11 19:00:00	SPY	ETF	288.9	289.09	288.8	288.8	29200.0
2019-06-11 04:00:00	QQQ	ETF	184.0	184.4	184.0	184.3	40022.0
2019-06-11 05:00:00	QQQ	ETF	184.3	184.63	184.28	184.56	37633.0
2019-06-11 06:00:00	QQQ	ETF	184.58	184.63	184.46	184.5	28077.0
2019-06-11 07:00:00	QQQ	ETF	184.47	184.58	184.33	184.53	362368.0
2019-06-11 08:00:00	QQQ	ETF	184.45	185.08	183.15	184.9	306953.0
2019-06-11 09:00:00	QQQ	ETF	184.92	185.4	184.27	184.59	6254433.0
2019-06-11 10:00:00	QQQ	ETF	184.57	185.055	183.73	184.05	5034889.0
2019-06-11 11:00:00	QQQ	ETF	184.05	184.17	183.2402	183.465	3336798.0
2019-06-11 12:00:00	QQQ	ETF	183.46	183.51	182.79	182.84	3264925.0
2019-06-11 13:00:00	QQQ	ETF	182.83	183.58	182.78	183.54	2635490.0
2019-06-11 14:00:00	QQQ	ETF	183.55	183.79	183.1	183.28	3304263.0
2019-06-11 15:00:00	QQQ	ETF	183.27	183.69	183.015	183.39	4707027.0
2019-06-11 16:00:00	QQQ	ETF	183.39	184.7	183.27	183.43	2063975.0
2019-06-11 17:00:00	QQQ	ETF	183.4	183.42	183.32	183.42	7687.0
2019-06-11 18:00:00	QQQ	ETF	183.37	183.41	183.24	183.33	35878.0
2019-06-11 19:00:00	QQQ	ETF	183.33	183.48	183.27	183.27	67233.0
2019-06-11 04:00:00	IWM	ETF	152.31	152.33	152.31	152.33	3000.0
2019-06-11 05:00:00	IWM	ETF	152.34	152.57	152.34	152.57	4748.0
2019-06-11 06:00:00	IWM	ETF	152.55	152.55	152.55	152.55	100.0
2019-06-11 07:00:00	IWM	ETF	152.54	152.68	152.52	152.6	24981.0
2019-06-11 08:00:00	IWM	ETF	152.7	152.84	152.64	152.82	12737.0
2019-06-11 09:00:00	IWM	ETF	152.84	153.23	152.61	152.62	1569969.0
2019-06-11 10:00:00	IWM	ETF	152.61	152.87	151.5834	151.83	2161172.0
2019-06-11 11:00:00	IWM	ETF	151.85	152.275	151.02	151.09	1815316.0
2019-06-11 12:00:00	IWM	ETF	151.09	151.18	150.58	150.74	1864909.0
2019-06-11 13:00:00	IWM	ETF	150.74	151.57	150.65	151.56	1374361.0
2019-06-11 14:00:00	IWM	ETF	151.56	151.74	150.89	151.17	1179541.0
2019-06-11 15:00:00	IWM	ETF	151.16	151.5	150.97	151.28	1774923.0
2019-06-11 16:00:00	IWM	ETF	151.28	151.39	151.17	151.27	573024.0
2019-06-11 17:00:00	IWM	ETF	151.3	151.3	151.25	151.25	2796.0
2019-06-11 18:00:00	IWM	ETF	151.23	151.23	151.16	151.19	8582.0
2019-06-11 19:00:00	IWM	ETF	151.23	151.3	151.14	151.15	12740.0
2019-06-11 04:00:00	DIA	ETF	261.96	261.96	261.85	261.85	620.0
2019-06-11 05:00:00	DIA	ETF	262.26	262.26	262.26	262.26	900.0

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

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