PREVIEW / stock_30min / 2012-01-20

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-20.parquet
  size:    1.4 MB
  rows:    74,031
  symbols: 3,506

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-20 04:00:00	AAPL	Stock	15.2107	15.2107	15.1821	15.2082	12040.0
2012-01-20 05:00:00	AAPL	Stock	15.155	15.155	15.1518	15.1518	28000.0
2012-01-20 05:30:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	11200.0
2012-01-20 06:00:00	AAPL	Stock	15.2225	15.2225	15.2225	15.2225	2800.0
2012-01-20 06:30:00	AAPL	Stock	15.2143	15.2143	15.2143	15.2143	2800.0
2012-01-20 07:00:00	AAPL	Stock	15.2096	15.2461	15.2096	15.2321	129164.0
2012-01-20 07:30:00	AAPL	Stock	15.2357	15.275	15.2357	15.2411	168980.0
2012-01-20 08:00:00	AAPL	Stock	15.2536	15.2536	15.2157	15.2371	198912.0
2012-01-20 08:30:00	AAPL	Stock	15.2321	15.2346	15.2214	15.2304	266224.0
2012-01-20 09:00:00	AAPL	Stock	15.2321	15.2682	15.2254	15.2571	1125348.0
2012-01-20 09:30:00	AAPL	Stock	15.2571	15.2679	15.1114	15.1625	81931976.0
2012-01-20 10:00:00	AAPL	Stock	15.16	15.1786	15.1489	15.1729	22025332.0
2012-01-20 10:30:00	AAPL	Stock	15.1729	15.1768	15.1468	15.1586	16624608.0
2012-01-20 11:00:00	AAPL	Stock	15.1589	15.1625	15.1525	15.1546	11938640.0
2012-01-20 11:30:00	AAPL	Stock	15.1543	15.1546	15.1289	15.1429	14917504.0
2012-01-20 12:00:00	AAPL	Stock	15.1421	15.1464	15.1411	15.1431	10907064.0
2012-01-20 12:30:00	AAPL	Stock	15.1425	15.1446	15.14	15.1414	10798872.0
2012-01-20 13:00:00	AAPL	Stock	15.1411	15.1446	15.1196	15.1232	13144572.0
2012-01-20 13:30:00	AAPL	Stock	15.1232	15.1271	15.04	15.0429	27715688.0
2012-01-20 14:00:00	AAPL	Stock	15.0421	15.0749	15.0186	15.0329	46141284.0
2012-01-20 14:30:00	AAPL	Stock	15.0325	15.0425	14.9911	15.0189	39568424.0
2012-01-20 15:00:00	AAPL	Stock	15.0193	15.0578	15.0111	15.0134	33761672.0
2012-01-20 15:30:00	AAPL	Stock	15.0146	15.0368	15.0	15.0093	58479428.0
2012-01-20 16:00:00	AAPL	Stock	15.011	15.2768	15.0007	15.0246	14908432.0
2012-01-20 16:30:00	AAPL	Stock	15.02	15.0339	15.0107	15.0339	750848.0
2012-01-20 17:00:00	AAPL	Stock	15.0354	15.0536	15.0289	15.0496	615468.0
2012-01-20 17:30:00	AAPL	Stock	15.0482	15.0643	15.0357	15.0396	578704.0
2012-01-20 18:00:00	AAPL	Stock	15.05	15.0643	15.0107	15.0643	325080.0
2012-01-20 18:30:00	AAPL	Stock	15.0618	15.0711	15.0611	15.0693	148120.0
2012-01-20 19:00:00	AAPL	Stock	15.0693	15.0818	15.0693	15.0771	269192.0
2012-01-20 19:30:00	AAPL	Stock	15.0811	15.0832	15.0714	15.0714	341796.0
2012-01-20 04:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	1000.0
2012-01-20 05:00:00	MSFT	Stock	28.64	28.76	28.64	28.76	2000.0
2012-01-20 05:30:00	MSFT	Stock	28.78	28.87	28.78	28.87	5000.0
2012-01-20 06:00:00	MSFT	Stock	28.77	28.77	28.7	28.7	1100.0
2012-01-20 06:30:00	MSFT	Stock	28.72	28.72	28.72	28.72	1000.0
2012-01-20 07:00:00	MSFT	Stock	28.71	28.78	28.7	28.78	16350.0
2012-01-20 07:30:00	MSFT	Stock	28.77	28.98	28.77	28.91	88282.0
2012-01-20 08:00:00	MSFT	Stock	28.91	28.93	28.82	28.85	271628.0
2012-01-20 08:30:00	MSFT	Stock	28.84	28.85	28.73	28.8	172888.0
2012-01-20 09:00:00	MSFT	Stock	28.79	28.88	28.68	28.81	816984.0
2012-01-20 09:30:00	MSFT	Stock	28.81	29.07	28.75	29.05	32843021.0
2012-01-20 10:00:00	MSFT	Stock	29.05	29.18	29.02	29.075	15696551.0
2012-01-20 10:30:00	MSFT	Stock	29.08	29.16	28.99	29.1	10701691.0
2012-01-20 11:00:00	MSFT	Stock	29.1	29.19	29.09	29.173	11267363.0
2012-01-20 11:30:00	MSFT	Stock	29.174	29.4	29.15	29.342	11817390.0
2012-01-20 12:00:00	MSFT	Stock	29.345	29.43	29.28	29.359	6899208.0
2012-01-20 12:30:00	MSFT	Stock	29.353	29.5	29.32	29.465	9329592.0
2012-01-20 13:00:00	MSFT	Stock	29.46	29.65	29.46	29.61	8001931.0
2012-01-20 13:30:00	MSFT	Stock	29.61	29.73	29.54	29.64	9322441.0

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

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