PREVIEW / etf_1hour / 2018-12-07

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-12-07.parquet
  size:    327 KB
  rows:    10,718

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-12-07 04:00:00	SPY	ETF	268.34	268.74	267.93	268.74	21138.0
2018-12-07 05:00:00	SPY	ETF	268.63	268.77	268.32	268.41	5170.0
2018-12-07 06:00:00	SPY	ETF	268.29	268.44	267.85	267.85	104335.0
2018-12-07 07:00:00	SPY	ETF	267.87	268.18	267.72	268.1	534448.0
2018-12-07 08:00:00	SPY	ETF	267.9401	270.1	267.45	269.29	1642779.0
2018-12-07 09:00:00	SPY	ETF	269.32	271.22	269.25	270.36	11000443.0
2018-12-07 10:00:00	SPY	ETF	270.37	270.71	267.02	268.24	21068760.0
2018-12-07 11:00:00	SPY	ETF	268.245	268.51	265.35	265.36	19265236.0
2018-12-07 12:00:00	SPY	ETF	265.37	266.55	264.56	266.27	15072344.0
2018-12-07 13:00:00	SPY	ETF	266.26	266.91	264.37	264.4	13560463.0
2018-12-07 14:00:00	SPY	ETF	264.4	265.0762	262.96	263.16	19391657.0
2018-12-07 15:00:00	SPY	ETF	263.16	265.46	262.63	263.65	40321123.0
2018-12-07 16:00:00	SPY	ETF	263.63	264.05	263.45	264.04	16750997.0
2018-12-07 17:00:00	SPY	ETF	263.77	263.94	263.57	263.81	99115.0
2018-12-07 18:00:00	SPY	ETF	263.77	263.79	263.07	263.5	91712.0
2018-12-07 19:00:00	SPY	ETF	263.5	263.5499	263.31	263.31	25921.0
2018-12-07 04:00:00	QQQ	ETF	166.52	166.59	165.47	166.05	84935.0
2018-12-07 05:00:00	QQQ	ETF	165.91	166.02	165.62	165.77	27680.0
2018-12-07 06:00:00	QQQ	ETF	165.75	165.8	165.29	165.29	44606.0
2018-12-07 07:00:00	QQQ	ETF	165.32	165.73	165.26	165.7	228419.0
2018-12-07 08:00:00	QQQ	ETF	165.7	166.96	165.3	166.16	878811.0
2018-12-07 09:00:00	QQQ	ETF	166.13	167.12	165.89	166.44	6080220.0
2018-12-07 10:00:00	QQQ	ETF	166.45	166.81	164.12	164.74	9411202.0
2018-12-07 11:00:00	QQQ	ETF	164.73	164.89	162.83	162.85	9238824.0
2018-12-07 12:00:00	QQQ	ETF	162.84	163.63	162.27	163.355	6673631.0
2018-12-07 13:00:00	QQQ	ETF	163.35	163.8	162.24	162.29	5173379.0
2018-12-07 14:00:00	QQQ	ETF	162.3	162.81	161.18	161.33	10011604.0
2018-12-07 15:00:00	QQQ	ETF	161.32	162.6	160.86	161.34	18952575.0
2018-12-07 16:00:00	QQQ	ETF	161.35	161.72	161.21	161.72	2606976.0
2018-12-07 17:00:00	QQQ	ETF	161.77	161.77	161.38	161.45	604632.0
2018-12-07 18:00:00	QQQ	ETF	161.41	161.54	161.3	161.38	9605.0
2018-12-07 19:00:00	QQQ	ETF	161.3	161.35	161.12	161.2	11473.0
2018-12-07 04:00:00	IWM	ETF	146.22	146.5	146.22	146.5	600.0
2018-12-07 06:00:00	IWM	ETF	146.5	146.5	146.29	146.29	3200.0
2018-12-07 07:00:00	IWM	ETF	146.25	146.32	146.25	146.31	5700.0
2018-12-07 08:00:00	IWM	ETF	146.3201	147.4	146.3201	146.99	60729.0
2018-12-07 09:00:00	IWM	ETF	147.03	148.26	147.0	147.81	1696183.0
2018-12-07 10:00:00	IWM	ETF	147.83	148.09	146.47	147.47	2447021.0
2018-12-07 11:00:00	IWM	ETF	147.48	147.64	145.5	145.52	3153275.0
2018-12-07 12:00:00	IWM	ETF	145.5174	146.03	144.89	145.89	2487882.0
2018-12-07 13:00:00	IWM	ETF	145.88	146.2	144.32	144.32	2325735.0
2018-12-07 14:00:00	IWM	ETF	144.31	144.76	143.49	143.62	4287491.0
2018-12-07 15:00:00	IWM	ETF	143.6	144.68	143.27	144.08	6215135.0
2018-12-07 16:00:00	IWM	ETF	144.1	146.2668	143.89	144.38	1847224.0
2018-12-07 17:00:00	IWM	ETF	144.02	144.25	144.02	144.25	353231.0
2018-12-07 18:00:00	IWM	ETF	144.25	144.25	144.05	144.05	2345.0
2018-12-07 19:00:00	IWM	ETF	143.94	143.97	143.94	143.95	1000.0
2018-12-07 04:00:00	DIA	ETF	248.35	248.49	248.34	248.49	2200.0
2018-12-07 06:00:00	DIA	ETF	248.26	248.26	248.12	248.22	5100.0
2018-12-07 07:00:00	DIA	ETF	247.98	248.24	247.9	248.1	5950.0

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

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