PREVIEW / stock_30min / 2013-05-03

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-05-03.parquet
  size:    1.5 MB
  rows:    79,025
  symbols: 3,509

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
2013-05-03 04:00:00	AAPL	Stock	15.9643	15.9661	15.9643	15.9661	8400.0
2013-05-03 04:30:00	AAPL	Stock	15.985	15.985	15.9821	15.9821	9044.0
2013-05-03 05:00:00	AAPL	Stock	15.9696	15.9696	15.9571	15.9571	14000.0
2013-05-03 07:00:00	AAPL	Stock	15.9654	15.9786	15.9429	15.9561	105308.0
2013-05-03 07:30:00	AAPL	Stock	15.9643	15.9643	15.9407	15.9464	76412.0
2013-05-03 08:00:00	AAPL	Stock	15.9364	15.9786	15.92	15.9286	827876.0
2013-05-03 08:30:00	AAPL	Stock	15.9357	16.0871	15.9357	16.0804	5234992.0
2013-05-03 09:00:00	AAPL	Stock	16.0679	16.1196	16.0679	16.1171	3850364.0
2013-05-03 09:30:00	AAPL	Stock	16.1125	16.1868	16.09	16.1121	86605064.0
2013-05-03 10:00:00	AAPL	Stock	16.1125	16.125	16.0539	16.0994	45022880.0
2013-05-03 10:30:00	AAPL	Stock	16.1025	16.1411	16.0989	16.1307	27130012.0
2013-05-03 11:00:00	AAPL	Stock	16.1314	16.1429	16.0893	16.0964	21533876.0
2013-05-03 11:30:00	AAPL	Stock	16.0982	16.1232	16.0929	16.1025	14787276.0
2013-05-03 12:00:00	AAPL	Stock	16.1036	16.1146	16.0936	16.1068	9387448.0
2013-05-03 12:30:00	AAPL	Stock	16.1071	16.1182	16.0964	16.1118	9976932.0
2013-05-03 13:00:00	AAPL	Stock	16.1136	16.1321	16.1036	16.1082	10497452.0
2013-05-03 13:30:00	AAPL	Stock	16.1043	16.1125	16.0825	16.0966	11282964.0
2013-05-03 14:00:00	AAPL	Stock	16.0971	16.1175	16.075	16.1129	12671820.0
2013-05-03 14:30:00	AAPL	Stock	16.1129	16.1129	16.0821	16.0827	11381580.0
2013-05-03 15:00:00	AAPL	Stock	16.0829	16.09	16.0646	16.0771	27604920.0
2013-05-03 15:30:00	AAPL	Stock	16.0768	16.0907	16.0411	16.0689	36882440.0
2013-05-03 16:00:00	AAPL	Stock	16.0707	16.118	15.8925	16.0707	17722572.0
2013-05-03 16:30:00	AAPL	Stock	16.0714	16.0738	16.0707	16.0714	872872.0
2013-05-03 17:00:00	AAPL	Stock	16.0718	16.0718	16.0707	16.0714	204064.0
2013-05-03 17:30:00	AAPL	Stock	16.0714	16.0718	16.0704	16.0718	113792.0
2013-05-03 18:00:00	AAPL	Stock	16.0725	16.0729	16.0696	16.0696	64456.0
2013-05-03 18:30:00	AAPL	Stock	16.0693	16.075	16.0686	16.0714	105784.0
2013-05-03 19:00:00	AAPL	Stock	16.0711	16.0718	16.0589	16.0589	57288.0
2013-05-03 19:30:00	AAPL	Stock	16.0643	16.0714	16.0643	16.0714	22820.0
2013-05-03 05:00:00	MSFT	Stock	33.02	33.02	33.02	33.02	100.0
2013-05-03 06:00:00	MSFT	Stock	33.02	33.02	33.02	33.02	100.0
2013-05-03 06:30:00	MSFT	Stock	32.97	32.97	32.97	32.97	1865.0
2013-05-03 07:00:00	MSFT	Stock	33.02	33.06	33.02	33.06	600.0
2013-05-03 07:30:00	MSFT	Stock	33.0	33.0	33.0	33.0	100.0
2013-05-03 08:00:00	MSFT	Stock	33.06	33.08	33.05	33.08	2929.0
2013-05-03 08:30:00	MSFT	Stock	33.12	33.39	33.12	33.37	109516.0
2013-05-03 09:00:00	MSFT	Stock	33.37	33.4	33.21	33.22	104465.0
2013-05-03 09:30:00	MSFT	Stock	33.23	33.47	33.08	33.435	6641592.0
2013-05-03 10:00:00	MSFT	Stock	33.43	33.46	33.3	33.45	4209614.0
2013-05-03 10:30:00	MSFT	Stock	33.456	33.52	33.37	33.42	4002276.0
2013-05-03 11:00:00	MSFT	Stock	33.43	33.48	33.395	33.43	3347084.0
2013-05-03 11:30:00	MSFT	Stock	33.42	33.48	33.4	33.43	2603739.0
2013-05-03 12:00:00	MSFT	Stock	33.43	33.44	33.35	33.4	1990301.0
2013-05-03 12:30:00	MSFT	Stock	33.4	33.43	33.35	33.4	1980930.0
2013-05-03 13:00:00	MSFT	Stock	33.41	33.5	33.405	33.43	2002263.0
2013-05-03 13:30:00	MSFT	Stock	33.42	33.44	33.31	33.362	2113509.0
2013-05-03 14:00:00	MSFT	Stock	33.36	33.43	33.33	33.425	2093906.0
2013-05-03 14:30:00	MSFT	Stock	33.42	33.435	33.37	33.39	2877351.0
2013-05-03 15:00:00	MSFT	Stock	33.39	33.46	33.38	33.433	2739170.0
2013-05-03 15:30:00	MSFT	Stock	33.435	33.5	33.41	33.49	6153232.0

> showing 50 of 79,025 rows — these rows as CSV

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