PREVIEW / stock_1hour / 2007-05-04

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-04.parquet
  size:    707 KB
  rows:    33,701
  symbols: 2,702

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-05-04 09:00:00	AAPL	Stock	3.6	3.6111	3.5893	3.5986	52992828.0
2007-05-04 10:00:00	AAPL	Stock	3.5989	3.6286	3.5954	3.6054	85092084.0
2007-05-04 11:00:00	AAPL	Stock	3.6057	3.6104	3.6004	3.6057	44402036.0
2007-05-04 12:00:00	AAPL	Stock	3.6061	3.6096	3.5914	3.5936	61730116.0
2007-05-04 13:00:00	AAPL	Stock	3.5939	3.6018	3.5921	3.5968	41464724.0
2007-05-04 14:00:00	AAPL	Stock	3.5964	3.5982	3.5921	3.5961	28452144.0
2007-05-04 15:00:00	AAPL	Stock	3.5957	3.6021	3.595	3.6	47179664.0
2007-05-04 16:00:00	AAPL	Stock	3.6	3.6004	3.5993	3.6004	2830912.0
2007-05-04 09:00:00	MSFT	Stock	30.68	30.7	30.29	30.43	15395646.0
2007-05-04 10:00:00	MSFT	Stock	30.43	30.65	30.35	30.61	12892821.0
2007-05-04 11:00:00	MSFT	Stock	30.608	30.65	30.45	30.51	10226126.0
2007-05-04 12:00:00	MSFT	Stock	30.5	30.51	30.36	30.46	15994007.0
2007-05-04 13:00:00	MSFT	Stock	30.46	30.59	30.43	30.44	9770255.0
2007-05-04 14:00:00	MSFT	Stock	30.44	30.58	30.41	30.57	11331293.0
2007-05-04 15:00:00	MSFT	Stock	30.56	30.65	30.46	30.56	20326075.0
2007-05-04 16:00:00	MSFT	Stock	30.56	30.56	30.53	30.56	964082.0
2007-05-04 09:00:00	NVDA	Stock	0.56	0.563	0.5567	0.5585	30192720.0
2007-05-04 10:00:00	NVDA	Stock	0.5583	0.5607	0.5555	0.5593	85676640.0
2007-05-04 11:00:00	NVDA	Stock	0.5595	0.5647	0.559	0.5637	52876740.0
2007-05-04 12:00:00	NVDA	Stock	0.5635	0.5642	0.5592	0.5637	66544500.0
2007-05-04 13:00:00	NVDA	Stock	0.5637	0.5637	0.5583	0.5587	38725020.0
2007-05-04 14:00:00	NVDA	Stock	0.5587	0.5608	0.5568	0.5593	46789020.0
2007-05-04 15:00:00	NVDA	Stock	0.5592	0.563	0.5592	0.5618	68856120.0
2007-05-04 16:00:00	NVDA	Stock	0.5623	0.5625	0.5617	0.5617	117600.0
2007-05-04 17:00:00	NVDA	Stock	0.5623	0.5623	0.5623	0.5623	36000.0
2007-05-04 18:00:00	NVDA	Stock	0.5623	0.5623	0.5623	0.5623	24000.0
2007-05-04 19:00:00	NVDA	Stock	0.5623	0.5633	0.5623	0.5633	90900.0
2007-05-04 04:00:00	AMZN	Stock	3.1125	3.1125	3.1125	3.1125	2000.0
2007-05-04 05:00:00	AMZN	Stock	3.1125	3.1125	3.1125	3.1125	2000.0
2007-05-04 07:00:00	AMZN	Stock	3.1075	3.12	3.08	3.1135	63000.0
2007-05-04 08:00:00	AMZN	Stock	3.114	3.132	3.1095	3.1185	2019820.0
2007-05-04 09:00:00	AMZN	Stock	3.12	3.174	3.115	3.1654	49982140.0
2007-05-04 10:00:00	AMZN	Stock	3.1646	3.1875	3.1455	3.179	57671820.0
2007-05-04 11:00:00	AMZN	Stock	3.1785	3.1865	3.1645	3.1665	41076340.0
2007-05-04 12:00:00	AMZN	Stock	3.166	3.1705	3.136	3.1595	36536860.0
2007-05-04 13:00:00	AMZN	Stock	3.1595	3.1872	3.141	3.149	23308400.0
2007-05-04 14:00:00	AMZN	Stock	3.1485	3.187	3.141	3.146	21130800.0
2007-05-04 15:00:00	AMZN	Stock	3.1455	3.1665	3.1365	3.1645	44671860.0
2007-05-04 16:00:00	AMZN	Stock	3.1645	3.1715	3.162	3.1685	4885980.0
2007-05-04 17:00:00	AMZN	Stock	3.1685	3.1685	3.165	3.165	57700.0
2007-05-04 18:00:00	AMZN	Stock	3.1655	3.1655	3.1645	3.1645	133000.0
2007-05-04 19:00:00	AMZN	Stock	3.1655	3.1655	3.1615	3.1655	70800.0
2007-05-04 09:00:00	CL	Stock	33.75	33.8	33.62	33.775	412400.0
2007-05-04 10:00:00	CL	Stock	33.77	33.805	33.69	33.72	680044.0
2007-05-04 11:00:00	CL	Stock	33.72	33.765	33.71	33.74	886000.0
2007-05-04 12:00:00	CL	Stock	33.745	33.75	33.69	33.72	726000.0
2007-05-04 13:00:00	CL	Stock	33.725	33.785	33.685	33.755	454000.0
2007-05-04 14:00:00	CL	Stock	33.76	33.845	33.73	33.845	589206.0
2007-05-04 15:00:00	CL	Stock	33.84	34.095	33.765	34.06	1601046.0
2007-05-04 16:00:00	CL	Stock	34.06	34.075	34.04	34.075	86400.0

> showing 50 of 33,701 rows — these rows as CSV

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