PREVIEW / etf_30min / 2013-04-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-12.parquet
  size:    314 KB
  rows:    10,556

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-04-12 04:00:00	SPY	ETF	159.0	159.0	158.8	158.96	61475.0
2013-04-12 04:30:00	SPY	ETF	158.96	158.96	158.96	158.96	900.0
2013-04-12 05:00:00	SPY	ETF	158.82	158.82	158.66	158.74	26377.0
2013-04-12 05:30:00	SPY	ETF	158.8	158.85	158.66	158.79	28100.0
2013-04-12 06:00:00	SPY	ETF	158.8	158.85	158.77	158.77	28650.0
2013-04-12 06:30:00	SPY	ETF	158.78	158.88	158.78	158.85	111697.0
2013-04-12 07:00:00	SPY	ETF	158.88	158.9	158.76	158.79	285781.0
2013-04-12 07:30:00	SPY	ETF	158.79	158.81	158.63	158.67	1322815.0
2013-04-12 08:00:00	SPY	ETF	158.68	158.87	158.56	158.61	2513270.0
2013-04-12 08:30:00	SPY	ETF	158.65	158.8	158.32	158.64	1776955.0
2013-04-12 09:00:00	SPY	ETF	158.65	158.7	158.42	158.68	945076.0
2013-04-12 09:30:00	SPY	ETF	158.68	159.04	158.58	158.61	14733908.0
2013-04-12 10:00:00	SPY	ETF	158.61	158.84	158.49	158.69	8778772.0
2013-04-12 10:30:00	SPY	ETF	158.69	158.7	158.0	158.14	11658422.0
2013-04-12 11:00:00	SPY	ETF	158.14	158.35	157.92	158.3	10143892.0
2013-04-12 11:30:00	SPY	ETF	158.305	158.49	158.14	158.485	7761329.0
2013-04-12 12:00:00	SPY	ETF	158.485	158.5	158.3	158.3	4167159.0
2013-04-12 12:30:00	SPY	ETF	158.3	158.605	158.29	158.57	4771484.0
2013-04-12 13:00:00	SPY	ETF	158.57	158.8	158.48	158.54	5735298.0
2013-04-12 13:30:00	SPY	ETF	158.54	158.67	158.47	158.55	3170844.0
2013-04-12 14:00:00	SPY	ETF	158.545	158.61	158.42	158.42	3570014.0
2013-04-12 14:30:00	SPY	ETF	158.42	158.55	158.37	158.5	4487126.0
2013-04-12 15:00:00	SPY	ETF	158.5	158.74	158.4603	158.635	5353049.0
2013-04-12 15:30:00	SPY	ETF	158.63	158.82	158.6	158.798	16012206.0
2013-04-12 16:00:00	SPY	ETF	158.81	159.2	158.59	158.62	6561755.0
2013-04-12 16:30:00	SPY	ETF	158.64	158.7	158.62	158.68	220279.0
2013-04-12 17:00:00	SPY	ETF	158.68	158.7	158.6	158.61	81173.0
2013-04-12 17:30:00	SPY	ETF	158.62	158.64	158.52	158.59	132350.0
2013-04-12 18:00:00	SPY	ETF	158.57	158.79	158.57	158.68	107858.0
2013-04-12 18:30:00	SPY	ETF	158.7	158.7	158.68	158.68	10757.0
2013-04-12 19:00:00	SPY	ETF	158.68	158.7	158.68	158.7	1661.0
2013-04-12 19:30:00	SPY	ETF	158.69	158.69	158.66	158.67	5404.0
2013-04-12 04:00:00	QQQ	ETF	69.99	69.99	69.9	69.9	200.0
2013-04-12 05:00:00	QQQ	ETF	69.83	69.83	69.79	69.79	5200.0
2013-04-12 06:30:00	QQQ	ETF	69.83	69.83	69.82	69.82	300.0
2013-04-12 07:00:00	QQQ	ETF	69.79	69.82	69.79	69.79	11600.0
2013-04-12 07:30:00	QQQ	ETF	69.76	69.76	69.68	69.69	837021.0
2013-04-12 08:00:00	QQQ	ETF	69.69	69.75	69.66	69.7	1682897.0
2013-04-12 08:30:00	QQQ	ETF	69.63	69.77	69.62	69.74	291288.0
2013-04-12 09:00:00	QQQ	ETF	69.74	69.84	69.62	69.83	473740.0
2013-04-12 09:30:00	QQQ	ETF	69.84	69.99	69.8	69.84	4861629.0
2013-04-12 10:00:00	QQQ	ETF	69.841	69.92	69.75	69.84	2051766.0
2013-04-12 10:30:00	QQQ	ETF	69.84	69.84	69.421	69.52	2474976.0
2013-04-12 11:00:00	QQQ	ETF	69.51	69.635	69.41	69.62	2921628.0
2013-04-12 11:30:00	QQQ	ETF	69.62	69.73	69.53	69.71	3138417.0
2013-04-12 12:00:00	QQQ	ETF	69.71	69.755	69.66	69.665	917928.0
2013-04-12 12:30:00	QQQ	ETF	69.66	69.83	69.66	69.81	1113845.0
2013-04-12 13:00:00	QQQ	ETF	69.81	69.9	69.795	69.84	1644671.0
2013-04-12 13:30:00	QQQ	ETF	69.84	69.89	69.78	69.848	900543.0
2013-04-12 14:00:00	QQQ	ETF	69.85	69.9	69.79	69.79	933633.0

> showing 50 of 10,556 rows — these rows as CSV

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