PREVIEW / stock_1hour / 2004-06-16

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-16.parquet
  size:    490 KB
  rows:    23,074
  symbols: 1,786

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
2004-06-16 08:00:00	AAPL	Stock	0.5507	0.5516	0.5489	0.5489	61600.0
2004-06-16 09:00:00	AAPL	Stock	0.5479	0.5509	0.5452	0.5505	20140344.0
2004-06-16 10:00:00	AAPL	Stock	0.5505	0.562	0.5504	0.5616	90453104.0
2004-06-16 11:00:00	AAPL	Stock	0.5618	0.5638	0.5584	0.5607	80580528.0
2004-06-16 12:00:00	AAPL	Stock	0.5609	0.5657	0.5598	0.565	40227992.0
2004-06-16 13:00:00	AAPL	Stock	0.5652	0.5695	0.5627	0.5668	76116208.0
2004-06-16 14:00:00	AAPL	Stock	0.5668	0.5746	0.5654	0.5736	97083728.0
2004-06-16 15:00:00	AAPL	Stock	0.5736	0.595	0.5736	0.5839	365384768.0
2004-06-16 16:00:00	AAPL	Stock	0.5846	0.5912	0.565	0.5846	13894832.0
2004-06-16 17:00:00	AAPL	Stock	0.5832	0.5843	0.583	0.5832	104720.0
2004-06-16 18:00:00	AAPL	Stock	0.5832	0.5832	0.5832	0.5832	5600.0
2004-06-16 08:00:00	MSFT	Stock	27.31	27.4	27.31	27.34	34773.0
2004-06-16 09:00:00	MSFT	Stock	27.32	27.41	27.21	27.27	8792058.0
2004-06-16 10:00:00	MSFT	Stock	27.27	27.32	27.22	27.2316	11188155.0
2004-06-16 11:00:00	MSFT	Stock	27.23	27.27	27.15	27.26	10666854.0
2004-06-16 12:00:00	MSFT	Stock	27.26	27.27	27.19	27.25	5340005.0
2004-06-16 13:00:00	MSFT	Stock	27.24	27.26	27.19	27.23	4106858.0
2004-06-16 14:00:00	MSFT	Stock	27.22	27.39	27.22	27.36	9829134.0
2004-06-16 15:00:00	MSFT	Stock	27.37	27.5	27.29	27.33	12473119.0
2004-06-16 16:00:00	MSFT	Stock	27.32	27.4237	27.26	27.28	3826502.0
2004-06-16 17:00:00	MSFT	Stock	27.27	27.32	27.26	27.27	25447.0
2004-06-16 18:00:00	MSFT	Stock	27.27	27.27	27.26	27.26	3376.0
2004-06-16 09:00:00	NVDA	Stock	0.1708	0.1708	0.1683	0.1689	35602920.0
2004-06-16 10:00:00	NVDA	Stock	0.1689	0.171	0.1688	0.1705	55779600.0
2004-06-16 11:00:00	NVDA	Stock	0.1705	0.1706	0.1687	0.1692	18869640.0
2004-06-16 12:00:00	NVDA	Stock	0.1692	0.1692	0.1675	0.1681	38997720.0
2004-06-16 13:00:00	NVDA	Stock	0.1681	0.1682	0.1674	0.1679	12524760.0
2004-06-16 14:00:00	NVDA	Stock	0.1677	0.1686	0.1673	0.1678	25781280.0
2004-06-16 15:00:00	NVDA	Stock	0.1677	0.1684	0.1671	0.168	53016360.0
2004-06-16 16:00:00	NVDA	Stock	0.168	0.1681	0.1677	0.1677	5662080.0
2004-06-16 17:00:00	NVDA	Stock	0.1675	0.1675	0.1675	0.1675	108000.0
2004-06-16 08:00:00	AMZN	Stock	2.5175	2.5175	2.5175	2.5175	4000.0
2004-06-16 09:00:00	AMZN	Stock	2.5095	2.516	2.4955	2.511	11335700.0
2004-06-16 10:00:00	AMZN	Stock	2.51	2.5215	2.5015	2.52	17912140.0
2004-06-16 11:00:00	AMZN	Stock	2.52	2.5215	2.5135	2.518	8486980.0
2004-06-16 12:00:00	AMZN	Stock	2.5195	2.528	2.514	2.525	5352700.0
2004-06-16 13:00:00	AMZN	Stock	2.525	2.5295	2.5205	2.5255	7901460.0
2004-06-16 14:00:00	AMZN	Stock	2.5255	2.5375	2.525	2.5345	9481500.0
2004-06-16 15:00:00	AMZN	Stock	2.534	2.5355	2.5225	2.5255	13391840.0
2004-06-16 16:00:00	AMZN	Stock	2.527	2.5285	2.5235	2.527	2918840.0
2004-06-16 17:00:00	AMZN	Stock	2.525	2.525	2.5175	2.5175	315600.0
2004-06-16 09:00:00	CL	Stock	29.125	29.215	29.09	29.12	220200.0
2004-06-16 10:00:00	CL	Stock	29.12	29.24	29.105	29.135	380000.0
2004-06-16 11:00:00	CL	Stock	29.135	29.19	29.12	29.165	311600.0
2004-06-16 12:00:00	CL	Stock	29.165	29.205	29.165	29.17	143600.0
2004-06-16 13:00:00	CL	Stock	29.175	29.235	29.155	29.22	184600.0
2004-06-16 14:00:00	CL	Stock	29.21	29.25	29.175	29.2	217600.0
2004-06-16 15:00:00	CL	Stock	29.195	29.25	29.185	29.23	667800.0
2004-06-16 16:00:00	CL	Stock	29.235	29.235	29.235	29.235	20600.0

> showing 49 of 23,074 rows — these rows as CSV

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