PREVIEW / etf_1hour / 2015-10-28

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-10-28.parquet
  size:    246 KB
  rows:    7,833

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-28 04:00:00	SPY	ETF	206.84	207.08	206.77	207.08	15857.0
2015-10-28 05:00:00	SPY	ETF	207.08	207.25	207.02	207.25	8433.0
2015-10-28 06:00:00	SPY	ETF	207.16	207.22	207.05	207.08	24460.0
2015-10-28 07:00:00	SPY	ETF	207.08	207.16	207.04	207.04	125493.0
2015-10-28 08:00:00	SPY	ETF	207.03	207.17	206.88	206.89	286591.0
2015-10-28 09:00:00	SPY	ETF	206.9	207.36	206.66	207.35	9638238.0
2015-10-28 10:00:00	SPY	ETF	207.35	208.02	207.28	208.01	14147630.0
2015-10-28 11:00:00	SPY	ETF	208.01	208.19	207.76	208.15	10771078.0
2015-10-28 12:00:00	SPY	ETF	208.15	208.23	207.78	207.87	7057620.0
2015-10-28 13:00:00	SPY	ETF	207.88	208.47	207.82	208.362	8588231.0
2015-10-28 14:00:00	SPY	ETF	208.37	208.4	206.21	207.45	43828492.0
2015-10-28 15:00:00	SPY	ETF	207.44	208.97	207.3067	208.96	34009813.0
2015-10-28 16:00:00	SPY	ETF	208.97	209.12	208.75	208.81	6253722.0
2015-10-28 17:00:00	SPY	ETF	208.79	208.98	208.76	208.78	389152.0
2015-10-28 18:00:00	SPY	ETF	208.75	208.95	208.68	208.68	137749.0
2015-10-28 19:00:00	SPY	ETF	208.7	208.72	208.62	208.71	137981.0
2015-10-28 04:00:00	QQQ	ETF	113.28	113.4	113.23	113.4	7150.0
2015-10-28 05:00:00	QQQ	ETF	113.39	113.5	113.39	113.5	6450.0
2015-10-28 06:00:00	QQQ	ETF	113.46	113.51	113.44	113.44	6700.0
2015-10-28 07:00:00	QQQ	ETF	113.47	113.49	113.41	113.42	19771.0
2015-10-28 08:00:00	QQQ	ETF	113.39	113.48	113.22	113.22	100937.0
2015-10-28 09:00:00	QQQ	ETF	113.22	113.34	112.85	113.18	3483911.0
2015-10-28 10:00:00	QQQ	ETF	113.18	113.255	112.73	113.2495	4064153.0
2015-10-28 11:00:00	QQQ	ETF	113.24	113.46	113.18	113.45	3182764.0
2015-10-28 12:00:00	QQQ	ETF	113.4409	113.5532	113.31	113.3555	1747506.0
2015-10-28 13:00:00	QQQ	ETF	113.36	113.66	113.29	113.61	2344161.0
2015-10-28 14:00:00	QQQ	ETF	113.59	113.62	112.34	113.01	11733103.0
2015-10-28 15:00:00	QQQ	ETF	113.01	114.02	112.93	114.01	9812851.0
2015-10-28 16:00:00	QQQ	ETF	114.01	114.22	113.95	113.96	509111.0
2015-10-28 17:00:00	QQQ	ETF	113.98	114.02	113.95	113.98	8662.0
2015-10-28 18:00:00	QQQ	ETF	113.94	113.94	113.85	113.87	11648.0
2015-10-28 19:00:00	QQQ	ETF	113.86	113.92	113.85	113.9	4250.0
2015-10-28 07:00:00	IWM	ETF	114.11	114.15	114.1	114.13	9100.0
2015-10-28 08:00:00	IWM	ETF	114.1	114.25	114.1	114.14	52721.0
2015-10-28 09:00:00	IWM	ETF	114.23	115.1	113.92	115.09	3623235.0
2015-10-28 10:00:00	IWM	ETF	115.1	116.22	115.1	116.22	7365668.0
2015-10-28 11:00:00	IWM	ETF	116.22	116.41	115.96	116.27	5534356.0
2015-10-28 12:00:00	IWM	ETF	116.265	116.59	116.19	116.24	3412221.0
2015-10-28 13:00:00	IWM	ETF	116.24	116.46	116.02	116.43	2883495.0
2015-10-28 14:00:00	IWM	ETF	116.43	116.48	114.51	115.9099	12057644.0
2015-10-28 15:00:00	IWM	ETF	115.89	117.14	115.76	117.09	11059266.0
2015-10-28 16:00:00	IWM	ETF	117.09	117.16	115.4104	116.88	4384681.0
2015-10-28 17:00:00	IWM	ETF	116.87	116.99	116.85	116.99	19275.0
2015-10-28 18:00:00	IWM	ETF	117.0	117.04	116.92	116.92	2400.0
2015-10-28 19:00:00	IWM	ETF	116.92	117.0	116.92	116.92	800.0
2015-10-28 06:00:00	DIA	ETF	176.06	176.06	176.06	176.06	100.0
2015-10-28 07:00:00	DIA	ETF	176.05	176.05	176.05	176.05	300.0
2015-10-28 08:00:00	DIA	ETF	176.0	176.04	175.9	176.04	13068.0
2015-10-28 09:00:00	DIA	ETF	176.0	176.39	175.93	176.39	546529.0
2015-10-28 10:00:00	DIA	ETF	176.4	176.77	176.28	176.77	609967.0

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

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