PREVIEW / stock_30min / 2013-06-14

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-06-14.parquet
  size:    1.5 MB
  rows:    77,084
  symbols: 3,500

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
2013-06-14 05:00:00	AAPL	Stock	15.5607	15.5718	15.5607	15.5718	68320.0
2013-06-14 06:00:00	AAPL	Stock	15.5536	15.5536	15.5536	15.5536	2800.0
2013-06-14 06:30:00	AAPL	Stock	15.5407	15.5429	15.5357	15.5357	38444.0
2013-06-14 07:00:00	AAPL	Stock	15.5257	15.5464	15.5243	15.5411	98084.0
2013-06-14 08:00:00	AAPL	Stock	15.5589	15.5639	15.5243	15.5439	247520.0
2013-06-14 08:30:00	AAPL	Stock	15.5425	15.5811	15.5425	15.5811	922740.0
2013-06-14 09:00:00	AAPL	Stock	15.5804	15.5961	15.5446	15.5557	1056804.0
2013-06-14 09:30:00	AAPL	Stock	15.5554	15.5818	15.4886	15.4975	36888040.0
2013-06-14 10:00:00	AAPL	Stock	15.4975	15.5389	15.4289	15.4446	28446236.0
2013-06-14 10:30:00	AAPL	Stock	15.4436	15.475	15.3989	15.4131	22166592.0
2013-06-14 11:00:00	AAPL	Stock	15.4129	15.4429	15.3832	15.3896	16398676.0
2013-06-14 11:30:00	AAPL	Stock	15.3896	15.41	15.3529	15.395	21960232.0
2013-06-14 12:00:00	AAPL	Stock	15.3921	15.4278	15.375	15.3982	12164488.0
2013-06-14 12:30:00	AAPL	Stock	15.4039	15.4167	15.3768	15.3843	8157408.0
2013-06-14 13:00:00	AAPL	Stock	15.3843	15.3846	15.3554	15.3604	12356316.0
2013-06-14 13:30:00	AAPL	Stock	15.3571	15.3646	15.3036	15.3429	19683468.0
2013-06-14 14:00:00	AAPL	Stock	15.3424	15.3732	15.3286	15.3594	13145664.0
2013-06-14 14:30:00	AAPL	Stock	15.3597	15.3871	15.3386	15.3439	10994816.0
2013-06-14 15:00:00	AAPL	Stock	15.3437	15.3675	15.3346	15.3407	11035304.0
2013-06-14 15:30:00	AAPL	Stock	15.3373	15.3575	15.3353	15.3547	31538276.0
2013-06-14 16:00:00	AAPL	Stock	15.3571	15.4926	15.35	15.3554	12187896.0
2013-06-14 16:30:00	AAPL	Stock	15.3539	15.3589	15.3521	15.3589	8998864.0
2013-06-14 17:00:00	AAPL	Stock	15.355	15.3589	15.3525	15.3557	135744.0
2013-06-14 17:30:00	AAPL	Stock	15.3525	15.3568	15.3525	15.3564	23548.0
2013-06-14 18:00:00	AAPL	Stock	15.3529	15.3557	15.3529	15.3529	15400.0
2013-06-14 18:30:00	AAPL	Stock	15.3536	15.3557	15.3521	15.3529	27636.0
2013-06-14 19:00:00	AAPL	Stock	15.3554	15.3554	15.3529	15.3529	15596.0
2013-06-14 19:30:00	AAPL	Stock	15.3529	15.3529	15.3489	15.3489	175336.0
2013-06-14 07:30:00	MSFT	Stock	34.6	34.61	34.6	34.6	1970.0
2013-06-14 08:00:00	MSFT	Stock	34.68	34.68	34.6	34.64	2970.0
2013-06-14 08:30:00	MSFT	Stock	34.61	34.72	34.61	34.69	80700.0
2013-06-14 09:00:00	MSFT	Stock	34.64	34.68	34.5	34.55	51351.0
2013-06-14 09:30:00	MSFT	Stock	34.55	34.69	34.36	34.395	6971070.0
2013-06-14 10:00:00	MSFT	Stock	34.4	34.52	34.39	34.48	4072470.0
2013-06-14 10:30:00	MSFT	Stock	34.48	34.49	34.32	34.4	3912901.0
2013-06-14 11:00:00	MSFT	Stock	34.395	34.44	34.33	34.4	2321965.0
2013-06-14 11:30:00	MSFT	Stock	34.4	34.41	34.33	34.36	1892083.0
2013-06-14 12:00:00	MSFT	Stock	34.37	34.41	34.34	34.395	1612404.0
2013-06-14 12:30:00	MSFT	Stock	34.395	34.44	34.34	34.36	1670929.0
2013-06-14 13:00:00	MSFT	Stock	34.36	34.39	34.25	34.34	1929908.0
2013-06-14 13:30:00	MSFT	Stock	34.34	34.35	34.265	34.33	1667018.0
2013-06-14 14:00:00	MSFT	Stock	34.325	34.41	34.28	34.39	1525405.0
2013-06-14 14:30:00	MSFT	Stock	34.4	34.41	34.34	34.355	1786583.0
2013-06-14 15:00:00	MSFT	Stock	34.355	34.415	34.34	34.355	2934452.0
2013-06-14 15:30:00	MSFT	Stock	34.36	34.41	34.32	34.4	4854439.0
2013-06-14 16:00:00	MSFT	Stock	34.39	34.432	34.318	34.4	15168632.0
2013-06-14 16:30:00	MSFT	Stock	34.393	34.4	34.36	34.4	67369.0
2013-06-14 17:00:00	MSFT	Stock	34.4	34.41	34.4	34.41	4869.0
2013-06-14 17:30:00	MSFT	Stock	34.41	34.42	34.38	34.38	3000.0
2013-06-14 18:00:00	MSFT	Stock	34.38	34.38	34.38	34.38	900.0

> showing 50 of 77,084 rows — these rows as CSV

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