PREVIEW / stock_30min / 2010-03-02

all stock 30-min files

  file:    by_date/stock_30min/2010/2010-03-02.parquet
  size:    1.4 MB
  rows:    74,538
  symbols: 3,483

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
2010-03-02 04:00:00	AAPL	Stock	7.445	7.445	7.4446	7.4446	7224.0
2010-03-02 06:30:00	AAPL	Stock	7.4643	7.4643	7.4643	7.4643	2800.0
2010-03-02 07:00:00	AAPL	Stock	7.4857	7.5086	7.4679	7.4821	329448.0
2010-03-02 07:30:00	AAPL	Stock	7.4893	7.4893	7.4757	7.4854	102004.0
2010-03-02 08:00:00	AAPL	Stock	7.4893	7.5032	7.4786	7.5025	1128064.0
2010-03-02 08:30:00	AAPL	Stock	7.5004	7.5221	7.5	7.5161	2525712.0
2010-03-02 09:00:00	AAPL	Stock	7.5157	7.5157	7.4979	7.4993	1400868.0
2010-03-02 09:30:00	AAPL	Stock	7.4993	7.5296	7.4864	7.5053	94103240.0
2010-03-02 10:00:00	AAPL	Stock	7.5057	7.5107	7.4607	7.4814	64940120.0
2010-03-02 10:30:00	AAPL	Stock	7.4807	7.4961	7.4718	7.4721	33344080.0
2010-03-02 11:00:00	AAPL	Stock	7.4725	7.5157	7.4711	7.5046	30821840.0
2010-03-02 11:30:00	AAPL	Stock	7.5036	7.5093	7.4825	7.5039	23834888.0
2010-03-02 12:00:00	AAPL	Stock	7.5032	7.5064	7.4929	7.4968	15474060.0
2010-03-02 12:30:00	AAPL	Stock	7.4975	7.5036	7.4896	7.4929	13158684.0
2010-03-02 13:00:00	AAPL	Stock	7.4939	7.4982	7.4825	7.4897	10649548.0
2010-03-02 13:30:00	AAPL	Stock	7.49	7.5036	7.4893	7.5011	15611876.0
2010-03-02 14:00:00	AAPL	Stock	7.5009	7.5068	7.4732	7.4746	24487092.0
2010-03-02 14:30:00	AAPL	Stock	7.4746	7.4804	7.4264	7.4296	45904600.0
2010-03-02 15:00:00	AAPL	Stock	7.4296	7.4579	7.4257	7.4304	37916732.0
2010-03-02 15:30:00	AAPL	Stock	7.4307	7.4582	7.4193	7.4571	60093796.0
2010-03-02 16:00:00	AAPL	Stock	7.4571	7.4941	7.4514	7.4539	10943492.0
2010-03-02 16:30:00	AAPL	Stock	7.4536	7.4589	7.4521	7.4529	108332.0
2010-03-02 17:00:00	AAPL	Stock	7.4546	7.4575	7.4529	7.4568	100828.0
2010-03-02 17:30:00	AAPL	Stock	7.4579	7.4586	7.4536	7.4539	154168.0
2010-03-02 18:00:00	AAPL	Stock	7.4539	7.4589	7.4536	7.4536	166404.0
2010-03-02 18:30:00	AAPL	Stock	7.4529	7.4536	7.4493	7.4507	110936.0
2010-03-02 19:00:00	AAPL	Stock	7.4514	7.4579	7.4514	7.4521	61544.0
2010-03-02 19:30:00	AAPL	Stock	7.4518	7.4518	7.4464	7.4468	89208.0
2010-03-02 07:00:00	MSFT	Stock	29.01	29.01	29.01	29.01	140.0
2010-03-02 07:30:00	MSFT	Stock	29.08	29.08	29.08	29.08	275.0
2010-03-02 08:00:00	MSFT	Stock	29.1	29.16	29.1	29.16	1320.0
2010-03-02 08:30:00	MSFT	Stock	29.16	29.19	29.13	29.15	10767.0
2010-03-02 09:00:00	MSFT	Stock	29.15	29.15	29.05	29.06	19146.0
2010-03-02 09:30:00	MSFT	Stock	29.07	29.3	29.02	29.109	6908469.0
2010-03-02 10:00:00	MSFT	Stock	29.105	29.14	28.94	28.99	6502319.0
2010-03-02 10:30:00	MSFT	Stock	28.99	29.1	28.955	29.05	4245644.0
2010-03-02 11:00:00	MSFT	Stock	29.04	29.06	28.63	28.8	16391122.0
2010-03-02 11:30:00	MSFT	Stock	28.8	28.97	28.74	28.88	7028649.0
2010-03-02 12:00:00	MSFT	Stock	28.88	28.89	28.54	28.63	6192681.0
2010-03-02 12:30:00	MSFT	Stock	28.63	28.71	28.625	28.69	2519591.0
2010-03-02 13:00:00	MSFT	Stock	28.691	28.73	28.66	28.68	1633811.0
2010-03-02 13:30:00	MSFT	Stock	28.68	28.82	28.67	28.808	2720022.0
2010-03-02 14:00:00	MSFT	Stock	28.81	28.84	28.69	28.707	2664078.0
2010-03-02 14:30:00	MSFT	Stock	28.705	28.72	28.56	28.56	2873528.0
2010-03-02 15:00:00	MSFT	Stock	28.56	28.58	28.31	28.345	8960966.0
2010-03-02 15:30:00	MSFT	Stock	28.35	28.46	28.24	28.45	17586286.0
2010-03-02 16:00:00	MSFT	Stock	28.45	29.205	28.355	28.45	4665915.0
2010-03-02 16:30:00	MSFT	Stock	28.356	28.49	28.356	28.49	88436.0
2010-03-02 17:00:00	MSFT	Stock	28.48	28.48	28.48	28.48	200.0
2010-03-02 17:30:00	MSFT	Stock	28.45	28.45	28.45	28.45	400.0

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

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