PREVIEW / etf_1hour / 2015-02-12

all etf 1-hour files

  file:    by_date/etf_1hour/2015/2015-02-12.parquet
  size:    240 KB
  rows:    7,568

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-02-12 04:00:00	SPY	ETF	207.45	207.83	206.98	207.78	93864.0
2015-02-12 05:00:00	SPY	ETF	207.83	208.25	207.77	208.12	95678.0
2015-02-12 06:00:00	SPY	ETF	208.14	208.23	207.81	208.0	55628.0
2015-02-12 07:00:00	SPY	ETF	208.08	208.16	207.96	208.08	235858.0
2015-02-12 08:00:00	SPY	ETF	208.05	208.24	207.56	207.8	1230099.0
2015-02-12 09:00:00	SPY	ETF	207.81	208.32	207.66	208.21	12907012.0
2015-02-12 10:00:00	SPY	ETF	208.2	208.46	207.95	208.11	12744207.0
2015-02-12 11:00:00	SPY	ETF	208.12	208.36	207.85	208.26	10622156.0
2015-02-12 12:00:00	SPY	ETF	208.26	208.6	208.23	208.4	7935641.0
2015-02-12 13:00:00	SPY	ETF	208.41	208.72	208.399	208.69	8920248.0
2015-02-12 14:00:00	SPY	ETF	208.69	208.85	208.47	208.82	9795864.0
2015-02-12 15:00:00	SPY	ETF	208.83	208.99	208.64	208.895	19315420.0
2015-02-12 16:00:00	SPY	ETF	208.89	208.969	206.9727	208.76	12247961.0
2015-02-12 17:00:00	SPY	ETF	208.76	208.81	208.75	208.8	125131.0
2015-02-12 18:00:00	SPY	ETF	208.77	208.78	208.69	208.75	159737.0
2015-02-12 19:00:00	SPY	ETF	208.74	208.78	208.71	208.72	122910.0
2015-02-12 04:00:00	QQQ	ETF	104.9	105.34	104.9	105.14	21350.0
2015-02-12 05:00:00	QQQ	ETF	105.36	105.49	105.36	105.49	13470.0
2015-02-12 06:00:00	QQQ	ETF	105.54	105.56	105.4	105.4	8200.0
2015-02-12 07:00:00	QQQ	ETF	105.47	105.49	105.36	105.4	35529.0
2015-02-12 08:00:00	QQQ	ETF	105.39	105.52	105.11	105.44	211284.0
2015-02-12 09:00:00	QQQ	ETF	105.43	105.66	105.3	105.58	4213451.0
2015-02-12 10:00:00	QQQ	ETF	105.59	105.69	105.4805	105.58	2675613.0
2015-02-12 11:00:00	QQQ	ETF	105.59	105.69	105.42	105.64	1898782.0
2015-02-12 12:00:00	QQQ	ETF	105.64	105.85	105.62	105.775	1904860.0
2015-02-12 13:00:00	QQQ	ETF	105.77	105.95	105.69	105.911	1765648.0
2015-02-12 14:00:00	QQQ	ETF	105.92	105.95	105.78	105.92	1593231.0
2015-02-12 15:00:00	QQQ	ETF	105.92	106.04	105.84	106.01	4855229.0
2015-02-12 16:00:00	QQQ	ETF	106.01	106.07	104.8083	105.99	883641.0
2015-02-12 17:00:00	QQQ	ETF	105.99	106.01	105.94	105.96	17469.0
2015-02-12 18:00:00	QQQ	ETF	105.98	106.0	105.95	105.96	16752.0
2015-02-12 19:00:00	QQQ	ETF	105.97	105.98	105.94	105.97	7293.0
2015-02-12 06:00:00	IWM	ETF	120.37	120.42	120.37	120.42	2900.0
2015-02-12 07:00:00	IWM	ETF	120.5	120.56	120.31	120.54	59987.0
2015-02-12 08:00:00	IWM	ETF	120.54	120.56	120.2	120.3	115722.0
2015-02-12 09:00:00	IWM	ETF	120.31	120.41	119.84	120.32	3288024.0
2015-02-12 10:00:00	IWM	ETF	120.33	120.58	120.18	120.27	3381899.0
2015-02-12 11:00:00	IWM	ETF	120.28	120.46	120.13	120.37	2076963.0
2015-02-12 12:00:00	IWM	ETF	120.38	120.555	120.32	120.4	1313673.0
2015-02-12 13:00:00	IWM	ETF	120.41	120.77	120.41	120.72	3321839.0
2015-02-12 14:00:00	IWM	ETF	120.72	120.81	120.62	120.77	1832081.0
2015-02-12 15:00:00	IWM	ETF	120.78	120.92	120.63	120.8	4667763.0
2015-02-12 16:00:00	IWM	ETF	120.81	120.81	120.4816	120.62	3942310.0
2015-02-12 17:00:00	IWM	ETF	120.62	120.62	120.58	120.59	56362.0
2015-02-12 18:00:00	IWM	ETF	120.58	120.64	120.58	120.64	1150.0
2015-02-12 19:00:00	IWM	ETF	120.64	120.65	120.59	120.65	2500.0
2015-02-12 04:00:00	DIA	ETF	179.49	179.49	179.49	179.49	200.0
2015-02-12 05:00:00	DIA	ETF	179.69	179.69	179.69	179.69	200.0
2015-02-12 08:00:00	DIA	ETF	179.82	179.82	179.11	179.25	19000.0
2015-02-12 09:00:00	DIA	ETF	179.26	179.64	179.0	179.38	797804.0

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

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