PREVIEW / stock_1hour / 2008-02-11

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-11.parquet
  size:    811 KB
  rows:    40,742
  symbols: 3,264

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-02-11 06:00:00	AAPL	Stock	4.4911	4.5357	4.4911	4.5336	352800.0
2008-02-11 07:00:00	AAPL	Stock	4.5357	4.5536	4.5279	4.5357	513156.0
2008-02-11 08:00:00	AAPL	Stock	4.5321	4.5836	4.5282	4.5821	10875200.0
2008-02-11 09:00:00	AAPL	Stock	4.5821	4.6107	4.5486	4.5929	204451408.0
2008-02-11 10:00:00	AAPL	Stock	4.5932	4.605	4.5429	4.5961	185761800.0
2008-02-11 11:00:00	AAPL	Stock	4.5961	4.6057	4.5571	4.5632	121911496.0
2008-02-11 12:00:00	AAPL	Stock	4.5629	4.6071	4.5629	4.5968	105747096.0
2008-02-11 13:00:00	AAPL	Stock	4.5964	4.627	4.5964	4.6187	126621572.0
2008-02-11 14:00:00	AAPL	Stock	4.6186	4.6421	4.5932	4.6029	154197288.0
2008-02-11 15:00:00	AAPL	Stock	4.6032	4.6375	4.5857	4.6232	232517236.0
2008-02-11 16:00:00	AAPL	Stock	4.6235	4.6329	4.5639	4.6207	56626836.0
2008-02-11 17:00:00	AAPL	Stock	4.6243	4.6321	4.5589	4.6318	1276044.0
2008-02-11 18:00:00	AAPL	Stock	4.6318	4.6318	4.625	4.6279	244076.0
2008-02-11 19:00:00	AAPL	Stock	4.6275	4.6279	4.6232	4.625	393708.0
2008-02-11 05:00:00	MSFT	Stock	28.84	28.84	28.84	28.84	100.0
2008-02-11 06:00:00	MSFT	Stock	28.84	28.84	28.3	28.59	1400.0
2008-02-11 07:00:00	MSFT	Stock	28.22	28.46	28.22	28.37	63388.0
2008-02-11 08:00:00	MSFT	Stock	28.4	28.75	28.35	28.7	331517.0
2008-02-11 09:00:00	MSFT	Stock	28.67	28.72	27.91	27.962	21345792.0
2008-02-11 10:00:00	MSFT	Stock	27.97	28.12	27.95	28.11	29808533.0
2008-02-11 11:00:00	MSFT	Stock	28.1	28.19	27.93	27.97	21673175.0
2008-02-11 12:00:00	MSFT	Stock	27.98	28.1	27.97	28.08	14586922.0
2008-02-11 13:00:00	MSFT	Stock	28.08	28.17	28.01	28.13	18458382.0
2008-02-11 14:00:00	MSFT	Stock	28.12	28.35	28.09	28.31	17883931.0
2008-02-11 15:00:00	MSFT	Stock	28.31	28.34	28.05	28.19	27949060.0
2008-02-11 16:00:00	MSFT	Stock	28.2	28.6	28.06	28.261	4651918.0
2008-02-11 17:00:00	MSFT	Stock	28.27	28.27	28.0	28.21	44785.0
2008-02-11 18:00:00	MSFT	Stock	28.24	28.24	28.2	28.22	8090.0
2008-02-11 19:00:00	MSFT	Stock	28.23	28.23	28.2	28.2	11236.0
2008-02-11 08:00:00	NVDA	Stock	0.625	0.6315	0.625	0.625	232040.0
2008-02-11 09:00:00	NVDA	Stock	0.6308	0.6388	0.6238	0.632	56544200.0
2008-02-11 10:00:00	NVDA	Stock	0.6318	0.6402	0.6258	0.6375	76056760.0
2008-02-11 11:00:00	NVDA	Stock	0.6375	0.6393	0.6263	0.6288	77708960.0
2008-02-11 12:00:00	NVDA	Stock	0.629	0.6332	0.627	0.6313	55152280.0
2008-02-11 13:00:00	NVDA	Stock	0.6315	0.6368	0.6305	0.633	55128040.0
2008-02-11 14:00:00	NVDA	Stock	0.633	0.6335	0.627	0.6304	58396320.0
2008-02-11 15:00:00	NVDA	Stock	0.6305	0.6322	0.6225	0.6263	104668480.0
2008-02-11 16:00:00	NVDA	Stock	0.6263	0.6311	0.6242	0.6258	19699240.0
2008-02-11 17:00:00	NVDA	Stock	0.6285	0.6295	0.6285	0.6295	134000.0
2008-02-11 18:00:00	NVDA	Stock	0.6295	0.6295	0.6285	0.6285	25000.0
2008-02-11 19:00:00	NVDA	Stock	0.6273	0.6273	0.6273	0.6273	4000.0
2008-02-11 08:00:00	AMZN	Stock	3.6755	3.7025	3.675	3.69	158160.0
2008-02-11 09:00:00	AMZN	Stock	3.6855	3.7185	3.6385	3.697	26194540.0
2008-02-11 10:00:00	AMZN	Stock	3.698	3.7105	3.64	3.6685	18708660.0
2008-02-11 11:00:00	AMZN	Stock	3.669	3.7345	3.663	3.709	22403620.0
2008-02-11 12:00:00	AMZN	Stock	3.7095	3.798	3.709	3.7767	24407340.0
2008-02-11 13:00:00	AMZN	Stock	3.778	3.79	3.7595	3.771	14123080.0
2008-02-11 14:00:00	AMZN	Stock	3.771	3.7745	3.741	3.7555	16457260.0
2008-02-11 15:00:00	AMZN	Stock	3.755	3.78	3.738	3.76	28302900.0
2008-02-11 16:00:00	AMZN	Stock	3.76	3.766	3.6915	3.7625	4487560.0

> showing 50 of 40,742 rows — these rows as CSV

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