PREVIEW / stock_1hour / 2004-11-09

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-09.parquet
  size:    520 KB
  rows:    24,442
  symbols: 1,866

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
2004-11-09 08:00:00	AAPL	Stock	0.9739	0.9741	0.9711	0.9723	1899072.0
2004-11-09 09:00:00	AAPL	Stock	0.9732	0.9732	0.9621	0.9634	79011352.0
2004-11-09 10:00:00	AAPL	Stock	0.9634	0.9646	0.9532	0.9586	110201728.0
2004-11-09 11:00:00	AAPL	Stock	0.9584	0.9636	0.9571	0.9605	45722992.0
2004-11-09 12:00:00	AAPL	Stock	0.9607	0.9664	0.9605	0.9625	43738296.0
2004-11-09 13:00:00	AAPL	Stock	0.9625	0.9677	0.9613	0.9671	46862592.0
2004-11-09 14:00:00	AAPL	Stock	0.9673	0.9741	0.9664	0.968	56692608.0
2004-11-09 15:00:00	AAPL	Stock	0.968	0.9711	0.9641	0.9643	63043960.0
2004-11-09 16:00:00	AAPL	Stock	0.9655	0.9678	0.9638	0.9652	6041000.0
2004-11-09 17:00:00	AAPL	Stock	0.9666	0.967	0.9625	0.9625	724696.0
2004-11-09 18:00:00	AAPL	Stock	0.9625	0.9625	0.958	0.958	113736.0
2004-11-09 08:00:00	MSFT	Stock	29.38	29.61	29.29	29.44	804201.0
2004-11-09 09:00:00	MSFT	Stock	29.41	29.55	29.33	29.53	10877762.0
2004-11-09 10:00:00	MSFT	Stock	29.528	29.54	29.41	29.45	10191712.0
2004-11-09 11:00:00	MSFT	Stock	29.45	29.53	29.37	29.49	12263567.0
2004-11-09 12:00:00	MSFT	Stock	29.5	29.62	29.48	29.62	11059705.0
2004-11-09 13:00:00	MSFT	Stock	29.6188	29.7	29.57	29.7	10398399.0
2004-11-09 14:00:00	MSFT	Stock	29.6987	29.89	29.69	29.85	17462423.0
2004-11-09 15:00:00	MSFT	Stock	29.85	29.89	29.73	29.77	20305399.0
2004-11-09 16:00:00	MSFT	Stock	29.77	29.83	29.7	29.76	2319062.0
2004-11-09 17:00:00	MSFT	Stock	29.79	29.82	29.74	29.78	190395.0
2004-11-09 18:00:00	MSFT	Stock	29.78	29.82	29.78	29.8	8905.0
2004-11-09 08:00:00	NVDA	Stock	0.1479	0.1486	0.1463	0.1469	1757760.0
2004-11-09 09:00:00	NVDA	Stock	0.1469	0.1498	0.1462	0.1487	99985800.0
2004-11-09 10:00:00	NVDA	Stock	0.1487	0.1491	0.1471	0.1477	139117560.0
2004-11-09 11:00:00	NVDA	Stock	0.1476	0.148	0.1469	0.1472	71991480.0
2004-11-09 12:00:00	NVDA	Stock	0.1472	0.1478	0.1471	0.1477	28039200.0
2004-11-09 13:00:00	NVDA	Stock	0.1477	0.148	0.1473	0.1478	31329600.0
2004-11-09 14:00:00	NVDA	Stock	0.1477	0.1487	0.1476	0.1482	66381240.0
2004-11-09 15:00:00	NVDA	Stock	0.1482	0.1483	0.1471	0.1474	127252560.0
2004-11-09 16:00:00	NVDA	Stock	0.1474	0.1477	0.1463	0.1473	2628600.0
2004-11-09 17:00:00	NVDA	Stock	0.1471	0.1477	0.1471	0.1477	517200.0
2004-11-09 08:00:00	AMZN	Stock	1.875	1.875	1.875	1.875	20000.0
2004-11-09 09:00:00	AMZN	Stock	1.871	1.8905	1.8445	1.8865	22404260.0
2004-11-09 10:00:00	AMZN	Stock	1.8865	1.8865	1.8385	1.8465	26111200.0
2004-11-09 11:00:00	AMZN	Stock	1.8465	1.868	1.835	1.863	16388360.0
2004-11-09 12:00:00	AMZN	Stock	1.864	1.8895	1.863	1.883	14077480.0
2004-11-09 13:00:00	AMZN	Stock	1.884	1.885	1.868	1.8775	11750260.0
2004-11-09 14:00:00	AMZN	Stock	1.877	1.881	1.8625	1.8725	12425340.0
2004-11-09 15:00:00	AMZN	Stock	1.871	1.8775	1.8625	1.8705	21146180.0
2004-11-09 16:00:00	AMZN	Stock	1.8705	1.8725	1.8675	1.8675	582700.0
2004-11-09 17:00:00	AMZN	Stock	1.8635	1.874	1.8635	1.874	385200.0
2004-11-09 18:00:00	AMZN	Stock	1.872	1.872	1.869	1.869	6000.0
2004-11-09 09:00:00	CL	Stock	23.365	23.49	23.35	23.455	586600.0
2004-11-09 10:00:00	CL	Stock	23.455	23.475	23.27	23.28	550000.0
2004-11-09 11:00:00	CL	Stock	23.28	23.32	23.24	23.255	552000.0
2004-11-09 12:00:00	CL	Stock	23.265	23.47	23.265	23.46	576200.0
2004-11-09 13:00:00	CL	Stock	23.47	23.48	23.32	23.345	419200.0
2004-11-09 14:00:00	CL	Stock	23.35	23.46	23.345	23.35	430400.0
2004-11-09 15:00:00	CL	Stock	23.345	23.375	23.29	23.365	844400.0

> showing 50 of 24,442 rows — these rows as CSV

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