PREVIEW / stock_1hour / 2009-07-07

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-07-07.parquet
  size:    830 KB
  rows:    40,491
  symbols: 3,327

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-07-07 08:00:00	AAPL	Stock	4.9725	4.9725	4.9529	4.9607	971712.0
2009-07-07 09:00:00	AAPL	Stock	4.9614	4.9886	4.9325	4.9496	71116892.0
2009-07-07 10:00:00	AAPL	Stock	4.95	4.9511	4.8821	4.8911	69887132.0
2009-07-07 11:00:00	AAPL	Stock	4.89	4.8989	4.8536	4.8696	70496076.0
2009-07-07 12:00:00	AAPL	Stock	4.8696	4.8725	4.8436	4.8596	42651420.0
2009-07-07 13:00:00	AAPL	Stock	4.8604	4.8857	4.8572	4.8846	47886888.0
2009-07-07 14:00:00	AAPL	Stock	4.8854	4.8882	4.8607	4.8632	43390340.0
2009-07-07 15:00:00	AAPL	Stock	4.8629	4.8675	4.8279	4.835	103091268.0
2009-07-07 16:00:00	AAPL	Stock	4.8343	4.9445	4.8305	4.8464	9574964.0
2009-07-07 17:00:00	AAPL	Stock	4.8446	4.8536	4.8421	4.8464	372120.0
2009-07-07 18:00:00	AAPL	Stock	4.8321	4.8457	4.8314	4.8429	995988.0
2009-07-07 19:00:00	AAPL	Stock	4.8411	4.8464	4.84	4.8464	136136.0
2009-07-07 07:00:00	MSFT	Stock	23.32	23.32	23.3	23.3	1210.0
2009-07-07 08:00:00	MSFT	Stock	23.26	23.26	23.12	23.15	13540.0
2009-07-07 09:00:00	MSFT	Stock	23.11	23.15	22.95	22.992	6032286.0
2009-07-07 10:00:00	MSFT	Stock	22.99	23.0	22.8	22.84	7394010.0
2009-07-07 11:00:00	MSFT	Stock	22.85	22.85	22.69	22.762	5958544.0
2009-07-07 12:00:00	MSFT	Stock	22.767	22.8	22.71	22.75	4322203.0
2009-07-07 13:00:00	MSFT	Stock	22.75	22.85	22.73	22.768	4369963.0
2009-07-07 14:00:00	MSFT	Stock	22.77	22.81	22.65	22.7	5622535.0
2009-07-07 15:00:00	MSFT	Stock	22.69	22.7	22.46	22.54	15258391.0
2009-07-07 16:00:00	MSFT	Stock	22.54	23.364	22.5	22.52	2283291.0
2009-07-07 17:00:00	MSFT	Stock	22.53	22.53	22.5	22.52	19050.0
2009-07-07 18:00:00	MSFT	Stock	22.53	22.53	22.5	22.5	22343.0
2009-07-07 19:00:00	MSFT	Stock	22.49	22.53	22.49	22.53	4041.0
2009-07-07 06:00:00	NVDA	Stock	0.2663	0.2663	0.2663	0.2663	40000.0
2009-07-07 08:00:00	NVDA	Stock	0.2663	0.2663	0.266	0.2663	224000.0
2009-07-07 09:00:00	NVDA	Stock	0.2665	0.2665	0.2608	0.263	90131880.0
2009-07-07 10:00:00	NVDA	Stock	0.2628	0.2654	0.2592	0.261	252349640.0
2009-07-07 11:00:00	NVDA	Stock	0.2608	0.2615	0.257	0.2572	140919640.0
2009-07-07 12:00:00	NVDA	Stock	0.2572	0.2585	0.2558	0.2578	78088840.0
2009-07-07 13:00:00	NVDA	Stock	0.2578	0.2598	0.2572	0.2575	59319280.0
2009-07-07 14:00:00	NVDA	Stock	0.2575	0.2583	0.2527	0.2538	232834760.0
2009-07-07 15:00:00	NVDA	Stock	0.254	0.254	0.2515	0.2523	184941520.0
2009-07-07 16:00:00	NVDA	Stock	0.252	0.2592	0.2498	0.2523	31349800.0
2009-07-07 17:00:00	NVDA	Stock	0.2518	0.2518	0.2518	0.2518	5600.0
2009-07-07 18:00:00	NVDA	Stock	0.2525	0.2525	0.2525	0.2525	20000.0
2009-07-07 19:00:00	NVDA	Stock	0.2525	0.2525	0.2525	0.2525	20000.0
2009-07-07 07:00:00	AMZN	Stock	3.9155	3.9155	3.9155	3.9155	10000.0
2009-07-07 08:00:00	AMZN	Stock	3.905	3.905	3.905	3.905	42000.0
2009-07-07 09:00:00	AMZN	Stock	3.906	3.9345	3.8693	3.872	16408060.0
2009-07-07 10:00:00	AMZN	Stock	3.873	3.8755	3.8415	3.8425	15810080.0
2009-07-07 11:00:00	AMZN	Stock	3.842	3.844	3.7955	3.807	18406660.0
2009-07-07 12:00:00	AMZN	Stock	3.8078	3.809	3.778	3.7885	14759360.0
2009-07-07 13:00:00	AMZN	Stock	3.789	3.828	3.788	3.817	16152960.0
2009-07-07 14:00:00	AMZN	Stock	3.817	3.8315	3.8	3.803	10811620.0
2009-07-07 15:00:00	AMZN	Stock	3.803	3.8105	3.7705	3.7815	32549480.0
2009-07-07 16:00:00	AMZN	Stock	3.7815	3.8968	3.776	3.7815	4026160.0
2009-07-07 18:00:00	AMZN	Stock	3.776	3.78	3.776	3.78	6000.0
2009-07-07 19:00:00	AMZN	Stock	3.7805	3.7805	3.7775	3.7775	4000.0

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

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