PREVIEW / stock_1hour / 2009-04-28

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-28.parquet
  size:    820 KB
  rows:    40,188
  symbols: 3,313

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
2009-04-28 06:00:00	AAPL	Stock	4.3896	4.3896	4.3882	4.3882	5600.0
2009-04-28 07:00:00	AAPL	Stock	4.3896	4.4254	4.3896	4.3996	92400.0
2009-04-28 08:00:00	AAPL	Stock	4.4546	4.4546	4.3996	4.42	845320.0
2009-04-28 09:00:00	AAPL	Stock	4.4179	4.4539	4.4021	4.4536	67645536.0
2009-04-28 10:00:00	AAPL	Stock	4.45	4.5075	4.4486	4.4953	91549668.0
2009-04-28 11:00:00	AAPL	Stock	4.495	4.5004	4.4682	4.4727	37573116.0
2009-04-28 12:00:00	AAPL	Stock	4.4729	4.4982	4.4729	4.4904	32881772.0
2009-04-28 13:00:00	AAPL	Stock	4.4907	4.4986	4.4386	4.4421	61650148.0
2009-04-28 14:00:00	AAPL	Stock	4.4421	4.4907	4.4364	4.4757	53256728.0
2009-04-28 15:00:00	AAPL	Stock	4.4757	4.4839	4.4214	4.4282	83470268.0
2009-04-28 16:00:00	AAPL	Stock	4.4279	4.4775	4.4218	4.425	14580944.0
2009-04-28 17:00:00	AAPL	Stock	4.425	4.4286	4.4221	4.4221	205128.0
2009-04-28 18:00:00	AAPL	Stock	4.425	4.4361	4.4164	4.4332	732284.0
2009-04-28 19:00:00	AAPL	Stock	4.4296	4.44	4.4293	4.44	88648.0
2009-04-28 06:00:00	MSFT	Stock	20.23	20.3	20.2	20.2	2000.0
2009-04-28 07:00:00	MSFT	Stock	20.21	20.27	20.21	20.23	1100.0
2009-04-28 08:00:00	MSFT	Stock	20.29	20.33	20.23	20.23	27016.0
2009-04-28 09:00:00	MSFT	Stock	20.31	20.33	19.86	20.0	8691838.0
2009-04-28 10:00:00	MSFT	Stock	20.0	20.1	19.98	20.06	12416315.0
2009-04-28 11:00:00	MSFT	Stock	20.06	20.24	20.05	20.148	8047033.0
2009-04-28 12:00:00	MSFT	Stock	20.145	20.21	19.96	19.972	6116977.0
2009-04-28 13:00:00	MSFT	Stock	19.98	20.14	19.79	19.84	10193139.0
2009-04-28 14:00:00	MSFT	Stock	19.85	20.04	19.83	19.96	13053560.0
2009-04-28 15:00:00	MSFT	Stock	19.965	20.03	19.86	19.92	12875826.0
2009-04-28 16:00:00	MSFT	Stock	19.93	20.593	19.88	19.94	1515391.0
2009-04-28 17:00:00	MSFT	Stock	19.92	19.98	19.9	19.95	51909.0
2009-04-28 18:00:00	MSFT	Stock	19.93	19.95	19.87	19.95	2389100.0
2009-04-28 19:00:00	MSFT	Stock	19.95	19.95	19.88	19.95	1420.0
2009-04-28 06:00:00	NVDA	Stock	0.273	0.273	0.2728	0.2728	44000.0
2009-04-28 07:00:00	NVDA	Stock	0.2703	0.2703	0.2703	0.2703	40000.0
2009-04-28 08:00:00	NVDA	Stock	0.2743	0.2743	0.263	0.27	496200.0
2009-04-28 09:00:00	NVDA	Stock	0.2735	0.2789	0.2695	0.277	82400080.0
2009-04-28 10:00:00	NVDA	Stock	0.2772	0.281	0.275	0.2808	170355560.0
2009-04-28 11:00:00	NVDA	Stock	0.2806	0.282	0.278	0.2794	83274360.0
2009-04-28 12:00:00	NVDA	Stock	0.2794	0.2808	0.278	0.278	76071120.0
2009-04-28 13:00:00	NVDA	Stock	0.278	0.2799	0.276	0.2763	53394920.0
2009-04-28 14:00:00	NVDA	Stock	0.2763	0.28	0.276	0.278	50152240.0
2009-04-28 15:00:00	NVDA	Stock	0.2783	0.279	0.2755	0.2763	95186160.0
2009-04-28 16:00:00	NVDA	Stock	0.2763	0.2781	0.2748	0.2752	8281280.0
2009-04-28 17:00:00	NVDA	Stock	0.2752	0.2763	0.275	0.2763	76000.0
2009-04-28 18:00:00	NVDA	Stock	0.2752	0.2763	0.2752	0.2763	56000.0
2009-04-28 19:00:00	NVDA	Stock	0.2755	0.2772	0.275	0.275	92000.0
2009-04-28 06:00:00	AMZN	Stock	4.1125	4.1125	4.1125	4.1125	4000.0
2009-04-28 08:00:00	AMZN	Stock	4.1395	4.1925	4.1375	4.1625	85840.0
2009-04-28 09:00:00	AMZN	Stock	4.1755	4.2015	4.12	4.1955	23435260.0
2009-04-28 10:00:00	AMZN	Stock	4.1955	4.2675	4.192	4.2325	36882440.0
2009-04-28 11:00:00	AMZN	Stock	4.2325	4.241	4.1705	4.181	20040620.0
2009-04-28 12:00:00	AMZN	Stock	4.1825	4.2222	4.167	4.1795	13019540.0
2009-04-28 13:00:00	AMZN	Stock	4.1785	4.1935	4.1375	4.1415	14458200.0
2009-04-28 14:00:00	AMZN	Stock	4.1415	4.1765	4.1355	4.151	15213700.0

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

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