PREVIEW / stock_1hour / 2009-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-02-06.parquet
  size:    810 KB
  rows:    39,646
  symbols: 3,318

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-02-06 04:00:00	AAPL	Stock	3.4593	3.4593	3.4486	3.4486	19600.0
2009-02-06 07:00:00	AAPL	Stock	3.4707	3.4707	3.4707	3.4707	2800.0
2009-02-06 08:00:00	AAPL	Stock	3.4589	3.4804	3.4293	3.47	2116604.0
2009-02-06 09:00:00	AAPL	Stock	3.4682	3.5129	3.4489	3.5025	80587808.0
2009-02-06 10:00:00	AAPL	Stock	3.5025	3.5357	3.4864	3.5282	112131516.0
2009-02-06 11:00:00	AAPL	Stock	3.5283	3.55	3.5254	3.5379	87201128.0
2009-02-06 12:00:00	AAPL	Stock	3.5375	3.5446	3.5286	3.5321	51828336.0
2009-02-06 13:00:00	AAPL	Stock	3.5321	3.5675	3.5304	3.5668	85859844.0
2009-02-06 14:00:00	AAPL	Stock	3.5668	3.5714	3.5443	3.5529	96925836.0
2009-02-06 15:00:00	AAPL	Stock	3.5525	3.5689	3.5379	3.5689	130514328.0
2009-02-06 16:00:00	AAPL	Stock	3.5596	3.5679	3.5369	3.5611	21421624.0
2009-02-06 17:00:00	AAPL	Stock	3.5607	3.5714	3.5607	3.5675	296688.0
2009-02-06 18:00:00	AAPL	Stock	3.5704	3.5704	3.5614	3.57	12396944.0
2009-02-06 19:00:00	AAPL	Stock	3.5679	3.5836	3.5632	3.5786	341796.0
2009-02-06 06:00:00	MSFT	Stock	19.1	19.1	19.1	19.1	5000.0
2009-02-06 07:00:00	MSFT	Stock	19.0	19.0	19.0	19.0	1900.0
2009-02-06 08:00:00	MSFT	Stock	19.0	19.1	18.94	19.08	26949.0
2009-02-06 09:00:00	MSFT	Stock	19.1	19.63	19.06	19.625	7357366.0
2009-02-06 10:00:00	MSFT	Stock	19.62	19.75	19.47	19.71	16715289.0
2009-02-06 11:00:00	MSFT	Stock	19.705	19.84	19.65	19.73	11479879.0
2009-02-06 12:00:00	MSFT	Stock	19.73	19.78	19.64	19.762	9531841.0
2009-02-06 13:00:00	MSFT	Stock	19.76	19.93	19.682	19.82	10134027.0
2009-02-06 14:00:00	MSFT	Stock	19.81	19.82	19.61	19.68	10720248.0
2009-02-06 15:00:00	MSFT	Stock	19.68	19.77	19.57	19.7	14897259.0
2009-02-06 16:00:00	MSFT	Stock	19.67	19.85	19.65	19.79	4155364.0
2009-02-06 17:00:00	MSFT	Stock	19.8	19.83	19.66	19.81	11606.0
2009-02-06 18:00:00	MSFT	Stock	19.81	19.88	19.66	19.78	22782.0
2009-02-06 19:00:00	MSFT	Stock	19.78	19.8	19.78	19.8	5247.0
2009-02-06 08:00:00	NVDA	Stock	0.2312	0.2368	0.2312	0.2368	76000.0
2009-02-06 09:00:00	NVDA	Stock	0.235	0.2453	0.2312	0.241	145496760.0
2009-02-06 10:00:00	NVDA	Stock	0.241	0.2412	0.2308	0.2352	268835560.0
2009-02-06 11:00:00	NVDA	Stock	0.2355	0.2388	0.2355	0.2382	110873760.0
2009-02-06 12:00:00	NVDA	Stock	0.238	0.2385	0.235	0.2382	92149200.0
2009-02-06 13:00:00	NVDA	Stock	0.2385	0.2432	0.2375	0.2415	107166600.0
2009-02-06 14:00:00	NVDA	Stock	0.2412	0.245	0.2405	0.2437	83850000.0
2009-02-06 15:00:00	NVDA	Stock	0.2438	0.2482	0.24	0.2465	268366080.0
2009-02-06 16:00:00	NVDA	Stock	0.2465	0.2468	0.2402	0.2468	17528320.0
2009-02-06 17:00:00	NVDA	Stock	0.245	0.2462	0.245	0.2462	75400.0
2009-02-06 18:00:00	NVDA	Stock	0.2448	0.245	0.2438	0.245	160000.0
2009-02-06 19:00:00	NVDA	Stock	0.2462	0.2465	0.245	0.2462	56000.0
2009-02-06 08:00:00	AMZN	Stock	3.1625	3.1815	3.1625	3.1815	12000.0
2009-02-06 09:00:00	AMZN	Stock	3.175	3.287	3.159	3.2775	29786880.0
2009-02-06 10:00:00	AMZN	Stock	3.278	3.3	3.245	3.2656	42869880.0
2009-02-06 11:00:00	AMZN	Stock	3.2655	3.3055	3.2655	3.294	24515060.0
2009-02-06 12:00:00	AMZN	Stock	3.2938	3.325	3.2815	3.292	31627760.0
2009-02-06 13:00:00	AMZN	Stock	3.291	3.329	3.2895	3.3195	23837120.0
2009-02-06 14:00:00	AMZN	Stock	3.32	3.3225	3.2925	3.3115	29796540.0
2009-02-06 15:00:00	AMZN	Stock	3.3115	3.35	3.2885	3.3275	52821040.0
2009-02-06 16:00:00	AMZN	Stock	3.3275	3.33	3.2937	3.3245	1752560.0
2009-02-06 17:00:00	AMZN	Stock	3.3245	3.3325	3.3245	3.3325	84300.0

> showing 50 of 39,646 rows — these rows as CSV

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