PREVIEW / stock_30min / 2012-12-07

all stock 30-min files

  file:    by_date/stock_30min/2012/2012-12-07.parquet
  size:    1.4 MB
  rows:    74,489
  symbols: 3,481

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-12-07 04:00:00	AAPL	Stock	19.5736	19.5739	19.5736	19.5739	11200.0
2012-12-07 04:30:00	AAPL	Stock	19.5829	19.6	19.5829	19.6	8400.0
2012-12-07 05:00:00	AAPL	Stock	19.5743	19.5743	19.5743	19.5743	2800.0
2012-12-07 05:30:00	AAPL	Stock	19.5557	19.5557	19.5361	19.5396	29232.0
2012-12-07 06:00:00	AAPL	Stock	19.5393	19.5625	19.5393	19.5407	14000.0
2012-12-07 06:30:00	AAPL	Stock	19.5357	19.5496	19.5357	19.5357	22988.0
2012-12-07 07:00:00	AAPL	Stock	19.5568	19.6304	19.5536	19.6304	253372.0
2012-12-07 07:30:00	AAPL	Stock	19.6286	19.6871	19.5943	19.5943	624624.0
2012-12-07 08:00:00	AAPL	Stock	19.6068	19.6254	19.3929	19.5357	2897832.0
2012-12-07 08:30:00	AAPL	Stock	19.5339	19.7411	19.5321	19.6907	8247288.0
2012-12-07 09:00:00	AAPL	Stock	19.6857	19.7818	19.6714	19.7679	3938368.0
2012-12-07 09:30:00	AAPL	Stock	19.7654	19.8286	19.4114	19.4286	113419460.0
2012-12-07 10:00:00	AAPL	Stock	19.4239	19.6136	19.2961	19.3132	75331200.0
2012-12-07 10:30:00	AAPL	Stock	19.3154	19.4019	19.1346	19.2711	90899564.0
2012-12-07 11:00:00	AAPL	Stock	19.2711	19.3082	19.1607	19.2021	45559640.0
2012-12-07 11:30:00	AAPL	Stock	19.1989	19.2814	19.0436	19.0593	48951812.0
2012-12-07 12:00:00	AAPL	Stock	19.0593	19.1879	19.0171	19.05	57447544.0
2012-12-07 12:30:00	AAPL	Stock	19.0543	19.075	18.9286	19.0561	56435092.0
2012-12-07 13:00:00	AAPL	Stock	19.0562	19.115	19.0089	19.055	33116664.0
2012-12-07 13:30:00	AAPL	Stock	19.0575	19.075	18.9643	19.0682	28027216.0
2012-12-07 14:00:00	AAPL	Stock	19.0664	19.0982	18.9825	19.0691	29631980.0
2012-12-07 14:30:00	AAPL	Stock	19.07	19.2229	19.0536	19.1039	52077284.0
2012-12-07 15:00:00	AAPL	Stock	19.1036	19.155	18.9571	18.9829	45548440.0
2012-12-07 15:30:00	AAPL	Stock	18.9829	19.125	18.9693	19.0364	73330236.0
2012-12-07 16:00:00	AAPL	Stock	19.0354	19.5457	18.9875	19.0054	7961492.0
2012-12-07 16:30:00	AAPL	Stock	19.0029	19.0446	18.976	19.0043	647304.0
2012-12-07 17:00:00	AAPL	Stock	19.0061	19.0386	18.9732	18.985	1035048.0
2012-12-07 17:30:00	AAPL	Stock	18.9829	19.0386	18.9754	18.9807	552776.0
2012-12-07 18:00:00	AAPL	Stock	18.9821	18.9875	18.9771	18.9821	26572.0
2012-12-07 18:30:00	AAPL	Stock	18.9725	18.9889	18.9668	18.9889	218204.0
2012-12-07 19:00:00	AAPL	Stock	18.9936	19.0218	18.9936	19.0196	155764.0
2012-12-07 19:30:00	AAPL	Stock	19.0196	19.0196	19.0089	19.0089	365960.0
2012-12-07 05:30:00	MSFT	Stock	26.77	26.77	26.77	26.77	130.0
2012-12-07 08:00:00	MSFT	Stock	26.73	26.73	26.7	26.7	4650.0
2012-12-07 08:30:00	MSFT	Stock	26.77	26.91	26.77	26.83	37528.0
2012-12-07 09:00:00	MSFT	Stock	26.79	26.85	26.77	26.8	25458.0
2012-12-07 09:30:00	MSFT	Stock	26.81	26.82	26.41	26.42	5865905.0
2012-12-07 10:00:00	MSFT	Stock	26.42	26.52	26.38	26.44	4738104.0
2012-12-07 10:30:00	MSFT	Stock	26.44	26.52	26.415	26.475	3036889.0
2012-12-07 11:00:00	MSFT	Stock	26.47	26.5	26.39	26.495	2910387.0
2012-12-07 11:30:00	MSFT	Stock	26.5	26.53	26.43	26.45	2138477.0
2012-12-07 12:00:00	MSFT	Stock	26.46	26.51	26.45	26.48	1506187.0
2012-12-07 12:30:00	MSFT	Stock	26.48	26.48	26.44	26.443	1483988.0
2012-12-07 13:00:00	MSFT	Stock	26.45	26.48	26.43	26.475	2060900.0
2012-12-07 13:30:00	MSFT	Stock	26.473	26.48	26.42	26.43	1434357.0
2012-12-07 14:00:00	MSFT	Stock	26.44	26.44	26.41	26.42	1948880.0
2012-12-07 14:30:00	MSFT	Stock	26.42	26.49	26.4	26.4	3068991.0
2012-12-07 15:00:00	MSFT	Stock	26.4	26.41	26.37	26.38	4376853.0
2012-12-07 15:30:00	MSFT	Stock	26.385	26.47	26.38	26.46	7827410.0
2012-12-07 16:00:00	MSFT	Stock	26.45	26.74	26.385	26.464	2040955.0

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

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