PREVIEW / stock_1hour / 2008-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-02.parquet
  size:    836 KB
  rows:    39,974
  symbols: 3,283

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-05-02 05:00:00	AAPL	Stock	6.4693	6.4714	6.4582	6.4582	28000.0
2008-05-02 06:00:00	AAPL	Stock	6.4536	6.4536	6.4536	6.4536	2800.0
2008-05-02 07:00:00	AAPL	Stock	6.4429	6.4518	6.4061	6.4071	405132.0
2008-05-02 08:00:00	AAPL	Stock	6.4129	6.5	6.3939	6.4643	21322784.0
2008-05-02 09:00:00	AAPL	Stock	6.4704	6.4821	6.3929	6.4318	187137048.0
2008-05-02 10:00:00	AAPL	Stock	6.4315	6.4971	6.3768	6.3921	252327656.0
2008-05-02 11:00:00	AAPL	Stock	6.3907	6.4593	6.39	6.4222	121757328.0
2008-05-02 12:00:00	AAPL	Stock	6.4214	6.4429	6.3929	6.4339	88501980.0
2008-05-02 13:00:00	AAPL	Stock	6.4336	6.4554	6.4018	6.4341	90133988.0
2008-05-02 14:00:00	AAPL	Stock	6.4343	6.45	6.4032	6.4061	90077008.0
2008-05-02 15:00:00	AAPL	Stock	6.4064	6.4732	6.3986	6.4643	119152656.0
2008-05-02 16:00:00	AAPL	Stock	6.4657	6.4706	6.4104	6.4557	8451044.0
2008-05-02 17:00:00	AAPL	Stock	6.46	6.4643	6.4571	6.4621	10096688.0
2008-05-02 18:00:00	AAPL	Stock	6.4614	6.4671	6.4543	6.4671	251580.0
2008-05-02 19:00:00	AAPL	Stock	6.4646	6.4675	6.4643	6.4671	282044.0
2008-05-02 06:00:00	MSFT	Stock	29.35	29.35	29.16	29.16	3293.0
2008-05-02 07:00:00	MSFT	Stock	29.2	29.3	29.1	29.22	37731.0
2008-05-02 08:00:00	MSFT	Stock	29.22	29.6	29.15	29.54	292437.0
2008-05-02 09:00:00	MSFT	Stock	29.55	29.62	29.2	29.43	6944010.0
2008-05-02 10:00:00	MSFT	Stock	29.43	29.5	29.07	29.36	13781864.0
2008-05-02 11:00:00	MSFT	Stock	29.36	29.44	29.21	29.24	8058149.0
2008-05-02 12:00:00	MSFT	Stock	29.25	29.25	29.138	29.18	5342461.0
2008-05-02 13:00:00	MSFT	Stock	29.19	29.21	29.03	29.13	5899383.0
2008-05-02 14:00:00	MSFT	Stock	29.13	29.18	28.86	28.87	9941236.0
2008-05-02 15:00:00	MSFT	Stock	28.87	29.24	28.86	29.23	11317706.0
2008-05-02 16:00:00	MSFT	Stock	29.207	29.24	29.005	29.16	2231756.0
2008-05-02 17:00:00	MSFT	Stock	29.15	29.25	29.15	29.25	34510.0
2008-05-02 18:00:00	MSFT	Stock	29.23	29.3	29.13	29.25	44877.0
2008-05-02 19:00:00	MSFT	Stock	29.25	29.25	29.12	29.12	8038.0
2008-05-02 08:00:00	NVDA	Stock	0.5412	0.5525	0.538	0.5488	1625200.0
2008-05-02 09:00:00	NVDA	Stock	0.5498	0.5578	0.5439	0.5572	223864840.0
2008-05-02 10:00:00	NVDA	Stock	0.5575	0.5625	0.5478	0.5498	291884160.0
2008-05-02 11:00:00	NVDA	Stock	0.5495	0.5562	0.5495	0.5539	97605520.0
2008-05-02 12:00:00	NVDA	Stock	0.5538	0.5572	0.553	0.5565	81525760.0
2008-05-02 13:00:00	NVDA	Stock	0.5565	0.557	0.5502	0.5512	83439800.0
2008-05-02 14:00:00	NVDA	Stock	0.5512	0.5545	0.549	0.552	127351160.0
2008-05-02 15:00:00	NVDA	Stock	0.5521	0.563	0.552	0.563	192489680.0
2008-05-02 16:00:00	NVDA	Stock	0.5625	0.5635	0.5542	0.5605	5619480.0
2008-05-02 17:00:00	NVDA	Stock	0.56	0.563	0.56	0.563	88000.0
2008-05-02 18:00:00	NVDA	Stock	0.5625	0.5625	0.56	0.56	89000.0
2008-05-02 19:00:00	NVDA	Stock	0.5625	0.5625	0.5625	0.5625	4000.0
2008-05-02 08:00:00	AMZN	Stock	3.968	4.02	3.968	3.9705	962320.0
2008-05-02 09:00:00	AMZN	Stock	4.0175	4.06	3.9325	3.9595	18948760.0
2008-05-02 10:00:00	AMZN	Stock	3.9595	4.0005	3.875	3.8785	29535440.0
2008-05-02 11:00:00	AMZN	Stock	3.8784	3.908	3.8645	3.882	22010180.0
2008-05-02 12:00:00	AMZN	Stock	3.882	3.8875	3.8395	3.8445	19523120.0
2008-05-02 13:00:00	AMZN	Stock	3.8445	3.86	3.827	3.854	15548940.0
2008-05-02 14:00:00	AMZN	Stock	3.854	3.857	3.82	3.838	20860420.0
2008-05-02 15:00:00	AMZN	Stock	3.838	3.865	3.8315	3.865	31666620.0
2008-05-02 16:00:00	AMZN	Stock	3.8655	3.8834	3.8487	3.8605	2553200.0

> showing 50 of 39,974 rows — these rows as CSV

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