PREVIEW / stock_30min / 2008-11-07

all stock 30-min files

  file:    by_date/stock_30min/2008/2008-11-07.parquet
  size:    1.2 MB
  rows:    67,190
  symbols: 3,282

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
2008-11-07 07:00:00	AAPL	Stock	3.6179	3.6179	3.5896	3.5896	8400.0
2008-11-07 07:30:00	AAPL	Stock	3.5821	3.5821	3.5625	3.5625	205072.0
2008-11-07 08:00:00	AAPL	Stock	3.5714	3.5732	3.5482	3.5679	1742272.0
2008-11-07 08:30:00	AAPL	Stock	3.5614	3.5786	3.5289	3.5293	3893708.0
2008-11-07 09:00:00	AAPL	Stock	3.5336	3.5546	3.5221	3.5418	2571240.0
2008-11-07 09:30:00	AAPL	Stock	3.5418	3.5571	3.4186	3.4432	171565856.0
2008-11-07 10:00:00	AAPL	Stock	3.4436	3.5161	3.4418	3.5011	137896528.0
2008-11-07 10:30:00	AAPL	Stock	3.5018	3.5661	3.4954	3.5282	105397600.0
2008-11-07 11:00:00	AAPL	Stock	3.5289	3.5321	3.4704	3.4882	92430884.0
2008-11-07 11:30:00	AAPL	Stock	3.4875	3.5236	3.4782	3.5229	58364488.0
2008-11-07 12:00:00	AAPL	Stock	3.5236	3.5432	3.5139	3.5279	46591580.0
2008-11-07 12:30:00	AAPL	Stock	3.5279	3.5461	3.5143	3.5393	45432940.0
2008-11-07 13:00:00	AAPL	Stock	3.5404	3.5532	3.5143	3.5421	42866292.0
2008-11-07 13:30:00	AAPL	Stock	3.5421	3.5454	3.5007	3.5286	39128348.0
2008-11-07 14:00:00	AAPL	Stock	3.5286	3.5418	3.5143	3.5211	40628952.0
2008-11-07 14:30:00	AAPL	Stock	3.5211	3.5482	3.4743	3.475	66328444.0
2008-11-07 15:00:00	AAPL	Stock	3.4754	3.5043	3.4411	3.4482	107799076.0
2008-11-07 15:30:00	AAPL	Stock	3.4484	3.5082	3.4404	3.5075	106588608.0
2008-11-07 16:00:00	AAPL	Stock	3.5082	3.5321	3.4752	3.5207	17412472.0
2008-11-07 16:30:00	AAPL	Stock	3.5182	3.5207	3.5089	3.5182	398860.0
2008-11-07 17:00:00	AAPL	Stock	3.5182	3.52	3.5086	3.5086	496524.0
2008-11-07 17:30:00	AAPL	Stock	3.5164	3.5186	3.5143	3.5143	78316.0
2008-11-07 18:00:00	AAPL	Stock	3.515	3.5179	3.5125	3.5179	375312.0
2008-11-07 18:30:00	AAPL	Stock	3.5196	3.5232	3.5164	3.5232	74200.0
2008-11-07 19:00:00	AAPL	Stock	3.5232	3.5246	3.5196	3.5246	119924.0
2008-11-07 19:30:00	AAPL	Stock	3.5264	3.5264	3.5196	3.5254	152740.0
2008-11-07 07:30:00	MSFT	Stock	21.38	21.45	21.11	21.11	2040.0
2008-11-07 08:00:00	MSFT	Stock	21.2	21.3	21.11	21.11	58223.0
2008-11-07 08:30:00	MSFT	Stock	21.12	21.25	21.05	21.18	98476.0
2008-11-07 09:00:00	MSFT	Stock	21.16	21.34	21.14	21.32	122089.0
2008-11-07 09:30:00	MSFT	Stock	21.32	21.39	21.0	21.13	7264020.0
2008-11-07 10:00:00	MSFT	Stock	21.13	21.46	21.12	21.36	7999423.0
2008-11-07 10:30:00	MSFT	Stock	21.36	21.48	21.3	21.4	5592484.0
2008-11-07 11:00:00	MSFT	Stock	21.4	21.42	21.22	21.25	4627775.0
2008-11-07 11:30:00	MSFT	Stock	21.25	21.43	21.21	21.42	3996060.0
2008-11-07 12:00:00	MSFT	Stock	21.42	21.5	21.35	21.35	3561323.0
2008-11-07 12:30:00	MSFT	Stock	21.35	21.47	21.26	21.38	2819539.0
2008-11-07 13:00:00	MSFT	Stock	21.38	21.45	21.23	21.381	3422867.0
2008-11-07 13:30:00	MSFT	Stock	21.38	21.43	21.235	21.41	2678625.0
2008-11-07 14:00:00	MSFT	Stock	21.43	21.43	21.3	21.34	2854486.0
2008-11-07 14:30:00	MSFT	Stock	21.34	21.49	21.15	21.15	4476244.0
2008-11-07 15:00:00	MSFT	Stock	21.15	21.35	21.03	21.15	6871017.0
2008-11-07 15:30:00	MSFT	Stock	21.15	21.54	21.11	21.53	9731372.0
2008-11-07 16:00:00	MSFT	Stock	21.53	21.64	21.262	21.53	2873101.0
2008-11-07 16:30:00	MSFT	Stock	21.53	21.55	21.45	21.5	9825.0
2008-11-07 17:00:00	MSFT	Stock	21.5	21.56	21.5	21.56	455110.0
2008-11-07 17:30:00	MSFT	Stock	21.5	21.5	21.5	21.5	5000.0
2008-11-07 18:00:00	MSFT	Stock	21.56	21.61	21.53	21.53	9269.0
2008-11-07 18:30:00	MSFT	Stock	21.56	21.56	21.56	21.56	100.0
2008-11-07 19:00:00	MSFT	Stock	21.53	21.55	21.53	21.55	300.0

> showing 50 of 67,190 rows — these rows as CSV

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