PREVIEW / stock_1hour / 2007-12-14

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-14.parquet
  size:    809 KB
  rows:    40,052
  symbols: 3,230

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-12-14 06:00:00	AAPL	Stock	6.8643	6.8643	6.8361	6.8368	67200.0
2007-12-14 07:00:00	AAPL	Stock	6.8368	6.8482	6.8214	6.8371	137200.0
2007-12-14 08:00:00	AAPL	Stock	6.8446	6.8554	6.7946	6.8089	3349444.0
2007-12-14 09:00:00	AAPL	Stock	6.8089	6.8407	6.7693	6.8164	103532744.0
2007-12-14 10:00:00	AAPL	Stock	6.8161	6.9	6.7968	6.8964	141581272.0
2007-12-14 11:00:00	AAPL	Stock	6.8964	6.8971	6.8207	6.8354	88153604.0
2007-12-14 12:00:00	AAPL	Stock	6.8343	6.8761	6.7861	6.8264	65524172.0
2007-12-14 13:00:00	AAPL	Stock	6.8275	6.8393	6.8071	6.8239	46607736.0
2007-12-14 14:00:00	AAPL	Stock	6.8239	6.8486	6.8089	6.8089	54581492.0
2007-12-14 15:00:00	AAPL	Stock	6.8093	6.8343	6.7857	6.7993	131623380.0
2007-12-14 16:00:00	AAPL	Stock	6.7993	6.8259	6.7946	6.7996	36553804.0
2007-12-14 17:00:00	AAPL	Stock	6.7979	6.7996	6.7964	6.7964	2526720.0
2007-12-14 18:00:00	AAPL	Stock	6.7982	6.7982	6.7946	6.7964	121744.0
2007-12-14 19:00:00	AAPL	Stock	6.7964	6.7996	6.7954	6.7996	223580.0
2007-12-14 06:00:00	MSFT	Stock	35.17	35.17	35.17	35.17	100.0
2007-12-14 07:00:00	MSFT	Stock	35.14	35.14	35.14	35.14	5000.0
2007-12-14 08:00:00	MSFT	Stock	35.12	35.21	35.0	35.1	158700.0
2007-12-14 09:00:00	MSFT	Stock	35.04	35.52	35.0	35.36	12656332.0
2007-12-14 10:00:00	MSFT	Stock	35.36	35.811	35.32	35.78	10264871.0
2007-12-14 11:00:00	MSFT	Stock	35.78	35.84	35.65	35.7	7876506.0
2007-12-14 12:00:00	MSFT	Stock	35.7	35.75	35.51	35.67	6385692.0
2007-12-14 13:00:00	MSFT	Stock	35.66	35.79	35.63	35.74	3855119.0
2007-12-14 14:00:00	MSFT	Stock	35.74	35.84	35.65	35.65	6489612.0
2007-12-14 15:00:00	MSFT	Stock	35.66	35.73	35.17	35.32	16418040.0
2007-12-14 16:00:00	MSFT	Stock	35.32	35.62	35.288	35.31	7017806.0
2007-12-14 17:00:00	MSFT	Stock	35.29	35.707	35.29	35.31	5934.0
2007-12-14 18:00:00	MSFT	Stock	35.31	35.35	35.3	35.33	3000.0
2007-12-14 19:00:00	MSFT	Stock	35.33	35.33	35.33	35.33	300.0
2007-12-14 08:00:00	NVDA	Stock	0.8578	0.8578	0.8578	0.8578	11800.0
2007-12-14 09:00:00	NVDA	Stock	0.8582	0.8738	0.8502	0.8715	45001360.0
2007-12-14 10:00:00	NVDA	Stock	0.8713	0.8863	0.868	0.8805	63665840.0
2007-12-14 11:00:00	NVDA	Stock	0.8805	0.8863	0.8745	0.8753	39449880.0
2007-12-14 12:00:00	NVDA	Stock	0.8755	0.88	0.8748	0.876	23079720.0
2007-12-14 13:00:00	NVDA	Stock	0.876	0.8808	0.8745	0.8755	21707000.0
2007-12-14 14:00:00	NVDA	Stock	0.8752	0.881	0.8742	0.875	48301360.0
2007-12-14 15:00:00	NVDA	Stock	0.875	0.8798	0.8708	0.8778	99127640.0
2007-12-14 16:00:00	NVDA	Stock	0.8778	0.878	0.8754	0.877	10561880.0
2007-12-14 17:00:00	NVDA	Stock	0.8754	0.8804	0.8754	0.8804	3109240.0
2007-12-14 19:00:00	NVDA	Stock	0.8798	0.88	0.8798	0.88	60000.0
2007-12-14 08:00:00	AMZN	Stock	4.5815	4.5825	4.54	4.545	286120.0
2007-12-14 09:00:00	AMZN	Stock	4.545	4.56	4.5125	4.5295	19776140.0
2007-12-14 10:00:00	AMZN	Stock	4.5315	4.561	4.5165	4.55	20305380.0
2007-12-14 11:00:00	AMZN	Stock	4.55	4.562	4.513	4.515	11901560.0
2007-12-14 12:00:00	AMZN	Stock	4.515	4.5275	4.5	4.526	9693880.0
2007-12-14 13:00:00	AMZN	Stock	4.525	4.5335	4.5035	4.5085	9303620.0
2007-12-14 14:00:00	AMZN	Stock	4.5085	4.5095	4.472	4.475	14013520.0
2007-12-14 15:00:00	AMZN	Stock	4.475	4.487	4.4465	4.455	30646880.0
2007-12-14 16:00:00	AMZN	Stock	4.455	4.62	4.449	4.46	4091120.0
2007-12-14 17:00:00	AMZN	Stock	4.4525	4.5228	4.4525	4.455	14660.0
2007-12-14 18:00:00	AMZN	Stock	4.455	4.455	4.455	4.455	2500.0

> showing 50 of 40,052 rows — these rows as CSV

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