PREVIEW / etf_1hour / 2011-07-11

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-11.parquet
  size:    186 KB
  rows:    5,697

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-07-11 04:00:00	SPY	ETF	133.9	133.9	133.4	133.61	27292.0
2011-07-11 05:00:00	SPY	ETF	133.49	133.5	133.3	133.4	24166.0
2011-07-11 06:00:00	SPY	ETF	133.4	133.47	133.3	133.34	24655.0
2011-07-11 07:00:00	SPY	ETF	133.33	133.36	132.85	132.94	1917573.0
2011-07-11 08:00:00	SPY	ETF	132.94	133.24	132.6728	132.89	5790760.0
2011-07-11 09:00:00	SPY	ETF	132.88	133.18	132.65	132.94	20916446.0
2011-07-11 10:00:00	SPY	ETF	132.94	133.005	132.01	132.02	31982331.0
2011-07-11 11:00:00	SPY	ETF	132.02	132.5	131.91	132.299	26215186.0
2011-07-11 12:00:00	SPY	ETF	132.29	132.45	132.1	132.16	10265250.0
2011-07-11 13:00:00	SPY	ETF	132.165	132.21	131.84	132.18	14386597.0
2011-07-11 14:00:00	SPY	ETF	132.17	132.225	131.75	131.89	15493321.0
2011-07-11 15:00:00	SPY	ETF	131.89	132.05	131.66	131.99	41869307.0
2011-07-11 16:00:00	SPY	ETF	131.98	134.4174	131.98	132.26	21084365.0
2011-07-11 17:00:00	SPY	ETF	132.26	132.26	132.11	132.17	323456.0
2011-07-11 18:00:00	SPY	ETF	132.17	132.31	131.96	132.17	724817.0
2011-07-11 19:00:00	SPY	ETF	132.17	132.24	132.1	132.2	219147.0
2011-07-11 04:00:00	QQQ	ETF	59.02	59.02	58.66	58.66	10058.0
2011-07-11 06:00:00	QQQ	ETF	58.59	58.66	58.56	58.56	26400.0
2011-07-11 07:00:00	QQQ	ETF	58.59	58.6	58.4	58.42	586130.0
2011-07-11 08:00:00	QQQ	ETF	58.54	58.54	58.38	58.45	2679915.0
2011-07-11 09:00:00	QQQ	ETF	58.45	58.71	58.37	58.58	7187615.0
2011-07-11 10:00:00	QQQ	ETF	58.58	58.62	58.08	58.0826	11320083.0
2011-07-11 11:00:00	QQQ	ETF	58.09	58.2	57.95	58.12	6568257.0
2011-07-11 12:00:00	QQQ	ETF	58.1101	58.13	57.95	58.0	2488550.0
2011-07-11 13:00:00	QQQ	ETF	58.0	58.0284	57.84	58.008	3312314.0
2011-07-11 14:00:00	QQQ	ETF	58.0	58.03	57.76	57.865	4602013.0
2011-07-11 15:00:00	QQQ	ETF	57.865	57.98	57.76	57.97	7907443.0
2011-07-11 16:00:00	QQQ	ETF	57.97	58.16	57.96	58.06	1783373.0
2011-07-11 17:00:00	QQQ	ETF	58.06	58.06	57.9435	58.0	73422.0
2011-07-11 18:00:00	QQQ	ETF	58.02	58.11	57.96	58.06	73445.0
2011-07-11 19:00:00	QQQ	ETF	58.04	58.06	58.01	58.06	18700.0
2011-07-11 04:00:00	IWM	ETF	84.51	84.51	84.51	84.51	1000.0
2011-07-11 05:00:00	IWM	ETF	84.32	84.32	84.32	84.32	113.0
2011-07-11 06:00:00	IWM	ETF	84.4	84.4	84.27	84.27	1165.0
2011-07-11 07:00:00	IWM	ETF	84.26	84.29	84.0	84.04	145807.0
2011-07-11 08:00:00	IWM	ETF	84.08	84.17	83.96	84.07	1515927.0
2011-07-11 09:00:00	IWM	ETF	84.07	84.53	83.93	84.37	7625774.0
2011-07-11 10:00:00	IWM	ETF	84.37	84.4	83.39	83.41	12396901.0
2011-07-11 11:00:00	IWM	ETF	83.4	83.7	83.2	83.55	9857397.0
2011-07-11 12:00:00	IWM	ETF	83.5512	83.65	83.41	83.44	3500953.0
2011-07-11 13:00:00	IWM	ETF	83.44	83.47	83.26	83.44	4056656.0
2011-07-11 14:00:00	IWM	ETF	83.44	83.47	83.13	83.23	4654028.0
2011-07-11 15:00:00	IWM	ETF	83.23	83.36	83.09	83.31	10426332.0
2011-07-11 16:00:00	IWM	ETF	83.31	83.6307	83.2319	83.29	1101880.0
2011-07-11 17:00:00	IWM	ETF	83.33	83.33	83.2	83.22	37602.0
2011-07-11 18:00:00	IWM	ETF	83.23	83.29	83.23	83.29	4300.0
2011-07-11 19:00:00	IWM	ETF	83.27	83.28	83.2	83.2	15899.0
2011-07-11 04:00:00	DIA	ETF	125.87	125.87	125.69	125.69	6000.0
2011-07-11 05:00:00	DIA	ETF	125.67	125.67	125.61	125.61	2000.0
2011-07-11 07:00:00	DIA	ETF	125.67	125.67	125.31	125.31	37000.0

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

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