PREVIEW / stock_1hour / 2008-11-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-11-20.parquet
  size:    820 KB
  rows:    41,952
  symbols: 3,397

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
2008-11-20 04:00:00	AAPL	Stock	3.0739	3.0739	3.0361	3.0361	11200.0
2008-11-20 06:00:00	AAPL	Stock	3.0161	3.0161	3.0161	3.0161	2800.0
2008-11-20 07:00:00	AAPL	Stock	3.0532	3.1054	3.0532	3.1054	428932.0
2008-11-20 08:00:00	AAPL	Stock	3.0968	3.1064	3.0214	3.0393	2547692.0
2008-11-20 09:00:00	AAPL	Stock	3.0411	3.0679	2.985	3.0	162650628.0
2008-11-20 10:00:00	AAPL	Stock	3.0	3.065	2.8571	3.0375	338028656.0
2008-11-20 11:00:00	AAPL	Stock	3.0361	3.0557	2.9932	3.0196	227910900.0
2008-11-20 12:00:00	AAPL	Stock	3.0193	3.0875	2.9896	3.0407	209296472.0
2008-11-20 13:00:00	AAPL	Stock	3.0407	3.05	2.9618	3.0254	186047064.0
2008-11-20 14:00:00	AAPL	Stock	3.025	3.0346	2.9236	2.9361	200612412.0
2008-11-20 15:00:00	AAPL	Stock	2.9364	2.9564	2.8657	2.875	343110712.0
2008-11-20 16:00:00	AAPL	Stock	2.875	2.9874	2.8657	2.8882	29087968.0
2008-11-20 17:00:00	AAPL	Stock	2.8857	2.8911	2.87	2.87	961940.0
2008-11-20 18:00:00	AAPL	Stock	2.87	2.8846	2.8679	2.8768	441196.0
2008-11-20 19:00:00	AAPL	Stock	2.8764	2.8854	2.8754	2.8854	523572.0
2008-11-20 07:00:00	MSFT	Stock	18.25	18.5	18.22	18.22	1874.0
2008-11-20 08:00:00	MSFT	Stock	18.3	18.4	18.05	18.06	88425.0
2008-11-20 09:00:00	MSFT	Stock	18.11	18.55	18.06	18.14	11973043.0
2008-11-20 10:00:00	MSFT	Stock	18.13	18.55	18.0	18.54	22274241.0
2008-11-20 11:00:00	MSFT	Stock	18.55	18.84	18.2	18.22	17290344.0
2008-11-20 12:00:00	MSFT	Stock	18.21	18.73	18.07	18.49	15791391.0
2008-11-20 13:00:00	MSFT	Stock	18.49	18.61	18.15	18.58	14345164.0
2008-11-20 14:00:00	MSFT	Stock	18.588	18.64	18.08	18.2	13540247.0
2008-11-20 15:00:00	MSFT	Stock	18.19	18.27	17.5	17.54	36707535.0
2008-11-20 16:00:00	MSFT	Stock	17.54	18.44	17.52	17.75	5913021.0
2008-11-20 17:00:00	MSFT	Stock	17.71	18.191	17.516	17.69	33881.0
2008-11-20 18:00:00	MSFT	Stock	17.7	17.8	17.6	17.75	38693.0
2008-11-20 19:00:00	MSFT	Stock	17.7	17.75	17.65	17.75	15929.0
2008-11-20 08:00:00	NVDA	Stock	0.1538	0.1548	0.1528	0.1545	192000.0
2008-11-20 09:00:00	NVDA	Stock	0.1545	0.1552	0.1498	0.1508	68104920.0
2008-11-20 10:00:00	NVDA	Stock	0.1505	0.1622	0.1475	0.1588	152145400.0
2008-11-20 11:00:00	NVDA	Stock	0.159	0.1598	0.1545	0.1552	88137280.0
2008-11-20 12:00:00	NVDA	Stock	0.1552	0.1612	0.1538	0.1588	82616600.0
2008-11-20 13:00:00	NVDA	Stock	0.159	0.159	0.1537	0.1575	71343000.0
2008-11-20 14:00:00	NVDA	Stock	0.1575	0.1575	0.1502	0.1512	116036040.0
2008-11-20 15:00:00	NVDA	Stock	0.151	0.1578	0.1458	0.1482	215904000.0
2008-11-20 16:00:00	NVDA	Stock	0.148	0.1575	0.1455	0.146	21202880.0
2008-11-20 17:00:00	NVDA	Stock	0.146	0.1488	0.1458	0.1475	451200.0
2008-11-20 18:00:00	NVDA	Stock	0.1482	0.1495	0.1482	0.1495	48000.0
2008-11-20 19:00:00	NVDA	Stock	0.1495	0.1495	0.1462	0.1495	68000.0
2008-11-20 06:00:00	AMZN	Stock	1.792	1.85	1.792	1.85	7100.0
2008-11-20 08:00:00	AMZN	Stock	1.7995	1.8	1.763	1.763	153960.0
2008-11-20 09:00:00	AMZN	Stock	1.763	1.895	1.756	1.8825	42225360.0
2008-11-20 10:00:00	AMZN	Stock	1.883	1.986	1.817	1.9415	78815580.0
2008-11-20 11:00:00	AMZN	Stock	1.9415	1.9495	1.87	1.8965	45773640.0
2008-11-20 12:00:00	AMZN	Stock	1.8965	1.971	1.858	1.956	39823940.0
2008-11-20 13:00:00	AMZN	Stock	1.954	1.9545	1.895	1.9435	30432120.0
2008-11-20 14:00:00	AMZN	Stock	1.942	1.956	1.8575	1.867	35031480.0
2008-11-20 15:00:00	AMZN	Stock	1.867	1.8855	1.734	1.752	81958520.0
2008-11-20 16:00:00	AMZN	Stock	1.752	1.8722	1.751	1.773	8195140.0

> showing 50 of 41,952 rows — these rows as CSV

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