PREVIEW / etf_30min / 2012-11-20

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-20.parquet
  size:    284 KB
  rows:    9,589

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-20 04:00:00	SPY	ETF	138.7	138.86	138.65	138.86	15500.0
2012-11-20 04:30:00	SPY	ETF	138.86	138.86	138.71	138.76	700.0
2012-11-20 05:00:00	SPY	ETF	138.76	138.95	138.76	138.95	400.0
2012-11-20 05:30:00	SPY	ETF	138.95	139.06	138.95	139.06	50600.0
2012-11-20 06:00:00	SPY	ETF	139.05	139.05	138.93	138.94	11870.0
2012-11-20 06:30:00	SPY	ETF	138.96	138.97	138.91	138.96	17300.0
2012-11-20 07:00:00	SPY	ETF	138.91	139.09	138.91	138.98	77303.0
2012-11-20 07:30:00	SPY	ETF	138.98	138.98	138.63	138.74	415680.0
2012-11-20 08:00:00	SPY	ETF	138.74	139.04	138.72	138.96	400814.0
2012-11-20 08:30:00	SPY	ETF	138.98	139.15	138.9	138.97	980019.0
2012-11-20 09:00:00	SPY	ETF	138.98	139.01	138.85	138.91	474422.0
2012-11-20 09:30:00	SPY	ETF	138.91	138.93	138.5	138.88	12849021.0
2012-11-20 10:00:00	SPY	ETF	138.88	139.13	138.72	139.025	7968439.0
2012-11-20 10:30:00	SPY	ETF	139.02	139.26	138.75	138.95	6940390.0
2012-11-20 11:00:00	SPY	ETF	138.94	139.19	138.81	139.13	5420118.0
2012-11-20 11:30:00	SPY	ETF	139.13	139.39	139.02	139.335	7019476.0
2012-11-20 12:00:00	SPY	ETF	139.335	139.42	139.06	139.14	7130400.0
2012-11-20 12:30:00	SPY	ETF	139.13	139.195	138.98	139.125	4437277.0
2012-11-20 13:00:00	SPY	ETF	139.13	139.15	138.08	138.09	11837866.0
2012-11-20 13:30:00	SPY	ETF	138.09	138.67	138.09	138.6201	7034371.0
2012-11-20 14:00:00	SPY	ETF	138.62	138.9	138.52	138.85	5450161.0
2012-11-20 14:30:00	SPY	ETF	138.85	138.87	138.62	138.82	4445557.0
2012-11-20 15:00:00	SPY	ETF	138.817	139.05	138.79	138.91	4686695.0
2012-11-20 15:30:00	SPY	ETF	138.915	139.25	138.87	139.23	15530916.0
2012-11-20 16:00:00	SPY	ETF	139.23	139.36	138.741	139.29	6942426.0
2012-11-20 16:30:00	SPY	ETF	139.29	139.3	139.1076	139.26	2634478.0
2012-11-20 17:00:00	SPY	ETF	139.27	139.35	139.26	139.34	1122815.0
2012-11-20 17:30:00	SPY	ETF	139.34	139.35	139.31	139.32	15153.0
2012-11-20 18:00:00	SPY	ETF	139.31	139.32	139.24	139.28	59051.0
2012-11-20 18:30:00	SPY	ETF	139.27	139.28	139.22	139.23	106075.0
2012-11-20 19:00:00	SPY	ETF	139.23	139.38	139.19	139.34	40139.0
2012-11-20 19:30:00	SPY	ETF	139.34	139.5	139.32	139.4	210330.0
2012-11-20 04:00:00	QQQ	ETF	63.57	63.58	63.57	63.58	8100.0
2012-11-20 04:30:00	QQQ	ETF	63.55	63.55	63.55	63.55	100.0
2012-11-20 05:30:00	QQQ	ETF	63.68	63.69	63.68	63.69	13000.0
2012-11-20 06:00:00	QQQ	ETF	63.71	63.71	63.71	63.71	6000.0
2012-11-20 06:30:00	QQQ	ETF	63.69	63.69	63.69	63.69	100.0
2012-11-20 07:00:00	QQQ	ETF	63.71	63.72	63.69	63.69	2100.0
2012-11-20 07:30:00	QQQ	ETF	63.69	63.69	63.55	63.59	20800.0
2012-11-20 08:00:00	QQQ	ETF	63.56	63.71	63.56	63.7	42420.0
2012-11-20 08:30:00	QQQ	ETF	63.7	63.79	63.57	63.77	93660.0
2012-11-20 09:00:00	QQQ	ETF	63.77	63.84	63.74	63.78	86397.0
2012-11-20 09:30:00	QQQ	ETF	63.77	63.7801	63.52	63.69	4213997.0
2012-11-20 10:00:00	QQQ	ETF	63.69	63.83	63.65	63.75	2819763.0
2012-11-20 10:30:00	QQQ	ETF	63.745	63.84	63.6401	63.65	3545988.0
2012-11-20 11:00:00	QQQ	ETF	63.65	63.8	63.58	63.76	1471692.0
2012-11-20 11:30:00	QQQ	ETF	63.77	63.88	63.7101	63.86	1387128.0
2012-11-20 12:00:00	QQQ	ETF	63.87	63.89	63.68	63.75	1893587.0
2012-11-20 12:30:00	QQQ	ETF	63.7452	63.75	63.63	63.718	1128755.0
2012-11-20 13:00:00	QQQ	ETF	63.71	63.72	63.19	63.2	11048995.0

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

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