PREVIEW / stock_1hour / 2009-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-06.parquet
  size:    872 KB
  rows:    42,782
  symbols: 3,363

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-05-06 07:00:00	AAPL	Stock	4.7143	4.7193	4.7036	4.7107	202328.0
2009-05-06 08:00:00	AAPL	Stock	4.7207	4.7682	4.7143	4.7629	2340996.0
2009-05-06 09:00:00	AAPL	Stock	4.7607	4.7679	4.7207	4.7343	64916656.0
2009-05-06 10:00:00	AAPL	Stock	4.7357	4.7361	4.6507	4.6704	103592692.0
2009-05-06 11:00:00	AAPL	Stock	4.6707	4.6939	4.6554	4.6939	50629796.0
2009-05-06 12:00:00	AAPL	Stock	4.6946	4.705	4.6675	4.675	42867160.0
2009-05-06 13:00:00	AAPL	Stock	4.6746	4.7039	4.6646	4.7032	46554004.0
2009-05-06 14:00:00	AAPL	Stock	4.7036	4.7564	4.6975	4.7246	82538680.0
2009-05-06 15:00:00	AAPL	Stock	4.725	4.7386	4.7	4.7318	67838036.0
2009-05-06 16:00:00	AAPL	Stock	4.7364	4.7507	4.6921	4.7339	6792212.0
2009-05-06 17:00:00	AAPL	Stock	4.7321	4.7321	4.673	4.7321	146944.0
2009-05-06 18:00:00	AAPL	Stock	4.7329	4.7357	4.7275	4.7321	150836.0
2009-05-06 19:00:00	AAPL	Stock	4.7321	4.7343	4.73	4.7304	15568.0
2009-05-06 08:00:00	MSFT	Stock	19.86	20.01	19.79	20.01	139283.0
2009-05-06 09:00:00	MSFT	Stock	20.0	20.1	19.79	19.936	7299159.0
2009-05-06 10:00:00	MSFT	Stock	19.94	19.955	19.61	19.75	9489348.0
2009-05-06 11:00:00	MSFT	Stock	19.76	19.93	19.73	19.89	7103069.0
2009-05-06 12:00:00	MSFT	Stock	19.89	19.95	19.81	19.82	5056397.0
2009-05-06 13:00:00	MSFT	Stock	19.82	19.87	19.71	19.85	5881743.0
2009-05-06 14:00:00	MSFT	Stock	19.85	19.92	19.69	19.749	9233882.0
2009-05-06 15:00:00	MSFT	Stock	19.745	19.8	19.64	19.79	11828429.0
2009-05-06 16:00:00	MSFT	Stock	19.79	19.911	19.7	19.78	2851683.0
2009-05-06 17:00:00	MSFT	Stock	19.79	19.91	19.73	19.75	25737.0
2009-05-06 18:00:00	MSFT	Stock	19.75	19.79	19.75	19.75	17603.0
2009-05-06 19:00:00	MSFT	Stock	19.75	19.8	19.75	19.76	8220.0
2009-05-06 08:00:00	NVDA	Stock	0.296	0.3038	0.295	0.302	791160.0
2009-05-06 09:00:00	NVDA	Stock	0.3018	0.3018	0.2908	0.2938	116965520.0
2009-05-06 10:00:00	NVDA	Stock	0.2938	0.2942	0.2832	0.2868	156619280.0
2009-05-06 11:00:00	NVDA	Stock	0.287	0.2971	0.2865	0.291	130950720.0
2009-05-06 12:00:00	NVDA	Stock	0.2908	0.2915	0.2867	0.2872	81958720.0
2009-05-06 13:00:00	NVDA	Stock	0.287	0.2892	0.2858	0.2892	93502160.0
2009-05-06 14:00:00	NVDA	Stock	0.2892	0.292	0.2892	0.2892	106913280.0
2009-05-06 15:00:00	NVDA	Stock	0.2895	0.294	0.2838	0.289	229140440.0
2009-05-06 16:00:00	NVDA	Stock	0.2885	0.2916	0.2884	0.2892	2451400.0
2009-05-06 17:00:00	NVDA	Stock	0.289	0.2912	0.289	0.2912	232840.0
2009-05-06 18:00:00	NVDA	Stock	0.2915	0.295	0.2912	0.295	1879880.0
2009-05-06 19:00:00	NVDA	Stock	0.2938	0.2938	0.2925	0.2925	66000.0
2009-05-06 06:00:00	AMZN	Stock	4.1055	4.1055	4.1055	4.1055	2000.0
2009-05-06 07:00:00	AMZN	Stock	4.1075	4.1075	4.1075	4.1075	4000.0
2009-05-06 08:00:00	AMZN	Stock	4.107	4.1505	4.095	4.15	379900.0
2009-05-06 09:00:00	AMZN	Stock	4.1625	4.18	4.1275	4.156	22372900.0
2009-05-06 10:00:00	AMZN	Stock	4.157	4.1575	3.983	4.0214	43522200.0
2009-05-06 11:00:00	AMZN	Stock	4.0225	4.133	4.0	4.0475	18103200.0
2009-05-06 12:00:00	AMZN	Stock	4.0475	4.067	4.034	4.055	15188920.0
2009-05-06 13:00:00	AMZN	Stock	4.055	4.082	4.0345	4.08	18627440.0
2009-05-06 14:00:00	AMZN	Stock	4.0805	4.113	4.0745	4.0865	19460800.0
2009-05-06 15:00:00	AMZN	Stock	4.087	4.1	4.0605	4.1	30247620.0
2009-05-06 16:00:00	AMZN	Stock	4.0995	4.1135	4.0702	4.105	938340.0
2009-05-06 17:00:00	AMZN	Stock	4.11	4.1125	4.0995	4.105	71720.0
2009-05-06 18:00:00	AMZN	Stock	4.1	4.11	4.1	4.1005	28400.0

> showing 50 of 42,782 rows — these rows as CSV

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