PREVIEW / etf_1hour / 2011-07-08

all etf 1-hour files

  file:    by_date/etf_1hour/2011/2011-07-08.parquet
  size:    180 KB
  rows:    5,566

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-08 04:00:00	SPY	ETF	135.62	135.65	135.37	135.65	1000.0
2011-07-08 05:00:00	SPY	ETF	135.54	135.54	135.2	135.2	1800.0
2011-07-08 06:00:00	SPY	ETF	135.34	135.52	135.26	135.52	6800.0
2011-07-08 07:00:00	SPY	ETF	135.5	135.63	135.46	135.49	419828.0
2011-07-08 08:00:00	SPY	ETF	135.54	135.87	133.68	133.8	22461893.0
2011-07-08 09:00:00	SPY	ETF	133.81	134.25	133.51	134.1	29398725.0
2011-07-08 10:00:00	SPY	ETF	134.1	134.115	133.56	133.76	28333940.0
2011-07-08 11:00:00	SPY	ETF	133.755	133.93	133.39	133.85	24157181.0
2011-07-08 12:00:00	SPY	ETF	133.85	135.3558	133.65	133.89	9334407.0
2011-07-08 13:00:00	SPY	ETF	133.89	134.22	133.76	133.95	13877281.0
2011-07-08 14:00:00	SPY	ETF	133.95	134.11	133.8	134.01	13094877.0
2011-07-08 15:00:00	SPY	ETF	134.01	134.44	133.9	134.41	33507632.0
2011-07-08 16:00:00	SPY	ETF	134.41	135.3558	133.9623	134.67	15467858.0
2011-07-08 17:00:00	SPY	ETF	134.68	134.72	134.62	134.63	197873.0
2011-07-08 18:00:00	SPY	ETF	134.62	134.69	134.4	134.63	283891.0
2011-07-08 19:00:00	SPY	ETF	134.64	134.71	134.64	134.65	30175.0
2011-07-08 04:00:00	QQQ	ETF	59.34	59.34	59.34	59.34	900.0
2011-07-08 05:00:00	QQQ	ETF	59.24	59.24	59.22	59.22	10100.0
2011-07-08 06:00:00	QQQ	ETF	59.3	59.38	59.26	59.38	2000.0
2011-07-08 07:00:00	QQQ	ETF	59.36	59.42	59.35	59.36	139471.0
2011-07-08 08:00:00	QQQ	ETF	59.36	59.48	58.65	58.68	8240550.0
2011-07-08 09:00:00	QQQ	ETF	58.69	58.935	58.53	58.86	9084217.0
2011-07-08 10:00:00	QQQ	ETF	58.86	58.88	58.55	58.61	8619008.0
2011-07-08 11:00:00	QQQ	ETF	58.6	58.64	58.37	58.585	6968944.0
2011-07-08 12:00:00	QQQ	ETF	58.59	58.75	58.5	58.7	3319201.0
2011-07-08 13:00:00	QQQ	ETF	58.7	58.83	58.6099	58.7	4704061.0
2011-07-08 14:00:00	QQQ	ETF	58.6999	58.79	58.6301	58.755	2847285.0
2011-07-08 15:00:00	QQQ	ETF	58.755	59.03	58.71	59.02	9589686.0
2011-07-08 16:00:00	QQQ	ETF	59.03	59.198	59.02	59.15	3090908.0
2011-07-08 17:00:00	QQQ	ETF	59.16	59.19	58.7053	58.7053	22184.0
2011-07-08 18:00:00	QQQ	ETF	59.16	59.19	59.03	59.13	28821.0
2011-07-08 19:00:00	QQQ	ETF	59.14	59.18	59.13	59.18	13127.0
2011-07-08 06:00:00	IWM	ETF	85.75	85.75	85.75	85.75	300.0
2011-07-08 07:00:00	IWM	ETF	85.83	85.88	85.83	85.88	12100.0
2011-07-08 08:00:00	IWM	ETF	85.87	86.08	84.52	84.6	3906570.0
2011-07-08 09:00:00	IWM	ETF	84.62	85.04	84.35	84.86	10745254.0
2011-07-08 10:00:00	IWM	ETF	84.86	84.87	84.37	84.57	9980233.0
2011-07-08 11:00:00	IWM	ETF	84.56	84.83	84.32	84.76	6592992.0
2011-07-08 12:00:00	IWM	ETF	84.76	84.9	84.69	84.85	2719671.0
2011-07-08 13:00:00	IWM	ETF	84.85	85.07	84.75	84.86	4918504.0
2011-07-08 14:00:00	IWM	ETF	84.855	84.93	84.72	84.87	3407014.0
2011-07-08 15:00:00	IWM	ETF	84.87	85.21	84.83	85.15	9073691.0
2011-07-08 16:00:00	IWM	ETF	85.15	85.28	85.12	85.22	1686447.0
2011-07-08 17:00:00	IWM	ETF	85.2	85.28	85.2	85.27	2400.0
2011-07-08 18:00:00	IWM	ETF	85.24	85.26	85.24	85.24	3449.0
2011-07-08 19:00:00	IWM	ETF	85.26	85.28	85.19	85.23	9355.0
2011-07-08 07:00:00	DIA	ETF	127.3	127.3	127.25	127.27	5300.0
2011-07-08 08:00:00	DIA	ETF	127.27	127.55	125.83	125.89	266425.0
2011-07-08 09:00:00	DIA	ETF	125.91	126.26	125.69	126.13	1337971.0
2011-07-08 10:00:00	DIA	ETF	126.13	126.13	125.59	125.83	1042796.0

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

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