PREVIEW / stock_30min / 2007-09-27

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-09-27.parquet
  size:    1.2 MB
  rows:    67,069
  symbols: 3,105

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
2007-09-27 05:00:00	AAPL	Stock	5.4561	5.4561	5.4561	5.4561	14000.0
2007-09-27 06:00:00	AAPL	Stock	5.4725	5.4725	5.4725	5.4725	2800.0
2007-09-27 07:00:00	AAPL	Stock	5.4789	5.4832	5.4675	5.4714	198436.0
2007-09-27 07:30:00	AAPL	Stock	5.4721	5.4893	5.4721	5.4889	111272.0
2007-09-27 08:00:00	AAPL	Stock	5.4868	5.4882	5.4696	5.4786	3236380.0
2007-09-27 08:30:00	AAPL	Stock	5.4807	5.4954	5.4754	5.4946	2202032.0
2007-09-27 09:00:00	AAPL	Stock	5.4936	5.4993	5.4868	5.4954	3539788.0
2007-09-27 09:30:00	AAPL	Stock	5.4936	5.4982	5.44	5.4643	111803832.0
2007-09-27 10:00:00	AAPL	Stock	5.4639	5.4889	5.4429	5.4682	73626756.0
2007-09-27 10:30:00	AAPL	Stock	5.4679	5.5171	5.4654	5.5114	75601316.0
2007-09-27 11:00:00	AAPL	Stock	5.5121	5.5175	5.4843	5.4893	70992096.0
2007-09-27 11:30:00	AAPL	Stock	5.4882	5.5079	5.4861	5.4979	37684136.0
2007-09-27 12:00:00	AAPL	Stock	5.4979	5.5061	5.4868	5.5007	26298440.0
2007-09-27 12:30:00	AAPL	Stock	5.5007	5.5079	5.4929	5.4943	17453576.0
2007-09-27 13:00:00	AAPL	Stock	5.4943	5.4975	5.485	5.4868	27524840.0
2007-09-27 13:30:00	AAPL	Stock	5.4868	5.4914	5.4714	5.4864	35260960.0
2007-09-27 14:00:00	AAPL	Stock	5.4861	5.5	5.4861	5.4986	27823348.0
2007-09-27 14:30:00	AAPL	Stock	5.4993	5.5046	5.4854	5.4886	28177856.0
2007-09-27 15:00:00	AAPL	Stock	5.4882	5.5029	5.4796	5.4996	45771124.0
2007-09-27 15:30:00	AAPL	Stock	5.5	5.5186	5.4914	5.5161	57522220.0
2007-09-27 16:00:00	AAPL	Stock	5.5175	5.5268	5.4561	5.5179	10329844.0
2007-09-27 16:30:00	AAPL	Stock	5.5136	5.5179	5.5068	5.5071	699608.0
2007-09-27 17:00:00	AAPL	Stock	5.5096	5.5121	5.5029	5.5043	306320.0
2007-09-27 17:30:00	AAPL	Stock	5.5054	5.5114	5.5054	5.5075	81732.0
2007-09-27 18:00:00	AAPL	Stock	5.5075	5.5179	5.5057	5.5075	333256.0
2007-09-27 18:30:00	AAPL	Stock	5.5071	5.5161	5.4893	5.4893	808920.0
2007-09-27 19:00:00	AAPL	Stock	5.4925	5.4954	5.4764	5.4804	823060.0
2007-09-27 19:30:00	AAPL	Stock	5.4764	5.4946	5.4764	5.4925	256116.0
2007-09-27 07:00:00	MSFT	Stock	29.51	29.51	29.5	29.5	800.0
2007-09-27 07:30:00	MSFT	Stock	29.55	29.55	29.55	29.55	2800.0
2007-09-27 08:00:00	MSFT	Stock	29.58	29.68	29.56	29.67	19300.0
2007-09-27 08:30:00	MSFT	Stock	29.65	29.67	29.6	29.67	37282.0
2007-09-27 09:00:00	MSFT	Stock	29.66	29.7	29.62	29.69	68837.0
2007-09-27 09:30:00	MSFT	Stock	29.7	29.7	29.51	29.52	4344534.0
2007-09-27 10:00:00	MSFT	Stock	29.53	29.59	29.49	29.565	3485478.0
2007-09-27 10:30:00	MSFT	Stock	29.57	29.72	29.55	29.68	4102539.0
2007-09-27 11:00:00	MSFT	Stock	29.69	29.72	29.6	29.63	2337561.0
2007-09-27 11:30:00	MSFT	Stock	29.64	29.64	29.55	29.56	2352990.0
2007-09-27 12:00:00	MSFT	Stock	29.56	29.6	29.54	29.58	2368851.0
2007-09-27 12:30:00	MSFT	Stock	29.59	29.61	29.54	29.55	1699285.0
2007-09-27 13:00:00	MSFT	Stock	29.55	29.59	29.5	29.55	2251540.0
2007-09-27 13:30:00	MSFT	Stock	29.55	29.56	29.5	29.51	2278408.0
2007-09-27 14:00:00	MSFT	Stock	29.52	29.57	29.5	29.54	1943000.0
2007-09-27 14:30:00	MSFT	Stock	29.55	29.58	29.46	29.46	2869358.0
2007-09-27 15:00:00	MSFT	Stock	29.47	29.53	29.44	29.53	3808582.0
2007-09-27 15:30:00	MSFT	Stock	29.53	29.56	29.48	29.5	5674770.0
2007-09-27 16:00:00	MSFT	Stock	29.49	29.575	29.488	29.49	1313543.0
2007-09-27 16:30:00	MSFT	Stock	29.55	29.55	29.49	29.49	83000.0
2007-09-27 17:00:00	MSFT	Stock	29.49	29.5	29.49	29.49	5453.0
2007-09-27 17:30:00	MSFT	Stock	29.59	29.59	29.49	29.5	5237.0

> showing 50 of 67,069 rows — these rows as CSV

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