PREVIEW / etf_30min / 2012-05-10

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-10.parquet
  size:    285 KB
  rows:    9,720

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-05-10 04:00:00	SPY	ETF	136.14	136.14	135.72	135.72	1000.0
2012-05-10 04:30:00	SPY	ETF	135.83	136.0	135.83	136.0	3400.0
2012-05-10 05:00:00	SPY	ETF	135.78	135.78	135.46	135.52	29600.0
2012-05-10 05:30:00	SPY	ETF	135.5	135.6	135.39	135.51	31100.0
2012-05-10 06:00:00	SPY	ETF	135.54	135.72	135.54	135.71	15446.0
2012-05-10 06:30:00	SPY	ETF	135.83	136.04	135.7	136.0	72750.0
2012-05-10 07:00:00	SPY	ETF	135.94	135.98	135.7	135.96	183629.0
2012-05-10 07:30:00	SPY	ETF	135.95	136.48	135.93	136.47	596338.0
2012-05-10 08:00:00	SPY	ETF	136.48	136.61	135.45	136.53	947111.0
2012-05-10 08:30:00	SPY	ETF	136.53	136.85	136.4	136.58	1975050.0
2012-05-10 09:00:00	SPY	ETF	136.58	136.92	136.53	136.7	979912.0
2012-05-10 09:30:00	SPY	ETF	136.68	136.85	136.41	136.62	15202642.0
2012-05-10 10:00:00	SPY	ETF	136.62	136.79	136.18	136.23	16471626.0
2012-05-10 10:30:00	SPY	ETF	136.23	136.43	135.92	136.12	12888730.0
2012-05-10 11:00:00	SPY	ETF	136.12	136.31	135.92	136.28	9271036.0
2012-05-10 11:30:00	SPY	ETF	136.29	136.52	136.12	136.22	8958748.0
2012-05-10 12:00:00	SPY	ETF	136.22	136.37	135.92	136.3	8801722.0
2012-05-10 12:30:00	SPY	ETF	136.3	136.64	136.26	136.59	8763930.0
2012-05-10 13:00:00	SPY	ETF	136.59	136.64	136.42	136.58	7957611.0
2012-05-10 13:30:00	SPY	ETF	136.59	136.73	136.29	136.355	5919529.0
2012-05-10 14:00:00	SPY	ETF	136.34	136.51	136.33	136.48	3839839.0
2012-05-10 14:30:00	SPY	ETF	136.48	136.49	136.22	136.25	5581592.0
2012-05-10 15:00:00	SPY	ETF	136.25	136.35	136.12	136.27	7311801.0
2012-05-10 15:30:00	SPY	ETF	136.26	136.31	135.71	136.03	18749991.0
2012-05-10 16:00:00	SPY	ETF	136.01	136.4802	135.8853	136.33	8729316.0
2012-05-10 16:30:00	SPY	ETF	136.32	136.33	135.35	135.67	4171388.0
2012-05-10 17:00:00	SPY	ETF	135.69	135.7	134.97	135.2	1670028.0
2012-05-10 17:30:00	SPY	ETF	135.2	135.37	135.2	135.32	432410.0
2012-05-10 18:00:00	SPY	ETF	135.26	135.43	135.19	135.36	237656.0
2012-05-10 18:30:00	SPY	ETF	135.34	135.44	135.33	135.42	94675.0
2012-05-10 19:00:00	SPY	ETF	135.42	135.49	135.21	135.37	87241.0
2012-05-10 19:30:00	SPY	ETF	135.33	135.39	135.18	135.29	100997.0
2012-05-10 04:00:00	QQQ	ETF	63.82	64.33	63.82	64.21	8200.0
2012-05-10 04:30:00	QQQ	ETF	64.26	64.36	64.26	64.33	5500.0
2012-05-10 05:00:00	QQQ	ETF	64.2	64.2	64.2	64.2	1000.0
2012-05-10 06:00:00	QQQ	ETF	64.12	64.12	64.12	64.12	4000.0
2012-05-10 06:30:00	QQQ	ETF	64.26	64.34	64.26	64.32	39800.0
2012-05-10 07:00:00	QQQ	ETF	64.33	64.34	64.24	64.34	42500.0
2012-05-10 07:30:00	QQQ	ETF	64.37	64.55	64.37	64.55	128855.0
2012-05-10 08:00:00	QQQ	ETF	64.56	64.62	64.14	64.61	531847.0
2012-05-10 08:30:00	QQQ	ETF	64.62	64.74	64.55	64.61	238037.0
2012-05-10 09:00:00	QQQ	ETF	64.62	64.75	64.6	64.62	676393.0
2012-05-10 09:30:00	QQQ	ETF	64.61	64.63	64.26	64.35	7453422.0
2012-05-10 10:00:00	QQQ	ETF	64.36	64.425	64.035	64.07	4773118.0
2012-05-10 10:30:00	QQQ	ETF	64.07	64.29	64.0	64.13	4331586.0
2012-05-10 11:00:00	QQQ	ETF	64.14	64.23	64.05	64.2199	2116785.0
2012-05-10 11:30:00	QQQ	ETF	64.21	64.3	64.07	64.1295	2240215.0
2012-05-10 12:00:00	QQQ	ETF	64.128	64.17	63.95	64.1601	3239071.0
2012-05-10 12:30:00	QQQ	ETF	64.16	64.38	64.1301	64.37	3097370.0
2012-05-10 13:00:00	QQQ	ETF	64.37	64.39	64.28	64.37	2671166.0

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

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