PREVIEW / stock_1hour / 2004-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-06-23.parquet
  size:    506 KB
  rows:    24,007
  symbols: 1,794

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-23 08:00:00	AAPL	Stock	0.5875	0.5893	0.5875	0.5893	156800.0
2004-06-23 09:00:00	AAPL	Stock	0.5848	0.5898	0.5848	0.5882	45416392.0
2004-06-23 10:00:00	AAPL	Stock	0.5884	0.5905	0.5877	0.5891	32870768.0
2004-06-23 11:00:00	AAPL	Stock	0.5889	0.5914	0.5889	0.5902	74008872.0
2004-06-23 12:00:00	AAPL	Stock	0.59	0.5973	0.5896	0.5964	44776256.0
2004-06-23 13:00:00	AAPL	Stock	0.5964	0.5996	0.5961	0.5993	40545064.0
2004-06-23 14:00:00	AAPL	Stock	0.5993	0.6009	0.5968	0.5991	50829856.0
2004-06-23 15:00:00	AAPL	Stock	0.5991	0.6041	0.5986	0.6009	90581120.0
2004-06-23 16:00:00	AAPL	Stock	0.6009	0.6021	0.5971	0.6018	4137896.0
2004-06-23 17:00:00	AAPL	Stock	0.6	0.6	0.598	0.5982	78400.0
2004-06-23 18:00:00	AAPL	Stock	0.598	0.598	0.5979	0.5979	53200.0
2004-06-23 08:00:00	MSFT	Stock	28.23	28.27	28.23	28.25	27700.0
2004-06-23 09:00:00	MSFT	Stock	28.23	28.28	28.12	28.2	6669337.0
2004-06-23 10:00:00	MSFT	Stock	28.201	28.27	28.06	28.09	8434648.0
2004-06-23 11:00:00	MSFT	Stock	28.09	28.15	28.0	28.11	9134964.0
2004-06-23 12:00:00	MSFT	Stock	28.11	28.22	28.1	28.19	6635328.0
2004-06-23 13:00:00	MSFT	Stock	28.19	28.21	28.09	28.111	4335831.0
2004-06-23 14:00:00	MSFT	Stock	28.12	28.22	28.07	28.198	7049916.0
2004-06-23 15:00:00	MSFT	Stock	28.2	28.38	28.19	28.32	13438306.0
2004-06-23 16:00:00	MSFT	Stock	28.31	28.35	28.28	28.34	1075150.0
2004-06-23 17:00:00	MSFT	Stock	28.34	28.35	28.1829	28.3	82100.0
2004-06-23 08:00:00	NVDA	Stock	0.1667	0.1667	0.1667	0.1667	60000.0
2004-06-23 09:00:00	NVDA	Stock	0.1667	0.1675	0.1654	0.1664	37888680.0
2004-06-23 10:00:00	NVDA	Stock	0.1664	0.1675	0.1662	0.167	39791040.0
2004-06-23 11:00:00	NVDA	Stock	0.167	0.1693	0.1667	0.1692	45272040.0
2004-06-23 12:00:00	NVDA	Stock	0.1692	0.1698	0.1686	0.1689	25943280.0
2004-06-23 13:00:00	NVDA	Stock	0.1688	0.1692	0.1683	0.1683	26610120.0
2004-06-23 14:00:00	NVDA	Stock	0.1683	0.1692	0.1678	0.1688	26733000.0
2004-06-23 15:00:00	NVDA	Stock	0.1687	0.1697	0.1686	0.169	54896040.0
2004-06-23 16:00:00	NVDA	Stock	0.169	0.1694	0.1689	0.1693	1996680.0
2004-06-23 09:00:00	AMZN	Stock	2.447	2.4475	2.4175	2.4295	14225700.0
2004-06-23 10:00:00	AMZN	Stock	2.4285	2.478	2.4255	2.4635	24427980.0
2004-06-23 11:00:00	AMZN	Stock	2.463	2.482	2.456	2.48	11779520.0
2004-06-23 12:00:00	AMZN	Stock	2.4805	2.515	2.475	2.51	26364180.0
2004-06-23 13:00:00	AMZN	Stock	2.51	2.532	2.5045	2.5245	18699820.0
2004-06-23 14:00:00	AMZN	Stock	2.5245	2.5435	2.5225	2.5325	19759960.0
2004-06-23 15:00:00	AMZN	Stock	2.532	2.55	2.5315	2.545	29964380.0
2004-06-23 16:00:00	AMZN	Stock	2.545	2.5475	2.538	2.5475	1800380.0
2004-06-23 17:00:00	AMZN	Stock	2.5475	2.5475	2.5405	2.5435	831800.0
2004-06-23 18:00:00	AMZN	Stock	2.543	2.543	2.543	2.543	9000.0
2004-06-23 09:00:00	CL	Stock	29.225	29.365	29.19	29.31	233200.0
2004-06-23 10:00:00	CL	Stock	29.31	29.325	29.225	29.235	611800.0
2004-06-23 11:00:00	CL	Stock	29.245	29.245	29.135	29.225	532200.0
2004-06-23 12:00:00	CL	Stock	29.225	29.225	29.175	29.185	243000.0
2004-06-23 13:00:00	CL	Stock	29.185	29.22	29.18	29.185	135800.0
2004-06-23 14:00:00	CL	Stock	29.18	29.23	29.175	29.225	270200.0
2004-06-23 15:00:00	CL	Stock	29.225	29.25	29.2	29.22	1021600.0
2004-06-23 16:00:00	CL	Stock	29.21	29.21	29.21	29.21	600.0

> showing 48 of 24,007 rows — these rows as CSV

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