PREVIEW / stock_30min / 2010-12-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-12-07.parquet
  size:    1.5 MB
  rows:    80,149
  symbols: 3,536

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
2010-12-07 04:30:00	AAPL	Stock	11.4993	11.5025	11.4993	11.5025	11200.0
2010-12-07 05:00:00	AAPL	Stock	11.5464	11.5464	11.5411	11.5411	5600.0
2010-12-07 06:00:00	AAPL	Stock	11.5	11.5	11.5	11.5	2800.0
2010-12-07 06:30:00	AAPL	Stock	11.5343	11.5357	11.5171	11.5179	16800.0
2010-12-07 07:00:00	AAPL	Stock	11.5179	11.5571	11.5179	11.5293	654388.0
2010-12-07 07:30:00	AAPL	Stock	11.5354	11.5429	11.5257	11.5368	422100.0
2010-12-07 08:00:00	AAPL	Stock	11.5407	11.5532	11.5179	11.5482	3171504.0
2010-12-07 08:30:00	AAPL	Stock	11.5496	11.5589	11.5436	11.5568	1944348.0
2010-12-07 09:00:00	AAPL	Stock	11.5564	11.5689	11.5364	11.5643	2663668.0
2010-12-07 09:30:00	AAPL	Stock	11.5636	11.5711	11.505	11.5168	71870316.0
2010-12-07 10:00:00	AAPL	Stock	11.5164	11.5193	11.4682	11.4745	39979352.0
2010-12-07 10:30:00	AAPL	Stock	11.4751	11.5	11.4489	11.4914	26163480.0
2010-12-07 11:00:00	AAPL	Stock	11.4925	11.505	11.4757	11.4921	17363360.0
2010-12-07 11:30:00	AAPL	Stock	11.4929	11.5032	11.4746	11.4796	14365288.0
2010-12-07 12:00:00	AAPL	Stock	11.4796	11.4904	11.4518	11.4671	15366764.0
2010-12-07 12:30:00	AAPL	Stock	11.4657	11.4794	11.4586	11.4698	10640728.0
2010-12-07 13:00:00	AAPL	Stock	11.4694	11.4854	11.4682	11.4721	8830304.0
2010-12-07 13:30:00	AAPL	Stock	11.4732	11.4814	11.4571	11.4782	13370756.0
2010-12-07 14:00:00	AAPL	Stock	11.4771	11.5	11.4736	11.4998	12085668.0
2010-12-07 14:30:00	AAPL	Stock	11.4993	11.5114	11.4518	11.4579	27065024.0
2010-12-07 15:00:00	AAPL	Stock	11.4571	11.4704	11.3857	11.4207	51038288.0
2010-12-07 15:30:00	AAPL	Stock	11.4214	11.4371	11.3614	11.3643	55997284.0
2010-12-07 16:00:00	AAPL	Stock	11.365	11.5764	11.3646	11.3711	12390532.0
2010-12-07 16:30:00	AAPL	Stock	11.3807	11.4225	11.3718	11.3839	346500.0
2010-12-07 17:00:00	AAPL	Stock	11.4346	11.4346	11.3625	11.3711	697200.0
2010-12-07 17:30:00	AAPL	Stock	11.3696	11.3714	11.3675	11.3696	500528.0
2010-12-07 18:00:00	AAPL	Stock	11.365	11.3711	11.3589	11.3654	193340.0
2010-12-07 18:30:00	AAPL	Stock	11.3664	11.3693	11.3643	11.3664	60312.0
2010-12-07 19:00:00	AAPL	Stock	11.3679	11.3729	11.3679	11.3725	147868.0
2010-12-07 19:30:00	AAPL	Stock	11.3729	11.3964	11.3714	11.3929	795592.0
2010-12-07 05:30:00	MSFT	Stock	27.12	27.12	27.12	27.12	200.0
2010-12-07 06:30:00	MSFT	Stock	27.05	27.05	27.05	27.05	1000.0
2010-12-07 07:00:00	MSFT	Stock	27.04	27.05	27.04	27.05	2000.0
2010-12-07 07:30:00	MSFT	Stock	27.04	27.1	27.04	27.05	2600.0
2010-12-07 08:00:00	MSFT	Stock	27.02	27.05	26.98	27.02	37551.0
2010-12-07 08:30:00	MSFT	Stock	27.02	27.05	27.01	27.05	18725.0
2010-12-07 09:00:00	MSFT	Stock	27.07	27.11	27.03	27.07	143244.0
2010-12-07 09:30:00	MSFT	Stock	27.07	27.09	26.88	27.03	7368893.0
2010-12-07 10:00:00	MSFT	Stock	27.03	27.06	26.9	26.905	7159303.0
2010-12-07 10:30:00	MSFT	Stock	26.905	26.99	26.89	26.975	4031497.0
2010-12-07 11:00:00	MSFT	Stock	26.975	26.99	26.94	26.962	2312793.0
2010-12-07 11:30:00	MSFT	Stock	26.97	26.99	26.92	26.945	3312216.0
2010-12-07 12:00:00	MSFT	Stock	26.94	26.97	26.91	26.945	3463696.0
2010-12-07 12:30:00	MSFT	Stock	26.942	26.99	26.93	26.975	1973860.0
2010-12-07 13:00:00	MSFT	Stock	26.98	26.99	26.93	26.935	1986167.0
2010-12-07 13:30:00	MSFT	Stock	26.935	26.99	26.92	26.97	2392184.0
2010-12-07 14:00:00	MSFT	Stock	26.97	27.05	26.94	27.04	4826418.0
2010-12-07 14:30:00	MSFT	Stock	27.035	27.13	26.942	26.97	4578809.0
2010-12-07 15:00:00	MSFT	Stock	26.97	27.0	26.89	26.96	4387239.0
2010-12-07 15:30:00	MSFT	Stock	26.965	26.99	26.85	26.88	5567184.0

> showing 50 of 80,149 rows — these rows as CSV

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