PREVIEW / stock_30min / 2009-05-28

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-28.parquet
  size:    1.3 MB
  rows:    69,782
  symbols: 3,361

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-28 04:00:00	AAPL	Stock	4.7157	4.7157	4.7157	4.7157	2800.0
2009-05-28 05:30:00	AAPL	Stock	4.7218	4.7321	4.7218	4.7321	5600.0
2009-05-28 07:00:00	AAPL	Stock	4.7589	4.7671	4.7589	4.7671	11200.0
2009-05-28 07:30:00	AAPL	Stock	4.7582	4.7582	4.7304	4.7304	31080.0
2009-05-28 08:00:00	AAPL	Stock	4.7464	4.7582	4.7446	4.7536	307188.0
2009-05-28 08:30:00	AAPL	Stock	4.7582	4.7857	4.7571	4.7786	1431024.0
2009-05-28 09:00:00	AAPL	Stock	4.7768	4.7839	4.7643	4.7661	549640.0
2009-05-28 09:30:00	AAPL	Stock	4.7661	4.8121	4.7611	4.7804	63733124.0
2009-05-28 10:00:00	AAPL	Stock	4.7811	4.7814	4.7154	4.7571	63556836.0
2009-05-28 10:30:00	AAPL	Stock	4.7557	4.7589	4.7321	4.7578	32628316.0
2009-05-28 11:00:00	AAPL	Stock	4.7579	4.7789	4.7521	4.7674	31347512.0
2009-05-28 11:30:00	AAPL	Stock	4.7675	4.7746	4.7579	4.7704	19550300.0
2009-05-28 12:00:00	AAPL	Stock	4.7707	4.7721	4.7364	4.7446	19269124.0
2009-05-28 12:30:00	AAPL	Stock	4.7446	4.7535	4.7389	4.7486	11937240.0
2009-05-28 13:00:00	AAPL	Stock	4.7489	4.8011	4.7446	4.7857	39371892.0
2009-05-28 13:30:00	AAPL	Stock	4.7857	4.8021	4.7818	4.7996	28512680.0
2009-05-28 14:00:00	AAPL	Stock	4.7996	4.8264	4.7968	4.8225	46857328.0
2009-05-28 14:30:00	AAPL	Stock	4.8225	4.8325	4.8139	4.8264	35658112.0
2009-05-28 15:00:00	AAPL	Stock	4.8264	4.8339	4.7946	4.8218	30593556.0
2009-05-28 15:30:00	AAPL	Stock	4.8225	4.8354	4.8143	4.8221	49987924.0
2009-05-28 16:00:00	AAPL	Stock	4.823	4.8296	4.7659	4.8239	7368200.0
2009-05-28 16:30:00	AAPL	Stock	4.8264	4.8318	4.7849	4.83	105980.0
2009-05-28 17:00:00	AAPL	Stock	4.8268	4.8321	4.8268	4.8307	92904.0
2009-05-28 17:30:00	AAPL	Stock	4.8286	4.8304	4.8268	4.8286	86688.0
2009-05-28 18:00:00	AAPL	Stock	4.8279	4.8318	4.8239	4.83	916720.0
2009-05-28 18:30:00	AAPL	Stock	4.8296	4.8296	4.8186	4.8268	239120.0
2009-05-28 19:00:00	AAPL	Stock	4.8268	4.8282	4.8236	4.8236	79352.0
2009-05-28 19:30:00	AAPL	Stock	4.8232	4.8296	4.8232	4.8296	103040.0
2009-05-28 08:30:00	MSFT	Stock	20.25	20.3	20.25	20.3	12390.0
2009-05-28 09:00:00	MSFT	Stock	20.3	20.34	20.22	20.34	19178.0
2009-05-28 09:30:00	MSFT	Stock	20.32	20.505	20.27	20.45	3857201.0
2009-05-28 10:00:00	MSFT	Stock	20.45	20.45	20.05	20.15	4479465.0
2009-05-28 10:30:00	MSFT	Stock	20.15	20.25	20.12	20.168	2595915.0
2009-05-28 11:00:00	MSFT	Stock	20.17	20.35	20.15	20.34	2816903.0
2009-05-28 11:30:00	MSFT	Stock	20.34	20.43	20.28	20.38	2958442.0
2009-05-28 12:00:00	MSFT	Stock	20.39	20.41	20.2	20.23	2230270.0
2009-05-28 12:30:00	MSFT	Stock	20.235	20.35	20.22	20.28	1260460.0
2009-05-28 13:00:00	MSFT	Stock	20.28	20.59	20.26	20.51	4638565.0
2009-05-28 13:30:00	MSFT	Stock	20.518	20.58	20.42	20.48	2258847.0
2009-05-28 14:00:00	MSFT	Stock	20.48	20.62	20.46	20.57	2452689.0
2009-05-28 14:30:00	MSFT	Stock	20.58	20.63	20.48	20.56	2817732.0
2009-05-28 15:00:00	MSFT	Stock	20.57	20.6	20.42	20.46	3177802.0
2009-05-28 15:30:00	MSFT	Stock	20.47	20.56	20.42	20.45	7603366.0
2009-05-28 16:00:00	MSFT	Stock	20.45	20.49	20.388	20.46	1525346.0
2009-05-28 16:30:00	MSFT	Stock	20.46	20.46	20.395	20.45	31719.0
2009-05-28 17:00:00	MSFT	Stock	20.45	20.45	20.44	20.44	598.0
2009-05-28 17:30:00	MSFT	Stock	20.44	20.45	20.44	20.45	1400.0
2009-05-28 18:00:00	MSFT	Stock	20.45	20.45	20.44	20.44	4790.0
2009-05-28 18:30:00	MSFT	Stock	20.45	20.45	20.45	20.45	740.0
2009-05-28 19:00:00	MSFT	Stock	20.45	20.45	20.42	20.42	790.0

> showing 50 of 69,782 rows — these rows as CSV

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