PREVIEW / etf_30min / 2012-03-15

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-03-15.parquet
  size:    288 KB
  rows:    9,726

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-03-15 04:00:00	SPY	ETF	140.02	140.16	140.01	140.07	16600.0
2012-03-15 04:30:00	SPY	ETF	140.08	140.2	140.08	140.13	19700.0
2012-03-15 05:00:00	SPY	ETF	140.16	140.2	140.12	140.2	33200.0
2012-03-15 05:30:00	SPY	ETF	140.27	140.37	140.2	140.2	33854.0
2012-03-15 06:00:00	SPY	ETF	140.15	140.15	140.07	140.07	1200.0
2012-03-15 06:30:00	SPY	ETF	140.13	140.13	140.03	140.1	33908.0
2012-03-15 07:00:00	SPY	ETF	140.07	140.2	140.07	140.2	79258.0
2012-03-15 07:30:00	SPY	ETF	140.22	140.32	140.18	140.3	198940.0
2012-03-15 08:00:00	SPY	ETF	140.29	140.35	140.21	140.27	225418.0
2012-03-15 08:30:00	SPY	ETF	140.27	140.38	140.182	140.24	498489.0
2012-03-15 09:00:00	SPY	ETF	140.24	140.269	139.91	140.12	1421965.0
2012-03-15 09:30:00	SPY	ETF	140.12	140.16	139.76	140.025	16592788.0
2012-03-15 10:00:00	SPY	ETF	140.02	140.33	139.86	140.23	18918760.0
2012-03-15 10:30:00	SPY	ETF	140.23	140.38	140.12	140.15	11000426.0
2012-03-15 11:00:00	SPY	ETF	140.15	140.31	140.02	140.26	7644921.0
2012-03-15 11:30:00	SPY	ETF	140.26	140.34	140.08	140.29	8263530.0
2012-03-15 12:00:00	SPY	ETF	140.295	140.7	140.28	140.64	10630600.0
2012-03-15 12:30:00	SPY	ETF	140.631	140.74	140.58	140.63	6252137.0
2012-03-15 13:00:00	SPY	ETF	140.63	140.7	140.48	140.5199	7823505.0
2012-03-15 13:30:00	SPY	ETF	140.51	140.6	140.42	140.4599	8075479.0
2012-03-15 14:00:00	SPY	ETF	140.46	140.66	140.37	140.57	6122880.0
2012-03-15 14:30:00	SPY	ETF	140.57	140.68	140.49	140.63	7538500.0
2012-03-15 15:00:00	SPY	ETF	140.63	140.72	140.55	140.68	7520200.0
2012-03-15 15:30:00	SPY	ETF	140.68	140.78	140.54	140.68	20692640.0
2012-03-15 16:00:00	SPY	ETF	140.67	140.72	139.9186	140.62	7775420.0
2012-03-15 16:30:00	SPY	ETF	140.62	140.62	139.9186	140.57	10139012.0
2012-03-15 17:00:00	SPY	ETF	140.57	140.58	140.51	140.58	3193719.0
2012-03-15 17:30:00	SPY	ETF	140.58	140.59	140.54	140.59	39498.0
2012-03-15 18:00:00	SPY	ETF	140.59	140.64	140.58	140.61	50800.0
2012-03-15 18:30:00	SPY	ETF	140.61	140.63	140.52	140.55	43112.0
2012-03-15 19:00:00	SPY	ETF	140.53	140.59	140.53	140.56	33483.0
2012-03-15 19:30:00	SPY	ETF	140.59	140.63	140.58	140.59	108629.0
2012-03-15 05:00:00	QQQ	ETF	66.65	66.65	66.65	66.65	500.0
2012-03-15 07:00:00	QQQ	ETF	66.4	66.65	66.4	66.64	1200.0
2012-03-15 07:30:00	QQQ	ETF	66.64	66.68	66.64	66.68	15700.0
2012-03-15 08:00:00	QQQ	ETF	66.68	66.7	66.65	66.7	52730.0
2012-03-15 08:30:00	QQQ	ETF	66.7	66.73	66.67	66.7	159770.0
2012-03-15 09:00:00	QQQ	ETF	66.69	66.71	66.66	66.69	150362.0
2012-03-15 09:30:00	QQQ	ETF	66.69	66.72	66.48	66.65	5839134.0
2012-03-15 10:00:00	QQQ	ETF	66.65	66.77	66.35	66.66	8188191.0
2012-03-15 10:30:00	QQQ	ETF	66.67	66.745	66.56	66.5779	3498501.0
2012-03-15 11:00:00	QQQ	ETF	66.575	66.718	66.47	66.68	3269009.0
2012-03-15 11:30:00	QQQ	ETF	66.69	66.75	66.62	66.67	1902450.0
2012-03-15 12:00:00	QQQ	ETF	66.68	66.82	66.65	66.79	2345733.0
2012-03-15 12:30:00	QQQ	ETF	66.79	66.81	66.72	66.7221	1426399.0
2012-03-15 13:00:00	QQQ	ETF	66.72	66.77	66.52	66.57	3768515.0
2012-03-15 13:30:00	QQQ	ETF	66.57	66.66	66.43	66.49	4987028.0
2012-03-15 14:00:00	QQQ	ETF	66.4891	66.66	66.36	66.6	3685548.0
2012-03-15 14:30:00	QQQ	ETF	66.5971	66.72	66.53	66.67	2924534.0
2012-03-15 15:00:00	QQQ	ETF	66.675	66.74	66.57	66.7	5039854.0

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

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