PREVIEW / stock_30min / 2008-04-21

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-04-21.parquet
  size:    1.2 MB
  rows:    68,418
  symbols: 3,286

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
2008-04-21 04:00:00	AAPL	Stock	5.7693	5.7693	5.7618	5.7618	5600.0
2008-04-21 05:30:00	AAPL	Stock	5.7889	5.7921	5.7889	5.7921	11172.0
2008-04-21 06:00:00	AAPL	Stock	5.7793	5.7793	5.7779	5.7779	21000.0
2008-04-21 06:30:00	AAPL	Stock	5.7711	5.775	5.7711	5.775	33600.0
2008-04-21 07:00:00	AAPL	Stock	5.775	5.7768	5.7571	5.7768	242788.0
2008-04-21 07:30:00	AAPL	Stock	5.7721	5.8036	5.7682	5.7857	363664.0
2008-04-21 08:00:00	AAPL	Stock	5.7929	5.8214	5.7821	5.7893	5399184.0
2008-04-21 08:30:00	AAPL	Stock	5.7904	5.8071	5.7861	5.79	2806608.0
2008-04-21 09:00:00	AAPL	Stock	5.7875	5.8036	5.7821	5.7943	3426080.0
2008-04-21 09:30:00	AAPL	Stock	5.7943	5.8732	5.7771	5.8604	147320880.0
2008-04-21 10:00:00	AAPL	Stock	5.8607	5.8636	5.8307	5.8393	82154240.0
2008-04-21 10:30:00	AAPL	Stock	5.8396	5.8425	5.8071	5.8164	69313384.0
2008-04-21 11:00:00	AAPL	Stock	5.8164	5.8304	5.8143	5.8239	46962776.0
2008-04-21 11:30:00	AAPL	Stock	5.8243	5.8468	5.8221	5.8407	36182440.0
2008-04-21 12:00:00	AAPL	Stock	5.8407	5.8768	5.8361	5.8729	59597804.0
2008-04-21 12:30:00	AAPL	Stock	5.8729	5.8821	5.8579	5.8775	45241756.0
2008-04-21 13:00:00	AAPL	Stock	5.8771	5.8921	5.8757	5.8804	49870016.0
2008-04-21 13:30:00	AAPL	Stock	5.88	5.8854	5.8664	5.8782	36833832.0
2008-04-21 14:00:00	AAPL	Stock	5.8789	5.8818	5.8646	5.8811	33737620.0
2008-04-21 14:30:00	AAPL	Stock	5.8811	5.9425	5.875	5.9375	109537176.0
2008-04-21 15:00:00	AAPL	Stock	5.9371	6.0036	5.9345	5.9789	142056040.0
2008-04-21 15:30:00	AAPL	Stock	5.9793	6.0179	5.9579	6.0057	133988064.0
2008-04-21 16:00:00	AAPL	Stock	6.0037	6.0057	5.8919	5.9968	10608248.0
2008-04-21 16:30:00	AAPL	Stock	5.9968	6.0058	5.8927	5.9786	3347148.0
2008-04-21 17:00:00	AAPL	Stock	5.9821	5.9943	5.9768	5.9921	699776.0
2008-04-21 17:30:00	AAPL	Stock	5.8734	5.9911	5.8734	5.9882	651700.0
2008-04-21 18:00:00	AAPL	Stock	5.9857	5.9875	5.9786	5.9821	313180.0
2008-04-21 18:30:00	AAPL	Stock	5.9821	5.985	5.9786	5.9789	80220.0
2008-04-21 19:00:00	AAPL	Stock	5.9846	5.985	5.9786	5.9821	165312.0
2008-04-21 19:30:00	AAPL	Stock	5.9804	5.9821	5.9764	5.9768	149268.0
2008-04-21 07:00:00	MSFT	Stock	30.03	30.03	30.0	30.03	3100.0
2008-04-21 07:30:00	MSFT	Stock	30.03	30.1	30.0	30.1	1610.0
2008-04-21 08:00:00	MSFT	Stock	30.15	30.5	30.0	30.4	186599.0
2008-04-21 08:30:00	MSFT	Stock	30.4	30.4	30.24	30.31	109193.0
2008-04-21 09:00:00	MSFT	Stock	30.32	30.33	30.2	30.2	69527.0
2008-04-21 09:30:00	MSFT	Stock	30.22	30.43	30.12	30.4	7560506.0
2008-04-21 10:00:00	MSFT	Stock	30.4	30.4	30.22	30.31	5316116.0
2008-04-21 10:30:00	MSFT	Stock	30.31	30.47	30.28	30.42	5066478.0
2008-04-21 11:00:00	MSFT	Stock	30.42	30.53	30.4	30.51	3745520.0
2008-04-21 11:30:00	MSFT	Stock	30.505	30.6	30.43	30.43	4875608.0
2008-04-21 12:00:00	MSFT	Stock	30.43	30.47	30.4	30.4	1747338.0
2008-04-21 12:30:00	MSFT	Stock	30.408	30.48	30.35	30.44	2795928.0
2008-04-21 13:00:00	MSFT	Stock	30.441	30.49	30.41	30.41	2693291.0
2008-04-21 13:30:00	MSFT	Stock	30.41	30.44	30.3	30.32	3006420.0
2008-04-21 14:00:00	MSFT	Stock	30.31	30.37	30.28	30.37	2056461.0
2008-04-21 14:30:00	MSFT	Stock	30.37	30.465	30.34	30.34	2647477.0
2008-04-21 15:00:00	MSFT	Stock	30.34	30.51	30.3	30.46	4001469.0
2008-04-21 15:30:00	MSFT	Stock	30.46	30.52	30.38	30.41	5747351.0
2008-04-21 16:00:00	MSFT	Stock	30.42	30.421	30.35	30.417	1352855.0
2008-04-21 16:30:00	MSFT	Stock	30.46	30.46	30.38	30.43	267957.0

> showing 50 of 68,418 rows — these rows as CSV

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