PREVIEW / stock_30min / 2009-06-03

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-03.parquet
  size:    1.3 MB
  rows:    73,049
  symbols: 3,347

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-06-03 04:00:00	AAPL	Stock	4.9818	4.9996	4.9818	4.9996	5600.0
2009-06-03 04:30:00	AAPL	Stock	4.9818	4.9925	4.9818	4.9925	25200.0
2009-06-03 05:00:00	AAPL	Stock	4.9818	4.9818	4.9818	4.9818	8400.0
2009-06-03 05:30:00	AAPL	Stock	4.9818	4.9818	4.9818	4.9818	16800.0
2009-06-03 07:00:00	AAPL	Stock	4.9836	4.9839	4.9743	4.9839	64680.0
2009-06-03 07:30:00	AAPL	Stock	4.9786	5.0089	4.9786	5.0036	812896.0
2009-06-03 08:00:00	AAPL	Stock	5.0036	5.0129	4.9818	5.0032	1452696.0
2009-06-03 08:30:00	AAPL	Stock	5.0032	5.0086	4.9946	4.9971	1647268.0
2009-06-03 09:00:00	AAPL	Stock	4.9971	5.0168	4.995	5.0	2668260.0
2009-06-03 09:30:00	AAPL	Stock	5.0	5.0354	4.9929	5.0171	93356480.0
2009-06-03 10:00:00	AAPL	Stock	5.0168	5.0182	4.9668	4.9907	61659808.0
2009-06-03 10:30:00	AAPL	Stock	4.9911	5.0161	4.9768	5.0154	41047216.0
2009-06-03 11:00:00	AAPL	Stock	5.0154	5.0207	4.9904	5.0168	34788628.0
2009-06-03 11:30:00	AAPL	Stock	5.0168	5.0264	5.0082	5.0228	29578584.0
2009-06-03 12:00:00	AAPL	Stock	5.0225	5.0271	5.0029	5.0071	22815688.0
2009-06-03 12:30:00	AAPL	Stock	5.0068	5.0161	4.9907	4.9946	22623440.0
2009-06-03 13:00:00	AAPL	Stock	4.9946	5.0085	4.9918	5.0036	20918408.0
2009-06-03 13:30:00	AAPL	Stock	5.0036	5.0118	4.9939	5.0089	29006488.0
2009-06-03 14:00:00	AAPL	Stock	5.0089	5.0193	5.0029	5.0167	21638316.0
2009-06-03 14:30:00	AAPL	Stock	5.0168	5.0196	4.9929	5.0075	47375692.0
2009-06-03 15:00:00	AAPL	Stock	5.0075	5.0154	4.9989	5.0043	30557184.0
2009-06-03 15:30:00	AAPL	Stock	5.0039	5.0396	4.9932	5.0368	71911952.0
2009-06-03 16:00:00	AAPL	Stock	5.0361	5.0414	5.0087	5.0393	18419548.0
2009-06-03 16:30:00	AAPL	Stock	5.0393	5.0411	5.0339	5.0396	3238144.0
2009-06-03 17:00:00	AAPL	Stock	5.0364	5.0396	5.0339	5.0343	173264.0
2009-06-03 17:30:00	AAPL	Stock	5.0339	5.0393	5.0321	5.0393	109872.0
2009-06-03 18:00:00	AAPL	Stock	5.0339	5.0414	5.0339	5.0393	2283680.0
2009-06-03 18:30:00	AAPL	Stock	5.04	5.04	5.0343	5.0343	69160.0
2009-06-03 19:00:00	AAPL	Stock	5.0357	5.0357	5.0329	5.0329	44072.0
2009-06-03 19:30:00	AAPL	Stock	5.0339	5.0357	5.0318	5.0357	173096.0
2009-06-03 06:30:00	MSFT	Stock	21.4	21.4	21.4	21.4	100.0
2009-06-03 08:00:00	MSFT	Stock	21.4	21.4	21.26	21.3	176250.0
2009-06-03 08:30:00	MSFT	Stock	21.37	21.37	21.24	21.25	5990.0
2009-06-03 09:00:00	MSFT	Stock	21.25	21.38	21.25	21.35	33468.0
2009-06-03 09:30:00	MSFT	Stock	21.31	21.65	21.31	21.48	5754305.0
2009-06-03 10:00:00	MSFT	Stock	21.48	21.65	21.42	21.602	4275105.0
2009-06-03 10:30:00	MSFT	Stock	21.601	21.675	21.57	21.67	3001675.0
2009-06-03 11:00:00	MSFT	Stock	21.67	21.69	21.58	21.615	2746805.0
2009-06-03 11:30:00	MSFT	Stock	21.6	21.68	21.59	21.61	2131382.0
2009-06-03 12:00:00	MSFT	Stock	21.61	21.61	21.48	21.491	1908887.0
2009-06-03 12:30:00	MSFT	Stock	21.5	21.52	21.43	21.45	1764424.0
2009-06-03 13:00:00	MSFT	Stock	21.46	21.46	21.32	21.36	1774796.0
2009-06-03 13:30:00	MSFT	Stock	21.36	21.44	21.29	21.44	3485560.0
2009-06-03 14:00:00	MSFT	Stock	21.44	21.47	21.38	21.43	2886969.0
2009-06-03 14:30:00	MSFT	Stock	21.433	21.57	21.42	21.54	2340232.0
2009-06-03 15:00:00	MSFT	Stock	21.55	21.57	21.48	21.49	3124132.0
2009-06-03 15:30:00	MSFT	Stock	21.5	21.76	21.47	21.74	8807739.0
2009-06-03 16:00:00	MSFT	Stock	21.74	21.77	21.538	21.74	9843222.0
2009-06-03 16:30:00	MSFT	Stock	21.76	21.77	21.73	21.75	714056.0
2009-06-03 17:00:00	MSFT	Stock	21.75	21.79	21.74	21.78	7087.0

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

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