PREVIEW / stock_1hour / 2008-05-23

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-23.parquet
  size:    820 KB
  rows:    39,476
  symbols: 3,282

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-23 04:00:00	AAPL	Stock	6.4079	6.425	6.3739	6.425	134400.0
2008-05-23 05:00:00	AAPL	Stock	6.4268	6.4268	6.3982	6.3982	21868.0
2008-05-23 06:00:00	AAPL	Stock	6.4286	6.4357	6.4125	6.4357	510552.0
2008-05-23 07:00:00	AAPL	Stock	6.4179	6.525	6.4179	6.5107	3705100.0
2008-05-23 08:00:00	AAPL	Stock	6.5107	6.5182	6.4286	6.4504	12816916.0
2008-05-23 09:00:00	AAPL	Stock	6.4504	6.4889	6.4296	6.4425	154107632.0
2008-05-23 10:00:00	AAPL	Stock	6.4418	6.4964	6.4304	6.468	160790700.0
2008-05-23 11:00:00	AAPL	Stock	6.4671	6.4796	6.4314	6.4536	107900128.0
2008-05-23 12:00:00	AAPL	Stock	6.4521	6.4643	6.35	6.3795	124481196.0
2008-05-23 13:00:00	AAPL	Stock	6.3757	6.4364	6.3689	6.4021	87271884.0
2008-05-23 14:00:00	AAPL	Stock	6.4021	6.4996	6.3957	6.4829	114228772.0
2008-05-23 15:00:00	AAPL	Stock	6.4829	6.4982	6.4382	6.4704	126921172.0
2008-05-23 16:00:00	AAPL	Stock	6.4704	6.4768	6.3232	6.4689	7468020.0
2008-05-23 17:00:00	AAPL	Stock	6.4668	6.4764	6.465	6.4743	1115016.0
2008-05-23 18:00:00	AAPL	Stock	6.4743	6.4768	6.3857	6.4768	526876.0
2008-05-23 19:00:00	AAPL	Stock	6.4768	6.4821	6.4768	6.4804	390992.0
2008-05-23 06:00:00	MSFT	Stock	28.35	28.35	28.35	28.35	200.0
2008-05-23 08:00:00	MSFT	Stock	28.47	28.55	28.46	28.46	3781.0
2008-05-23 09:00:00	MSFT	Stock	28.41	28.42	28.19	28.24	4112480.0
2008-05-23 10:00:00	MSFT	Stock	28.24	28.27	28.05	28.138	7961371.0
2008-05-23 11:00:00	MSFT	Stock	28.13	28.16	28.02	28.05	6671898.0
2008-05-23 12:00:00	MSFT	Stock	28.04	28.19	28.04	28.07	5543101.0
2008-05-23 13:00:00	MSFT	Stock	28.08	28.12	28.04	28.06	3740910.0
2008-05-23 14:00:00	MSFT	Stock	28.05	28.08	28.0	28.022	6185189.0
2008-05-23 15:00:00	MSFT	Stock	28.03	28.09	27.95	28.05	11402591.0
2008-05-23 16:00:00	MSFT	Stock	28.05	28.47	28.01	28.04	1633906.0
2008-05-23 17:00:00	MSFT	Stock	28.05	28.05	28.0	28.05	9671.0
2008-05-23 18:00:00	MSFT	Stock	28.05	28.07	28.05	28.05	9657.0
2008-05-23 19:00:00	MSFT	Stock	28.05	28.07	28.04	28.05	7130.0
2008-05-23 08:00:00	NVDA	Stock	0.5912	0.5912	0.5872	0.591	130640.0
2008-05-23 09:00:00	NVDA	Stock	0.5878	0.595	0.5815	0.5832	65184520.0
2008-05-23 10:00:00	NVDA	Stock	0.5832	0.5858	0.5742	0.5772	127133600.0
2008-05-23 11:00:00	NVDA	Stock	0.5772	0.5798	0.5692	0.5758	119668640.0
2008-05-23 12:00:00	NVDA	Stock	0.5759	0.5788	0.5722	0.5725	60210000.0
2008-05-23 13:00:00	NVDA	Stock	0.5725	0.5778	0.5715	0.5738	79491880.0
2008-05-23 14:00:00	NVDA	Stock	0.5738	0.5792	0.573	0.5788	124804080.0
2008-05-23 15:00:00	NVDA	Stock	0.5788	0.5798	0.5752	0.578	186422480.0
2008-05-23 16:00:00	NVDA	Stock	0.5778	0.5912	0.5755	0.5775	15577440.0
2008-05-23 19:00:00	NVDA	Stock	0.5782	0.5798	0.5782	0.5798	8000.0
2008-05-23 08:00:00	AMZN	Stock	3.953	3.955	3.953	3.955	17080.0
2008-05-23 09:00:00	AMZN	Stock	3.955	3.955	3.9005	3.9295	13257420.0
2008-05-23 10:00:00	AMZN	Stock	3.931	3.9435	3.901	3.9295	23868180.0
2008-05-23 11:00:00	AMZN	Stock	3.9295	3.94	3.8765	3.905	19729080.0
2008-05-23 12:00:00	AMZN	Stock	3.903	3.924	3.872	3.877	12657620.0
2008-05-23 13:00:00	AMZN	Stock	3.8775	3.905	3.8715	3.899	16811140.0
2008-05-23 14:00:00	AMZN	Stock	3.899	3.926	3.895	3.918	12622180.0
2008-05-23 15:00:00	AMZN	Stock	3.918	3.9295	3.906	3.9175	19483920.0
2008-05-23 16:00:00	AMZN	Stock	3.9105	3.963	3.9	3.907	6063260.0
2008-05-23 07:00:00	TLT	Stock	91.55	91.55	91.55	91.55	1200.0
2008-05-23 08:00:00	TLT	Stock	91.83	92.0	91.83	92.0	1400.0

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

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