PREVIEW / stock_1hour / 2005-08-12

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-12.parquet
  size:    568 KB
  rows:    27,202
  symbols: 2,049

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-12 07:00:00	AAPL	Stock	1.5493	1.5493	1.5471	1.5471	299600.0
2005-08-12 08:00:00	AAPL	Stock	1.5471	1.5514	1.5375	1.5482	1771140.0
2005-08-12 09:00:00	AAPL	Stock	1.5457	1.5596	1.5446	1.5579	34231260.0
2005-08-12 10:00:00	AAPL	Stock	1.5582	1.5693	1.5543	1.5668	49425096.0
2005-08-12 11:00:00	AAPL	Stock	1.5665	1.5804	1.5636	1.5775	74368280.0
2005-08-12 12:00:00	AAPL	Stock	1.5771	1.5829	1.5736	1.5825	60551876.0
2005-08-12 13:00:00	AAPL	Stock	1.5825	1.6179	1.5786	1.6114	192898524.0
2005-08-12 14:00:00	AAPL	Stock	1.6111	1.645	1.6111	1.6425	224703836.0
2005-08-12 15:00:00	AAPL	Stock	1.6425	1.6507	1.6361	1.6468	242352236.0
2005-08-12 16:00:00	AAPL	Stock	1.6464	1.6536	1.6433	1.6507	6424264.0
2005-08-12 17:00:00	AAPL	Stock	1.6518	1.6536	1.6473	1.6514	747068.0
2005-08-12 18:00:00	AAPL	Stock	1.6536	1.6575	1.6532	1.6536	579544.0
2005-08-12 08:00:00	MSFT	Stock	27.07	27.11	27.07	27.1	22148.0
2005-08-12 09:00:00	MSFT	Stock	27.1	27.14	26.96	27.03	6677705.0
2005-08-12 10:00:00	MSFT	Stock	27.03	27.14	26.99	27.07	7733106.0
2005-08-12 11:00:00	MSFT	Stock	27.06	27.1	26.95	27.01	5565223.0
2005-08-12 12:00:00	MSFT	Stock	27.0	27.06	26.949	27.01	5211280.0
2005-08-12 13:00:00	MSFT	Stock	27.01	27.01	26.9	26.92	5324550.0
2005-08-12 14:00:00	MSFT	Stock	26.92	27.05	26.9	26.93	5066900.0
2005-08-12 15:00:00	MSFT	Stock	26.92	27.08	26.9	27.03	11481145.0
2005-08-12 16:00:00	MSFT	Stock	27.03	27.072	26.96	26.98	834886.0
2005-08-12 17:00:00	MSFT	Stock	26.98	27.05	26.95	27.01	43952.0
2005-08-12 18:00:00	MSFT	Stock	26.96	26.98	26.95	26.95	6550.0
2005-08-12 04:00:00	NVDA	Stock	0.2467	0.2467	0.2467	0.2467	23640.0
2005-08-12 07:00:00	NVDA	Stock	0.2508	0.2542	0.2494	0.25	2856000.0
2005-08-12 08:00:00	NVDA	Stock	0.2501	0.2517	0.2479	0.2491	27110160.0
2005-08-12 09:00:00	NVDA	Stock	0.249	0.2517	0.2442	0.2487	640844160.0
2005-08-12 10:00:00	NVDA	Stock	0.2486	0.2504	0.2407	0.2412	558093240.0
2005-08-12 11:00:00	NVDA	Stock	0.2412	0.2459	0.2409	0.2453	233165160.0
2005-08-12 12:00:00	NVDA	Stock	0.2455	0.2485	0.2452	0.2467	161866680.0
2005-08-12 13:00:00	NVDA	Stock	0.2467	0.2478	0.2453	0.246	120417480.0
2005-08-12 14:00:00	NVDA	Stock	0.2457	0.2492	0.2455	0.2487	194065680.0
2005-08-12 15:00:00	NVDA	Stock	0.2487	0.2512	0.2487	0.2497	336742200.0
2005-08-12 16:00:00	NVDA	Stock	0.2492	0.2512	0.2492	0.25	6707760.0
2005-08-12 17:00:00	NVDA	Stock	0.25	0.2504	0.2485	0.25	19560000.0
2005-08-12 18:00:00	NVDA	Stock	0.2504	0.2504	0.25	0.25	139200.0
2005-08-12 08:00:00	AMZN	Stock	2.2425	2.2425	2.242	2.242	16000.0
2005-08-12 09:00:00	AMZN	Stock	2.242	2.286	2.23	2.242	13978300.0
2005-08-12 10:00:00	AMZN	Stock	2.242	2.243	2.2205	2.2275	19677740.0
2005-08-12 11:00:00	AMZN	Stock	2.2275	2.236	2.2105	2.211	19356120.0
2005-08-12 12:00:00	AMZN	Stock	2.2175	2.2175	2.206	2.2085	15127640.0
2005-08-12 13:00:00	AMZN	Stock	2.208	2.2105	2.206	2.2085	8049800.0
2005-08-12 14:00:00	AMZN	Stock	2.208	2.2115	2.206	2.2086	12315980.0
2005-08-12 15:00:00	AMZN	Stock	2.209	2.2135	2.2025	2.209	34854060.0
2005-08-12 16:00:00	AMZN	Stock	2.209	2.211	2.206	2.206	756800.0
2005-08-12 17:00:00	AMZN	Stock	2.2095	2.21	2.206	2.209	135960.0
2005-08-12 09:00:00	CL	Stock	26.3	26.345	26.155	26.185	360200.0
2005-08-12 10:00:00	CL	Stock	26.19	26.24	26.16	26.225	392400.0
2005-08-12 11:00:00	CL	Stock	26.23	26.285	26.21	26.28	480600.0
2005-08-12 12:00:00	CL	Stock	26.28	26.285	26.175	26.22	512400.0

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

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