PREVIEW / stock_1hour / 2007-03-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-03-16.parquet
  size:    689 KB
  rows:    32,183
  symbols: 2,534

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
2007-03-16 08:00:00	AAPL	Stock	3.2025	3.2029	3.1875	3.2014	1604148.0
2007-03-16 09:00:00	AAPL	Stock	3.2	3.2114	3.195	3.2057	151931080.0
2007-03-16 10:00:00	AAPL	Stock	3.2061	3.2139	3.2054	3.2125	74423552.0
2007-03-16 11:00:00	AAPL	Stock	3.2121	3.2121	3.1968	3.2004	64252160.0
2007-03-16 12:00:00	AAPL	Stock	3.2004	3.21	3.1982	3.2071	43633912.0
2007-03-16 13:00:00	AAPL	Stock	3.2071	3.2107	3.1993	3.2015	44399292.0
2007-03-16 14:00:00	AAPL	Stock	3.2018	3.2032	3.19	3.1964	55412728.0
2007-03-16 15:00:00	AAPL	Stock	3.1961	3.2018	3.1939	3.1989	66185224.0
2007-03-16 16:00:00	AAPL	Stock	3.1996	3.2021	3.1964	3.1982	26896632.0
2007-03-16 17:00:00	AAPL	Stock	3.1979	3.1982	3.1932	3.1964	202888.0
2007-03-16 18:00:00	AAPL	Stock	3.1964	3.2004	3.1914	3.1993	155288.0
2007-03-16 19:00:00	AAPL	Stock	3.1964	3.1989	3.1964	3.1989	50652.0
2007-03-16 08:00:00	MSFT	Stock	27.3	27.3	27.18	27.18	4262.0
2007-03-16 09:00:00	MSFT	Stock	27.23	27.5	27.22	27.34	25139908.0
2007-03-16 10:00:00	MSFT	Stock	27.34	27.48	27.33	27.38	7305956.0
2007-03-16 11:00:00	MSFT	Stock	27.39	27.39	27.2	27.32	6531959.0
2007-03-16 12:00:00	MSFT	Stock	27.32	27.36	27.27	27.339	3611544.0
2007-03-16 13:00:00	MSFT	Stock	27.34	27.42	27.3	27.39	3932016.0
2007-03-16 14:00:00	MSFT	Stock	27.4	27.48	27.31	27.4	4314153.0
2007-03-16 15:00:00	MSFT	Stock	27.4	27.42	27.31	27.31	10280840.0
2007-03-16 16:00:00	MSFT	Stock	27.31	27.34	27.31	27.33	653206.0
2007-03-16 17:00:00	MSFT	Stock	27.34	27.35	27.32	27.32	3300.0
2007-03-16 18:00:00	MSFT	Stock	27.291	27.31	27.29	27.29	18217.0
2007-03-16 19:00:00	MSFT	Stock	27.33	27.33	27.28	27.28	2639.0
2007-03-16 08:00:00	NVDA	Stock	0.477	0.477	0.475	0.475	1290000.0
2007-03-16 09:00:00	NVDA	Stock	0.475	0.4782	0.474	0.4747	149378820.0
2007-03-16 10:00:00	NVDA	Stock	0.4747	0.4775	0.4718	0.4722	81099060.0
2007-03-16 11:00:00	NVDA	Stock	0.4722	0.473	0.4692	0.472	62736060.0
2007-03-16 12:00:00	NVDA	Stock	0.4718	0.4738	0.4703	0.473	39348060.0
2007-03-16 13:00:00	NVDA	Stock	0.473	0.474	0.4718	0.4733	29824320.0
2007-03-16 14:00:00	NVDA	Stock	0.4733	0.4733	0.4692	0.4702	51331500.0
2007-03-16 15:00:00	NVDA	Stock	0.4702	0.4733	0.4697	0.4723	91099680.0
2007-03-16 16:00:00	NVDA	Stock	0.4725	0.4728	0.4722	0.4725	3101040.0
2007-03-16 17:00:00	NVDA	Stock	0.4725	0.4725	0.4725	0.4725	115500.0
2007-03-16 18:00:00	NVDA	Stock	0.4725	0.4725	0.4725	0.4725	12000.0
2007-03-16 19:00:00	NVDA	Stock	0.4717	0.4717	0.4717	0.4717	24000.0
2007-03-16 09:00:00	AMZN	Stock	1.886	1.8925	1.876	1.8785	28053300.0
2007-03-16 10:00:00	AMZN	Stock	1.8785	1.895	1.878	1.892	10467160.0
2007-03-16 11:00:00	AMZN	Stock	1.892	1.896	1.877	1.8875	12555360.0
2007-03-16 12:00:00	AMZN	Stock	1.887	1.8985	1.8865	1.8985	7712060.0
2007-03-16 13:00:00	AMZN	Stock	1.8985	1.904	1.8945	1.902	9307560.0
2007-03-16 14:00:00	AMZN	Stock	1.902	1.902	1.8775	1.8785	21320400.0
2007-03-16 15:00:00	AMZN	Stock	1.8785	1.8935	1.878	1.8925	35940940.0
2007-03-16 16:00:00	AMZN	Stock	1.8925	1.9025	1.8922	1.8925	448360.0
2007-03-16 17:00:00	AMZN	Stock	1.8925	1.8925	1.8925	1.8925	24000.0
2007-03-16 19:00:00	AMZN	Stock	1.8925	1.8925	1.8925	1.8925	15700.0
2007-03-16 09:00:00	CL	Stock	32.71	32.725	32.625	32.69	1942800.0
2007-03-16 10:00:00	CL	Stock	32.69	32.735	32.64	32.64	512800.0
2007-03-16 11:00:00	CL	Stock	32.64	32.68	32.4765	32.505	463400.0
2007-03-16 12:00:00	CL	Stock	32.505	32.555	32.475	32.505	327800.0

> showing 50 of 32,183 rows — these rows as CSV

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