PREVIEW / etf_30min / 2013-04-08

all etf 30-min files

  file:    by_date/etf_30min/2013/2013-04-08.parquet
  size:    308 KB
  rows:    10,355

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-08 04:00:00	SPY	ETF	155.31	155.31	155.22	155.29	14972.0
2013-04-08 04:30:00	SPY	ETF	155.31	155.47	155.31	155.47	500.0
2013-04-08 05:00:00	SPY	ETF	155.42	155.42	155.39	155.41	5600.0
2013-04-08 05:30:00	SPY	ETF	155.41	155.41	155.41	155.41	39100.0
2013-04-08 06:00:00	SPY	ETF	155.46	155.46	155.42	155.42	3560.0
2013-04-08 06:30:00	SPY	ETF	155.42	155.52	155.42	155.5	43020.0
2013-04-08 07:00:00	SPY	ETF	155.49	155.61	155.48	155.57	225264.0
2013-04-08 07:30:00	SPY	ETF	155.57	155.62	155.47	155.61	122290.0
2013-04-08 08:00:00	SPY	ETF	155.59	155.62	155.45	155.45	295593.0
2013-04-08 08:30:00	SPY	ETF	155.46	155.54	155.42	155.43	425970.0
2013-04-08 09:00:00	SPY	ETF	155.44	155.44	155.23	155.27	565156.0
2013-04-08 09:30:00	SPY	ETF	155.27	155.3	154.81	155.02	11393436.0
2013-04-08 10:00:00	SPY	ETF	155.03	155.14	154.75	154.94	8585907.0
2013-04-08 10:30:00	SPY	ETF	154.94	155.26	154.89	155.22	5871259.0
2013-04-08 11:00:00	SPY	ETF	155.221	155.26	154.99	155.141	4083089.0
2013-04-08 11:30:00	SPY	ETF	155.14	155.22	155.015	155.06	3485163.0
2013-04-08 12:00:00	SPY	ETF	155.06	155.14	154.94	155.029	3791293.0
2013-04-08 12:30:00	SPY	ETF	155.02	155.205	155.02	155.1099	3078078.0
2013-04-08 13:00:00	SPY	ETF	155.11	155.29	155.1	155.2485	3115490.0
2013-04-08 13:30:00	SPY	ETF	155.24	155.625	155.22	155.601	4542178.0
2013-04-08 14:00:00	SPY	ETF	155.6022	155.8	155.58	155.689	5170142.0
2013-04-08 14:30:00	SPY	ETF	155.69	155.79	155.65	155.675	3232481.0
2013-04-08 15:00:00	SPY	ETF	155.67	155.85	155.67	155.85	4738880.0
2013-04-08 15:30:00	SPY	ETF	155.845	156.22	155.2534	156.19	15021928.0
2013-04-08 16:00:00	SPY	ETF	156.19	156.46	156.0223	156.35	5516660.0
2013-04-08 16:30:00	SPY	ETF	156.34	156.66	156.21	156.66	410427.0
2013-04-08 17:00:00	SPY	ETF	156.63	156.65	156.47	156.48	266029.0
2013-04-08 17:30:00	SPY	ETF	156.48	156.5	156.46	156.49	19805.0
2013-04-08 18:00:00	SPY	ETF	156.5	156.53	156.4	156.42	65479.0
2013-04-08 18:30:00	SPY	ETF	156.44	156.46	156.42	156.44	24200.0
2013-04-08 19:00:00	SPY	ETF	156.43	156.47	156.43	156.43	14884.0
2013-04-08 19:30:00	SPY	ETF	156.44	156.46	156.4	156.46	60151.0
2013-04-08 04:00:00	QQQ	ETF	67.97	67.97	67.97	67.97	1400.0
2013-04-08 05:00:00	QQQ	ETF	68.0	68.0	68.0	68.0	2000.0
2013-04-08 05:30:00	QQQ	ETF	67.97	67.97	67.97	67.97	2398.0
2013-04-08 06:00:00	QQQ	ETF	68.01	68.03	68.01	68.03	10602.0
2013-04-08 06:30:00	QQQ	ETF	68.04	68.04	68.03	68.03	4120.0
2013-04-08 07:00:00	QQQ	ETF	68.04	68.08	68.04	68.07	22700.0
2013-04-08 07:30:00	QQQ	ETF	68.07	68.1	68.07	68.1	21200.0
2013-04-08 08:00:00	QQQ	ETF	68.09	68.1	68.0	68.0	254030.0
2013-04-08 08:30:00	QQQ	ETF	68.0	68.03	68.0	68.02	62112.0
2013-04-08 09:00:00	QQQ	ETF	68.0	68.0	67.85	67.88	114418.0
2013-04-08 09:30:00	QQQ	ETF	67.88	67.955	67.78	67.88	2918394.0
2013-04-08 10:00:00	QQQ	ETF	67.88	67.91	67.69	67.77	1859551.0
2013-04-08 10:30:00	QQQ	ETF	67.78	67.88	67.73	67.87	854523.0
2013-04-08 11:00:00	QQQ	ETF	67.87	67.8892	67.76	67.8	675713.0
2013-04-08 11:30:00	QQQ	ETF	67.81	67.869	67.75	67.79	1061128.0
2013-04-08 12:00:00	QQQ	ETF	67.79	67.83	67.69	67.73	531988.0
2013-04-08 12:30:00	QQQ	ETF	67.73	67.82	67.73	67.79	255512.0
2013-04-08 13:00:00	QQQ	ETF	67.79	67.855	67.78	67.84	360732.0

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

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