PREVIEW / etf_1hour / 2013-09-09

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-09-09.parquet
  size:    210 KB
  rows:    6,570

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
2013-09-09 04:00:00	SPY	ETF	166.15	166.52	166.15	166.51	80000.0
2013-09-09 05:00:00	SPY	ETF	166.46	166.46	166.27	166.27	14000.0
2013-09-09 06:00:00	SPY	ETF	166.26	166.5	166.26	166.26	23800.0
2013-09-09 07:00:00	SPY	ETF	166.24	166.44	166.2	166.29	164627.0
2013-09-09 08:00:00	SPY	ETF	166.32	166.42	166.27	166.42	694369.0
2013-09-09 09:00:00	SPY	ETF	166.42	167.05	166.37	166.9801	11521667.0
2013-09-09 10:00:00	SPY	ETF	166.99	167.11	166.63	166.8	12668882.0
2013-09-09 11:00:00	SPY	ETF	166.79	167.07	166.7	166.98	8548020.0
2013-09-09 12:00:00	SPY	ETF	166.98	167.28	166.98	167.185	6887252.0
2013-09-09 13:00:00	SPY	ETF	167.19	167.44	167.12	167.43	5692736.0
2013-09-09 14:00:00	SPY	ETF	167.42	167.73	167.415	167.56	10054030.0
2013-09-09 15:00:00	SPY	ETF	167.56	167.72	167.46	167.64	17518542.0
2013-09-09 16:00:00	SPY	ETF	167.64	167.71	167.42	167.62	2901956.0
2013-09-09 17:00:00	SPY	ETF	167.62	167.69	167.61	167.67	4125590.0
2013-09-09 18:00:00	SPY	ETF	167.67	167.79	167.65	167.76	126505.0
2013-09-09 19:00:00	SPY	ETF	167.71	167.8	167.69	167.79	24290.0
2013-09-09 04:00:00	QQQ	ETF	77.18	77.23	77.17	77.23	32800.0
2013-09-09 05:00:00	QQQ	ETF	77.21	77.21	77.15	77.15	14300.0
2013-09-09 06:00:00	QQQ	ETF	77.17	77.26	77.15	77.15	15300.0
2013-09-09 07:00:00	QQQ	ETF	77.13	77.39	77.11	77.19	53335.0
2013-09-09 08:00:00	QQQ	ETF	77.2	77.21	77.15	77.19	52301.0
2013-09-09 09:00:00	QQQ	ETF	77.21	77.52	77.2	77.47	3137953.0
2013-09-09 10:00:00	QQQ	ETF	77.47	77.52	77.26	77.37	3270658.0
2013-09-09 11:00:00	QQQ	ETF	77.365	77.58	77.31	77.54	2935503.0
2013-09-09 12:00:00	QQQ	ETF	77.54	77.7	77.53	77.6386	2755720.0
2013-09-09 13:00:00	QQQ	ETF	77.63	77.77	77.6	77.7501	2409114.0
2013-09-09 14:00:00	QQQ	ETF	77.76	77.96	77.75	77.854	3481715.0
2013-09-09 15:00:00	QQQ	ETF	77.86	77.93	77.78	77.83	5070813.0
2013-09-09 16:00:00	QQQ	ETF	77.82	77.9	77.74	77.86	1589543.0
2013-09-09 17:00:00	QQQ	ETF	77.85	77.9	77.85	77.9	31915.0
2013-09-09 18:00:00	QQQ	ETF	77.86	77.92	77.84	77.86	10186.0
2013-09-09 19:00:00	QQQ	ETF	77.86	77.9	77.85	77.89	7800.0
2013-09-09 06:00:00	IWM	ETF	102.75	102.75	102.6	102.6	1690.0
2013-09-09 07:00:00	IWM	ETF	102.68	102.68	102.58	102.61	10100.0
2013-09-09 08:00:00	IWM	ETF	102.6	102.69	102.57	102.69	82731.0
2013-09-09 09:00:00	IWM	ETF	102.7	103.12	102.65	103.09	2535689.0
2013-09-09 10:00:00	IWM	ETF	103.1	103.29	102.92	103.21	3252274.0
2013-09-09 11:00:00	IWM	ETF	103.21	103.439	103.17	103.34	2226962.0
2013-09-09 12:00:00	IWM	ETF	103.34	103.55	103.23	103.35	2227528.0
2013-09-09 13:00:00	IWM	ETF	103.34	103.68	103.33	103.68	1751909.0
2013-09-09 14:00:00	IWM	ETF	103.675	103.84	103.66	103.71	3654097.0
2013-09-09 15:00:00	IWM	ETF	103.72	104.03	103.7	103.94	8270735.0
2013-09-09 16:00:00	IWM	ETF	103.93	104.02	103.8	103.9	1332757.0
2013-09-09 17:00:00	IWM	ETF	103.89	103.96	103.82	103.93	13626.0
2013-09-09 18:00:00	IWM	ETF	103.94	103.94	103.94	103.94	2000.0
2013-09-09 19:00:00	IWM	ETF	104.02	104.02	104.02	104.02	130.0
2013-09-09 08:00:00	DIA	ETF	149.37	149.39	149.37	149.39	200.0
2013-09-09 09:00:00	DIA	ETF	149.43	150.19	149.42	150.12	605009.0
2013-09-09 10:00:00	DIA	ETF	150.13	150.2	149.85	150.02	608288.0
2013-09-09 11:00:00	DIA	ETF	150.02	150.18	149.85	150.07	587098.0

> showing 50 of 6,570 rows — these rows as CSV

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