PREVIEW / stock_1hour / 2007-12-31

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-31.parquet
  size:    840 KB
  rows:    41,633
  symbols: 3,282

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-12-31 07:00:00	AAPL	Stock	7.1379	7.1429	7.1379	7.1429	30800.0
2007-12-31 08:00:00	AAPL	Stock	7.1429	7.1696	7.1429	7.15	3454360.0
2007-12-31 09:00:00	AAPL	Stock	7.15	7.1525	7.0704	7.1036	80244472.0
2007-12-31 10:00:00	AAPL	Stock	7.1029	7.1371	7.0921	7.1182	76258084.0
2007-12-31 11:00:00	AAPL	Stock	7.1182	7.1607	7.1089	7.1461	74691372.0
2007-12-31 12:00:00	AAPL	Stock	7.1468	7.1504	7.1	7.1204	63525700.0
2007-12-31 13:00:00	AAPL	Stock	7.12	7.1411	7.1161	7.1196	38371312.0
2007-12-31 14:00:00	AAPL	Stock	7.1186	7.1318	7.1	7.1246	53047708.0
2007-12-31 15:00:00	AAPL	Stock	7.1243	7.1529	7.0625	7.0743	127220072.0
2007-12-31 16:00:00	AAPL	Stock	7.0714	7.1214	7.0696	7.0875	19909512.0
2007-12-31 17:00:00	AAPL	Stock	7.0857	7.0918	7.0821	7.0839	523264.0
2007-12-31 18:00:00	AAPL	Stock	7.0893	7.1439	7.0743	7.09	1993460.0
2007-12-31 19:00:00	AAPL	Stock	7.0896	7.0911	7.0857	7.0893	256060.0
2007-12-31 08:00:00	MSFT	Stock	36.05	36.12	36.05	36.12	1799.0
2007-12-31 09:00:00	MSFT	Stock	36.12	36.12	35.7	35.75	3902855.0
2007-12-31 10:00:00	MSFT	Stock	35.76	35.85	35.57	35.71	4061774.0
2007-12-31 11:00:00	MSFT	Stock	35.72	35.86	35.62	35.75	3407278.0
2007-12-31 12:00:00	MSFT	Stock	35.75	35.79	35.65	35.687	2922343.0
2007-12-31 13:00:00	MSFT	Stock	35.69	35.8	35.61	35.72	2543024.0
2007-12-31 14:00:00	MSFT	Stock	35.72	35.78	35.67	35.75	3096973.0
2007-12-31 15:00:00	MSFT	Stock	35.76	35.82	35.52	35.59	10371120.0
2007-12-31 16:00:00	MSFT	Stock	35.59	35.75	33.59	35.59	5029318.0
2007-12-31 17:00:00	MSFT	Stock	35.59	35.69	35.59	35.69	254879.0
2007-12-31 18:00:00	MSFT	Stock	35.78	35.78	35.48	35.51	533369.0
2007-12-31 19:00:00	MSFT	Stock	35.48	35.48	35.48	35.48	200.0
2007-12-31 09:00:00	NVDA	Stock	0.8662	0.867	0.8575	0.867	24957880.0
2007-12-31 10:00:00	NVDA	Stock	0.867	0.8785	0.861	0.8612	49693160.0
2007-12-31 11:00:00	NVDA	Stock	0.8615	0.865	0.8528	0.86	32815680.0
2007-12-31 12:00:00	NVDA	Stock	0.86	0.862	0.8552	0.8598	22116680.0
2007-12-31 13:00:00	NVDA	Stock	0.8598	0.864	0.859	0.8602	19108840.0
2007-12-31 14:00:00	NVDA	Stock	0.8602	0.863	0.858	0.8618	20248080.0
2007-12-31 15:00:00	NVDA	Stock	0.862	0.862	0.8502	0.852	82014400.0
2007-12-31 16:00:00	NVDA	Stock	0.8505	0.8638	0.848	0.8505	5307240.0
2007-12-31 17:00:00	NVDA	Stock	0.8532	0.8532	0.8532	0.8532	23440.0
2007-12-31 18:00:00	NVDA	Stock	0.8615	0.8615	0.8505	0.8505	2594320.0
2007-12-31 08:00:00	AMZN	Stock	4.738	4.738	4.6825	4.6935	118540.0
2007-12-31 09:00:00	AMZN	Stock	4.6995	4.7055	4.661	4.6755	13479780.0
2007-12-31 10:00:00	AMZN	Stock	4.675	4.6975	4.65	4.6715	14806220.0
2007-12-31 11:00:00	AMZN	Stock	4.671	4.6745	4.6225	4.6605	13339920.0
2007-12-31 12:00:00	AMZN	Stock	4.6605	4.662	4.6265	4.6505	11929720.0
2007-12-31 13:00:00	AMZN	Stock	4.65	4.6595	4.6275	4.634	9781820.0
2007-12-31 14:00:00	AMZN	Stock	4.634	4.6785	4.632	4.672	13105860.0
2007-12-31 15:00:00	AMZN	Stock	4.6715	4.7185	4.6265	4.639	34324580.0
2007-12-31 16:00:00	AMZN	Stock	4.631	4.67	4.6285	4.6695	3663040.0
2007-12-31 17:00:00	AMZN	Stock	4.655	4.6625	4.6325	4.6555	48500.0
2007-12-31 18:00:00	AMZN	Stock	4.658	4.671	4.632	4.671	533840.0
2007-12-31 19:00:00	AMZN	Stock	4.6825	4.6875	4.6825	4.6875	28000.0
2007-12-31 08:00:00	TLT	Stock	92.83	92.83	92.83	92.83	1000.0
2007-12-31 09:00:00	TLT	Stock	92.9	92.95	92.75	92.92	532910.0
2007-12-31 10:00:00	TLT	Stock	92.91	92.99	92.6	92.92	494100.0

> showing 50 of 41,633 rows — these rows as CSV

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