PREVIEW / etf_30min / 2011-03-28

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-03-28.parquet
  size:    270 KB
  rows:    9,109

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-03-28 04:00:00	SPY	ETF	131.55	131.71	131.55	131.71	1100.0
2011-03-28 04:30:00	SPY	ETF	131.69	131.7	131.65	131.65	9900.0
2011-03-28 05:00:00	SPY	ETF	131.75	131.76	131.65	131.65	7500.0
2011-03-28 05:30:00	SPY	ETF	131.5	131.55	131.48	131.54	5600.0
2011-03-28 06:00:00	SPY	ETF	131.47	131.57	131.47	131.52	15200.0
2011-03-28 06:30:00	SPY	ETF	131.46	131.59	131.46	131.59	21400.0
2011-03-28 07:00:00	SPY	ETF	131.56	131.7	131.53	131.59	89100.0
2011-03-28 07:30:00	SPY	ETF	131.59	131.7	131.59	131.61	174544.0
2011-03-28 08:00:00	SPY	ETF	131.62	131.65	131.38	131.51	786292.0
2011-03-28 08:30:00	SPY	ETF	131.52	131.64	131.47	131.61	496012.0
2011-03-28 09:00:00	SPY	ETF	131.61	131.68	131.53	131.59	467557.0
2011-03-28 09:30:00	SPY	ETF	131.58	131.85	131.46	131.7499	13039750.0
2011-03-28 10:00:00	SPY	ETF	131.75	131.91	131.63	131.79	8416050.0
2011-03-28 10:30:00	SPY	ETF	131.79	131.92	131.59	131.62	7933205.0
2011-03-28 11:00:00	SPY	ETF	131.62	131.65	131.48	131.63	5808595.0
2011-03-28 11:30:00	SPY	ETF	131.63	131.65	131.35	131.5	6283281.0
2011-03-28 12:00:00	SPY	ETF	131.49	131.56	131.41	131.45	4506383.0
2011-03-28 12:30:00	SPY	ETF	131.46	131.56	131.45	131.54	3522241.0
2011-03-28 13:00:00	SPY	ETF	131.54	131.67	131.53	131.59	3084641.0
2011-03-28 13:30:00	SPY	ETF	131.59	131.63	131.49	131.49	2307099.0
2011-03-28 14:00:00	SPY	ETF	131.5	131.51	131.38	131.455	3124301.0
2011-03-28 14:30:00	SPY	ETF	131.46	131.61	131.38	131.42	5691575.0
2011-03-28 15:00:00	SPY	ETF	131.43	131.55	131.37	131.4199	8386662.0
2011-03-28 15:30:00	SPY	ETF	131.415	131.47	130.94	130.97	21682101.0
2011-03-28 16:00:00	SPY	ETF	130.97	131.0126	130.62	130.66	11268803.0
2011-03-28 16:30:00	SPY	ETF	130.68	130.76	130.67	130.69	422111.0
2011-03-28 17:00:00	SPY	ETF	130.69	130.72	130.6	130.63	113776.0
2011-03-28 17:30:00	SPY	ETF	130.65	130.74	130.65	130.66	18132.0
2011-03-28 18:00:00	SPY	ETF	130.65	130.94	130.61	130.68	77698.0
2011-03-28 18:30:00	SPY	ETF	130.7	130.94	130.64	130.67	814642.0
2011-03-28 19:00:00	SPY	ETF	130.64	130.68	130.6	130.65	33906.0
2011-03-28 19:30:00	SPY	ETF	130.64	130.64	130.58	130.58	42741.0
2011-03-28 04:00:00	QQQ	ETF	56.84	56.84	56.84	56.84	200.0
2011-03-28 04:30:00	QQQ	ETF	57.11	57.11	57.11	57.11	100.0
2011-03-28 05:00:00	QQQ	ETF	57.15	57.15	57.13	57.13	2900.0
2011-03-28 05:30:00	QQQ	ETF	57.04	57.08	57.04	57.08	600.0
2011-03-28 06:00:00	QQQ	ETF	57.09	57.09	57.08	57.08	200.0
2011-03-28 06:30:00	QQQ	ETF	57.07	57.07	57.07	57.07	100.0
2011-03-28 07:00:00	QQQ	ETF	57.08	57.1	57.05	57.07	62392.0
2011-03-28 07:30:00	QQQ	ETF	57.09	57.14	57.08	57.1	135719.0
2011-03-28 08:00:00	QQQ	ETF	57.08	57.1	56.97	57.03	127705.0
2011-03-28 08:30:00	QQQ	ETF	57.04	57.08	57.01	57.07	65450.0
2011-03-28 09:00:00	QQQ	ETF	57.06	57.11	57.04	57.09	572824.0
2011-03-28 09:30:00	QQQ	ETF	57.09	57.1	56.84	56.94	6095996.0
2011-03-28 10:00:00	QQQ	ETF	56.95	57.03	56.85	56.93	3028170.0
2011-03-28 10:30:00	QQQ	ETF	56.93	57.06	56.88	56.92	2126850.0
2011-03-28 11:00:00	QQQ	ETF	56.92	56.97	56.85	56.93	1306774.0
2011-03-28 11:30:00	QQQ	ETF	56.94	56.94	56.72	56.86	1833412.0
2011-03-28 12:00:00	QQQ	ETF	56.85	56.9	56.82	56.84	761512.0
2011-03-28 12:30:00	QQQ	ETF	56.84	56.88	56.83	56.86	517783.0

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

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