PREVIEW / stock_30min / 2007-10-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-10-01.parquet
  size:    1.2 MB
  rows:    68,478
  symbols: 3,135

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-01 07:00:00	AAPL	Stock	5.4643	5.4643	5.4536	5.4536	84000.0
2007-10-01 07:30:00	AAPL	Stock	5.4768	5.4768	5.4664	5.475	122640.0
2007-10-01 08:00:00	AAPL	Stock	5.4668	5.5143	5.4668	5.5107	2176132.0
2007-10-01 08:30:00	AAPL	Stock	5.51	5.5254	5.4836	5.5029	2891056.0
2007-10-01 09:00:00	AAPL	Stock	5.5043	5.5268	5.4982	5.5214	2696792.0
2007-10-01 09:30:00	AAPL	Stock	5.5214	5.5311	5.4821	5.4889	92362396.0
2007-10-01 10:00:00	AAPL	Stock	5.4886	5.5036	5.4618	5.4761	82312972.0
2007-10-01 10:30:00	AAPL	Stock	5.475	5.5036	5.4743	5.4929	43899772.0
2007-10-01 11:00:00	AAPL	Stock	5.4929	5.5207	5.4868	5.5146	52065776.0
2007-10-01 11:30:00	AAPL	Stock	5.5146	5.5654	5.51	5.5645	102805864.0
2007-10-01 12:00:00	AAPL	Stock	5.565	5.5786	5.5518	5.5657	61955712.0
2007-10-01 12:30:00	AAPL	Stock	5.5654	5.5754	5.5589	5.5736	29852956.0
2007-10-01 13:00:00	AAPL	Stock	5.5739	5.5839	5.5643	5.5679	34405308.0
2007-10-01 13:30:00	AAPL	Stock	5.5671	5.5796	5.5621	5.5707	36824676.0
2007-10-01 14:00:00	AAPL	Stock	5.5711	5.5996	5.5704	5.5958	56437948.0
2007-10-01 14:30:00	AAPL	Stock	5.5957	5.6211	5.5918	5.6132	68954536.0
2007-10-01 15:00:00	AAPL	Stock	5.6129	5.6218	5.5879	5.5989	62791120.0
2007-10-01 15:30:00	AAPL	Stock	5.5989	5.6	5.5664	5.5857	86933308.0
2007-10-01 16:00:00	AAPL	Stock	5.5864	5.5907	5.4831	5.5012	13798092.0
2007-10-01 16:30:00	AAPL	Stock	5.5825	5.5879	5.5776	5.5843	1523452.0
2007-10-01 17:00:00	AAPL	Stock	5.5846	5.5879	5.5818	5.5818	271264.0
2007-10-01 17:30:00	AAPL	Stock	5.5829	5.5879	5.5829	5.5846	868868.0
2007-10-01 18:00:00	AAPL	Stock	5.5846	5.5846	5.5821	5.5821	545972.0
2007-10-01 18:30:00	AAPL	Stock	5.5818	5.5818	5.5757	5.5768	119700.0
2007-10-01 19:00:00	AAPL	Stock	5.5786	5.5821	5.5757	5.5821	126840.0
2007-10-01 19:30:00	AAPL	Stock	5.5804	5.5854	5.5804	5.5854	244216.0
2007-10-01 04:00:00	MSFT	Stock	29.5	29.5	29.5	29.5	100.0
2007-10-01 08:00:00	MSFT	Stock	29.54	29.59	29.42	29.45	10825.0
2007-10-01 08:30:00	MSFT	Stock	29.44	29.44	29.44	29.44	1200.0
2007-10-01 09:00:00	MSFT	Stock	29.46	29.48	29.44	29.46	161020.0
2007-10-01 09:30:00	MSFT	Stock	29.46	29.73	29.41	29.68	5167201.0
2007-10-01 10:00:00	MSFT	Stock	29.69	29.75	29.58	29.59	3377687.0
2007-10-01 10:30:00	MSFT	Stock	29.58	29.61	29.55	29.56	2398143.0
2007-10-01 11:00:00	MSFT	Stock	29.57	29.6	29.53	29.542	2165340.0
2007-10-01 11:30:00	MSFT	Stock	29.54	29.61	29.54	29.58	2211917.0
2007-10-01 12:00:00	MSFT	Stock	29.58	29.69	29.58	29.62	2718861.0
2007-10-01 12:30:00	MSFT	Stock	29.62	29.67	29.61	29.619	1966476.0
2007-10-01 13:00:00	MSFT	Stock	29.61	29.71	29.6	29.7	2586288.0
2007-10-01 13:30:00	MSFT	Stock	29.7	29.72	29.68	29.71	2188419.0
2007-10-01 14:00:00	MSFT	Stock	29.71	29.75	29.56	29.7	2687267.0
2007-10-01 14:30:00	MSFT	Stock	29.7	29.77	29.69	29.74	2875024.0
2007-10-01 15:00:00	MSFT	Stock	29.73	29.78	29.72	29.77	2718662.0
2007-10-01 15:30:00	MSFT	Stock	29.78	29.79	29.73	29.76	6529487.0
2007-10-01 16:00:00	MSFT	Stock	29.77	29.79	29.635	29.65	3729775.0
2007-10-01 16:30:00	MSFT	Stock	29.75	29.75	29.704	29.704	109386.0
2007-10-01 17:00:00	MSFT	Stock	29.72	29.75	29.72	29.73	10006.0
2007-10-01 17:30:00	MSFT	Stock	29.677	29.75	29.677	29.73	242072.0
2007-10-01 18:00:00	MSFT	Stock	29.74	29.77	29.7	29.7	20535.0
2007-10-01 18:30:00	MSFT	Stock	29.71	29.71	29.71	29.71	125.0
2007-10-01 19:30:00	MSFT	Stock	29.75	29.75	29.71	29.71	250.0

> showing 50 of 68,478 rows — these rows as CSV

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