PREVIEW / stock_30min / 2009-05-08

all stock 30-min files

  file:    by_date/stock_30min/2009/2009-05-08.parquet
  size:    1.3 MB
  rows:    71,112
  symbols: 3,370

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-05-08 05:00:00	AAPL	Stock	4.6536	4.6536	4.6536	4.6536	5600.0
2009-05-08 06:00:00	AAPL	Stock	4.6607	4.6607	4.6607	4.6607	14000.0
2009-05-08 06:30:00	AAPL	Stock	4.6554	4.6554	4.6554	4.6554	14000.0
2009-05-08 07:00:00	AAPL	Stock	4.6607	4.6696	4.6607	4.6607	15400.0
2009-05-08 07:30:00	AAPL	Stock	4.6607	4.6661	4.6386	4.6393	138964.0
2009-05-08 08:00:00	AAPL	Stock	4.6382	4.66	4.6379	4.6429	450268.0
2009-05-08 08:30:00	AAPL	Stock	4.6464	4.6604	4.6161	4.6343	895524.0
2009-05-08 09:00:00	AAPL	Stock	4.635	4.6357	4.6071	4.6071	766192.0
2009-05-08 09:30:00	AAPL	Stock	4.6086	4.6869	4.5689	4.6495	76301288.0
2009-05-08 10:00:00	AAPL	Stock	4.6475	4.6489	4.5096	4.53	71773240.0
2009-05-08 10:30:00	AAPL	Stock	4.5285	4.5504	4.5093	4.5396	41519716.0
2009-05-08 11:00:00	AAPL	Stock	4.5396	4.5839	4.5396	4.565	31184692.0
2009-05-08 11:30:00	AAPL	Stock	4.565	4.5764	4.5464	4.5618	19702396.0
2009-05-08 12:00:00	AAPL	Stock	4.5604	4.6046	4.5504	4.5879	27025320.0
2009-05-08 12:30:00	AAPL	Stock	4.5875	4.6161	4.5714	4.6143	22273832.0
2009-05-08 13:00:00	AAPL	Stock	4.6144	4.6193	4.5643	4.5882	18702376.0
2009-05-08 13:30:00	AAPL	Stock	4.5882	4.5954	4.5754	4.5878	16673972.0
2009-05-08 14:00:00	AAPL	Stock	4.5864	4.6236	4.5857	4.6089	21291172.0
2009-05-08 14:30:00	AAPL	Stock	4.6089	4.6468	4.6079	4.6389	26120892.0
2009-05-08 15:00:00	AAPL	Stock	4.6396	4.6436	4.6118	4.6246	25640972.0
2009-05-08 15:30:00	AAPL	Stock	4.6236	4.6282	4.6036	4.6154	47845560.0
2009-05-08 16:00:00	AAPL	Stock	4.6157	4.621	4.5625	4.6132	15552880.0
2009-05-08 16:30:00	AAPL	Stock	4.6132	4.6189	4.6132	4.6132	61152.0
2009-05-08 17:00:00	AAPL	Stock	4.6143	4.6143	4.6143	4.6143	28252.0
2009-05-08 17:30:00	AAPL	Stock	4.6136	4.6196	4.6125	4.6196	56000.0
2009-05-08 18:00:00	AAPL	Stock	4.6193	4.625	4.6193	4.625	28000.0
2009-05-08 18:30:00	AAPL	Stock	4.62	4.62	4.62	4.62	11900.0
2009-05-08 19:00:00	AAPL	Stock	4.6261	4.6261	4.6146	4.6146	16856.0
2009-05-08 19:30:00	AAPL	Stock	4.6264	4.6264	4.6146	4.6146	13300.0
2009-05-08 04:30:00	MSFT	Stock	19.75	19.75	19.75	19.75	600.0
2009-05-08 06:30:00	MSFT	Stock	19.63	19.63	19.63	19.63	1000.0
2009-05-08 07:00:00	MSFT	Stock	19.61	19.61	19.61	19.61	1000.0
2009-05-08 07:30:00	MSFT	Stock	19.5	19.5	19.5	19.5	400.0
2009-05-08 08:00:00	MSFT	Stock	19.5	19.59	19.46	19.52	8150.0
2009-05-08 08:30:00	MSFT	Stock	19.52	19.65	19.46	19.5	17220.0
2009-05-08 09:00:00	MSFT	Stock	19.51	19.53	19.41	19.46	16338.0
2009-05-08 09:30:00	MSFT	Stock	19.47	19.64	19.38	19.56	8434220.0
2009-05-08 10:00:00	MSFT	Stock	19.56	19.57	19.24	19.29	6707044.0
2009-05-08 10:30:00	MSFT	Stock	19.29	19.44	19.261	19.38	7080480.0
2009-05-08 11:00:00	MSFT	Stock	19.38	19.43	19.34	19.37	2421883.0
2009-05-08 11:30:00	MSFT	Stock	19.368	19.38	19.28	19.32	2584950.0
2009-05-08 12:00:00	MSFT	Stock	19.32	19.37	19.22	19.23	5069535.0
2009-05-08 12:30:00	MSFT	Stock	19.23	19.32	19.22	19.3	2384955.0
2009-05-08 13:00:00	MSFT	Stock	19.3	19.35	19.24	19.26	2801297.0
2009-05-08 13:30:00	MSFT	Stock	19.252	19.26	19.14	19.19	3814899.0
2009-05-08 14:00:00	MSFT	Stock	19.19	19.39	19.18	19.261	2798058.0
2009-05-08 14:30:00	MSFT	Stock	19.26	19.4	19.24	19.39	2810750.0
2009-05-08 15:00:00	MSFT	Stock	19.4	19.51	19.33	19.47	7141132.0
2009-05-08 15:30:00	MSFT	Stock	19.47	19.63	19.32	19.42	9175879.0
2009-05-08 16:00:00	MSFT	Stock	19.42	19.672	19.26	19.4	3164614.0

> showing 50 of 71,112 rows — these rows as CSV

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