PREVIEW / etf_30min / 2011-04-14

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-04-14.parquet
  size:    274 KB
  rows:    9,180

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
2011-04-14 05:30:00	SPY	ETF	131.01	131.01	130.62	130.67	14300.0
2011-04-14 06:00:00	SPY	ETF	130.63	130.79	130.62	130.7	30200.0
2011-04-14 06:30:00	SPY	ETF	130.7	130.75	130.61	130.61	23750.0
2011-04-14 07:00:00	SPY	ETF	130.65	130.72	130.54	130.67	160006.0
2011-04-14 07:30:00	SPY	ETF	130.69	130.85	130.69	130.8	196773.0
2011-04-14 08:00:00	SPY	ETF	130.8	130.96	130.72	130.83	666035.0
2011-04-14 08:30:00	SPY	ETF	130.82	131.293	130.43	130.63	2056455.0
2011-04-14 09:00:00	SPY	ETF	130.62	130.73	130.48	130.7	751226.0
2011-04-14 09:30:00	SPY	ETF	130.7	130.88	130.27	130.65	22623451.0
2011-04-14 10:00:00	SPY	ETF	130.66	131.13	130.6	131.09	13728512.0
2011-04-14 10:30:00	SPY	ETF	131.09	131.27	130.98	131.03	11608735.0
2011-04-14 11:00:00	SPY	ETF	131.03	131.18	130.86	130.92	13796938.0
2011-04-14 11:30:00	SPY	ETF	130.93	131.07	130.78	131.04	8570109.0
2011-04-14 12:00:00	SPY	ETF	131.04	131.28	130.98	131.27	6385923.0
2011-04-14 12:30:00	SPY	ETF	131.27	131.39	131.22	131.33	5997009.0
2011-04-14 13:00:00	SPY	ETF	131.3399	131.43	131.16	131.23	7324600.0
2011-04-14 13:30:00	SPY	ETF	131.24	131.3	131.05	131.06	3813443.0
2011-04-14 14:00:00	SPY	ETF	131.06	131.39	131.06	131.29	5100692.0
2011-04-14 14:30:00	SPY	ETF	131.29	131.47	131.2	131.38	6916701.0
2011-04-14 15:00:00	SPY	ETF	131.38	131.76	131.33	131.72	15054652.0
2011-04-14 15:30:00	SPY	ETF	131.72	131.76	131.52	131.56	15708351.0
2011-04-14 16:00:00	SPY	ETF	131.56	131.62	131.1374	131.49	10711669.0
2011-04-14 16:30:00	SPY	ETF	131.49	131.5	131.43	131.49	289000.0
2011-04-14 17:00:00	SPY	ETF	131.49	131.58	131.48	131.57	2107699.0
2011-04-14 17:30:00	SPY	ETF	131.55	131.59	131.53	131.57	19856.0
2011-04-14 18:00:00	SPY	ETF	131.57	131.67	131.43	131.63	75541.0
2011-04-14 18:30:00	SPY	ETF	131.64	131.68	131.57	131.64	23265.0
2011-04-14 19:00:00	SPY	ETF	131.61	131.63	131.56	131.58	13631.0
2011-04-14 19:30:00	SPY	ETF	131.63	131.76	131.58	131.65	51394.0
2011-04-14 05:00:00	QQQ	ETF	56.62	56.62	56.62	56.62	200.0
2011-04-14 05:30:00	QQQ	ETF	56.54	56.54	56.45	56.45	3200.0
2011-04-14 06:00:00	QQQ	ETF	56.39	56.42	56.36	56.38	45286.0
2011-04-14 06:30:00	QQQ	ETF	56.38	56.4	56.34	56.34	1700.0
2011-04-14 07:00:00	QQQ	ETF	56.34	56.39	56.31	56.39	90487.0
2011-04-14 07:30:00	QQQ	ETF	56.39	56.44	56.39	56.43	168006.0
2011-04-14 08:00:00	QQQ	ETF	56.43	56.48	56.41	56.43	117024.0
2011-04-14 08:30:00	QQQ	ETF	56.43	56.44	56.31	56.41	565395.0
2011-04-14 09:00:00	QQQ	ETF	56.42	56.47	56.38	56.45	461461.0
2011-04-14 09:30:00	QQQ	ETF	56.45	56.525	56.23	56.411	6346005.0
2011-04-14 10:00:00	QQQ	ETF	56.41	56.63	56.38	56.61	5243625.0
2011-04-14 10:30:00	QQQ	ETF	56.61	56.67	56.52	56.55	3333203.0
2011-04-14 11:00:00	QQQ	ETF	56.545	56.585	56.4	56.4338	4608135.0
2011-04-14 11:30:00	QQQ	ETF	56.44	56.54	56.37	56.52	2097275.0
2011-04-14 12:00:00	QQQ	ETF	56.53	56.62	56.49	56.58	2235574.0
2011-04-14 12:30:00	QQQ	ETF	56.58	56.63	56.54	56.6	1659164.0
2011-04-14 13:00:00	QQQ	ETF	56.61	56.65	56.455	56.5	3149189.0
2011-04-14 13:30:00	QQQ	ETF	56.5	56.54	56.41	56.42	1668839.0
2011-04-14 14:00:00	QQQ	ETF	56.42	56.61	56.42	56.55	2207167.0
2011-04-14 14:30:00	QQQ	ETF	56.5529	56.68	56.53	56.632	1724414.0
2011-04-14 15:00:00	QQQ	ETF	56.64	56.83	56.61	56.8	2875695.0

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

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