PREVIEW / stock_1hour / 2005-08-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-08-19.parquet
  size:    538 KB
  rows:    25,927
  symbols: 2,064

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-19 08:00:00	AAPL	Stock	1.6646	1.665	1.6607	1.6607	327600.0
2005-08-19 09:00:00	AAPL	Stock	1.6621	1.6671	1.65	1.665	81326980.0
2005-08-19 10:00:00	AAPL	Stock	1.6654	1.6679	1.6361	1.6439	118477464.0
2005-08-19 11:00:00	AAPL	Stock	1.6439	1.6457	1.635	1.6379	51366084.0
2005-08-19 12:00:00	AAPL	Stock	1.6379	1.6436	1.635	1.6382	24661588.0
2005-08-19 13:00:00	AAPL	Stock	1.6382	1.6407	1.6346	1.6375	20238960.0
2005-08-19 14:00:00	AAPL	Stock	1.6379	1.6404	1.6371	1.6379	27018768.0
2005-08-19 15:00:00	AAPL	Stock	1.6379	1.6539	1.635	1.6368	45146164.0
2005-08-19 16:00:00	AAPL	Stock	1.6361	1.6387	1.6357	1.6375	1545908.0
2005-08-19 17:00:00	AAPL	Stock	1.6379	1.6379	1.6364	1.6364	115080.0
2005-08-19 18:00:00	AAPL	Stock	1.6375	1.6375	1.6375	1.6375	56140.0
2005-08-19 08:00:00	MSFT	Stock	26.9	26.91	26.82	26.87	63622.0
2005-08-19 09:00:00	MSFT	Stock	26.87	26.95	26.7	26.8	8301227.0
2005-08-19 10:00:00	MSFT	Stock	26.8	26.851	26.73	26.78	4616631.0
2005-08-19 11:00:00	MSFT	Stock	26.78	26.91	26.75	26.86	4892020.0
2005-08-19 12:00:00	MSFT	Stock	26.87	26.9	26.79	26.81	4773152.0
2005-08-19 13:00:00	MSFT	Stock	26.81	26.9	26.75	26.8	2789387.0
2005-08-19 14:00:00	MSFT	Stock	26.79	26.8	26.73	26.78	3324593.0
2005-08-19 15:00:00	MSFT	Stock	26.77	26.868	26.72	26.72	5272130.0
2005-08-19 16:00:00	MSFT	Stock	26.73	26.752	26.7	26.73	300798.0
2005-08-19 17:00:00	MSFT	Stock	26.73	26.73	26.7	26.73	13867.0
2005-08-19 18:00:00	MSFT	Stock	26.73	26.76	26.71	26.73	3708.0
2005-08-19 09:00:00	NVDA	Stock	0.2454	0.2462	0.2426	0.2445	84606360.0
2005-08-19 10:00:00	NVDA	Stock	0.2445	0.2455	0.2439	0.2451	87287160.0
2005-08-19 11:00:00	NVDA	Stock	0.2451	0.2452	0.2439	0.2446	47519880.0
2005-08-19 12:00:00	NVDA	Stock	0.2445	0.2447	0.2429	0.2432	34059720.0
2005-08-19 13:00:00	NVDA	Stock	0.2432	0.2441	0.243	0.244	31313160.0
2005-08-19 14:00:00	NVDA	Stock	0.244	0.2441	0.2432	0.2436	36514560.0
2005-08-19 15:00:00	NVDA	Stock	0.2436	0.2446	0.243	0.2433	87039240.0
2005-08-19 16:00:00	NVDA	Stock	0.2433	0.2433	0.2428	0.2433	1292400.0
2005-08-19 08:00:00	AMZN	Stock	2.1875	2.1875	2.175	2.1875	32000.0
2005-08-19 09:00:00	AMZN	Stock	2.18	2.1875	2.1665	2.1725	16017180.0
2005-08-19 10:00:00	AMZN	Stock	2.1725	2.1775	2.1685	2.1736	9095120.0
2005-08-19 11:00:00	AMZN	Stock	2.174	2.1815	2.1721	2.1805	9341380.0
2005-08-19 12:00:00	AMZN	Stock	2.1805	2.1825	2.1725	2.1765	4736360.0
2005-08-19 13:00:00	AMZN	Stock	2.177	2.1785	2.1755	2.176	4970960.0
2005-08-19 14:00:00	AMZN	Stock	2.176	2.178	2.175	2.176	5665120.0
2005-08-19 15:00:00	AMZN	Stock	2.1765	2.1885	2.176	2.186	15289680.0
2005-08-19 16:00:00	AMZN	Stock	2.186	2.188	2.1805	2.183	324620.0
2005-08-19 09:00:00	CL	Stock	26.35	26.35	26.115	26.175	559800.0
2005-08-19 10:00:00	CL	Stock	26.185	26.31	26.16	26.28	649400.0
2005-08-19 11:00:00	CL	Stock	26.28	26.3	26.2	26.205	258000.0
2005-08-19 12:00:00	CL	Stock	26.205	26.205	26.1	26.105	330800.0
2005-08-19 13:00:00	CL	Stock	26.1	26.18	26.1	26.155	343000.0
2005-08-19 14:00:00	CL	Stock	26.155	26.18	26.12	26.155	365800.0
2005-08-19 15:00:00	CL	Stock	26.15	26.17	26.06	26.07	700000.0

> showing 46 of 25,927 rows — these rows as CSV

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