PREVIEW / stock_30min / 2011-11-10

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-11-10.parquet
  size:    1.4 MB
  rows:    73,839
  symbols: 3,489

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-11-10 04:00:00	AAPL	Stock	14.1429	14.1607	14.1429	14.1514	44520.0
2011-11-10 04:30:00	AAPL	Stock	14.175	14.1971	14.175	14.1971	19600.0
2011-11-10 05:00:00	AAPL	Stock	14.1875	14.1875	14.1875	14.1875	2800.0
2011-11-10 07:00:00	AAPL	Stock	14.1875	14.2861	14.1871	14.2411	1029700.0
2011-11-10 07:30:00	AAPL	Stock	14.2464	14.2571	14.2207	14.2214	703220.0
2011-11-10 08:00:00	AAPL	Stock	14.2168	14.25	14.1964	14.2093	1437520.0
2011-11-10 08:30:00	AAPL	Stock	14.2107	14.2354	14.1979	14.2307	1289204.0
2011-11-10 09:00:00	AAPL	Stock	14.2286	14.2314	14.1786	14.1789	1601964.0
2011-11-10 09:30:00	AAPL	Stock	14.1825	14.1861	13.8254	13.8571	131331060.0
2011-11-10 10:00:00	AAPL	Stock	13.8571	13.8639	13.6625	13.7315	137941300.0
2011-11-10 10:30:00	AAPL	Stock	13.7314	13.8107	13.7025	13.7352	77811216.0
2011-11-10 11:00:00	AAPL	Stock	13.7386	13.8393	13.7339	13.7821	52140340.0
2011-11-10 11:30:00	AAPL	Stock	13.7832	13.8368	13.7539	13.7936	32407200.0
2011-11-10 12:00:00	AAPL	Stock	13.7936	13.8029	13.6786	13.6804	45967040.0
2011-11-10 12:30:00	AAPL	Stock	13.679	13.7479	13.6482	13.7334	46050200.0
2011-11-10 13:00:00	AAPL	Stock	13.7332	13.8214	13.7143	13.7614	35108192.0
2011-11-10 13:30:00	AAPL	Stock	13.7614	13.8	13.7265	13.7991	26442808.0
2011-11-10 14:00:00	AAPL	Stock	13.7984	13.8	13.7321	13.7357	23398032.0
2011-11-10 14:30:00	AAPL	Stock	13.7357	13.7675	13.6968	13.7018	27066340.0
2011-11-10 15:00:00	AAPL	Stock	13.7036	13.7579	13.6982	13.7418	33539212.0
2011-11-10 15:30:00	AAPL	Stock	13.7418	13.7675	13.7186	13.7575	54654908.0
2011-11-10 16:00:00	AAPL	Stock	13.7575	13.8147	13.7393	13.7475	9919812.0
2011-11-10 16:30:00	AAPL	Stock	13.745	13.7579	13.7232	13.7579	468076.0
2011-11-10 17:00:00	AAPL	Stock	13.7539	13.7579	13.7411	13.7411	253960.0
2011-11-10 17:30:00	AAPL	Stock	13.7464	13.7489	13.7382	13.7425	139020.0
2011-11-10 18:00:00	AAPL	Stock	13.7461	13.7579	13.7321	13.7343	148400.0
2011-11-10 18:30:00	AAPL	Stock	13.7321	13.745	13.7321	13.7411	44296.0
2011-11-10 19:00:00	AAPL	Stock	13.7482	13.7518	13.7425	13.7429	114632.0
2011-11-10 19:30:00	AAPL	Stock	13.7536	13.7571	13.7429	13.7571	70504.0
2011-11-10 04:30:00	MSFT	Stock	26.36	26.44	26.36	26.44	900.0
2011-11-10 05:00:00	MSFT	Stock	26.45	26.5	26.45	26.5	2700.0
2011-11-10 06:00:00	MSFT	Stock	26.4	26.4	26.4	26.4	2100.0
2011-11-10 07:00:00	MSFT	Stock	26.43	26.45	26.43	26.45	1500.0
2011-11-10 07:30:00	MSFT	Stock	26.45	26.51	26.45	26.48	3076.0
2011-11-10 08:00:00	MSFT	Stock	26.47	26.49	26.38	26.41	11344.0
2011-11-10 08:30:00	MSFT	Stock	26.45	26.46	26.41	26.42	8245.0
2011-11-10 09:00:00	MSFT	Stock	26.42	26.53	26.3	26.49	66352.0
2011-11-10 09:30:00	MSFT	Stock	26.48	26.5	26.28	26.33	3091410.0
2011-11-10 10:00:00	MSFT	Stock	26.315	26.42	26.3	26.33	3288230.0
2011-11-10 10:30:00	MSFT	Stock	26.33	26.33	26.12	26.19	2835570.0
2011-11-10 11:00:00	MSFT	Stock	26.2	26.33	26.18	26.23	2091052.0
2011-11-10 11:30:00	MSFT	Stock	26.225	26.34	26.19	26.3	2443928.0
2011-11-10 12:00:00	MSFT	Stock	26.3	26.32	26.2	26.21	1618220.0
2011-11-10 12:30:00	MSFT	Stock	26.205	26.3	26.17	26.29	1444650.0
2011-11-10 13:00:00	MSFT	Stock	26.29	26.43	26.275	26.357	1962191.0
2011-11-10 13:30:00	MSFT	Stock	26.35	26.44	26.345	26.43	1466620.0
2011-11-10 14:00:00	MSFT	Stock	26.428	26.44	26.31	26.325	1629355.0
2011-11-10 14:30:00	MSFT	Stock	26.32	26.35	26.23	26.233	1605715.0
2011-11-10 15:00:00	MSFT	Stock	26.24	26.34	26.2	26.32	2084778.0
2011-11-10 15:30:00	MSFT	Stock	26.32	26.38	26.26	26.28	5026669.0

> showing 50 of 73,839 rows — these rows as CSV

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