PREVIEW / stock_1hour / 2007-08-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-08-03.parquet
  size:    794 KB
  rows:    38,803
  symbols: 3,117

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-08-03 09:00:00	AAPL	Stock	4.8307	4.8554	4.8054	4.8121	86638440.0
2007-08-03 10:00:00	AAPL	Stock	4.8129	4.834	4.7954	4.8114	98529536.0
2007-08-03 11:00:00	AAPL	Stock	4.81	4.8249	4.7964	4.8082	73983504.0
2007-08-03 12:00:00	AAPL	Stock	4.8082	4.8393	4.8082	4.8136	68963104.0
2007-08-03 13:00:00	AAPL	Stock	4.8143	4.8214	4.8071	4.8185	38767176.0
2007-08-03 14:00:00	AAPL	Stock	4.8182	4.8307	4.7679	4.7861	104652184.0
2007-08-03 15:00:00	AAPL	Stock	4.7868	4.79	4.6964	4.7011	143651256.0
2007-08-03 16:00:00	AAPL	Stock	4.7071	4.7089	4.7015	4.7089	15939084.0
2007-08-03 09:00:00	MSFT	Stock	29.45	29.78	29.41	29.58	3812921.0
2007-08-03 10:00:00	MSFT	Stock	29.58	29.75	29.421	29.49	6951685.0
2007-08-03 11:00:00	MSFT	Stock	29.49	29.63	29.45	29.56	5720468.0
2007-08-03 12:00:00	MSFT	Stock	29.56	29.66	29.39	29.44	6587367.0
2007-08-03 13:00:00	MSFT	Stock	29.44	29.44	29.32	29.35	4508054.0
2007-08-03 14:00:00	MSFT	Stock	29.355	29.43	29.13	29.213	10291674.0
2007-08-03 15:00:00	MSFT	Stock	29.22	29.24	28.9	28.9	15852068.0
2007-08-03 16:00:00	MSFT	Stock	28.9	28.96	28.9	28.96	2647855.0
2007-08-03 09:00:00	NVDA	Stock	0.7537	0.7587	0.7345	0.7402	46493160.0
2007-08-03 10:00:00	NVDA	Stock	0.7402	0.7427	0.7287	0.734	90340860.0
2007-08-03 11:00:00	NVDA	Stock	0.7337	0.7362	0.7292	0.7347	73936500.0
2007-08-03 12:00:00	NVDA	Stock	0.7345	0.7365	0.7228	0.7237	83120520.0
2007-08-03 13:00:00	NVDA	Stock	0.7238	0.7273	0.7218	0.7253	58042860.0
2007-08-03 14:00:00	NVDA	Stock	0.7255	0.7272	0.7175	0.7178	83689680.0
2007-08-03 15:00:00	NVDA	Stock	0.718	0.721	0.7087	0.7092	165978600.0
2007-08-03 16:00:00	NVDA	Stock	0.7085	0.7142	0.7075	0.7107	2735100.0
2007-08-03 17:00:00	NVDA	Stock	0.7115	0.7125	0.7115	0.7123	64260.0
2007-08-03 18:00:00	NVDA	Stock	0.71	0.71	0.7097	0.7097	66000.0
2007-08-03 19:00:00	NVDA	Stock	0.7097	0.7097	0.7097	0.7097	10800.0
2007-08-03 07:00:00	AMZN	Stock	3.9975	4.025	3.9975	4.02	34000.0
2007-08-03 08:00:00	AMZN	Stock	4.0105	4.0125	3.955	3.97	346740.0
2007-08-03 09:00:00	AMZN	Stock	3.9725	4.0375	3.9115	3.9156	26706340.0
2007-08-03 10:00:00	AMZN	Stock	3.9164	3.9315	3.881	3.9	25984920.0
2007-08-03 11:00:00	AMZN	Stock	3.9015	3.9195	3.889	3.915	16565020.0
2007-08-03 12:00:00	AMZN	Stock	3.9155	3.943	3.907	3.9135	15767500.0
2007-08-03 13:00:00	AMZN	Stock	3.914	3.9375	3.8945	3.93	10362020.0
2007-08-03 14:00:00	AMZN	Stock	3.931	3.9415	3.8625	3.873	19588100.0
2007-08-03 15:00:00	AMZN	Stock	3.875	3.884	3.8355	3.8355	34634520.0
2007-08-03 16:00:00	AMZN	Stock	3.8366	3.85	3.831	3.844	4403620.0
2007-08-03 17:00:00	AMZN	Stock	3.8425	3.8525	3.8355	3.8425	889100.0
2007-08-03 18:00:00	AMZN	Stock	3.84	3.84	3.84	3.84	10000.0
2007-08-03 19:00:00	AMZN	Stock	3.841	3.841	3.841	3.841	10000.0
2007-08-03 09:00:00	TLT	Stock	87.28	87.46	87.28	87.46	440100.0
2007-08-03 10:00:00	TLT	Stock	87.46	87.65	87.46	87.59	202900.0
2007-08-03 11:00:00	TLT	Stock	87.61	87.69	87.53	87.61	364401.0
2007-08-03 12:00:00	TLT	Stock	87.62	87.66	87.46	87.58	40000.0
2007-08-03 13:00:00	TLT	Stock	87.58	87.71	87.58	87.65	53100.0
2007-08-03 14:00:00	TLT	Stock	87.64	87.87	87.63	87.81	186896.0
2007-08-03 15:00:00	TLT	Stock	87.82	87.89	87.78	87.89	117000.0
2007-08-03 16:00:00	TLT	Stock	87.9	87.93	87.87	87.93	14000.0
2007-08-03 09:00:00	CL	Stock	33.95	33.95	33.425	33.5	870200.0
2007-08-03 10:00:00	CL	Stock	33.5	33.51	33.315	33.485	1243000.0

> showing 50 of 38,803 rows — these rows as CSV

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