PREVIEW / stock_1hour / 2005-11-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-11-04.parquet
  size:    569 KB
  rows:    27,060
  symbols: 2,105

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-11-04 05:00:00	AAPL	Stock	2.175	2.1754	2.175	2.175	53200.0
2005-11-04 06:00:00	AAPL	Stock	2.1696	2.1696	2.1607	2.1607	16800.0
2005-11-04 07:00:00	AAPL	Stock	2.15	2.1689	2.15	2.1657	1910636.0
2005-11-04 08:00:00	AAPL	Stock	2.1629	2.1779	2.1518	2.1661	10602788.0
2005-11-04 09:00:00	AAPL	Stock	2.1668	2.1764	2.1293	2.1657	227346252.0
2005-11-04 10:00:00	AAPL	Stock	2.1657	2.1671	2.1446	2.1629	147505848.0
2005-11-04 11:00:00	AAPL	Stock	2.1625	2.1871	2.1625	2.1725	133034272.0
2005-11-04 12:00:00	AAPL	Stock	2.1729	2.1825	2.16	2.1707	77699636.0
2005-11-04 13:00:00	AAPL	Stock	2.1711	2.1714	2.1625	2.1679	47362560.0
2005-11-04 14:00:00	AAPL	Stock	2.1679	2.1764	2.1657	2.1714	74701732.0
2005-11-04 15:00:00	AAPL	Stock	2.1711	2.1829	2.1661	2.1825	148645504.0
2005-11-04 16:00:00	AAPL	Stock	2.18	2.1839	2.164	2.1839	1351336.0
2005-11-04 17:00:00	AAPL	Stock	2.1832	2.1854	2.1804	2.1854	287308.0
2005-11-04 18:00:00	AAPL	Stock	2.1854	2.1875	2.1839	2.1871	170716.0
2005-11-04 08:00:00	MSFT	Stock	26.55	26.61	26.5	26.54	101564.0
2005-11-04 09:00:00	MSFT	Stock	26.54	26.65	26.44	26.62	6236301.0
2005-11-04 10:00:00	MSFT	Stock	26.62	26.631	26.45	26.529	8325085.0
2005-11-04 11:00:00	MSFT	Stock	26.53	26.6	26.5	26.53	6401676.0
2005-11-04 12:00:00	MSFT	Stock	26.531	26.621	26.48	26.6	13129474.0
2005-11-04 13:00:00	MSFT	Stock	26.6	26.62	26.53	26.56	5549961.0
2005-11-04 14:00:00	MSFT	Stock	26.552	26.62	26.54	26.6	6198636.0
2005-11-04 15:00:00	MSFT	Stock	26.6	26.71	26.56	26.64	9705280.0
2005-11-04 16:00:00	MSFT	Stock	26.66	26.69	26.575	26.69	656842.0
2005-11-04 17:00:00	MSFT	Stock	26.68	26.69	26.569	26.69	16480.0
2005-11-04 18:00:00	MSFT	Stock	26.67	26.69	26.67	26.69	310.0
2005-11-04 08:00:00	NVDA	Stock	0.2887	0.2887	0.2887	0.2887	36000.0
2005-11-04 09:00:00	NVDA	Stock	0.2887	0.2897	0.2862	0.2867	78119400.0
2005-11-04 10:00:00	NVDA	Stock	0.2868	0.2874	0.2808	0.2837	96848640.0
2005-11-04 11:00:00	NVDA	Stock	0.2838	0.2854	0.2813	0.2817	124751760.0
2005-11-04 12:00:00	NVDA	Stock	0.2817	0.2838	0.2812	0.2832	46982040.0
2005-11-04 13:00:00	NVDA	Stock	0.2832	0.2837	0.2818	0.282	35365560.0
2005-11-04 14:00:00	NVDA	Stock	0.2818	0.2842	0.2817	0.2831	68660760.0
2005-11-04 15:00:00	NVDA	Stock	0.2832	0.2842	0.2827	0.2837	101210640.0
2005-11-04 16:00:00	NVDA	Stock	0.2837	0.2837	0.2828	0.2828	202800.0
2005-11-04 17:00:00	NVDA	Stock	0.2837	0.2837	0.2832	0.2832	60000.0
2005-11-04 08:00:00	AMZN	Stock	2.1	2.1	2.075	2.075	50000.0
2005-11-04 09:00:00	AMZN	Stock	2.0655	2.0765	2.06	2.0705	11639760.0
2005-11-04 10:00:00	AMZN	Stock	2.071	2.09	2.0455	2.0565	18504880.0
2005-11-04 11:00:00	AMZN	Stock	2.057	2.0645	2.055	2.055	9128800.0
2005-11-04 12:00:00	AMZN	Stock	2.0552	2.0725	2.051	2.0635	7303940.0
2005-11-04 13:00:00	AMZN	Stock	2.0635	2.069	2.0615	2.0635	7288220.0
2005-11-04 14:00:00	AMZN	Stock	2.063	2.0696	2.052	2.055	8354100.0
2005-11-04 15:00:00	AMZN	Stock	2.055	2.058	2.0515	2.0545	24717480.0
2005-11-04 16:00:00	AMZN	Stock	2.0545	2.057	2.0485	2.057	538200.0
2005-11-04 17:00:00	AMZN	Stock	2.0544	2.0575	2.0544	2.0575	29840.0
2005-11-04 08:00:00	CL	Stock	26.0	26.0	26.0	26.0	400.0
2005-11-04 09:00:00	CL	Stock	25.85	26.06	25.85	26.02	352800.0
2005-11-04 10:00:00	CL	Stock	26.02	26.08	25.935	25.96	748200.0
2005-11-04 11:00:00	CL	Stock	25.96	26.0	25.9	25.915	393000.0
2005-11-04 12:00:00	CL	Stock	25.91	25.96	25.89	25.945	283200.0

> showing 50 of 27,060 rows — these rows as CSV

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