PREVIEW / etf_1hour / 2018-11-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-07.parquet
  size:    331 KB
  rows:    10,720

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-11-07 04:00:00	SPY	ETF	277.29	278.29	277.29	278.25	98113.0
2018-11-07 05:00:00	SPY	ETF	278.2	278.34	277.9	278.06	67855.0
2018-11-07 06:00:00	SPY	ETF	278.03	278.08	277.51	277.6	239054.0
2018-11-07 07:00:00	SPY	ETF	277.64	278.04	277.21	277.24	535511.0
2018-11-07 08:00:00	SPY	ETF	277.94	278.0101	277.06	277.24	774527.0
2018-11-07 09:00:00	SPY	ETF	277.26	278.4	277.01	277.41	11943813.0
2018-11-07 10:00:00	SPY	ETF	277.4001	278.92	277.08	278.56	15578498.0
2018-11-07 11:00:00	SPY	ETF	278.56	279.43	278.36	279.38	9384015.0
2018-11-07 12:00:00	SPY	ETF	279.39	279.63	279.09	279.53	6606714.0
2018-11-07 13:00:00	SPY	ETF	279.54	279.76	279.0	279.24	6154922.0
2018-11-07 14:00:00	SPY	ETF	279.24	280.41	279.21	280.07	10568836.0
2018-11-07 15:00:00	SPY	ETF	280.07	281.1	280.01	280.92	25420878.0
2018-11-07 16:00:00	SPY	ETF	280.92	281.33	280.7378	281.2599	13160279.0
2018-11-07 17:00:00	SPY	ETF	281.27	281.28	281.01	281.13	198534.0
2018-11-07 18:00:00	SPY	ETF	281.17	281.32	280.97	281.02	195640.0
2018-11-07 19:00:00	SPY	ETF	281.03	281.23	280.98	281.18	51594.0
2018-11-07 04:00:00	QQQ	ETF	172.5	173.26	172.5	173.22	70552.0
2018-11-07 05:00:00	QQQ	ETF	173.22	173.22	172.76	172.85	36442.0
2018-11-07 06:00:00	QQQ	ETF	172.82	172.92	172.48	172.55	69530.0
2018-11-07 07:00:00	QQQ	ETF	172.57	172.95	172.23	172.25	391697.0
2018-11-07 08:00:00	QQQ	ETF	172.58	172.9499	171.22	172.12	510453.0
2018-11-07 09:00:00	QQQ	ETF	172.1	172.995	171.73	172.5	8035239.0
2018-11-07 10:00:00	QQQ	ETF	172.5	174.37	172.4	173.99	9445573.0
2018-11-07 11:00:00	QQQ	ETF	173.99	174.786	173.7	174.73	5083542.0
2018-11-07 12:00:00	QQQ	ETF	174.72	174.76	174.1959	174.54	3222816.0
2018-11-07 13:00:00	QQQ	ETF	174.55	174.77	174.05	174.33	3227764.0
2018-11-07 14:00:00	QQQ	ETF	174.33	175.03	174.33	174.64	4520946.0
2018-11-07 15:00:00	QQQ	ETF	174.65	175.54	174.58	175.47	9093582.0
2018-11-07 16:00:00	QQQ	ETF	175.47	175.79	175.37	175.69	2950327.0
2018-11-07 17:00:00	QQQ	ETF	175.66	175.69	175.56	175.6	54401.0
2018-11-07 18:00:00	QQQ	ETF	175.57	175.71	175.45	175.52	62280.0
2018-11-07 19:00:00	QQQ	ETF	175.56	175.66	175.45	175.66	24027.0
2018-11-07 04:00:00	IWM	ETF	155.34	155.62	155.25	155.62	4550.0
2018-11-07 05:00:00	IWM	ETF	155.78	155.82	155.54	155.55	13687.0
2018-11-07 06:00:00	IWM	ETF	155.61	155.61	155.41	155.41	12918.0
2018-11-07 07:00:00	IWM	ETF	155.41	155.61	155.2	155.26	142169.0
2018-11-07 08:00:00	IWM	ETF	155.4199	155.61	155.17	155.21	92564.0
2018-11-07 09:00:00	IWM	ETF	155.13	155.95	154.8	155.03	2474292.0
2018-11-07 10:00:00	IWM	ETF	155.04	155.99	154.8	155.63	2487493.0
2018-11-07 11:00:00	IWM	ETF	155.63	156.37	155.41	156.32	2839842.0
2018-11-07 12:00:00	IWM	ETF	156.32	156.66	156.08	156.5301	1895027.0
2018-11-07 13:00:00	IWM	ETF	156.54	156.73	156.01	156.12	1532014.0
2018-11-07 14:00:00	IWM	ETF	156.115	156.84	156.075	156.81	2046921.0
2018-11-07 15:00:00	IWM	ETF	156.81	157.38	156.77	157.31	4878210.0
2018-11-07 16:00:00	IWM	ETF	157.2732	157.51	157.2732	157.41	2121453.0
2018-11-07 17:00:00	IWM	ETF	157.32	157.47	157.32	157.33	3073.0
2018-11-07 18:00:00	IWM	ETF	157.34	157.42	157.3	157.3	10386.0
2018-11-07 19:00:00	IWM	ETF	157.31	157.41	157.28	157.34	10600.0
2018-11-07 04:00:00	DIA	ETF	258.01	258.32	258.01	258.32	9380.0
2018-11-07 05:00:00	DIA	ETF	258.66	258.66	258.56	258.56	1200.0

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

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