PREVIEW / stock_30min / 2010-04-07

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-04-07.parquet
  size:    1.4 MB
  rows:    74,344
  symbols: 3,485

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-04-07 04:00:00	AAPL	Stock	8.5582	8.5582	8.5582	8.5582	50400.0
2010-04-07 06:00:00	AAPL	Stock	8.5589	8.5589	8.5589	8.5589	2800.0
2010-04-07 07:00:00	AAPL	Stock	8.5446	8.5446	8.5339	8.5339	8400.0
2010-04-07 07:30:00	AAPL	Stock	8.5311	8.5436	8.5271	8.5361	90412.0
2010-04-07 08:00:00	AAPL	Stock	8.5361	8.5468	8.5357	8.5371	959168.0
2010-04-07 08:30:00	AAPL	Stock	8.5386	8.555	8.5361	8.5436	784644.0
2010-04-07 09:00:00	AAPL	Stock	8.5436	8.5614	8.5404	8.5557	989716.0
2010-04-07 09:30:00	AAPL	Stock	8.5557	8.6071	8.5443	8.579	71464568.0
2010-04-07 10:00:00	AAPL	Stock	8.5796	8.6196	8.5761	8.6082	50479128.0
2010-04-07 10:30:00	AAPL	Stock	8.6082	8.6225	8.5796	8.5986	48784036.0
2010-04-07 11:00:00	AAPL	Stock	8.5986	8.6164	8.5861	8.6089	34754272.0
2010-04-07 11:30:00	AAPL	Stock	8.61	8.615	8.6014	8.6076	17753316.0
2010-04-07 12:00:00	AAPL	Stock	8.6071	8.6179	8.5961	8.6025	13513696.0
2010-04-07 12:30:00	AAPL	Stock	8.6043	8.6175	8.6021	8.6161	12600252.0
2010-04-07 13:00:00	AAPL	Stock	8.6164	8.64	8.6154	8.6332	34103720.0
2010-04-07 13:30:00	AAPL	Stock	8.6336	8.6375	8.6214	8.6332	21439740.0
2010-04-07 14:00:00	AAPL	Stock	8.6339	8.6375	8.5911	8.6039	40433456.0
2010-04-07 14:30:00	AAPL	Stock	8.6043	8.6068	8.5643	8.5875	66600968.0
2010-04-07 15:00:00	AAPL	Stock	8.5864	8.5878	8.5236	8.5629	85941884.0
2010-04-07 15:30:00	AAPL	Stock	8.5629	8.5929	8.5561	8.5907	54874904.0
2010-04-07 16:00:00	AAPL	Stock	8.5925	8.5964	8.5554	8.5918	8968792.0
2010-04-07 16:30:00	AAPL	Stock	8.5646	8.5962	8.5646	8.5914	423528.0
2010-04-07 17:00:00	AAPL	Stock	8.5914	8.5935	8.5879	8.5911	179872.0
2010-04-07 17:30:00	AAPL	Stock	8.5911	8.5943	8.5896	8.5943	117852.0
2010-04-07 18:00:00	AAPL	Stock	8.5921	8.5957	8.5896	8.5911	197988.0
2010-04-07 18:30:00	AAPL	Stock	8.5929	8.5971	8.5921	8.5971	252056.0
2010-04-07 19:00:00	AAPL	Stock	8.5954	8.5982	8.5929	8.5929	145936.0
2010-04-07 19:30:00	AAPL	Stock	8.5929	8.5929	8.5864	8.5864	149828.0
2010-04-07 05:00:00	MSFT	Stock	29.29	29.29	29.29	29.29	100.0
2010-04-07 07:30:00	MSFT	Stock	29.25	29.25	29.25	29.25	100.0
2010-04-07 08:00:00	MSFT	Stock	29.31	29.31	29.25	29.27	5325.0
2010-04-07 08:30:00	MSFT	Stock	29.27	29.27	29.22	29.27	10133.0
2010-04-07 09:00:00	MSFT	Stock	29.27	29.29	29.16	29.16	70779.0
2010-04-07 09:30:00	MSFT	Stock	29.19	29.3	29.14	29.23	7577632.0
2010-04-07 10:00:00	MSFT	Stock	29.23	29.56	29.23	29.43	6732734.0
2010-04-07 10:30:00	MSFT	Stock	29.43	29.46	29.35	29.46	5245966.0
2010-04-07 11:00:00	MSFT	Stock	29.47	29.485	29.37	29.45	2659980.0
2010-04-07 11:30:00	MSFT	Stock	29.46	29.48	29.39	29.45	2470338.0
2010-04-07 12:00:00	MSFT	Stock	29.455	29.47	29.24	29.404	3785769.0
2010-04-07 12:30:00	MSFT	Stock	29.4	29.41	29.34	29.41	2727839.0
2010-04-07 13:00:00	MSFT	Stock	29.41	29.47	29.37	29.416	3107126.0
2010-04-07 13:30:00	MSFT	Stock	29.41	29.43	29.32	29.37	2091341.0
2010-04-07 14:00:00	MSFT	Stock	29.37	29.39	29.24	29.31	2436926.0
2010-04-07 14:30:00	MSFT	Stock	29.3	29.38	29.27	29.34	3039787.0
2010-04-07 15:00:00	MSFT	Stock	29.34	29.345	29.19	29.252	6390217.0
2010-04-07 15:30:00	MSFT	Stock	29.252	29.36	29.23	29.36	5497140.0
2010-04-07 16:00:00	MSFT	Stock	29.36	29.41	29.3	29.35	2459199.0
2010-04-07 16:30:00	MSFT	Stock	29.31	29.31	29.265	29.31	24400.0
2010-04-07 17:00:00	MSFT	Stock	29.32	29.367	29.32	29.32	1213.0
2010-04-07 17:30:00	MSFT	Stock	29.33	29.33	29.31	29.31	505.0

> showing 50 of 74,344 rows — these rows as CSV

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