PREVIEW / stock_1hour / 2008-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-07.parquet
  size:    838 KB
  rows:    40,163
  symbols: 3,288

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
2008-05-07 06:00:00	AAPL	Stock	6.6539	6.6539	6.6539	6.6539	2800.0
2008-05-07 07:00:00	AAPL	Stock	6.66	6.6629	6.6168	6.6225	209468.0
2008-05-07 08:00:00	AAPL	Stock	6.6254	6.6625	6.6254	6.6429	3964912.0
2008-05-07 09:00:00	AAPL	Stock	6.6461	6.6664	6.5989	6.6339	121347632.0
2008-05-07 10:00:00	AAPL	Stock	6.6343	6.7071	6.6196	6.685	185065244.0
2008-05-07 11:00:00	AAPL	Stock	6.6854	6.7214	6.6389	6.6518	146323576.0
2008-05-07 12:00:00	AAPL	Stock	6.6514	6.6839	6.6454	6.6604	79287180.0
2008-05-07 13:00:00	AAPL	Stock	6.6611	6.6646	6.5607	6.5839	150682896.0
2008-05-07 14:00:00	AAPL	Stock	6.5839	6.5979	6.4961	6.5196	192394748.0
2008-05-07 15:00:00	AAPL	Stock	6.5189	6.5357	6.4479	6.5257	253673392.0
2008-05-07 16:00:00	AAPL	Stock	6.5329	6.5988	6.515	6.5161	15356068.0
2008-05-07 17:00:00	AAPL	Stock	6.5196	6.5286	6.5143	6.5232	1041992.0
2008-05-07 18:00:00	AAPL	Stock	6.525	6.5268	6.5196	6.5196	553616.0
2008-05-07 19:00:00	AAPL	Stock	6.5196	6.535	6.5196	6.535	536648.0
2008-05-07 07:00:00	MSFT	Stock	29.77	29.77	29.77	29.77	290.0
2008-05-07 08:00:00	MSFT	Stock	29.65	29.77	29.65	29.72	12148.0
2008-05-07 09:00:00	MSFT	Stock	29.72	29.982	29.68	29.93	10257303.0
2008-05-07 10:00:00	MSFT	Stock	29.92	30.14	29.85	30.0	16026465.0
2008-05-07 11:00:00	MSFT	Stock	30.01	30.04	29.85	29.85	8897493.0
2008-05-07 12:00:00	MSFT	Stock	29.859	29.94	29.83	29.88	6699366.0
2008-05-07 13:00:00	MSFT	Stock	29.888	29.9	29.51	29.6	9397343.0
2008-05-07 14:00:00	MSFT	Stock	29.6	29.69	29.38	29.438	11030036.0
2008-05-07 15:00:00	MSFT	Stock	29.44	29.46	29.08	29.19	20030594.0
2008-05-07 16:00:00	MSFT	Stock	29.2	29.708	29.16	29.2	5619112.0
2008-05-07 17:00:00	MSFT	Stock	29.19	29.27	29.18	29.24	77478.0
2008-05-07 18:00:00	MSFT	Stock	29.22	29.26	29.22	29.22	3518.0
2008-05-07 19:00:00	MSFT	Stock	29.22	29.26	29.22	29.23	4744.0
2008-05-07 08:00:00	NVDA	Stock	0.565	0.5665	0.5625	0.5642	421760.0
2008-05-07 09:00:00	NVDA	Stock	0.5642	0.5715	0.5638	0.5655	88970120.0
2008-05-07 10:00:00	NVDA	Stock	0.5655	0.5722	0.5612	0.5622	134907520.0
2008-05-07 11:00:00	NVDA	Stock	0.562	0.5635	0.553	0.554	113809440.0
2008-05-07 12:00:00	NVDA	Stock	0.554	0.5588	0.5532	0.5588	57866160.0
2008-05-07 13:00:00	NVDA	Stock	0.5588	0.5598	0.5518	0.5545	86855720.0
2008-05-07 14:00:00	NVDA	Stock	0.5546	0.5555	0.5465	0.548	84726280.0
2008-05-07 15:00:00	NVDA	Stock	0.548	0.5512	0.5455	0.5512	126587720.0
2008-05-07 16:00:00	NVDA	Stock	0.5502	0.5577	0.5478	0.5502	3718920.0
2008-05-07 17:00:00	NVDA	Stock	0.5502	0.5502	0.5475	0.5475	282040.0
2008-05-07 18:00:00	NVDA	Stock	0.5475	0.5502	0.5475	0.5502	302640.0
2008-05-07 19:00:00	NVDA	Stock	0.5488	0.5488	0.547	0.5472	134200.0
2008-05-07 08:00:00	AMZN	Stock	3.763	3.8	3.763	3.7995	6000.0
2008-05-07 09:00:00	AMZN	Stock	3.7855	3.832	3.745	3.799	29595160.0
2008-05-07 10:00:00	AMZN	Stock	3.799	3.83	3.7695	3.77	24024560.0
2008-05-07 11:00:00	AMZN	Stock	3.7701	3.78	3.727	3.747	16240100.0
2008-05-07 12:00:00	AMZN	Stock	3.7475	3.7605	3.735	3.7595	9633520.0
2008-05-07 13:00:00	AMZN	Stock	3.7595	3.76	3.703	3.716	13857720.0
2008-05-07 14:00:00	AMZN	Stock	3.716	3.73	3.679	3.698	26495640.0
2008-05-07 15:00:00	AMZN	Stock	3.698	3.698	3.6545	3.6625	42608080.0
2008-05-07 16:00:00	AMZN	Stock	3.666	3.7589	3.65	3.659	4211780.0
2008-05-07 17:00:00	AMZN	Stock	3.66	3.662	3.653	3.653	69940.0
2008-05-07 19:00:00	AMZN	Stock	3.6585	3.6585	3.6535	3.6535	18400.0

> showing 50 of 40,163 rows — these rows as CSV

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