PREVIEW / stock_30min / 2009-04-30

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-04-30.parquet
  size:    1.3 MB
  rows:    74,103
  symbols: 3,340

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-04-30 04:00:00	AAPL	Stock	4.5046	4.5046	4.5046	4.5046	2800.0
2009-04-30 04:30:00	AAPL	Stock	4.5332	4.5332	4.5286	4.5286	16800.0
2009-04-30 07:00:00	AAPL	Stock	4.5204	4.5321	4.5054	4.5268	96320.0
2009-04-30 07:30:00	AAPL	Stock	4.5268	4.5268	4.5089	4.5179	144200.0
2009-04-30 08:00:00	AAPL	Stock	4.5179	4.5304	4.5093	4.5214	885752.0
2009-04-30 08:30:00	AAPL	Stock	4.5214	4.5214	4.5107	4.5107	386540.0
2009-04-30 09:00:00	AAPL	Stock	4.5107	4.5214	4.5071	4.5143	379120.0
2009-04-30 09:30:00	AAPL	Stock	4.5071	4.5154	4.4643	4.5039	79078132.0
2009-04-30 10:00:00	AAPL	Stock	4.5046	4.5268	4.5032	4.5229	35130060.0
2009-04-30 10:30:00	AAPL	Stock	4.5232	4.5279	4.5032	4.5257	27666800.0
2009-04-30 11:00:00	AAPL	Stock	4.5268	4.5357	4.5157	4.5175	25789652.0
2009-04-30 11:30:00	AAPL	Stock	4.5182	4.5332	4.5118	4.5207	27552084.0
2009-04-30 12:00:00	AAPL	Stock	4.52	4.5296	4.5161	4.5289	20068972.0
2009-04-30 12:30:00	AAPL	Stock	4.5293	4.5296	4.4939	4.5086	32201960.0
2009-04-30 13:00:00	AAPL	Stock	4.5086	4.5196	4.4811	4.4893	30507568.0
2009-04-30 13:30:00	AAPL	Stock	4.4889	4.505	4.4821	4.4936	22048488.0
2009-04-30 14:00:00	AAPL	Stock	4.4943	4.5046	4.4821	4.5014	26156816.0
2009-04-30 14:30:00	AAPL	Stock	4.5007	4.5011	4.4821	4.4907	24898272.0
2009-04-30 15:00:00	AAPL	Stock	4.4907	4.4929	4.4614	4.4818	44304176.0
2009-04-30 15:30:00	AAPL	Stock	4.4818	4.5029	4.4775	4.4929	54483016.0
2009-04-30 16:00:00	AAPL	Stock	4.4943	4.5206	4.4857	4.4893	33044564.0
2009-04-30 16:30:00	AAPL	Stock	4.4893	4.5002	4.4893	4.4893	1110004.0
2009-04-30 17:00:00	AAPL	Stock	4.4939	4.4939	4.4786	4.4821	44016.0
2009-04-30 17:30:00	AAPL	Stock	4.4786	4.4839	4.4782	4.4839	73640.0
2009-04-30 18:00:00	AAPL	Stock	4.4939	4.4939	4.4821	4.4875	302092.0
2009-04-30 18:30:00	AAPL	Stock	4.4875	4.4939	4.4875	4.4875	158620.0
2009-04-30 19:00:00	AAPL	Stock	4.4893	4.4929	4.4893	4.4893	47432.0
2009-04-30 19:30:00	AAPL	Stock	4.4857	4.4943	4.4857	4.4939	45332.0
2009-04-30 07:00:00	MSFT	Stock	20.5	20.5	20.5	20.5	4000.0
2009-04-30 07:30:00	MSFT	Stock	20.45	20.45	20.45	20.45	300.0
2009-04-30 08:00:00	MSFT	Stock	20.5	20.59	20.45	20.52	51565.0
2009-04-30 08:30:00	MSFT	Stock	20.55	20.58	20.5	20.54	36888.0
2009-04-30 09:00:00	MSFT	Stock	20.54	20.63	20.54	20.6	177678.0
2009-04-30 09:30:00	MSFT	Stock	20.6	20.92	20.6	20.821	10361975.0
2009-04-30 10:00:00	MSFT	Stock	20.82	21.1	20.74	21.05	8950209.0
2009-04-30 10:30:00	MSFT	Stock	21.05	21.07	20.81	20.96	5742690.0
2009-04-30 11:00:00	MSFT	Stock	20.95	20.99	20.74	20.81	4679238.0
2009-04-30 11:30:00	MSFT	Stock	20.81	20.91	20.55	20.57	5320035.0
2009-04-30 12:00:00	MSFT	Stock	20.57	20.58	20.49	20.58	3623793.0
2009-04-30 12:30:00	MSFT	Stock	20.58	20.59	20.27	20.34	4468530.0
2009-04-30 13:00:00	MSFT	Stock	20.34	20.41	20.2	20.24	4219162.0
2009-04-30 13:30:00	MSFT	Stock	20.24	20.33	20.19	20.27	4095058.0
2009-04-30 14:00:00	MSFT	Stock	20.26	20.36	20.2	20.36	2862835.0
2009-04-30 14:30:00	MSFT	Stock	20.35	20.36	20.27	20.305	3652658.0
2009-04-30 15:00:00	MSFT	Stock	20.3	20.31	20.18	20.23	5899834.0
2009-04-30 15:30:00	MSFT	Stock	20.239	20.44	20.01	20.26	10016190.0
2009-04-30 16:00:00	MSFT	Stock	20.27	20.912	20.23	20.263	6359358.0
2009-04-30 16:30:00	MSFT	Stock	20.262	20.615	20.25	20.25	701318.0
2009-04-30 17:00:00	MSFT	Stock	20.26	20.26	20.23	20.25	2537.0
2009-04-30 17:30:00	MSFT	Stock	20.23	20.266	20.23	20.25	9307.0

> showing 50 of 74,103 rows — these rows as CSV

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