PREVIEW / stock_1hour / 2008-01-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-01-04.parquet
  size:    833 KB
  rows:    41,254
  symbols: 3,260

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
2008-01-04 04:00:00	AAPL	Stock	6.9957	6.9993	6.9814	6.9993	42000.0
2008-01-04 05:00:00	AAPL	Stock	7.0211	7.0482	7.0211	7.0471	67200.0
2008-01-04 06:00:00	AAPL	Stock	7.0375	7.0375	7.0268	7.035	62692.0
2008-01-04 07:00:00	AAPL	Stock	7.0179	7.0179	6.9946	6.9946	290640.0
2008-01-04 08:00:00	AAPL	Stock	6.9946	6.9996	6.8214	6.8321	13650112.0
2008-01-04 09:00:00	AAPL	Stock	6.8375	6.8929	6.7629	6.8289	179232816.0
2008-01-04 10:00:00	AAPL	Stock	6.8291	6.8446	6.7357	6.7518	195361124.0
2008-01-04 11:00:00	AAPL	Stock	6.7507	6.7771	6.7143	6.7446	163734200.0
2008-01-04 12:00:00	AAPL	Stock	6.7446	6.7821	6.7143	6.7211	103130328.0
2008-01-04 13:00:00	AAPL	Stock	6.7204	6.7214	6.6607	6.6961	139141940.0
2008-01-04 14:00:00	AAPL	Stock	6.6961	6.6996	6.5271	6.5793	240751924.0
2008-01-04 15:00:00	AAPL	Stock	6.5804	6.5814	6.3889	6.4261	396286492.0
2008-01-04 16:00:00	AAPL	Stock	6.4257	6.8226	6.4204	6.4236	21449988.0
2008-01-04 17:00:00	AAPL	Stock	6.4261	6.4286	6.4125	6.4196	1642480.0
2008-01-04 18:00:00	AAPL	Stock	6.4239	6.4304	6.4182	6.4304	512260.0
2008-01-04 19:00:00	AAPL	Stock	6.4318	6.4321	6.4246	6.43	475916.0
2008-01-04 08:00:00	MSFT	Stock	35.5	35.5	34.95	34.96	275769.0
2008-01-04 09:00:00	MSFT	Stock	34.96	35.22	34.83	35.05	5940546.0
2008-01-04 10:00:00	MSFT	Stock	35.05	35.15	34.28	34.28	12044601.0
2008-01-04 11:00:00	MSFT	Stock	34.29	34.44	34.09	34.44	12677433.0
2008-01-04 12:00:00	MSFT	Stock	34.44	34.69	34.4	34.46	6907510.0
2008-01-04 13:00:00	MSFT	Stock	34.47	34.58	34.22	34.51	6779705.0
2008-01-04 14:00:00	MSFT	Stock	34.5	34.51	34.11	34.29	7833370.0
2008-01-04 15:00:00	MSFT	Stock	34.29	34.46	34.17	34.36	15729567.0
2008-01-04 16:00:00	MSFT	Stock	34.34	35.054	34.34	34.45	3670120.0
2008-01-04 17:00:00	MSFT	Stock	34.48	34.48	34.25	34.25	28473.0
2008-01-04 18:00:00	MSFT	Stock	34.3	34.36	34.25	34.3	1500.0
2008-01-04 19:00:00	MSFT	Stock	34.3	34.34	34.28	34.34	1610.0
2008-01-04 08:00:00	NVDA	Stock	0.8188	0.8188	0.7992	0.8	520440.0
2008-01-04 09:00:00	NVDA	Stock	0.803	0.803	0.7788	0.7862	68799560.0
2008-01-04 10:00:00	NVDA	Stock	0.7862	0.7923	0.7543	0.7575	111771000.0
2008-01-04 11:00:00	NVDA	Stock	0.7578	0.765	0.757	0.7633	67426800.0
2008-01-04 12:00:00	NVDA	Stock	0.7633	0.7665	0.7538	0.7545	65174240.0
2008-01-04 13:00:00	NVDA	Stock	0.7545	0.7572	0.75	0.7558	62042360.0
2008-01-04 14:00:00	NVDA	Stock	0.7558	0.756	0.745	0.7488	95266840.0
2008-01-04 15:00:00	NVDA	Stock	0.7488	0.7572	0.7485	0.7495	208980920.0
2008-01-04 16:00:00	NVDA	Stock	0.7503	0.7938	0.7492	0.75	52538120.0
2008-01-04 17:00:00	NVDA	Stock	0.7488	0.75	0.7488	0.75	17720.0
2008-01-04 18:00:00	NVDA	Stock	0.7523	0.7523	0.7513	0.7518	27400.0
2008-01-04 19:00:00	NVDA	Stock	0.7518	0.7518	0.7518	0.7518	19800.0
2008-01-04 07:00:00	AMZN	Stock	4.7605	4.7605	4.76	4.76	86000.0
2008-01-04 08:00:00	AMZN	Stock	4.7605	4.7605	4.66	4.6625	467260.0
2008-01-04 09:00:00	AMZN	Stock	4.6735	4.686	4.5775	4.5815	31351960.0
2008-01-04 10:00:00	AMZN	Stock	4.58	4.6005	4.488	4.493	42577760.0
2008-01-04 11:00:00	AMZN	Stock	4.493	4.555	4.4865	4.5405	24328060.0
2008-01-04 12:00:00	AMZN	Stock	4.54	4.566	4.517	4.5345	14823600.0
2008-01-04 13:00:00	AMZN	Stock	4.534	4.5425	4.4975	4.523	14653040.0
2008-01-04 14:00:00	AMZN	Stock	4.522	4.5235	4.43	4.4735	29052500.0
2008-01-04 15:00:00	AMZN	Stock	4.474	4.484	4.425	4.44	43897200.0
2008-01-04 16:00:00	AMZN	Stock	4.44	4.6588	4.4375	4.4675	3628320.0

> showing 50 of 41,254 rows — these rows as CSV

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