PREVIEW / stock_30min / 2010-10-11

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-10-11.parquet
  size:    1.3 MB
  rows:    71,809
  symbols: 3,465

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-10-11 04:00:00	AAPL	Stock	10.4929	10.4929	10.4929	10.4929	2800.0
2010-10-11 06:30:00	AAPL	Stock	10.5107	10.5111	10.5107	10.5111	5600.0
2010-10-11 07:00:00	AAPL	Stock	10.5346	10.5346	10.5154	10.5325	25200.0
2010-10-11 07:30:00	AAPL	Stock	10.5307	10.5446	10.5296	10.5364	199080.0
2010-10-11 08:00:00	AAPL	Stock	10.5357	10.5439	10.5225	10.5393	1696044.0
2010-10-11 08:30:00	AAPL	Stock	10.5396	10.5396	10.5268	10.5357	1686048.0
2010-10-11 09:00:00	AAPL	Stock	10.5361	10.5375	10.5179	10.5275	1295868.0
2010-10-11 09:30:00	AAPL	Stock	10.5268	10.5961	10.5264	10.5764	86163924.0
2010-10-11 10:00:00	AAPL	Stock	10.5754	10.6114	10.5679	10.6036	60247012.0
2010-10-11 10:30:00	AAPL	Stock	10.6036	10.6071	10.5571	10.573	37106552.0
2010-10-11 11:00:00	AAPL	Stock	10.5721	10.5879	10.5661	10.58	18994416.0
2010-10-11 11:30:00	AAPL	Stock	10.5811	10.5936	10.5686	10.5739	18412912.0
2010-10-11 12:00:00	AAPL	Stock	10.575	10.5882	10.5679	10.5839	11885552.0
2010-10-11 12:30:00	AAPL	Stock	10.5837	10.6007	10.5807	10.5927	11844224.0
2010-10-11 13:00:00	AAPL	Stock	10.5929	10.5986	10.5857	10.5925	8834084.0
2010-10-11 13:30:00	AAPL	Stock	10.5936	10.6046	10.5893	10.6004	12360992.0
2010-10-11 14:00:00	AAPL	Stock	10.6018	10.6032	10.5914	10.5974	11235084.0
2010-10-11 14:30:00	AAPL	Stock	10.5974	10.6157	10.5918	10.6054	32224780.0
2010-10-11 15:00:00	AAPL	Stock	10.6052	10.61	10.5568	10.56	37042908.0
2010-10-11 15:30:00	AAPL	Stock	10.5596	10.5652	10.5214	10.5486	59835580.0
2010-10-11 16:00:00	AAPL	Stock	10.5529	10.5763	10.5486	10.5575	14058604.0
2010-10-11 16:30:00	AAPL	Stock	10.5596	10.581	10.5481	10.581	947072.0
2010-10-11 17:00:00	AAPL	Stock	10.5039	10.5564	10.5039	10.5564	66836.0
2010-10-11 17:30:00	AAPL	Stock	10.5568	10.5593	10.5546	10.5579	148092.0
2010-10-11 18:00:00	AAPL	Stock	10.5589	10.5593	10.545	10.55	464044.0
2010-10-11 18:30:00	AAPL	Stock	10.5475	10.5546	10.5432	10.5536	298536.0
2010-10-11 19:00:00	AAPL	Stock	10.5546	10.5546	10.55	10.55	41860.0
2010-10-11 19:30:00	AAPL	Stock	10.55	10.55	10.5432	10.5479	93100.0
2010-10-11 04:00:00	MSFT	Stock	24.75	24.75	24.75	24.75	990.0
2010-10-11 05:00:00	MSFT	Stock	24.72	24.75	24.72	24.75	810.0
2010-10-11 05:30:00	MSFT	Stock	24.71	24.71	24.71	24.71	600.0
2010-10-11 06:00:00	MSFT	Stock	24.71	24.72	24.71	24.72	1500.0
2010-10-11 07:00:00	MSFT	Stock	24.77	24.77	24.77	24.77	280.0
2010-10-11 07:30:00	MSFT	Stock	24.71	24.75	24.71	24.74	750.0
2010-10-11 08:00:00	MSFT	Stock	24.71	24.75	24.69	24.72	13592.0
2010-10-11 08:30:00	MSFT	Stock	24.73	24.75	24.68	24.7	19455.0
2010-10-11 09:00:00	MSFT	Stock	24.72	24.73	24.66	24.7	31205.0
2010-10-11 09:30:00	MSFT	Stock	24.74	24.74	24.53	24.59	3077783.0
2010-10-11 10:00:00	MSFT	Stock	24.585	24.64	24.56	24.62	2762713.0
2010-10-11 10:30:00	MSFT	Stock	24.625	24.64	24.56	24.57	3082509.0
2010-10-11 11:00:00	MSFT	Stock	24.57	24.6	24.55	24.58	1783212.0
2010-10-11 11:30:00	MSFT	Stock	24.585	24.64	24.58	24.635	1975337.0
2010-10-11 12:00:00	MSFT	Stock	24.63	24.68	24.62	24.68	1635800.0
2010-10-11 12:30:00	MSFT	Stock	24.67	24.71	24.65	24.68	1947593.0
2010-10-11 13:00:00	MSFT	Stock	24.675	24.68	24.64	24.64	623025.0
2010-10-11 13:30:00	MSFT	Stock	24.65	24.66	24.61	24.658	1062802.0
2010-10-11 14:00:00	MSFT	Stock	24.659	24.66	24.61	24.615	1196051.0
2010-10-11 14:30:00	MSFT	Stock	24.615	24.62	24.6	24.6	880774.0
2010-10-11 15:00:00	MSFT	Stock	24.6	24.62	24.55	24.56	1849735.0
2010-10-11 15:30:00	MSFT	Stock	24.57	24.58	24.5	24.58	3998524.0

> showing 50 of 71,809 rows — these rows as CSV

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