PREVIEW / stock_30min / 2013-04-24

all stock 30-min files

  file:    by_date/stock_30min/2013/2013-04-24.parquet
  size:    1.5 MB
  rows:    78,088
  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-24 04:00:00	AAPL	Stock	14.4829	14.6075	14.4829	14.5539	107800.0
2013-04-24 04:30:00	AAPL	Stock	14.585	14.585	14.5596	14.5632	14000.0
2013-04-24 05:00:00	AAPL	Stock	14.5554	14.5554	14.5357	14.5364	128240.0
2013-04-24 05:30:00	AAPL	Stock	14.5357	14.55	14.5179	14.5321	81200.0
2013-04-24 06:00:00	AAPL	Stock	14.5346	14.5346	14.4429	14.4893	218624.0
2013-04-24 06:30:00	AAPL	Stock	14.4464	14.4632	14.3482	14.3911	366016.0
2013-04-24 07:00:00	AAPL	Stock	14.4154	14.5	14.3929	14.4482	1436848.0
2013-04-24 07:30:00	AAPL	Stock	14.4507	14.4507	14.0893	14.1661	8318548.0
2013-04-24 08:00:00	AAPL	Stock	14.1696	14.25	13.9668	14.0964	18834312.0
2013-04-24 08:30:00	AAPL	Stock	14.0964	14.4595	13.9925	14.0357	12763240.0
2013-04-24 09:00:00	AAPL	Stock	14.035	14.1214	13.9946	14.055	10060428.0
2013-04-24 09:30:00	AAPL	Stock	14.0539	14.8304	14.0179	14.5814	273947436.0
2013-04-24 10:00:00	AAPL	Stock	14.5868	14.6511	14.1979	14.3393	146558776.0
2013-04-24 10:30:00	AAPL	Stock	14.3414	14.4461	14.2539	14.2996	70885976.0
2013-04-24 11:00:00	AAPL	Stock	14.3	14.3925	14.2679	14.3568	49058968.0
2013-04-24 11:30:00	AAPL	Stock	14.3586	14.3893	14.2701	14.2861	29821148.0
2013-04-24 12:00:00	AAPL	Stock	14.2857	14.3679	14.2768	14.3311	24097780.0
2013-04-24 12:30:00	AAPL	Stock	14.3311	14.3639	14.3079	14.3264	14984928.0
2013-04-24 13:00:00	AAPL	Stock	14.3296	14.5239	14.3269	14.4757	47400584.0
2013-04-24 13:30:00	AAPL	Stock	14.4725	14.521	14.4321	14.4554	31506104.0
2013-04-24 14:00:00	AAPL	Stock	14.45	14.605	14.44	14.5893	46844196.0
2013-04-24 14:30:00	AAPL	Stock	14.5911	14.6943	14.5682	14.6479	48669880.0
2013-04-24 15:00:00	AAPL	Stock	14.6477	14.6496	14.495	14.5164	48035232.0
2013-04-24 15:30:00	AAPL	Stock	14.5189	14.5764	14.4589	14.4846	56457044.0
2013-04-24 16:00:00	AAPL	Stock	14.4846	14.5	14.4378	14.48	10547880.0
2013-04-24 16:30:00	AAPL	Stock	14.4714	14.5194	14.0776	14.4821	423304.0
2013-04-24 17:00:00	AAPL	Stock	14.485	14.4893	14.4786	14.4821	7304808.0
2013-04-24 17:30:00	AAPL	Stock	14.475	14.4879	14.4696	14.4768	133756.0
2013-04-24 18:00:00	AAPL	Stock	14.4739	14.475	14.4671	14.4679	124180.0
2013-04-24 18:30:00	AAPL	Stock	14.4679	14.4807	14.4664	14.4668	48860.0
2013-04-24 19:00:00	AAPL	Stock	14.47	14.4732	14.4696	14.4732	28000.0
2013-04-24 19:30:00	AAPL	Stock	14.4746	14.4886	14.4732	14.4732	82404.0
2013-04-24 06:30:00	MSFT	Stock	30.65	30.65	30.65	30.65	3150.0
2013-04-24 07:00:00	MSFT	Stock	30.58	30.65	30.55	30.65	3740.0
2013-04-24 07:30:00	MSFT	Stock	30.65	30.65	30.65	30.65	900.0
2013-04-24 08:00:00	MSFT	Stock	30.58	30.6	30.58	30.6	2390.0
2013-04-24 08:30:00	MSFT	Stock	30.59	30.6	30.55	30.56	38100.0
2013-04-24 09:00:00	MSFT	Stock	30.56	30.6	30.56	30.6	20300.0
2013-04-24 09:30:00	MSFT	Stock	30.6	30.83	30.6	30.83	5759310.0
2013-04-24 10:00:00	MSFT	Stock	30.83	30.96	30.785	30.94	7064636.0
2013-04-24 10:30:00	MSFT	Stock	30.945	31.04	30.93	31.03	5479204.0
2013-04-24 11:00:00	MSFT	Stock	31.02	31.11	31.02	31.085	4065777.0
2013-04-24 11:30:00	MSFT	Stock	31.09	31.1	31.024	31.073	4025821.0
2013-04-24 12:00:00	MSFT	Stock	31.075	31.145	31.06	31.12	3667015.0
2013-04-24 12:30:00	MSFT	Stock	31.12	31.18	31.08	31.112	5242719.0
2013-04-24 13:00:00	MSFT	Stock	31.115	31.285	31.11	31.25	5734997.0
2013-04-24 13:30:00	MSFT	Stock	31.25	31.58	31.24	31.525	12957605.0
2013-04-24 14:00:00	MSFT	Stock	31.521	31.7	31.51	31.664	5386539.0
2013-04-24 14:30:00	MSFT	Stock	31.665	31.75	31.65	31.75	4346236.0
2013-04-24 15:00:00	MSFT	Stock	31.74	31.8	31.73	31.76	5558921.0

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

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