PREVIEW / etf_30min / 2012-05-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-25.parquet
  size:    265 KB
  rows:    8,992

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-25 04:00:00	SPY	ETF	133.12	133.5	133.12	133.5	3685.0
2012-05-25 04:30:00	SPY	ETF	133.44	133.44	133.25	133.25	4420.0
2012-05-25 05:00:00	SPY	ETF	133.23	133.33	133.11	133.15	7102.0
2012-05-25 05:30:00	SPY	ETF	133.05	133.14	133.04	133.14	63850.0
2012-05-25 06:00:00	SPY	ETF	133.16	133.28	133.14	133.25	8700.0
2012-05-25 06:30:00	SPY	ETF	133.18	133.21	132.72	132.84	222770.0
2012-05-25 07:00:00	SPY	ETF	132.85	133.02	132.81	132.92	144128.0
2012-05-25 07:30:00	SPY	ETF	132.92	132.98	132.79	132.83	150900.0
2012-05-25 08:00:00	SPY	ETF	132.85	133.0601	132.43	132.5	1562956.0
2012-05-25 08:30:00	SPY	ETF	132.48	132.67	132.42	132.43	1440973.0
2012-05-25 09:00:00	SPY	ETF	132.42	132.61	132.4	132.47	782669.0
2012-05-25 09:30:00	SPY	ETF	132.48	132.85	132.36	132.7	16446579.0
2012-05-25 10:00:00	SPY	ETF	132.7	132.75	132.26	132.5399	11659684.0
2012-05-25 10:30:00	SPY	ETF	132.54	132.8	132.31	132.36	9730283.0
2012-05-25 11:00:00	SPY	ETF	132.36	132.76	132.35	132.68	8088050.0
2012-05-25 11:30:00	SPY	ETF	132.67	132.73	132.42	132.64	8354229.0
2012-05-25 12:00:00	SPY	ETF	132.63	132.66	132.3	132.33	9448216.0
2012-05-25 12:30:00	SPY	ETF	132.33	132.51	132.3	132.405	5959180.0
2012-05-25 13:00:00	SPY	ETF	132.41	132.52	132.32	132.49	6212684.0
2012-05-25 13:30:00	SPY	ETF	132.49	132.53	132.37	132.415	5192381.0
2012-05-25 14:00:00	SPY	ETF	132.42	132.45	132.09	132.23	6373807.0
2012-05-25 14:30:00	SPY	ETF	132.23	132.33	132.0	132.12	5586742.0
2012-05-25 15:00:00	SPY	ETF	132.129	132.27	131.78	131.96	9226013.0
2012-05-25 15:30:00	SPY	ETF	131.97	132.22	131.89	132.14	14742978.0
2012-05-25 16:00:00	SPY	ETF	132.14	132.7	131.5355	132.15	8004334.0
2012-05-25 16:30:00	SPY	ETF	132.12	132.2371	132.11	132.18	2251138.0
2012-05-25 17:00:00	SPY	ETF	132.18	132.18	132.0	132.0	136483.0
2012-05-25 17:30:00	SPY	ETF	132.01	132.08	131.96	132.0	70334.0
2012-05-25 18:00:00	SPY	ETF	132.0	132.04	131.95	131.99	39872.0
2012-05-25 18:30:00	SPY	ETF	131.99	131.99	131.96	131.98	19200.0
2012-05-25 19:00:00	SPY	ETF	132.0	132.01	131.99	132.01	1600.0
2012-05-25 19:30:00	SPY	ETF	131.99	132.04	131.96	132.04	11682.0
2012-05-25 04:00:00	QQQ	ETF	62.5	62.65	62.5	62.65	500.0
2012-05-25 04:30:00	QQQ	ETF	62.64	62.64	62.64	62.64	100.0
2012-05-25 06:00:00	QQQ	ETF	62.59	62.59	62.59	62.59	100.0
2012-05-25 06:30:00	QQQ	ETF	62.54	62.54	62.43	62.43	6000.0
2012-05-25 07:00:00	QQQ	ETF	62.39	62.46	62.39	62.43	42900.0
2012-05-25 07:30:00	QQQ	ETF	62.46	62.46	62.35	62.37	126700.0
2012-05-25 08:00:00	QQQ	ETF	62.38	62.41	62.22	62.24	186695.0
2012-05-25 08:30:00	QQQ	ETF	62.21	62.31	62.15	62.15	277220.0
2012-05-25 09:00:00	QQQ	ETF	62.15	62.23	62.14	62.19	168429.0
2012-05-25 09:30:00	QQQ	ETF	62.2	62.3201	62.11	62.23	4104684.0
2012-05-25 10:00:00	QQQ	ETF	62.23	62.26	61.94	62.0608	3632743.0
2012-05-25 10:30:00	QQQ	ETF	62.06	62.23	61.95	61.97	2841381.0
2012-05-25 11:00:00	QQQ	ETF	61.97	62.16	61.97	62.13	1731441.0
2012-05-25 11:30:00	QQQ	ETF	62.13	62.1301	61.96	62.08	2202878.0
2012-05-25 12:00:00	QQQ	ETF	62.08	62.1301	61.9999	62.01	1395459.0
2012-05-25 12:30:00	QQQ	ETF	62.01	62.13	61.99	62.09	997516.0
2012-05-25 13:00:00	QQQ	ETF	62.08	62.1895	62.04	62.17	745488.0
2012-05-25 13:30:00	QQQ	ETF	62.169	62.27	62.15	62.18	1403715.0

> showing 50 of 8,992 rows — these rows as CSV

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