PREVIEW / stock_30min / 2009-05-20

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-20.parquet
  size:    1.3 MB
  rows:    73,184
  symbols: 3,354

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-20 04:30:00	AAPL	Stock	4.5911	4.5911	4.5911	4.5911	2800.0
2009-05-20 07:00:00	AAPL	Stock	4.5632	4.5946	4.5632	4.5714	8400.0
2009-05-20 07:30:00	AAPL	Stock	4.5711	4.5911	4.5711	4.5911	26040.0
2009-05-20 08:00:00	AAPL	Stock	4.5871	4.5875	4.5646	4.5679	356580.0
2009-05-20 08:30:00	AAPL	Stock	4.5679	4.5793	4.5636	4.5711	349244.0
2009-05-20 09:00:00	AAPL	Stock	4.5714	4.5714	4.55	4.5582	862344.0
2009-05-20 09:30:00	AAPL	Stock	4.5629	4.5793	4.5182	4.5446	62533520.0
2009-05-20 10:00:00	AAPL	Stock	4.5475	4.6146	4.5446	4.5971	43017492.0
2009-05-20 10:30:00	AAPL	Stock	4.5979	4.6064	4.5839	4.5918	21911540.0
2009-05-20 11:00:00	AAPL	Stock	4.5911	4.6007	4.5686	4.5743	19654320.0
2009-05-20 11:30:00	AAPL	Stock	4.5746	4.5929	4.55	4.5541	20519464.0
2009-05-20 12:00:00	AAPL	Stock	4.5539	4.5668	4.5425	4.5594	15941156.0
2009-05-20 12:30:00	AAPL	Stock	4.5596	4.5596	4.5039	4.51	22257340.0
2009-05-20 13:00:00	AAPL	Stock	4.51	4.5279	4.4907	4.5261	26622344.0
2009-05-20 13:30:00	AAPL	Stock	4.5262	4.5454	4.5214	4.5425	17800020.0
2009-05-20 14:00:00	AAPL	Stock	4.5433	4.5618	4.5214	4.5496	25168500.0
2009-05-20 14:30:00	AAPL	Stock	4.5486	4.5607	4.5329	4.5464	24271940.0
2009-05-20 15:00:00	AAPL	Stock	4.5461	4.5462	4.5029	4.5171	31738168.0
2009-05-20 15:30:00	AAPL	Stock	4.5179	4.5179	4.475	4.4961	46399780.0
2009-05-20 16:00:00	AAPL	Stock	4.495	4.5499	4.4851	4.4936	5436396.0
2009-05-20 16:30:00	AAPL	Stock	4.4936	4.5445	4.4893	4.495	326844.0
2009-05-20 17:00:00	AAPL	Stock	4.4954	4.5443	4.4857	4.4864	276080.0
2009-05-20 17:30:00	AAPL	Stock	4.4893	4.4893	4.4861	4.4879	46200.0
2009-05-20 18:00:00	AAPL	Stock	4.4954	4.4954	4.4911	4.4929	689668.0
2009-05-20 18:30:00	AAPL	Stock	4.4929	4.4964	4.4929	4.4964	109760.0
2009-05-20 19:00:00	AAPL	Stock	4.4957	4.4957	4.4957	4.4957	4564.0
2009-05-20 19:30:00	AAPL	Stock	4.4932	4.4932	4.4929	4.4929	19292.0
2009-05-20 05:30:00	MSFT	Stock	20.48	20.48	20.48	20.48	1800.0
2009-05-20 07:00:00	MSFT	Stock	20.48	20.48	20.48	20.48	1000.0
2009-05-20 08:00:00	MSFT	Stock	20.36	20.42	20.36	20.41	2262.0
2009-05-20 08:30:00	MSFT	Stock	20.41	20.41	20.41	20.41	100.0
2009-05-20 09:00:00	MSFT	Stock	20.42	20.47	20.36	20.43	26800.0
2009-05-20 09:30:00	MSFT	Stock	20.41	20.47	20.22	20.424	5463632.0
2009-05-20 10:00:00	MSFT	Stock	20.42	20.63	20.42	20.52	5231082.0
2009-05-20 10:30:00	MSFT	Stock	20.52	20.6	20.52	20.58	2161479.0
2009-05-20 11:00:00	MSFT	Stock	20.58	20.69	20.56	20.64	4090399.0
2009-05-20 11:30:00	MSFT	Stock	20.64	20.66	20.47	20.48	4849044.0
2009-05-20 12:00:00	MSFT	Stock	20.47	20.54	20.46	20.528	1583223.0
2009-05-20 12:30:00	MSFT	Stock	20.53	20.69	20.43	20.44	2115736.0
2009-05-20 13:00:00	MSFT	Stock	20.44	20.59	20.4	20.58	2457186.0
2009-05-20 13:30:00	MSFT	Stock	20.59	20.67	20.57	20.62	2106151.0
2009-05-20 14:00:00	MSFT	Stock	20.62	20.67	20.53	20.62	2960777.0
2009-05-20 14:30:00	MSFT	Stock	20.61	20.65	20.55	20.606	1978834.0
2009-05-20 15:00:00	MSFT	Stock	20.608	20.62	20.45	20.51	3936264.0
2009-05-20 15:30:00	MSFT	Stock	20.51	20.52	20.34	20.39	6012847.0
2009-05-20 16:00:00	MSFT	Stock	20.39	20.767	20.34	20.509	1626038.0
2009-05-20 16:30:00	MSFT	Stock	20.4	20.529	20.38	20.4	78149.0
2009-05-20 17:00:00	MSFT	Stock	20.42	20.42	20.4	20.4	849.0
2009-05-20 17:30:00	MSFT	Stock	20.42	20.44	20.42	20.42	697.0
2009-05-20 18:00:00	MSFT	Stock	20.39	20.5	20.39	20.42	11770.0

> showing 50 of 73,184 rows — these rows as CSV

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