PREVIEW / etf_1hour / 2012-03-06

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-03-06.parquet
  size:    196 KB
  rows:    6,066

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-03-06 04:00:00	SPY	ETF	136.52	136.52	135.82	135.84	44806.0
2012-03-06 05:00:00	SPY	ETF	135.95	135.95	135.72	135.75	28100.0
2012-03-06 06:00:00	SPY	ETF	135.79	135.9	135.7	135.76	176260.0
2012-03-06 07:00:00	SPY	ETF	135.75	135.95	135.7	135.83	821010.0
2012-03-06 08:00:00	SPY	ETF	135.85	136.41	135.62	135.69	2018554.0
2012-03-06 09:00:00	SPY	ETF	135.69	135.69	135.02	135.1	29939145.0
2012-03-06 10:00:00	SPY	ETF	135.1	135.22	134.78	134.88	29331910.0
2012-03-06 11:00:00	SPY	ETF	134.88	135.16	134.75	134.84	29560576.0
2012-03-06 12:00:00	SPY	ETF	134.83	134.92	134.58	134.72	15837919.0
2012-03-06 13:00:00	SPY	ETF	134.72	134.825	134.54	134.65	13852134.0
2012-03-06 14:00:00	SPY	ETF	134.66	134.795	134.36	134.42	18327467.0
2012-03-06 15:00:00	SPY	ETF	134.425	134.96	134.42	134.7	35395834.0
2012-03-06 16:00:00	SPY	ETF	134.71	136.8123	134.48	134.7	23792170.0
2012-03-06 17:00:00	SPY	ETF	134.7	134.73	134.65	134.69	147270.0
2012-03-06 18:00:00	SPY	ETF	134.72	134.97	134.72	134.95	190263.0
2012-03-06 19:00:00	SPY	ETF	134.91	134.99	134.87	134.96	162488.0
2012-03-06 04:00:00	QQQ	ETF	63.85	63.85	63.8	63.8	300.0
2012-03-06 05:00:00	QQQ	ETF	63.75	63.78	63.75	63.78	19915.0
2012-03-06 06:00:00	QQQ	ETF	63.77	63.77	63.65	63.71	90950.0
2012-03-06 07:00:00	QQQ	ETF	63.69	63.8	63.66	63.77	210941.0
2012-03-06 08:00:00	QQQ	ETF	63.75	63.79	63.67	63.72	2338755.0
2012-03-06 09:00:00	QQQ	ETF	63.71	63.72	63.42	63.46	12415479.0
2012-03-06 10:00:00	QQQ	ETF	63.46	63.515	63.23	63.395	10948918.0
2012-03-06 11:00:00	QQQ	ETF	63.385	63.67	63.36	63.44	5872438.0
2012-03-06 12:00:00	QQQ	ETF	63.445	63.53	63.33	63.46	4626574.0
2012-03-06 13:00:00	QQQ	ETF	63.46	63.64	63.37	63.4799	4265483.0
2012-03-06 14:00:00	QQQ	ETF	63.48	63.54	63.3	63.37	3733018.0
2012-03-06 15:00:00	QQQ	ETF	63.3721	63.67	63.3721	63.5754	7354609.0
2012-03-06 16:00:00	QQQ	ETF	63.58	63.64	63.5	63.6	1037431.0
2012-03-06 17:00:00	QQQ	ETF	63.61	63.62	63.56	63.6	30744.0
2012-03-06 18:00:00	QQQ	ETF	63.64	63.68	63.63	63.68	7740.0
2012-03-06 19:00:00	QQQ	ETF	63.72	63.72	63.68	63.71	11243.0
2012-03-06 04:00:00	IWM	ETF	80.05	80.05	79.89	79.89	529.0
2012-03-06 05:00:00	IWM	ETF	79.62	79.62	79.62	79.62	100.0
2012-03-06 06:00:00	IWM	ETF	79.91	79.91	79.6	79.6	2500.0
2012-03-06 07:00:00	IWM	ETF	79.58	79.74	79.54	79.7	72022.0
2012-03-06 08:00:00	IWM	ETF	79.69	79.75	79.5	79.53	268299.0
2012-03-06 09:00:00	IWM	ETF	79.53	79.62	79.14	79.22	8311264.0
2012-03-06 10:00:00	IWM	ETF	79.22	79.35	78.794	78.91	10023680.0
2012-03-06 11:00:00	IWM	ETF	78.9	79.16	78.73	78.77	4903244.0
2012-03-06 12:00:00	IWM	ETF	78.77	78.86	78.57	78.74	4560976.0
2012-03-06 13:00:00	IWM	ETF	78.74	78.825	78.62	78.69	4041557.0
2012-03-06 14:00:00	IWM	ETF	78.69	78.74	78.41	78.47	5296443.0
2012-03-06 15:00:00	IWM	ETF	78.475	78.75	78.47	78.74	10324219.0
2012-03-06 16:00:00	IWM	ETF	78.74	80.2998	78.6035	78.6035	4356941.0
2012-03-06 17:00:00	IWM	ETF	78.72	78.76	78.68	78.69	41000.0
2012-03-06 18:00:00	IWM	ETF	78.7	78.77	78.7	78.77	62501.0
2012-03-06 19:00:00	IWM	ETF	78.84	78.84	78.84	78.84	832.0
2012-03-06 04:00:00	DIA	ETF	128.82	128.82	128.82	128.82	100.0
2012-03-06 07:00:00	DIA	ETF	128.62	128.84	128.62	128.7	21000.0

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

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