PREVIEW / etf_30min / 2012-02-14

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-14.parquet
  size:    283 KB
  rows:    9,557

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-14 04:00:00	SPY	ETF	135.03	135.03	135.03	135.03	100.0
2012-02-14 04:30:00	SPY	ETF	134.95	135.11	134.95	135.11	1150.0
2012-02-14 05:00:00	SPY	ETF	135.15	135.6	135.15	135.6	23159.0
2012-02-14 05:30:00	SPY	ETF	135.55	135.55	135.5	135.54	28692.0
2012-02-14 06:00:00	SPY	ETF	135.46	135.5	135.45	135.45	2200.0
2012-02-14 06:30:00	SPY	ETF	135.42	135.61	135.42	135.53	118980.0
2012-02-14 07:00:00	SPY	ETF	135.55	135.59	135.45	135.48	64705.0
2012-02-14 07:30:00	SPY	ETF	135.48	135.48	135.28	135.32	111230.0
2012-02-14 08:00:00	SPY	ETF	135.34	135.5	135.21	135.34	1202524.0
2012-02-14 08:30:00	SPY	ETF	135.36	135.5	134.86	134.97	1708687.0
2012-02-14 09:00:00	SPY	ETF	134.97	135.05	134.78	134.99	1395120.0
2012-02-14 09:30:00	SPY	ETF	135.0	135.14	134.9	134.9199	14638865.0
2012-02-14 10:00:00	SPY	ETF	134.91	135.0	134.62	134.86	16706184.0
2012-02-14 10:30:00	SPY	ETF	134.87	134.94	134.58	134.72	11205011.0
2012-02-14 11:00:00	SPY	ETF	134.72	134.94	134.68	134.91	8494692.0
2012-02-14 11:30:00	SPY	ETF	134.91	135.1	134.9	134.92	10111427.0
2012-02-14 12:00:00	SPY	ETF	134.92	135.01	134.82	134.85	6617308.0
2012-02-14 12:30:00	SPY	ETF	134.86	134.91	134.64	134.69	4827601.0
2012-02-14 13:00:00	SPY	ETF	134.69	134.69	134.5	134.62	7787036.0
2012-02-14 13:30:00	SPY	ETF	134.61	134.81	134.59	134.745	5960317.0
2012-02-14 14:00:00	SPY	ETF	134.75	134.81	134.39	134.42	8733482.0
2012-02-14 14:30:00	SPY	ETF	134.41	134.54	134.27	134.51	8287467.0
2012-02-14 15:00:00	SPY	ETF	134.51	134.7	134.25	134.335	10301070.0
2012-02-14 15:30:00	SPY	ETF	134.32	135.27	134.26	135.23	31272661.0
2012-02-14 16:00:00	SPY	ETF	135.22	135.36	134.89	135.21	8521431.0
2012-02-14 16:30:00	SPY	ETF	135.2	135.3591	134.7269	135.21	1960426.0
2012-02-14 17:00:00	SPY	ETF	135.22	135.25	135.18	135.19	206230.0
2012-02-14 17:30:00	SPY	ETF	135.19	135.3592	135.17	135.2	506999.0
2012-02-14 18:00:00	SPY	ETF	135.19	135.19	135.14	135.18	605525.0
2012-02-14 18:30:00	SPY	ETF	135.16	135.21	135.14	135.2	43720.0
2012-02-14 19:00:00	SPY	ETF	135.21	135.23	135.17	135.22	26180.0
2012-02-14 19:30:00	SPY	ETF	135.2	135.25	135.16	135.25	20554.0
2012-02-14 05:00:00	QQQ	ETF	63.12	63.15	63.12	63.15	1000.0
2012-02-14 05:30:00	QQQ	ETF	63.19	63.19	63.19	63.19	300.0
2012-02-14 06:00:00	QQQ	ETF	63.16	63.16	63.12	63.15	19900.0
2012-02-14 06:30:00	QQQ	ETF	63.14	63.17	63.14	63.17	18900.0
2012-02-14 07:00:00	QQQ	ETF	63.19	63.2	63.1	63.12	36820.0
2012-02-14 07:30:00	QQQ	ETF	63.12	63.12	63.04	63.04	17300.0
2012-02-14 08:00:00	QQQ	ETF	63.1	63.13	63.02	63.07	881107.0
2012-02-14 08:30:00	QQQ	ETF	63.08	63.1	62.87	62.9	335231.0
2012-02-14 09:00:00	QQQ	ETF	62.91	62.95	62.84	62.88	243263.0
2012-02-14 09:30:00	QQQ	ETF	62.9	63.07	62.86	62.98	3972813.0
2012-02-14 10:00:00	QQQ	ETF	62.98	63.03	62.83	62.98	3312784.0
2012-02-14 10:30:00	QQQ	ETF	62.97	63.0	62.7899	62.85	3357384.0
2012-02-14 11:00:00	QQQ	ETF	62.854	62.93	62.815	62.93	1608608.0
2012-02-14 11:30:00	QQQ	ETF	62.93	63.03	62.91	62.92	3187152.0
2012-02-14 12:00:00	QQQ	ETF	62.91	62.949	62.81	62.85	1308418.0
2012-02-14 12:30:00	QQQ	ETF	62.8593	62.92	62.78	62.82	841484.0
2012-02-14 13:00:00	QQQ	ETF	62.81	62.83	62.73	62.8001	2068215.0
2012-02-14 13:30:00	QQQ	ETF	62.81	62.93	62.8	62.89	1189927.0

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

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