PREVIEW / stock_30min / 2012-10-10

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-10-10.parquet
  size:    1.4 MB
  rows:    73,604
  symbols: 3,474

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-10-10 04:00:00	AAPL	Stock	22.8171	22.8214	22.8171	22.8214	76972.0
2012-10-10 04:30:00	AAPL	Stock	22.8071	22.8071	22.8071	22.8071	2800.0
2012-10-10 05:00:00	AAPL	Stock	22.8039	22.8039	22.7946	22.7946	14336.0
2012-10-10 05:30:00	AAPL	Stock	22.7929	22.7929	22.6911	22.7143	134652.0
2012-10-10 06:00:00	AAPL	Stock	22.7071	22.7179	22.7071	22.7179	75208.0
2012-10-10 06:30:00	AAPL	Stock	22.7286	22.7286	22.7286	22.7286	2800.0
2012-10-10 07:00:00	AAPL	Stock	22.7232	22.7643	22.7179	22.7571	283640.0
2012-10-10 07:30:00	AAPL	Stock	22.7643	22.8321	22.7639	22.8214	986300.0
2012-10-10 08:00:00	AAPL	Stock	22.8311	22.855	22.7839	22.8214	1971760.0
2012-10-10 08:30:00	AAPL	Stock	22.8107	22.8179	22.7557	22.7904	712124.0
2012-10-10 09:00:00	AAPL	Stock	22.7904	22.8489	22.7821	22.8482	1404368.0
2012-10-10 09:30:00	AAPL	Stock	22.8482	22.9489	22.75	22.835	98071316.0
2012-10-10 10:00:00	AAPL	Stock	22.8389	23.0	22.8286	22.9821	54854996.0
2012-10-10 10:30:00	AAPL	Stock	22.9884	23.0268	22.9143	22.9636	40472068.0
2012-10-10 11:00:00	AAPL	Stock	22.9639	23.035	22.9471	22.9978	32146520.0
2012-10-10 11:30:00	AAPL	Stock	22.996	23.0261	22.8686	22.9196	34752676.0
2012-10-10 12:00:00	AAPL	Stock	22.92	22.9521	22.8725	22.9279	22809752.0
2012-10-10 12:30:00	AAPL	Stock	22.9314	22.9325	22.7914	22.8096	28996268.0
2012-10-10 13:00:00	AAPL	Stock	22.8068	22.8968	22.7857	22.8746	25455752.0
2012-10-10 13:30:00	AAPL	Stock	22.8779	22.8779	22.8129	22.8598	17727332.0
2012-10-10 14:00:00	AAPL	Stock	22.8596	22.9529	22.8586	22.9312	23437820.0
2012-10-10 14:30:00	AAPL	Stock	22.9314	22.9814	22.8614	22.9076	24984680.0
2012-10-10 15:00:00	AAPL	Stock	22.9054	22.9343	22.8329	22.8614	26629792.0
2012-10-10 15:30:00	AAPL	Stock	22.8586	22.9043	22.8257	22.8886	40293792.0
2012-10-10 16:00:00	AAPL	Stock	22.8896	22.9416	22.8843	22.9014	15734684.0
2012-10-10 16:30:00	AAPL	Stock	22.8964	22.8964	22.8637	22.8761	609924.0
2012-10-10 17:00:00	AAPL	Stock	22.8804	22.8804	22.8432	22.85	222068.0
2012-10-10 17:30:00	AAPL	Stock	22.8511	22.8896	22.8496	22.8896	193872.0
2012-10-10 18:00:00	AAPL	Stock	22.8582	22.8643	22.8446	22.845	146384.0
2012-10-10 18:30:00	AAPL	Stock	22.8518	22.8557	22.8461	22.8471	128184.0
2012-10-10 19:00:00	AAPL	Stock	22.8536	22.8536	22.8286	22.8289	251188.0
2012-10-10 19:30:00	AAPL	Stock	22.8289	22.8393	22.8271	22.8393	269332.0
2012-10-10 07:00:00	MSFT	Stock	29.24	29.24	29.24	29.24	500.0
2012-10-10 07:30:00	MSFT	Stock	29.26	29.26	29.26	29.26	400.0
2012-10-10 08:00:00	MSFT	Stock	29.35	29.35	29.33	29.33	3740.0
2012-10-10 08:30:00	MSFT	Stock	29.31	29.33	29.24	29.24	15087.0
2012-10-10 09:00:00	MSFT	Stock	29.25	29.25	29.15	29.15	27804.0
2012-10-10 09:30:00	MSFT	Stock	29.15	29.26	29.03	29.18	4876790.0
2012-10-10 10:00:00	MSFT	Stock	29.18	29.31	29.16	29.3	3293816.0
2012-10-10 10:30:00	MSFT	Stock	29.3	29.31	29.145	29.204	3568966.0
2012-10-10 11:00:00	MSFT	Stock	29.21	29.24	29.18	29.238	1946913.0
2012-10-10 11:30:00	MSFT	Stock	29.24	29.25	29.15	29.195	2449817.0
2012-10-10 12:00:00	MSFT	Stock	29.19	29.23	29.16	29.2	1593310.0
2012-10-10 12:30:00	MSFT	Stock	29.2	29.21	29.12	29.14	1957416.0
2012-10-10 13:00:00	MSFT	Stock	29.14	29.16	29.06	29.07	5443090.0
2012-10-10 13:30:00	MSFT	Stock	29.07	29.1	29.01	29.06	2058918.0
2012-10-10 14:00:00	MSFT	Stock	29.055	29.09	28.97	29.03	3395400.0
2012-10-10 14:30:00	MSFT	Stock	29.02	29.06	28.97	28.995	2701859.0
2012-10-10 15:00:00	MSFT	Stock	29.0	29.03	28.97	28.99	3518841.0
2012-10-10 15:30:00	MSFT	Stock	29.0	29.01	28.95	28.99	5955562.0

> showing 50 of 73,604 rows — these rows as CSV

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