PREVIEW / stock_1hour / 2008-06-03

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-03.parquet
  size:    860 KB
  rows:    41,842
  symbols: 3,312

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-06-03 07:00:00	AAPL	Stock	6.6529	6.6607	6.6529	6.6607	19320.0
2008-06-03 08:00:00	AAPL	Stock	6.6607	6.6825	6.6607	6.6689	2311708.0
2008-06-03 09:00:00	AAPL	Stock	6.6696	6.6779	6.6271	6.6668	77585004.0
2008-06-03 10:00:00	AAPL	Stock	6.6671	6.7057	6.6671	6.6961	105863912.0
2008-06-03 11:00:00	AAPL	Stock	6.6957	6.7214	6.6907	6.7111	74879672.0
2008-06-03 12:00:00	AAPL	Stock	6.7121	6.7136	6.6757	6.6846	55126064.0
2008-06-03 13:00:00	AAPL	Stock	6.6856	6.7036	6.5714	6.5954	112910056.0
2008-06-03 14:00:00	AAPL	Stock	6.5943	6.615	6.512	6.5829	144927440.0
2008-06-03 15:00:00	AAPL	Stock	6.5807	6.6675	6.5604	6.6207	161875728.0
2008-06-03 16:00:00	AAPL	Stock	6.6264	6.6464	6.6071	6.6206	8581216.0
2008-06-03 17:00:00	AAPL	Stock	6.6154	6.6364	6.6079	6.6125	416752.0
2008-06-03 18:00:00	AAPL	Stock	6.6107	6.6204	6.6071	6.6089	6564180.0
2008-06-03 19:00:00	AAPL	Stock	6.6089	6.6089	6.5993	6.5993	192696.0
2008-06-03 07:00:00	MSFT	Stock	27.91	27.91	27.91	27.91	100.0
2008-06-03 08:00:00	MSFT	Stock	27.9	27.91	27.86	27.9	7816.0
2008-06-03 09:00:00	MSFT	Stock	27.88	28.08	27.81	28.03	6179887.0
2008-06-03 10:00:00	MSFT	Stock	28.04	28.31	27.89	27.982	9087093.0
2008-06-03 11:00:00	MSFT	Stock	27.99	28.06	27.9	27.93	5687556.0
2008-06-03 12:00:00	MSFT	Stock	27.93	27.93	27.74	27.77	6462421.0
2008-06-03 13:00:00	MSFT	Stock	27.78	27.78	27.33	27.45	15803692.0
2008-06-03 14:00:00	MSFT	Stock	27.45	27.48	27.27	27.368	14273445.0
2008-06-03 15:00:00	MSFT	Stock	27.37	27.49	27.29	27.31	18258852.0
2008-06-03 16:00:00	MSFT	Stock	27.31	27.8	27.3	27.34	6476128.0
2008-06-03 17:00:00	MSFT	Stock	27.34	27.95	27.31	27.32	60092.0
2008-06-03 18:00:00	MSFT	Stock	27.34	27.95	27.31	27.33	5014457.0
2008-06-03 19:00:00	MSFT	Stock	27.33	27.35	27.33	27.35	9892.0
2008-06-03 08:00:00	NVDA	Stock	0.625	0.625	0.62	0.62	280000.0
2008-06-03 09:00:00	NVDA	Stock	0.62	0.624	0.6	0.6068	103769040.0
2008-06-03 10:00:00	NVDA	Stock	0.607	0.6198	0.6045	0.6075	105211480.0
2008-06-03 11:00:00	NVDA	Stock	0.6078	0.6122	0.6068	0.6095	70197680.0
2008-06-03 12:00:00	NVDA	Stock	0.6095	0.6095	0.602	0.6025	64387000.0
2008-06-03 13:00:00	NVDA	Stock	0.6028	0.6053	0.5998	0.6008	111601840.0
2008-06-03 14:00:00	NVDA	Stock	0.6008	0.6013	0.5918	0.6013	157754480.0
2008-06-03 15:00:00	NVDA	Stock	0.6013	0.6053	0.599	0.5998	187035840.0
2008-06-03 16:00:00	NVDA	Stock	0.5992	0.611	0.598	0.599	6261520.0
2008-06-03 17:00:00	NVDA	Stock	0.6225	0.6225	0.6225	0.6225	31000.0
2008-06-03 18:00:00	NVDA	Stock	0.601	0.6033	0.6	0.6	3524920.0
2008-06-03 19:00:00	NVDA	Stock	0.599	0.6	0.599	0.5998	115600.0
2008-06-03 08:00:00	AMZN	Stock	4.0195	4.0195	4.0195	4.0195	10000.0
2008-06-03 09:00:00	AMZN	Stock	4.0115	4.043	4.0095	4.0315	11343880.0
2008-06-03 10:00:00	AMZN	Stock	4.0335	4.064	4.0335	4.0475	15478800.0
2008-06-03 11:00:00	AMZN	Stock	4.048	4.0945	4.0425	4.083	14961360.0
2008-06-03 12:00:00	AMZN	Stock	4.0826	4.0835	4.0335	4.044	12634720.0
2008-06-03 13:00:00	AMZN	Stock	4.0435	4.051	3.975	3.991	14320640.0
2008-06-03 14:00:00	AMZN	Stock	3.989	3.9915	3.963	3.978	17810920.0
2008-06-03 15:00:00	AMZN	Stock	3.977	4.0325	3.97	4.0045	24400200.0
2008-06-03 16:00:00	AMZN	Stock	4.0065	4.0249	4.0046	4.0046	1414620.0
2008-06-03 17:00:00	AMZN	Stock	4.0055	4.0055	4.0055	4.0055	8000.0
2008-06-03 18:00:00	AMZN	Stock	4.0055	4.0055	4.0055	4.0055	7900000.0
2008-06-03 09:00:00	TLT	Stock	90.1	90.17	89.95	90.04	186911.0

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

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