PREVIEW / stock_1hour / 2007-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-02-05.parquet
  size:    642 KB
  rows:    30,448
  symbols: 2,494

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
2007-02-05 07:00:00	AAPL	Stock	3.0154	3.0157	3.0154	3.0157	15400.0
2007-02-05 08:00:00	AAPL	Stock	3.015	3.0261	3.0054	3.025	1685600.0
2007-02-05 09:00:00	AAPL	Stock	3.0218	3.0382	3.0029	3.0161	94697120.0
2007-02-05 10:00:00	AAPL	Stock	3.0157	3.0236	3.0029	3.0125	99983324.0
2007-02-05 11:00:00	AAPL	Stock	3.0118	3.0439	3.0104	3.0339	117740028.0
2007-02-05 12:00:00	AAPL	Stock	3.0343	3.0411	3.0257	3.0332	49337932.0
2007-02-05 13:00:00	AAPL	Stock	3.0332	3.0375	3.0214	3.0239	45116120.0
2007-02-05 14:00:00	AAPL	Stock	3.0239	3.0304	3.0114	3.0207	55918548.0
2007-02-05 15:00:00	AAPL	Stock	3.0196	3.0207	2.9979	2.9979	106423996.0
2007-02-05 16:00:00	AAPL	Stock	2.9989	3.0014	2.9911	2.9979	2659496.0
2007-02-05 17:00:00	AAPL	Stock	2.9979	2.9993	2.9979	2.9982	271180.0
2007-02-05 18:00:00	AAPL	Stock	2.9982	2.9993	2.9936	2.9993	461496.0
2007-02-05 19:00:00	AAPL	Stock	2.9954	2.9975	2.9943	2.9964	488180.0
2007-02-05 07:00:00	MSFT	Stock	30.04	30.08	30.03	30.03	8300.0
2007-02-05 08:00:00	MSFT	Stock	30.05	30.1	30.01	30.07	72510.0
2007-02-05 09:00:00	MSFT	Stock	30.08	30.08	29.61	29.85	12884217.0
2007-02-05 10:00:00	MSFT	Stock	29.85	30.0	29.8	29.88	9798854.0
2007-02-05 11:00:00	MSFT	Stock	29.89	29.9	29.67	29.71	10470764.0
2007-02-05 12:00:00	MSFT	Stock	29.7	30.02	29.58	29.59	6791287.0
2007-02-05 13:00:00	MSFT	Stock	29.59	29.6	29.41	29.52	13305224.0
2007-02-05 14:00:00	MSFT	Stock	29.52	29.56	29.41	29.52	8166426.0
2007-02-05 15:00:00	MSFT	Stock	29.52	29.7	29.42	29.59	16262984.0
2007-02-05 16:00:00	MSFT	Stock	29.6	29.66	29.58	29.6	214222.0
2007-02-05 17:00:00	MSFT	Stock	29.6	29.6	29.57	29.58	9650.0
2007-02-05 18:00:00	MSFT	Stock	29.58	29.58	29.57	29.57	4750.0
2007-02-05 19:00:00	MSFT	Stock	29.58	29.58	29.56	29.56	5615.0
2007-02-05 08:00:00	NVDA	Stock	0.5308	0.5308	0.5308	0.5308	18000.0
2007-02-05 09:00:00	NVDA	Stock	0.5308	0.544	0.5308	0.5427	81526260.0
2007-02-05 10:00:00	NVDA	Stock	0.5425	0.5437	0.5358	0.5412	115574160.0
2007-02-05 11:00:00	NVDA	Stock	0.541	0.5417	0.5378	0.5404	66785880.0
2007-02-05 12:00:00	NVDA	Stock	0.5405	0.5425	0.5392	0.5425	37656180.0
2007-02-05 13:00:00	NVDA	Stock	0.5425	0.5433	0.541	0.5432	50092620.0
2007-02-05 14:00:00	NVDA	Stock	0.5432	0.5437	0.5407	0.5427	57758940.0
2007-02-05 15:00:00	NVDA	Stock	0.5428	0.5432	0.5387	0.5395	100474800.0
2007-02-05 16:00:00	NVDA	Stock	0.5395	0.5402	0.5395	0.5395	481680.0
2007-02-05 17:00:00	NVDA	Stock	0.5402	0.5402	0.5395	0.5395	89880.0
2007-02-05 18:00:00	NVDA	Stock	0.5383	0.5383	0.5383	0.5383	24000.0
2007-02-05 19:00:00	NVDA	Stock	0.5395	0.5395	0.5395	0.5395	30000.0
2007-02-05 06:00:00	AMZN	Stock	1.8655	1.8655	1.8655	1.8655	2000.0
2007-02-05 08:00:00	AMZN	Stock	1.8725	1.8725	1.865	1.865	24000.0
2007-02-05 09:00:00	AMZN	Stock	1.865	1.871	1.847	1.8535	23029100.0
2007-02-05 10:00:00	AMZN	Stock	1.8535	1.857	1.8385	1.852	28880720.0
2007-02-05 11:00:00	AMZN	Stock	1.8525	1.868	1.8515	1.859	18542860.0
2007-02-05 12:00:00	AMZN	Stock	1.8594	1.8665	1.8576	1.865	8215900.0
2007-02-05 13:00:00	AMZN	Stock	1.865	1.8655	1.859	1.862	8965020.0
2007-02-05 14:00:00	AMZN	Stock	1.862	1.8675	1.861	1.8655	12520160.0
2007-02-05 15:00:00	AMZN	Stock	1.8655	1.8665	1.858	1.858	17671160.0
2007-02-05 16:00:00	AMZN	Stock	1.8585	1.864	1.858	1.859	252200.0
2007-02-05 17:00:00	AMZN	Stock	1.8625	1.8625	1.8625	1.8625	27500.0
2007-02-05 18:00:00	AMZN	Stock	1.864	1.8655	1.864	1.8655	50000.0

> showing 50 of 30,448 rows — these rows as CSV

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