PREVIEW / stock_1hour / 2007-12-26

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-26.parquet
  size:    811 KB
  rows:    40,798
  symbols: 3,250

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-26 07:00:00	AAPL	Stock	7.1071	7.1464	7.1071	7.1146	514192.0
2007-12-26 08:00:00	AAPL	Stock	7.1214	7.1768	7.1214	7.1321	8543500.0
2007-12-26 09:00:00	AAPL	Stock	7.1321	7.1325	7.0293	7.0525	107658488.0
2007-12-26 10:00:00	AAPL	Stock	7.0525	7.1225	7.0393	7.1089	103804036.0
2007-12-26 11:00:00	AAPL	Stock	7.11	7.1418	7.0946	7.0968	103675544.0
2007-12-26 12:00:00	AAPL	Stock	7.0975	7.1371	7.0961	7.1346	49212436.0
2007-12-26 13:00:00	AAPL	Stock	7.1343	7.1771	7.125	7.17	109664940.0
2007-12-26 14:00:00	AAPL	Stock	7.1707	7.1771	7.1346	7.1668	74290076.0
2007-12-26 15:00:00	AAPL	Stock	7.1666	7.1743	7.0857	7.1043	134319304.0
2007-12-26 16:00:00	AAPL	Stock	7.1043	7.1429	6.7804	7.1	11081420.0
2007-12-26 17:00:00	AAPL	Stock	7.1004	7.1075	7.0939	7.1007	766528.0
2007-12-26 18:00:00	AAPL	Stock	7.1007	7.1064	7.0946	7.1025	153020.0
2007-12-26 19:00:00	AAPL	Stock	7.1	7.1104	7.1	7.1071	454188.0
2007-12-26 07:00:00	MSFT	Stock	36.89	36.89	36.7	36.7	400.0
2007-12-26 08:00:00	MSFT	Stock	36.8	36.8	36.5	36.68	11563.0
2007-12-26 09:00:00	MSFT	Stock	36.68	36.68	36.36	36.39	2789075.0
2007-12-26 10:00:00	MSFT	Stock	36.39	36.45	36.28	36.29	3167386.0
2007-12-26 11:00:00	MSFT	Stock	36.29	36.38	36.26	36.37	3158048.0
2007-12-26 12:00:00	MSFT	Stock	36.36	36.44	36.33	36.41	2751187.0
2007-12-26 13:00:00	MSFT	Stock	36.41	36.58	36.4	36.57	3506245.0
2007-12-26 14:00:00	MSFT	Stock	36.57	36.64	36.53	36.592	5209225.0
2007-12-26 15:00:00	MSFT	Stock	36.59	36.63	36.52	36.61	5617244.0
2007-12-26 16:00:00	MSFT	Stock	36.6	36.62	36.479	36.61	4207896.0
2007-12-26 17:00:00	MSFT	Stock	36.61	36.62	36.6	36.62	58023.0
2007-12-26 18:00:00	MSFT	Stock	36.58	36.58	36.57	36.57	200.0
2007-12-26 19:00:00	MSFT	Stock	36.6	36.6	36.6	36.6	100.0
2007-12-26 08:00:00	NVDA	Stock	0.8988	0.8988	0.8988	0.8988	16400.0
2007-12-26 09:00:00	NVDA	Stock	0.8988	0.9	0.8875	0.8915	22948160.0
2007-12-26 10:00:00	NVDA	Stock	0.8918	0.8985	0.8888	0.8932	26295600.0
2007-12-26 11:00:00	NVDA	Stock	0.8928	0.8975	0.8925	0.8953	20551880.0
2007-12-26 12:00:00	NVDA	Stock	0.8953	0.9	0.895	0.8998	23295920.0
2007-12-26 13:00:00	NVDA	Stock	0.8998	0.9	0.8955	0.899	22298600.0
2007-12-26 14:00:00	NVDA	Stock	0.899	0.9033	0.8982	0.9015	20718080.0
2007-12-26 15:00:00	NVDA	Stock	0.9014	0.9062	0.9014	0.9053	59109000.0
2007-12-26 16:00:00	NVDA	Stock	0.9065	0.9065	0.8989	0.9065	20250920.0
2007-12-26 17:00:00	NVDA	Stock	0.905	0.9065	0.905	0.9065	183320.0
2007-12-26 18:00:00	NVDA	Stock	0.9068	0.9075	0.9068	0.9075	69000.0
2007-12-26 19:00:00	NVDA	Stock	0.9045	0.9045	0.9045	0.9045	20000.0
2007-12-26 08:00:00	AMZN	Stock	4.5625	4.6075	4.5575	4.595	158800.0
2007-12-26 09:00:00	AMZN	Stock	4.595	4.595	4.525	4.545	16974600.0
2007-12-26 10:00:00	AMZN	Stock	4.544	4.697	4.5425	4.6725	27374520.0
2007-12-26 11:00:00	AMZN	Stock	4.673	4.6885	4.635	4.647	14293220.0
2007-12-26 12:00:00	AMZN	Stock	4.647	4.6703	4.6425	4.66	10317080.0
2007-12-26 13:00:00	AMZN	Stock	4.6595	4.6685	4.654	4.6665	6399340.0
2007-12-26 14:00:00	AMZN	Stock	4.667	4.669	4.6455	4.661	11615920.0
2007-12-26 15:00:00	AMZN	Stock	4.6605	4.666	4.6365	4.6425	18048220.0
2007-12-26 16:00:00	AMZN	Stock	4.6485	4.6615	4.6352	4.644	2230320.0
2007-12-26 17:00:00	AMZN	Stock	4.648	4.6625	4.6425	4.66	309640.0
2007-12-26 18:00:00	AMZN	Stock	4.66	4.665	4.656	4.665	44820.0
2007-12-26 19:00:00	AMZN	Stock	4.655	4.655	4.654	4.654	8000.0

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

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