PREVIEW / stock_30min / 2013-04-30

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-30.parquet
  size:    1.5 MB
  rows:    78,674
  symbols: 3,487

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-04-30 04:00:00	AAPL	Stock	15.3571	15.3575	15.3571	15.3575	36456.0
2013-04-30 04:30:00	AAPL	Stock	15.4196	15.4196	15.4196	15.4196	16800.0
2013-04-30 05:30:00	AAPL	Stock	15.4268	15.4268	15.4268	15.4268	2800.0
2013-04-30 06:00:00	AAPL	Stock	15.4496	15.4521	15.4304	15.4304	9800.0
2013-04-30 06:30:00	AAPL	Stock	15.4289	15.4289	15.4186	15.4214	14000.0
2013-04-30 07:00:00	AAPL	Stock	15.4186	15.4286	15.3886	15.4021	185836.0
2013-04-30 07:30:00	AAPL	Stock	15.3996	15.4214	15.3996	15.405	139160.0
2013-04-30 08:00:00	AAPL	Stock	15.3986	15.4214	15.3536	15.4018	1763748.0
2013-04-30 08:30:00	AAPL	Stock	15.4068	15.4857	15.4011	15.4854	2747696.0
2013-04-30 09:00:00	AAPL	Stock	15.4832	15.5475	15.4554	15.5411	3998932.0
2013-04-30 09:30:00	AAPL	Stock	15.5393	15.6654	15.4311	15.4696	130116476.0
2013-04-30 10:00:00	AAPL	Stock	15.4716	15.5711	15.4621	15.5057	47536804.0
2013-04-30 10:30:00	AAPL	Stock	15.5082	15.5961	15.4836	15.5821	34381900.0
2013-04-30 11:00:00	AAPL	Stock	15.5807	15.7218	15.5779	15.6757	55357260.0
2013-04-30 11:30:00	AAPL	Stock	15.6757	15.7371	15.6521	15.6975	42196056.0
2013-04-30 12:00:00	AAPL	Stock	15.6979	15.7043	15.6539	15.6704	27394192.0
2013-04-30 12:30:00	AAPL	Stock	15.6714	15.8032	15.6572	15.7882	43131816.0
2013-04-30 13:00:00	AAPL	Stock	15.7868	15.9018	15.7868	15.8796	60763220.0
2013-04-30 13:30:00	AAPL	Stock	15.8804	15.8893	15.8107	15.8564	38998820.0
2013-04-30 14:00:00	AAPL	Stock	15.8514	15.8639	15.7701	15.8268	37654316.0
2013-04-30 14:30:00	AAPL	Stock	15.8254	15.8625	15.7929	15.8604	27608924.0
2013-04-30 15:00:00	AAPL	Stock	15.8554	15.8693	15.7843	15.8286	29852396.0
2013-04-30 15:30:00	AAPL	Stock	15.8265	15.8661	15.7904	15.8143	54438104.0
2013-04-30 16:00:00	AAPL	Stock	15.8143	15.829	15.5237	15.8107	16686012.0
2013-04-30 16:30:00	AAPL	Stock	15.8082	15.8317	15.8079	15.8132	948192.0
2013-04-30 17:00:00	AAPL	Stock	15.8132	15.8136	15.7857	15.8	554988.0
2013-04-30 17:30:00	AAPL	Stock	15.8	15.8125	15.7971	15.8071	150500.0
2013-04-30 18:00:00	AAPL	Stock	15.8054	15.8118	15.8036	15.805	125860.0
2013-04-30 18:30:00	AAPL	Stock	15.8082	15.8132	15.8075	15.8132	30940.0
2013-04-30 19:00:00	AAPL	Stock	15.8114	15.8207	15.8114	15.8179	167664.0
2013-04-30 19:30:00	AAPL	Stock	15.8168	15.8211	15.8129	15.8211	262584.0
2013-04-30 06:30:00	MSFT	Stock	32.59	32.59	32.59	32.59	1900.0
2013-04-30 07:00:00	MSFT	Stock	32.59	32.59	32.58	32.59	3600.0
2013-04-30 07:30:00	MSFT	Stock	32.6	32.69	32.6	32.61	5239.0
2013-04-30 08:00:00	MSFT	Stock	32.62	32.7	32.62	32.63	8375.0
2013-04-30 08:30:00	MSFT	Stock	32.62	32.64	32.61	32.63	79433.0
2013-04-30 09:00:00	MSFT	Stock	32.63	32.65	32.57	32.58	42250.0
2013-04-30 09:30:00	MSFT	Stock	32.56	32.68	32.28	32.48	10678313.0
2013-04-30 10:00:00	MSFT	Stock	32.48	32.8	32.44	32.67	6811149.0
2013-04-30 10:30:00	MSFT	Stock	32.66	32.88	32.65	32.834	4303368.0
2013-04-30 11:00:00	MSFT	Stock	32.84	32.9	32.81	32.89	2967329.0
2013-04-30 11:30:00	MSFT	Stock	32.88	32.89	32.82	32.83	2480134.0
2013-04-30 12:00:00	MSFT	Stock	32.83	32.85	32.77	32.85	2089632.0
2013-04-30 12:30:00	MSFT	Stock	32.84	32.9	32.79	32.866	2205457.0
2013-04-30 13:00:00	MSFT	Stock	32.87	32.94	32.86	32.895	2381217.0
2013-04-30 13:30:00	MSFT	Stock	32.9	32.95	32.83	32.925	2147618.0
2013-04-30 14:00:00	MSFT	Stock	32.925	32.95	32.875	32.9	7306493.0
2013-04-30 14:30:00	MSFT	Stock	32.9	32.98	32.875	32.975	5354203.0
2013-04-30 15:00:00	MSFT	Stock	32.97	32.98	32.88	32.895	4044400.0
2013-04-30 15:30:00	MSFT	Stock	32.89	33.11	32.88	33.09	13463184.0

> showing 50 of 78,674 rows — these rows as CSV

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