PREVIEW / stock_1hour / 2007-07-30

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-07-30.parquet
  size:    775 KB
  rows:    37,827
  symbols: 3,110

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-07-30 09:00:00	AAPL	Stock	5.1546	5.1946	5.1332	5.1671	137493356.0
2007-07-30 10:00:00	AAPL	Stock	5.1671	5.1746	4.9846	5.0425	320234236.0
2007-07-30 11:00:00	AAPL	Stock	5.0429	5.0714	4.9921	5.0307	159154604.0
2007-07-30 12:00:00	AAPL	Stock	5.0307	5.0893	5.0	5.0857	117564496.0
2007-07-30 13:00:00	AAPL	Stock	5.0854	5.1	4.9966	5.07	115232992.0
2007-07-30 14:00:00	AAPL	Stock	5.07	5.0757	5.0404	5.0607	86009924.0
2007-07-30 15:00:00	AAPL	Stock	5.0614	5.0893	5.0404	5.0554	129186876.0
2007-07-30 16:00:00	AAPL	Stock	5.0511	5.0511	5.0511	5.0511	16231488.0
2007-07-30 09:00:00	MSFT	Stock	29.405	29.49	29.03	29.101	6946577.0
2007-07-30 10:00:00	MSFT	Stock	29.106	29.21	28.98	29.02	9701240.0
2007-07-30 11:00:00	MSFT	Stock	29.02	29.14	28.98	29.07	7094973.0
2007-07-30 12:00:00	MSFT	Stock	29.07	29.32	28.95	29.27	6847926.0
2007-07-30 13:00:00	MSFT	Stock	29.27	29.39	29.15	29.25	6006393.0
2007-07-30 14:00:00	MSFT	Stock	29.25	29.36	29.16	29.352	5777242.0
2007-07-30 15:00:00	MSFT	Stock	29.36	29.45	29.24	29.42	14311327.0
2007-07-30 16:00:00	MSFT	Stock	29.44	29.44	29.4	29.4	3771031.0
2007-07-30 08:00:00	NVDA	Stock	0.7428	0.7465	0.7428	0.7438	576000.0
2007-07-30 09:00:00	NVDA	Stock	0.7438	0.7558	0.74	0.7535	63408540.0
2007-07-30 10:00:00	NVDA	Stock	0.754	0.7583	0.7417	0.7447	97678620.0
2007-07-30 11:00:00	NVDA	Stock	0.7448	0.749	0.7417	0.7447	61812720.0
2007-07-30 12:00:00	NVDA	Stock	0.7445	0.7502	0.74	0.7483	49328160.0
2007-07-30 13:00:00	NVDA	Stock	0.7485	0.7572	0.7475	0.7548	42666420.0
2007-07-30 14:00:00	NVDA	Stock	0.7547	0.7593	0.7545	0.7568	62157540.0
2007-07-30 15:00:00	NVDA	Stock	0.7565	0.7592	0.7537	0.7582	110234160.0
2007-07-30 16:00:00	NVDA	Stock	0.7575	0.7583	0.75	0.7582	306060.0
2007-07-30 17:00:00	NVDA	Stock	0.7582	0.7582	0.7582	0.7582	6000.0
2007-07-30 18:00:00	NVDA	Stock	0.7583	0.7597	0.7583	0.7597	215640.0
2007-07-30 19:00:00	NVDA	Stock	0.7597	0.7597	0.7597	0.7597	12000.0
2007-07-30 06:00:00	AMZN	Stock	4.151	4.151	4.14	4.14	12000.0
2007-07-30 07:00:00	AMZN	Stock	4.1425	4.144	4.11	4.1285	325140.0
2007-07-30 08:00:00	AMZN	Stock	4.1325	4.1725	4.1275	4.171	1142680.0
2007-07-30 09:00:00	AMZN	Stock	4.171	4.2025	4.08	4.111	46627600.0
2007-07-30 10:00:00	AMZN	Stock	4.1125	4.168	4.0755	4.1255	45523300.0
2007-07-30 11:00:00	AMZN	Stock	4.125	4.144	4.099	4.129	22705700.0
2007-07-30 12:00:00	AMZN	Stock	4.1275	4.157	4.11	4.1495	18076300.0
2007-07-30 13:00:00	AMZN	Stock	4.1485	4.1845	4.1416	4.1725	19145460.0
2007-07-30 14:00:00	AMZN	Stock	4.1735	4.179	4.1405	4.1448	27149520.0
2007-07-30 15:00:00	AMZN	Stock	4.144	4.155	4.118	4.135	53689200.0
2007-07-30 16:00:00	AMZN	Stock	4.135	4.148	4.13	4.145	16238280.0
2007-07-30 17:00:00	AMZN	Stock	4.144	4.1525	4.144	4.15	105500.0
2007-07-30 18:00:00	AMZN	Stock	4.1515	4.152	4.15	4.15	37000.0
2007-07-30 19:00:00	AMZN	Stock	4.15	4.15	4.138	4.145	16000.0
2007-07-30 09:00:00	TLT	Stock	87.19	87.36	87.14	87.21	171100.0
2007-07-30 10:00:00	TLT	Stock	87.2	87.28	87.08	87.14	721200.0
2007-07-30 11:00:00	TLT	Stock	87.22	87.27	87.13	87.15	151300.0
2007-07-30 12:00:00	TLT	Stock	87.14	87.18	86.97	87.07	154700.0
2007-07-30 13:00:00	TLT	Stock	87.06	87.09	86.91	86.96	181600.0
2007-07-30 14:00:00	TLT	Stock	86.96	87.14	86.92	87.02	248200.0
2007-07-30 15:00:00	TLT	Stock	87.05	87.06	86.94	87.0	170500.0
2007-07-30 16:00:00	TLT	Stock	86.99	87.03	86.99	87.03	4600.0

> showing 50 of 37,827 rows — these rows as CSV

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