PREVIEW / stock_30min / 2007-05-18

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-05-18.parquet
  size:    1.1 MB
  rows:    63,412
  symbols: 3,000

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-05-18 09:30:00	AAPL	Stock	3.9368	3.9482	3.9239	3.9389	152926928.0
2007-05-18 10:00:00	AAPL	Stock	3.9393	3.9514	3.9325	3.9429	74113396.0
2007-05-18 10:30:00	AAPL	Stock	3.9432	3.9439	3.9261	3.9279	53867856.0
2007-05-18 11:00:00	AAPL	Stock	3.9279	3.9325	3.9221	3.9286	36742580.0
2007-05-18 11:30:00	AAPL	Stock	3.9286	3.9296	3.9257	3.9282	21753172.0
2007-05-18 12:00:00	AAPL	Stock	3.9282	3.9321	3.9204	3.9289	27384672.0
2007-05-18 12:30:00	AAPL	Stock	3.9289	3.9375	3.9286	3.9314	33171404.0
2007-05-18 13:00:00	AAPL	Stock	3.9318	3.9339	3.9268	3.9282	15276100.0
2007-05-18 13:30:00	AAPL	Stock	3.9282	3.935	3.9264	3.9314	18327176.0
2007-05-18 14:00:00	AAPL	Stock	3.9314	3.9343	3.9275	3.9282	25628764.0
2007-05-18 14:30:00	AAPL	Stock	3.9275	3.9311	3.9225	3.9278	34437060.0
2007-05-18 15:00:00	AAPL	Stock	3.9275	3.9296	3.9221	3.9264	27814752.0
2007-05-18 15:30:00	AAPL	Stock	3.9264	3.9325	3.9261	3.9293	48769392.0
2007-05-18 16:00:00	AAPL	Stock	3.9293	3.9293	3.9279	3.9293	7091280.0
2007-05-18 09:30:00	MSFT	Stock	30.97	30.99	30.58	30.63	14580995.0
2007-05-18 10:00:00	MSFT	Stock	30.63	30.76	30.59	30.742	5230635.0
2007-05-18 10:30:00	MSFT	Stock	30.748	30.76	30.68	30.719	2171662.0
2007-05-18 11:00:00	MSFT	Stock	30.71	30.736	30.66	30.7	2027471.0
2007-05-18 11:30:00	MSFT	Stock	30.7	30.72	30.62	30.63	1978284.0
2007-05-18 12:00:00	MSFT	Stock	30.63	30.66	30.6	30.65	1804702.0
2007-05-18 12:30:00	MSFT	Stock	30.65	30.74	30.61	30.73	3082771.0
2007-05-18 13:00:00	MSFT	Stock	30.72	30.73	30.69	30.7	1028327.0
2007-05-18 13:30:00	MSFT	Stock	30.7	30.79	30.7	30.7	2295854.0
2007-05-18 14:00:00	MSFT	Stock	30.71	30.72	30.67	30.7	2258749.0
2007-05-18 14:30:00	MSFT	Stock	30.69	30.73	30.61	30.64	2891680.0
2007-05-18 15:00:00	MSFT	Stock	30.64	30.69	30.62	30.69	2418437.0
2007-05-18 15:30:00	MSFT	Stock	30.69	30.84	30.68	30.84	7061052.0
2007-05-18 16:00:00	MSFT	Stock	30.83	30.83	30.83	30.83	2060926.0
2007-05-18 08:00:00	NVDA	Stock	0.5763	0.5767	0.5763	0.5763	101700.0
2007-05-18 08:30:00	NVDA	Stock	0.5767	0.5767	0.5757	0.5767	367200.0
2007-05-18 09:00:00	NVDA	Stock	0.5767	0.577	0.5742	0.5767	2266800.0
2007-05-18 09:30:00	NVDA	Stock	0.5767	0.578	0.5725	0.578	76734600.0
2007-05-18 10:00:00	NVDA	Stock	0.578	0.5792	0.5768	0.5775	53514720.0
2007-05-18 10:30:00	NVDA	Stock	0.5775	0.5782	0.5723	0.5732	33416940.0
2007-05-18 11:00:00	NVDA	Stock	0.5728	0.5758	0.5718	0.5752	26664180.0
2007-05-18 11:30:00	NVDA	Stock	0.575	0.5775	0.575	0.5774	27120780.0
2007-05-18 12:00:00	NVDA	Stock	0.5773	0.579	0.5773	0.5782	26443200.0
2007-05-18 12:30:00	NVDA	Stock	0.5782	0.583	0.5782	0.5817	45377880.0
2007-05-18 13:00:00	NVDA	Stock	0.5816	0.583	0.5815	0.582	22600140.0
2007-05-18 13:30:00	NVDA	Stock	0.582	0.585	0.582	0.5847	53363580.0
2007-05-18 14:00:00	NVDA	Stock	0.5848	0.5853	0.583	0.5833	33028020.0
2007-05-18 14:30:00	NVDA	Stock	0.5833	0.5835	0.5808	0.5828	38684100.0
2007-05-18 15:00:00	NVDA	Stock	0.5828	0.583	0.5803	0.5813	44222220.0
2007-05-18 15:30:00	NVDA	Stock	0.5812	0.5847	0.581	0.584	78783000.0
2007-05-18 16:00:00	NVDA	Stock	0.584	0.584	0.5827	0.583	26314620.0
2007-05-18 16:30:00	NVDA	Stock	0.5835	0.5838	0.5833	0.5833	660000.0
2007-05-18 17:30:00	NVDA	Stock	0.5785	0.5785	0.5785	0.5785	192000.0
2007-05-18 18:00:00	NVDA	Stock	0.5828	0.5832	0.5828	0.5832	66000.0
2007-05-18 18:30:00	NVDA	Stock	0.5833	0.5837	0.5833	0.5837	36000.0
2007-05-18 19:30:00	NVDA	Stock	0.5837	0.5838	0.5837	0.5838	72000.0

> showing 50 of 63,412 rows — these rows as CSV

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