PREVIEW / etf_1hour / 2015-11-10

all etf 1-hour files

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

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-11-10 04:00:00	SPY	ETF	208.25	208.33	207.57	207.61	26733.0
2015-11-10 05:00:00	SPY	ETF	207.61	207.68	207.43	207.43	10194.0
2015-11-10 06:00:00	SPY	ETF	207.45	207.9	207.45	207.85	17318.0
2015-11-10 07:00:00	SPY	ETF	207.81	207.81	207.28	207.48	112461.0
2015-11-10 08:00:00	SPY	ETF	207.77	208.17	207.42	207.59	575412.0
2015-11-10 09:00:00	SPY	ETF	207.59	208.2	207.43	208.06	10274933.0
2015-11-10 10:00:00	SPY	ETF	208.06	208.13	207.19	207.76	11216999.0
2015-11-10 11:00:00	SPY	ETF	207.76	207.95	207.41	207.81	8418443.0
2015-11-10 12:00:00	SPY	ETF	207.81	208.14	207.59	207.77	5799678.0
2015-11-10 13:00:00	SPY	ETF	207.77	208.23	207.57	208.125	5699918.0
2015-11-10 14:00:00	SPY	ETF	208.125	208.6	207.9	208.34	8200476.0
2015-11-10 15:00:00	SPY	ETF	208.34	208.51	208.1	208.51	16346205.0
2015-11-10 16:00:00	SPY	ETF	208.5	208.63	208.2857	208.43	6256793.0
2015-11-10 17:00:00	SPY	ETF	208.45	208.5	208.36	208.41	66511.0
2015-11-10 18:00:00	SPY	ETF	208.38	208.56	208.27	208.31	54112.0
2015-11-10 19:00:00	SPY	ETF	208.3	208.45	208.3	208.4	48812.0
2015-11-10 04:00:00	QQQ	ETF	113.3	113.31	113.25	113.3	16350.0
2015-11-10 06:00:00	QQQ	ETF	113.18	113.45	113.18	113.45	2310.0
2015-11-10 07:00:00	QQQ	ETF	113.43	113.43	112.93	112.96	45995.0
2015-11-10 08:00:00	QQQ	ETF	113.37	113.37	113.04	113.11	153076.0
2015-11-10 09:00:00	QQQ	ETF	113.12	113.19	112.68	113.08	5455961.0
2015-11-10 10:00:00	QQQ	ETF	113.08	113.18	112.63	113.04	3604794.0
2015-11-10 11:00:00	QQQ	ETF	113.05	113.21	112.9	113.065	2757934.0
2015-11-10 12:00:00	QQQ	ETF	113.055	113.14	112.89	112.95	1631491.0
2015-11-10 13:00:00	QQQ	ETF	112.94	113.18	112.78	113.1005	2224896.0
2015-11-10 14:00:00	QQQ	ETF	113.1	113.39	112.925	113.28	2628296.0
2015-11-10 15:00:00	QQQ	ETF	113.27	113.33	113.0	113.28	5079624.0
2015-11-10 16:00:00	QQQ	ETF	113.28	113.39	113.23	113.33	436895.0
2015-11-10 17:00:00	QQQ	ETF	113.31	113.34	113.25	113.34	34945.0
2015-11-10 18:00:00	QQQ	ETF	113.32	113.33	113.25	113.29	16989.0
2015-11-10 19:00:00	QQQ	ETF	113.3	113.34	113.29	113.29	4600.0
2015-11-10 04:00:00	IWM	ETF	117.57	117.57	117.35	117.35	200.0
2015-11-10 05:00:00	IWM	ETF	117.32	117.32	117.32	117.32	100.0
2015-11-10 06:00:00	IWM	ETF	117.32	117.43	117.32	117.43	200.0
2015-11-10 07:00:00	IWM	ETF	117.22	117.22	117.2	117.2	600.0
2015-11-10 08:00:00	IWM	ETF	117.33	117.52	117.3	117.41	177622.0
2015-11-10 09:00:00	IWM	ETF	117.45	117.89	117.31	117.7265	1731648.0
2015-11-10 10:00:00	IWM	ETF	117.73	117.79	116.96	117.49	3715583.0
2015-11-10 11:00:00	IWM	ETF	117.49	117.645	117.05	117.4	2522904.0
2015-11-10 12:00:00	IWM	ETF	117.39	117.8206	117.36	117.575	1968436.0
2015-11-10 13:00:00	IWM	ETF	117.56	117.92	117.41	117.81	1596983.0
2015-11-10 14:00:00	IWM	ETF	117.8	118.15	117.63	117.93	1853307.0
2015-11-10 15:00:00	IWM	ETF	117.93	118.16	117.9	118.12	4903445.0
2015-11-10 16:00:00	IWM	ETF	118.12	118.35	118.12	118.25	1934925.0
2015-11-10 17:00:00	IWM	ETF	118.2	118.32	118.2	118.21	151137.0
2015-11-10 18:00:00	IWM	ETF	118.17	118.17	118.17	118.17	167.0
2015-11-10 19:00:00	IWM	ETF	118.2	118.22	118.2	118.22	1600.0
2015-11-10 05:00:00	DIA	ETF	176.9	176.9	176.85	176.85	3000.0
2015-11-10 07:00:00	DIA	ETF	177.09	177.09	177.09	177.09	100.0
2015-11-10 08:00:00	DIA	ETF	177.0	177.17	177.0	177.17	500.0

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

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