PREVIEW / stock_30min / 2016-08-29

all stock 30-min files

  file:    by_date/stock_30min/2016/2016-08-29.parquet
  size:    1.6 MB
  rows:    81,412
  symbols: 3,259

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
2016-08-29 04:00:00	AAPL	Stock	26.675	26.675	26.64	26.64	800.0
2016-08-29 04:30:00	AAPL	Stock	26.675	26.675	26.675	26.675	400.0
2016-08-29 06:00:00	AAPL	Stock	26.6675	26.6675	26.6675	26.6675	480.0
2016-08-29 06:30:00	AAPL	Stock	26.7	26.7025	26.7	26.7025	4252.0
2016-08-29 07:00:00	AAPL	Stock	26.7	26.7	26.7	26.7	2800.0
2016-08-29 07:30:00	AAPL	Stock	26.7275	26.7275	26.71	26.725	52156.0
2016-08-29 08:00:00	AAPL	Stock	26.7325	26.7325	26.6775	26.695	31100.0
2016-08-29 08:30:00	AAPL	Stock	26.7125	26.775	26.7075	26.74	93224.0
2016-08-29 09:00:00	AAPL	Stock	26.735	26.735	26.655	26.6625	107012.0
2016-08-29 09:30:00	AAPL	Stock	26.6575	26.7675	26.5725	26.705	13103628.0
2016-08-29 10:00:00	AAPL	Stock	26.7025	26.75	26.685	26.705	5962060.0
2016-08-29 10:30:00	AAPL	Stock	26.705	26.7125	26.64	26.64	6010676.0
2016-08-29 11:00:00	AAPL	Stock	26.6425	26.67	26.625	26.6675	4635904.0
2016-08-29 11:30:00	AAPL	Stock	26.6682	26.7075	26.635	26.6925	5469216.0
2016-08-29 12:00:00	AAPL	Stock	26.6925	26.8075	26.6855	26.75	8009720.0
2016-08-29 12:30:00	AAPL	Stock	26.75	26.8575	26.7338	26.8425	5064172.0
2016-08-29 13:00:00	AAPL	Stock	26.845	26.86	26.7675	26.8	7043332.0
2016-08-29 13:30:00	AAPL	Stock	26.8012	26.8275	26.7675	26.7925	5346976.0
2016-08-29 14:00:00	AAPL	Stock	26.7925	26.8025	26.7525	26.755	3048556.0
2016-08-29 14:30:00	AAPL	Stock	26.7575	26.76	26.6825	26.716	5366192.0
2016-08-29 15:00:00	AAPL	Stock	26.7175	26.7225	26.675	26.695	4577284.0
2016-08-29 15:30:00	AAPL	Stock	26.695	26.7225	26.6875	26.705	7579408.0
2016-08-29 16:00:00	AAPL	Stock	26.705	26.72	26.695	26.695	11499680.0
2016-08-29 16:30:00	AAPL	Stock	26.7	26.705	26.6975	26.6975	25080.0
2016-08-29 17:00:00	AAPL	Stock	26.7	26.705	26.695	26.6975	467768.0
2016-08-29 17:30:00	AAPL	Stock	26.6975	26.705	26.6525	26.6525	74840.0
2016-08-29 18:00:00	AAPL	Stock	26.6525	26.6725	26.63	26.63	27432.0
2016-08-29 18:30:00	AAPL	Stock	26.6725	26.6725	26.645	26.6525	6900.0
2016-08-29 19:00:00	AAPL	Stock	26.6625	26.6625	26.65	26.65	6076.0
2016-08-29 19:30:00	AAPL	Stock	26.6525	26.66	26.6525	26.655	10600.0
2016-08-29 05:30:00	MSFT	Stock	57.99	58.07	57.99	58.07	2036.0
2016-08-29 06:30:00	MSFT	Stock	58.08	58.08	58.08	58.08	100.0
2016-08-29 08:00:00	MSFT	Stock	58.08	58.08	58.05	58.05	10400.0
2016-08-29 08:30:00	MSFT	Stock	58.08	58.08	58.08	58.08	500.0
2016-08-29 09:00:00	MSFT	Stock	58.1	58.18	58.1	58.18	2400.0
2016-08-29 09:30:00	MSFT	Stock	58.18	58.6	58.13	58.48	2424690.0
2016-08-29 10:00:00	MSFT	Stock	58.485	58.5	58.31	58.35	1052650.0
2016-08-29 10:30:00	MSFT	Stock	58.35	58.39	58.29	58.306	795689.0
2016-08-29 11:00:00	MSFT	Stock	58.31	58.36	58.24	58.31	945731.0
2016-08-29 11:30:00	MSFT	Stock	58.31	58.467	58.255	58.463	790774.0
2016-08-29 12:00:00	MSFT	Stock	58.46	58.48	58.31	58.34	573257.0
2016-08-29 12:30:00	MSFT	Stock	58.335	58.341	58.28	58.34	481507.0
2016-08-29 13:00:00	MSFT	Stock	58.34	58.35	58.26	58.319	520793.0
2016-08-29 13:30:00	MSFT	Stock	58.32	58.35	58.29	58.305	471196.0
2016-08-29 14:00:00	MSFT	Stock	58.305	58.34	58.26	58.27	477032.0
2016-08-29 14:30:00	MSFT	Stock	58.275	58.3	58.24	58.27	569630.0
2016-08-29 15:00:00	MSFT	Stock	58.27	58.27	58.17	58.18	559652.0
2016-08-29 15:30:00	MSFT	Stock	58.18	58.2	58.1	58.1	1924670.0
2016-08-29 16:00:00	MSFT	Stock	58.1	58.22	58.05	58.14	3676299.0
2016-08-29 16:30:00	MSFT	Stock	58.1	58.13	58.1	58.13	2009.0

> showing 50 of 81,412 rows — these rows as CSV

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