PREVIEW / etf_30min / 2012-07-18

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-18.parquet
  size:    283 KB
  rows:    9,431

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-18 04:00:00	SPY	ETF	136.04	136.11	136.04	136.11	800.0
2012-07-18 04:30:00	SPY	ETF	136.26	136.3	136.26	136.29	6076.0
2012-07-18 05:00:00	SPY	ETF	136.23	136.23	136.03	136.1	2400.0
2012-07-18 05:30:00	SPY	ETF	136.09	136.1	135.98	135.99	3982.0
2012-07-18 06:00:00	SPY	ETF	135.95	136.03	135.94	136.01	1900.0
2012-07-18 06:30:00	SPY	ETF	136.06	136.06	136.0	136.0	6195.0
2012-07-18 07:00:00	SPY	ETF	136.03	136.05	135.91	136.02	117363.0
2012-07-18 07:30:00	SPY	ETF	136.05	136.11	135.98	136.03	142600.0
2012-07-18 08:00:00	SPY	ETF	136.03	136.15	135.94	136.13	813714.0
2012-07-18 08:30:00	SPY	ETF	136.14	136.23	135.88	135.96	395462.0
2012-07-18 09:00:00	SPY	ETF	135.95	136.05	135.87	136.03	737247.0
2012-07-18 09:30:00	SPY	ETF	136.04	136.93	135.96	136.79	15437502.0
2012-07-18 10:00:00	SPY	ETF	136.7999	137.12	136.76	136.89	9305449.0
2012-07-18 10:30:00	SPY	ETF	136.885	137.28	136.75	137.23	8158028.0
2012-07-18 11:00:00	SPY	ETF	137.23	137.26	137.04	137.08	5199501.0
2012-07-18 11:30:00	SPY	ETF	137.09	137.34	137.08	137.25	6503940.0
2012-07-18 12:00:00	SPY	ETF	137.25	137.64	137.24	137.518	8957688.0
2012-07-18 12:30:00	SPY	ETF	137.51	137.61	137.46	137.52	4073333.0
2012-07-18 13:00:00	SPY	ETF	137.53	137.561	137.46	137.5199	3205602.0
2012-07-18 13:30:00	SPY	ETF	137.51	137.52	137.22	137.32	7169379.0
2012-07-18 14:00:00	SPY	ETF	137.32	137.45	137.26	137.4	4159361.0
2012-07-18 14:30:00	SPY	ETF	137.41	137.42	136.95	137.11	7581714.0
2012-07-18 15:00:00	SPY	ETF	137.12	137.47	137.12	137.31	6955079.0
2012-07-18 15:30:00	SPY	ETF	137.32	137.47	137.2	137.35	14640008.0
2012-07-18 16:00:00	SPY	ETF	137.35	137.5266	136.0414	137.37	7033478.0
2012-07-18 16:30:00	SPY	ETF	137.36	137.64	137.32	137.6	440857.0
2012-07-18 17:00:00	SPY	ETF	137.62	137.75	137.6	137.72	247656.0
2012-07-18 17:30:00	SPY	ETF	137.73	137.73	137.66	137.68	161866.0
2012-07-18 18:00:00	SPY	ETF	137.69	137.75	137.53	137.6	76460.0
2012-07-18 18:30:00	SPY	ETF	137.58	137.6	137.55	137.57	15246.0
2012-07-18 19:00:00	SPY	ETF	137.55	137.57	137.5	137.54	18965.0
2012-07-18 19:30:00	SPY	ETF	137.54	137.57	137.51	137.57	17588.0
2012-07-18 05:30:00	QQQ	ETF	63.44	63.44	63.44	63.44	400.0
2012-07-18 07:00:00	QQQ	ETF	63.39	63.41	63.36	63.4	184915.0
2012-07-18 07:30:00	QQQ	ETF	63.4	63.41	63.37	63.39	33544.0
2012-07-18 08:00:00	QQQ	ETF	63.38	63.46	63.38	63.45	63194.0
2012-07-18 08:30:00	QQQ	ETF	63.46	63.48	63.33	63.37	120830.0
2012-07-18 09:00:00	QQQ	ETF	63.39	63.44	63.34	63.38	413317.0
2012-07-18 09:30:00	QQQ	ETF	63.39	64.1	63.39	64.05	5434518.0
2012-07-18 10:00:00	QQQ	ETF	64.05	64.24	64.04	64.098	3963151.0
2012-07-18 10:30:00	QQQ	ETF	64.1	64.26	64.02	64.22	3424805.0
2012-07-18 11:00:00	QQQ	ETF	64.222	64.25	64.15	64.22	1746600.0
2012-07-18 11:30:00	QQQ	ETF	64.22	64.4	64.22	64.3625	1965385.0
2012-07-18 12:00:00	QQQ	ETF	64.37	64.58	64.36	64.5011	3520230.0
2012-07-18 12:30:00	QQQ	ETF	64.5	64.56	64.47	64.51	1389801.0
2012-07-18 13:00:00	QQQ	ETF	64.51	64.54	64.4618	64.49	1150841.0
2012-07-18 13:30:00	QQQ	ETF	64.49	64.49	64.32	64.37	1572210.0
2012-07-18 14:00:00	QQQ	ETF	64.37	64.44	64.35	64.39	1184538.0
2012-07-18 14:30:00	QQQ	ETF	64.39	64.4	64.16	64.25	1849803.0
2012-07-18 15:00:00	QQQ	ETF	64.25	64.41	64.25	64.34	1883987.0

> showing 50 of 9,431 rows — these rows as CSV

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