PREVIEW / stock_1hour / 2008-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-23.parquet
  size:    852 KB
  rows:    40,978
  symbols: 3,314

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-23 07:00:00	AAPL	Stock	6.2707	6.2732	6.2475	6.2475	320488.0
2008-06-23 08:00:00	AAPL	Stock	6.2564	6.2821	6.2189	6.2668	3428236.0
2008-06-23 09:00:00	AAPL	Stock	6.2679	6.2736	6.1454	6.1607	118589156.0
2008-06-23 10:00:00	AAPL	Stock	6.1607	6.2282	6.1386	6.1686	111155604.0
2008-06-23 11:00:00	AAPL	Stock	6.1687	6.1786	6.1271	6.1774	81637864.0
2008-06-23 12:00:00	AAPL	Stock	6.1775	6.2007	6.1475	6.1954	51543268.0
2008-06-23 13:00:00	AAPL	Stock	6.1954	6.2661	6.1811	6.2429	70805784.0
2008-06-23 14:00:00	AAPL	Stock	6.2414	6.2814	6.2314	6.2561	86765532.0
2008-06-23 15:00:00	AAPL	Stock	6.2564	6.2575	6.1793	6.1843	92370852.0
2008-06-23 16:00:00	AAPL	Stock	6.1843	6.2083	6.1679	6.1843	8117564.0
2008-06-23 17:00:00	AAPL	Stock	6.1725	6.201	6.1686	6.1725	371924.0
2008-06-23 18:00:00	AAPL	Stock	6.1725	6.175	6.1679	6.1679	199780.0
2008-06-23 19:00:00	AAPL	Stock	6.1679	6.1746	6.1679	6.1739	92036.0
2008-06-23 07:00:00	MSFT	Stock	28.18	28.18	28.18	28.18	500.0
2008-06-23 08:00:00	MSFT	Stock	28.3	28.31	28.24	28.26	29562.0
2008-06-23 09:00:00	MSFT	Stock	28.29	28.41	28.01	28.089	6677333.0
2008-06-23 10:00:00	MSFT	Stock	28.09	28.14	27.79	27.9	13820802.0
2008-06-23 11:00:00	MSFT	Stock	27.901	28.02	27.81	28.0	5525504.0
2008-06-23 12:00:00	MSFT	Stock	28.0	28.04	27.84	27.96	3854865.0
2008-06-23 13:00:00	MSFT	Stock	27.955	28.13	27.89	28.02	4774828.0
2008-06-23 14:00:00	MSFT	Stock	28.02	28.2	28.0	28.09	6102988.0
2008-06-23 15:00:00	MSFT	Stock	28.08	28.09	27.89	27.99	9224993.0
2008-06-23 16:00:00	MSFT	Stock	27.97	28.2	27.8	27.97	1325448.0
2008-06-23 17:00:00	MSFT	Stock	27.9	27.9	27.88	27.88	2700.0
2008-06-23 18:00:00	MSFT	Stock	27.89	27.89	27.86	27.86	849.0
2008-06-23 19:00:00	MSFT	Stock	27.87	27.87	27.87	27.87	3900.0
2008-06-23 04:00:00	NVDA	Stock	0.4912	0.4912	0.4912	0.4912	16000.0
2008-06-23 08:00:00	NVDA	Stock	0.4938	0.494	0.49	0.49	244760.0
2008-06-23 09:00:00	NVDA	Stock	0.4925	0.4988	0.4885	0.4892	97588720.0
2008-06-23 10:00:00	NVDA	Stock	0.4892	0.4895	0.4812	0.4858	203605240.0
2008-06-23 11:00:00	NVDA	Stock	0.4857	0.486	0.4795	0.4838	102279760.0
2008-06-23 12:00:00	NVDA	Stock	0.4838	0.485	0.4825	0.4848	63842880.0
2008-06-23 13:00:00	NVDA	Stock	0.4848	0.4875	0.4843	0.487	72933600.0
2008-06-23 14:00:00	NVDA	Stock	0.4868	0.4875	0.4848	0.486	81930240.0
2008-06-23 15:00:00	NVDA	Stock	0.4862	0.4865	0.4822	0.4838	129717320.0
2008-06-23 16:00:00	NVDA	Stock	0.4832	0.49	0.4822	0.4838	5326880.0
2008-06-23 17:00:00	NVDA	Stock	0.4843	0.4869	0.4843	0.4845	2015680.0
2008-06-23 07:00:00	AMZN	Stock	4.0525	4.0525	4.0525	4.0525	63400.0
2008-06-23 08:00:00	AMZN	Stock	4.055	4.0975	4.055	4.063	20480.0
2008-06-23 09:00:00	AMZN	Stock	4.064	4.1075	4.0075	4.0205	17928020.0
2008-06-23 10:00:00	AMZN	Stock	4.018	4.0325	3.9795	4.007	24285760.0
2008-06-23 11:00:00	AMZN	Stock	4.006	4.01	3.9775	4.008	12852520.0
2008-06-23 12:00:00	AMZN	Stock	4.0085	4.037	4.0035	4.035	10988720.0
2008-06-23 13:00:00	AMZN	Stock	4.035	4.097	4.0155	4.075	21102280.0
2008-06-23 14:00:00	AMZN	Stock	4.074	4.0815	4.034	4.0485	20461360.0
2008-06-23 15:00:00	AMZN	Stock	4.0485	4.051	4.029	4.038	32418880.0
2008-06-23 16:00:00	AMZN	Stock	4.032	4.0383	3.9535	4.034	1313560.0
2008-06-23 17:00:00	AMZN	Stock	4.0	4.0557	3.9995	4.0	374760.0
2008-06-23 18:00:00	AMZN	Stock	4.005	4.0055	4.005	4.0055	13000.0
2008-06-23 09:00:00	TLT	Stock	89.8	90.2	89.8	90.16	162610.0

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

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