PREVIEW / stock_30min / 2009-02-09

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-02-09.parquet
  size:    1.2 MB
  rows:    67,455
  symbols: 3,328

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-02-09 06:30:00	AAPL	Stock	3.5446	3.5571	3.5446	3.5571	15120.0
2009-02-09 07:00:00	AAPL	Stock	3.5536	3.5554	3.5536	3.5554	33600.0
2009-02-09 07:30:00	AAPL	Stock	3.5571	3.5607	3.555	3.5571	50400.0
2009-02-09 08:00:00	AAPL	Stock	3.5536	3.5707	3.5536	3.5607	450520.0
2009-02-09 08:30:00	AAPL	Stock	3.5618	3.5707	3.5561	3.5704	212352.0
2009-02-09 09:00:00	AAPL	Stock	3.5679	3.5861	3.5636	3.5696	1675632.0
2009-02-09 09:30:00	AAPL	Stock	3.5679	3.6368	3.5536	3.6336	113914892.0
2009-02-09 10:00:00	AAPL	Stock	3.6339	3.6571	3.6014	3.6418	94316096.0
2009-02-09 10:30:00	AAPL	Stock	3.6421	3.6725	3.6343	3.6689	71459416.0
2009-02-09 11:00:00	AAPL	Stock	3.6696	3.67	3.6454	3.6639	46847052.0
2009-02-09 11:30:00	AAPL	Stock	3.6643	3.67	3.6496	3.6654	36174684.0
2009-02-09 12:00:00	AAPL	Stock	3.6654	3.6782	3.6518	3.6761	31160164.0
2009-02-09 12:30:00	AAPL	Stock	3.6761	3.6786	3.6632	3.6693	31755780.0
2009-02-09 13:00:00	AAPL	Stock	3.6696	3.6779	3.6618	3.6643	25458804.0
2009-02-09 13:30:00	AAPL	Stock	3.6643	3.675	3.6414	3.675	47572476.0
2009-02-09 14:00:00	AAPL	Stock	3.6746	3.675	3.6371	3.6461	46056556.0
2009-02-09 14:30:00	AAPL	Stock	3.6457	3.6571	3.6411	3.6496	32199580.0
2009-02-09 15:00:00	AAPL	Stock	3.6493	3.6736	3.6429	3.67	43095164.0
2009-02-09 15:30:00	AAPL	Stock	3.6696	3.6775	3.6607	3.6643	64660288.0
2009-02-09 16:00:00	AAPL	Stock	3.6639	3.6654	3.6347	3.6607	11311636.0
2009-02-09 16:30:00	AAPL	Stock	3.6604	3.6611	3.6564	3.6564	377664.0
2009-02-09 17:00:00	AAPL	Stock	3.6554	3.66	3.6546	3.66	74648.0
2009-02-09 17:30:00	AAPL	Stock	3.6589	3.6604	3.6554	3.6554	453908.0
2009-02-09 18:00:00	AAPL	Stock	3.6611	3.6611	3.6443	3.6446	4380796.0
2009-02-09 18:30:00	AAPL	Stock	3.6461	3.6571	3.6461	3.6482	182392.0
2009-02-09 19:00:00	AAPL	Stock	3.65	3.6518	3.6346	3.6346	258580.0
2009-02-09 19:30:00	AAPL	Stock	3.6375	3.6375	3.6179	3.625	201992.0
2009-02-09 20:00:00	AAPL	Stock	3.6611	3.6611	3.6611	3.6611	45724.0
2009-02-09 04:00:00	MSFT	Stock	19.51	19.51	19.2	19.2	500.0
2009-02-09 06:30:00	MSFT	Stock	19.33	19.33	19.33	19.33	1000.0
2009-02-09 07:30:00	MSFT	Stock	19.5	19.5	19.5	19.5	1000.0
2009-02-09 08:00:00	MSFT	Stock	19.55	19.7	19.5	19.7	14002.0
2009-02-09 08:30:00	MSFT	Stock	19.64	19.67	19.54	19.56	15628.0
2009-02-09 09:00:00	MSFT	Stock	19.56	19.72	19.38	19.69	39891.0
2009-02-09 09:30:00	MSFT	Stock	19.65	19.77	19.43	19.49	4926422.0
2009-02-09 10:00:00	MSFT	Stock	19.481	19.5	19.34	19.4	3756701.0
2009-02-09 10:30:00	MSFT	Stock	19.4	19.51	19.37	19.51	3910844.0
2009-02-09 11:00:00	MSFT	Stock	19.51	19.52	19.43	19.44	2764171.0
2009-02-09 11:30:00	MSFT	Stock	19.442	19.45	19.31	19.31	2787441.0
2009-02-09 12:00:00	MSFT	Stock	19.32	19.39	19.3	19.388	1995677.0
2009-02-09 12:30:00	MSFT	Stock	19.39	19.4	19.36	19.392	1570788.0
2009-02-09 13:00:00	MSFT	Stock	19.395	19.46	19.37	19.37	1946167.0
2009-02-09 13:30:00	MSFT	Stock	19.38	19.39	19.3	19.39	1255323.0
2009-02-09 14:00:00	MSFT	Stock	19.39	19.4	19.3	19.32	3038073.0
2009-02-09 14:30:00	MSFT	Stock	19.32	19.37	19.26	19.35	3516115.0
2009-02-09 15:00:00	MSFT	Stock	19.34	19.43	19.34	19.398	4301431.0
2009-02-09 15:30:00	MSFT	Stock	19.39	19.46	19.35	19.44	8844060.0
2009-02-09 16:00:00	MSFT	Stock	19.45	19.47	19.34	19.41	5571875.0
2009-02-09 16:30:00	MSFT	Stock	19.39	19.48	19.36	19.36	198129.0
2009-02-09 17:00:00	MSFT	Stock	19.4	19.4	19.36	19.36	817.0

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

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