PREVIEW / etf_30min / 2012-02-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-23.parquet
  size:    284 KB
  rows:    9,561

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-23 04:00:00	SPY	ETF	136.2	136.64	136.2	136.6	35680.0
2012-02-23 04:30:00	SPY	ETF	136.6	136.65	136.39	136.43	21274.0
2012-02-23 05:00:00	SPY	ETF	136.4	136.47	136.1	136.1	15150.0
2012-02-23 05:30:00	SPY	ETF	136.15	136.25	136.15	136.16	26100.0
2012-02-23 06:00:00	SPY	ETF	136.16	136.16	136.16	136.16	500.0
2012-02-23 06:30:00	SPY	ETF	136.1	136.12	136.1	136.1	625.0
2012-02-23 07:00:00	SPY	ETF	136.13	136.16	135.97	136.12	742695.0
2012-02-23 07:30:00	SPY	ETF	136.16	136.2	136.09	136.1	89066.0
2012-02-23 08:00:00	SPY	ETF	136.1	136.36	136.07	136.27	1333651.0
2012-02-23 08:30:00	SPY	ETF	136.28	136.35	136.2	136.27	736761.0
2012-02-23 09:00:00	SPY	ETF	136.26	136.27	135.87	135.96	1317696.0
2012-02-23 09:30:00	SPY	ETF	135.96	135.98	135.5	135.67	15612723.0
2012-02-23 10:00:00	SPY	ETF	135.67	136.03	135.65	135.94	15886236.0
2012-02-23 10:30:00	SPY	ETF	135.945	136.37	135.91	136.34	14178101.0
2012-02-23 11:00:00	SPY	ETF	136.335	136.51	136.26	136.43	14237302.0
2012-02-23 11:30:00	SPY	ETF	136.44	136.48	136.33	136.3901	5367338.0
2012-02-23 12:00:00	SPY	ETF	136.39	136.5	136.35	136.46	4424692.0
2012-02-23 12:30:00	SPY	ETF	136.46	136.55	136.31	136.39	6595299.0
2012-02-23 13:00:00	SPY	ETF	136.3885	136.41	136.25	136.31	5199491.0
2012-02-23 13:30:00	SPY	ETF	136.32	136.43	136.2	136.38	5957288.0
2012-02-23 14:00:00	SPY	ETF	136.39	136.42	136.27	136.4199	6392670.0
2012-02-23 14:30:00	SPY	ETF	136.42	136.53	136.33	136.415	6772454.0
2012-02-23 15:00:00	SPY	ETF	136.41	136.66	136.38	136.6199	8239027.0
2012-02-23 15:30:00	SPY	ETF	136.62	136.73	136.56	136.63	16145910.0
2012-02-23 16:00:00	SPY	ETF	136.63	136.83	135.7767	136.77	4491448.0
2012-02-23 16:30:00	SPY	ETF	136.77	136.81	136.41	136.77	537786.0
2012-02-23 17:00:00	SPY	ETF	136.77	136.88	136.77	136.88	328278.0
2012-02-23 17:30:00	SPY	ETF	136.85	136.92	136.83	136.86	45710.0
2012-02-23 18:00:00	SPY	ETF	136.9	137.0	136.89	137.0	93976.0
2012-02-23 18:30:00	SPY	ETF	136.99	137.03	136.94	136.98	42953.0
2012-02-23 19:00:00	SPY	ETF	137.0	137.0	136.93	136.96	21519.0
2012-02-23 19:30:00	SPY	ETF	136.96	137.05	136.96	137.03	58104.0
2012-02-23 04:00:00	QQQ	ETF	63.55	63.58	63.55	63.58	1200.0
2012-02-23 04:30:00	QQQ	ETF	63.59	63.59	63.59	63.59	300.0
2012-02-23 05:00:00	QQQ	ETF	63.43	63.43	63.43	63.43	200.0
2012-02-23 07:00:00	QQQ	ETF	63.44	63.45	63.44	63.44	5500.0
2012-02-23 07:30:00	QQQ	ETF	63.44	63.45	63.41	63.41	32255.0
2012-02-23 08:00:00	QQQ	ETF	63.42	63.52	63.4	63.5	1209198.0
2012-02-23 08:30:00	QQQ	ETF	63.51	63.55	63.47	63.49	170469.0
2012-02-23 09:00:00	QQQ	ETF	63.5	63.5	63.34	63.39	404743.0
2012-02-23 09:30:00	QQQ	ETF	63.39	63.41	63.09	63.27	4335505.0
2012-02-23 10:00:00	QQQ	ETF	63.26	63.5	63.26	63.43	3272798.0
2012-02-23 10:30:00	QQQ	ETF	63.42	63.6617	63.41	63.64	4194543.0
2012-02-23 11:00:00	QQQ	ETF	63.65	63.8	63.61	63.77	5393643.0
2012-02-23 11:30:00	QQQ	ETF	63.77	63.8	63.66	63.69	1987196.0
2012-02-23 12:00:00	QQQ	ETF	63.7	63.74	63.601	63.68	2158829.0
2012-02-23 12:30:00	QQQ	ETF	63.68	63.73	63.52	63.57	3378069.0
2012-02-23 13:00:00	QQQ	ETF	63.57	63.63	63.5	63.56	1870585.0
2012-02-23 13:30:00	QQQ	ETF	63.56	63.58	63.38	63.53	4582801.0
2012-02-23 14:00:00	QQQ	ETF	63.53	63.5586	63.44	63.55	1896067.0

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

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