PREVIEW / etf_30min / 2012-06-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-25.parquet
  size:    281 KB
  rows:    9,606

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-06-25 04:00:00	SPY	ETF	132.5	132.5	132.31	132.39	14019.0
2012-06-25 04:30:00	SPY	ETF	132.4	132.4	132.37	132.37	400.0
2012-06-25 05:00:00	SPY	ETF	132.32	132.32	132.24	132.27	23837.0
2012-06-25 05:30:00	SPY	ETF	132.21	132.25	132.18	132.25	10350.0
2012-06-25 06:00:00	SPY	ETF	132.17	132.25	132.1	132.21	18320.0
2012-06-25 06:30:00	SPY	ETF	132.21	132.27	132.13	132.24	19400.0
2012-06-25 07:00:00	SPY	ETF	132.27	132.32	132.0	132.03	342881.0
2012-06-25 07:30:00	SPY	ETF	132.05	132.18	131.97	132.15	132325.0
2012-06-25 08:00:00	SPY	ETF	132.2	132.27	132.15	132.19	955182.0
2012-06-25 08:30:00	SPY	ETF	132.17	132.18	131.98	132.05	1112215.0
2012-06-25 09:00:00	SPY	ETF	132.04	132.36	132.0	132.04	1556091.0
2012-06-25 09:30:00	SPY	ETF	132.05	132.1	131.44	131.66	23405962.0
2012-06-25 10:00:00	SPY	ETF	131.66	131.85	131.24	131.27	15997797.0
2012-06-25 10:30:00	SPY	ETF	131.27	131.48	131.2	131.36	10015517.0
2012-06-25 11:00:00	SPY	ETF	131.36	131.4	131.16	131.245	7106238.0
2012-06-25 11:30:00	SPY	ETF	131.24	131.28	130.88	130.91	8704474.0
2012-06-25 12:00:00	SPY	ETF	130.9	131.21	130.85	131.11	7170484.0
2012-06-25 12:30:00	SPY	ETF	131.1	131.18	131.055	131.07	3564748.0
2012-06-25 13:00:00	SPY	ETF	131.07	131.19	130.94	131.1799	4173058.0
2012-06-25 13:30:00	SPY	ETF	131.175	131.41	131.14	131.33	7704889.0
2012-06-25 14:00:00	SPY	ETF	131.32	131.48	131.23	131.24	7544862.0
2012-06-25 14:30:00	SPY	ETF	131.25	131.26	131.04	131.08	6366171.0
2012-06-25 15:00:00	SPY	ETF	131.08	131.6	131.055	131.5	9898607.0
2012-06-25 15:30:00	SPY	ETF	131.5	131.62	131.24	131.28	16498419.0
2012-06-25 16:00:00	SPY	ETF	131.27	131.804	130.85	131.24	8731466.0
2012-06-25 16:30:00	SPY	ETF	131.25	131.31	131.21	131.29	265949.0
2012-06-25 17:00:00	SPY	ETF	131.27	131.31	131.23	131.29	35436.0
2012-06-25 17:30:00	SPY	ETF	131.27	131.28	131.23	131.23	1143945.0
2012-06-25 18:00:00	SPY	ETF	131.25	131.25	131.15	131.2	12010.0
2012-06-25 18:30:00	SPY	ETF	131.2	131.3	131.2	131.3	14269.0
2012-06-25 19:00:00	SPY	ETF	131.29	131.42	131.27	131.39	59785.0
2012-06-25 19:30:00	SPY	ETF	131.38	131.44	131.33	131.35	41070.0
2012-06-25 04:30:00	QQQ	ETF	63.0	63.0	63.0	63.0	200.0
2012-06-25 05:00:00	QQQ	ETF	62.95	62.95	62.87	62.87	300.0
2012-06-25 05:30:00	QQQ	ETF	62.83	62.83	62.83	62.83	200.0
2012-06-25 06:00:00	QQQ	ETF	62.81	62.81	62.8	62.8	300.0
2012-06-25 06:30:00	QQQ	ETF	62.85	62.85	62.85	62.85	1000.0
2012-06-25 07:00:00	QQQ	ETF	62.86	62.86	62.74	62.74	14380.0
2012-06-25 07:30:00	QQQ	ETF	62.79	62.81	62.76	62.81	11240.0
2012-06-25 08:00:00	QQQ	ETF	62.83	62.89	62.83	62.85	91670.0
2012-06-25 08:30:00	QQQ	ETF	62.83	62.83	62.76	62.78	88107.0
2012-06-25 09:00:00	QQQ	ETF	62.8	62.87	62.79	62.82	157144.0
2012-06-25 09:30:00	QQQ	ETF	62.83	62.85	62.49	62.59	5378433.0
2012-06-25 10:00:00	QQQ	ETF	62.58	62.69	62.21	62.23	3551418.0
2012-06-25 10:30:00	QQQ	ETF	62.22	62.3599	62.19	62.31	1855497.0
2012-06-25 11:00:00	QQQ	ETF	62.31	62.32	62.14	62.15	1595565.0
2012-06-25 11:30:00	QQQ	ETF	62.15	62.16	61.96	61.98	2058330.0
2012-06-25 12:00:00	QQQ	ETF	61.97	62.185	61.95	62.1218	1345515.0
2012-06-25 12:30:00	QQQ	ETF	62.129	62.17	62.08	62.11	725473.0
2012-06-25 13:00:00	QQQ	ETF	62.11	62.17	62.02	62.15	1174679.0

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

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