PREVIEW / etf_30min / 2012-05-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-22.parquet
  size:    294 KB
  rows:    9,955

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-22 04:00:00	SPY	ETF	132.35	132.38	132.29	132.29	3632.0
2012-05-22 04:30:00	SPY	ETF	132.27	132.27	132.27	132.27	200.0
2012-05-22 05:00:00	SPY	ETF	131.95	132.14	131.91	131.99	17270.0
2012-05-22 05:30:00	SPY	ETF	132.09	132.1	131.98	132.01	2850.0
2012-05-22 06:00:00	SPY	ETF	131.9	131.96	131.8	131.9	25390.0
2012-05-22 06:30:00	SPY	ETF	131.94	131.94	131.88	131.88	4000.0
2012-05-22 07:00:00	SPY	ETF	131.99	132.47	131.99	132.45	839608.0
2012-05-22 07:30:00	SPY	ETF	132.45	132.56	132.37	132.54	527422.0
2012-05-22 08:00:00	SPY	ETF	132.5	132.6	132.37	132.5	2074409.0
2012-05-22 08:30:00	SPY	ETF	132.5	132.5	132.1	132.17	830859.0
2012-05-22 09:00:00	SPY	ETF	132.18	132.36	131.88	132.31	1834145.0
2012-05-22 09:30:00	SPY	ETF	132.31	132.52	131.97	132.26	19275838.0
2012-05-22 10:00:00	SPY	ETF	132.25	133.03	132.25	132.87	17906465.0
2012-05-22 10:30:00	SPY	ETF	132.87	133.17	132.87	133.13	12786338.0
2012-05-22 11:00:00	SPY	ETF	133.14	133.23	132.99	133.08	11009172.0
2012-05-22 11:30:00	SPY	ETF	133.08	133.125	132.72	132.76	10204091.0
2012-05-22 12:00:00	SPY	ETF	132.77	132.8	132.32	132.68	12904024.0
2012-05-22 12:30:00	SPY	ETF	132.68	132.83	132.59	132.7199	6154388.0
2012-05-22 13:00:00	SPY	ETF	132.715	132.88	132.54	132.55	6389511.0
2012-05-22 13:30:00	SPY	ETF	132.55	132.72	132.33	132.5325	8194023.0
2012-05-22 14:00:00	SPY	ETF	132.53	132.87	132.51	132.71	6603859.0
2012-05-22 14:30:00	SPY	ETF	132.71	132.82	132.44	132.57	7446539.0
2012-05-22 15:00:00	SPY	ETF	132.56	132.66	131.97	131.97	13289155.0
2012-05-22 15:30:00	SPY	ETF	131.97	132.1	131.34	132.07	36654571.0
2012-05-22 16:00:00	SPY	ETF	132.09	132.34	131.8	132.1	14306103.0
2012-05-22 16:30:00	SPY	ETF	132.1	132.17	131.92	131.98	5712755.0
2012-05-22 17:00:00	SPY	ETF	132.01	132.06	131.92	131.92	244028.0
2012-05-22 17:30:00	SPY	ETF	131.94	131.96	131.91	131.91	32853.0
2012-05-22 18:00:00	SPY	ETF	131.91	131.96	131.88	131.95	110212.0
2012-05-22 18:30:00	SPY	ETF	131.95	131.96	131.82	131.86	48730.0
2012-05-22 19:00:00	SPY	ETF	131.86	131.86	131.72	131.73	33922.0
2012-05-22 19:30:00	SPY	ETF	131.74	131.74	131.65	131.71	88589.0
2012-05-22 05:00:00	QQQ	ETF	62.46	62.46	62.44	62.44	17000.0
2012-05-22 05:30:00	QQQ	ETF	62.45	62.46	62.45	62.46	3000.0
2012-05-22 06:00:00	QQQ	ETF	62.39	62.39	62.38	62.38	200.0
2012-05-22 06:30:00	QQQ	ETF	62.41	62.41	62.39	62.41	6800.0
2012-05-22 07:00:00	QQQ	ETF	62.44	62.65	62.44	62.62	38650.0
2012-05-22 07:30:00	QQQ	ETF	62.63	62.74	62.59	62.74	416838.0
2012-05-22 08:00:00	QQQ	ETF	62.72	62.77	62.6688	62.7	2011998.0
2012-05-22 08:30:00	QQQ	ETF	62.72	62.72	62.52	62.57	202968.0
2012-05-22 09:00:00	QQQ	ETF	62.57	62.68	62.53	62.67	452356.0
2012-05-22 09:30:00	QQQ	ETF	62.67	62.77	62.4199	62.6372	6884894.0
2012-05-22 10:00:00	QQQ	ETF	62.63	62.88	62.6	62.715	4492687.0
2012-05-22 10:30:00	QQQ	ETF	62.71	62.95	62.7	62.82	4494835.0
2012-05-22 11:00:00	QQQ	ETF	62.8201	62.9301	62.77	62.89	3385229.0
2012-05-22 11:30:00	QQQ	ETF	62.89	62.92	62.7	62.7201	1904821.0
2012-05-22 12:00:00	QQQ	ETF	62.72	62.74	62.48	62.7	3389526.0
2012-05-22 12:30:00	QQQ	ETF	62.7	62.78	62.62	62.75	2018555.0
2012-05-22 13:00:00	QQQ	ETF	62.75	62.87	62.62	62.63	2392532.0
2012-05-22 13:30:00	QQQ	ETF	62.62	62.73	62.51	62.6	1657846.0

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

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