PREVIEW / stock_30min / 2007-10-03

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-03.parquet
  size:    1.2 MB
  rows:    67,186
  symbols: 3,130

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
2007-10-03 05:30:00	AAPL	Stock	5.6439	5.6439	5.6429	5.6429	28000.0
2007-10-03 06:30:00	AAPL	Stock	5.6214	5.6214	5.6214	5.6214	14000.0
2007-10-03 07:00:00	AAPL	Stock	5.6211	5.65	5.62	5.6214	154728.0
2007-10-03 07:30:00	AAPL	Stock	5.62	5.6361	5.62	5.6339	297360.0
2007-10-03 08:00:00	AAPL	Stock	5.6286	5.6589	5.6214	5.6357	4838680.0
2007-10-03 08:30:00	AAPL	Stock	5.6343	5.6371	5.625	5.6346	1004948.0
2007-10-03 09:00:00	AAPL	Stock	5.6339	5.6479	5.6293	5.6396	2078860.0
2007-10-03 09:30:00	AAPL	Stock	5.6396	5.6536	5.6086	5.6136	88126220.0
2007-10-03 10:00:00	AAPL	Stock	5.6125	5.6571	5.6125	5.6489	73394580.0
2007-10-03 10:30:00	AAPL	Stock	5.6489	5.6679	5.6346	5.6636	71208452.0
2007-10-03 11:00:00	AAPL	Stock	5.6639	5.685	5.6525	5.6711	57599276.0
2007-10-03 11:30:00	AAPL	Stock	5.6707	5.6839	5.6536	5.6621	41572916.0
2007-10-03 12:00:00	AAPL	Stock	5.6614	5.6679	5.6504	5.6576	29896496.0
2007-10-03 12:30:00	AAPL	Stock	5.6575	5.6732	5.6525	5.6696	21721616.0
2007-10-03 13:00:00	AAPL	Stock	5.6693	5.6821	5.65	5.665	49682388.0
2007-10-03 13:30:00	AAPL	Stock	5.6639	5.6707	5.6343	5.6418	38118696.0
2007-10-03 14:00:00	AAPL	Stock	5.6414	5.6443	5.6218	5.63	49233212.0
2007-10-03 14:30:00	AAPL	Stock	5.6304	5.6418	5.6075	5.6211	59520216.0
2007-10-03 15:00:00	AAPL	Stock	5.6207	5.6364	5.615	5.6282	37646112.0
2007-10-03 15:30:00	AAPL	Stock	5.6286	5.6479	5.6257	5.6411	51425556.0
2007-10-03 16:00:00	AAPL	Stock	5.6411	5.65	5.6315	5.64	9424772.0
2007-10-03 16:30:00	AAPL	Stock	5.6418	5.6452	5.6282	5.6421	3840676.0
2007-10-03 17:00:00	AAPL	Stock	5.64	5.6471	5.6393	5.6471	684628.0
2007-10-03 17:30:00	AAPL	Stock	5.6436	5.6464	5.6429	5.6457	109116.0
2007-10-03 18:00:00	AAPL	Stock	5.6446	5.6482	5.64	5.6457	327796.0
2007-10-03 18:30:00	AAPL	Stock	5.6464	5.6464	5.6361	5.64	337008.0
2007-10-03 19:00:00	AAPL	Stock	5.64	5.6411	5.6375	5.6375	122192.0
2007-10-03 19:30:00	AAPL	Stock	5.6361	5.6468	5.6339	5.6468	172536.0
2007-10-03 08:00:00	MSFT	Stock	29.67	29.7	29.63	29.64	406128.0
2007-10-03 08:30:00	MSFT	Stock	29.66	29.68	29.65	29.66	3028.0
2007-10-03 09:00:00	MSFT	Stock	29.66	29.71	29.53	29.7	37424.0
2007-10-03 09:30:00	MSFT	Stock	29.71	29.71	29.46	29.53	2895654.0
2007-10-03 10:00:00	MSFT	Stock	29.53	29.59	29.53	29.58	2555069.0
2007-10-03 10:30:00	MSFT	Stock	29.58	29.61	29.55	29.59	2090352.0
2007-10-03 11:00:00	MSFT	Stock	29.59	29.85	29.47	29.53	3936608.0
2007-10-03 11:30:00	MSFT	Stock	29.52	29.54	29.47	29.489	1714856.0
2007-10-03 12:00:00	MSFT	Stock	29.485	29.49	29.36	29.37	2465495.0
2007-10-03 12:30:00	MSFT	Stock	29.37	29.44	29.36	29.4	1770061.0
2007-10-03 13:00:00	MSFT	Stock	29.39	29.43	29.36	29.42	1758628.0
2007-10-03 13:30:00	MSFT	Stock	29.42	29.429	29.32	29.38	1894167.0
2007-10-03 14:00:00	MSFT	Stock	29.38	29.39	29.31	29.375	2221564.0
2007-10-03 14:30:00	MSFT	Stock	29.37	29.39	29.29	29.39	2245853.0
2007-10-03 15:00:00	MSFT	Stock	29.38	29.41	29.32	29.32	2774608.0
2007-10-03 15:30:00	MSFT	Stock	29.325	29.47	29.31	29.47	6563032.0
2007-10-03 16:00:00	MSFT	Stock	29.47	29.5	29.379	29.47	2019598.0
2007-10-03 16:30:00	MSFT	Stock	29.5	29.591	29.38	29.591	230370.0
2007-10-03 17:00:00	MSFT	Stock	29.47	29.51	29.383	29.5	48641.0
2007-10-03 17:30:00	MSFT	Stock	29.48	29.52	29.48	29.52	3380.0
2007-10-03 18:00:00	MSFT	Stock	29.45	29.61	29.45	29.61	25567.0
2007-10-03 18:30:00	MSFT	Stock	29.45	29.45	29.44	29.45	1859.0

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

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