PREVIEW / stock_1hour / 2006-09-14

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-09-14.parquet
  size:    628 KB
  rows:    29,975
  symbols: 2,363

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
2006-09-14 06:00:00	AAPL	Stock	2.6668	2.6761	2.6668	2.6761	16800.0
2006-09-14 07:00:00	AAPL	Stock	2.6586	2.6661	2.6571	2.6607	271124.0
2006-09-14 08:00:00	AAPL	Stock	2.6618	2.6618	2.6361	2.6375	6318928.0
2006-09-14 09:00:00	AAPL	Stock	2.6361	2.6454	2.6236	2.6364	110623464.0
2006-09-14 10:00:00	AAPL	Stock	2.6367	2.665	2.6321	2.6593	195544888.0
2006-09-14 11:00:00	AAPL	Stock	2.6593	2.6668	2.6479	2.6567	130080804.0
2006-09-14 12:00:00	AAPL	Stock	2.6568	2.6607	2.6432	2.6525	75898256.0
2006-09-14 13:00:00	AAPL	Stock	2.6525	2.6611	2.645	2.6568	80803884.0
2006-09-14 14:00:00	AAPL	Stock	2.6568	2.6586	2.6461	2.6525	70226408.0
2006-09-14 15:00:00	AAPL	Stock	2.6525	2.6557	2.64	2.65	120845004.0
2006-09-14 16:00:00	AAPL	Stock	2.65	2.6518	2.6482	2.6507	1717324.0
2006-09-14 17:00:00	AAPL	Stock	2.6489	2.6518	2.6429	2.6486	361340.0
2006-09-14 18:00:00	AAPL	Stock	2.6486	2.6486	2.6479	2.6482	61600.0
2006-09-14 07:00:00	MSFT	Stock	25.98	26.06	25.98	26.06	3696.0
2006-09-14 08:00:00	MSFT	Stock	26.01	26.14	26.01	26.1	77329.0
2006-09-14 09:00:00	MSFT	Stock	26.09	26.17	25.9	26.17	14018915.0
2006-09-14 10:00:00	MSFT	Stock	26.16	26.41	26.15	26.31	17266124.0
2006-09-14 11:00:00	MSFT	Stock	26.31	26.35	26.18	26.31	7269355.0
2006-09-14 12:00:00	MSFT	Stock	26.32	26.5	26.3	26.42	5343462.0
2006-09-14 13:00:00	MSFT	Stock	26.42	26.42	26.3	26.388	6767581.0
2006-09-14 14:00:00	MSFT	Stock	26.39	26.42	26.32	26.34	7861095.0
2006-09-14 15:00:00	MSFT	Stock	26.34	26.39	26.3	26.35	12913618.0
2006-09-14 16:00:00	MSFT	Stock	26.35	26.38	26.136	26.38	142588.0
2006-09-14 17:00:00	MSFT	Stock	26.35	26.37	26.28	26.33	21442.0
2006-09-14 18:00:00	MSFT	Stock	26.36	26.37	26.36	26.37	1325.0
2006-09-14 08:00:00	NVDA	Stock	0.485	0.485	0.485	0.485	30000.0
2006-09-14 09:00:00	NVDA	Stock	0.4833	0.4892	0.4768	0.4872	50599320.0
2006-09-14 10:00:00	NVDA	Stock	0.4872	0.4907	0.4847	0.4893	71516040.0
2006-09-14 11:00:00	NVDA	Stock	0.4895	0.4915	0.4875	0.4897	62062620.0
2006-09-14 12:00:00	NVDA	Stock	0.4897	0.4917	0.4872	0.489	49982580.0
2006-09-14 13:00:00	NVDA	Stock	0.489	0.489	0.4857	0.4863	36125760.0
2006-09-14 14:00:00	NVDA	Stock	0.4865	0.487	0.4825	0.483	51453180.0
2006-09-14 15:00:00	NVDA	Stock	0.483	0.4843	0.4795	0.4825	76696740.0
2006-09-14 16:00:00	NVDA	Stock	0.4825	0.4832	0.4825	0.4832	214980.0
2006-09-14 17:00:00	NVDA	Stock	0.4832	0.4832	0.4832	0.4832	42000.0
2006-09-14 18:00:00	NVDA	Stock	0.48	0.48	0.48	0.48	187560.0
2006-09-14 09:00:00	AMZN	Stock	1.5795	1.58	1.559	1.568	9792400.0
2006-09-14 10:00:00	AMZN	Stock	1.568	1.5815	1.566	1.5805	11501120.0
2006-09-14 11:00:00	AMZN	Stock	1.5805	1.589	1.5765	1.5845	7266480.0
2006-09-14 12:00:00	AMZN	Stock	1.5845	1.5935	1.58	1.588	5748680.0
2006-09-14 13:00:00	AMZN	Stock	1.588	1.588	1.575	1.582	7223440.0
2006-09-14 14:00:00	AMZN	Stock	1.582	1.5845	1.5785	1.5795	5797900.0
2006-09-14 15:00:00	AMZN	Stock	1.579	1.5845	1.574	1.5825	13200080.0
2006-09-14 16:00:00	AMZN	Stock	1.5825	1.5845	1.5815	1.584	64620.0
2006-09-14 17:00:00	AMZN	Stock	1.5825	1.5825	1.5825	1.5825	14000.0
2006-09-14 09:00:00	CL	Stock	30.4	30.49	30.29	30.4	397400.0
2006-09-14 10:00:00	CL	Stock	30.4	30.5	30.375	30.455	635400.0
2006-09-14 11:00:00	CL	Stock	30.46	30.615	30.42	30.59	545400.0
2006-09-14 12:00:00	CL	Stock	30.6	30.74	30.525	30.73	388600.0
2006-09-14 13:00:00	CL	Stock	30.73	30.81	30.7	30.81	432200.0

> showing 50 of 29,975 rows — these rows as CSV

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