PREVIEW / etf_1hour / 2018-10-29

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-10-29.parquet
  size:    321 KB
  rows:    10,648

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-10-29 04:00:00	SPY	ETF	266.32	266.57	265.83	266.11	97276.0
2018-10-29 05:00:00	SPY	ETF	266.06	267.74	265.86	267.66	81380.0
2018-10-29 06:00:00	SPY	ETF	267.62	268.84	267.5	268.63	276550.0
2018-10-29 07:00:00	SPY	ETF	268.63	269.66	268.54	268.75	522156.0
2018-10-29 08:00:00	SPY	ETF	268.75	269.61	265.8	269.33	624604.0
2018-10-29 09:00:00	SPY	ETF	269.3	269.32	268.26	269.02	13050101.0
2018-10-29 10:00:00	SPY	ETF	269.03	270.25	268.52	269.13	16324353.0
2018-10-29 11:00:00	SPY	ETF	269.15	269.42	267.41	267.42	13372137.0
2018-10-29 12:00:00	SPY	ETF	267.42	267.59	266.17	266.63	19667202.0
2018-10-29 13:00:00	SPY	ETF	266.64	267.89	266.6	266.99	10087016.0
2018-10-29 14:00:00	SPY	ETF	266.99	267.0	264.25	264.54	19978158.0
2018-10-29 15:00:00	SPY	ETF	264.55	264.6199	259.85	263.8	51135350.0
2018-10-29 16:00:00	SPY	ETF	263.79	264.1	263.26	263.52	10352695.0
2018-10-29 17:00:00	SPY	ETF	265.4031	265.4031	263.36	263.44	1585709.0
2018-10-29 18:00:00	SPY	ETF	263.46	263.9	263.18	263.47	1462985.0
2018-10-29 19:00:00	SPY	ETF	263.4	263.95	263.4	263.75	211913.0
2018-10-29 04:00:00	QQQ	ETF	168.0	168.29	167.69	167.82	53577.0
2018-10-29 05:00:00	QQQ	ETF	167.71	169.27	167.68	169.21	187507.0
2018-10-29 06:00:00	QQQ	ETF	169.14	169.5	168.97	169.39	94172.0
2018-10-29 07:00:00	QQQ	ETF	169.34	170.04	169.25	169.38	297189.0
2018-10-29 08:00:00	QQQ	ETF	169.27	169.98	167.75	169.66	1301149.0
2018-10-29 09:00:00	QQQ	ETF	169.72	169.72	168.36	168.93	7707793.0
2018-10-29 10:00:00	QQQ	ETF	168.92	169.86	168.13	168.28	9741878.0
2018-10-29 11:00:00	QQQ	ETF	168.29	168.59	166.69	166.71	9499396.0
2018-10-29 12:00:00	QQQ	ETF	166.71	166.83	165.08	165.77	12925182.0
2018-10-29 13:00:00	QQQ	ETF	165.78	166.852	165.73	166.05	6840363.0
2018-10-29 14:00:00	QQQ	ETF	166.05	166.09	163.635	163.945	12061989.0
2018-10-29 15:00:00	QQQ	ETF	163.96	164.02	160.09	163.72	35455433.0
2018-10-29 16:00:00	QQQ	ETF	163.72	163.98	163.16	163.49	4632801.0
2018-10-29 17:00:00	QQQ	ETF	163.41	163.5	163.19	163.33	167609.0
2018-10-29 18:00:00	QQQ	ETF	163.33	163.45	163.04	163.2201	138502.0
2018-10-29 19:00:00	QQQ	ETF	163.23	163.78	163.23	163.62	74080.0
2018-10-29 04:00:00	IWM	ETF	148.03	148.05	147.7	147.7	7500.0
2018-10-29 05:00:00	IWM	ETF	147.64	148.58	147.64	148.58	700.0
2018-10-29 06:00:00	IWM	ETF	148.55	148.89	148.54	148.7	12747.0
2018-10-29 07:00:00	IWM	ETF	148.81	149.25	148.81	148.9	71294.0
2018-10-29 08:00:00	IWM	ETF	148.84	149.38	147.72	149.31	145657.0
2018-10-29 09:00:00	IWM	ETF	149.33	149.81	149.13	149.72	3263470.0
2018-10-29 10:00:00	IWM	ETF	149.72	150.63	149.71	150.13	4763317.0
2018-10-29 11:00:00	IWM	ETF	150.14	150.55	149.22	149.22	2934145.0
2018-10-29 12:00:00	IWM	ETF	149.22	149.33	148.1	148.46	2869066.0
2018-10-29 13:00:00	IWM	ETF	148.48	149.59	148.45	149.08	2542434.0
2018-10-29 14:00:00	IWM	ETF	149.08	149.12	147.23	147.4399	3521946.0
2018-10-29 15:00:00	IWM	ETF	147.44	147.49	145.07	146.74	8388389.0
2018-10-29 16:00:00	IWM	ETF	146.8053	147.4549	146.52	146.73	1737311.0
2018-10-29 17:00:00	IWM	ETF	146.89	146.93	146.6	146.6	132706.0
2018-10-29 18:00:00	IWM	ETF	146.73	146.8	146.59	146.77	5900.0
2018-10-29 19:00:00	IWM	ETF	146.76	146.95	146.76	146.9	39803.0
2018-10-29 04:00:00	DIA	ETF	247.3	247.3	246.86	246.86	200.0
2018-10-29 05:00:00	DIA	ETF	247.93	248.0	247.93	248.0	200.0

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

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