PREVIEW / stock_1hour / 2004-12-27

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-12-27.parquet
  size:    527 KB
  rows:    24,753
  symbols: 1,899

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-12-27 08:00:00	AAPL	Stock	1.15	1.1571	1.1498	1.1554	1514856.0
2004-12-27 09:00:00	AAPL	Stock	1.1563	1.1634	1.1454	1.1536	85411928.0
2004-12-27 10:00:00	AAPL	Stock	1.1536	1.1536	1.1432	1.1439	99171912.0
2004-12-27 11:00:00	AAPL	Stock	1.1439	1.1455	1.1238	1.1316	152550552.0
2004-12-27 12:00:00	AAPL	Stock	1.1316	1.1345	1.1295	1.13	39877096.0
2004-12-27 13:00:00	AAPL	Stock	1.13	1.1316	1.1259	1.1313	32534376.0
2004-12-27 14:00:00	AAPL	Stock	1.1313	1.133	1.1271	1.1313	39655728.0
2004-12-27 15:00:00	AAPL	Stock	1.1313	1.1316	1.1229	1.128	72884672.0
2004-12-27 16:00:00	AAPL	Stock	1.128	1.1295	1.127	1.1284	5841416.0
2004-12-27 17:00:00	AAPL	Stock	1.1268	1.1298	1.1268	1.1277	171920.0
2004-12-27 18:00:00	AAPL	Stock	1.1284	1.1284	1.1268	1.1268	28000.0
2004-12-27 08:00:00	MSFT	Stock	27.02	27.08	27.02	27.08	7975.0
2004-12-27 09:00:00	MSFT	Stock	27.08	27.1	27.0	27.05	6174761.0
2004-12-27 10:00:00	MSFT	Stock	27.06	27.06	26.93	26.94	10619500.0
2004-12-27 11:00:00	MSFT	Stock	26.94	26.97	26.82	26.93	10741269.0
2004-12-27 12:00:00	MSFT	Stock	26.93	26.981	26.89	26.93	6497300.0
2004-12-27 13:00:00	MSFT	Stock	26.92	26.94	26.88	26.92	4958588.0
2004-12-27 14:00:00	MSFT	Stock	26.9207	26.93	26.85	26.88	4997066.0
2004-12-27 15:00:00	MSFT	Stock	26.88	26.92	26.85	26.85	9731165.0
2004-12-27 16:00:00	MSFT	Stock	26.85	26.86	26.83	26.86	745186.0
2004-12-27 17:00:00	MSFT	Stock	26.86	26.87	26.86	26.86	9150.0
2004-12-27 18:00:00	MSFT	Stock	26.86	26.86	26.85	26.85	950.0
2004-12-27 09:00:00	NVDA	Stock	0.1932	0.1958	0.1922	0.1927	45845880.0
2004-12-27 10:00:00	NVDA	Stock	0.1927	0.1928	0.1911	0.1915	61860000.0
2004-12-27 11:00:00	NVDA	Stock	0.1915	0.1917	0.1897	0.1899	64575960.0
2004-12-27 12:00:00	NVDA	Stock	0.1899	0.1906	0.1896	0.19	27042000.0
2004-12-27 13:00:00	NVDA	Stock	0.19	0.1906	0.1896	0.1904	13700160.0
2004-12-27 14:00:00	NVDA	Stock	0.1905	0.1915	0.1902	0.1913	34350840.0
2004-12-27 15:00:00	NVDA	Stock	0.1914	0.1915	0.1903	0.1904	51936600.0
2004-12-27 16:00:00	NVDA	Stock	0.1903	0.1915	0.1903	0.1907	4704480.0
2004-12-27 17:00:00	NVDA	Stock	0.1907	0.1907	0.1907	0.1907	48000.0
2004-12-27 08:00:00	AMZN	Stock	1.955	1.985	1.9525	1.985	475220.0
2004-12-27 09:00:00	AMZN	Stock	1.985	2.024	1.954	2.02	38260480.0
2004-12-27 10:00:00	AMZN	Stock	2.02	2.05	2.008	2.045	72532700.0
2004-12-27 11:00:00	AMZN	Stock	2.045	2.074	2.0445	2.0665	81642740.0
2004-12-27 12:00:00	AMZN	Stock	2.066	2.115	2.064	2.11	63852840.0
2004-12-27 13:00:00	AMZN	Stock	2.11	2.119	2.103	2.117	50075900.0
2004-12-27 14:00:00	AMZN	Stock	2.1165	2.1465	2.116	2.13	66388100.0
2004-12-27 15:00:00	AMZN	Stock	2.13	2.1375	2.111	2.113	65289640.0
2004-12-27 16:00:00	AMZN	Stock	2.1145	2.1145	2.1065	2.109	4564520.0
2004-12-27 17:00:00	AMZN	Stock	2.1085	2.1085	2.101	2.107	604220.0
2004-12-27 18:00:00	AMZN	Stock	2.105	2.1095	2.104	2.1085	87600.0
2004-12-27 09:00:00	CL	Stock	25.385	25.465	25.3	25.355	277600.0
2004-12-27 10:00:00	CL	Stock	25.355	25.42	25.31	25.33	506800.0
2004-12-27 11:00:00	CL	Stock	25.33	25.37	25.27	25.33	276400.0
2004-12-27 12:00:00	CL	Stock	25.335	25.375	25.26	25.27	389400.0
2004-12-27 13:00:00	CL	Stock	25.265	25.28	25.205	25.275	222200.0
2004-12-27 14:00:00	CL	Stock	25.275	25.3	25.185	25.25	290800.0
2004-12-27 15:00:00	CL	Stock	25.245	25.27	25.175	25.175	543600.0
2004-12-27 17:00:00	CL	Stock	25.2	25.2	25.2	25.2	400.0

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

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