PREVIEW / etf_30min / 2012-11-26

all etf 30-min files

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

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-26 04:00:00	SPY	ETF	140.74	140.74	140.55	140.68	29778.0
2012-11-26 04:30:00	SPY	ETF	140.61	140.61	140.43	140.43	2000.0
2012-11-26 05:00:00	SPY	ETF	140.51	140.56	140.43	140.56	16600.0
2012-11-26 05:30:00	SPY	ETF	140.56	140.71	140.56	140.71	42250.0
2012-11-26 06:00:00	SPY	ETF	140.74	140.74	140.62	140.64	1700.0
2012-11-26 06:30:00	SPY	ETF	140.76	140.86	140.64	140.64	40654.0
2012-11-26 07:00:00	SPY	ETF	140.66	140.68	140.59	140.63	133048.0
2012-11-26 07:30:00	SPY	ETF	140.63	140.66	140.49	140.53	204111.0
2012-11-26 08:00:00	SPY	ETF	140.55	140.63	140.5	140.53	783938.0
2012-11-26 08:30:00	SPY	ETF	140.52	140.74	140.52	140.69	749587.0
2012-11-26 09:00:00	SPY	ETF	140.69	140.74	140.57	140.64	762241.0
2012-11-26 09:30:00	SPY	ETF	140.65	140.84	140.44	140.77	13291263.0
2012-11-26 10:00:00	SPY	ETF	140.77	140.88	140.58	140.66	8192523.0
2012-11-26 10:30:00	SPY	ETF	140.66	140.78	140.49	140.51	5982367.0
2012-11-26 11:00:00	SPY	ETF	140.51	141.3563	140.19	140.33	8723898.0
2012-11-26 11:30:00	SPY	ETF	140.33	140.55	140.31	140.54	5002683.0
2012-11-26 12:00:00	SPY	ETF	140.55	141.3563	140.47	140.509	3237481.0
2012-11-26 12:30:00	SPY	ETF	140.51	140.78	140.35	140.7	5573771.0
2012-11-26 13:00:00	SPY	ETF	140.7	140.85	140.63	140.74	3947070.0
2012-11-26 13:30:00	SPY	ETF	140.75	140.83	140.59	140.66	3448090.0
2012-11-26 14:00:00	SPY	ETF	140.67	141.3563	140.58	140.62	7052875.0
2012-11-26 14:30:00	SPY	ETF	140.625	140.93	140.62	140.85	4547031.0
2012-11-26 15:00:00	SPY	ETF	140.845	140.91	140.74	140.85	5277920.0
2012-11-26 15:30:00	SPY	ETF	140.85	141.11	140.7	141.09	11794043.0
2012-11-26 16:00:00	SPY	ETF	141.09	141.3563	140.25	140.5148	7549746.0
2012-11-26 16:30:00	SPY	ETF	141.025	141.05	140.7593	141.05	751488.0
2012-11-26 17:00:00	SPY	ETF	141.06	141.16	141.06	141.07	116989.0
2012-11-26 17:30:00	SPY	ETF	141.09	141.12	141.06	141.07	78775.0
2012-11-26 18:00:00	SPY	ETF	141.06	141.14	141.05	141.06	31359.0
2012-11-26 18:30:00	SPY	ETF	141.09	141.14	141.05	141.14	12500.0
2012-11-26 19:00:00	SPY	ETF	141.15	141.32	141.12	141.32	146395.0
2012-11-26 19:30:00	SPY	ETF	141.32	141.42	141.21	141.26	288392.0
2012-11-26 04:00:00	QQQ	ETF	64.67	64.67	64.59	64.59	200.0
2012-11-26 04:30:00	QQQ	ETF	64.58	64.58	64.54	64.54	1000.0
2012-11-26 05:30:00	QQQ	ETF	64.62	64.62	64.62	64.62	200.0
2012-11-26 06:30:00	QQQ	ETF	64.69	64.72	64.64	64.64	20500.0
2012-11-26 07:00:00	QQQ	ETF	64.66	64.66	64.63	64.65	5251.0
2012-11-26 07:30:00	QQQ	ETF	64.66	64.66	64.6	64.6	20450.0
2012-11-26 08:00:00	QQQ	ETF	64.64	64.67	64.6	64.62	86186.0
2012-11-26 08:30:00	QQQ	ETF	64.63	64.72	64.63	64.72	33706.0
2012-11-26 09:00:00	QQQ	ETF	64.7	64.78	64.69	64.75	270211.0
2012-11-26 09:30:00	QQQ	ETF	64.77	64.93	64.6104	64.89	4112156.0
2012-11-26 10:00:00	QQQ	ETF	64.9	64.9	64.71	64.76	1722269.0
2012-11-26 10:30:00	QQQ	ETF	64.76	64.87	64.72	64.73	1423071.0
2012-11-26 11:00:00	QQQ	ETF	64.73	64.77	64.54	64.63	2617763.0
2012-11-26 11:30:00	QQQ	ETF	64.63	64.82	64.621	64.79	902694.0
2012-11-26 12:00:00	QQQ	ETF	64.79	64.9	64.78	64.85	619280.0
2012-11-26 12:30:00	QQQ	ETF	64.85	65.01	64.75	64.94	2833542.0
2012-11-26 13:00:00	QQQ	ETF	64.945	65.04	64.91	64.96	1662804.0
2012-11-26 13:30:00	QQQ	ETF	64.96	65.05	64.94	64.97	704869.0

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

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