PREVIEW / stock_1hour / 2007-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-14.parquet
  size:    810 KB
  rows:    40,410
  symbols: 3,204

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-11-14 04:00:00	AAPL	Stock	6.2321	6.2321	6.2107	6.2107	13888.0
2007-11-14 05:00:00	AAPL	Stock	6.2214	6.2496	6.2161	6.22	137424.0
2007-11-14 06:00:00	AAPL	Stock	6.2339	6.2375	6.1982	6.2089	360864.0
2007-11-14 07:00:00	AAPL	Stock	6.1982	6.1982	6.1111	6.1607	1937096.0
2007-11-14 08:00:00	AAPL	Stock	6.1607	6.2875	6.1279	6.2725	29562092.0
2007-11-14 09:00:00	AAPL	Stock	6.2746	6.3418	6.1861	6.2086	270389252.0
2007-11-14 10:00:00	AAPL	Stock	6.2079	6.2814	6.1904	6.2277	221241720.0
2007-11-14 11:00:00	AAPL	Stock	6.2264	6.2411	6.1171	6.1693	196338184.0
2007-11-14 12:00:00	AAPL	Stock	6.17	6.2429	6.1518	6.1639	117787376.0
2007-11-14 13:00:00	AAPL	Stock	6.1629	6.2118	6.1379	6.1386	92978956.0
2007-11-14 14:00:00	AAPL	Stock	6.1393	6.1668	5.9943	6.0011	172226460.0
2007-11-14 15:00:00	AAPL	Stock	6.0011	6.0625	5.8479	5.9318	321916924.0
2007-11-14 16:00:00	AAPL	Stock	5.9321	6.1449	5.9204	5.9639	21697844.0
2007-11-14 17:00:00	AAPL	Stock	5.9325	6.0947	5.9146	5.9286	3450580.0
2007-11-14 18:00:00	AAPL	Stock	5.915	5.955	5.9143	5.9411	1198876.0
2007-11-14 19:00:00	AAPL	Stock	5.9411	5.9554	5.9329	5.9464	287784.0
2007-11-14 08:00:00	MSFT	Stock	34.37	34.8	34.37	34.67	111406.0
2007-11-14 09:00:00	MSFT	Stock	34.67	34.75	34.13	34.199	12159532.0
2007-11-14 10:00:00	MSFT	Stock	34.2	34.41	34.19	34.23	9884985.0
2007-11-14 11:00:00	MSFT	Stock	34.22	34.23	33.83	33.931	13471102.0
2007-11-14 12:00:00	MSFT	Stock	33.94	34.12	33.93	33.99	6540702.0
2007-11-14 13:00:00	MSFT	Stock	33.99	34.17	33.95	33.97	7670755.0
2007-11-14 14:00:00	MSFT	Stock	33.97	34.06	33.95	33.95	6240261.0
2007-11-14 15:00:00	MSFT	Stock	33.95	34.12	33.75	33.93	23104617.0
2007-11-14 16:00:00	MSFT	Stock	33.92	34.095	33.9	33.93	4878566.0
2007-11-14 17:00:00	MSFT	Stock	33.93	34.46	33.92	33.92	551371.0
2007-11-14 18:00:00	MSFT	Stock	33.93	34.0	33.92	33.99	218477.0
2007-11-14 19:00:00	MSFT	Stock	33.99	33.99	33.91	33.91	4030.0
2007-11-14 07:00:00	NVDA	Stock	0.8175	0.8175	0.8175	0.8175	4000.0
2007-11-14 08:00:00	NVDA	Stock	0.8262	0.837	0.8158	0.8335	2022800.0
2007-11-14 09:00:00	NVDA	Stock	0.8338	0.8458	0.825	0.826	96543520.0
2007-11-14 10:00:00	NVDA	Stock	0.826	0.838	0.8162	0.8172	101517160.0
2007-11-14 11:00:00	NVDA	Stock	0.8175	0.826	0.808	0.8208	63746080.0
2007-11-14 12:00:00	NVDA	Stock	0.8208	0.8278	0.8205	0.827	49860920.0
2007-11-14 13:00:00	NVDA	Stock	0.827	0.8325	0.8262	0.827	64910280.0
2007-11-14 14:00:00	NVDA	Stock	0.827	0.832	0.823	0.8283	84606200.0
2007-11-14 15:00:00	NVDA	Stock	0.8283	0.8292	0.8	0.806	179764000.0
2007-11-14 16:00:00	NVDA	Stock	0.8045	0.8232	0.8043	0.8043	11921880.0
2007-11-14 17:00:00	NVDA	Stock	0.8043	0.8226	0.8043	0.8043	5553160.0
2007-11-14 18:00:00	NVDA	Stock	0.8043	0.8043	0.8043	0.8043	11000.0
2007-11-14 19:00:00	NVDA	Stock	0.806	0.806	0.8038	0.8038	20000.0
2007-11-14 07:00:00	AMZN	Stock	3.9925	4.025	3.9925	4.025	24000.0
2007-11-14 08:00:00	AMZN	Stock	3.9995	4.0695	3.9785	4.058	350540.0
2007-11-14 09:00:00	AMZN	Stock	4.0595	4.0635	3.9825	3.99	26035260.0
2007-11-14 10:00:00	AMZN	Stock	3.9915	4.0195	3.954	3.9975	26083560.0
2007-11-14 11:00:00	AMZN	Stock	3.9975	4.011	3.942	3.9815	18945440.0
2007-11-14 12:00:00	AMZN	Stock	3.9815	4.016	3.9705	4.0065	12190960.0
2007-11-14 13:00:00	AMZN	Stock	4.0055	4.0295	3.99	3.9915	16758020.0
2007-11-14 14:00:00	AMZN	Stock	3.9925	4.0215	3.9818	3.999	18432820.0
2007-11-14 15:00:00	AMZN	Stock	4.0005	4.012	3.9075	3.928	38245400.0

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

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