PREVIEW / stock_1hour / 2008-06-26

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-26.parquet
  size:    850 KB
  rows:    40,843
  symbols: 3,342

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-06-26 07:00:00	AAPL	Stock	6.25	6.275	6.2268	6.2582	305480.0
2008-06-26 08:00:00	AAPL	Stock	6.25	6.2654	6.2079	6.2193	3489584.0
2008-06-26 09:00:00	AAPL	Stock	6.2193	6.2444	6.1346	6.155	112503720.0
2008-06-26 10:00:00	AAPL	Stock	6.1586	6.1886	6.0857	6.0921	141857464.0
2008-06-26 11:00:00	AAPL	Stock	6.0921	6.12	6.0775	6.0917	102008928.0
2008-06-26 12:00:00	AAPL	Stock	6.0914	6.0989	6.0314	6.0711	117301352.0
2008-06-26 13:00:00	AAPL	Stock	6.0704	6.0846	6.0271	6.0548	80216836.0
2008-06-26 14:00:00	AAPL	Stock	6.0546	6.0671	6.0004	6.025	109002628.0
2008-06-26 15:00:00	AAPL	Stock	6.0243	6.0743	6.0061	6.0079	144186364.0
2008-06-26 16:00:00	AAPL	Stock	6.0079	6.0885	6.0	6.0036	24352832.0
2008-06-26 17:00:00	AAPL	Stock	6.0036	6.3354	6.0	6.0004	1592976.0
2008-06-26 18:00:00	AAPL	Stock	6.0004	6.0018	5.99	5.9904	769888.0
2008-06-26 19:00:00	AAPL	Stock	5.9925	5.9957	5.9857	5.9893	230244.0
2008-06-26 07:00:00	MSFT	Stock	28.24	28.24	28.16	28.16	700.0
2008-06-26 08:00:00	MSFT	Stock	28.1	28.15	27.93	27.98	17237.0
2008-06-26 09:00:00	MSFT	Stock	27.96	28.19	27.91	28.09	6968026.0
2008-06-26 10:00:00	MSFT	Stock	28.1	28.2	27.95	28.02	10298797.0
2008-06-26 11:00:00	MSFT	Stock	28.02	28.08	27.9	28.042	8010404.0
2008-06-26 12:00:00	MSFT	Stock	28.04	28.13	27.96	27.98	6323921.0
2008-06-26 13:00:00	MSFT	Stock	27.97	28.05	27.95	27.99	4678949.0
2008-06-26 14:00:00	MSFT	Stock	27.982	28.05	27.84	27.9	7167030.0
2008-06-26 15:00:00	MSFT	Stock	27.9	28.05	27.76	27.76	14115295.0
2008-06-26 16:00:00	MSFT	Stock	27.76	27.988	27.739	27.76	7155522.0
2008-06-26 17:00:00	MSFT	Stock	28.35	28.35	27.73	27.73	223600.0
2008-06-26 18:00:00	MSFT	Stock	27.71	27.74	27.7	27.74	7610.0
2008-06-26 19:00:00	MSFT	Stock	27.72	27.74	27.69	27.7	11165.0
2008-06-26 08:00:00	NVDA	Stock	0.495	0.4955	0.4925	0.495	98400.0
2008-06-26 09:00:00	NVDA	Stock	0.4912	0.4925	0.4782	0.4788	73043600.0
2008-06-26 10:00:00	NVDA	Stock	0.479	0.4835	0.4772	0.4798	168470320.0
2008-06-26 11:00:00	NVDA	Stock	0.4798	0.4858	0.4788	0.4848	101387040.0
2008-06-26 12:00:00	NVDA	Stock	0.4846	0.4855	0.4808	0.4815	80165040.0
2008-06-26 13:00:00	NVDA	Stock	0.4815	0.483	0.4788	0.4822	72246240.0
2008-06-26 14:00:00	NVDA	Stock	0.4822	0.484	0.478	0.4788	128252680.0
2008-06-26 15:00:00	NVDA	Stock	0.4788	0.4843	0.4768	0.4768	185767920.0
2008-06-26 16:00:00	NVDA	Stock	0.4768	0.4812	0.4765	0.4775	26630000.0
2008-06-26 17:00:00	NVDA	Stock	0.5025	0.5025	0.4768	0.4778	698320.0
2008-06-26 18:00:00	NVDA	Stock	0.4778	0.4778	0.4775	0.4775	68000.0
2008-06-26 19:00:00	NVDA	Stock	0.4775	0.4788	0.4768	0.4768	133600.0
2008-06-26 08:00:00	AMZN	Stock	3.997	3.999	3.965	3.9725	75840.0
2008-06-26 09:00:00	AMZN	Stock	3.9625	3.9945	3.8805	3.91	21045200.0
2008-06-26 10:00:00	AMZN	Stock	3.912	3.947	3.834	3.838	43560760.0
2008-06-26 11:00:00	AMZN	Stock	3.8405	3.8905	3.8135	3.8805	33575460.0
2008-06-26 12:00:00	AMZN	Stock	3.881	3.889	3.8435	3.8605	24508900.0
2008-06-26 13:00:00	AMZN	Stock	3.86	3.873	3.8255	3.842	16220260.0
2008-06-26 14:00:00	AMZN	Stock	3.842	3.85	3.8	3.8038	20018840.0
2008-06-26 15:00:00	AMZN	Stock	3.803	3.8975	3.8	3.815	41231880.0
2008-06-26 16:00:00	AMZN	Stock	3.815	3.8632	3.8144	3.815	21833500.0
2008-06-26 17:00:00	AMZN	Stock	4.0255	4.0255	3.815	3.8395	170840.0
2008-06-26 18:00:00	AMZN	Stock	3.825	3.825	3.8245	3.8245	25540.0
2008-06-26 19:00:00	AMZN	Stock	3.8245	3.8245	3.8245	3.8245	19500.0

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

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