PREVIEW / stock_30min / 2009-06-02

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-06-02.parquet
  size:    1.3 MB
  rows:    74,059
  symbols: 3,337

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-02 08:00:00	AAPL	Stock	4.9818	4.9821	4.9557	4.9646	294616.0
2009-06-02 08:30:00	AAPL	Stock	4.9646	4.9646	4.9464	4.9607	335944.0
2009-06-02 09:00:00	AAPL	Stock	4.9557	4.9596	4.9507	4.9571	437080.0
2009-06-02 09:30:00	AAPL	Stock	4.9539	5.0293	4.9411	5.0218	69443528.0
2009-06-02 10:00:00	AAPL	Stock	5.0246	5.0479	5.0043	5.0194	62677468.0
2009-06-02 10:30:00	AAPL	Stock	5.0196	5.0246	4.9811	4.9861	33953388.0
2009-06-02 11:00:00	AAPL	Stock	4.9861	5.0061	4.975	5.0	26472040.0
2009-06-02 11:30:00	AAPL	Stock	5.0	5.0014	4.9621	4.9775	28910504.0
2009-06-02 12:00:00	AAPL	Stock	4.977	4.9814	4.9571	4.965	27897324.0
2009-06-02 12:30:00	AAPL	Stock	4.9643	4.9843	4.9643	4.9796	18112136.0
2009-06-02 13:00:00	AAPL	Stock	4.9793	4.98	4.9411	4.9601	24683568.0
2009-06-02 13:30:00	AAPL	Stock	4.9611	4.9818	4.9611	4.9811	19045824.0
2009-06-02 14:00:00	AAPL	Stock	4.9811	5.0029	4.9757	4.9936	25366964.0
2009-06-02 14:30:00	AAPL	Stock	4.9936	4.9964	4.9832	4.9846	16441964.0
2009-06-02 15:00:00	AAPL	Stock	4.9846	5.0	4.9846	4.9961	27279980.0
2009-06-02 15:30:00	AAPL	Stock	4.9961	5.0132	4.9696	4.9814	57863372.0
2009-06-02 16:00:00	AAPL	Stock	4.9814	4.9914	4.975	4.9814	8879920.0
2009-06-02 16:30:00	AAPL	Stock	4.9811	4.9821	4.9793	4.9811	576128.0
2009-06-02 17:00:00	AAPL	Stock	4.9814	4.9829	4.9807	4.9818	274372.0
2009-06-02 17:30:00	AAPL	Stock	4.9814	4.9818	4.9804	4.9818	125636.0
2009-06-02 18:00:00	AAPL	Stock	4.9839	5.0268	4.9818	5.0268	1374324.0
2009-06-02 18:30:00	AAPL	Stock	5.0232	5.0304	5.0218	5.0218	762412.0
2009-06-02 19:00:00	AAPL	Stock	5.0218	5.0261	5.0107	5.0143	389788.0
2009-06-02 19:30:00	AAPL	Stock	5.0111	5.0196	5.0111	5.0132	212604.0
2009-06-02 07:30:00	MSFT	Stock	21.5	21.5	21.45	21.5	1400.0
2009-06-02 08:00:00	MSFT	Stock	21.36	21.5	21.36	21.4	12465.0
2009-06-02 08:30:00	MSFT	Stock	21.4	21.4	21.3	21.3	14281.0
2009-06-02 09:00:00	MSFT	Stock	21.29	21.37	21.17	21.35	30254.0
2009-06-02 09:30:00	MSFT	Stock	21.35	21.78	21.2	21.76	5351815.0
2009-06-02 10:00:00	MSFT	Stock	21.76	21.98	21.72	21.79	6018333.0
2009-06-02 10:30:00	MSFT	Stock	21.79	21.79	21.57	21.61	3362977.0
2009-06-02 11:00:00	MSFT	Stock	21.62	21.83	21.615	21.74	3792747.0
2009-06-02 11:30:00	MSFT	Stock	21.74	21.75	21.52	21.52	3479275.0
2009-06-02 12:00:00	MSFT	Stock	21.525	21.54	21.32	21.333	3166845.0
2009-06-02 12:30:00	MSFT	Stock	21.33	21.45	21.25	21.43	3007949.0
2009-06-02 13:00:00	MSFT	Stock	21.431	21.44	21.31	21.43	1676693.0
2009-06-02 13:30:00	MSFT	Stock	21.42	21.5	21.42	21.49	2497652.0
2009-06-02 14:00:00	MSFT	Stock	21.5	21.52	21.41	21.481	2965226.0
2009-06-02 14:30:00	MSFT	Stock	21.485	21.53	21.42	21.43	1965669.0
2009-06-02 15:00:00	MSFT	Stock	21.43	21.54	21.43	21.46	4076259.0
2009-06-02 15:30:00	MSFT	Stock	21.46	21.52	21.37	21.4	4496361.0
2009-06-02 16:00:00	MSFT	Stock	21.4	21.8	21.34	21.4	1683855.0
2009-06-02 16:30:00	MSFT	Stock	21.4	21.536	21.38	21.4	313927.0
2009-06-02 17:00:00	MSFT	Stock	21.561	21.561	21.4	21.547	8514.0
2009-06-02 17:30:00	MSFT	Stock	21.4	21.4	21.4	21.4	9435.0
2009-06-02 18:00:00	MSFT	Stock	21.4	21.4	21.4	21.4	1000.0
2009-06-02 18:30:00	MSFT	Stock	21.4	21.4	21.38	21.38	391.0
2009-06-02 19:00:00	MSFT	Stock	21.4	21.4	21.4	21.4	150.0
2009-06-02 19:30:00	MSFT	Stock	21.4	21.45	21.4	21.45	4543.0
2009-06-02 08:00:00	NVDA	Stock	0.273	0.273	0.2725	0.2725	12000.0

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

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