PREVIEW / etf_1hour / 2012-08-09

all etf 1-hour files

  file:    by_date/etf_1hour/2012/2012-08-09.parquet
  size:    179 KB
  rows:    5,555

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-08-09 04:00:00	SPY	ETF	140.45	140.55	140.45	140.47	1130.0
2012-08-09 05:00:00	SPY	ETF	140.5	140.57	140.5	140.57	510.0
2012-08-09 06:00:00	SPY	ETF	140.63	140.65	140.29	140.29	38430.0
2012-08-09 07:00:00	SPY	ETF	140.25	140.4	140.0	140.21	205172.0
2012-08-09 08:00:00	SPY	ETF	140.21	140.45	140.1	140.31	2737252.0
2012-08-09 09:00:00	SPY	ETF	140.32	140.75	140.15	140.46	12378173.0
2012-08-09 10:00:00	SPY	ETF	140.46	140.89	140.46	140.8	12892862.0
2012-08-09 11:00:00	SPY	ETF	140.8	140.825	140.15	140.2604	15180537.0
2012-08-09 12:00:00	SPY	ETF	140.27	140.65	140.2	140.65	11773531.0
2012-08-09 13:00:00	SPY	ETF	140.65	140.71	140.51	140.55	7130440.0
2012-08-09 14:00:00	SPY	ETF	140.5509	140.78	140.51	140.6701	7760636.0
2012-08-09 15:00:00	SPY	ETF	140.67	140.73	140.45	140.58	12397322.0
2012-08-09 16:00:00	SPY	ETF	140.61	140.72	140.4	140.63	2322583.0
2012-08-09 17:00:00	SPY	ETF	140.64	140.64	140.51	140.54	4556272.0
2012-08-09 18:00:00	SPY	ETF	140.57	140.66	140.54	140.66	34045.0
2012-08-09 19:00:00	SPY	ETF	140.66	140.66	140.5	140.53	162769.0
2012-08-09 06:00:00	QQQ	ETF	66.59	66.59	66.59	66.59	100.0
2012-08-09 07:00:00	QQQ	ETF	66.58	66.63	66.46	66.57	26225.0
2012-08-09 08:00:00	QQQ	ETF	66.55	66.73	66.49	66.63	708791.0
2012-08-09 09:00:00	QQQ	ETF	66.64	66.88	66.57	66.76	2235619.0
2012-08-09 10:00:00	QQQ	ETF	66.77	66.91	66.75	66.8499	3091394.0
2012-08-09 11:00:00	QQQ	ETF	66.85	66.86	66.49	66.56	3123750.0
2012-08-09 12:00:00	QQQ	ETF	66.56	66.728	66.52	66.728	3135958.0
2012-08-09 13:00:00	QQQ	ETF	66.72	66.76	66.67	66.72	1166605.0
2012-08-09 14:00:00	QQQ	ETF	66.72	66.82	66.69	66.77	1222152.0
2012-08-09 15:00:00	QQQ	ETF	66.77	66.815	66.7	66.79	5258203.0
2012-08-09 16:00:00	QQQ	ETF	66.8	66.84	66.78	66.8	375642.0
2012-08-09 17:00:00	QQQ	ETF	66.8	66.8	66.76	66.8	14760.0
2012-08-09 18:00:00	QQQ	ETF	66.77	66.8	66.76	66.8	7810.0
2012-08-09 19:00:00	QQQ	ETF	66.78	66.78	66.71	66.74	46444.0
2012-08-09 07:00:00	IWM	ETF	79.77	79.77	79.58	79.66	172923.0
2012-08-09 08:00:00	IWM	ETF	79.65	80.0	79.61	79.86	518123.0
2012-08-09 09:00:00	IWM	ETF	79.85	80.14	79.69	79.89	3129457.0
2012-08-09 10:00:00	IWM	ETF	79.9	80.31	79.87	80.21	3321134.0
2012-08-09 11:00:00	IWM	ETF	80.22	80.39	79.85	79.94	3723495.0
2012-08-09 12:00:00	IWM	ETF	79.94	80.17	79.87	80.16	2789251.0
2012-08-09 13:00:00	IWM	ETF	80.16	80.19	80.02	80.1	998569.0
2012-08-09 14:00:00	IWM	ETF	80.11	80.25	80.06	80.16	1444219.0
2012-08-09 15:00:00	IWM	ETF	80.16	80.26	80.01	80.15	4957254.0
2012-08-09 16:00:00	IWM	ETF	80.16	80.25	80.1242	80.23	1057451.0
2012-08-09 17:00:00	IWM	ETF	80.19	80.19	80.16	80.16	3600.0
2012-08-09 18:00:00	IWM	ETF	80.2	80.2	80.17	80.17	670.0
2012-08-09 19:00:00	IWM	ETF	80.2	80.23	80.18	80.18	3400.0
2012-08-09 07:00:00	DIA	ETF	131.51	131.51	131.45	131.45	3000.0
2012-08-09 08:00:00	DIA	ETF	131.4	131.6	131.4	131.55	4260.0
2012-08-09 09:00:00	DIA	ETF	131.51	131.86	131.46	131.6	914572.0
2012-08-09 10:00:00	DIA	ETF	131.63	131.87	131.59	131.74	305323.0
2012-08-09 11:00:00	DIA	ETF	131.76	131.77	131.11	131.2	459904.0
2012-08-09 12:00:00	DIA	ETF	131.18	131.57	131.16	131.57	402910.0
2012-08-09 13:00:00	DIA	ETF	131.59	131.64	131.42	131.46	277673.0

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

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