PREVIEW / etf_30min / 2012-11-23

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-23.parquet
  size:    173 KB
  rows:    5,450

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-11-23 04:00:00	SPY	ETF	139.49	139.49	139.49	139.49	200.0
2012-11-23 04:30:00	SPY	ETF	139.59	139.59	139.59	139.59	100.0
2012-11-23 05:00:00	SPY	ETF	139.8	139.8	139.69	139.7	19200.0
2012-11-23 05:30:00	SPY	ETF	139.55	139.55	139.55	139.55	100.0
2012-11-23 06:00:00	SPY	ETF	139.56	139.7	139.5	139.7	2500.0
2012-11-23 06:30:00	SPY	ETF	139.7	139.74	139.59	139.74	5029.0
2012-11-23 07:00:00	SPY	ETF	139.7	139.74	139.69	139.74	5560.0
2012-11-23 07:30:00	SPY	ETF	139.74	139.83	139.74	139.8	32531.0
2012-11-23 08:00:00	SPY	ETF	139.82	140.0	139.82	139.94	246965.0
2012-11-23 08:30:00	SPY	ETF	139.94	139.95	139.86	139.92	273166.0
2012-11-23 09:00:00	SPY	ETF	139.92	140.22	139.92	140.13	1045520.0
2012-11-23 09:30:00	SPY	ETF	140.13	140.32	140.04	140.28	11608573.0
2012-11-23 10:00:00	SPY	ETF	140.28	140.875	140.28	140.78	8458646.0
2012-11-23 10:30:00	SPY	ETF	140.78	140.85	140.64	140.738	5468804.0
2012-11-23 11:00:00	SPY	ETF	140.74	140.87	140.72	140.77	3334148.0
2012-11-23 11:30:00	SPY	ETF	140.775	140.84	140.64	140.68	3840423.0
2012-11-23 12:00:00	SPY	ETF	140.68	140.77	140.57	140.74	5444697.0
2012-11-23 12:30:00	SPY	ETF	140.745	141.4	140.72	141.35	15995851.0
2012-11-23 13:00:00	SPY	ETF	141.33	141.35	141.1	141.11	5991060.0
2012-11-23 13:30:00	SPY	ETF	141.12	141.16	141.11	141.15	287009.0
2012-11-23 14:00:00	SPY	ETF	141.15	141.17	141.07	141.17	175504.0
2012-11-23 14:30:00	SPY	ETF	141.17	141.18	141.14	141.15	16311.0
2012-11-23 15:00:00	SPY	ETF	141.17	141.2	141.14	141.15	16403.0
2012-11-23 15:30:00	SPY	ETF	141.14	141.16	141.1	141.16	13681.0
2012-11-23 16:00:00	SPY	ETF	141.13	141.17	141.12	141.13	3124.0
2012-11-23 16:30:00	SPY	ETF	141.12	141.16	141.12	141.14	6925.0
2012-11-23 04:30:00	QQQ	ETF	64.06	64.06	64.06	64.06	200.0
2012-11-23 05:30:00	QQQ	ETF	64.03	64.03	64.03	64.03	533.0
2012-11-23 06:30:00	QQQ	ETF	64.06	64.06	64.06	64.06	300.0
2012-11-23 07:00:00	QQQ	ETF	64.08	64.09	64.08	64.09	15000.0
2012-11-23 07:30:00	QQQ	ETF	64.09	64.11	64.09	64.1	17240.0
2012-11-23 08:00:00	QQQ	ETF	64.13	64.22	64.12	64.19	61505.0
2012-11-23 08:30:00	QQQ	ETF	64.2	64.21	64.16	64.17	4090.0
2012-11-23 09:00:00	QQQ	ETF	64.16	64.33	64.16	64.32	202612.0
2012-11-23 09:30:00	QQQ	ETF	64.31	64.45	64.2501	64.36	2720660.0
2012-11-23 10:00:00	QQQ	ETF	64.36	64.69	64.35	64.64	2682636.0
2012-11-23 10:30:00	QQQ	ETF	64.65	64.68	64.57	64.6695	1939897.0
2012-11-23 11:00:00	QQQ	ETF	64.661	64.745	64.65	64.7299	1503116.0
2012-11-23 11:30:00	QQQ	ETF	64.73	64.78	64.69	64.7199	741357.0
2012-11-23 12:00:00	QQQ	ETF	64.719	64.74	64.58	64.65	1411568.0
2012-11-23 12:30:00	QQQ	ETF	64.65	64.92	64.6413	64.9	3041695.0
2012-11-23 13:00:00	QQQ	ETF	64.89	64.91	64.6671	64.81	1421593.0
2012-11-23 13:30:00	QQQ	ETF	64.8	64.8	64.7801	64.7801	13900.0
2012-11-23 14:00:00	QQQ	ETF	64.8	64.83	64.79	64.7901	4056.0
2012-11-23 14:30:00	QQQ	ETF	64.85	64.87	64.85	64.87	4600.0
2012-11-23 15:00:00	QQQ	ETF	64.84	64.84	64.79	64.79	2300.0
2012-11-23 15:30:00	QQQ	ETF	64.79	64.82	64.79	64.82	1445.0
2012-11-23 16:00:00	QQQ	ETF	64.84	64.85	64.84	64.85	600.0
2012-11-23 16:30:00	QQQ	ETF	64.84	64.84	64.84	64.84	1000.0
2012-11-23 07:00:00	IWM	ETF	79.7	79.7	79.65	79.65	400.0

> showing 50 of 5,450 rows — these rows as CSV

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