PREVIEW / stock_1hour / 2008-07-16

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-07-16.parquet
  size:    840 KB
  rows:    40,776
  symbols: 3,356

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-07-16 06:00:00	AAPL	Stock	6.0736	6.0736	6.0039	6.0039	19292.0
2008-07-16 07:00:00	AAPL	Stock	6.005	6.0786	6.005	6.0786	111300.0
2008-07-16 08:00:00	AAPL	Stock	6.0714	6.1225	6.0711	6.1	3208576.0
2008-07-16 09:00:00	AAPL	Stock	6.1018	6.1143	6.0214	6.0782	107316860.0
2008-07-16 10:00:00	AAPL	Stock	6.0786	6.1354	6.0536	6.0889	129463124.0
2008-07-16 11:00:00	AAPL	Stock	6.0879	6.1175	6.045	6.0811	105100436.0
2008-07-16 12:00:00	AAPL	Stock	6.0816	6.1021	6.045	6.1011	74956504.0
2008-07-16 13:00:00	AAPL	Stock	6.1014	6.1089	6.0668	6.0986	74404400.0
2008-07-16 14:00:00	AAPL	Stock	6.0995	6.1607	6.0761	6.1564	116474652.0
2008-07-16 15:00:00	AAPL	Stock	6.1571	6.1761	6.1382	6.1689	106994468.0
2008-07-16 16:00:00	AAPL	Stock	6.1689	6.1718	6.0586	6.1536	17647308.0
2008-07-16 17:00:00	AAPL	Stock	6.1589	6.1723	6.1479	6.1582	153384.0
2008-07-16 18:00:00	AAPL	Stock	6.1586	6.1607	6.15	6.1554	123564.0
2008-07-16 19:00:00	AAPL	Stock	6.1604	6.1607	6.1504	6.1571	107408.0
2008-07-16 20:00:00	AAPL	Stock	6.0746	6.0746	6.0746	6.0746	53200.0
2008-07-16 07:00:00	MSFT	Stock	25.7	25.7	25.7	25.7	200.0
2008-07-16 08:00:00	MSFT	Stock	26.14	26.38	26.14	26.3	13730.0
2008-07-16 09:00:00	MSFT	Stock	26.33	26.36	26.01	26.31	7899761.0
2008-07-16 10:00:00	MSFT	Stock	26.31	26.48	25.92	26.46	11654665.0
2008-07-16 11:00:00	MSFT	Stock	26.46	26.63	26.33	26.46	7651670.0
2008-07-16 12:00:00	MSFT	Stock	26.47	26.67	26.41	26.65	5745749.0
2008-07-16 13:00:00	MSFT	Stock	26.65	27.04	26.64	27.04	10296611.0
2008-07-16 14:00:00	MSFT	Stock	27.04	27.25	26.95	27.18	13528894.0
2008-07-16 15:00:00	MSFT	Stock	27.17	27.29	27.105	27.28	16343613.0
2008-07-16 16:00:00	MSFT	Stock	27.26	27.28	26.15	27.15	5904119.0
2008-07-16 17:00:00	MSFT	Stock	26.698	27.32	26.698	27.32	39821.0
2008-07-16 18:00:00	MSFT	Stock	27.34	27.34	27.27	27.27	9425.0
2008-07-16 19:00:00	MSFT	Stock	27.27	27.28	27.26	27.27	3900.0
2008-07-16 07:00:00	NVDA	Stock	0.2838	0.2838	0.278	0.278	8000.0
2008-07-16 08:00:00	NVDA	Stock	0.2848	0.285	0.28	0.28	161840.0
2008-07-16 09:00:00	NVDA	Stock	0.2812	0.2848	0.2755	0.2808	77635520.0
2008-07-16 10:00:00	NVDA	Stock	0.2808	0.2815	0.2748	0.2798	137057920.0
2008-07-16 11:00:00	NVDA	Stock	0.2798	0.284	0.279	0.2835	136234560.0
2008-07-16 12:00:00	NVDA	Stock	0.2835	0.2868	0.2818	0.2862	117739080.0
2008-07-16 13:00:00	NVDA	Stock	0.2862	0.2905	0.2835	0.284	88758600.0
2008-07-16 14:00:00	NVDA	Stock	0.284	0.2848	0.2815	0.2832	172124760.0
2008-07-16 15:00:00	NVDA	Stock	0.283	0.285	0.2818	0.2832	231903000.0
2008-07-16 16:00:00	NVDA	Stock	0.2832	0.284	0.2815	0.2825	49551360.0
2008-07-16 17:00:00	NVDA	Stock	0.2821	0.2835	0.2821	0.2835	1327320.0
2008-07-16 19:00:00	NVDA	Stock	0.2835	0.2835	0.2835	0.2835	88000.0
2008-07-16 08:00:00	AMZN	Stock	3.4	3.4	3.3515	3.365	43460.0
2008-07-16 09:00:00	AMZN	Stock	3.365	3.442	3.342	3.437	13184000.0
2008-07-16 10:00:00	AMZN	Stock	3.437	3.5455	3.395	3.5435	33880280.0
2008-07-16 11:00:00	AMZN	Stock	3.544	3.6195	3.54	3.583	42161080.0
2008-07-16 12:00:00	AMZN	Stock	3.5825	3.6045	3.5645	3.5955	20247300.0
2008-07-16 13:00:00	AMZN	Stock	3.5945	3.615	3.584	3.613	18071200.0
2008-07-16 14:00:00	AMZN	Stock	3.612	3.6375	3.606	3.63	37184060.0
2008-07-16 15:00:00	AMZN	Stock	3.628	3.635	3.583	3.5975	51269000.0
2008-07-16 16:00:00	AMZN	Stock	3.6085	3.6245	3.3515	3.55	5635980.0
2008-07-16 17:00:00	AMZN	Stock	3.5595	3.6106	3.55	3.5625	1080160.0

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

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