PREVIEW / etf_30min / 2012-04-25

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-04-25.parquet
  size:    281 KB
  rows:    9,531

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-04-25 04:00:00	SPY	ETF	138.3	138.7	138.3	138.61	8516.0
2012-04-25 04:30:00	SPY	ETF	138.48	138.6	138.4	138.6	13240.0
2012-04-25 05:00:00	SPY	ETF	138.54	138.54	138.43	138.43	700.0
2012-04-25 05:30:00	SPY	ETF	138.53	138.53	138.31	138.4	6600.0
2012-04-25 06:00:00	SPY	ETF	138.42	138.45	138.42	138.45	2400.0
2012-04-25 06:30:00	SPY	ETF	138.43	138.47	138.43	138.45	9790.0
2012-04-25 07:00:00	SPY	ETF	138.45	138.57	138.45	138.5	188130.0
2012-04-25 07:30:00	SPY	ETF	138.5	138.51	138.37	138.37	294715.0
2012-04-25 08:00:00	SPY	ETF	138.45	138.57	138.37	138.5	256553.0
2012-04-25 08:30:00	SPY	ETF	138.51	138.51	138.05	138.36	1270985.0
2012-04-25 09:00:00	SPY	ETF	138.35	138.67	138.32	138.64	1604097.0
2012-04-25 09:30:00	SPY	ETF	138.65	139.19	138.56	139.05	19893388.0
2012-04-25 10:00:00	SPY	ETF	139.05	139.09	138.73	138.845	11900321.0
2012-04-25 10:30:00	SPY	ETF	138.84	138.9	138.7	138.7399	10483745.0
2012-04-25 11:00:00	SPY	ETF	138.73	138.82	138.57	138.81	8537448.0
2012-04-25 11:30:00	SPY	ETF	138.81	138.82	138.63	138.68	4939905.0
2012-04-25 12:00:00	SPY	ETF	138.6707	138.81	138.64	138.76	4348649.0
2012-04-25 12:30:00	SPY	ETF	138.768	138.91	138.53	138.91	9263996.0
2012-04-25 13:00:00	SPY	ETF	138.9	139.08	138.85	138.9801	8677859.0
2012-04-25 13:30:00	SPY	ETF	138.985	139.04	138.87	138.92	3858151.0
2012-04-25 14:00:00	SPY	ETF	138.91	139.22	138.61	139.03	14535073.0
2012-04-25 14:30:00	SPY	ETF	139.035	139.13	138.7	139.1123	10970679.0
2012-04-25 15:00:00	SPY	ETF	139.11	139.25	138.94	138.969	8949680.0
2012-04-25 15:30:00	SPY	ETF	138.9615	139.22	138.94	139.19	17577610.0
2012-04-25 16:00:00	SPY	ETF	139.2	139.28	137.2901	139.25	10008728.0
2012-04-25 16:30:00	SPY	ETF	139.23	139.29	137.29	139.28	1373138.0
2012-04-25 17:00:00	SPY	ETF	139.28	139.3	139.2	139.28	219053.0
2012-04-25 17:30:00	SPY	ETF	139.26	139.28	139.23	139.28	13410.0
2012-04-25 18:00:00	SPY	ETF	139.25	139.28	139.25	139.25	4716.0
2012-04-25 18:30:00	SPY	ETF	139.26	139.28	139.24	139.24	76250.0
2012-04-25 19:00:00	SPY	ETF	139.26	139.28	139.21	139.21	5490.0
2012-04-25 19:30:00	SPY	ETF	139.21	139.3	139.19	139.21	25172.0
2012-04-25 04:00:00	QQQ	ETF	65.73	65.9	65.73	65.9	700.0
2012-04-25 04:30:00	QQQ	ETF	65.88	65.91	65.82	65.91	8682.0
2012-04-25 05:00:00	QQQ	ETF	65.87	65.87	65.85	65.85	500.0
2012-04-25 05:30:00	QQQ	ETF	65.84	65.91	65.84	65.91	1200.0
2012-04-25 06:30:00	QQQ	ETF	65.86	65.92	65.86	65.92	2513.0
2012-04-25 07:00:00	QQQ	ETF	65.93	65.97	65.91	65.94	44879.0
2012-04-25 07:30:00	QQQ	ETF	65.94	65.97	65.91	65.96	53661.0
2012-04-25 08:00:00	QQQ	ETF	65.95	66.03	65.94	65.98	559666.0
2012-04-25 08:30:00	QQQ	ETF	65.94	65.97	65.72	65.9	545847.0
2012-04-25 09:00:00	QQQ	ETF	65.9	66.07	65.89	66.06	845577.0
2012-04-25 09:30:00	QQQ	ETF	66.06	66.49	65.97	66.455	11725526.0
2012-04-25 10:00:00	QQQ	ETF	66.45	66.46	66.28	66.32	6213010.0
2012-04-25 10:30:00	QQQ	ETF	66.31	66.35	66.16	66.21	4032883.0
2012-04-25 11:00:00	QQQ	ETF	66.21	66.28	66.14	66.275	3165903.0
2012-04-25 11:30:00	QQQ	ETF	66.27	66.29	66.15	66.1699	2384238.0
2012-04-25 12:00:00	QQQ	ETF	66.17	66.255	66.17	66.23	1171537.0
2012-04-25 12:30:00	QQQ	ETF	66.23	66.3	66.11	66.27	2655859.0
2012-04-25 13:00:00	QQQ	ETF	66.2678	66.38	66.23	66.31	2276147.0

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

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