PREVIEW / etf_1hour / 2018-11-08

all etf 1-hour files

  file:    by_date/etf_1hour/2018/2018-11-08.parquet
  size:    322 KB
  rows:    10,538

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-08 04:00:00	SPY	ETF	280.99	281.0	280.22	280.25	54412.0
2018-11-08 05:00:00	SPY	ETF	280.21	280.27	279.9	279.97	120908.0
2018-11-08 06:00:00	SPY	ETF	279.93	280.28	279.86	280.15	59110.0
2018-11-08 07:00:00	SPY	ETF	280.2	280.55	280.15	280.5	308979.0
2018-11-08 08:00:00	SPY	ETF	280.3001	280.6	280.12	280.33	550199.0
2018-11-08 09:00:00	SPY	ETF	280.34	280.9898	280.03	280.9	8372727.0
2018-11-08 10:00:00	SPY	ETF	280.9	281.0	280.14	280.72	8624628.0
2018-11-08 11:00:00	SPY	ETF	280.72	281.14	280.41	280.94	4580718.0
2018-11-08 12:00:00	SPY	ETF	280.94	281.22	280.6116	280.63	3856764.0
2018-11-08 13:00:00	SPY	ETF	280.6399	280.76	280.09	280.4975	4893710.0
2018-11-08 14:00:00	SPY	ETF	280.5	280.92	279.22	279.84	11788633.0
2018-11-08 15:00:00	SPY	ETF	279.84	280.44	279.34	280.44	13583301.0
2018-11-08 16:00:00	SPY	ETF	280.42	280.77	280.1941	280.26	6195568.0
2018-11-08 17:00:00	SPY	ETF	280.5	280.5	280.02	280.04	710633.0
2018-11-08 18:00:00	SPY	ETF	280.06	280.29	279.96	280.29	136729.0
2018-11-08 19:00:00	SPY	ETF	280.27	280.62	280.27	280.39	61703.0
2018-11-08 20:00:00	SPY	ETF	280.5	280.5	280.4137	280.4137	42000.0
2018-11-08 04:00:00	QQQ	ETF	175.66	175.66	174.91	174.92	34998.0
2018-11-08 05:00:00	QQQ	ETF	174.8	174.81	174.36	174.49	79099.0
2018-11-08 06:00:00	QQQ	ETF	174.47	174.79	174.39	174.73	54762.0
2018-11-08 07:00:00	QQQ	ETF	174.72	175.05	174.68	174.95	173058.0
2018-11-08 08:00:00	QQQ	ETF	174.9201	175.02	174.63	174.77	351071.0
2018-11-08 09:00:00	QQQ	ETF	174.72	175.21	174.11	175.13	5356069.0
2018-11-08 10:00:00	QQQ	ETF	175.13	175.302	174.41	174.81	5188047.0
2018-11-08 11:00:00	QQQ	ETF	174.82	175.08	174.35	174.81	2813221.0
2018-11-08 12:00:00	QQQ	ETF	174.84	174.945	174.48	174.5101	2078469.0
2018-11-08 13:00:00	QQQ	ETF	174.51	174.65	173.96	174.52	2899141.0
2018-11-08 14:00:00	QQQ	ETF	174.5191	174.99	173.68	174.05	5436896.0
2018-11-08 15:00:00	QQQ	ETF	174.06	174.49	173.63	174.49	7748544.0
2018-11-08 16:00:00	QQQ	ETF	174.48	174.69	174.17	174.18	1243206.0
2018-11-08 17:00:00	QQQ	ETF	174.04	174.17	173.97	174.0	24632.0
2018-11-08 18:00:00	QQQ	ETF	173.96	174.24	173.9	174.24	36916.0
2018-11-08 19:00:00	QQQ	ETF	174.2	174.43	174.14	174.18	50663.0
2018-11-08 05:00:00	IWM	ETF	156.74	156.82	156.74	156.82	500.0
2018-11-08 06:00:00	IWM	ETF	156.79	156.8	156.56	156.68	2000.0
2018-11-08 07:00:00	IWM	ETF	156.7	156.84	156.7	156.84	65557.0
2018-11-08 08:00:00	IWM	ETF	157.41	157.41	156.61	156.67	38474.0
2018-11-08 09:00:00	IWM	ETF	156.61	157.27	156.52	157.26	1599311.0
2018-11-08 10:00:00	IWM	ETF	157.27	157.38	156.5735	157.3199	1630351.0
2018-11-08 11:00:00	IWM	ETF	157.32	157.65	157.0	157.15	1303218.0
2018-11-08 12:00:00	IWM	ETF	157.17	157.9	157.05	157.35	1794918.0
2018-11-08 13:00:00	IWM	ETF	157.35	157.47	156.89	157.04	1254834.0
2018-11-08 14:00:00	IWM	ETF	157.05	157.37	156.34	156.64	1765560.0
2018-11-08 15:00:00	IWM	ETF	156.65	156.99	156.35	156.99	3134989.0
2018-11-08 16:00:00	IWM	ETF	156.99	157.24	156.8888	157.09	777586.0
2018-11-08 17:00:00	IWM	ETF	157.0	157.0	156.9	156.98	1640.0
2018-11-08 18:00:00	IWM	ETF	156.91	157.0	156.81	157.0	10018.0
2018-11-08 19:00:00	IWM	ETF	157.07	157.21	157.04	157.04	12100.0
2018-11-08 06:00:00	DIA	ETF	261.48	261.48	261.02	261.02	452.0
2018-11-08 07:00:00	DIA	ETF	261.48	261.7	261.2	261.7	1818.0

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

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