PREVIEW / stock_30min / 2011-09-08

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-09-08.parquet
  size:    1.4 MB
  rows:    74,454
  symbols: 3,505

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
2011-09-08 05:30:00	AAPL	Stock	13.7679	13.7679	13.7571	13.7571	16800.0
2011-09-08 06:00:00	AAPL	Stock	13.75	13.7839	13.75	13.7839	112000.0
2011-09-08 06:30:00	AAPL	Stock	13.7857	13.7857	13.775	13.775	5600.0
2011-09-08 07:00:00	AAPL	Stock	13.7607	13.7857	13.7607	13.7625	371448.0
2011-09-08 07:30:00	AAPL	Stock	13.7604	13.7714	13.7096	13.7136	337260.0
2011-09-08 08:00:00	AAPL	Stock	13.7143	13.725	13.6836	13.6839	647276.0
2011-09-08 08:30:00	AAPL	Stock	13.685	13.7	13.6379	13.6461	2321760.0
2011-09-08 09:00:00	AAPL	Stock	13.6443	13.6679	13.6164	13.6518	2606436.0
2011-09-08 09:30:00	AAPL	Stock	13.6546	13.7493	13.6539	13.7275	58780568.0
2011-09-08 10:00:00	AAPL	Stock	13.7293	13.81	13.6979	13.8039	49220248.0
2011-09-08 10:30:00	AAPL	Stock	13.8039	13.8632	13.8007	13.8614	33043304.0
2011-09-08 11:00:00	AAPL	Stock	13.8635	13.8789	13.82	13.8207	28947492.0
2011-09-08 11:30:00	AAPL	Stock	13.8221	13.8454	13.7536	13.7661	23539992.0
2011-09-08 12:00:00	AAPL	Stock	13.7664	13.8111	13.75	13.7782	18971596.0
2011-09-08 12:30:00	AAPL	Stock	13.7766	13.8096	13.745	13.8018	18435368.0
2011-09-08 13:00:00	AAPL	Stock	13.8036	13.8154	13.7732	13.7836	9908192.0
2011-09-08 13:30:00	AAPL	Stock	13.7857	13.8179	13.7071	13.75	34934984.0
2011-09-08 14:00:00	AAPL	Stock	13.75	13.7961	13.7261	13.7464	26042660.0
2011-09-08 14:30:00	AAPL	Stock	13.7464	13.7754	13.7304	13.761	18496016.0
2011-09-08 15:00:00	AAPL	Stock	13.7593	13.7659	13.6889	13.7639	35804552.0
2011-09-08 15:30:00	AAPL	Stock	13.7636	13.7754	13.7175	13.7211	41103804.0
2011-09-08 16:00:00	AAPL	Stock	13.7199	13.805	13.7075	13.7268	10454276.0
2011-09-08 16:30:00	AAPL	Stock	13.7261	13.763	13.6599	13.6599	203532.0
2011-09-08 17:00:00	AAPL	Stock	13.7229	13.7229	13.7107	13.7186	69160.0
2011-09-08 17:30:00	AAPL	Stock	13.715	13.7218	13.7143	13.7168	61600.0
2011-09-08 18:00:00	AAPL	Stock	13.7157	13.7346	13.7157	13.7275	150276.0
2011-09-08 18:30:00	AAPL	Stock	13.7214	13.7386	13.7214	13.7296	86968.0
2011-09-08 19:00:00	AAPL	Stock	13.7293	13.7393	13.7218	13.7243	103740.0
2011-09-08 19:30:00	AAPL	Stock	13.7296	13.7418	13.7	13.7143	403592.0
2011-09-08 06:00:00	MSFT	Stock	26.06	26.07	26.06	26.07	900.0
2011-09-08 07:30:00	MSFT	Stock	26.09	26.09	25.98	25.98	3034.0
2011-09-08 08:00:00	MSFT	Stock	26.0	26.0	25.95	25.97	9250.0
2011-09-08 08:30:00	MSFT	Stock	25.95	25.95	25.81	25.85	13349.0
2011-09-08 09:00:00	MSFT	Stock	25.84	26.02	25.84	25.98	38002.0
2011-09-08 09:30:00	MSFT	Stock	25.97	26.46	25.95	26.45	7600200.0
2011-09-08 10:00:00	MSFT	Stock	26.46	26.61	26.35	26.59	6631505.0
2011-09-08 10:30:00	MSFT	Stock	26.59	26.63	26.54	26.615	4277620.0
2011-09-08 11:00:00	MSFT	Stock	26.62	26.66	26.53	26.583	3949970.0
2011-09-08 11:30:00	MSFT	Stock	26.58	26.66	26.49	26.505	4044295.0
2011-09-08 12:00:00	MSFT	Stock	26.5	26.5	26.41	26.435	4122084.0
2011-09-08 12:30:00	MSFT	Stock	26.44	26.44	26.32	26.32	5134004.0
2011-09-08 13:00:00	MSFT	Stock	26.32	26.33	26.23	26.26	5022202.0
2011-09-08 13:30:00	MSFT	Stock	26.26	26.33	26.18	26.3	4551343.0
2011-09-08 14:00:00	MSFT	Stock	26.305	26.37	26.25	26.29	4328402.0
2011-09-08 14:30:00	MSFT	Stock	26.28	26.335	26.26	26.335	2313787.0
2011-09-08 15:00:00	MSFT	Stock	26.33	26.37	26.21	26.36	4057798.0
2011-09-08 15:30:00	MSFT	Stock	26.37	26.39	26.2	26.21	6580973.0
2011-09-08 16:00:00	MSFT	Stock	26.22	26.402	26.2	26.21	2078397.0
2011-09-08 16:30:00	MSFT	Stock	26.23	26.375	26.005	26.005	52222.0
2011-09-08 17:00:00	MSFT	Stock	26.25	26.25	26.23	26.23	1100.0

> showing 50 of 74,454 rows — these rows as CSV

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