PREVIEW / stock_1hour / 2008-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-10-27.parquet
  size:    789 KB
  rows:    40,240
  symbols: 3,335

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-10-27 07:00:00	AAPL	Stock	3.3536	3.3679	3.34	3.3679	256900.0
2008-10-27 08:00:00	AAPL	Stock	3.3711	3.4236	3.3425	3.4221	3247580.0
2008-10-27 09:00:00	AAPL	Stock	3.4204	3.4761	3.3929	3.4496	159604704.0
2008-10-27 10:00:00	AAPL	Stock	3.4489	3.4868	3.3661	3.4107	220594052.0
2008-10-27 11:00:00	AAPL	Stock	3.4107	3.4382	3.375	3.3982	145691224.0
2008-10-27 12:00:00	AAPL	Stock	3.3975	3.4643	3.3896	3.4618	134872612.0
2008-10-27 13:00:00	AAPL	Stock	3.4621	3.4743	3.425	3.4472	122496024.0
2008-10-27 14:00:00	AAPL	Stock	3.4482	3.46	3.3675	3.3729	148407280.0
2008-10-27 15:00:00	AAPL	Stock	3.3725	3.4125	3.2807	3.2893	233188396.0
2008-10-27 16:00:00	AAPL	Stock	3.2879	3.4106	3.2814	3.2861	20932156.0
2008-10-27 17:00:00	AAPL	Stock	3.2929	3.4671	3.2821	3.2854	9243388.0
2008-10-27 18:00:00	AAPL	Stock	3.2825	3.285	3.275	3.2786	562856.0
2008-10-27 19:00:00	AAPL	Stock	3.2786	3.2932	3.2786	3.2786	333872.0
2008-10-27 20:00:00	AAPL	Stock	3.3986	3.3986	3.3986	3.3986	51072.0
2008-10-27 08:00:00	MSFT	Stock	21.74	21.79	21.4	21.79	105710.0
2008-10-27 09:00:00	MSFT	Stock	21.8	21.98	21.26	21.419	10496956.0
2008-10-27 10:00:00	MSFT	Stock	21.42	21.67	21.12	21.3	15120696.0
2008-10-27 11:00:00	MSFT	Stock	21.29	21.41	21.03	21.158	12242822.0
2008-10-27 12:00:00	MSFT	Stock	21.15	21.5	21.12	21.5	12927857.0
2008-10-27 13:00:00	MSFT	Stock	21.495	21.9	21.31	21.85	12853302.0
2008-10-27 14:00:00	MSFT	Stock	21.85	21.92	21.35	21.36	13127262.0
2008-10-27 15:00:00	MSFT	Stock	21.37	21.96	21.02	21.17	30337227.0
2008-10-27 16:00:00	MSFT	Stock	21.16	21.642	21.02	21.13	7855941.0
2008-10-27 17:00:00	MSFT	Stock	21.15	21.41	21.08	21.08	74363.0
2008-10-27 18:00:00	MSFT	Stock	21.08	21.14	21.01	21.1	21889.0
2008-10-27 19:00:00	MSFT	Stock	21.08	21.11	21.04	21.08	19431.0
2008-10-27 20:00:00	MSFT	Stock	21.11	21.11	21.11	21.11	9370.0
2008-10-27 08:00:00	NVDA	Stock	0.1713	0.1713	0.1625	0.1625	77440.0
2008-10-27 09:00:00	NVDA	Stock	0.1642	0.168	0.159	0.1648	70221320.0
2008-10-27 10:00:00	NVDA	Stock	0.165	0.1678	0.1622	0.1655	80024840.0
2008-10-27 11:00:00	NVDA	Stock	0.1655	0.1713	0.165	0.1713	73225480.0
2008-10-27 12:00:00	NVDA	Stock	0.1713	0.1783	0.171	0.178	112772920.0
2008-10-27 13:00:00	NVDA	Stock	0.1778	0.184	0.1758	0.1838	125077880.0
2008-10-27 14:00:00	NVDA	Stock	0.1835	0.1845	0.1768	0.1768	85048440.0
2008-10-27 15:00:00	NVDA	Stock	0.1768	0.1798	0.174	0.1745	134062120.0
2008-10-27 16:00:00	NVDA	Stock	0.1745	0.1804	0.1728	0.1743	2662320.0
2008-10-27 17:00:00	NVDA	Stock	0.1748	0.1748	0.1728	0.1738	206320.0
2008-10-27 18:00:00	NVDA	Stock	0.1738	0.1743	0.1738	0.1738	124720.0
2008-10-27 19:00:00	NVDA	Stock	0.1743	0.175	0.1743	0.175	68000.0
2008-10-27 08:00:00	AMZN	Stock	2.4	2.4615	2.3745	2.451	352560.0
2008-10-27 09:00:00	AMZN	Stock	2.45	2.5385	2.4215	2.5095	27555620.0
2008-10-27 10:00:00	AMZN	Stock	2.513	2.5395	2.4361	2.5025	28580500.0
2008-10-27 11:00:00	AMZN	Stock	2.502	2.5542	2.485	2.5185	27234040.0
2008-10-27 12:00:00	AMZN	Stock	2.518	2.6075	2.5115	2.607	35106300.0
2008-10-27 13:00:00	AMZN	Stock	2.6045	2.625	2.5601	2.6095	26492480.0
2008-10-27 14:00:00	AMZN	Stock	2.61	2.6295	2.5475	2.56	37958960.0
2008-10-27 15:00:00	AMZN	Stock	2.56	2.606	2.475	2.479	43730640.0
2008-10-27 16:00:00	AMZN	Stock	2.4795	2.5812	2.4725	2.479	7028700.0
2008-10-27 17:00:00	AMZN	Stock	2.485	2.55	2.479	2.48	261600.0
2008-10-27 18:00:00	AMZN	Stock	2.48	2.5	2.475	2.475	123800.0

> showing 50 of 40,240 rows — these rows as CSV

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