PREVIEW / etf_30min / 2012-05-29

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-29.parquet
  size:    281 KB
  rows:    9,387

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-29 04:00:00	SPY	ETF	133.28	133.35	133.12	133.14	4090.0
2012-05-29 04:30:00	SPY	ETF	132.99	133.1	132.95	132.95	3987.0
2012-05-29 05:00:00	SPY	ETF	133.08	133.09	132.98	133.09	3808.0
2012-05-29 05:30:00	SPY	ETF	132.95	132.95	132.69	132.69	8450.0
2012-05-29 06:00:00	SPY	ETF	132.79	132.87	132.79	132.87	2500.0
2012-05-29 06:30:00	SPY	ETF	132.87	132.98	132.71	132.98	56647.0
2012-05-29 07:00:00	SPY	ETF	132.98	133.01	132.87	132.92	202562.0
2012-05-29 07:30:00	SPY	ETF	132.92	133.04	132.82	132.95	243177.0
2012-05-29 08:00:00	SPY	ETF	132.94	132.98	132.72	132.95	437700.0
2012-05-29 08:30:00	SPY	ETF	132.95	133.0	132.1	132.9	639930.0
2012-05-29 09:00:00	SPY	ETF	132.91	133.23	132.84	133.15	911628.0
2012-05-29 09:30:00	SPY	ETF	133.16	133.45	132.96	133.23	15494119.0
2012-05-29 10:00:00	SPY	ETF	133.27	133.81	132.94	133.73	16008876.0
2012-05-29 10:30:00	SPY	ETF	133.73	133.93	133.68	133.78	9357208.0
2012-05-29 11:00:00	SPY	ETF	133.78	133.81	133.52	133.661	9245067.0
2012-05-29 11:30:00	SPY	ETF	133.67	133.68	132.9199	133.07	16885457.0
2012-05-29 12:00:00	SPY	ETF	133.065	133.12	132.77	132.97	12376624.0
2012-05-29 12:30:00	SPY	ETF	132.97	133.14	132.75	132.945	7869682.0
2012-05-29 13:00:00	SPY	ETF	132.94	133.7	132.8	132.81	3981946.0
2012-05-29 13:30:00	SPY	ETF	132.81	133.135	132.75	133.099	7571811.0
2012-05-29 14:00:00	SPY	ETF	133.092	133.25	132.93	133.12	6296210.0
2012-05-29 14:30:00	SPY	ETF	133.12	133.33	133.0	133.29	4543994.0
2012-05-29 15:00:00	SPY	ETF	133.2905	133.44	133.19	133.37	6340012.0
2012-05-29 15:30:00	SPY	ETF	133.37	133.75	133.21	133.689	21640194.0
2012-05-29 16:00:00	SPY	ETF	133.69	133.98	132.1946	133.9	6974947.0
2012-05-29 16:30:00	SPY	ETF	133.91	133.96	133.79	133.82	659019.0
2012-05-29 17:00:00	SPY	ETF	133.84	133.85	133.71	133.75	232792.0
2012-05-29 17:30:00	SPY	ETF	133.8	133.8	133.72	133.75	14336.0
2012-05-29 18:00:00	SPY	ETF	133.75	133.77	133.6	133.63	85483.0
2012-05-29 18:30:00	SPY	ETF	133.63	133.63	133.52	133.57	156617.0
2012-05-29 19:00:00	SPY	ETF	133.57	133.61	133.57	133.58	13104.0
2012-05-29 19:30:00	SPY	ETF	133.57	133.58	133.5	133.56	191303.0
2012-05-29 04:30:00	QQQ	ETF	62.57	62.57	62.57	62.57	100.0
2012-05-29 06:00:00	QQQ	ETF	62.42	62.5	62.42	62.5	7100.0
2012-05-29 06:30:00	QQQ	ETF	62.47	62.55	62.44	62.55	10502.0
2012-05-29 07:00:00	QQQ	ETF	62.56	62.57	62.5	62.53	8650.0
2012-05-29 07:30:00	QQQ	ETF	62.5	62.52	62.46	62.49	2900.0
2012-05-29 08:00:00	QQQ	ETF	62.52	62.52	62.38	62.5	44605.0
2012-05-29 08:30:00	QQQ	ETF	62.49	62.51	62.4	62.48	56595.0
2012-05-29 09:00:00	QQQ	ETF	62.48	62.63	62.46	62.63	220832.0
2012-05-29 09:30:00	QQQ	ETF	62.63	62.65	62.4	62.56	6134224.0
2012-05-29 10:00:00	QQQ	ETF	62.56	63.08	62.44	63.02	6910207.0
2012-05-29 10:30:00	QQQ	ETF	63.02	63.15	62.95	62.98	4543430.0
2012-05-29 11:00:00	QQQ	ETF	62.98	62.99	62.84	62.93	1399845.0
2012-05-29 11:30:00	QQQ	ETF	62.93	62.94	62.46	62.5201	4199113.0
2012-05-29 12:00:00	QQQ	ETF	62.52	62.52	62.28	62.43	4425458.0
2012-05-29 12:30:00	QQQ	ETF	62.42	62.56	62.31	62.46	2126262.0
2012-05-29 13:00:00	QQQ	ETF	62.46	62.5201	62.39	62.405	1275913.0
2012-05-29 13:30:00	QQQ	ETF	62.4003	62.58	62.35	62.5601	1473404.0
2012-05-29 14:00:00	QQQ	ETF	62.562	62.7	62.51	62.6401	1366273.0

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

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