PREVIEW / stock_1hour / 2007-04-12

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-04-12.parquet
  size:    693 KB
  rows:    32,325
  symbols: 2,573

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-12 04:00:00	AAPL	Stock	3.3104	3.3104	3.3068	3.3068	7000.0
2007-04-12 07:00:00	AAPL	Stock	3.3043	3.3043	3.3018	3.3018	14000.0
2007-04-12 08:00:00	AAPL	Stock	3.3014	3.3032	3.2868	3.2929	1297632.0
2007-04-12 09:00:00	AAPL	Stock	3.2929	3.2975	3.24	3.2575	125934340.0
2007-04-12 10:00:00	AAPL	Stock	3.2571	3.2811	3.2532	3.2793	130658024.0
2007-04-12 11:00:00	AAPL	Stock	3.2793	3.2968	3.2711	3.2786	102098472.0
2007-04-12 12:00:00	AAPL	Stock	3.2786	3.2946	3.2786	3.2889	59164784.0
2007-04-12 13:00:00	AAPL	Stock	3.2882	3.2946	3.2796	3.2889	46689076.0
2007-04-12 14:00:00	AAPL	Stock	3.2889	3.2943	3.2829	3.2904	38041724.0
2007-04-12 15:00:00	AAPL	Stock	3.2904	3.2943	3.2811	3.2911	71159116.0
2007-04-12 16:00:00	AAPL	Stock	3.2911	3.2929	3.1907	3.1964	36962044.0
2007-04-12 17:00:00	AAPL	Stock	3.1957	3.2925	3.1875	3.2036	40575724.0
2007-04-12 18:00:00	AAPL	Stock	3.2039	3.2357	3.2036	3.2314	2650032.0
2007-04-12 19:00:00	AAPL	Stock	3.2314	3.2321	3.2232	3.2293	695660.0
2007-04-12 08:00:00	MSFT	Stock	28.1	28.1	28.1	28.1	1000.0
2007-04-12 09:00:00	MSFT	Stock	28.09	28.19	28.04	28.12	4895617.0
2007-04-12 10:00:00	MSFT	Stock	28.11	28.43	28.1	28.36	6994335.0
2007-04-12 11:00:00	MSFT	Stock	28.36	28.42	28.29	28.4	5052986.0
2007-04-12 12:00:00	MSFT	Stock	28.39	28.55	28.36	28.52	4583977.0
2007-04-12 13:00:00	MSFT	Stock	28.53	28.62	28.45	28.45	5502149.0
2007-04-12 14:00:00	MSFT	Stock	28.45	28.49	28.36	28.41	3972519.0
2007-04-12 15:00:00	MSFT	Stock	28.42	28.59	28.4	28.54	10755558.0
2007-04-12 16:00:00	MSFT	Stock	28.54	28.57	28.397	28.52	763514.0
2007-04-12 17:00:00	MSFT	Stock	28.5	28.54	28.5	28.53	3889.0
2007-04-12 18:00:00	MSFT	Stock	28.5	28.5	28.5	28.5	100.0
2007-04-12 19:00:00	MSFT	Stock	28.52	28.53	28.51	28.51	9700.0
2007-04-12 08:00:00	NVDA	Stock	0.4887	0.49	0.4887	0.4897	42000.0
2007-04-12 09:00:00	NVDA	Stock	0.4897	0.4912	0.4857	0.4885	64620180.0
2007-04-12 10:00:00	NVDA	Stock	0.4885	0.4945	0.4882	0.4908	97209540.0
2007-04-12 11:00:00	NVDA	Stock	0.4908	0.493	0.49	0.4923	58497180.0
2007-04-12 12:00:00	NVDA	Stock	0.4923	0.4983	0.4922	0.4983	90230520.0
2007-04-12 13:00:00	NVDA	Stock	0.4983	0.5018	0.4977	0.5002	133034100.0
2007-04-12 14:00:00	NVDA	Stock	0.5002	0.5045	0.4997	0.5042	105374580.0
2007-04-12 15:00:00	NVDA	Stock	0.5042	0.507	0.502	0.5055	156731520.0
2007-04-12 16:00:00	NVDA	Stock	0.5058	0.5058	0.5042	0.5042	121980.0
2007-04-12 17:00:00	NVDA	Stock	0.5055	0.5055	0.5055	0.5055	193020.0
2007-04-12 08:00:00	AMZN	Stock	2.08	2.08	2.08	2.08	2000.0
2007-04-12 09:00:00	AMZN	Stock	2.0795	2.0865	2.07	2.0765	8413680.0
2007-04-12 10:00:00	AMZN	Stock	2.077	2.099	2.0765	2.098	12377020.0
2007-04-12 11:00:00	AMZN	Stock	2.0975	2.103	2.094	2.099	11764880.0
2007-04-12 12:00:00	AMZN	Stock	2.0985	2.1085	2.0985	2.1045	10126680.0
2007-04-12 13:00:00	AMZN	Stock	2.1045	2.113	2.1045	2.108	15638240.0
2007-04-12 14:00:00	AMZN	Stock	2.108	2.1105	2.102	2.1055	10492380.0
2007-04-12 15:00:00	AMZN	Stock	2.1055	2.1185	2.105	2.114	20535440.0
2007-04-12 16:00:00	AMZN	Stock	2.115	2.1175	2.114	2.115	621340.0
2007-04-12 17:00:00	AMZN	Stock	2.114	2.115	2.112	2.1135	62880.0
2007-04-12 18:00:00	AMZN	Stock	2.1125	2.115	2.1125	2.115	11000.0
2007-04-12 19:00:00	AMZN	Stock	2.115	2.115	2.112	2.115	21000.0
2007-04-12 08:00:00	CL	Stock	32.885	32.945	32.885	32.945	125600.0
2007-04-12 09:00:00	CL	Stock	32.945	32.98	32.755	32.824	411600.0

> showing 50 of 32,325 rows — these rows as CSV

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