PREVIEW / stock_1hour / 2008-04-29

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-04-29.parquet
  size:    841 KB
  rows:    40,628
  symbols: 3,297

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-04-29 07:00:00	AAPL	Stock	6.1179	6.1514	6.1179	6.1357	50120.0
2008-04-29 08:00:00	AAPL	Stock	6.1321	6.1464	6.125	6.1311	2804452.0
2008-04-29 09:00:00	AAPL	Stock	6.1321	6.1929	6.0804	6.1832	126477904.0
2008-04-29 10:00:00	AAPL	Stock	6.1839	6.2125	6.1375	6.1843	165357360.0
2008-04-29 11:00:00	AAPL	Stock	6.1843	6.2418	6.1768	6.2107	124377008.0
2008-04-29 12:00:00	AAPL	Stock	6.2107	6.2343	6.1954	6.2251	81544036.0
2008-04-29 13:00:00	AAPL	Stock	6.2257	6.2571	6.2218	6.2418	117922672.0
2008-04-29 14:00:00	AAPL	Stock	6.2418	6.2736	6.2304	6.2664	120219736.0
2008-04-29 15:00:00	AAPL	Stock	6.2668	6.2736	6.2346	6.2518	147391412.0
2008-04-29 16:00:00	AAPL	Stock	6.2502	6.2557	6.1591	6.25	11493944.0
2008-04-29 17:00:00	AAPL	Stock	6.2536	6.2554	6.2243	6.25	367472.0
2008-04-29 18:00:00	AAPL	Stock	6.2493	6.2589	6.2479	6.2589	578004.0
2008-04-29 19:00:00	AAPL	Stock	6.2589	6.2607	6.2536	6.2607	285796.0
2008-04-29 08:00:00	MSFT	Stock	29.0	29.0	28.84	28.99	51903.0
2008-04-29 09:00:00	MSFT	Stock	28.98	28.99	28.6	28.63	10937300.0
2008-04-29 10:00:00	MSFT	Stock	28.63	28.75	28.45	28.54	18172214.0
2008-04-29 11:00:00	MSFT	Stock	28.54	28.61	28.5	28.572	9333583.0
2008-04-29 12:00:00	MSFT	Stock	28.57	28.62	28.5	28.55	7205713.0
2008-04-29 13:00:00	MSFT	Stock	28.558	28.78	28.49	28.668	10108410.0
2008-04-29 14:00:00	MSFT	Stock	28.67	28.88	28.65	28.88	9474220.0
2008-04-29 15:00:00	MSFT	Stock	28.88	28.89	28.64	28.65	15110156.0
2008-04-29 16:00:00	MSFT	Stock	28.65	28.756	28.558	28.67	2049320.0
2008-04-29 17:00:00	MSFT	Stock	28.68	28.68	28.59	28.64	27580.0
2008-04-29 18:00:00	MSFT	Stock	28.64	28.65	28.6	28.63	12914.0
2008-04-29 19:00:00	MSFT	Stock	28.63	28.66	28.62	28.66	6749.0
2008-04-29 06:00:00	NVDA	Stock	0.4925	0.4925	0.4925	0.4925	4000.0
2008-04-29 07:00:00	NVDA	Stock	0.4925	0.4925	0.4925	0.4925	12000.0
2008-04-29 08:00:00	NVDA	Stock	0.495	0.495	0.4878	0.4898	295920.0
2008-04-29 09:00:00	NVDA	Stock	0.4912	0.4975	0.489	0.4952	60919960.0
2008-04-29 10:00:00	NVDA	Stock	0.4955	0.4982	0.4935	0.495	54901960.0
2008-04-29 11:00:00	NVDA	Stock	0.4952	0.5008	0.4945	0.4998	67354920.0
2008-04-29 12:00:00	NVDA	Stock	0.5	0.5004	0.4963	0.4982	62528640.0
2008-04-29 13:00:00	NVDA	Stock	0.4982	0.5078	0.4975	0.505	108887240.0
2008-04-29 14:00:00	NVDA	Stock	0.505	0.511	0.5048	0.5108	94429720.0
2008-04-29 15:00:00	NVDA	Stock	0.511	0.5112	0.5038	0.5055	99168360.0
2008-04-29 16:00:00	NVDA	Stock	0.506	0.5073	0.502	0.505	2642240.0
2008-04-29 17:00:00	NVDA	Stock	0.5055	0.5058	0.5055	0.5058	212000.0
2008-04-29 18:00:00	NVDA	Stock	0.5088	0.5088	0.5038	0.5038	56000.0
2008-04-29 20:00:00	NVDA	Stock	0.505	0.505	0.505	0.505	4000.0
2008-04-29 08:00:00	AMZN	Stock	4.0985	4.0985	4.0775	4.0775	850200.0
2008-04-29 09:00:00	AMZN	Stock	4.078	4.0885	4.0405	4.0458	13951360.0
2008-04-29 10:00:00	AMZN	Stock	4.0475	4.069	4.0175	4.0265	23047760.0
2008-04-29 11:00:00	AMZN	Stock	4.0265	4.031	4.0	4.008	19422140.0
2008-04-29 12:00:00	AMZN	Stock	4.0075	4.031	4.0015	4.012	11902640.0
2008-04-29 13:00:00	AMZN	Stock	4.0105	4.03	4.002	4.002	11801440.0
2008-04-29 14:00:00	AMZN	Stock	4.0025	4.025	3.993	4.02	17226620.0
2008-04-29 15:00:00	AMZN	Stock	4.02	4.0405	4.013	4.0345	31927380.0
2008-04-29 16:00:00	AMZN	Stock	4.0365	4.0878	4.0272	4.034	789820.0
2008-04-29 17:00:00	AMZN	Stock	4.039	4.0395	4.0255	4.0255	32000.0
2008-04-29 18:00:00	AMZN	Stock	4.0375	4.0375	4.0375	4.0375	3000.0

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

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