PREVIEW / etf_1hour / 2018-03-12

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-03-12.parquet
  size:    300 KB
  rows:    9,856

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-03-12 04:00:00	SPY	ETF	280.08	280.1	279.31	279.59	88931.0
2018-03-12 05:00:00	SPY	ETF	279.68	279.72	279.38	279.54	87457.0
2018-03-12 06:00:00	SPY	ETF	279.52	279.78	279.44	279.56	24337.0
2018-03-12 07:00:00	SPY	ETF	279.57	279.64	279.17	279.31	105630.0
2018-03-12 08:00:00	SPY	ETF	279.6	280.12	278.99	279.06	463936.0
2018-03-12 09:00:00	SPY	ETF	279.02	279.91	278.96	279.56	6573538.0
2018-03-12 10:00:00	SPY	ETF	279.565	279.61	278.551	278.57	9101950.0
2018-03-12 11:00:00	SPY	ETF	278.57	279.15	278.0801	278.7	7244204.0
2018-03-12 12:00:00	SPY	ETF	278.7	279.05	278.4669	278.66	6247215.0
2018-03-12 13:00:00	SPY	ETF	278.66	279.13	278.651	278.69	7666093.0
2018-03-12 14:00:00	SPY	ETF	278.69	278.96	278.13	278.31	6316947.0
2018-03-12 15:00:00	SPY	ETF	278.316	279.39	278.26	278.5	18167199.0
2018-03-12 16:00:00	SPY	ETF	278.52	278.68	278.1888	278.48	8034172.0
2018-03-12 17:00:00	SPY	ETF	278.47	278.52	278.23	278.37	1095462.0
2018-03-12 18:00:00	SPY	ETF	278.38	278.6	278.35	278.48	77306.0
2018-03-12 19:00:00	SPY	ETF	278.54	278.54	278.34	278.47	63748.0
2018-03-12 04:00:00	QQQ	ETF	174.18	174.18	173.85	174.0	54729.0
2018-03-12 05:00:00	QQQ	ETF	174.06	174.15	173.94	174.0	29470.0
2018-03-12 06:00:00	QQQ	ETF	174.0	174.08	173.93	174.02	10301.0
2018-03-12 07:00:00	QQQ	ETF	174.04	174.04	173.8	173.9	145208.0
2018-03-12 08:00:00	QQQ	ETF	173.9	174.29	173.6	173.64	114226.0
2018-03-12 09:00:00	QQQ	ETF	173.62	174.11	173.44	173.98	3004667.0
2018-03-12 10:00:00	QQQ	ETF	173.989	174.23	173.68	173.6924	3643403.0
2018-03-12 11:00:00	QQQ	ETF	173.7	174.09	173.28	174.05	3914381.0
2018-03-12 12:00:00	QQQ	ETF	174.05	174.35	174.001	174.17	2560311.0
2018-03-12 13:00:00	QQQ	ETF	174.17	174.48	174.01	174.01	2570871.0
2018-03-12 14:00:00	QQQ	ETF	174.0101	174.2	173.6	173.895	3982730.0
2018-03-12 15:00:00	QQQ	ETF	173.89	174.43	173.84	173.87	6723126.0
2018-03-12 16:00:00	QQQ	ETF	173.86	174.4615	173.82	173.92	2343186.0
2018-03-12 17:00:00	QQQ	ETF	173.91	174.08	173.81	173.95	132979.0
2018-03-12 18:00:00	QQQ	ETF	173.92	174.08	173.85	173.92	38187.0
2018-03-12 19:00:00	QQQ	ETF	173.92	173.92	173.71	173.77	68305.0
2018-03-12 04:00:00	IWM	ETF	159.68	159.68	159.15	159.15	1157.0
2018-03-12 05:00:00	IWM	ETF	159.12	159.13	159.08	159.08	7100.0
2018-03-12 06:00:00	IWM	ETF	159.09	159.09	158.94	158.94	1234.0
2018-03-12 07:00:00	IWM	ETF	159.13	159.2	159.0	159.0	7713.0
2018-03-12 08:00:00	IWM	ETF	159.07	159.25	158.99	159.2	70690.0
2018-03-12 09:00:00	IWM	ETF	159.18	159.53	158.92	159.2	1084994.0
2018-03-12 10:00:00	IWM	ETF	159.21	159.65	158.83	158.97	1654437.0
2018-03-12 11:00:00	IWM	ETF	158.97	159.135	158.49	159.03	1944676.0
2018-03-12 12:00:00	IWM	ETF	159.03	159.46	159.0	159.275	1227204.0
2018-03-12 13:00:00	IWM	ETF	159.28	159.63	159.2	159.22	997192.0
2018-03-12 14:00:00	IWM	ETF	159.24	159.3625	158.9101	159.0845	990512.0
2018-03-12 15:00:00	IWM	ETF	159.09	159.5	159.07	159.21	2804054.0
2018-03-12 16:00:00	IWM	ETF	159.17	159.37	159.12	159.3308	1049374.0
2018-03-12 17:00:00	IWM	ETF	159.2	159.35	159.2	159.35	267024.0
2018-03-12 18:00:00	IWM	ETF	159.28	159.38	159.2	159.37	18415.0
2018-03-12 19:00:00	IWM	ETF	159.33	159.33	159.2	159.31	5962.0
2018-03-12 04:00:00	DIA	ETF	254.17	254.98	254.17	254.78	2994.0
2018-03-12 06:00:00	DIA	ETF	254.4	254.4	254.4	254.4	300.0

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

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