PREVIEW / etf_30min / 2011-09-20

all etf 30-min files

  file:    by_date/etf_30min/2011/2011-09-20.parquet
  size:    279 KB
  rows:    9,213

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
2011-09-20 04:00:00	SPY	ETF	120.14	120.6	120.14	120.5	8312.0
2011-09-20 04:30:00	SPY	ETF	120.46	120.55	120.41	120.55	1800.0
2011-09-20 05:00:00	SPY	ETF	120.53	120.6	120.45	120.48	800.0
2011-09-20 05:30:00	SPY	ETF	120.5	121.52	120.5	121.52	28400.0
2011-09-20 06:00:00	SPY	ETF	121.52	121.61	121.17	121.2	35350.0
2011-09-20 06:30:00	SPY	ETF	121.3	121.35	121.05	121.16	107150.0
2011-09-20 07:00:00	SPY	ETF	121.13	121.39	121.1	121.23	630709.0
2011-09-20 07:30:00	SPY	ETF	121.19	121.31	121.08	121.2	359365.0
2011-09-20 08:00:00	SPY	ETF	121.21	121.41	121.02	121.26	1646310.0
2011-09-20 08:30:00	SPY	ETF	121.26	121.31	120.79	121.03	2667880.0
2011-09-20 09:00:00	SPY	ETF	121.04	121.15	120.69	120.82	1727875.0
2011-09-20 09:30:00	SPY	ETF	120.82	120.98	120.01	120.37	20367017.0
2011-09-20 10:00:00	SPY	ETF	120.41	121.0602	120.18	120.99	18291139.0
2011-09-20 10:30:00	SPY	ETF	120.99	121.64	120.9	121.6	17053095.0
2011-09-20 11:00:00	SPY	ETF	121.61	121.99	121.58	121.8	18593412.0
2011-09-20 11:30:00	SPY	ETF	121.8	121.95	121.56	121.87	11228933.0
2011-09-20 12:00:00	SPY	ETF	121.87	121.88	121.405	121.64	8541847.0
2011-09-20 12:30:00	SPY	ETF	121.64	121.82	121.32	121.69	7999640.0
2011-09-20 13:00:00	SPY	ETF	121.68	121.93	121.62	121.8	7940848.0
2011-09-20 13:30:00	SPY	ETF	121.81	121.84	121.45	121.551	7407369.0
2011-09-20 14:00:00	SPY	ETF	121.58	121.87	121.41	121.7	9075417.0
2011-09-20 14:30:00	SPY	ETF	121.7	121.8	121.14	121.23	16065606.0
2011-09-20 15:00:00	SPY	ETF	121.24	121.375	120.405	120.49	20791093.0
2011-09-20 15:30:00	SPY	ETF	120.49	120.76	120.1	120.17	32918920.0
2011-09-20 16:00:00	SPY	ETF	120.19	121.9822	119.95	120.08	6664334.0
2011-09-20 16:30:00	SPY	ETF	120.12	120.53	120.1	120.41	5493240.0
2011-09-20 17:00:00	SPY	ETF	120.44	120.5	120.27	120.31	255138.0
2011-09-20 17:30:00	SPY	ETF	120.33	120.38	120.28	120.29	17011.0
2011-09-20 18:00:00	SPY	ETF	120.3	120.45	119.98	120.05	437684.0
2011-09-20 18:30:00	SPY	ETF	120.05	120.14	120.0	120.07	69928.0
2011-09-20 19:00:00	SPY	ETF	120.06	120.07	120.0	120.03	46996.0
2011-09-20 19:30:00	SPY	ETF	120.05	120.32	120.0	120.31	61997.0
2011-09-20 04:00:00	QQQ	ETF	56.8	56.85	56.74	56.74	3120.0
2011-09-20 04:30:00	QQQ	ETF	56.77	56.77	56.77	56.77	500.0
2011-09-20 05:00:00	QQQ	ETF	56.85	56.85	56.85	56.85	200.0
2011-09-20 05:30:00	QQQ	ETF	56.85	57.26	56.81	57.26	4950.0
2011-09-20 06:00:00	QQQ	ETF	57.26	57.27	57.15	57.15	7380.0
2011-09-20 06:30:00	QQQ	ETF	57.2	57.2	57.05	57.05	8250.0
2011-09-20 07:00:00	QQQ	ETF	57.06	57.15	57.05	57.07	14120.0
2011-09-20 07:30:00	QQQ	ETF	57.04	57.12	57.0	57.1	162083.0
2011-09-20 08:00:00	QQQ	ETF	57.1	57.17	57.03	57.03	461611.0
2011-09-20 08:30:00	QQQ	ETF	57.11	57.15	56.96	57.04	679996.0
2011-09-20 09:00:00	QQQ	ETF	57.06	57.09	56.87	56.9	505095.0
2011-09-20 09:30:00	QQQ	ETF	56.9	56.9586	56.51	56.69	7041330.0
2011-09-20 10:00:00	QQQ	ETF	56.69	57.03	56.61	57.0099	5518300.0
2011-09-20 10:30:00	QQQ	ETF	57.01	57.2	56.96	57.17	4326905.0
2011-09-20 11:00:00	QQQ	ETF	57.17	57.28	57.11	57.19	5044717.0
2011-09-20 11:30:00	QQQ	ETF	57.18	57.35	57.09	57.31	2814556.0
2011-09-20 12:00:00	QQQ	ETF	57.31	57.31	57.1	57.1813	1939213.0
2011-09-20 12:30:00	QQQ	ETF	57.18	57.24	57.03	57.16	2409001.0

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

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