PREVIEW / stock_1hour / 2007-04-25

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-25.parquet
  size:    699 KB
  rows:    32,579
  symbols: 2,601

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-04-25 06:00:00	AAPL	Stock	3.3604	3.3604	3.3604	3.3604	2800.0
2007-04-25 07:00:00	AAPL	Stock	3.3604	3.3729	3.3604	3.3629	508760.0
2007-04-25 08:00:00	AAPL	Stock	3.3632	3.3786	3.3575	3.3625	3650332.0
2007-04-25 09:00:00	AAPL	Stock	3.3639	3.3821	3.35	3.3603	102175584.0
2007-04-25 10:00:00	AAPL	Stock	3.36	3.3711	3.3532	3.3611	99592108.0
2007-04-25 11:00:00	AAPL	Stock	3.3614	3.3689	3.3604	3.3675	75603612.0
2007-04-25 12:00:00	AAPL	Stock	3.3675	3.3871	3.3661	3.3871	93006956.0
2007-04-25 13:00:00	AAPL	Stock	3.3871	3.4007	3.3829	3.3896	109512620.0
2007-04-25 14:00:00	AAPL	Stock	3.3896	3.3925	3.3796	3.3896	137797352.0
2007-04-25 15:00:00	AAPL	Stock	3.3896	3.4071	3.385	3.4039	208206684.0
2007-04-25 16:00:00	AAPL	Stock	3.4039	3.7093	3.3482	3.6736	273812476.0
2007-04-25 17:00:00	AAPL	Stock	3.6736	3.6786	3.5714	3.6143	89059656.0
2007-04-25 18:00:00	AAPL	Stock	3.6157	3.6339	3.6143	3.6311	15482796.0
2007-04-25 19:00:00	AAPL	Stock	3.6314	3.6604	3.6289	3.6571	8886220.0
2007-04-25 08:00:00	MSFT	Stock	28.82	28.88	28.79	28.87	935997.0
2007-04-25 09:00:00	MSFT	Stock	28.86	28.89	28.72	28.8	6367793.0
2007-04-25 10:00:00	MSFT	Stock	28.79	28.858	28.7	28.74	5196342.0
2007-04-25 11:00:00	MSFT	Stock	28.74	28.79	28.69	28.76	4188020.0
2007-04-25 12:00:00	MSFT	Stock	28.75	28.81	28.72	28.73	2584126.0
2007-04-25 13:00:00	MSFT	Stock	28.72	28.95	28.71	28.91	3904438.0
2007-04-25 14:00:00	MSFT	Stock	28.91	29.0	28.87	28.96	4117409.0
2007-04-25 15:00:00	MSFT	Stock	28.96	29.0	28.89	28.99	9627978.0
2007-04-25 16:00:00	MSFT	Stock	28.99	29.0	28.99	28.99	1097335.0
2007-04-25 09:00:00	NVDA	Stock	0.5458	0.5548	0.5417	0.5438	63501780.0
2007-04-25 10:00:00	NVDA	Stock	0.5438	0.5465	0.5392	0.5432	94404060.0
2007-04-25 11:00:00	NVDA	Stock	0.543	0.5493	0.543	0.5488	51332220.0
2007-04-25 12:00:00	NVDA	Stock	0.5486	0.5508	0.5475	0.5487	41803020.0
2007-04-25 13:00:00	NVDA	Stock	0.5487	0.5517	0.5487	0.5515	41910180.0
2007-04-25 14:00:00	NVDA	Stock	0.5513	0.5547	0.5497	0.5542	72745740.0
2007-04-25 15:00:00	NVDA	Stock	0.5543	0.5547	0.5507	0.5522	115756500.0
2007-04-25 16:00:00	NVDA	Stock	0.5518	0.5533	0.55	0.5533	8287500.0
2007-04-25 17:00:00	NVDA	Stock	0.5533	0.555	0.5518	0.5518	415800.0
2007-04-25 04:00:00	AMZN	Stock	2.5165	2.5235	2.5	2.5235	78580.0
2007-04-25 06:00:00	AMZN	Stock	2.509	2.525	2.509	2.5175	245520.0
2007-04-25 07:00:00	AMZN	Stock	2.5175	2.63	2.5175	2.5945	19819500.0
2007-04-25 08:00:00	AMZN	Stock	2.594	2.644	2.5665	2.643	63526900.0
2007-04-25 09:00:00	AMZN	Stock	2.643	2.6995	2.6305	2.67	391832280.0
2007-04-25 10:00:00	AMZN	Stock	2.671	2.7325	2.6625	2.723	336952060.0
2007-04-25 11:00:00	AMZN	Stock	2.7235	2.763	2.7125	2.742	268863540.0
2007-04-25 12:00:00	AMZN	Stock	2.7415	2.7835	2.733	2.777	196686480.0
2007-04-25 13:00:00	AMZN	Stock	2.7765	2.859	2.774	2.824	353862620.0
2007-04-25 14:00:00	AMZN	Stock	2.8245	2.844	2.8015	2.816	200212380.0
2007-04-25 15:00:00	AMZN	Stock	2.8165	2.8445	2.8005	2.84	237891240.0
2007-04-25 16:00:00	AMZN	Stock	2.837	2.8565	2.837	2.854	10673800.0
2007-04-25 17:00:00	AMZN	Stock	2.853	2.854	2.8405	2.8425	1193880.0
2007-04-25 18:00:00	AMZN	Stock	2.845	2.852	2.8425	2.8425	860960.0
2007-04-25 19:00:00	AMZN	Stock	2.85	2.855	2.845	2.852	400580.0
2007-04-25 07:00:00	CL	Stock	34.25	34.25	34.25	34.25	600.0
2007-04-25 08:00:00	CL	Stock	34.25	34.25	34.25	34.25	200.0
2007-04-25 09:00:00	CL	Stock	34.25	34.495	33.54	33.796	867000.0

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

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