PREVIEW / stock_1hour / 2005-08-29

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-29.parquet
  size:    564 KB
  rows:    26,622
  symbols: 2,079

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-29 08:00:00	AAPL	Stock	1.625	1.6286	1.6146	1.6214	673848.0
2005-08-29 09:00:00	AAPL	Stock	1.6179	1.6368	1.6161	1.6364	40671792.0
2005-08-29 10:00:00	AAPL	Stock	1.6368	1.6425	1.6254	1.6279	50007244.0
2005-08-29 11:00:00	AAPL	Stock	1.6279	1.6371	1.6264	1.6332	27503364.0
2005-08-29 12:00:00	AAPL	Stock	1.6325	1.6357	1.6271	1.6282	20259736.0
2005-08-29 13:00:00	AAPL	Stock	1.6286	1.64	1.6286	1.6382	35077420.0
2005-08-29 14:00:00	AAPL	Stock	1.6386	1.6421	1.6371	1.6386	20491156.0
2005-08-29 15:00:00	AAPL	Stock	1.6386	1.644	1.6361	1.6371	49435596.0
2005-08-29 16:00:00	AAPL	Stock	1.6371	1.6421	1.6339	1.6382	2864176.0
2005-08-29 17:00:00	AAPL	Stock	1.6393	1.6425	1.6379	1.6418	410452.0
2005-08-29 18:00:00	AAPL	Stock	1.6393	1.6411	1.6386	1.6411	98000.0
2005-08-29 08:00:00	MSFT	Stock	26.8	26.82	26.73	26.8	77315.0
2005-08-29 09:00:00	MSFT	Stock	26.8	27.0	26.78	26.97	14051263.0
2005-08-29 10:00:00	MSFT	Stock	26.98	27.11	26.93	27.01	7483208.0
2005-08-29 11:00:00	MSFT	Stock	27.02	27.05	26.96	26.97	2762370.0
2005-08-29 12:00:00	MSFT	Stock	26.978	27.08	26.96	27.06	4557175.0
2005-08-29 13:00:00	MSFT	Stock	27.06	27.21	26.97	27.15	7142816.0
2005-08-29 14:00:00	MSFT	Stock	27.15	27.18	27.1	27.16	3792055.0
2005-08-29 15:00:00	MSFT	Stock	27.15	27.23	27.0	27.16	10353030.0
2005-08-29 16:00:00	MSFT	Stock	27.16	27.22	27.149	27.17	387137.0
2005-08-29 17:00:00	MSFT	Stock	27.16	27.21	27.084	27.19	27349.0
2005-08-29 18:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	1400.0
2005-08-29 09:00:00	NVDA	Stock	0.24	0.24	0.2368	0.239	54967440.0
2005-08-29 10:00:00	NVDA	Stock	0.2391	0.24	0.2381	0.2392	48826200.0
2005-08-29 11:00:00	NVDA	Stock	0.2393	0.2398	0.2384	0.2391	19346760.0
2005-08-29 12:00:00	NVDA	Stock	0.2392	0.2404	0.239	0.2399	21720120.0
2005-08-29 13:00:00	NVDA	Stock	0.24	0.2409	0.2397	0.2407	38731440.0
2005-08-29 14:00:00	NVDA	Stock	0.2406	0.2407	0.2397	0.2402	23838480.0
2005-08-29 15:00:00	NVDA	Stock	0.2402	0.2417	0.2396	0.2416	114955440.0
2005-08-29 16:00:00	NVDA	Stock	0.2416	0.2418	0.2385	0.2407	6402480.0
2005-08-29 17:00:00	NVDA	Stock	0.2397	0.2413	0.2379	0.239	3009960.0
2005-08-29 18:00:00	NVDA	Stock	0.2387	0.239	0.2387	0.239	601440.0
2005-08-29 08:00:00	AMZN	Stock	2.1025	2.105	2.1	2.105	14000.0
2005-08-29 09:00:00	AMZN	Stock	2.105	2.128	2.0925	2.1255	11216860.0
2005-08-29 10:00:00	AMZN	Stock	2.1255	2.15	2.1245	2.1355	17288640.0
2005-08-29 11:00:00	AMZN	Stock	2.136	2.1435	2.1295	2.1355	5239080.0
2005-08-29 12:00:00	AMZN	Stock	2.1345	2.1345	2.119	2.126	8874840.0
2005-08-29 13:00:00	AMZN	Stock	2.127	2.145	2.126	2.143	10281720.0
2005-08-29 14:00:00	AMZN	Stock	2.142	2.147	2.1375	2.141	5210360.0
2005-08-29 15:00:00	AMZN	Stock	2.1405	2.1475	2.136	2.14	12048020.0
2005-08-29 16:00:00	AMZN	Stock	2.141	2.1455	2.1394	2.144	796800.0
2005-08-29 17:00:00	AMZN	Stock	2.1428	2.1428	2.1428	2.1428	262000.0
2005-08-29 09:00:00	CL	Stock	25.975	26.1	25.975	26.075	210000.0
2005-08-29 10:00:00	CL	Stock	26.075	26.185	26.05	26.12	301400.0
2005-08-29 11:00:00	CL	Stock	26.1205	26.225	26.11	26.205	242000.0
2005-08-29 12:00:00	CL	Stock	26.21	26.23	26.175	26.21	143600.0
2005-08-29 13:00:00	CL	Stock	26.22	26.39	26.22	26.375	354800.0
2005-08-29 14:00:00	CL	Stock	26.375	26.39	26.305	26.39	244200.0
2005-08-29 15:00:00	CL	Stock	26.39	26.5	26.38	26.435	562600.0
2005-08-29 16:00:00	CL	Stock	26.42	26.42	26.42	26.42	14400.0

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

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