PREVIEW / stock_1hour / 2007-09-06

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-09-06.parquet
  size:    749 KB
  rows:    37,293
  symbols: 3,108

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-09-06 09:00:00	AAPL	Stock	4.8414	4.8707	4.75	4.7561	317490796.0
2007-09-06 10:00:00	AAPL	Stock	4.7568	4.8229	4.7396	4.8096	330953644.0
2007-09-06 11:00:00	AAPL	Stock	4.81	4.8104	4.7768	4.8032	180829208.0
2007-09-06 12:00:00	AAPL	Stock	4.8032	4.8571	4.7946	4.8179	199794336.0
2007-09-06 13:00:00	AAPL	Stock	4.8182	4.8382	4.8004	4.8268	105673064.0
2007-09-06 14:00:00	AAPL	Stock	4.8264	4.8686	4.81	4.8657	140479808.0
2007-09-06 15:00:00	AAPL	Stock	4.8657	4.9132	4.7857	4.8214	442068172.0
2007-09-06 16:00:00	AAPL	Stock	4.8214	4.8218	4.8214	4.8218	6182988.0
2007-09-06 09:00:00	MSFT	Stock	28.56	28.725	28.55	28.72	3140202.0
2007-09-06 10:00:00	MSFT	Stock	28.72	28.81	28.68	28.79	7327252.0
2007-09-06 11:00:00	MSFT	Stock	28.8	28.93	28.77	28.901	4755796.0
2007-09-06 12:00:00	MSFT	Stock	28.91	28.95	28.83	28.92	3681230.0
2007-09-06 13:00:00	MSFT	Stock	28.92	28.96	28.89	28.95	4217423.0
2007-09-06 14:00:00	MSFT	Stock	28.95	29.01	28.91	28.96	5294512.0
2007-09-06 15:00:00	MSFT	Stock	28.96	28.99	28.86	28.91	8666800.0
2007-09-06 16:00:00	MSFT	Stock	28.93	28.93	28.91	28.91	1409801.0
2007-09-06 08:00:00	NVDA	Stock	0.8763	0.885	0.8763	0.8833	181800.0
2007-09-06 09:00:00	NVDA	Stock	0.8817	0.8912	0.8807	0.8842	49633680.0
2007-09-06 10:00:00	NVDA	Stock	0.8843	0.885	0.8767	0.8813	83286120.0
2007-09-06 11:00:00	NVDA	Stock	0.8813	0.8848	0.8747	0.8825	65480760.0
2007-09-06 12:00:00	NVDA	Stock	0.8825	0.8853	0.8802	0.8835	35443800.0
2007-09-06 13:00:00	NVDA	Stock	0.8835	0.8843	0.877	0.8828	38858760.0
2007-09-06 14:00:00	NVDA	Stock	0.883	0.8832	0.8728	0.8734	45201360.0
2007-09-06 15:00:00	NVDA	Stock	0.8735	0.8772	0.8725	0.8758	66795360.0
2007-09-06 16:00:00	NVDA	Stock	0.8758	0.8854	0.8742	0.8854	7719720.0
2007-09-06 17:00:00	NVDA	Stock	0.875	0.8762	0.8728	0.8762	26220.0
2007-09-06 19:00:00	NVDA	Stock	0.8763	0.8765	0.8742	0.8765	58200.0
2007-09-06 06:00:00	AMZN	Stock	4.15	4.155	4.15	4.155	10000.0
2007-09-06 08:00:00	AMZN	Stock	4.1625	4.19	4.1625	4.19	117760.0
2007-09-06 09:00:00	AMZN	Stock	4.198	4.2475	4.198	4.2219	24083960.0
2007-09-06 10:00:00	AMZN	Stock	4.222	4.236	4.1425	4.2265	41411400.0
2007-09-06 11:00:00	AMZN	Stock	4.2275	4.2725	4.2075	4.2645	22341920.0
2007-09-06 12:00:00	AMZN	Stock	4.2655	4.2725	4.235	4.2465	16031180.0
2007-09-06 13:00:00	AMZN	Stock	4.2485	4.2665	4.226	4.2615	12531620.0
2007-09-06 14:00:00	AMZN	Stock	4.261	4.2655	4.231	4.2655	13044500.0
2007-09-06 15:00:00	AMZN	Stock	4.2665	4.323	4.262	4.311	36120660.0
2007-09-06 16:00:00	AMZN	Stock	4.3175	4.3185	4.233	4.3105	1025600.0
2007-09-06 17:00:00	AMZN	Stock	4.305	4.31	4.305	4.309	14000.0
2007-09-06 18:00:00	AMZN	Stock	4.306	4.306	4.303	4.303	6000.0
2007-09-06 19:00:00	AMZN	Stock	4.3105	4.3105	4.2975	4.2975	221400.0
2007-09-06 09:00:00	TLT	Stock	89.31	89.45	89.23	89.43	56300.0
2007-09-06 10:00:00	TLT	Stock	89.4	89.49	89.35	89.44	230599.0
2007-09-06 11:00:00	TLT	Stock	89.41	89.45	89.24	89.28	156600.0
2007-09-06 12:00:00	TLT	Stock	89.28	89.37	89.09	89.13	264700.0
2007-09-06 13:00:00	TLT	Stock	89.14	89.2	88.97	88.97	228600.0
2007-09-06 14:00:00	TLT	Stock	88.95	89.11	88.95	89.09	41400.0
2007-09-06 15:00:00	TLT	Stock	89.09	89.12	89.02	89.07	582500.0
2007-09-06 16:00:00	TLT	Stock	89.07	89.08	89.03	89.04	104400.0
2007-09-06 09:00:00	CL	Stock	32.465	32.935	32.465	32.79	193200.0
2007-09-06 10:00:00	CL	Stock	32.8	32.875	32.675	32.865	463000.0

> showing 50 of 37,293 rows — these rows as CSV

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