PREVIEW / etf_1hour / 2012-07-12

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-07-12.parquet
  size:    183 KB
  rows:    5,640

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-12 04:00:00	SPY	ETF	133.18	133.89	133.18	133.46	299220.0
2012-07-12 05:00:00	SPY	ETF	133.46	133.66	133.46	133.51	65606.0
2012-07-12 06:00:00	SPY	ETF	133.55	133.55	133.0	133.14	127933.0
2012-07-12 07:00:00	SPY	ETF	133.12	133.28	133.03	133.22	384966.0
2012-07-12 08:00:00	SPY	ETF	133.26	133.81	133.05	133.29	2679198.0
2012-07-12 09:00:00	SPY	ETF	133.29	133.41	132.77	132.94	16943184.0
2012-07-12 10:00:00	SPY	ETF	132.94	133.02	132.6	132.9	18425753.0
2012-07-12 11:00:00	SPY	ETF	132.9	133.49	132.84	133.41	16053351.0
2012-07-12 12:00:00	SPY	ETF	133.401	133.48	133.21	133.428	9440638.0
2012-07-12 13:00:00	SPY	ETF	133.42	134.03	133.33	133.62	17992055.0
2012-07-12 14:00:00	SPY	ETF	133.63	133.91	133.48	133.82	17446625.0
2012-07-12 15:00:00	SPY	ETF	133.81	134.1	133.5	133.59	32529897.0
2012-07-12 16:00:00	SPY	ETF	133.58	134.2269	133.1834	133.66	8428028.0
2012-07-12 17:00:00	SPY	ETF	133.63	133.64	133.56	133.6	160927.0
2012-07-12 18:00:00	SPY	ETF	133.61	133.75	133.61	133.75	96407.0
2012-07-12 19:00:00	SPY	ETF	133.71	133.73	133.48	133.52	58764.0
2012-07-12 04:00:00	QQQ	ETF	62.73	62.73	62.62	62.62	900.0
2012-07-12 05:00:00	QQQ	ETF	62.63	62.66	62.63	62.66	2000.0
2012-07-12 06:00:00	QQQ	ETF	62.66	62.66	62.49	62.5	12200.0
2012-07-12 07:00:00	QQQ	ETF	62.5	62.62	62.49	62.58	305227.0
2012-07-12 08:00:00	QQQ	ETF	62.6	62.7	62.48	62.51	521011.0
2012-07-12 09:00:00	QQQ	ETF	62.51	62.57	62.1	62.17	6312090.0
2012-07-12 10:00:00	QQQ	ETF	62.16	62.21	61.86	62.05	6663568.0
2012-07-12 11:00:00	QQQ	ETF	62.05	62.4	62.02	62.35	6054663.0
2012-07-12 12:00:00	QQQ	ETF	62.359	62.385	62.2	62.3	3379710.0
2012-07-12 13:00:00	QQQ	ETF	62.3	62.69	62.28	62.43	5886927.0
2012-07-12 14:00:00	QQQ	ETF	62.43	62.62	62.36	62.57	4747533.0
2012-07-12 15:00:00	QQQ	ETF	62.56	62.69	62.365	62.45	11000942.0
2012-07-12 16:00:00	QQQ	ETF	62.45	63.053	62.36	62.43	1947766.0
2012-07-12 17:00:00	QQQ	ETF	62.45	62.47	62.43	62.47	3890.0
2012-07-12 18:00:00	QQQ	ETF	62.48	62.54	62.48	62.51	11907.0
2012-07-12 19:00:00	QQQ	ETF	62.53	62.53	62.43	62.47	23833.0
2012-07-12 04:00:00	IWM	ETF	78.77	78.77	78.38	78.38	541.0
2012-07-12 05:00:00	IWM	ETF	78.41	78.52	78.41	78.52	600.0
2012-07-12 06:00:00	IWM	ETF	78.41	78.41	78.03	78.03	6300.0
2012-07-12 07:00:00	IWM	ETF	78.05	78.26	78.01	78.22	7985.0
2012-07-12 08:00:00	IWM	ETF	78.25	79.65	78.23	78.32	234910.0
2012-07-12 09:00:00	IWM	ETF	78.39	78.48	77.9	78.03	5087835.0
2012-07-12 10:00:00	IWM	ETF	78.03	78.13	77.59	77.78	6964152.0
2012-07-12 11:00:00	IWM	ETF	77.79	78.295	77.77	78.18	5998473.0
2012-07-12 12:00:00	IWM	ETF	78.19	78.26	77.97	78.09	3681850.0
2012-07-12 13:00:00	IWM	ETF	78.1	78.68	78.0	78.43	6922805.0
2012-07-12 14:00:00	IWM	ETF	78.43	78.8	78.36	78.76	5286779.0
2012-07-12 15:00:00	IWM	ETF	78.76	79.1	78.64	78.79	13687797.0
2012-07-12 16:00:00	IWM	ETF	78.79	78.9965	78.59	78.76	3314347.0
2012-07-12 17:00:00	IWM	ETF	78.74	78.8	78.74	78.8	6165.0
2012-07-12 18:00:00	IWM	ETF	78.8	78.81	78.79	78.81	3199.0
2012-07-12 19:00:00	IWM	ETF	78.79	78.79	78.7	78.72	5751.0
2012-07-12 06:00:00	DIA	ETF	125.0	125.0	124.98	124.98	300.0
2012-07-12 07:00:00	DIA	ETF	125.0	125.0	124.74	124.74	2700.0

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

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