PREVIEW / stock_1hour / 2009-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-08-20.parquet
  size:    849 KB
  rows:    41,203
  symbols: 3,367

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-08-20 07:00:00	AAPL	Stock	5.9107	5.9196	5.8982	5.9046	130060.0
2009-08-20 08:00:00	AAPL	Stock	5.9046	5.9179	5.8964	5.9125	2957080.0
2009-08-20 09:00:00	AAPL	Stock	5.9114	5.9286	5.8789	5.9286	54473048.0
2009-08-20 10:00:00	AAPL	Stock	5.9282	5.9421	5.9218	5.93	64602776.0
2009-08-20 11:00:00	AAPL	Stock	5.93	5.9332	5.9179	5.9243	33600448.0
2009-08-20 12:00:00	AAPL	Stock	5.9239	5.9471	5.9232	5.9446	35096460.0
2009-08-20 13:00:00	AAPL	Stock	5.9446	5.95	5.9311	5.9316	36775676.0
2009-08-20 14:00:00	AAPL	Stock	5.9325	5.94	5.9293	5.9346	34003788.0
2009-08-20 15:00:00	AAPL	Stock	5.9343	5.9543	5.9314	5.9429	65966208.0
2009-08-20 16:00:00	AAPL	Stock	5.945	5.945	5.9305	5.9404	12015500.0
2009-08-20 17:00:00	AAPL	Stock	5.9425	5.9429	5.9379	5.9382	96936.0
2009-08-20 18:00:00	AAPL	Stock	5.9371	5.9404	5.9357	5.9393	551348.0
2009-08-20 19:00:00	AAPL	Stock	5.9364	5.9364	5.9286	5.9307	77140.0
2009-08-20 08:00:00	MSFT	Stock	23.72	23.75	23.66	23.7	51000.0
2009-08-20 09:00:00	MSFT	Stock	23.7	23.87	23.54	23.86	4195544.0
2009-08-20 10:00:00	MSFT	Stock	23.86	23.87	23.67	23.69	6666068.0
2009-08-20 11:00:00	MSFT	Stock	23.69	23.72	23.54	23.555	4768157.0
2009-08-20 12:00:00	MSFT	Stock	23.55	23.73	23.55	23.71	3376424.0
2009-08-20 13:00:00	MSFT	Stock	23.707	23.74	23.67	23.7	2769162.0
2009-08-20 14:00:00	MSFT	Stock	23.71	23.73	23.63	23.64	3003142.0
2009-08-20 15:00:00	MSFT	Stock	23.65	23.74	23.64	23.66	9480815.0
2009-08-20 16:00:00	MSFT	Stock	23.67	23.703	23.64	23.68	2687212.0
2009-08-20 17:00:00	MSFT	Stock	23.68	23.68	23.67	23.67	1000.0
2009-08-20 18:00:00	MSFT	Stock	23.67	23.7	23.67	23.7	3746.0
2009-08-20 19:00:00	MSFT	Stock	23.69	23.69	23.66	23.66	900.0
2009-08-20 08:00:00	NVDA	Stock	0.3325	0.3325	0.3275	0.3298	176000.0
2009-08-20 09:00:00	NVDA	Stock	0.33	0.3333	0.3273	0.3305	132162800.0
2009-08-20 10:00:00	NVDA	Stock	0.3308	0.336	0.3295	0.3351	173539840.0
2009-08-20 11:00:00	NVDA	Stock	0.335	0.3368	0.3342	0.3368	92018600.0
2009-08-20 12:00:00	NVDA	Stock	0.3365	0.3388	0.3362	0.3385	62847800.0
2009-08-20 13:00:00	NVDA	Stock	0.3383	0.3398	0.3378	0.339	55533960.0
2009-08-20 14:00:00	NVDA	Stock	0.3393	0.3415	0.339	0.3408	67520080.0
2009-08-20 15:00:00	NVDA	Stock	0.3406	0.344	0.3405	0.3425	196292680.0
2009-08-20 16:00:00	NVDA	Stock	0.3425	0.3428	0.336	0.3413	25079000.0
2009-08-20 17:00:00	NVDA	Stock	0.3413	0.3413	0.3413	0.3413	46000.0
2009-08-20 18:00:00	NVDA	Stock	0.3422	0.3422	0.3422	0.3422	58000.0
2009-08-20 19:00:00	NVDA	Stock	0.3425	0.3425	0.3422	0.3422	92000.0
2009-08-20 04:00:00	AMZN	Stock	4.1605	4.1605	4.1605	4.1605	3380.0
2009-08-20 07:00:00	AMZN	Stock	4.166	4.166	4.125	4.125	9000.0
2009-08-20 08:00:00	AMZN	Stock	4.15	4.1585	4.136	4.149	145620.0
2009-08-20 09:00:00	AMZN	Stock	4.15	4.1725	4.133	4.165	19428360.0
2009-08-20 10:00:00	AMZN	Stock	4.1655	4.2005	4.152	4.1788	17366940.0
2009-08-20 11:00:00	AMZN	Stock	4.179	4.1925	4.1715	4.1865	11129740.0
2009-08-20 12:00:00	AMZN	Stock	4.1878	4.2125	4.1795	4.212	9002060.0
2009-08-20 13:00:00	AMZN	Stock	4.212	4.2175	4.175	4.196	9076260.0
2009-08-20 14:00:00	AMZN	Stock	4.196	4.199	4.176	4.184	8886860.0
2009-08-20 15:00:00	AMZN	Stock	4.1835	4.2165	4.1825	4.204	24410100.0
2009-08-20 16:00:00	AMZN	Stock	4.205	4.21	4.1831	4.201	1574440.0
2009-08-20 17:00:00	AMZN	Stock	4.2035	4.2035	4.201	4.201	8320.0
2009-08-20 18:00:00	AMZN	Stock	4.205	4.206	4.205	4.206	12020.0

> showing 50 of 41,203 rows — these rows as CSV

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