PREVIEW / etf_30min / 2012-06-08

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-08.parquet
  size:    278 KB
  rows:    9,308

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-06-08 04:00:00	SPY	ETF	131.58	131.58	131.19	131.28	5970.0
2012-06-08 04:30:00	SPY	ETF	131.27	131.45	131.22	131.32	10500.0
2012-06-08 05:00:00	SPY	ETF	131.34	131.59	131.31	131.59	8395.0
2012-06-08 05:30:00	SPY	ETF	131.64	132.05	131.64	131.86	11958.0
2012-06-08 06:00:00	SPY	ETF	131.86	132.02	131.76	131.76	4300.0
2012-06-08 06:30:00	SPY	ETF	131.6	131.6	131.32	131.47	123944.0
2012-06-08 07:00:00	SPY	ETF	131.5	131.59	131.42	131.59	242488.0
2012-06-08 07:30:00	SPY	ETF	131.58	131.85	131.57	131.75	355727.0
2012-06-08 08:00:00	SPY	ETF	131.79	132.0	131.3	131.68	880734.0
2012-06-08 08:30:00	SPY	ETF	131.68	131.96	131.43	131.71	553851.0
2012-06-08 09:00:00	SPY	ETF	131.72	132.05	131.39	131.7	1310386.0
2012-06-08 09:30:00	SPY	ETF	131.71	131.79	131.29	131.63	19368541.0
2012-06-08 10:00:00	SPY	ETF	131.62	131.9	131.51	131.82	14676947.0
2012-06-08 10:30:00	SPY	ETF	131.82	132.31	131.74	132.27	9485206.0
2012-06-08 11:00:00	SPY	ETF	132.28	132.31	131.99	132.095	7311974.0
2012-06-08 11:30:00	SPY	ETF	132.09	132.28	132.04	132.045	5713098.0
2012-06-08 12:00:00	SPY	ETF	132.045	132.25	132.04	132.25	5337448.0
2012-06-08 12:30:00	SPY	ETF	132.24	132.6	132.24	132.57	6674631.0
2012-06-08 13:00:00	SPY	ETF	132.58	132.88	132.5575	132.72	8124539.0
2012-06-08 13:30:00	SPY	ETF	132.725	132.81	132.59	132.685	5507925.0
2012-06-08 14:00:00	SPY	ETF	132.69	132.78	132.63	132.74	6897113.0
2012-06-08 14:30:00	SPY	ETF	132.74	132.975	132.69	132.76	5080231.0
2012-06-08 15:00:00	SPY	ETF	132.76	132.97	132.72	132.8286	6541714.0
2012-06-08 15:30:00	SPY	ETF	132.83	133.125	132.74	133.09	22166028.0
2012-06-08 16:00:00	SPY	ETF	133.1	133.51	133.0	133.4	9999966.0
2012-06-08 16:30:00	SPY	ETF	133.39	133.42	133.2631	133.37	3972572.0
2012-06-08 17:00:00	SPY	ETF	133.37	133.4	133.29	133.38	286050.0
2012-06-08 17:30:00	SPY	ETF	133.38	133.53	133.38	133.48	249345.0
2012-06-08 18:00:00	SPY	ETF	133.49	133.52	133.36	133.37	113430.0
2012-06-08 18:30:00	SPY	ETF	133.36	133.46	133.34	133.4	86013.0
2012-06-08 19:00:00	SPY	ETF	133.4	133.43	133.36	133.38	31443.0
2012-06-08 19:30:00	SPY	ETF	133.38	133.53	133.38	133.5	50520.0
2012-06-08 04:00:00	QQQ	ETF	62.0	62.1	61.95	62.1	6030.0
2012-06-08 05:00:00	QQQ	ETF	61.89	61.9	61.89	61.9	19200.0
2012-06-08 05:30:00	QQQ	ETF	62.0	62.0	62.0	62.0	160.0
2012-06-08 06:30:00	QQQ	ETF	62.0	62.05	62.0	62.05	8400.0
2012-06-08 07:00:00	QQQ	ETF	62.02	62.04	61.96	62.04	22245.0
2012-06-08 07:30:00	QQQ	ETF	62.1	62.18	62.06	62.15	30490.0
2012-06-08 08:00:00	QQQ	ETF	62.16	62.26	62.04	62.1	131152.0
2012-06-08 08:30:00	QQQ	ETF	62.12	62.24	62.12	62.12	43770.0
2012-06-08 09:00:00	QQQ	ETF	62.16	62.29	62.13	62.14	101747.0
2012-06-08 09:30:00	QQQ	ETF	62.15	62.26	61.96	62.23	4550136.0
2012-06-08 10:00:00	QQQ	ETF	62.23	62.39	62.17	62.34	5465807.0
2012-06-08 10:30:00	QQQ	ETF	62.345	62.64	62.33	62.61	2807156.0
2012-06-08 11:00:00	QQQ	ETF	62.62	62.635	62.44	62.54	1591269.0
2012-06-08 11:30:00	QQQ	ETF	62.54	62.61	62.43	62.44	1257128.0
2012-06-08 12:00:00	QQQ	ETF	62.45	62.51	62.41	62.5	1231707.0
2012-06-08 12:30:00	QQQ	ETF	62.5	62.63	62.5	62.59	1344834.0
2012-06-08 13:00:00	QQQ	ETF	62.58	62.75	62.57	62.711	2119423.0
2012-06-08 13:30:00	QQQ	ETF	62.715	62.775	62.67	62.67	1556252.0

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

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