PREVIEW / etf_30min / 2012-04-27

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-27.parquet
  size:    281 KB
  rows:    9,760

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-04-27 04:00:00	SPY	ETF	139.65	139.9	139.65	139.9	3199.0
2012-04-27 04:30:00	SPY	ETF	139.88	139.92	139.85	139.85	1100.0
2012-04-27 05:00:00	SPY	ETF	139.98	140.18	139.98	140.15	3800.0
2012-04-27 05:30:00	SPY	ETF	140.19	140.2	140.05	140.05	12100.0
2012-04-27 06:00:00	SPY	ETF	140.01	140.1	139.99	140.1	10800.0
2012-04-27 06:30:00	SPY	ETF	140.13	140.28	140.13	140.24	129813.0
2012-04-27 07:00:00	SPY	ETF	140.2	140.37	140.14	140.21	997038.0
2012-04-27 07:30:00	SPY	ETF	140.22	140.53	140.13	140.45	381757.0
2012-04-27 08:00:00	SPY	ETF	140.43	140.65	140.22	140.55	1405988.0
2012-04-27 08:30:00	SPY	ETF	140.51	140.75	140.13	140.51	2264246.0
2012-04-27 09:00:00	SPY	ETF	140.52	140.77	140.52	140.59	1478917.0
2012-04-27 09:30:00	SPY	ETF	140.58	140.6	140.03	140.22	14158157.0
2012-04-27 10:00:00	SPY	ETF	140.21	140.23	139.8	140.05	14973709.0
2012-04-27 10:30:00	SPY	ETF	140.05	140.3	139.93	140.245	12743706.0
2012-04-27 11:00:00	SPY	ETF	140.24	140.4	140.19	140.28	8022081.0
2012-04-27 11:30:00	SPY	ETF	140.27	140.37	140.2	140.3299	6207238.0
2012-04-27 12:00:00	SPY	ETF	140.33	140.42	140.26	140.39	3592012.0
2012-04-27 12:30:00	SPY	ETF	140.39	140.41	140.28	140.39	3568206.0
2012-04-27 13:00:00	SPY	ETF	140.39	140.56	140.36	140.53	3613346.0
2012-04-27 13:30:00	SPY	ETF	140.53	140.79	140.53	140.65	7788082.0
2012-04-27 14:00:00	SPY	ETF	140.65	140.68	140.49	140.53	4657701.0
2012-04-27 14:30:00	SPY	ETF	140.495	140.58	140.41	140.55	3730310.0
2012-04-27 15:00:00	SPY	ETF	140.55	140.66	140.42	140.53	5265015.0
2012-04-27 15:30:00	SPY	ETF	140.53	140.58	140.34	140.43	17003701.0
2012-04-27 16:00:00	SPY	ETF	140.42	140.45	140.16	140.36	10519194.0
2012-04-27 16:30:00	SPY	ETF	140.37	140.4	140.27	140.38	537563.0
2012-04-27 17:00:00	SPY	ETF	140.39	140.4	140.31	140.34	68350.0
2012-04-27 17:30:00	SPY	ETF	140.32	140.43	140.32	140.39	57566.0
2012-04-27 18:00:00	SPY	ETF	140.41	140.41	140.28	140.35	21543.0
2012-04-27 18:30:00	SPY	ETF	140.39	140.42	140.35	140.37	12834.0
2012-04-27 19:00:00	SPY	ETF	140.35	140.35	140.32	140.32	11000.0
2012-04-27 19:30:00	SPY	ETF	140.37	140.43	140.36	140.43	34114.0
2012-04-27 04:00:00	QQQ	ETF	66.57	66.73	66.57	66.72	2130.0
2012-04-27 04:30:00	QQQ	ETF	66.81	66.81	66.81	66.81	500.0
2012-04-27 05:00:00	QQQ	ETF	66.83	66.85	66.83	66.85	940.0
2012-04-27 06:00:00	QQQ	ETF	66.86	66.91	66.86	66.91	10100.0
2012-04-27 06:30:00	QQQ	ETF	66.94	66.94	66.94	66.94	600.0
2012-04-27 07:00:00	QQQ	ETF	66.98	67.04	66.95	66.95	26333.0
2012-04-27 07:30:00	QQQ	ETF	66.97	67.09	66.94	67.07	452740.0
2012-04-27 08:00:00	QQQ	ETF	67.06	67.15	66.95	67.12	884904.0
2012-04-27 08:30:00	QQQ	ETF	67.05	67.14	66.98	67.09	318634.0
2012-04-27 09:00:00	QQQ	ETF	67.1	67.2	67.1	67.13	765013.0
2012-04-27 09:30:00	QQQ	ETF	67.12	67.18	66.87	66.99	6409305.0
2012-04-27 10:00:00	QQQ	ETF	66.99	67.0	66.77	66.98	6928093.0
2012-04-27 10:30:00	QQQ	ETF	66.98	67.15	66.92	67.0971	3798311.0
2012-04-27 11:00:00	QQQ	ETF	67.095	67.22	67.08	67.17	3557091.0
2012-04-27 11:30:00	QQQ	ETF	67.1775	67.25	67.14	67.22	1897867.0
2012-04-27 12:00:00	QQQ	ETF	67.23	67.24	67.15	67.23	1112580.0
2012-04-27 12:30:00	QQQ	ETF	67.23	67.29	67.19	67.28	1158029.0
2012-04-27 13:00:00	QQQ	ETF	67.275	67.33	67.26	67.3062	1196875.0

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

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