PREVIEW / stock_1hour / 2004-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-15.parquet
  size:    514 KB
  rows:    24,072
  symbols: 1,738

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-03-15 08:00:00	AAPL	Stock	0.4916	0.4916	0.4866	0.4866	279944.0
2004-03-15 09:00:00	AAPL	Stock	0.4866	0.4884	0.4804	0.4836	55535648.0
2004-03-15 10:00:00	AAPL	Stock	0.4839	0.4857	0.4755	0.4757	70576296.0
2004-03-15 11:00:00	AAPL	Stock	0.4757	0.4788	0.4738	0.4759	59461584.0
2004-03-15 12:00:00	AAPL	Stock	0.4759	0.4777	0.4713	0.4745	71224216.0
2004-03-15 13:00:00	AAPL	Stock	0.4745	0.4748	0.4709	0.4732	43823752.0
2004-03-15 14:00:00	AAPL	Stock	0.4732	0.475	0.4705	0.4714	57280440.0
2004-03-15 15:00:00	AAPL	Stock	0.4714	0.4734	0.4689	0.4727	78001000.0
2004-03-15 16:00:00	AAPL	Stock	0.4727	0.4729	0.4705	0.4713	4690560.0
2004-03-15 17:00:00	AAPL	Stock	0.4713	0.4723	0.4713	0.4723	27944.0
2004-03-15 18:00:00	AAPL	Stock	0.4725	0.4725	0.4711	0.4711	792400.0
2004-03-15 08:00:00	MSFT	Stock	25.3	25.59	25.25	25.46	198978.0
2004-03-15 09:00:00	MSFT	Stock	25.5	25.5	25.24	25.26	6867111.0
2004-03-15 10:00:00	MSFT	Stock	25.26	25.29	25.14	25.18	8887256.0
2004-03-15 11:00:00	MSFT	Stock	25.18	25.231	25.11	25.14	6156235.0
2004-03-15 12:00:00	MSFT	Stock	25.14	25.23	25.1	25.17	7095113.0
2004-03-15 13:00:00	MSFT	Stock	25.18	25.38	25.12	25.36	10664409.0
2004-03-15 14:00:00	MSFT	Stock	25.35	25.43	25.16	25.33	10923579.0
2004-03-15 15:00:00	MSFT	Stock	25.33	25.37	25.16	25.2	12795718.0
2004-03-15 16:00:00	MSFT	Stock	25.2	25.245	25.16	25.17	1477589.0
2004-03-15 17:00:00	MSFT	Stock	25.19	25.19	25.16	25.19	2048.0
2004-03-15 18:00:00	MSFT	Stock	25.19	25.2729	25.19	25.19	6300.0
2004-03-15 08:00:00	NVDA	Stock	0.1787	0.1787	0.177	0.177	108000.0
2004-03-15 09:00:00	NVDA	Stock	0.1768	0.177	0.1754	0.1757	20087760.0
2004-03-15 10:00:00	NVDA	Stock	0.1757	0.1757	0.1726	0.1726	64517520.0
2004-03-15 11:00:00	NVDA	Stock	0.1726	0.1746	0.1721	0.1734	89611680.0
2004-03-15 12:00:00	NVDA	Stock	0.1737	0.1751	0.1729	0.1745	60496920.0
2004-03-15 13:00:00	NVDA	Stock	0.1745	0.1746	0.1726	0.1737	36282240.0
2004-03-15 14:00:00	NVDA	Stock	0.1737	0.1752	0.1733	0.1738	56155560.0
2004-03-15 15:00:00	NVDA	Stock	0.1737	0.1752	0.1727	0.1727	78294720.0
2004-03-15 16:00:00	NVDA	Stock	0.1732	0.1743	0.1726	0.1735	3237480.0
2004-03-15 08:00:00	AMZN	Stock	2.1125	2.1245	2.1125	2.1145	65880.0
2004-03-15 09:00:00	AMZN	Stock	2.1145	2.14	2.086	2.0945	16751840.0
2004-03-15 10:00:00	AMZN	Stock	2.0945	2.0945	2.053	2.057	26450640.0
2004-03-15 11:00:00	AMZN	Stock	2.057	2.079	2.0545	2.072	21996240.0
2004-03-15 12:00:00	AMZN	Stock	2.0725	2.0765	2.063	2.074	12672520.0
2004-03-15 13:00:00	AMZN	Stock	2.074	2.075	2.056	2.0605	8943660.0
2004-03-15 14:00:00	AMZN	Stock	2.0605	2.0825	2.057	2.0656	16289640.0
2004-03-15 15:00:00	AMZN	Stock	2.0665	2.0735	2.046	2.059	24478520.0
2004-03-15 16:00:00	AMZN	Stock	2.057	2.0605	2.054	2.0575	1020960.0
2004-03-15 17:00:00	AMZN	Stock	2.0575	2.0575	2.054	2.0565	288440.0
2004-03-15 18:00:00	AMZN	Stock	2.0565	2.0565	2.0565	2.0565	10000.0
2004-03-15 09:00:00	CL	Stock	27.475	27.475	27.34	27.34	263800.0
2004-03-15 10:00:00	CL	Stock	27.345	27.415	27.26	27.345	409800.0
2004-03-15 11:00:00	CL	Stock	27.345	27.365	27.285	27.325	328000.0
2004-03-15 12:00:00	CL	Stock	27.325	27.355	27.25	27.325	500800.0
2004-03-15 13:00:00	CL	Stock	27.345	27.345	27.26	27.31	462000.0
2004-03-15 14:00:00	CL	Stock	27.32	27.345	27.185	27.215	467200.0
2004-03-15 15:00:00	CL	Stock	27.21	27.325	27.21	27.23	610000.0
2004-03-15 16:00:00	CL	Stock	27.24	27.241	27.24	27.24	15800.0

> showing 50 of 24,072 rows — these rows as CSV

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