PREVIEW / etf_1hour / 2012-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-04-12.parquet
  size:    185 KB
  rows:    5,700

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
2012-04-12 04:00:00	SPY	ETF	137.41	137.72	137.41	137.49	12860.0
2012-04-12 05:00:00	SPY	ETF	137.39	137.39	137.15	137.22	41815.0
2012-04-12 06:00:00	SPY	ETF	137.16	137.52	137.16	137.45	61279.0
2012-04-12 07:00:00	SPY	ETF	137.45	137.69	137.36	137.57	507512.0
2012-04-12 08:00:00	SPY	ETF	137.56	137.84	136.86	137.08	2911029.0
2012-04-12 09:00:00	SPY	ETF	137.06	137.87	136.96	137.815	24394024.0
2012-04-12 10:00:00	SPY	ETF	137.81	138.32	137.66	138.23	27161824.0
2012-04-12 11:00:00	SPY	ETF	138.23	138.46	138.2	138.37	19260663.0
2012-04-12 12:00:00	SPY	ETF	138.38	138.72	138.29	138.66	17356554.0
2012-04-12 13:00:00	SPY	ETF	138.66	138.76	138.45	138.5	11077511.0
2012-04-12 14:00:00	SPY	ETF	138.5	138.84	138.49	138.75	13009722.0
2012-04-12 15:00:00	SPY	ETF	138.76	138.9	138.62	138.83	28017054.0
2012-04-12 16:00:00	SPY	ETF	138.81	139.12	138.2781	138.98	6850847.0
2012-04-12 17:00:00	SPY	ETF	138.98	139.04	138.86	138.9	303598.0
2012-04-12 18:00:00	SPY	ETF	138.9	138.98	138.85	138.9	64708.0
2012-04-12 19:00:00	SPY	ETF	138.92	139.05	138.86	139.05	652937.0
2012-04-12 06:00:00	QQQ	ETF	66.73	66.73	66.73	66.73	10000.0
2012-04-12 07:00:00	QQQ	ETF	66.69	66.83	66.67	66.82	33925.0
2012-04-12 08:00:00	QQQ	ETF	66.81	66.82	66.46	66.57	508336.0
2012-04-12 09:00:00	QQQ	ETF	66.55	66.921	66.4807	66.85	7792974.0
2012-04-12 10:00:00	QQQ	ETF	66.86	67.24	66.762	67.13	10724185.0
2012-04-12 11:00:00	QQQ	ETF	67.1329	67.26	67.095	67.1957	7949988.0
2012-04-12 12:00:00	QQQ	ETF	67.2	67.24	67.05	67.199	6187572.0
2012-04-12 13:00:00	QQQ	ETF	67.199	67.23	66.96	67.02	5153441.0
2012-04-12 14:00:00	QQQ	ETF	67.01	67.26	67.01	67.2	3848780.0
2012-04-12 15:00:00	QQQ	ETF	67.2	67.28	67.15	67.2	6606465.0
2012-04-12 16:00:00	QQQ	ETF	67.2	67.28	66.91	67.24	3333307.0
2012-04-12 17:00:00	QQQ	ETF	67.24	67.28	67.14	67.2	272145.0
2012-04-12 18:00:00	QQQ	ETF	67.17	67.2	67.14	67.16	11914.0
2012-04-12 19:00:00	QQQ	ETF	67.18	67.21	67.13	67.21	17100.0
2012-04-12 05:00:00	IWM	ETF	79.56	79.56	79.55	79.55	329.0
2012-04-12 07:00:00	IWM	ETF	79.75	79.96	79.74	79.94	60027.0
2012-04-12 08:00:00	IWM	ETF	79.9	79.92	79.15	79.5	1082388.0
2012-04-12 09:00:00	IWM	ETF	79.5	80.18	79.41	80.15	8221788.0
2012-04-12 10:00:00	IWM	ETF	80.15	80.53	79.86	80.47	7797337.0
2012-04-12 11:00:00	IWM	ETF	80.465	80.74	80.465	80.69	6454299.0
2012-04-12 12:00:00	IWM	ETF	80.69	80.86	80.57	80.76	4868324.0
2012-04-12 13:00:00	IWM	ETF	80.76	80.88	80.52	80.63	3746062.0
2012-04-12 14:00:00	IWM	ETF	80.63	80.91	80.59	80.845	2644157.0
2012-04-12 15:00:00	IWM	ETF	80.845	80.9	80.59	80.63	8951113.0
2012-04-12 16:00:00	IWM	ETF	80.62	81.05	80.5	80.75	5991217.0
2012-04-12 17:00:00	IWM	ETF	80.75	80.77	80.65	80.74	718677.0
2012-04-12 18:00:00	IWM	ETF	80.79	80.79	80.79	80.79	100.0
2012-04-12 19:00:00	IWM	ETF	80.62	80.78	80.62	80.78	1500.0
2012-04-12 06:00:00	DIA	ETF	128.25	128.4	128.2	128.25	17200.0
2012-04-12 07:00:00	DIA	ETF	128.39	128.51	128.39	128.46	27000.0
2012-04-12 08:00:00	DIA	ETF	128.43	128.43	127.93	127.97	21846.0
2012-04-12 09:00:00	DIA	ETF	128.08	128.72	128.04	128.68	692614.0
2012-04-12 10:00:00	DIA	ETF	128.69	129.16	128.56	129.11	1619418.0
2012-04-12 11:00:00	DIA	ETF	129.11	129.42	129.1	129.3	2041456.0

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

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