PREVIEW / etf_30min / 2012-11-19

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-19.parquet
  size:    299 KB
  rows:    10,080

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-11-19 04:00:00	SPY	ETF	137.18	137.26	137.18	137.26	6246.0
2012-11-19 04:30:00	SPY	ETF	137.18	137.28	137.18	137.28	11675.0
2012-11-19 05:00:00	SPY	ETF	137.25	137.26	137.24	137.24	2000.0
2012-11-19 05:30:00	SPY	ETF	137.24	137.32	137.24	137.32	2100.0
2012-11-19 06:00:00	SPY	ETF	137.3	137.37	137.24	137.36	20670.0
2012-11-19 06:30:00	SPY	ETF	137.37	137.55	137.36	137.52	103300.0
2012-11-19 07:00:00	SPY	ETF	137.51	137.6	137.46	137.49	234939.0
2012-11-19 07:30:00	SPY	ETF	137.47	137.53	137.34	137.44	180874.0
2012-11-19 08:00:00	SPY	ETF	137.5295	137.8	137.34	137.74	2368339.0
2012-11-19 08:30:00	SPY	ETF	137.73	137.9	137.73	137.85	1633177.0
2012-11-19 09:00:00	SPY	ETF	137.85	137.98	137.81	137.89	1439571.0
2012-11-19 09:30:00	SPY	ETF	137.9	138.49	137.82	138.43	20650498.0
2012-11-19 10:00:00	SPY	ETF	138.43	138.6	138.19	138.33	22550055.0
2012-11-19 10:30:00	SPY	ETF	138.331	138.63	138.27	138.45	8301744.0
2012-11-19 11:00:00	SPY	ETF	138.45	138.6	138.34	138.531	7442422.0
2012-11-19 11:30:00	SPY	ETF	138.53	138.59	138.39	138.519	5221168.0
2012-11-19 12:00:00	SPY	ETF	138.52	138.75	138.51	138.67	9268969.0
2012-11-19 12:30:00	SPY	ETF	138.67	138.72	138.53	138.61	4801701.0
2012-11-19 13:00:00	SPY	ETF	138.62	138.67	138.39	138.469	4058632.0
2012-11-19 13:30:00	SPY	ETF	138.46	138.53	138.37	138.49	3694799.0
2012-11-19 14:00:00	SPY	ETF	138.49	138.62	138.48	138.56	4602382.0
2012-11-19 14:30:00	SPY	ETF	138.56	138.85	138.47	138.78	7754854.0
2012-11-19 15:00:00	SPY	ETF	138.77	138.85	138.65	138.78	8154119.0
2012-11-19 15:30:00	SPY	ETF	138.79	139.13	138.68	139.11	21459210.0
2012-11-19 16:00:00	SPY	ETF	139.11	139.13	136.4057	138.97	8888291.0
2012-11-19 16:30:00	SPY	ETF	138.97	139.13	138.97	139.11	3886595.0
2012-11-19 17:00:00	SPY	ETF	139.11	139.21	138.74	138.9	661412.0
2012-11-19 17:30:00	SPY	ETF	138.83	138.85	138.72	138.73	130863.0
2012-11-19 18:00:00	SPY	ETF	138.71	138.83	138.65	138.76	217970.0
2012-11-19 18:30:00	SPY	ETF	138.75	138.8	138.72	138.72	15355.0
2012-11-19 19:00:00	SPY	ETF	138.76	138.87	138.74	138.76	20765.0
2012-11-19 19:30:00	SPY	ETF	138.8	138.83	138.76	138.8	45488.0
2012-11-19 04:00:00	QQQ	ETF	62.6	62.6	62.6	62.6	600.0
2012-11-19 04:30:00	QQQ	ETF	62.58	62.6	62.58	62.6	500.0
2012-11-19 05:00:00	QQQ	ETF	62.62	62.62	62.57	62.6	600.0
2012-11-19 05:30:00	QQQ	ETF	62.62	62.63	62.6	62.63	800.0
2012-11-19 06:00:00	QQQ	ETF	62.66	62.66	62.66	62.66	2500.0
2012-11-19 06:30:00	QQQ	ETF	62.7	62.75	62.7	62.75	13700.0
2012-11-19 07:00:00	QQQ	ETF	62.75	62.75	62.69	62.7	22800.0
2012-11-19 07:30:00	QQQ	ETF	62.7	62.76	62.67	62.76	61065.0
2012-11-19 08:00:00	QQQ	ETF	62.72	62.9	62.7	62.87	346082.0
2012-11-19 08:30:00	QQQ	ETF	62.89	62.93	62.89	62.92	144052.0
2012-11-19 09:00:00	QQQ	ETF	62.92	63.0	62.88	62.96	880775.0
2012-11-19 09:30:00	QQQ	ETF	62.97	63.289	62.96	63.22	7274538.0
2012-11-19 10:00:00	QQQ	ETF	63.23	63.27	63.05	63.1799	5102144.0
2012-11-19 10:30:00	QQQ	ETF	63.1788	63.42	63.14	63.325	2461575.0
2012-11-19 11:00:00	QQQ	ETF	63.33	63.41	63.29	63.378	1379295.0
2012-11-19 11:30:00	QQQ	ETF	63.38	63.41	63.31	63.378	1086167.0
2012-11-19 12:00:00	QQQ	ETF	63.37	63.56	63.37	63.52	1416261.0
2012-11-19 12:30:00	QQQ	ETF	63.5255	63.57	63.47	63.5201	852868.0

> showing 50 of 10,080 rows — these rows as CSV

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