PREVIEW / stock_1hour / 2005-03-23

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-03-23.parquet
  size:    554 KB
  rows:    26,404
  symbols: 1,960

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-03-23 08:00:00	AAPL	Stock	1.5243	1.5243	1.4982	1.5143	3587892.0
2005-03-23 09:00:00	AAPL	Stock	1.5154	1.5239	1.5007	1.5086	108422132.0
2005-03-23 10:00:00	AAPL	Stock	1.5089	1.5375	1.5068	1.5375	122009468.0
2005-03-23 11:00:00	AAPL	Stock	1.5375	1.55	1.5257	1.5286	109104240.0
2005-03-23 12:00:00	AAPL	Stock	1.5282	1.5429	1.5282	1.5329	50675268.0
2005-03-23 13:00:00	AAPL	Stock	1.5332	1.5361	1.5275	1.535	31872708.0
2005-03-23 14:00:00	AAPL	Stock	1.535	1.5396	1.5282	1.5304	40165608.0
2005-03-23 15:00:00	AAPL	Stock	1.5304	1.5464	1.5182	1.5186	129522764.0
2005-03-23 16:00:00	AAPL	Stock	1.5189	1.5214	1.515	1.5186	2601424.0
2005-03-23 17:00:00	AAPL	Stock	1.5175	1.5186	1.5111	1.5186	712656.0
2005-03-23 18:00:00	AAPL	Stock	1.5143	1.5143	1.5111	1.5114	145600.0
2005-03-23 08:00:00	MSFT	Stock	24.0	24.04	23.93	23.96	54215.0
2005-03-23 09:00:00	MSFT	Stock	23.96	24.14	23.95	24.09	10167136.0
2005-03-23 10:00:00	MSFT	Stock	24.1	24.305	24.09	24.23	16971368.0
2005-03-23 11:00:00	MSFT	Stock	24.22	24.27	24.19	24.23	8602615.0
2005-03-23 12:00:00	MSFT	Stock	24.22	24.37	24.22	24.35	8839136.0
2005-03-23 13:00:00	MSFT	Stock	24.36	24.39	24.24	24.28	8796929.0
2005-03-23 14:00:00	MSFT	Stock	24.28	24.33	24.219	24.23	8528438.0
2005-03-23 15:00:00	MSFT	Stock	24.22	24.32	24.17	24.17	15089653.0
2005-03-23 16:00:00	MSFT	Stock	24.2	24.22	24.17	24.2	403837.0
2005-03-23 17:00:00	MSFT	Stock	24.17	24.26	24.16	24.18	150705.0
2005-03-23 18:00:00	MSFT	Stock	24.18	24.21	24.18	24.21	6250.0
2005-03-23 08:00:00	NVDA	Stock	0.205	0.205	0.2042	0.2042	3372000.0
2005-03-23 09:00:00	NVDA	Stock	0.2046	0.2075	0.2039	0.2062	85723080.0
2005-03-23 10:00:00	NVDA	Stock	0.2062	0.209	0.2061	0.2081	129845280.0
2005-03-23 11:00:00	NVDA	Stock	0.2079	0.2085	0.2071	0.2077	62821920.0
2005-03-23 12:00:00	NVDA	Stock	0.2078	0.2092	0.2077	0.2087	46018080.0
2005-03-23 13:00:00	NVDA	Stock	0.2087	0.2103	0.2083	0.21	65044680.0
2005-03-23 14:00:00	NVDA	Stock	0.21	0.2104	0.2087	0.209	83344920.0
2005-03-23 15:00:00	NVDA	Stock	0.2091	0.2097	0.208	0.2089	145311120.0
2005-03-23 16:00:00	NVDA	Stock	0.2086	0.2097	0.2083	0.209	2986560.0
2005-03-23 17:00:00	NVDA	Stock	0.2093	0.2094	0.209	0.2094	248400.0
2005-03-23 09:00:00	AMZN	Stock	1.6575	1.6645	1.6505	1.6595	13982960.0
2005-03-23 10:00:00	AMZN	Stock	1.6595	1.6615	1.641	1.65	38349000.0
2005-03-23 11:00:00	AMZN	Stock	1.6495	1.6525	1.6435	1.6474	13101720.0
2005-03-23 12:00:00	AMZN	Stock	1.648	1.665	1.6475	1.663	9323700.0
2005-03-23 13:00:00	AMZN	Stock	1.6635	1.687	1.6605	1.6845	16166320.0
2005-03-23 14:00:00	AMZN	Stock	1.6845	1.692	1.67	1.67	15731440.0
2005-03-23 15:00:00	AMZN	Stock	1.6695	1.68	1.659	1.66	17571260.0
2005-03-23 16:00:00	AMZN	Stock	1.6615	1.665	1.659	1.659	659300.0
2005-03-23 17:00:00	AMZN	Stock	1.659	1.659	1.659	1.659	180000.0
2005-03-23 09:00:00	CL	Stock	25.3	25.745	25.3	25.52	562200.0
2005-03-23 10:00:00	CL	Stock	25.525	25.765	25.505	25.74	773000.0
2005-03-23 11:00:00	CL	Stock	25.71	25.91	25.665	25.895	798000.0
2005-03-23 12:00:00	CL	Stock	25.895	26.14	25.88	26.12	538400.0
2005-03-23 13:00:00	CL	Stock	26.12	26.205	25.965	26.025	635600.0
2005-03-23 14:00:00	CL	Stock	26.03	26.08	25.965	26.015	948800.0
2005-03-23 15:00:00	CL	Stock	26.015	26.15	25.96	26.01	1019800.0
2005-03-23 16:00:00	CL	Stock	26.015	26.15	26.015	26.15	93200.0

> showing 49 of 26,404 rows — these rows as CSV

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