PREVIEW / stock_1hour / 2008-03-28

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-28.parquet
  size:    797 KB
  rows:    39,755
  symbols: 3,280

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-03-28 04:00:00	AAPL	Stock	5.0393	5.0393	5.0393	5.0393	11200.0
2008-03-28 05:00:00	AAPL	Stock	5.0761	5.0761	5.0761	5.0761	14000.0
2008-03-28 06:00:00	AAPL	Stock	5.0818	5.0818	5.0393	5.0411	113960.0
2008-03-28 07:00:00	AAPL	Stock	5.08	5.0964	5.0607	5.0807	313740.0
2008-03-28 08:00:00	AAPL	Stock	5.0821	5.0893	5.0614	5.0668	4422488.0
2008-03-28 09:00:00	AAPL	Stock	5.0661	5.125	5.0482	5.1157	134584968.0
2008-03-28 10:00:00	AAPL	Stock	5.1154	5.1421	5.0989	5.1136	137616920.0
2008-03-28 11:00:00	AAPL	Stock	5.1136	5.1661	5.1082	5.1565	103516028.0
2008-03-28 12:00:00	AAPL	Stock	5.1561	5.1586	5.1279	5.1389	66295656.0
2008-03-28 13:00:00	AAPL	Stock	5.1386	5.1532	5.1179	5.1296	63658140.0
2008-03-28 14:00:00	AAPL	Stock	5.1296	5.1411	5.1004	5.1293	72628388.0
2008-03-28 15:00:00	AAPL	Stock	5.1289	5.1318	5.0793	5.1079	108845212.0
2008-03-28 16:00:00	AAPL	Stock	5.1036	5.1246	5.1004	5.1164	12030676.0
2008-03-28 17:00:00	AAPL	Stock	5.1168	5.1186	5.1071	5.1121	986832.0
2008-03-28 18:00:00	AAPL	Stock	5.1125	5.1214	5.1075	5.1179	355656.0
2008-03-28 19:00:00	AAPL	Stock	5.1171	5.1236	5.115	5.1196	495096.0
2008-03-28 06:00:00	MSFT	Stock	28.3	28.3	28.3	28.3	100.0
2008-03-28 07:00:00	MSFT	Stock	28.37	28.37	28.27	28.27	1000.0
2008-03-28 08:00:00	MSFT	Stock	28.28	28.28	28.05	28.2	528330.0
2008-03-28 09:00:00	MSFT	Stock	28.2	28.43	28.12	28.36	4783038.0
2008-03-28 10:00:00	MSFT	Stock	28.37	28.42	28.22	28.28	6926133.0
2008-03-28 11:00:00	MSFT	Stock	28.28	28.38	28.25	28.34	4069882.0
2008-03-28 12:00:00	MSFT	Stock	28.34	28.39	28.26	28.32	2567142.0
2008-03-28 13:00:00	MSFT	Stock	28.32	28.33	28.16	28.19	3914075.0
2008-03-28 14:00:00	MSFT	Stock	28.18	28.2	27.83	27.98	7952947.0
2008-03-28 15:00:00	MSFT	Stock	27.98	28.02	27.85	27.9	9717823.0
2008-03-28 16:00:00	MSFT	Stock	27.9	28.166	27.9	27.91	7075399.0
2008-03-28 17:00:00	MSFT	Stock	27.93	27.97	27.91	27.91	48597.0
2008-03-28 18:00:00	MSFT	Stock	27.97	27.97	27.9	27.9	9947.0
2008-03-28 19:00:00	MSFT	Stock	27.9	27.95	27.9	27.92	8268.0
2008-03-28 08:00:00	NVDA	Stock	0.4938	0.4938	0.4898	0.4898	88000.0
2008-03-28 09:00:00	NVDA	Stock	0.4912	0.4995	0.4885	0.497	51218200.0
2008-03-28 10:00:00	NVDA	Stock	0.4965	0.501	0.4963	0.498	107034240.0
2008-03-28 11:00:00	NVDA	Stock	0.498	0.5048	0.4978	0.5018	68485240.0
2008-03-28 12:00:00	NVDA	Stock	0.5018	0.5025	0.4955	0.4975	59119240.0
2008-03-28 13:00:00	NVDA	Stock	0.4972	0.499	0.4923	0.498	69022440.0
2008-03-28 14:00:00	NVDA	Stock	0.4978	0.5028	0.496	0.4998	94665640.0
2008-03-28 15:00:00	NVDA	Stock	0.4998	0.5	0.492	0.4932	102315760.0
2008-03-28 16:00:00	NVDA	Stock	0.4932	0.498	0.4902	0.4923	2261000.0
2008-03-28 17:00:00	NVDA	Stock	0.492	0.492	0.492	0.492	48000.0
2008-03-28 18:00:00	NVDA	Stock	0.4972	0.4972	0.4972	0.4972	4000.0
2008-03-28 08:00:00	AMZN	Stock	3.54	3.565	3.5275	3.5275	1753580.0
2008-03-28 09:00:00	AMZN	Stock	3.541	3.6105	3.524	3.5895	18424400.0
2008-03-28 10:00:00	AMZN	Stock	3.5892	3.6015	3.5595	3.589	16537620.0
2008-03-28 11:00:00	AMZN	Stock	3.587	3.5915	3.5605	3.5648	8463360.0
2008-03-28 12:00:00	AMZN	Stock	3.5648	3.5675	3.5265	3.531	7851840.0
2008-03-28 13:00:00	AMZN	Stock	3.53	3.54	3.5095	3.514	7886420.0
2008-03-28 14:00:00	AMZN	Stock	3.514	3.5265	3.491	3.5145	13009680.0
2008-03-28 15:00:00	AMZN	Stock	3.5145	3.5145	3.463	3.487	27937420.0
2008-03-28 16:00:00	AMZN	Stock	3.487	3.5485	3.483	3.497	1487420.0

> showing 50 of 39,755 rows — these rows as CSV

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