PREVIEW / etf_30min / 2013-03-12

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-03-12.parquet
  size:    303 KB
  rows:    10,384

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-03-12 04:00:00	SPY	ETF	155.75	155.86	155.71	155.71	19940.0
2013-03-12 04:30:00	SPY	ETF	155.85	155.85	155.85	155.85	1100.0
2013-03-12 05:00:00	SPY	ETF	155.89	155.96	155.85	155.85	32200.0
2013-03-12 05:30:00	SPY	ETF	155.84	155.84	155.75	155.84	18700.0
2013-03-12 06:00:00	SPY	ETF	155.8	155.84	155.7	155.77	17600.0
2013-03-12 06:30:00	SPY	ETF	155.79	155.84	155.79	155.81	900.0
2013-03-12 07:00:00	SPY	ETF	155.8	155.81	155.69	155.76	89993.0
2013-03-12 07:30:00	SPY	ETF	155.76	155.82	155.65	155.72	124111.0
2013-03-12 08:00:00	SPY	ETF	155.81	155.85	155.69	155.79	723901.0
2013-03-12 08:30:00	SPY	ETF	155.77	155.88	155.76	155.86	482994.0
2013-03-12 09:00:00	SPY	ETF	155.86	155.93	155.85	155.91	523163.0
2013-03-12 09:30:00	SPY	ETF	155.92	155.95	155.74	155.903	9889063.0
2013-03-12 10:00:00	SPY	ETF	155.91	156.1	155.9	156.06	6661757.0
2013-03-12 10:30:00	SPY	ETF	156.055	156.08	155.82	155.85	6444269.0
2013-03-12 11:00:00	SPY	ETF	155.86	155.86	155.34	155.349	10237304.0
2013-03-12 11:30:00	SPY	ETF	155.35	155.77	155.32	155.695	8984072.0
2013-03-12 12:00:00	SPY	ETF	155.7	155.74	155.42	155.48	4686840.0
2013-03-12 12:30:00	SPY	ETF	155.48	155.71	155.44	155.66	3631069.0
2013-03-12 13:00:00	SPY	ETF	155.67	155.67	155.51	155.56	2932910.0
2013-03-12 13:30:00	SPY	ETF	155.56	155.66	155.37	155.4	3939710.0
2013-03-12 14:00:00	SPY	ETF	155.41	155.465	155.21	155.31	7049093.0
2013-03-12 14:30:00	SPY	ETF	155.32	155.505	155.28	155.4	4159297.0
2013-03-12 15:00:00	SPY	ETF	155.4	155.76	155.39	155.64	6033503.0
2013-03-12 15:30:00	SPY	ETF	155.64	155.74	155.54	155.7	18350705.0
2013-03-12 16:00:00	SPY	ETF	155.69	155.72	155.5	155.71	4983479.0
2013-03-12 16:30:00	SPY	ETF	155.71	155.76	155.3192	155.76	491356.0
2013-03-12 17:00:00	SPY	ETF	155.75	156.0247	155.7	155.74	1548346.0
2013-03-12 17:30:00	SPY	ETF	155.73	155.74	155.73	155.74	5240.0
2013-03-12 18:00:00	SPY	ETF	155.72	155.72	155.65	155.69	15794.0
2013-03-12 18:30:00	SPY	ETF	155.7	155.72	155.7	155.7	16315.0
2013-03-12 19:00:00	SPY	ETF	155.66	155.74	155.66	155.73	23037.0
2013-03-12 19:30:00	SPY	ETF	155.73	155.75	155.68	155.73	36729.0
2013-03-12 04:00:00	QQQ	ETF	68.82	68.82	68.81	68.81	2500.0
2013-03-12 05:30:00	QQQ	ETF	68.8	68.8	68.8	68.8	1100.0
2013-03-12 06:00:00	QQQ	ETF	68.8	68.8	68.77	68.77	947.0
2013-03-12 07:00:00	QQQ	ETF	68.82	68.82	68.78	68.78	3700.0
2013-03-12 07:30:00	QQQ	ETF	68.78	68.79	68.74	68.74	12200.0
2013-03-12 08:00:00	QQQ	ETF	68.74	68.79	68.74	68.77	16775.0
2013-03-12 08:30:00	QQQ	ETF	68.76	68.8	68.74	68.77	83720.0
2013-03-12 09:00:00	QQQ	ETF	68.77	68.81	68.72	68.78	171711.0
2013-03-12 09:30:00	QQQ	ETF	68.78	68.9299	68.67	68.8601	3175993.0
2013-03-12 10:00:00	QQQ	ETF	68.86	68.9099	68.76	68.79	1445717.0
2013-03-12 10:30:00	QQQ	ETF	68.8	68.8	68.64	68.73	1248758.0
2013-03-12 11:00:00	QQQ	ETF	68.73	68.74	68.4	68.415	2485700.0
2013-03-12 11:30:00	QQQ	ETF	68.41	68.655	68.39	68.61	2186015.0
2013-03-12 12:00:00	QQQ	ETF	68.62	68.62	68.51	68.531	954165.0
2013-03-12 12:30:00	QQQ	ETF	68.53	68.695	68.53	68.66	861068.0
2013-03-12 13:00:00	QQQ	ETF	68.66	68.71	68.62	68.6499	711076.0
2013-03-12 13:30:00	QQQ	ETF	68.6499	68.69	68.51	68.55	956783.0
2013-03-12 14:00:00	QQQ	ETF	68.55	68.585	68.448	68.483	1046301.0

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

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