PREVIEW / stock_1hour / 2007-04-16

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-16.parquet
  size:    722 KB
  rows:    33,585
  symbols: 2,594

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
2007-04-16 07:00:00	AAPL	Stock	3.2393	3.2425	3.2371	3.2389	69076.0
2007-04-16 08:00:00	AAPL	Stock	3.2418	3.2429	3.2236	3.2268	3087560.0
2007-04-16 09:00:00	AAPL	Stock	3.2311	3.2436	3.2232	3.2343	101556532.0
2007-04-16 10:00:00	AAPL	Stock	3.2343	3.2639	3.23	3.2536	128301320.0
2007-04-16 11:00:00	AAPL	Stock	3.2536	3.2679	3.2432	3.2636	100368100.0
2007-04-16 12:00:00	AAPL	Stock	3.2639	3.2657	3.2536	3.2596	61659808.0
2007-04-16 13:00:00	AAPL	Stock	3.2596	3.2643	3.2532	3.2543	56294672.0
2007-04-16 14:00:00	AAPL	Stock	3.2543	3.2596	3.25	3.2586	49845236.0
2007-04-16 15:00:00	AAPL	Stock	3.2589	3.2668	3.2536	3.2661	83030136.0
2007-04-16 16:00:00	AAPL	Stock	3.2654	3.27	3.2625	3.2675	5826128.0
2007-04-16 17:00:00	AAPL	Stock	3.2679	3.2679	3.2654	3.2679	168672.0
2007-04-16 18:00:00	AAPL	Stock	3.2679	3.2682	3.2668	3.2679	68964.0
2007-04-16 19:00:00	AAPL	Stock	3.2679	3.2704	3.2679	3.2689	273140.0
2007-04-16 07:00:00	MSFT	Stock	28.61	28.61	28.61	28.61	1300.0
2007-04-16 08:00:00	MSFT	Stock	28.61	28.65	28.61	28.65	24900.0
2007-04-16 09:00:00	MSFT	Stock	28.63	28.75	28.54	28.65	3761114.0
2007-04-16 10:00:00	MSFT	Stock	28.66	28.69	28.21	28.58	4800197.0
2007-04-16 11:00:00	MSFT	Stock	28.582	28.73	28.55	28.66	3614919.0
2007-04-16 12:00:00	MSFT	Stock	28.65	28.71	28.6	28.65	2148833.0
2007-04-16 13:00:00	MSFT	Stock	28.65	28.73	28.632	28.65	3324403.0
2007-04-16 14:00:00	MSFT	Stock	28.64	28.74	28.62	28.73	2408404.0
2007-04-16 15:00:00	MSFT	Stock	28.73	28.75	28.65	28.72	7279337.0
2007-04-16 16:00:00	MSFT	Stock	28.71	28.73	28.7	28.71	796574.0
2007-04-16 17:00:00	MSFT	Stock	28.71	28.73	28.71	28.71	1000200.0
2007-04-16 18:00:00	MSFT	Stock	28.7	28.7	28.7	28.7	2350.0
2007-04-16 19:00:00	MSFT	Stock	28.7	28.713	28.7	28.713	414.0
2007-04-16 08:00:00	NVDA	Stock	0.5097	0.5097	0.5083	0.5083	132000.0
2007-04-16 09:00:00	NVDA	Stock	0.51	0.5122	0.5055	0.5062	66828120.0
2007-04-16 10:00:00	NVDA	Stock	0.5062	0.5108	0.5035	0.5075	120485940.0
2007-04-16 11:00:00	NVDA	Stock	0.5073	0.5108	0.5068	0.5088	76559880.0
2007-04-16 12:00:00	NVDA	Stock	0.5088	0.5092	0.5042	0.5042	53061240.0
2007-04-16 13:00:00	NVDA	Stock	0.5042	0.5062	0.503	0.5037	59648940.0
2007-04-16 14:00:00	NVDA	Stock	0.5037	0.504	0.5005	0.5018	69621780.0
2007-04-16 15:00:00	NVDA	Stock	0.5018	0.5078	0.5017	0.507	127706880.0
2007-04-16 16:00:00	NVDA	Stock	0.5068	0.507	0.5058	0.5058	1009620.0
2007-04-16 17:00:00	NVDA	Stock	0.5067	0.5067	0.5067	0.5067	30000.0
2007-04-16 18:00:00	NVDA	Stock	0.507	0.5073	0.5067	0.5073	109500.0
2007-04-16 04:00:00	AMZN	Stock	2.164	2.164	2.164	2.164	46000.0
2007-04-16 07:00:00	AMZN	Stock	2.14	2.1575	2.14	2.1575	144000.0
2007-04-16 08:00:00	AMZN	Stock	2.1505	2.162	2.1495	2.1565	1371520.0
2007-04-16 09:00:00	AMZN	Stock	2.1575	2.222	2.1565	2.2035	43502820.0
2007-04-16 10:00:00	AMZN	Stock	2.2035	2.2365	2.198	2.2265	49769180.0
2007-04-16 11:00:00	AMZN	Stock	2.2268	2.242	2.2255	2.2365	36330920.0
2007-04-16 12:00:00	AMZN	Stock	2.2375	2.249	2.237	2.2445	27089680.0
2007-04-16 13:00:00	AMZN	Stock	2.2445	2.2635	2.243	2.2535	29537780.0
2007-04-16 14:00:00	AMZN	Stock	2.254	2.2565	2.2505	2.254	19760600.0
2007-04-16 15:00:00	AMZN	Stock	2.2535	2.265	2.2525	2.26	51659260.0
2007-04-16 16:00:00	AMZN	Stock	2.2605	2.2625	2.2581	2.2595	3750020.0
2007-04-16 17:00:00	AMZN	Stock	2.2595	2.2605	2.2595	2.2605	102000.0
2007-04-16 18:00:00	AMZN	Stock	2.2595	2.2595	2.2595	2.2595	22000.0

> showing 50 of 33,585 rows — these rows as CSV

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