PREVIEW / etf_1hour / 2013-04-12

all etf 1-hour files

  file:    by_date/etf_1hour/2013/2013-04-12.parquet
  size:    202 KB
  rows:    6,257

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
2013-04-12 04:00:00	SPY	ETF	159.0	159.0	158.8	158.96	62375.0
2013-04-12 05:00:00	SPY	ETF	158.82	158.85	158.66	158.79	54477.0
2013-04-12 06:00:00	SPY	ETF	158.8	158.88	158.77	158.85	140347.0
2013-04-12 07:00:00	SPY	ETF	158.88	158.9	158.63	158.67	1608596.0
2013-04-12 08:00:00	SPY	ETF	158.68	158.87	158.32	158.64	4290225.0
2013-04-12 09:00:00	SPY	ETF	158.65	159.04	158.42	158.61	15678984.0
2013-04-12 10:00:00	SPY	ETF	158.61	158.84	158.0	158.14	20437194.0
2013-04-12 11:00:00	SPY	ETF	158.14	158.49	157.92	158.485	17905221.0
2013-04-12 12:00:00	SPY	ETF	158.485	158.605	158.29	158.57	8938643.0
2013-04-12 13:00:00	SPY	ETF	158.57	158.8	158.47	158.55	8906142.0
2013-04-12 14:00:00	SPY	ETF	158.545	158.61	158.37	158.5	8057140.0
2013-04-12 15:00:00	SPY	ETF	158.5	158.82	158.4603	158.798	21365255.0
2013-04-12 16:00:00	SPY	ETF	158.81	159.2	158.59	158.68	6782034.0
2013-04-12 17:00:00	SPY	ETF	158.68	158.7	158.52	158.59	213523.0
2013-04-12 18:00:00	SPY	ETF	158.57	158.79	158.57	158.68	118615.0
2013-04-12 19:00:00	SPY	ETF	158.68	158.7	158.66	158.67	7065.0
2013-04-12 04:00:00	QQQ	ETF	69.99	69.99	69.9	69.9	200.0
2013-04-12 05:00:00	QQQ	ETF	69.83	69.83	69.79	69.79	5200.0
2013-04-12 06:00:00	QQQ	ETF	69.83	69.83	69.82	69.82	300.0
2013-04-12 07:00:00	QQQ	ETF	69.79	69.82	69.68	69.69	848621.0
2013-04-12 08:00:00	QQQ	ETF	69.69	69.77	69.62	69.74	1974185.0
2013-04-12 09:00:00	QQQ	ETF	69.74	69.99	69.62	69.84	5335369.0
2013-04-12 10:00:00	QQQ	ETF	69.841	69.92	69.421	69.52	4526742.0
2013-04-12 11:00:00	QQQ	ETF	69.51	69.73	69.41	69.71	6060045.0
2013-04-12 12:00:00	QQQ	ETF	69.71	69.83	69.66	69.81	2031773.0
2013-04-12 13:00:00	QQQ	ETF	69.81	69.9	69.78	69.848	2545214.0
2013-04-12 14:00:00	QQQ	ETF	69.85	69.9	69.745	69.81	1956405.0
2013-04-12 15:00:00	QQQ	ETF	69.81	69.98	69.792	69.95	4192967.0
2013-04-12 16:00:00	QQQ	ETF	69.94	69.9917	69.8374	69.9	3244401.0
2013-04-12 17:00:00	QQQ	ETF	69.91	69.91	69.87	69.9	2600.0
2013-04-12 18:00:00	QQQ	ETF	69.9	70.01	69.9	69.92	9191.0
2013-04-12 19:00:00	QQQ	ETF	69.96	69.97	69.95	69.95	2700.0
2013-04-12 05:00:00	IWM	ETF	93.9	93.9	93.9	93.9	1400.0
2013-04-12 06:00:00	IWM	ETF	93.91	93.95	93.9	93.95	4100.0
2013-04-12 07:00:00	IWM	ETF	93.95	93.95	93.75	93.75	303780.0
2013-04-12 08:00:00	IWM	ETF	93.76	93.95	93.52	93.69	2361835.0
2013-04-12 09:00:00	IWM	ETF	93.68	93.94	93.53	93.658	5002983.0
2013-04-12 10:00:00	IWM	ETF	93.65	93.73	93.03	93.14	8778440.0
2013-04-12 11:00:00	IWM	ETF	93.14	93.67	92.915	93.61	8057359.0
2013-04-12 12:00:00	IWM	ETF	93.61	93.64	93.32	93.45	2440002.0
2013-04-12 13:00:00	IWM	ETF	93.45	93.58	93.349	93.45	3496399.0
2013-04-12 14:00:00	IWM	ETF	93.46	93.51	93.29	93.47	1910018.0
2013-04-12 15:00:00	IWM	ETF	93.46	93.68	93.438	93.61	5325948.0
2013-04-12 16:00:00	IWM	ETF	93.61	93.64	93.4664	93.48	1521222.0
2013-04-12 17:00:00	IWM	ETF	93.49	93.5	93.44	93.48	33797.0
2013-04-12 18:00:00	IWM	ETF	93.5	93.5	93.5	93.5	4000.0
2013-04-12 19:00:00	IWM	ETF	93.46	93.46	93.46	93.46	1000.0
2013-04-12 06:00:00	DIA	ETF	148.09	148.12	148.09	148.1	30093.0
2013-04-12 07:00:00	DIA	ETF	148.16	148.16	148.01	148.01	94850.0
2013-04-12 08:00:00	DIA	ETF	148.03	148.05	147.78	148.0	63874.0

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

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