PREVIEW / stock_1hour / 2003-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-01.parquet
  size:    467 KB
  rows:    22,160
  symbols: 1,598

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
2003-08-01 08:00:00	AAPL	Stock	0.375	0.3766	0.375	0.375	543200.0
2003-08-01 09:00:00	AAPL	Stock	0.3757	0.3802	0.3738	0.3752	21603960.0
2003-08-01 10:00:00	AAPL	Stock	0.3752	0.3757	0.3691	0.372	26584040.0
2003-08-01 11:00:00	AAPL	Stock	0.3718	0.3759	0.3702	0.3732	16586248.0
2003-08-01 12:00:00	AAPL	Stock	0.3734	0.3743	0.3707	0.3723	14959952.0
2003-08-01 13:00:00	AAPL	Stock	0.3723	0.3741	0.3709	0.3714	12149424.0
2003-08-01 14:00:00	AAPL	Stock	0.3716	0.3739	0.3702	0.372	15955800.0
2003-08-01 15:00:00	AAPL	Stock	0.372	0.3734	0.3689	0.3696	20862352.0
2003-08-01 16:00:00	AAPL	Stock	0.3696	0.3704	0.3686	0.3699	3841600.0
2003-08-01 17:00:00	AAPL	Stock	0.3703	0.3703	0.3703	0.3703	1030400.0
2003-08-01 18:00:00	AAPL	Stock	0.3696	0.3696	0.3696	0.3696	61600.0
2003-08-01 08:00:00	MSFT	Stock	26.5	26.58	26.339	26.4	188862.0
2003-08-01 09:00:00	MSFT	Stock	26.448	26.51	26.27	26.37	5918250.0
2003-08-01 10:00:00	MSFT	Stock	26.37	26.41	26.22	26.34	9101348.0
2003-08-01 11:00:00	MSFT	Stock	26.34	26.37	26.243	26.28	4592630.0
2003-08-01 12:00:00	MSFT	Stock	26.27	26.36	26.21	26.33	3153484.0
2003-08-01 13:00:00	MSFT	Stock	26.32	26.41	26.26	26.308	3120190.0
2003-08-01 14:00:00	MSFT	Stock	26.3	26.33	26.21	26.25	4045953.0
2003-08-01 15:00:00	MSFT	Stock	26.25	26.27	26.12	26.16	6019723.0
2003-08-01 16:00:00	MSFT	Stock	26.18	26.26	26.12	26.2	990259.0
2003-08-01 17:00:00	MSFT	Stock	26.21	26.21	26.19	26.2	553775.0
2003-08-01 18:00:00	MSFT	Stock	26.2	26.2	26.2	26.2	2800.0
2003-08-01 08:00:00	NVDA	Stock	0.1593	0.1604	0.1583	0.159	1368000.0
2003-08-01 09:00:00	NVDA	Stock	0.1591	0.1614	0.1576	0.1601	99905760.0
2003-08-01 10:00:00	NVDA	Stock	0.1599	0.1621	0.1587	0.162	136477920.0
2003-08-01 11:00:00	NVDA	Stock	0.1619	0.1647	0.1614	0.1637	159491880.0
2003-08-01 12:00:00	NVDA	Stock	0.1639	0.1646	0.162	0.164	58038480.0
2003-08-01 13:00:00	NVDA	Stock	0.1639	0.165	0.1634	0.1645	49796400.0
2003-08-01 14:00:00	NVDA	Stock	0.1645	0.1647	0.1627	0.1647	60692160.0
2003-08-01 15:00:00	NVDA	Stock	0.1647	0.1657	0.1636	0.164	98100720.0
2003-08-01 16:00:00	NVDA	Stock	0.164	0.165	0.1639	0.1644	10521000.0
2003-08-01 17:00:00	NVDA	Stock	0.1643	0.1646	0.1623	0.1646	1440000.0
2003-08-01 08:00:00	AMZN	Stock	2.089	2.0955	2.069	2.069	295220.0
2003-08-01 09:00:00	AMZN	Stock	2.0655	2.085	2.051	2.059	17081340.0
2003-08-01 10:00:00	AMZN	Stock	2.059	2.065	2.03	2.0415	28219540.0
2003-08-01 11:00:00	AMZN	Stock	2.0415	2.0525	2.036	2.0405	11899160.0
2003-08-01 12:00:00	AMZN	Stock	2.041	2.0455	2.03	2.032	15636820.0
2003-08-01 13:00:00	AMZN	Stock	2.032	2.0335	2.0125	2.0195	28800940.0
2003-08-01 14:00:00	AMZN	Stock	2.02	2.025	2.0075	2.0205	20123540.0
2003-08-01 15:00:00	AMZN	Stock	2.02	2.0215	1.989	2.0	35623320.0
2003-08-01 16:00:00	AMZN	Stock	2.0	2.0055	1.9975	1.9996	1146840.0
2003-08-01 17:00:00	AMZN	Stock	1.9996	2.0015	1.9959	2.001	778800.0
2003-08-01 18:00:00	AMZN	Stock	2.0015	2.0015	2.0015	2.0015	2000.0
2003-08-01 09:00:00	CL	Stock	27.04	27.3	26.8	27.115	361000.0
2003-08-01 10:00:00	CL	Stock	27.125	27.275	27.105	27.16	508800.0
2003-08-01 11:00:00	CL	Stock	27.15	27.21	27.13	27.175	278200.0
2003-08-01 12:00:00	CL	Stock	27.17	27.28	27.13	27.265	261800.0
2003-08-01 13:00:00	CL	Stock	27.27	27.3	27.135	27.18	207000.0
2003-08-01 14:00:00	CL	Stock	27.18	27.185	27.115	27.14	364600.0
2003-08-01 15:00:00	CL	Stock	27.14	27.165	27.09	27.135	681600.0

> showing 50 of 22,160 rows — these rows as CSV

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