PREVIEW / etf_30min / 2012-05-11

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-11.parquet
  size:    280 KB
  rows:    9,388

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-11 04:30:00	SPY	ETF	135.7	135.76	135.7	135.76	600.0
2012-05-11 05:00:00	SPY	ETF	135.7	135.7	135.7	135.7	1090.0
2012-05-11 05:30:00	SPY	ETF	135.48	135.6	135.48	135.6	4860.0
2012-05-11 06:00:00	SPY	ETF	135.6	135.83	135.57	135.67	6550.0
2012-05-11 06:30:00	SPY	ETF	135.65	135.68	135.49	135.49	25080.0
2012-05-11 07:00:00	SPY	ETF	135.49	135.67	135.38	135.61	190413.0
2012-05-11 07:30:00	SPY	ETF	135.62	135.78	135.54	135.68	333024.0
2012-05-11 08:00:00	SPY	ETF	135.67	135.9	135.35	135.44	697373.0
2012-05-11 08:30:00	SPY	ETF	135.47	135.52	135.17	135.3	1037774.0
2012-05-11 09:00:00	SPY	ETF	135.3	135.35	135.14	135.18	1342091.0
2012-05-11 09:30:00	SPY	ETF	135.17	135.89	135.11	135.68	20137636.0
2012-05-11 10:00:00	SPY	ETF	135.6814	136.38	135.681	136.25	18289707.0
2012-05-11 10:30:00	SPY	ETF	136.24	136.7	136.24	136.45	14068239.0
2012-05-11 11:00:00	SPY	ETF	136.45	136.79	136.34	136.68	8600575.0
2012-05-11 11:30:00	SPY	ETF	136.68	136.87	136.45	136.5699	7085527.0
2012-05-11 12:00:00	SPY	ETF	136.5668	136.61	136.4	136.455	4014277.0
2012-05-11 12:30:00	SPY	ETF	136.45	136.54	136.32	136.36	4405231.0
2012-05-11 13:00:00	SPY	ETF	136.38	136.38	136.09	136.19	5981127.0
2012-05-11 13:30:00	SPY	ETF	136.18	136.38	136.07	136.185	6545224.0
2012-05-11 14:00:00	SPY	ETF	136.1883	136.25	135.98	136.11	7749436.0
2012-05-11 14:30:00	SPY	ETF	136.11	136.13	135.88	135.97	9020351.0
2012-05-11 15:00:00	SPY	ETF	135.97	136.05	135.76	135.89	10390924.0
2012-05-11 15:30:00	SPY	ETF	135.89	135.92	135.53	135.57	18450572.0
2012-05-11 16:00:00	SPY	ETF	135.56	136.4511	135.41	135.41	9822182.0
2012-05-11 16:30:00	SPY	ETF	135.41	135.9275	135.363	135.51	2163967.0
2012-05-11 17:00:00	SPY	ETF	135.5	135.54	135.43	135.49	78114.0
2012-05-11 17:30:00	SPY	ETF	135.52	135.57	135.46	135.54	17011.0
2012-05-11 18:00:00	SPY	ETF	135.53	135.53	135.5	135.51	4126.0
2012-05-11 18:30:00	SPY	ETF	135.53	135.56	135.51	135.56	2010.0
2012-05-11 19:00:00	SPY	ETF	135.52	135.6	135.51	135.55	19183.0
2012-05-11 19:30:00	SPY	ETF	135.53	135.58	135.52	135.58	18738.0
2012-05-11 20:00:00	SPY	ETF	135.6	135.6	135.6	135.6	200.0
2012-05-11 04:00:00	QQQ	ETF	64.0	64.0	64.0	64.0	314.0
2012-05-11 07:00:00	QQQ	ETF	64.06	64.2	64.06	64.2	11780.0
2012-05-11 07:30:00	QQQ	ETF	64.2	64.29	64.18	64.22	13050.0
2012-05-11 08:00:00	QQQ	ETF	64.2	64.2	63.95	64.05	363140.0
2012-05-11 08:30:00	QQQ	ETF	64.1	64.1	63.87	63.91	383698.0
2012-05-11 09:00:00	QQQ	ETF	63.92	63.95	63.82	63.95	550494.0
2012-05-11 09:30:00	QQQ	ETF	63.96	64.43	63.91	64.33	6882089.0
2012-05-11 10:00:00	QQQ	ETF	64.33	64.735	64.33	64.6799	7712001.0
2012-05-11 10:30:00	QQQ	ETF	64.679	64.86	64.67	64.73	4745153.0
2012-05-11 11:00:00	QQQ	ETF	64.73	64.815	64.65	64.74	2324700.0
2012-05-11 11:30:00	QQQ	ETF	64.75	64.8486	64.67	64.71	1825260.0
2012-05-11 12:00:00	QQQ	ETF	64.7	64.72	64.57	64.62	1384470.0
2012-05-11 12:30:00	QQQ	ETF	64.61	64.7	64.55	64.5971	1415113.0
2012-05-11 13:00:00	QQQ	ETF	64.59	64.6	64.48	64.5674	1619922.0
2012-05-11 13:30:00	QQQ	ETF	64.57	64.66	64.52	64.6	1168179.0
2012-05-11 14:00:00	QQQ	ETF	64.6	64.619	64.47	64.54	1629976.0
2012-05-11 14:30:00	QQQ	ETF	64.54	64.541	64.39	64.43	1704579.0
2012-05-11 15:00:00	QQQ	ETF	64.44	64.4883	64.32	64.41	2469080.0

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

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