PREVIEW / etf_1hour / 2019-10-09

all etf 1-hour files

  file:    by_date/etf_1hour/2019/2019-10-09.parquet
  size:    337 KB
  rows:    11,058

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-10-09 04:00:00	SPY	ETF	289.5	290.15	289.42	290.03	23404.0
2019-10-09 05:00:00	SPY	ETF	290.0	292.72	290.0	291.38	176048.0
2019-10-09 06:00:00	SPY	ETF	291.15	291.41	290.68	291.06	108574.0
2019-10-09 07:00:00	SPY	ETF	291.01	291.37	290.82	291.36	456039.0
2019-10-09 08:00:00	SPY	ETF	291.37	291.42	289.1	290.89	760123.0
2019-10-09 09:00:00	SPY	ETF	290.89	291.25	289.45	290.43	6635007.0
2019-10-09 10:00:00	SPY	ETF	290.41	291.06	290.3	290.75	5954892.0
2019-10-09 11:00:00	SPY	ETF	290.74	291.32	290.06	290.94	7049842.0
2019-10-09 12:00:00	SPY	ETF	290.95	291.33	290.94	291.325	2609881.0
2019-10-09 13:00:00	SPY	ETF	291.34	291.82	290.97	291.39	5150638.0
2019-10-09 14:00:00	SPY	ETF	291.4	292.04	291.13	291.935	5675587.0
2019-10-09 15:00:00	SPY	ETF	291.93	292.3	291.04	291.23	16585610.0
2019-10-09 16:00:00	SPY	ETF	291.22	291.62	290.92	291.46	7092217.0
2019-10-09 17:00:00	SPY	ETF	291.47	291.47	291.29	291.32	1663030.0
2019-10-09 18:00:00	SPY	ETF	291.38	291.67	287.6	287.95	1111269.0
2019-10-09 19:00:00	SPY	ETF	287.84	289.28	287.76	289.22	283248.0
2019-10-09 04:00:00	QQQ	ETF	185.94	186.5	185.87	186.39	12296.0
2019-10-09 05:00:00	QQQ	ETF	186.36	187.72	186.35	187.44	60711.0
2019-10-09 06:00:00	QQQ	ETF	187.36	187.45	186.95	187.3	46604.0
2019-10-09 07:00:00	QQQ	ETF	187.24	187.41	187.03	187.36	204485.0
2019-10-09 08:00:00	QQQ	ETF	187.06	187.47	185.31	186.99	288178.0
2019-10-09 09:00:00	QQQ	ETF	187.02	187.29	186.43	186.7	2238322.0
2019-10-09 10:00:00	QQQ	ETF	186.7	187.18	186.6	187.127	2075877.0
2019-10-09 11:00:00	QQQ	ETF	187.13	187.4945	186.62	187.25	3456649.0
2019-10-09 12:00:00	QQQ	ETF	187.26	187.54	187.185	187.5	1085333.0
2019-10-09 13:00:00	QQQ	ETF	187.495	187.82	187.2	187.44	1588476.0
2019-10-09 14:00:00	QQQ	ETF	187.44	187.99	187.24	187.8747	1814506.0
2019-10-09 15:00:00	QQQ	ETF	187.87	188.08	187.21	187.34	4749937.0
2019-10-09 16:00:00	QQQ	ETF	187.34	187.58	187.06	187.44	861172.0
2019-10-09 17:00:00	QQQ	ETF	187.48	187.48	187.3	187.36	17871.0
2019-10-09 18:00:00	QQQ	ETF	187.37	187.6	184.51	184.51	415421.0
2019-10-09 19:00:00	QQQ	ETF	184.76	185.78	184.53	185.78	109992.0
2019-10-09 04:00:00	IWM	ETF	147.18	147.18	147.18	147.18	3100.0
2019-10-09 05:00:00	IWM	ETF	147.13	148.0	147.13	147.62	22500.0
2019-10-09 06:00:00	IWM	ETF	147.63	147.87	147.59	147.86	15100.0
2019-10-09 07:00:00	IWM	ETF	147.72	147.92	147.63	147.88	52444.0
2019-10-09 08:00:00	IWM	ETF	147.69	147.94	146.75	147.68	26562.0
2019-10-09 09:00:00	IWM	ETF	147.78	147.78	147.03	147.23	1461689.0
2019-10-09 10:00:00	IWM	ETF	147.22	147.44	146.88	147.09	1100081.0
2019-10-09 11:00:00	IWM	ETF	147.1	147.26	146.64	146.97	1410656.0
2019-10-09 12:00:00	IWM	ETF	146.9878	147.22	146.91	147.1	485889.0
2019-10-09 13:00:00	IWM	ETF	147.11	147.35	146.77	147.1502	722229.0
2019-10-09 14:00:00	IWM	ETF	147.11	147.42	146.96	147.41	894816.0
2019-10-09 15:00:00	IWM	ETF	147.4	147.6874	146.9	147.12	2884567.0
2019-10-09 16:00:00	IWM	ETF	147.11	147.4	146.93	147.28	464703.0
2019-10-09 17:00:00	IWM	ETF	147.13	147.39	147.13	147.29	3742.0
2019-10-09 18:00:00	IWM	ETF	147.29	147.37	145.38	145.47	68735.0
2019-10-09 19:00:00	IWM	ETF	145.48	145.85	145.43	145.85	25007.0
2019-10-09 05:00:00	DIA	ETF	263.7	264.12	263.7	264.12	3300.0
2019-10-09 06:00:00	DIA	ETF	263.8	263.82	263.8	263.82	2000.0

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

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