PREVIEW / etf_1hour / 2015-10-30

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-30.parquet
  size:    239 KB
  rows:    7,627

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
2015-10-30 04:00:00	SPY	ETF	209.52	209.74	209.51	209.64	54419.0
2015-10-30 05:00:00	SPY	ETF	209.59	209.62	209.34	209.36	10613.0
2015-10-30 06:00:00	SPY	ETF	209.2	209.23	209.02	209.2	75567.0
2015-10-30 07:00:00	SPY	ETF	209.2	209.25	209.07	209.18	323957.0
2015-10-30 08:00:00	SPY	ETF	209.15	209.94	209.05	209.38	508528.0
2015-10-30 09:00:00	SPY	ETF	209.36	209.37	208.56	208.6602	10834427.0
2015-10-30 10:00:00	SPY	ETF	208.66	208.89	208.39	208.73	14056200.0
2015-10-30 11:00:00	SPY	ETF	208.73	208.86	208.47	208.739	7124434.0
2015-10-30 12:00:00	SPY	ETF	208.735	209.32	208.5938	209.2199	11824496.0
2015-10-30 13:00:00	SPY	ETF	209.215	209.44	209.09	209.245	11634155.0
2015-10-30 14:00:00	SPY	ETF	209.245	209.35	208.37	208.41	16190967.0
2015-10-30 15:00:00	SPY	ETF	208.42	208.81	207.83	207.85	37930817.0
2015-10-30 16:00:00	SPY	ETF	207.86	208.6321	207.61	208.02	15356319.0
2015-10-30 17:00:00	SPY	ETF	208.0	208.02	207.94	208.0	216520.0
2015-10-30 18:00:00	SPY	ETF	208.0	208.09	208.0	208.06	31461.0
2015-10-30 19:00:00	SPY	ETF	208.04	208.06	207.98	208.03	18860.0
2015-10-30 04:00:00	QQQ	ETF	114.22	114.3	114.22	114.27	1410.0
2015-10-30 05:00:00	QQQ	ETF	114.13	114.13	114.13	114.13	100.0
2015-10-30 06:00:00	QQQ	ETF	114.01	114.01	113.84	113.84	2300.0
2015-10-30 07:00:00	QQQ	ETF	113.95	113.98	113.9	113.97	4825.0
2015-10-30 08:00:00	QQQ	ETF	113.97	114.1	113.97	114.06	80708.0
2015-10-30 09:00:00	QQQ	ETF	114.04	114.08	113.81	113.95	2866428.0
2015-10-30 10:00:00	QQQ	ETF	113.95	114.06	113.75	113.86	2803623.0
2015-10-30 11:00:00	QQQ	ETF	113.87	113.89	113.66	113.78	2317459.0
2015-10-30 12:00:00	QQQ	ETF	113.78	114.06	113.63	113.98	1939354.0
2015-10-30 13:00:00	QQQ	ETF	113.98	114.08	113.93	113.99	1650565.0
2015-10-30 14:00:00	QQQ	ETF	113.99	114.04	113.49	113.5242	2261643.0
2015-10-30 15:00:00	QQQ	ETF	113.51	113.79	113.31	113.33	6332915.0
2015-10-30 16:00:00	QQQ	ETF	113.32	113.7344	113.21	113.41	2384269.0
2015-10-30 17:00:00	QQQ	ETF	113.41	113.47	113.33	113.42	879896.0
2015-10-30 18:00:00	QQQ	ETF	113.4	113.42	113.35	113.4	6055.0
2015-10-30 19:00:00	QQQ	ETF	113.4	113.45	113.38	113.42	2500.0
2015-10-30 07:00:00	IWM	ETF	115.79	115.79	115.78	115.78	1100.0
2015-10-30 08:00:00	IWM	ETF	115.79	115.96	115.78	115.92	117009.0
2015-10-30 09:00:00	IWM	ETF	115.89	115.97	115.41	115.63	3063716.0
2015-10-30 10:00:00	IWM	ETF	115.62	115.94	115.36	115.69	3011376.0
2015-10-30 11:00:00	IWM	ETF	115.7	115.85	115.45	115.57	1976334.0
2015-10-30 12:00:00	IWM	ETF	115.57	115.94	115.4589	115.81	2094583.0
2015-10-30 13:00:00	IWM	ETF	115.81	116.03	115.79	115.9	2046198.0
2015-10-30 14:00:00	IWM	ETF	115.89	115.96	115.2	115.24	2458195.0
2015-10-30 15:00:00	IWM	ETF	115.23	115.54	115.08	115.35	5841583.0
2015-10-30 16:00:00	IWM	ETF	115.35	115.538	115.18	115.38	3034357.0
2015-10-30 17:00:00	IWM	ETF	115.36	115.41	115.33	115.33	3009.0
2015-10-30 18:00:00	IWM	ETF	115.34	115.4	115.34	115.38	4200.0
2015-10-30 08:00:00	DIA	ETF	177.8	177.85	177.8	177.85	1700.0
2015-10-30 09:00:00	DIA	ETF	177.74	177.74	177.15	177.25	677248.0
2015-10-30 10:00:00	DIA	ETF	177.2801	177.45	177.1201	177.38	604805.0
2015-10-30 11:00:00	DIA	ETF	177.4	177.43	177.1199	177.36	587159.0
2015-10-30 12:00:00	DIA	ETF	177.35	177.79	177.27	177.74	266339.0
2015-10-30 13:00:00	DIA	ETF	177.75	177.83	177.6	177.72	261153.0

> showing 50 of 7,627 rows — these rows as CSV

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