PREVIEW / stock_1hour / 2010-08-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-08-09.parquet
  size:    892 KB
  rows:    42,842
  symbols: 3,491

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
2010-08-09 06:00:00	AAPL	Stock	9.2964	9.2964	9.2607	9.2821	19600.0
2010-08-09 07:00:00	AAPL	Stock	9.2611	9.3143	9.2575	9.3079	321104.0
2010-08-09 08:00:00	AAPL	Stock	9.3132	9.335	9.3089	9.3179	1821092.0
2010-08-09 09:00:00	AAPL	Stock	9.3179	9.3393	9.275	9.2943	43008112.0
2010-08-09 10:00:00	AAPL	Stock	9.2946	9.3321	9.2704	9.2796	54451376.0
2010-08-09 11:00:00	AAPL	Stock	9.2807	9.3168	9.2782	9.2986	30271192.0
2010-08-09 12:00:00	AAPL	Stock	9.2986	9.3146	9.2961	9.3071	19293512.0
2010-08-09 13:00:00	AAPL	Stock	9.3068	9.3196	9.3022	9.3175	24728648.0
2010-08-09 14:00:00	AAPL	Stock	9.3182	9.3543	9.3175	9.3514	47368468.0
2010-08-09 15:00:00	AAPL	Stock	9.3511	9.3625	9.335	9.35	69141184.0
2010-08-09 16:00:00	AAPL	Stock	9.3486	9.3568	9.3071	9.3489	8180228.0
2010-08-09 17:00:00	AAPL	Stock	9.312	9.3504	9.312	9.3482	286720.0
2010-08-09 18:00:00	AAPL	Stock	9.3511	9.3536	9.3482	9.3536	285628.0
2010-08-09 19:00:00	AAPL	Stock	9.355	9.355	9.34	9.3446	191968.0
2010-08-09 05:00:00	MSFT	Stock	25.65	25.65	25.65	25.65	100.0
2010-08-09 07:00:00	MSFT	Stock	25.54	25.54	25.5	25.51	35650.0
2010-08-09 08:00:00	MSFT	Stock	25.59	25.65	25.55	25.64	28902.0
2010-08-09 09:00:00	MSFT	Stock	25.65	25.65	25.37	25.38	5642373.0
2010-08-09 10:00:00	MSFT	Stock	25.38	25.58	25.38	25.58	6239528.0
2010-08-09 11:00:00	MSFT	Stock	25.578	25.655	25.57	25.61	4143911.0
2010-08-09 12:00:00	MSFT	Stock	25.61	25.61	25.51	25.538	5150701.0
2010-08-09 13:00:00	MSFT	Stock	25.53	25.61	25.53	25.59	3110417.0
2010-08-09 14:00:00	MSFT	Stock	25.598	25.73	25.58	25.699	4626446.0
2010-08-09 15:00:00	MSFT	Stock	25.691	25.7	25.53	25.61	16265624.0
2010-08-09 16:00:00	MSFT	Stock	25.61	25.64	25.51	25.62	11567152.0
2010-08-09 17:00:00	MSFT	Stock	25.6	25.61	25.6	25.61	5847.0
2010-08-09 18:00:00	MSFT	Stock	25.6	25.6	25.6	25.6	450.0
2010-08-09 19:00:00	MSFT	Stock	25.62	25.62	25.6	25.62	2135.0
2010-08-09 04:00:00	NVDA	Stock	0.24	0.24	0.24	0.24	8000.0
2010-08-09 08:00:00	NVDA	Stock	0.2412	0.2432	0.2408	0.2412	1100000.0
2010-08-09 09:00:00	NVDA	Stock	0.2415	0.2415	0.2351	0.2362	78839000.0
2010-08-09 10:00:00	NVDA	Stock	0.2362	0.2388	0.236	0.2375	71265520.0
2010-08-09 11:00:00	NVDA	Stock	0.2375	0.2385	0.2365	0.238	39874240.0
2010-08-09 12:00:00	NVDA	Stock	0.238	0.238	0.2372	0.2379	22677520.0
2010-08-09 13:00:00	NVDA	Stock	0.2378	0.2395	0.2374	0.2392	53863400.0
2010-08-09 14:00:00	NVDA	Stock	0.2392	0.2415	0.2392	0.2412	47216440.0
2010-08-09 15:00:00	NVDA	Stock	0.241	0.2412	0.2395	0.2408	128892120.0
2010-08-09 16:00:00	NVDA	Stock	0.2408	0.2414	0.2387	0.241	10265160.0
2010-08-09 17:00:00	NVDA	Stock	0.2372	0.2415	0.2372	0.2405	581520.0
2010-08-09 18:00:00	NVDA	Stock	0.241	0.2425	0.241	0.2425	204400.0
2010-08-09 19:00:00	NVDA	Stock	0.241	0.241	0.241	0.241	12000.0
2010-08-09 08:00:00	AMZN	Stock	6.416	6.445	6.415	6.415	145420.0
2010-08-09 09:00:00	AMZN	Stock	6.417	6.4965	6.4095	6.457	25868440.0
2010-08-09 10:00:00	AMZN	Stock	6.458	6.4785	6.4085	6.425	16042320.0
2010-08-09 11:00:00	AMZN	Stock	6.425	6.4475	6.4005	6.4085	11636180.0
2010-08-09 12:00:00	AMZN	Stock	6.4065	6.422	6.3925	6.4055	8658740.0
2010-08-09 13:00:00	AMZN	Stock	6.406	6.4225	6.4	6.4095	7527020.0
2010-08-09 14:00:00	AMZN	Stock	6.411	6.446	6.41	6.4445	7939020.0
2010-08-09 15:00:00	AMZN	Stock	6.444	6.446	6.418	6.4415	16880200.0
2010-08-09 16:00:00	AMZN	Stock	6.4325	6.45	6.4235	6.43	1341600.0

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

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