PREVIEW / stock_30min / 2008-02-04

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-02-04.parquet
  size:    1.2 MB
  rows:    69,614
  symbols: 3,240

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-02-04 04:00:00	AAPL	Stock	4.7857	4.7857	4.7857	4.7857	7000.0
2008-02-04 06:00:00	AAPL	Stock	4.7825	4.7825	4.7804	4.7804	16800.0
2008-02-04 06:30:00	AAPL	Stock	4.8032	4.8032	4.8032	4.8032	13636.0
2008-02-04 07:00:00	AAPL	Stock	4.7921	4.8182	4.7829	4.8089	77364.0
2008-02-04 07:30:00	AAPL	Stock	4.7957	4.8089	4.7954	4.8	103516.0
2008-02-04 08:00:00	AAPL	Stock	4.7961	4.8054	4.7768	4.7768	981344.0
2008-02-04 08:30:00	AAPL	Stock	4.7771	4.7904	4.7768	4.7893	338632.0
2008-02-04 09:00:00	AAPL	Stock	4.7857	4.7982	4.7768	4.7939	1487472.0
2008-02-04 09:30:00	AAPL	Stock	4.7939	4.8532	4.7789	4.8407	129960516.0
2008-02-04 10:00:00	AAPL	Stock	4.84	4.8536	4.8143	4.8222	79515968.0
2008-02-04 10:30:00	AAPL	Stock	4.8229	4.8393	4.8082	4.8343	60677428.0
2008-02-04 11:00:00	AAPL	Stock	4.8343	4.8482	4.805	4.8125	56102732.0
2008-02-04 11:30:00	AAPL	Stock	4.8125	4.8204	4.7643	4.7682	73431512.0
2008-02-04 12:00:00	AAPL	Stock	4.7693	4.7736	4.7286	4.7432	65874676.0
2008-02-04 12:30:00	AAPL	Stock	4.7436	4.7614	4.7366	4.7436	47638892.0
2008-02-04 13:00:00	AAPL	Stock	4.7434	4.7511	4.7036	4.71	71582812.0
2008-02-04 13:30:00	AAPL	Stock	4.71	4.75	4.7082	4.7493	45270008.0
2008-02-04 14:00:00	AAPL	Stock	4.7491	4.7491	4.7143	4.725	44760688.0
2008-02-04 14:30:00	AAPL	Stock	4.7246	4.7246	4.6936	4.7193	73208548.0
2008-02-04 15:00:00	AAPL	Stock	4.7196	4.7307	4.7093	4.7232	50695204.0
2008-02-04 15:30:00	AAPL	Stock	4.7236	4.7239	4.7014	4.7039	71296456.0
2008-02-04 16:00:00	AAPL	Stock	4.7036	4.7768	4.6964	4.6993	25709908.0
2008-02-04 16:30:00	AAPL	Stock	4.7	4.7693	4.6975	4.7014	1184736.0
2008-02-04 17:00:00	AAPL	Stock	4.7014	4.7057	4.7011	4.7054	170156.0
2008-02-04 17:30:00	AAPL	Stock	4.7036	4.7054	4.7011	4.7036	153692.0
2008-02-04 18:00:00	AAPL	Stock	4.7036	4.7143	4.6986	4.7143	285516.0
2008-02-04 18:30:00	AAPL	Stock	4.7004	4.7004	4.6982	4.7	258216.0
2008-02-04 19:00:00	AAPL	Stock	4.6982	4.6993	4.6982	4.6993	7000.0
2008-02-04 19:30:00	AAPL	Stock	4.6986	4.7036	4.6968	4.6968	213304.0
2008-02-04 06:30:00	MSFT	Stock	30.72	30.72	30.72	30.72	1000.0
2008-02-04 07:00:00	MSFT	Stock	30.72	30.72	30.56	30.56	16392.0
2008-02-04 07:30:00	MSFT	Stock	30.56	30.64	30.53	30.56	15284.0
2008-02-04 08:00:00	MSFT	Stock	30.58	30.64	30.5	30.53	106511.0
2008-02-04 08:30:00	MSFT	Stock	30.54	30.75	30.5	30.64	514880.0
2008-02-04 09:00:00	MSFT	Stock	30.64	30.65	30.32	30.48	719732.0
2008-02-04 09:30:00	MSFT	Stock	30.48	30.63	30.25	30.5	17112306.0
2008-02-04 10:00:00	MSFT	Stock	30.5	30.53	30.33	30.41	13796187.0
2008-02-04 10:30:00	MSFT	Stock	30.41	30.53	30.27	30.52	10333389.0
2008-02-04 11:00:00	MSFT	Stock	30.52	30.61	30.49	30.51	7596257.0
2008-02-04 11:30:00	MSFT	Stock	30.51	30.57	30.48	30.53	6136766.0
2008-02-04 12:00:00	MSFT	Stock	30.527	30.66	30.45	30.52	7695564.0
2008-02-04 12:30:00	MSFT	Stock	30.51	30.57	30.5	30.538	4260182.0
2008-02-04 13:00:00	MSFT	Stock	30.538	30.66	30.46	30.55	5563541.0
2008-02-04 13:30:00	MSFT	Stock	30.56	30.72	30.56	30.7	4492006.0
2008-02-04 14:00:00	MSFT	Stock	30.7	30.71	30.64	30.69	4368957.0
2008-02-04 14:30:00	MSFT	Stock	30.68	30.683	30.45	30.52	7040640.0
2008-02-04 15:00:00	MSFT	Stock	30.52	30.57	30.5	30.52	5105285.0
2008-02-04 15:30:00	MSFT	Stock	30.51	30.53	30.11	30.19	15880031.0
2008-02-04 16:00:00	MSFT	Stock	30.18	30.53	30.13	30.15	9001869.0
2008-02-04 16:30:00	MSFT	Stock	30.18	30.5	30.15	30.16	226776.0

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

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