PREVIEW / etf_30min / 2012-02-28

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-28.parquet
  size:    291 KB
  rows:    9,809

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-02-28 04:00:00	SPY	ETF	137.47	137.72	137.47	137.58	78530.0
2012-02-28 04:30:00	SPY	ETF	137.62	137.7	137.46	137.66	15955.0
2012-02-28 05:00:00	SPY	ETF	137.62	137.68	137.61	137.61	14700.0
2012-02-28 05:30:00	SPY	ETF	137.6	137.69	137.6	137.65	16000.0
2012-02-28 06:00:00	SPY	ETF	137.7	137.75	137.66	137.73	111930.0
2012-02-28 06:30:00	SPY	ETF	137.71	137.71	137.61	137.71	19700.0
2012-02-28 07:00:00	SPY	ETF	137.62	137.75	137.62	137.71	89260.0
2012-02-28 07:30:00	SPY	ETF	137.73	137.8	137.69	137.69	179986.0
2012-02-28 08:00:00	SPY	ETF	137.67	137.72	137.6	137.7	503086.0
2012-02-28 08:30:00	SPY	ETF	137.7	137.7	137.11	137.22	3942020.0
2012-02-28 09:00:00	SPY	ETF	137.22	137.33	137.09	137.2	1215238.0
2012-02-28 09:30:00	SPY	ETF	137.2	137.52	136.93	137.52	14451008.0
2012-02-28 10:00:00	SPY	ETF	137.37	137.72	137.05	137.28	21385708.0
2012-02-28 10:30:00	SPY	ETF	137.29	137.62	137.285	137.48	12303740.0
2012-02-28 11:00:00	SPY	ETF	137.48	137.66	137.4	137.56	9524707.0
2012-02-28 11:30:00	SPY	ETF	137.56	137.63	137.42	137.52	6158528.0
2012-02-28 12:00:00	SPY	ETF	137.52	137.59	137.43	137.461	4114418.0
2012-02-28 12:30:00	SPY	ETF	137.47	137.6	137.43	137.56	3135795.0
2012-02-28 13:00:00	SPY	ETF	137.56	137.6	137.47	137.51	2967580.0
2012-02-28 13:30:00	SPY	ETF	137.51	137.515	137.09	137.18	10288395.0
2012-02-28 14:00:00	SPY	ETF	137.18	137.27	137.09	137.1184	7676093.0
2012-02-28 14:30:00	SPY	ETF	137.11	137.33	137.09	137.29	6086369.0
2012-02-28 15:00:00	SPY	ETF	137.29	137.525	137.24	137.51	6014652.0
2012-02-28 15:30:00	SPY	ETF	137.51	137.66	137.43	137.56	13415774.0
2012-02-28 16:00:00	SPY	ETF	137.56	137.65	136.94	137.59	4677293.0
2012-02-28 16:30:00	SPY	ETF	137.59	137.64	137.3772	137.55	339032.0
2012-02-28 17:00:00	SPY	ETF	137.55	137.61	137.53	137.59	62820.0
2012-02-28 17:30:00	SPY	ETF	137.56	137.6	137.3741	137.55	16234.0
2012-02-28 18:00:00	SPY	ETF	137.56	137.62	137.54	137.6	121538.0
2012-02-28 18:30:00	SPY	ETF	137.61	137.63	137.59	137.6	12850.0
2012-02-28 19:00:00	SPY	ETF	137.58	137.65	137.54	137.61	21185.0
2012-02-28 19:30:00	SPY	ETF	137.63	137.71	137.63	137.71	54616.0
2012-02-28 06:30:00	QQQ	ETF	64.29	64.29	64.29	64.29	300.0
2012-02-28 07:00:00	QQQ	ETF	64.23	64.29	64.23	64.27	4500.0
2012-02-28 07:30:00	QQQ	ETF	64.3	64.32	64.29	64.29	43253.0
2012-02-28 08:00:00	QQQ	ETF	64.3	64.3	64.25	64.27	71786.0
2012-02-28 08:30:00	QQQ	ETF	64.26	64.26	64.07	64.08	300125.0
2012-02-28 09:00:00	QQQ	ETF	64.08	64.15	64.06	64.09	54946.0
2012-02-28 09:30:00	QQQ	ETF	64.09	64.39	64.03	64.35	4642975.0
2012-02-28 10:00:00	QQQ	ETF	64.32	64.45	64.21	64.4115	7894278.0
2012-02-28 10:30:00	QQQ	ETF	64.413	64.5999	64.41	64.5	4786269.0
2012-02-28 11:00:00	QQQ	ETF	64.4991	64.58	64.45	64.55	2077920.0
2012-02-28 11:30:00	QQQ	ETF	64.545	64.57	64.49	64.528	1610948.0
2012-02-28 12:00:00	QQQ	ETF	64.52	64.58	64.5144	64.54	1402107.0
2012-02-28 12:30:00	QQQ	ETF	64.54	64.64	64.52	64.619	1460194.0
2012-02-28 13:00:00	QQQ	ETF	64.615	64.65	64.56	64.6202	1277866.0
2012-02-28 13:30:00	QQQ	ETF	64.62	64.62	64.35	64.4	3638463.0
2012-02-28 14:00:00	QQQ	ETF	64.39	64.46	64.335	64.3588	4054825.0
2012-02-28 14:30:00	QQQ	ETF	64.3599	64.48	64.32	64.44	1844186.0
2012-02-28 15:00:00	QQQ	ETF	64.44	64.63	64.44	64.6101	2002293.0

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

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