PREVIEW / stock_30min / 2009-05-18

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-18.parquet
  size:    1.3 MB
  rows:    70,543
  symbols: 3,330

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-05-18 08:00:00	AAPL	Stock	4.3929	4.4232	4.39	4.4207	670572.0
2009-05-18 08:30:00	AAPL	Stock	4.4121	4.4214	4.4107	4.4189	224840.0
2009-05-18 09:00:00	AAPL	Stock	4.4186	4.4282	4.4186	4.4264	542332.0
2009-05-18 09:30:00	AAPL	Stock	4.4196	4.4286	4.3418	4.3714	64317316.0
2009-05-18 10:00:00	AAPL	Stock	4.3714	4.3925	4.3543	4.3807	32323256.0
2009-05-18 10:30:00	AAPL	Stock	4.38	4.4246	4.375	4.4218	30687440.0
2009-05-18 11:00:00	AAPL	Stock	4.4229	4.4264	4.4068	4.4143	17604972.0
2009-05-18 11:30:00	AAPL	Stock	4.4146	4.4271	4.4104	4.4157	13302716.0
2009-05-18 12:00:00	AAPL	Stock	4.4157	4.4857	4.4129	4.48	56997136.0
2009-05-18 12:30:00	AAPL	Stock	4.4804	4.4921	4.4671	4.4757	38314276.0
2009-05-18 13:00:00	AAPL	Stock	4.4757	4.4839	4.4646	4.4811	21378028.0
2009-05-18 13:30:00	AAPL	Stock	4.4807	4.4936	4.4671	4.48	22765680.0
2009-05-18 14:00:00	AAPL	Stock	4.4813	4.5096	4.4793	4.4946	33294632.0
2009-05-18 14:30:00	AAPL	Stock	4.4946	4.525	4.4946	4.5193	30230032.0
2009-05-18 15:00:00	AAPL	Stock	4.5193	4.5207	4.4986	4.5036	24515484.0
2009-05-18 15:30:00	AAPL	Stock	4.5036	4.525	4.4954	4.5236	52998484.0
2009-05-18 16:00:00	AAPL	Stock	4.525	4.5254	4.4207	4.5161	14730772.0
2009-05-18 16:30:00	AAPL	Stock	4.5146	4.5239	4.5146	4.5182	232176.0
2009-05-18 17:00:00	AAPL	Stock	4.5239	4.5239	4.5154	4.5154	1591156.0
2009-05-18 17:30:00	AAPL	Stock	4.4224	4.5186	4.4224	4.5179	107492.0
2009-05-18 18:00:00	AAPL	Stock	4.5239	4.5239	4.5157	4.5193	1386168.0
2009-05-18 18:30:00	AAPL	Stock	4.5164	4.5196	4.5164	4.5193	97608.0
2009-05-18 19:00:00	AAPL	Stock	4.5196	4.5196	4.5171	4.5171	42448.0
2009-05-18 19:30:00	AAPL	Stock	4.5196	4.5232	4.5164	4.5179	74620.0
2009-05-18 07:30:00	MSFT	Stock	20.3	20.3	20.3	20.3	1300.0
2009-05-18 08:00:00	MSFT	Stock	20.29	20.35	19.48	20.35	22610.0
2009-05-18 08:30:00	MSFT	Stock	20.29	20.37	20.25	20.37	9331.0
2009-05-18 09:00:00	MSFT	Stock	20.38	20.48	20.34	20.34	47805.0
2009-05-18 09:30:00	MSFT	Stock	20.37	20.48	20.3	20.38	5184701.0
2009-05-18 10:00:00	MSFT	Stock	20.38	20.41	20.24	20.318	4760441.0
2009-05-18 10:30:00	MSFT	Stock	20.34	20.41	20.25	20.38	3206718.0
2009-05-18 11:00:00	MSFT	Stock	20.39	20.4	20.32	20.391	2486533.0
2009-05-18 11:30:00	MSFT	Stock	20.4	20.5	20.39	20.43	2303405.0
2009-05-18 12:00:00	MSFT	Stock	20.43	20.47	20.42	20.46	1737484.0
2009-05-18 12:30:00	MSFT	Stock	20.45	20.55	20.44	20.5	2053375.0
2009-05-18 13:00:00	MSFT	Stock	20.49	20.51	20.4	20.45	2301995.0
2009-05-18 13:30:00	MSFT	Stock	20.46	20.47	20.41	20.43	1866310.0
2009-05-18 14:00:00	MSFT	Stock	20.42	20.44	20.32	20.38	2143440.0
2009-05-18 14:30:00	MSFT	Stock	20.38	20.5	20.35	20.482	2812374.0
2009-05-18 15:00:00	MSFT	Stock	20.49	20.53	20.46	20.475	3219023.0
2009-05-18 15:30:00	MSFT	Stock	20.475	20.59	20.43	20.59	6877363.0
2009-05-18 16:00:00	MSFT	Stock	20.59	20.6	20.421	20.6	3505897.0
2009-05-18 16:30:00	MSFT	Stock	20.56	20.6	20.432	20.6	74526.0
2009-05-18 17:00:00	MSFT	Stock	20.6	20.6	20.55	20.55	454621.0
2009-05-18 17:30:00	MSFT	Stock	20.55	20.55	20.55	20.55	400.0
2009-05-18 18:00:00	MSFT	Stock	20.6	20.6	20.58	20.58	69481.0
2009-05-18 18:30:00	MSFT	Stock	20.58	20.58	20.58	20.58	140.0
2009-05-18 19:00:00	MSFT	Stock	20.56	20.56	20.56	20.56	350.0
2009-05-18 19:30:00	MSFT	Stock	20.56	20.6	20.56	20.6	3446.0
2009-05-18 08:00:00	NVDA	Stock	0.2275	0.2275	0.2245	0.2245	74000.0

> showing 50 of 70,543 rows — these rows as CSV

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