PREVIEW / stock_30min / 2012-01-25

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-01-25.parquet
  size:    1.4 MB
  rows:    76,197
  symbols: 3,536

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-25 04:00:00	AAPL	Stock	16.1143	16.1143	16.05	16.0543	145740.0
2012-01-25 04:30:00	AAPL	Stock	16.0571	16.0725	16.0411	16.0682	126812.0
2012-01-25 05:00:00	AAPL	Stock	16.0643	16.0804	16.0607	16.0804	145152.0
2012-01-25 05:30:00	AAPL	Stock	16.075	16.1393	16.0625	16.1393	169624.0
2012-01-25 06:00:00	AAPL	Stock	16.11	16.1536	16.11	16.1429	147000.0
2012-01-25 06:30:00	AAPL	Stock	16.1339	16.1536	16.1321	16.1429	165844.0
2012-01-25 07:00:00	AAPL	Stock	16.1339	16.1964	16.1339	16.1786	1914612.0
2012-01-25 07:30:00	AAPL	Stock	16.1786	16.2243	16.1571	16.2054	1881572.0
2012-01-25 08:00:00	AAPL	Stock	16.1986	16.2314	16.125	16.2282	8381380.0
2012-01-25 08:30:00	AAPL	Stock	16.2282	16.4107	16.2232	16.3786	18739140.0
2012-01-25 09:00:00	AAPL	Stock	16.3821	16.4	16.2143	16.2214	22511496.0
2012-01-25 09:30:00	AAPL	Stock	16.2236	16.2304	15.9732	16.0357	285535320.0
2012-01-25 10:00:00	AAPL	Stock	16.0346	16.0379	15.9007	15.98	103812492.0
2012-01-25 10:30:00	AAPL	Stock	15.9804	15.9821	15.9218	15.9554	52320492.0
2012-01-25 11:00:00	AAPL	Stock	15.9571	16.0578	15.9479	16.0407	72014208.0
2012-01-25 11:30:00	AAPL	Stock	16.0417	16.0568	15.9889	16.0232	33593504.0
2012-01-25 12:00:00	AAPL	Stock	16.0236	16.0286	15.925	15.9514	35851648.0
2012-01-25 12:30:00	AAPL	Stock	15.9511	15.9804	15.8475	15.8607	51035348.0
2012-01-25 13:00:00	AAPL	Stock	15.8618	15.96	15.8593	15.9429	39014612.0
2012-01-25 13:30:00	AAPL	Stock	15.9429	16.0036	15.9396	15.9979	34838468.0
2012-01-25 14:00:00	AAPL	Stock	15.9982	16.0	15.9525	15.9829	29913464.0
2012-01-25 14:30:00	AAPL	Stock	15.9839	15.9868	15.9411	15.9446	25887736.0
2012-01-25 15:00:00	AAPL	Stock	15.9432	15.9829	15.9364	15.9757	30723868.0
2012-01-25 15:30:00	AAPL	Stock	15.9781	15.9807	15.9464	15.9493	63324632.0
2012-01-25 16:00:00	AAPL	Stock	15.9482	16.0714	15.9482	15.9589	3061100.0
2012-01-25 16:30:00	AAPL	Stock	15.96	16.0032	15.9482	15.9482	1047032.0
2012-01-25 17:00:00	AAPL	Stock	15.9482	15.9521	15.9393	15.95	441840.0
2012-01-25 17:30:00	AAPL	Stock	15.9486	15.9639	15.9471	15.9639	186592.0
2012-01-25 18:00:00	AAPL	Stock	15.9625	15.9707	15.9611	15.9693	506772.0
2012-01-25 18:30:00	AAPL	Stock	15.965	15.965	15.9446	15.9446	194516.0
2012-01-25 19:00:00	AAPL	Stock	15.9464	15.9521	15.9375	15.9521	184352.0
2012-01-25 19:30:00	AAPL	Stock	15.9596	15.9643	15.9564	15.9643	168196.0
2012-01-25 07:00:00	MSFT	Stock	29.38	29.38	29.38	29.38	470.0
2012-01-25 07:30:00	MSFT	Stock	29.3	29.36	29.29	29.29	1580.0
2012-01-25 08:00:00	MSFT	Stock	29.32	29.37	29.24	29.26	11288.0
2012-01-25 08:30:00	MSFT	Stock	29.3	29.3	29.18	29.23	15270.0
2012-01-25 09:00:00	MSFT	Stock	29.23	29.27	29.02	29.1	135251.0
2012-01-25 09:30:00	MSFT	Stock	29.1	29.33	29.07	29.23	6484641.0
2012-01-25 10:00:00	MSFT	Stock	29.23	29.37	29.2	29.215	4459222.0
2012-01-25 10:30:00	MSFT	Stock	29.21	29.28	29.16	29.26	3278466.0
2012-01-25 11:00:00	MSFT	Stock	29.265	29.5	29.25	29.48	4868118.0
2012-01-25 11:30:00	MSFT	Stock	29.483	29.52	29.33	29.372	3641384.0
2012-01-25 12:00:00	MSFT	Stock	29.375	29.45	29.3	29.39	3726379.0
2012-01-25 12:30:00	MSFT	Stock	29.398	29.52	29.352	29.39	2724702.0
2012-01-25 13:00:00	MSFT	Stock	29.39	29.495	29.39	29.46	4997641.0
2012-01-25 13:30:00	MSFT	Stock	29.46	29.57	29.43	29.565	3778694.0
2012-01-25 14:00:00	MSFT	Stock	29.565	29.64	29.51	29.57	4253248.0
2012-01-25 14:30:00	MSFT	Stock	29.58	29.65	29.56	29.577	3175909.0
2012-01-25 15:00:00	MSFT	Stock	29.575	29.58	29.46	29.52	2897731.0
2012-01-25 15:30:00	MSFT	Stock	29.515	29.65	29.5	29.57	7289452.0

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

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