PREVIEW / etf_1hour / 2011-09-20

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-09-20.parquet
  size:    179 KB
  rows:    5,473

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
2011-09-20 04:00:00	SPY	ETF	120.14	120.6	120.14	120.55	10112.0
2011-09-20 05:00:00	SPY	ETF	120.53	121.52	120.45	121.52	29200.0
2011-09-20 06:00:00	SPY	ETF	121.52	121.61	121.05	121.16	142500.0
2011-09-20 07:00:00	SPY	ETF	121.13	121.39	121.08	121.2	990074.0
2011-09-20 08:00:00	SPY	ETF	121.21	121.41	120.79	121.03	4314190.0
2011-09-20 09:00:00	SPY	ETF	121.04	121.15	120.01	120.37	22094892.0
2011-09-20 10:00:00	SPY	ETF	120.41	121.64	120.18	121.6	35344234.0
2011-09-20 11:00:00	SPY	ETF	121.61	121.99	121.56	121.87	29822345.0
2011-09-20 12:00:00	SPY	ETF	121.87	121.88	121.32	121.69	16541487.0
2011-09-20 13:00:00	SPY	ETF	121.68	121.93	121.45	121.551	15348217.0
2011-09-20 14:00:00	SPY	ETF	121.58	121.87	121.14	121.23	25141023.0
2011-09-20 15:00:00	SPY	ETF	121.24	121.375	120.1	120.17	53710013.0
2011-09-20 16:00:00	SPY	ETF	120.19	121.9822	119.95	120.41	12157574.0
2011-09-20 17:00:00	SPY	ETF	120.44	120.5	120.27	120.29	272149.0
2011-09-20 18:00:00	SPY	ETF	120.3	120.45	119.98	120.07	507612.0
2011-09-20 19:00:00	SPY	ETF	120.06	120.32	120.0	120.31	108993.0
2011-09-20 04:00:00	QQQ	ETF	56.8	56.85	56.74	56.77	3620.0
2011-09-20 05:00:00	QQQ	ETF	56.85	57.26	56.81	57.26	5150.0
2011-09-20 06:00:00	QQQ	ETF	57.26	57.27	57.05	57.05	15630.0
2011-09-20 07:00:00	QQQ	ETF	57.06	57.15	57.0	57.1	176203.0
2011-09-20 08:00:00	QQQ	ETF	57.1	57.17	56.96	57.04	1141607.0
2011-09-20 09:00:00	QQQ	ETF	57.06	57.09	56.51	56.69	7546425.0
2011-09-20 10:00:00	QQQ	ETF	56.69	57.2	56.61	57.17	9845205.0
2011-09-20 11:00:00	QQQ	ETF	57.17	57.35	57.09	57.31	7859273.0
2011-09-20 12:00:00	QQQ	ETF	57.31	57.31	57.03	57.16	4348214.0
2011-09-20 13:00:00	QQQ	ETF	57.16	57.22	56.99	57.081	3894914.0
2011-09-20 14:00:00	QQQ	ETF	57.08	57.24	56.75	56.81	5941760.0
2011-09-20 15:00:00	QQQ	ETF	56.82	56.88	56.23	56.33	13367436.0
2011-09-20 16:00:00	QQQ	ETF	56.34	56.55	56.33	56.55	1803166.0
2011-09-20 17:00:00	QQQ	ETF	56.55	56.58	56.48	56.52	200344.0
2011-09-20 18:00:00	QQQ	ETF	56.53	56.57	56.4	56.45	66256.0
2011-09-20 19:00:00	QQQ	ETF	56.44	56.54	56.41	56.52	36630.0
2011-09-20 05:00:00	IWM	ETF	70.79	70.96	70.79	70.96	300.0
2011-09-20 07:00:00	IWM	ETF	70.84	70.9	70.67	70.8	36895.0
2011-09-20 08:00:00	IWM	ETF	70.81	70.9	70.51	70.62	345115.0
2011-09-20 09:00:00	IWM	ETF	70.65	70.69	70.0	70.2	5674237.0
2011-09-20 10:00:00	IWM	ETF	70.21	71.2	70.16	71.0693	10486196.0
2011-09-20 11:00:00	IWM	ETF	71.0763	71.29	70.81	71.09	6643354.0
2011-09-20 12:00:00	IWM	ETF	71.09	71.1	70.51	70.69	4566137.0
2011-09-20 13:00:00	IWM	ETF	70.68	70.86	70.49	70.6	3221087.0
2011-09-20 14:00:00	IWM	ETF	70.6	70.69	69.98	70.11	7053070.0
2011-09-20 15:00:00	IWM	ETF	70.12	70.22	69.11	69.15	16129746.0
2011-09-20 16:00:00	IWM	ETF	69.15	70.3228	68.99	69.2	4794561.0
2011-09-20 17:00:00	IWM	ETF	69.23	69.23	69.05	69.05	61435.0
2011-09-20 18:00:00	IWM	ETF	69.11	69.14	68.99	69.1	44898.0
2011-09-20 19:00:00	IWM	ETF	69.13	69.14	69.04	69.13	3859.0
2011-09-20 05:00:00	DIA	ETF	114.25	114.8	114.25	114.8	9500.0
2011-09-20 06:00:00	DIA	ETF	114.77	114.9	114.52	114.52	2400.0
2011-09-20 07:00:00	DIA	ETF	113.72	114.52	113.72	114.52	3900.0
2011-09-20 08:00:00	DIA	ETF	114.42	114.65	114.27	114.27	65576.0

> showing 50 of 5,473 rows — these rows as CSV

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