PREVIEW / stock_30min / 2007-05-01

all stock 30-min files

  file:    by_date/stock_30min/2007/2007-05-01.parquet
  size:    1.1 MB
  rows:    58,031
  symbols: 2,677

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-01 09:30:00	AAPL	Stock	3.5568	3.5839	3.5475	3.5579	73521420.0
2007-05-01 10:00:00	AAPL	Stock	3.5579	3.5607	3.5196	3.5268	77905772.0
2007-05-01 10:30:00	AAPL	Stock	3.525	3.5357	3.5225	3.5311	53550056.0
2007-05-01 11:00:00	AAPL	Stock	3.5304	3.5836	3.525	3.5414	35632688.0
2007-05-01 11:30:00	AAPL	Stock	3.5418	3.5529	3.5361	3.5418	33356848.0
2007-05-01 12:00:00	AAPL	Stock	3.5414	3.5464	3.5293	3.5304	19660900.0
2007-05-01 12:30:00	AAPL	Stock	3.5307	3.5393	3.5272	3.5286	19026476.0
2007-05-01 13:00:00	AAPL	Stock	3.5286	3.5336	3.5214	3.5323	28383600.0
2007-05-01 13:30:00	AAPL	Stock	3.5325	3.55	3.5307	3.5482	35862960.0
2007-05-01 14:00:00	AAPL	Stock	3.5482	3.5571	3.5414	3.5543	26484052.0
2007-05-01 14:30:00	AAPL	Stock	3.555	3.5664	3.5518	3.5565	37287740.0
2007-05-01 15:00:00	AAPL	Stock	3.5564	3.5614	3.5457	3.5465	31094224.0
2007-05-01 15:30:00	AAPL	Stock	3.5464	3.5564	3.5446	3.5525	38029992.0
2007-05-01 16:00:00	AAPL	Stock	3.5525	3.5525	3.55	3.5525	5500572.0
2007-05-01 09:30:00	MSFT	Stock	29.94	30.08	29.9	30.06	7843812.0
2007-05-01 10:00:00	MSFT	Stock	30.06	30.09	29.96	30.09	7331885.0
2007-05-01 10:30:00	MSFT	Stock	30.09	30.27	30.07	30.25	6742751.0
2007-05-01 11:00:00	MSFT	Stock	30.25	30.29	30.2	30.2	5329594.0
2007-05-01 11:30:00	MSFT	Stock	30.2	30.245	30.19	30.192	2748034.0
2007-05-01 12:00:00	MSFT	Stock	30.2	30.24	30.19	30.23	2346434.0
2007-05-01 12:30:00	MSFT	Stock	30.24	30.26	30.08	30.11	3955337.0
2007-05-01 13:00:00	MSFT	Stock	30.11	30.17	30.1	30.17	2919538.0
2007-05-01 13:30:00	MSFT	Stock	30.17	30.21	30.14	30.17	2869511.0
2007-05-01 14:00:00	MSFT	Stock	30.16	30.26	30.14	30.25	3710366.0
2007-05-01 14:30:00	MSFT	Stock	30.245	30.32	30.24	30.31	5170730.0
2007-05-01 15:00:00	MSFT	Stock	30.31	30.34	30.27	30.28	5119025.0
2007-05-01 15:30:00	MSFT	Stock	30.28	30.42	30.18	30.41	11106703.0
2007-05-01 16:00:00	MSFT	Stock	30.4	30.42	30.4	30.4	1126750.0
2007-05-01 09:00:00	NVDA	Stock	0.5558	0.5592	0.5555	0.5592	930000.0
2007-05-01 09:30:00	NVDA	Stock	0.5582	0.5583	0.5525	0.5553	71018160.0
2007-05-01 10:00:00	NVDA	Stock	0.555	0.5567	0.5495	0.5508	70687380.0
2007-05-01 10:30:00	NVDA	Stock	0.551	0.5575	0.551	0.5573	47358480.0
2007-05-01 11:00:00	NVDA	Stock	0.5575	0.5618	0.5553	0.5588	39681900.0
2007-05-01 11:30:00	NVDA	Stock	0.5588	0.5595	0.5533	0.5543	26135880.0
2007-05-01 12:00:00	NVDA	Stock	0.5545	0.5558	0.553	0.554	27944520.0
2007-05-01 12:30:00	NVDA	Stock	0.5542	0.5565	0.5532	0.5552	28273080.0
2007-05-01 13:00:00	NVDA	Stock	0.5552	0.5552	0.5502	0.5525	31594020.0
2007-05-01 13:30:00	NVDA	Stock	0.5525	0.5563	0.5512	0.5555	29283300.0
2007-05-01 14:00:00	NVDA	Stock	0.5557	0.5567	0.5538	0.5563	25059900.0
2007-05-01 14:30:00	NVDA	Stock	0.5563	0.561	0.5555	0.5575	38909160.0
2007-05-01 15:00:00	NVDA	Stock	0.5577	0.5588	0.555	0.5552	28978320.0
2007-05-01 15:30:00	NVDA	Stock	0.5552	0.5552	0.5527	0.5542	64762260.0
2007-05-01 16:00:00	NVDA	Stock	0.5542	0.5565	0.554	0.5565	6948780.0
2007-05-01 16:30:00	NVDA	Stock	0.5565	0.557	0.5565	0.557	27000.0
2007-05-01 17:30:00	NVDA	Stock	0.556	0.556	0.556	0.556	30000.0
2007-05-01 18:00:00	NVDA	Stock	0.5567	0.5567	0.5567	0.5567	7200.0
2007-05-01 18:30:00	NVDA	Stock	0.556	0.556	0.556	0.556	30000.0
2007-05-01 19:00:00	NVDA	Stock	0.5567	0.5567	0.5567	0.5567	120000.0
2007-05-01 19:30:00	NVDA	Stock	0.556	0.556	0.556	0.556	40800.0
2007-05-01 07:00:00	AMZN	Stock	3.0575	3.0575	3.0335	3.0575	46000.0

> showing 50 of 58,031 rows — these rows as CSV

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