PREVIEW / stock_1hour / 2003-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-04-21.parquet
  size:    411 KB
  rows:    20,491
  symbols: 1,576

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
2003-04-21 08:00:00	AAPL	Stock	0.2342	0.2348	0.2342	0.2348	604800.0
2003-04-21 09:00:00	AAPL	Stock	0.2345	0.2355	0.2318	0.2353	30318288.0
2003-04-21 10:00:00	AAPL	Stock	0.2354	0.2355	0.2321	0.2332	31120488.0
2003-04-21 11:00:00	AAPL	Stock	0.2332	0.2349	0.233	0.2346	16258424.0
2003-04-21 12:00:00	AAPL	Stock	0.2348	0.235	0.2336	0.2341	13296808.0
2003-04-21 13:00:00	AAPL	Stock	0.2341	0.235	0.2339	0.2345	8372280.0
2003-04-21 14:00:00	AAPL	Stock	0.2346	0.2354	0.2335	0.2343	14987168.0
2003-04-21 15:00:00	AAPL	Stock	0.2344	0.2355	0.2341	0.2345	23993088.0
2003-04-21 16:00:00	AAPL	Stock	0.2345	0.235	0.2339	0.235	1915536.0
2003-04-21 17:00:00	AAPL	Stock	0.2345	0.235	0.2345	0.2348	319200.0
2003-04-21 18:00:00	AAPL	Stock	0.234	0.234	0.234	0.234	28000.0
2003-04-21 08:00:00	MSFT	Stock	25.5	25.58	25.45	25.561	42900.0
2003-04-21 09:00:00	MSFT	Stock	25.56	25.68	25.35	25.456	6718129.0
2003-04-21 10:00:00	MSFT	Stock	25.46	25.48	25.08	25.2	7848697.0
2003-04-21 11:00:00	MSFT	Stock	25.19	25.28	25.116	25.26	4780537.0
2003-04-21 12:00:00	MSFT	Stock	25.26	25.28	25.096	25.13	3446883.0
2003-04-21 13:00:00	MSFT	Stock	25.13	25.28	25.12	25.269	3656676.0
2003-04-21 14:00:00	MSFT	Stock	25.2632	25.3	25.15	25.23	4614983.0
2003-04-21 15:00:00	MSFT	Stock	25.23	25.3	25.17	25.22	5819956.0
2003-04-21 16:00:00	MSFT	Stock	25.219	25.27	25.201	25.23	345388.0
2003-04-21 17:00:00	MSFT	Stock	25.23	25.25	25.21	25.23	68632.0
2003-04-21 18:00:00	MSFT	Stock	25.23	25.24	25.2	25.23	16669.0
2003-04-21 08:00:00	NVDA	Stock	0.1137	0.1137	0.1137	0.1137	146880.0
2003-04-21 09:00:00	NVDA	Stock	0.1137	0.1146	0.1128	0.1141	53904000.0
2003-04-21 10:00:00	NVDA	Stock	0.1142	0.1149	0.1133	0.1144	114357480.0
2003-04-21 11:00:00	NVDA	Stock	0.1144	0.1155	0.1143	0.1151	74760360.0
2003-04-21 12:00:00	NVDA	Stock	0.115	0.1154	0.1143	0.115	61758480.0
2003-04-21 13:00:00	NVDA	Stock	0.1149	0.1167	0.1143	0.1162	98469600.0
2003-04-21 14:00:00	NVDA	Stock	0.1162	0.1165	0.1157	0.1162	50591880.0
2003-04-21 15:00:00	NVDA	Stock	0.1162	0.117	0.1157	0.1167	86007240.0
2003-04-21 16:00:00	NVDA	Stock	0.1167	0.1168	0.1166	0.1167	4525200.0
2003-04-21 17:00:00	NVDA	Stock	0.1162	0.1171	0.1162	0.1169	3876000.0
2003-04-21 18:00:00	NVDA	Stock	0.1169	0.1169	0.1169	0.1169	120000.0
2003-04-21 08:00:00	AMZN	Stock	1.25	1.255	1.249	1.249	50000.0
2003-04-21 09:00:00	AMZN	Stock	1.2505	1.3085	1.245	1.303	34265100.0
2003-04-21 10:00:00	AMZN	Stock	1.303	1.303	1.2725	1.2805	38464460.0
2003-04-21 11:00:00	AMZN	Stock	1.2805	1.2815	1.2725	1.278	8454300.0
2003-04-21 12:00:00	AMZN	Stock	1.278	1.278	1.2635	1.266	9421180.0
2003-04-21 13:00:00	AMZN	Stock	1.2665	1.273	1.264	1.268	4567080.0
2003-04-21 14:00:00	AMZN	Stock	1.2685	1.2695	1.25	1.2585	16447140.0
2003-04-21 15:00:00	AMZN	Stock	1.2585	1.266	1.253	1.2625	14724300.0
2003-04-21 16:00:00	AMZN	Stock	1.2625	1.2685	1.2625	1.265	241100.0
2003-04-21 17:00:00	AMZN	Stock	1.2625	1.2664	1.2623	1.2625	308000.0
2003-04-21 09:00:00	CL	Stock	28.0	28.1	27.955	28.08	407200.0
2003-04-21 10:00:00	CL	Stock	28.075	28.125	28.005	28.02	580000.0
2003-04-21 11:00:00	CL	Stock	28.05	28.125	28.05	28.095	394600.0
2003-04-21 12:00:00	CL	Stock	28.095	28.17	28.055	28.125	380000.0
2003-04-21 13:00:00	CL	Stock	28.125	28.235	28.12	28.2	286200.0
2003-04-21 14:00:00	CL	Stock	28.2	28.2	28.065	28.135	327200.0
2003-04-21 15:00:00	CL	Stock	28.13	28.195	28.1	28.18	629800.0

> showing 50 of 20,491 rows — these rows as CSV

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