PREVIEW / stock_1hour / 2005-08-04

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-04.parquet
  size:    565 KB
  rows:    26,821
  symbols: 2,052

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-08-04 07:00:00	AAPL	Stock	1.5393	1.5393	1.5286	1.5286	5600.0
2005-08-04 08:00:00	AAPL	Stock	1.5429	1.5429	1.5339	1.5339	491120.0
2005-08-04 09:00:00	AAPL	Stock	1.5354	1.5375	1.5282	1.5289	27458900.0
2005-08-04 10:00:00	AAPL	Stock	1.5293	1.5318	1.5229	1.5304	40072312.0
2005-08-04 11:00:00	AAPL	Stock	1.5304	1.5318	1.515	1.5164	42656404.0
2005-08-04 12:00:00	AAPL	Stock	1.5161	1.5179	1.5104	1.5154	44185400.0
2005-08-04 13:00:00	AAPL	Stock	1.515	1.5189	1.5121	1.5186	32032028.0
2005-08-04 14:00:00	AAPL	Stock	1.5182	1.5254	1.5179	1.5236	29485092.0
2005-08-04 15:00:00	AAPL	Stock	1.5232	1.5268	1.5218	1.5236	46326756.0
2005-08-04 16:00:00	AAPL	Stock	1.5257	1.5261	1.5232	1.5236	2753576.0
2005-08-04 17:00:00	AAPL	Stock	1.525	1.5254	1.5232	1.525	2570400.0
2005-08-04 18:00:00	AAPL	Stock	1.5232	1.5236	1.5232	1.5236	3517360.0
2005-08-04 08:00:00	MSFT	Stock	27.23	27.23	27.0	27.12	347128.0
2005-08-04 09:00:00	MSFT	Stock	27.12	27.5	27.11	27.31	14006310.0
2005-08-04 10:00:00	MSFT	Stock	27.302	27.4	27.24	27.27	15177114.0
2005-08-04 11:00:00	MSFT	Stock	27.27	27.33	27.169	27.18	15377658.0
2005-08-04 12:00:00	MSFT	Stock	27.18	27.23	27.13	27.152	10760602.0
2005-08-04 13:00:00	MSFT	Stock	27.16	27.19	27.05	27.18	9836003.0
2005-08-04 14:00:00	MSFT	Stock	27.17	27.3	27.17	27.23	11207125.0
2005-08-04 15:00:00	MSFT	Stock	27.22	27.34	27.2	27.31	12996450.0
2005-08-04 16:00:00	MSFT	Stock	27.31	27.4	27.25	27.38	911592.0
2005-08-04 17:00:00	MSFT	Stock	27.38	27.41	27.32	27.36	239574.0
2005-08-04 18:00:00	MSFT	Stock	27.32	27.41	27.32	27.41	68768.0
2005-08-04 08:00:00	NVDA	Stock	0.23	0.2318	0.23	0.2301	624000.0
2005-08-04 09:00:00	NVDA	Stock	0.2315	0.2315	0.2291	0.2297	33389640.0
2005-08-04 10:00:00	NVDA	Stock	0.2298	0.2312	0.2292	0.2311	45369120.0
2005-08-04 11:00:00	NVDA	Stock	0.2311	0.2311	0.2293	0.2299	43026480.0
2005-08-04 12:00:00	NVDA	Stock	0.2299	0.2304	0.2293	0.2296	27712800.0
2005-08-04 13:00:00	NVDA	Stock	0.2296	0.23	0.2294	0.2298	24968280.0
2005-08-04 14:00:00	NVDA	Stock	0.2297	0.2302	0.2297	0.2302	32036880.0
2005-08-04 15:00:00	NVDA	Stock	0.2302	0.2308	0.2295	0.2296	115965000.0
2005-08-04 16:00:00	NVDA	Stock	0.2296	0.2297	0.2292	0.2297	20546880.0
2005-08-04 17:00:00	NVDA	Stock	0.2288	0.2292	0.2287	0.2292	300000.0
2005-08-04 18:00:00	NVDA	Stock	0.2292	0.2292	0.2292	0.2292	120000.0
2005-08-04 08:00:00	AMZN	Stock	2.294	2.294	2.2775	2.2825	595500.0
2005-08-04 09:00:00	AMZN	Stock	2.285	2.2885	2.275	2.2805	23941200.0
2005-08-04 10:00:00	AMZN	Stock	2.2805	2.286	2.2775	2.281	15400620.0
2005-08-04 11:00:00	AMZN	Stock	2.28	2.2835	2.275	2.2755	8881560.0
2005-08-04 12:00:00	AMZN	Stock	2.276	2.286	2.2735	2.281	9590020.0
2005-08-04 13:00:00	AMZN	Stock	2.2825	2.285	2.2755	2.276	9493860.0
2005-08-04 14:00:00	AMZN	Stock	2.2755	2.2795	2.271	2.2735	12991580.0
2005-08-04 15:00:00	AMZN	Stock	2.2735	2.2815	2.2725	2.273	16775340.0
2005-08-04 16:00:00	AMZN	Stock	2.275	2.278	2.27	2.272	198000.0
2005-08-04 17:00:00	AMZN	Stock	2.2725	2.2725	2.271	2.271	98000.0
2005-08-04 18:00:00	AMZN	Stock	2.272	2.2775	2.272	2.2775	16000.0
2005-08-04 09:00:00	CL	Stock	26.56	26.56	26.465	26.47	375600.0
2005-08-04 10:00:00	CL	Stock	26.475	26.475	26.355	26.445	628400.0
2005-08-04 11:00:00	CL	Stock	26.44	26.45	26.18	26.18	567800.0
2005-08-04 12:00:00	CL	Stock	26.175	26.3	26.125	26.26	502400.0
2005-08-04 13:00:00	CL	Stock	26.26	26.3	26.185	26.205	408600.0

> showing 50 of 26,821 rows — these rows as CSV

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