PREVIEW / etf_1hour / 2012-07-26

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-26.parquet
  size:    187 KB
  rows:    5,799

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-07-26 04:00:00	SPY	ETF	133.9	133.9	133.76	133.8	1547.0
2012-07-26 05:00:00	SPY	ETF	133.66	133.68	133.44	133.68	41760.0
2012-07-26 06:00:00	SPY	ETF	133.55	135.1	133.55	135.0	360172.0
2012-07-26 07:00:00	SPY	ETF	134.99	136.02	134.99	135.58	2905747.0
2012-07-26 08:00:00	SPY	ETF	135.56	136.0	134.63	135.81	4554378.0
2012-07-26 09:00:00	SPY	ETF	135.82	136.27	135.62	135.98	21156052.0
2012-07-26 10:00:00	SPY	ETF	135.98	136.31	135.53	135.719	24963605.0
2012-07-26 11:00:00	SPY	ETF	135.71	135.74	135.29	135.41	15792454.0
2012-07-26 12:00:00	SPY	ETF	135.4	135.76	135.26	135.725	9201040.0
2012-07-26 13:00:00	SPY	ETF	135.725	136.07	135.69	135.791	9947173.0
2012-07-26 14:00:00	SPY	ETF	135.8	136.14	135.75	136.01	14044142.0
2012-07-26 15:00:00	SPY	ETF	136.0	136.46	135.93	136.109	32335902.0
2012-07-26 16:00:00	SPY	ETF	136.14	136.35	133.9191	136.09	16948557.0
2012-07-26 17:00:00	SPY	ETF	136.1	136.29	136.09	136.16	374068.0
2012-07-26 18:00:00	SPY	ETF	136.19	136.19	136.04	136.13	272413.0
2012-07-26 19:00:00	SPY	ETF	136.13	136.13	136.04	136.08	82329.0
2012-07-26 05:00:00	QQQ	ETF	62.25	62.27	62.23	62.27	4450.0
2012-07-26 06:00:00	QQQ	ETF	62.38	63.01	62.38	63.01	20477.0
2012-07-26 07:00:00	QQQ	ETF	63.0	63.43	63.0	63.31	262200.0
2012-07-26 08:00:00	QQQ	ETF	63.27	63.45	63.2	63.32	1328584.0
2012-07-26 09:00:00	QQQ	ETF	63.31	63.73	63.25	63.46	7427632.0
2012-07-26 10:00:00	QQQ	ETF	63.45	63.7	63.175	63.3	8100773.0
2012-07-26 11:00:00	QQQ	ETF	63.31	63.35	62.98	63.061	4495442.0
2012-07-26 12:00:00	QQQ	ETF	63.065	63.27	62.97	63.24	2595192.0
2012-07-26 13:00:00	QQQ	ETF	63.23	63.43	63.2	63.2	2864076.0
2012-07-26 14:00:00	QQQ	ETF	63.2	63.43	63.19	63.352	1670622.0
2012-07-26 15:00:00	QQQ	ETF	63.35	63.6	63.3	63.36	6068327.0
2012-07-26 16:00:00	QQQ	ETF	63.37	63.5205	62.5135	63.3	2113565.0
2012-07-26 17:00:00	QQQ	ETF	63.32	63.38	63.29	63.36	16213.0
2012-07-26 18:00:00	QQQ	ETF	63.34	63.34	63.3	63.34	14520.0
2012-07-26 19:00:00	QQQ	ETF	63.3	63.32	63.3	63.31	5290.0
2012-07-26 06:00:00	IWM	ETF	77.15	77.48	77.15	77.48	1200.0
2012-07-26 07:00:00	IWM	ETF	77.44	78.13	77.29	78.0	299141.0
2012-07-26 08:00:00	IWM	ETF	77.96	78.18	77.86	77.96	405009.0
2012-07-26 09:00:00	IWM	ETF	77.97	78.18	77.6	77.7	7783639.0
2012-07-26 10:00:00	IWM	ETF	77.69	77.9	77.29	77.4	8064786.0
2012-07-26 11:00:00	IWM	ETF	77.4	77.51	77.13	77.18	5312959.0
2012-07-26 12:00:00	IWM	ETF	77.18	77.25	77.02	77.22	3801077.0
2012-07-26 13:00:00	IWM	ETF	77.21	77.35	77.0	77.09	3283559.0
2012-07-26 14:00:00	IWM	ETF	77.1	77.51	77.02	77.4	4743806.0
2012-07-26 15:00:00	IWM	ETF	77.39	77.66	77.31	77.46	6685990.0
2012-07-26 16:00:00	IWM	ETF	77.46	77.59	77.31	77.34	1348224.0
2012-07-26 17:00:00	IWM	ETF	77.33	77.41	77.29	77.41	19504.0
2012-07-26 18:00:00	IWM	ETF	77.35	77.35	77.35	77.35	100.0
2012-07-26 19:00:00	IWM	ETF	77.4	77.4	77.4	77.4	100.0
2012-07-26 07:00:00	DIA	ETF	127.48	128.08	127.48	127.88	10000.0
2012-07-26 08:00:00	DIA	ETF	127.9	128.15	127.62	128.11	61671.0
2012-07-26 09:00:00	DIA	ETF	128.13	128.91	127.99	128.691	1633810.0
2012-07-26 10:00:00	DIA	ETF	128.65	129.03	128.14	128.32	1707468.0
2012-07-26 11:00:00	DIA	ETF	128.33	128.33	127.94	128.09	590078.0

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

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