PREVIEW / stock_1hour / 2006-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2006/2006-10-10.parquet
  size:    605 KB
  rows:    28,861
  symbols: 2,385

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-10-10 07:00:00	AAPL	Stock	2.6614	2.6618	2.6614	2.6618	47600.0
2006-10-10 08:00:00	AAPL	Stock	2.6643	2.6679	2.6586	2.6621	609700.0
2006-10-10 09:00:00	AAPL	Stock	2.6636	2.6668	2.6425	2.6471	84172900.0
2006-10-10 10:00:00	AAPL	Stock	2.6479	2.6621	2.6457	2.6525	73092264.0
2006-10-10 11:00:00	AAPL	Stock	2.6529	2.66	2.6421	2.6443	61787012.0
2006-10-10 12:00:00	AAPL	Stock	2.6446	2.6482	2.6239	2.6304	88854164.0
2006-10-10 13:00:00	AAPL	Stock	2.6307	2.6364	2.61	2.6196	71195124.0
2006-10-10 14:00:00	AAPL	Stock	2.6197	2.6354	2.6104	2.6307	67516764.0
2006-10-10 15:00:00	AAPL	Stock	2.63	2.6361	2.6229	2.6354	72760940.0
2006-10-10 16:00:00	AAPL	Stock	2.6357	2.6393	2.6325	2.6339	3410316.0
2006-10-10 17:00:00	AAPL	Stock	2.6332	2.6339	2.6325	2.6329	244748.0
2006-10-10 18:00:00	AAPL	Stock	2.6336	2.6346	2.6325	2.6343	123620.0
2006-10-10 19:00:00	AAPL	Stock	2.6343	2.6357	2.6343	2.6357	8316.0
2006-10-10 07:00:00	MSFT	Stock	27.69	27.69	27.69	27.69	200.0
2006-10-10 08:00:00	MSFT	Stock	27.72	27.72	27.65	27.67	41760.0
2006-10-10 09:00:00	MSFT	Stock	27.67	27.75	27.58	27.58	4558763.0
2006-10-10 10:00:00	MSFT	Stock	27.59	27.63	27.51	27.6	5893224.0
2006-10-10 11:00:00	MSFT	Stock	27.6	27.7	27.55	27.57	3896061.0
2006-10-10 12:00:00	MSFT	Stock	27.57	27.59	27.51	27.53	2312094.0
2006-10-10 13:00:00	MSFT	Stock	27.53	27.55	27.44	27.55	3694299.0
2006-10-10 14:00:00	MSFT	Stock	27.55	27.65	27.5	27.62	4443318.0
2006-10-10 15:00:00	MSFT	Stock	27.62	27.69	27.5	27.67	8451698.0
2006-10-10 16:00:00	MSFT	Stock	27.68	27.68	27.6	27.64	84980.0
2006-10-10 17:00:00	MSFT	Stock	27.64	27.65	27.64	27.64	2500.0
2006-10-10 18:00:00	MSFT	Stock	27.67	27.67	27.64	27.64	1066.0
2006-10-10 19:00:00	MSFT	Stock	27.65	27.65	27.65	27.65	100.0
2006-10-10 08:00:00	NVDA	Stock	0.5465	0.5577	0.5465	0.547	74100.0
2006-10-10 09:00:00	NVDA	Stock	0.547	0.548	0.533	0.5395	113557620.0
2006-10-10 10:00:00	NVDA	Stock	0.5392	0.5443	0.5355	0.5418	115026600.0
2006-10-10 11:00:00	NVDA	Stock	0.5417	0.5475	0.5415	0.544	71156940.0
2006-10-10 12:00:00	NVDA	Stock	0.5437	0.5458	0.5307	0.5322	103096860.0
2006-10-10 13:00:00	NVDA	Stock	0.5318	0.5353	0.53	0.5328	69083280.0
2006-10-10 14:00:00	NVDA	Stock	0.5328	0.5345	0.5303	0.5318	54884100.0
2006-10-10 15:00:00	NVDA	Stock	0.532	0.5367	0.531	0.5362	75764580.0
2006-10-10 16:00:00	NVDA	Stock	0.5362	0.5372	0.5362	0.5362	222480.0
2006-10-10 17:00:00	NVDA	Stock	0.537	0.5372	0.537	0.5372	60000.0
2006-10-10 18:00:00	NVDA	Stock	0.5362	0.5372	0.5362	0.5362	84000.0
2006-10-10 19:00:00	NVDA	Stock	0.5367	0.5367	0.5367	0.5367	12000.0
2006-10-10 08:00:00	AMZN	Stock	1.672	1.672	1.67	1.67	34000.0
2006-10-10 09:00:00	AMZN	Stock	1.67	1.67	1.6575	1.66	9766160.0
2006-10-10 10:00:00	AMZN	Stock	1.6605	1.678	1.6555	1.6745	16301560.0
2006-10-10 11:00:00	AMZN	Stock	1.6745	1.679	1.6605	1.6635	15647680.0
2006-10-10 12:00:00	AMZN	Stock	1.6631	1.67	1.639	1.64	13778700.0
2006-10-10 13:00:00	AMZN	Stock	1.6405	1.6425	1.6285	1.6295	15159600.0
2006-10-10 14:00:00	AMZN	Stock	1.6295	1.639	1.6255	1.6285	16124360.0
2006-10-10 15:00:00	AMZN	Stock	1.628	1.6325	1.6245	1.6315	32463060.0
2006-10-10 16:00:00	AMZN	Stock	1.6305	1.6315	1.6275	1.63	1957000.0
2006-10-10 17:00:00	AMZN	Stock	1.626	1.626	1.626	1.626	10000.0
2006-10-10 18:00:00	AMZN	Stock	1.626	1.6305	1.626	1.6305	241000.0
2006-10-10 19:00:00	AMZN	Stock	1.6305	1.6305	1.6305	1.6305	19000.0

> showing 50 of 28,861 rows — these rows as CSV

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