PREVIEW / stock_30min / 2009-04-23

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-23.parquet
  size:    1.2 MB
  rows:    69,060
  symbols: 3,295

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
2009-04-23 04:30:00	AAPL	Stock	4.4696	4.4696	4.4696	4.4696	2800.0
2009-04-23 05:00:00	AAPL	Stock	4.4793	4.4954	4.4793	4.4954	19600.0
2009-04-23 05:30:00	AAPL	Stock	4.4957	4.4964	4.4957	4.4964	19488.0
2009-04-23 06:00:00	AAPL	Stock	4.4993	4.5139	4.4993	4.5139	80640.0
2009-04-23 06:30:00	AAPL	Stock	4.5125	4.5296	4.505	4.505	53200.0
2009-04-23 07:00:00	AAPL	Stock	4.5043	4.5357	4.4839	4.5139	830900.0
2009-04-23 07:30:00	AAPL	Stock	4.5179	4.5282	4.4743	4.5082	2311428.0
2009-04-23 08:00:00	AAPL	Stock	4.5075	4.5286	4.4821	4.5286	7222572.0
2009-04-23 08:30:00	AAPL	Stock	4.525	4.5786	4.4971	4.5746	13783840.0
2009-04-23 09:00:00	AAPL	Stock	4.5743	4.5786	4.52	4.5204	12509700.0
2009-04-23 09:30:00	AAPL	Stock	4.5211	4.5429	4.4179	4.4411	208660844.0
2009-04-23 10:00:00	AAPL	Stock	4.4407	4.5093	4.4289	4.4941	104661172.0
2009-04-23 10:30:00	AAPL	Stock	4.4937	4.4957	4.4475	4.4562	62714120.0
2009-04-23 11:00:00	AAPL	Stock	4.4571	4.4586	4.4111	4.4532	49946512.0
2009-04-23 11:30:00	AAPL	Stock	4.4532	4.4893	4.45	4.4746	43249920.0
2009-04-23 12:00:00	AAPL	Stock	4.475	4.5046	4.4689	4.4796	66416728.0
2009-04-23 12:30:00	AAPL	Stock	4.4796	4.5	4.4754	4.4961	28348656.0
2009-04-23 13:00:00	AAPL	Stock	4.4961	4.5107	4.485	4.4861	46393060.0
2009-04-23 13:30:00	AAPL	Stock	4.4861	4.5	4.47	4.4948	44490264.0
2009-04-23 14:00:00	AAPL	Stock	4.4948	4.495	4.4504	4.4621	45268748.0
2009-04-23 14:30:00	AAPL	Stock	4.4625	4.4964	4.4607	4.48	42093044.0
2009-04-23 15:00:00	AAPL	Stock	4.4796	4.4818	4.4475	4.47	55632136.0
2009-04-23 15:30:00	AAPL	Stock	4.4704	4.495	4.4554	4.4864	79060660.0
2009-04-23 16:00:00	AAPL	Stock	4.4864	4.4868	4.4607	4.4839	14521416.0
2009-04-23 16:30:00	AAPL	Stock	4.4836	4.4875	4.4786	4.4821	809312.0
2009-04-23 17:00:00	AAPL	Stock	4.4839	4.495	4.4821	4.4857	541968.0
2009-04-23 17:30:00	AAPL	Stock	4.4821	4.4861	4.475	4.4768	203812.0
2009-04-23 18:00:00	AAPL	Stock	4.4768	4.4821	4.4725	4.4768	991732.0
2009-04-23 18:30:00	AAPL	Stock	4.4718	4.4786	4.4643	4.4686	319536.0
2009-04-23 19:00:00	AAPL	Stock	4.4686	4.4686	4.4636	4.4643	168952.0
2009-04-23 19:30:00	AAPL	Stock	4.4643	4.4686	4.4643	4.4646	111748.0
2009-04-23 20:00:00	AAPL	Stock	4.4836	4.4836	4.4836	4.4836	324800.0
2009-04-23 07:00:00	MSFT	Stock	19.14	19.14	19.14	19.14	500.0
2009-04-23 07:30:00	MSFT	Stock	19.1	19.1	18.95	18.95	4610.0
2009-04-23 08:00:00	MSFT	Stock	19.05	19.16	19.05	19.1	12775.0
2009-04-23 08:30:00	MSFT	Stock	19.12	19.12	19.0	19.05	18700.0
2009-04-23 09:00:00	MSFT	Stock	19.06	19.06	18.85	18.85	121425.0
2009-04-23 09:30:00	MSFT	Stock	18.86	18.92	18.57	18.615	7251229.0
2009-04-23 10:00:00	MSFT	Stock	18.61	18.74	18.5	18.69	5985835.0
2009-04-23 10:30:00	MSFT	Stock	18.69	18.74	18.52	18.52	4498926.0
2009-04-23 11:00:00	MSFT	Stock	18.52	18.65	18.5	18.57	3607447.0
2009-04-23 11:30:00	MSFT	Stock	18.572	18.64	18.53	18.548	2876776.0
2009-04-23 12:00:00	MSFT	Stock	18.54	18.69	18.52	18.629	3312017.0
2009-04-23 12:30:00	MSFT	Stock	18.615	18.817	18.57	18.59	3220357.0
2009-04-23 13:00:00	MSFT	Stock	18.59	18.63	18.55	18.59	5773115.0
2009-04-23 13:30:00	MSFT	Stock	18.589	18.6	18.52	18.55	4557944.0
2009-04-23 14:00:00	MSFT	Stock	18.55	18.56	18.47	18.55	5931274.0
2009-04-23 14:30:00	MSFT	Stock	18.55	18.65	18.54	18.61	7151891.0
2009-04-23 15:00:00	MSFT	Stock	18.615	18.71	18.595	18.71	6273876.0
2009-04-23 15:30:00	MSFT	Stock	18.71	18.94	18.64	18.92	10951675.0

> showing 50 of 69,060 rows — these rows as CSV

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