PREVIEW / etf_30min / 2012-05-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-08.parquet
  size:    296 KB
  rows:    10,007

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-05-08 04:00:00	SPY	ETF	136.62	136.97	136.32	136.36	32149.0
2012-05-08 04:30:00	SPY	ETF	136.54	136.54	136.21	136.31	1742.0
2012-05-08 05:00:00	SPY	ETF	136.31	136.53	136.31	136.4	35290.0
2012-05-08 05:30:00	SPY	ETF	136.42	136.42	136.28	136.36	15500.0
2012-05-08 06:00:00	SPY	ETF	136.37	136.45	136.33	136.45	10985.0
2012-05-08 06:30:00	SPY	ETF	136.46	136.48	136.25	136.25	62785.0
2012-05-08 07:00:00	SPY	ETF	136.3	136.54	136.28	136.49	161450.0
2012-05-08 07:30:00	SPY	ETF	136.53	136.96	136.52	136.94	217903.0
2012-05-08 08:00:00	SPY	ETF	136.95	136.99	136.36	136.39	813880.0
2012-05-08 08:30:00	SPY	ETF	136.38	136.69	136.23	136.56	1017011.0
2012-05-08 09:00:00	SPY	ETF	136.56	136.58	136.27	136.29	935433.0
2012-05-08 09:30:00	SPY	ETF	136.28	136.51	136.0	136.23	20694472.0
2012-05-08 10:00:00	SPY	ETF	136.24	136.26	135.65	135.67	18267572.0
2012-05-08 10:30:00	SPY	ETF	135.67	136.44	135.23	135.39	19898466.0
2012-05-08 11:00:00	SPY	ETF	135.39	135.39	134.92	135.26	20262856.0
2012-05-08 11:30:00	SPY	ETF	135.26	135.71	135.14	135.59	17845044.0
2012-05-08 12:00:00	SPY	ETF	135.58	135.6	135.2	135.26	8916767.0
2012-05-08 12:30:00	SPY	ETF	135.27	135.39	135.155	135.18	7956285.0
2012-05-08 13:00:00	SPY	ETF	135.1893	135.6	135.17	135.581	6175180.0
2012-05-08 13:30:00	SPY	ETF	135.585	135.73	135.5	135.66	8890316.0
2012-05-08 14:00:00	SPY	ETF	135.67	135.95	135.45	135.7	7046468.0
2012-05-08 14:30:00	SPY	ETF	135.7	136.12	135.68	136.01	12654894.0
2012-05-08 15:00:00	SPY	ETF	136.01	136.68	135.9	136.57	19448235.0
2012-05-08 15:30:00	SPY	ETF	136.56	136.77	136.38	136.52	22709119.0
2012-05-08 16:00:00	SPY	ETF	136.51	136.6143	135.1599	136.43	6617290.0
2012-05-08 16:30:00	SPY	ETF	136.45	137.1261	136.44	136.52	9354528.0
2012-05-08 17:00:00	SPY	ETF	136.52	136.55	136.51	136.55	148169.0
2012-05-08 17:30:00	SPY	ETF	136.51	136.53	136.48	136.5	559124.0
2012-05-08 18:00:00	SPY	ETF	136.49	136.49	136.44	136.46	49755.0
2012-05-08 18:30:00	SPY	ETF	136.46	136.46	136.33	136.36	39890.0
2012-05-08 19:00:00	SPY	ETF	136.36	136.37	136.2	136.26	122406.0
2012-05-08 19:30:00	SPY	ETF	136.26	136.32	136.22	136.3	46225.0
2012-05-08 04:00:00	QQQ	ETF	64.54	64.54	64.54	64.54	192.0
2012-05-08 04:30:00	QQQ	ETF	64.38	64.38	64.38	64.38	100.0
2012-05-08 06:00:00	QQQ	ETF	64.36	64.38	64.36	64.38	200.0
2012-05-08 06:30:00	QQQ	ETF	64.39	64.39	64.31	64.31	200.0
2012-05-08 07:00:00	QQQ	ETF	64.36	64.44	64.36	64.43	14300.0
2012-05-08 07:30:00	QQQ	ETF	64.46	64.6	64.44	64.59	9445.0
2012-05-08 08:00:00	QQQ	ETF	64.63	64.65	64.34	64.34	110019.0
2012-05-08 08:30:00	QQQ	ETF	64.35	64.5	64.27	64.47	128480.0
2012-05-08 09:00:00	QQQ	ETF	64.43	64.45	64.3	64.34	322001.0
2012-05-08 09:30:00	QQQ	ETF	64.33	64.52	64.17	64.25	6437487.0
2012-05-08 10:00:00	QQQ	ETF	64.25	64.265	63.91	63.93	4918190.0
2012-05-08 10:30:00	QQQ	ETF	63.93	63.94	63.57	63.76	7808254.0
2012-05-08 11:00:00	QQQ	ETF	63.75	63.76	63.48	63.7	4338986.0
2012-05-08 11:30:00	QQQ	ETF	63.696	64.03	63.62	63.92	7305289.0
2012-05-08 12:00:00	QQQ	ETF	63.92	63.94	63.67	63.7595	3005073.0
2012-05-08 12:30:00	QQQ	ETF	63.75	63.82	63.66	63.68	1734591.0
2012-05-08 13:00:00	QQQ	ETF	63.69	63.97	63.68	63.96	2462103.0
2012-05-08 13:30:00	QQQ	ETF	63.97	64.09	63.92	64.06	3702432.0

> showing 50 of 10,007 rows — these rows as CSV

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