PREVIEW / stock_30min / 2011-05-18

all stock 30-min files

  file:    by_date/stock_30min/2011/2011-05-18.parquet
  size:    1.4 MB
  rows:    76,538
  symbols: 3,559

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-05-18 04:00:00	AAPL	Stock	12.0714	12.0714	12.0714	12.0714	2800.0
2011-05-18 07:00:00	AAPL	Stock	12.0404	12.0404	12.0046	12.005	134484.0
2011-05-18 07:30:00	AAPL	Stock	12.0146	12.0179	11.9893	11.9911	144200.0
2011-05-18 08:00:00	AAPL	Stock	12.0	12.0071	11.9714	11.9857	525532.0
2011-05-18 08:30:00	AAPL	Stock	11.9857	11.9986	11.9775	11.9979	345772.0
2011-05-18 09:00:00	AAPL	Stock	11.9968	12.0268	11.9946	12.0179	1819328.0
2011-05-18 09:30:00	AAPL	Stock	12.0168	12.0857	12.0	12.0743	63344428.0
2011-05-18 10:00:00	AAPL	Stock	12.0746	12.1204	12.0657	12.1089	38677184.0
2011-05-18 10:30:00	AAPL	Stock	12.1082	12.1411	12.1078	12.1336	35199808.0
2011-05-18 11:00:00	AAPL	Stock	12.1339	12.1495	12.133	12.135	31471440.0
2011-05-18 11:30:00	AAPL	Stock	12.1357	12.1382	12.1061	12.1196	16144380.0
2011-05-18 12:00:00	AAPL	Stock	12.1204	12.1321	12.1157	12.1225	9470440.0
2011-05-18 12:30:00	AAPL	Stock	12.1213	12.1429	12.1111	12.1357	12463920.0
2011-05-18 13:00:00	AAPL	Stock	12.1371	12.1586	12.1304	12.1329	14650216.0
2011-05-18 13:30:00	AAPL	Stock	12.1322	12.1768	12.1312	12.1632	14148540.0
2011-05-18 14:00:00	AAPL	Stock	12.1621	12.1804	12.1486	12.1557	20728820.0
2011-05-18 14:30:00	AAPL	Stock	12.1537	12.1643	12.1254	12.14	16911944.0
2011-05-18 15:00:00	AAPL	Stock	12.1404	12.16	12.1332	12.155	15733816.0
2011-05-18 15:30:00	AAPL	Stock	12.155	12.16	12.1329	12.135	33083792.0
2011-05-18 16:00:00	AAPL	Stock	12.1357	12.1523	12.005	12.1382	6972252.0
2011-05-18 16:30:00	AAPL	Stock	12.1386	12.1556	12.1386	12.1479	306908.0
2011-05-18 17:00:00	AAPL	Stock	12.1432	12.1464	12.1429	12.1464	22848.0
2011-05-18 17:30:00	AAPL	Stock	12.1432	12.1457	12.1432	12.1457	16408.0
2011-05-18 18:00:00	AAPL	Stock	12.1471	12.1521	12.1382	12.1521	183092.0
2011-05-18 18:30:00	AAPL	Stock	12.1496	12.1521	12.1496	12.1521	30800.0
2011-05-18 19:00:00	AAPL	Stock	12.1536	12.1679	12.1536	12.1607	330456.0
2011-05-18 19:30:00	AAPL	Stock	12.1668	12.1671	12.1571	12.1607	167020.0
2011-05-18 06:00:00	MSFT	Stock	24.64	24.64	24.64	24.64	200.0
2011-05-18 06:30:00	MSFT	Stock	24.59	24.59	24.59	24.59	450.0
2011-05-18 07:00:00	MSFT	Stock	24.6	24.6	24.59	24.59	13000.0
2011-05-18 07:30:00	MSFT	Stock	24.59	24.6	24.57	24.59	4570.0
2011-05-18 08:00:00	MSFT	Stock	24.6	24.6	24.56	24.58	5659.0
2011-05-18 08:30:00	MSFT	Stock	24.58	24.59	24.56	24.57	2700.0
2011-05-18 09:00:00	MSFT	Stock	24.58	24.6	24.5	24.53	14141.0
2011-05-18 09:30:00	MSFT	Stock	24.55	24.55	24.3	24.32	6071461.0
2011-05-18 10:00:00	MSFT	Stock	24.31	24.42	24.25	24.408	6724091.0
2011-05-18 10:30:00	MSFT	Stock	24.41	24.49	24.37	24.45	5177791.0
2011-05-18 11:00:00	MSFT	Stock	24.45	24.62	24.44	24.603	4504207.0
2011-05-18 11:30:00	MSFT	Stock	24.605	24.605	24.54	24.57	2422955.0
2011-05-18 12:00:00	MSFT	Stock	24.57	24.6	24.5	24.56	4027529.0
2011-05-18 12:30:00	MSFT	Stock	24.55	24.57	24.47	24.49	2905429.0
2011-05-18 13:00:00	MSFT	Stock	24.49	24.58	24.48	24.57	1271222.0
2011-05-18 13:30:00	MSFT	Stock	24.575	24.68	24.56	24.63	2299426.0
2011-05-18 14:00:00	MSFT	Stock	24.635	24.74	24.61	24.62	3954391.0
2011-05-18 14:30:00	MSFT	Stock	24.62	24.64	24.58	24.629	2501270.0
2011-05-18 15:00:00	MSFT	Stock	24.63	24.72	24.605	24.685	2580628.0
2011-05-18 15:30:00	MSFT	Stock	24.685	24.7	24.65	24.69	5850472.0
2011-05-18 16:00:00	MSFT	Stock	24.7	24.716	24.52	24.68	2741498.0
2011-05-18 16:30:00	MSFT	Stock	24.703	24.703	24.67	24.67	53201.0
2011-05-18 17:00:00	MSFT	Stock	24.68	24.69	24.67	24.67	2800.0

> showing 50 of 76,538 rows — these rows as CSV

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