PREVIEW / stock_1hour / 2005-01-18

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-01-18.parquet
  size:    552 KB
  rows:    25,762
  symbols: 1,917

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
2005-01-18 08:00:00	AAPL	Stock	1.2554	1.2554	1.2457	1.2486	966840.0
2005-01-18 09:00:00	AAPL	Stock	1.2486	1.2532	1.237	1.2375	206719184.0
2005-01-18 10:00:00	AAPL	Stock	1.2373	1.2613	1.2359	1.2577	269065048.0
2005-01-18 11:00:00	AAPL	Stock	1.2579	1.2582	1.2468	1.2545	106831424.0
2005-01-18 12:00:00	AAPL	Stock	1.2545	1.2589	1.2543	1.2554	60872952.0
2005-01-18 13:00:00	AAPL	Stock	1.2554	1.2557	1.2455	1.2525	90119736.0
2005-01-18 14:00:00	AAPL	Stock	1.2525	1.2566	1.2475	1.2554	99468320.0
2005-01-18 15:00:00	AAPL	Stock	1.2554	1.2625	1.2536	1.2618	158007696.0
2005-01-18 16:00:00	AAPL	Stock	1.2616	1.2634	1.2598	1.2616	5048736.0
2005-01-18 17:00:00	AAPL	Stock	1.2616	1.2625	1.2604	1.2616	748216.0
2005-01-18 18:00:00	AAPL	Stock	1.2614	1.2625	1.2607	1.2607	114800.0
2005-01-18 08:00:00	MSFT	Stock	26.07	26.1	26.01	26.05	18560.0
2005-01-18 09:00:00	MSFT	Stock	26.02	26.1	25.84	25.94	11364823.0
2005-01-18 10:00:00	MSFT	Stock	25.932	26.14	25.93	26.09	13367231.0
2005-01-18 11:00:00	MSFT	Stock	26.09	26.29	26.08	26.2	10429759.0
2005-01-18 12:00:00	MSFT	Stock	26.21	26.3	26.2	26.21	5360813.0
2005-01-18 13:00:00	MSFT	Stock	26.21	26.35	26.2	26.3	4613742.0
2005-01-18 14:00:00	MSFT	Stock	26.3	26.35	26.17	26.23	7233517.0
2005-01-18 15:00:00	MSFT	Stock	26.22	26.33	26.17	26.31	12662903.0
2005-01-18 16:00:00	MSFT	Stock	26.3	26.35	26.29	26.31	669074.0
2005-01-18 17:00:00	MSFT	Stock	26.31	26.31	26.29	26.31	72627.0
2005-01-18 18:00:00	MSFT	Stock	26.31	26.32	26.31	26.31	1175.0
2005-01-18 08:00:00	NVDA	Stock	0.1792	0.1793	0.1792	0.1793	120000.0
2005-01-18 09:00:00	NVDA	Stock	0.1792	0.1792	0.1768	0.1791	28772520.0
2005-01-18 10:00:00	NVDA	Stock	0.1791	0.1815	0.1784	0.1805	54774120.0
2005-01-18 11:00:00	NVDA	Stock	0.1805	0.1819	0.1804	0.1814	64321200.0
2005-01-18 12:00:00	NVDA	Stock	0.1814	0.1824	0.1811	0.1811	42338400.0
2005-01-18 13:00:00	NVDA	Stock	0.1811	0.1812	0.18	0.1802	68124240.0
2005-01-18 14:00:00	NVDA	Stock	0.1802	0.1821	0.1802	0.1817	80213880.0
2005-01-18 15:00:00	NVDA	Stock	0.1817	0.1825	0.1812	0.1818	103992840.0
2005-01-18 16:00:00	NVDA	Stock	0.1821	0.1827	0.1817	0.1822	11852280.0
2005-01-18 17:00:00	NVDA	Stock	0.1821	0.1821	0.1819	0.1819	540000.0
2005-01-18 18:00:00	NVDA	Stock	0.1821	0.1821	0.1821	0.1821	144000.0
2005-01-18 08:00:00	AMZN	Stock	2.2215	2.225	2.2215	2.225	50000.0
2005-01-18 09:00:00	AMZN	Stock	2.2175	2.25	2.2075	2.238	31120520.0
2005-01-18 10:00:00	AMZN	Stock	2.238	2.241	2.222	2.228	29171620.0
2005-01-18 11:00:00	AMZN	Stock	2.228	2.234	2.218	2.2205	21208300.0
2005-01-18 12:00:00	AMZN	Stock	2.2205	2.23	2.2185	2.224	10964220.0
2005-01-18 13:00:00	AMZN	Stock	2.224	2.23	2.218	2.224	10264720.0
2005-01-18 14:00:00	AMZN	Stock	2.224	2.2375	2.223	2.237	14986380.0
2005-01-18 15:00:00	AMZN	Stock	2.237	2.2375	2.223	2.2275	21170300.0
2005-01-18 16:00:00	AMZN	Stock	2.2285	2.2445	2.2085	2.233	1493980.0
2005-01-18 17:00:00	AMZN	Stock	2.233	2.234	2.229	2.2335	306800.0
2005-01-18 18:00:00	AMZN	Stock	2.23	2.23	2.23	2.23	3000.0
2005-01-18 09:00:00	CL	Stock	24.875	24.9	24.765	24.8	895200.0
2005-01-18 10:00:00	CL	Stock	24.79	25.01	24.78	24.975	484800.0
2005-01-18 11:00:00	CL	Stock	24.96	25.0845	24.955	25.075	488000.0
2005-01-18 12:00:00	CL	Stock	25.07	25.1	25.035	25.06	267600.0
2005-01-18 13:00:00	CL	Stock	25.065	25.15	25.06	25.07	210200.0
2005-01-18 14:00:00	CL	Stock	25.07	25.135	25.055	25.065	240800.0

> showing 50 of 25,762 rows — these rows as CSV

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