PREVIEW / etf_30min / 2013-10-23

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-10-23.parquet
  size:    328 KB
  rows:    11,237

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
2013-10-23 04:00:00	SPY	ETF	174.55	174.84	174.23	174.39	46848.0
2013-10-23 04:30:00	SPY	ETF	174.4	174.53	174.4	174.52	3654.0
2013-10-23 05:00:00	SPY	ETF	174.54	174.61	174.47	174.47	25397.0
2013-10-23 05:30:00	SPY	ETF	174.45	174.53	174.43	174.43	25600.0
2013-10-23 06:00:00	SPY	ETF	174.42	174.45	174.32	174.33	27400.0
2013-10-23 06:30:00	SPY	ETF	174.35	174.62	174.32	174.56	131702.0
2013-10-23 07:00:00	SPY	ETF	174.54	174.6	174.46	174.51	139351.0
2013-10-23 07:30:00	SPY	ETF	174.495	174.62	174.38	174.57	259771.0
2013-10-23 08:00:00	SPY	ETF	174.56	174.65	174.42	174.63	1336171.0
2013-10-23 08:30:00	SPY	ETF	174.63	174.81	174.53	174.76	571066.0
2013-10-23 09:00:00	SPY	ETF	174.77	174.81	174.68	174.81	545472.0
2013-10-23 09:30:00	SPY	ETF	174.81	174.89	174.19	174.23	15586637.0
2013-10-23 10:00:00	SPY	ETF	174.2301	174.71	174.1	174.235	13648115.0
2013-10-23 10:30:00	SPY	ETF	174.23	174.57	173.96	174.27	10292488.0
2013-10-23 11:00:00	SPY	ETF	174.27	174.67	174.21	174.381	6692271.0
2013-10-23 11:30:00	SPY	ETF	174.395	174.645	174.39	174.51	4906295.0
2013-10-23 12:00:00	SPY	ETF	174.52	174.55	174.23	174.25	4554529.0
2013-10-23 12:30:00	SPY	ETF	174.25	174.57	174.18	174.53	4850300.0
2013-10-23 13:00:00	SPY	ETF	174.54	174.65	174.43	174.61	2727371.0
2013-10-23 13:30:00	SPY	ETF	174.62	174.63	174.36	174.48	4048287.0
2013-10-23 14:00:00	SPY	ETF	174.48	174.59	174.42	174.5	2669530.0
2013-10-23 14:30:00	SPY	ETF	174.51	174.84	174.47	174.71	4867932.0
2013-10-23 15:00:00	SPY	ETF	174.71	174.81	174.4	174.44	7872969.0
2013-10-23 15:30:00	SPY	ETF	174.45	174.66	174.44	174.62	11499551.0
2013-10-23 16:00:00	SPY	ETF	174.62	174.77	174.51	174.75	4290709.0
2013-10-23 16:30:00	SPY	ETF	174.77	174.82	174.75	174.75	164839.0
2013-10-23 17:00:00	SPY	ETF	174.75	174.83	174.74	174.82	151827.0
2013-10-23 17:30:00	SPY	ETF	174.8	174.8	174.74	174.76	64169.0
2013-10-23 18:00:00	SPY	ETF	174.76	174.8	174.59	174.59	62834.0
2013-10-23 18:30:00	SPY	ETF	174.58	174.72	174.58	174.67	6300.0
2013-10-23 19:00:00	SPY	ETF	174.69	174.69	174.64	174.69	5020.0
2013-10-23 19:30:00	SPY	ETF	174.67	174.78	174.67	174.76	47465.0
2013-10-23 04:00:00	QQQ	ETF	82.0	82.0	81.85	81.94	64900.0
2013-10-23 04:30:00	QQQ	ETF	81.94	81.99	81.93	81.98	7700.0
2013-10-23 05:00:00	QQQ	ETF	81.97	81.97	81.93	81.93	2300.0
2013-10-23 05:30:00	QQQ	ETF	81.92	81.94	81.9	81.9	4000.0
2013-10-23 06:00:00	QQQ	ETF	81.89	81.92	81.86	81.86	15500.0
2013-10-23 06:30:00	QQQ	ETF	81.86	81.96	81.84	81.94	16240.0
2013-10-23 07:00:00	QQQ	ETF	81.93	81.96	81.89	81.92	18874.0
2013-10-23 07:30:00	QQQ	ETF	81.91	81.96	81.85	81.93	140530.0
2013-10-23 08:00:00	QQQ	ETF	81.93	82.1	81.9	82.0	120852.0
2013-10-23 08:30:00	QQQ	ETF	82.0	82.09	81.96	82.08	127608.0
2013-10-23 09:00:00	QQQ	ETF	82.08	82.09	82.0	82.04	286243.0
2013-10-23 09:30:00	QQQ	ETF	82.04	82.2	81.77	81.781	5342021.0
2013-10-23 10:00:00	QQQ	ETF	81.79	82.005	81.71	81.785	3322482.0
2013-10-23 10:30:00	QQQ	ETF	81.78	81.93	81.55	81.651	3474216.0
2013-10-23 11:00:00	QQQ	ETF	81.66	81.82	81.58	81.7199	2280479.0
2013-10-23 11:30:00	QQQ	ETF	81.72	81.87	81.72	81.81	1130704.0
2013-10-23 12:00:00	QQQ	ETF	81.8045	81.83	81.65	81.65	1282620.0
2013-10-23 12:30:00	QQQ	ETF	81.65	81.91	81.65	81.891	1079311.0

> showing 50 of 11,237 rows — these rows as CSV

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