PREVIEW / stock_30min / 2012-01-27

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-27.parquet
  size:    1.4 MB
  rows:    74,239
  symbols: 3,507

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-01-27 04:00:00	AAPL	Stock	15.9039	15.9429	15.9039	15.9429	14000.0
2012-01-27 04:30:00	AAPL	Stock	15.9446	15.9464	15.9446	15.9464	16800.0
2012-01-27 05:00:00	AAPL	Stock	15.9639	15.9732	15.9596	15.9732	36400.0
2012-01-27 05:30:00	AAPL	Stock	15.975	15.9754	15.975	15.9754	8400.0
2012-01-27 06:00:00	AAPL	Stock	15.9718	15.9825	15.9586	15.9586	30800.0
2012-01-27 06:30:00	AAPL	Stock	15.9643	15.9643	15.9607	15.9607	22400.0
2012-01-27 07:00:00	AAPL	Stock	15.9464	15.9464	15.9279	15.9357	181972.0
2012-01-27 07:30:00	AAPL	Stock	15.9293	15.9421	15.9036	15.9096	151620.0
2012-01-27 08:00:00	AAPL	Stock	15.9071	15.9268	15.8418	15.9157	715652.0
2012-01-27 08:30:00	AAPL	Stock	15.8964	15.9089	15.835	15.8429	956872.0
2012-01-27 09:00:00	AAPL	Stock	15.84	15.875	15.84	15.8711	1086316.0
2012-01-27 09:30:00	AAPL	Stock	15.8693	15.9714	15.8489	15.9557	48163472.0
2012-01-27 10:00:00	AAPL	Stock	15.9557	15.9561	15.9075	15.9279	26043528.0
2012-01-27 10:30:00	AAPL	Stock	15.9275	15.9418	15.8929	15.9269	17786748.0
2012-01-27 11:00:00	AAPL	Stock	15.9271	15.9536	15.925	15.9425	18039644.0
2012-01-27 11:30:00	AAPL	Stock	15.9414	15.9425	15.9061	15.9168	14327880.0
2012-01-27 12:00:00	AAPL	Stock	15.9186	15.9243	15.895	15.9214	10403848.0
2012-01-27 12:30:00	AAPL	Stock	15.9211	15.9296	15.9046	15.9092	8002120.0
2012-01-27 13:00:00	AAPL	Stock	15.9114	15.9286	15.9068	15.9268	7382620.0
2012-01-27 13:30:00	AAPL	Stock	15.9268	15.94	15.9204	15.9329	10021480.0
2012-01-27 14:00:00	AAPL	Stock	15.9343	15.9389	15.915	15.9157	11400340.0
2012-01-27 14:30:00	AAPL	Stock	15.915	15.9304	15.9114	15.9247	9074268.0
2012-01-27 15:00:00	AAPL	Stock	15.925	15.9761	15.9236	15.9696	32792816.0
2012-01-27 15:30:00	AAPL	Stock	15.9696	16.0171	15.9554	15.9811	49372372.0
2012-01-27 16:00:00	AAPL	Stock	15.9796	15.9911	15.9419	15.9746	29550752.0
2012-01-27 16:30:00	AAPL	Stock	15.9746	16.0092	15.9677	15.9911	889476.0
2012-01-27 17:00:00	AAPL	Stock	15.9964	15.9964	15.9743	15.9821	119392.0
2012-01-27 17:30:00	AAPL	Stock	15.9868	15.9868	15.9779	15.9782	68600.0
2012-01-27 18:00:00	AAPL	Stock	15.9821	15.9821	15.9821	15.9821	8400.0
2012-01-27 18:30:00	AAPL	Stock	15.9886	15.9886	15.9793	15.9793	19600.0
2012-01-27 19:00:00	AAPL	Stock	15.9789	15.9864	15.9789	15.9864	42000.0
2012-01-27 19:30:00	AAPL	Stock	15.9829	15.9871	15.9821	15.9871	131040.0
2012-01-27 07:30:00	MSFT	Stock	29.46	29.46	29.46	29.46	300.0
2012-01-27 08:00:00	MSFT	Stock	29.67	29.67	29.5	29.51	4300.0
2012-01-27 08:30:00	MSFT	Stock	29.51	29.51	29.34	29.36	9585.0
2012-01-27 09:00:00	MSFT	Stock	29.36	29.51	29.36	29.44	36206.0
2012-01-27 09:30:00	MSFT	Stock	29.46	29.53	29.36	29.5	3343686.0
2012-01-27 10:00:00	MSFT	Stock	29.5	29.51	29.36	29.466	5022297.0
2012-01-27 10:30:00	MSFT	Stock	29.465	29.5	29.23	29.28	4690710.0
2012-01-27 11:00:00	MSFT	Stock	29.28	29.35	29.28	29.33	2592997.0
2012-01-27 11:30:00	MSFT	Stock	29.325	29.34	29.2	29.26	2253446.0
2012-01-27 12:00:00	MSFT	Stock	29.27	29.3	29.23	29.27	1806776.0
2012-01-27 12:30:00	MSFT	Stock	29.27	29.29	29.19	29.2	1758913.0
2012-01-27 13:00:00	MSFT	Stock	29.2	29.26	29.185	29.24	1546124.0
2012-01-27 13:30:00	MSFT	Stock	29.233	29.3	29.21	29.28	2542609.0
2012-01-27 14:00:00	MSFT	Stock	29.275	29.31	29.25	29.25	1997398.0
2012-01-27 14:30:00	MSFT	Stock	29.255	29.35	29.25	29.276	3054160.0
2012-01-27 15:00:00	MSFT	Stock	29.276	29.32	29.26	29.295	2753831.0
2012-01-27 15:30:00	MSFT	Stock	29.295	29.31	29.17	29.22	6947557.0
2012-01-27 16:00:00	MSFT	Stock	29.22	29.5	29.2	29.23	2376752.0

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

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