PREVIEW / stock_1hour / 2004-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-03-19.parquet
  size:    511 KB
  rows:    23,993
  symbols: 1,742

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-19 08:00:00	AAPL	Stock	0.4588	0.4711	0.4586	0.4589	1870400.0
2004-03-19 09:00:00	AAPL	Stock	0.4589	0.4621	0.4564	0.462	27784792.0
2004-03-19 10:00:00	AAPL	Stock	0.462	0.4673	0.458	0.4654	53409216.0
2004-03-19 11:00:00	AAPL	Stock	0.4654	0.4723	0.4643	0.4677	74797296.0
2004-03-19 12:00:00	AAPL	Stock	0.4677	0.4679	0.4648	0.4657	18581976.0
2004-03-19 13:00:00	AAPL	Stock	0.4657	0.467	0.4641	0.4657	30932944.0
2004-03-19 14:00:00	AAPL	Stock	0.4657	0.4664	0.4625	0.4636	53377184.0
2004-03-19 15:00:00	AAPL	Stock	0.4634	0.4643	0.4598	0.4611	85581664.0
2004-03-19 16:00:00	AAPL	Stock	0.4611	0.4643	0.4603	0.4618	7698096.0
2004-03-19 18:00:00	AAPL	Stock	0.4619	0.4619	0.4616	0.4616	3108112.0
2004-03-19 08:00:00	MSFT	Stock	24.96	25.01	24.95	24.98	82244.0
2004-03-19 09:00:00	MSFT	Stock	24.96	24.96	24.71	24.74	11870565.0
2004-03-19 10:00:00	MSFT	Stock	24.73	24.791	24.66	24.79	15795867.0
2004-03-19 11:00:00	MSFT	Stock	24.79	24.9	24.75	24.86	10498550.0
2004-03-19 12:00:00	MSFT	Stock	24.85	24.88	24.79	24.879	6308118.0
2004-03-19 13:00:00	MSFT	Stock	24.88	24.94	24.86	24.87	8771362.0
2004-03-19 14:00:00	MSFT	Stock	24.87	24.91	24.84	24.85	6429970.0
2004-03-19 15:00:00	MSFT	Stock	24.85	24.86	24.61	24.62	15437862.0
2004-03-19 16:00:00	MSFT	Stock	24.61	24.655	24.56	24.56	1183034.0
2004-03-19 17:00:00	MSFT	Stock	24.57	24.61	24.55	24.6	49105.0
2004-03-19 18:00:00	MSFT	Stock	24.57	24.6225	24.55	24.56	384255.0
2004-03-19 09:00:00	NVDA	Stock	0.1867	0.1869	0.1839	0.1854	64127160.0
2004-03-19 10:00:00	NVDA	Stock	0.1854	0.1872	0.1847	0.1871	53210520.0
2004-03-19 11:00:00	NVDA	Stock	0.1871	0.1878	0.1867	0.1867	45828720.0
2004-03-19 12:00:00	NVDA	Stock	0.1867	0.1875	0.1866	0.1875	35133840.0
2004-03-19 13:00:00	NVDA	Stock	0.1875	0.1878	0.1837	0.1862	85971240.0
2004-03-19 14:00:00	NVDA	Stock	0.1862	0.1862	0.1849	0.1851	26917680.0
2004-03-19 15:00:00	NVDA	Stock	0.1852	0.1862	0.1842	0.1848	118927200.0
2004-03-19 16:00:00	NVDA	Stock	0.1847	0.1849	0.1834	0.1845	3089280.0
2004-03-19 18:00:00	NVDA	Stock	0.1845	0.1849	0.1845	0.1847	1124400.0
2004-03-19 08:00:00	AMZN	Stock	2.155	2.155	2.1525	2.1525	22000.0
2004-03-19 09:00:00	AMZN	Stock	2.1525	2.1565	2.1315	2.145	12540480.0
2004-03-19 10:00:00	AMZN	Stock	2.145	2.1875	2.1415	2.184	28104920.0
2004-03-19 11:00:00	AMZN	Stock	2.1835	2.1855	2.161	2.1625	14393040.0
2004-03-19 12:00:00	AMZN	Stock	2.162	2.1655	2.152	2.1555	7301420.0
2004-03-19 13:00:00	AMZN	Stock	2.155	2.1705	2.1545	2.1675	12531360.0
2004-03-19 14:00:00	AMZN	Stock	2.1665	2.172	2.1575	2.1575	8850860.0
2004-03-19 15:00:00	AMZN	Stock	2.158	2.162	2.1385	2.1385	25563600.0
2004-03-19 16:00:00	AMZN	Stock	2.1385	2.142	2.137	2.1405	1286900.0
2004-03-19 17:00:00	AMZN	Stock	2.137	2.14	2.13	2.13	633440.0
2004-03-19 18:00:00	AMZN	Stock	2.138	2.138	2.138	2.138	6000.0
2004-03-19 09:00:00	CL	Stock	27.5	27.52	27.475	27.485	777000.0
2004-03-19 10:00:00	CL	Stock	27.48	27.525	27.4	27.405	645600.0
2004-03-19 11:00:00	CL	Stock	27.405	27.55	27.4	27.515	257000.0
2004-03-19 12:00:00	CL	Stock	27.505	27.545	27.475	27.495	476800.0
2004-03-19 13:00:00	CL	Stock	27.495	27.505	27.445	27.48	354600.0
2004-03-19 14:00:00	CL	Stock	27.48	27.505	27.45	27.45	321200.0
2004-03-19 15:00:00	CL	Stock	27.45	27.46	27.35	27.39	739600.0
2004-03-19 16:00:00	CL	Stock	27.375	27.3775	27.375	27.375	51400.0
2004-03-19 18:00:00	CL	Stock	27.375	27.381	27.375	27.381	61000.0

> showing 50 of 23,993 rows — these rows as CSV

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