PREVIEW / stock_1hour / 2003-08-13

all stock 1-hour files

  file:    by_date/stock_1hour/2003/2003-08-13.parquet
  size:    428 KB
  rows:    20,899
  symbols: 1,601

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-08-13 09:00:00	AAPL	Stock	0.3527	0.3566	0.3518	0.3541	19340944.0
2003-08-13 10:00:00	AAPL	Stock	0.3539	0.3559	0.3518	0.3518	21543368.0
2003-08-13 11:00:00	AAPL	Stock	0.3518	0.3525	0.3496	0.3511	24285968.0
2003-08-13 12:00:00	AAPL	Stock	0.3511	0.3541	0.3509	0.3539	22185800.0
2003-08-13 13:00:00	AAPL	Stock	0.3539	0.3568	0.3532	0.3553	51217600.0
2003-08-13 14:00:00	AAPL	Stock	0.3554	0.3632	0.3552	0.3616	51283568.0
2003-08-13 15:00:00	AAPL	Stock	0.362	0.3625	0.3584	0.3604	57784776.0
2003-08-13 16:00:00	AAPL	Stock	0.3604	0.3604	0.3596	0.3596	10932712.0
2003-08-13 17:00:00	AAPL	Stock	0.3604	0.3604	0.3604	0.3604	968800.0
2003-08-13 08:00:00	MSFT	Stock	25.68	25.839	25.63	25.82	89445.0
2003-08-13 09:00:00	MSFT	Stock	25.81	25.89	25.66	25.72	5408971.0
2003-08-13 10:00:00	MSFT	Stock	25.72	25.82	25.63	25.66	6369850.0
2003-08-13 11:00:00	MSFT	Stock	25.65	25.68	25.54	25.59	4735249.0
2003-08-13 12:00:00	MSFT	Stock	25.59	25.65	25.559	25.6	4254758.0
2003-08-13 13:00:00	MSFT	Stock	25.603	25.66	25.57	25.58	2464118.0
2003-08-13 14:00:00	MSFT	Stock	25.59	25.7	25.569	25.63	4594580.0
2003-08-13 15:00:00	MSFT	Stock	25.63	25.64	25.51	25.6	6769256.0
2003-08-13 16:00:00	MSFT	Stock	25.59	25.66	25.56	25.6	1686095.0
2003-08-13 17:00:00	MSFT	Stock	25.58	25.6	25.58	25.6	180600.0
2003-08-13 18:00:00	MSFT	Stock	25.59	25.59	25.59	25.59	1050.0
2003-08-13 08:00:00	NVDA	Stock	0.1379	0.1392	0.1379	0.1385	820800.0
2003-08-13 09:00:00	NVDA	Stock	0.1389	0.1404	0.136	0.1376	107859000.0
2003-08-13 10:00:00	NVDA	Stock	0.1375	0.1391	0.1369	0.1384	90070920.0
2003-08-13 11:00:00	NVDA	Stock	0.1384	0.1389	0.1376	0.1377	86225040.0
2003-08-13 12:00:00	NVDA	Stock	0.1377	0.1404	0.1377	0.1402	50218680.0
2003-08-13 13:00:00	NVDA	Stock	0.1402	0.1416	0.1399	0.1409	94789680.0
2003-08-13 14:00:00	NVDA	Stock	0.1408	0.1421	0.1407	0.1413	99274440.0
2003-08-13 15:00:00	NVDA	Stock	0.1413	0.1414	0.1388	0.1397	102397200.0
2003-08-13 16:00:00	NVDA	Stock	0.1397	0.14	0.1385	0.1391	16818000.0
2003-08-13 17:00:00	NVDA	Stock	0.1391	0.1399	0.1391	0.1391	954000.0
2003-08-13 18:00:00	NVDA	Stock	0.1389	0.1389	0.1389	0.1389	48000.0
2003-08-13 08:00:00	AMZN	Stock	2.0	2.0105	2.0	2.01	278000.0
2003-08-13 09:00:00	AMZN	Stock	2.0085	2.014	1.9925	2.0011	23406580.0
2003-08-13 10:00:00	AMZN	Stock	2.0015	2.005	1.992	1.992	22465620.0
2003-08-13 11:00:00	AMZN	Stock	1.992	1.998	1.9855	1.9905	17392620.0
2003-08-13 12:00:00	AMZN	Stock	1.9905	2.0	1.9875	1.9985	9492400.0
2003-08-13 13:00:00	AMZN	Stock	1.9985	2.004	1.9975	2.0035	11986280.0
2003-08-13 14:00:00	AMZN	Stock	2.004	2.0235	2.002	2.0155	19373320.0
2003-08-13 15:00:00	AMZN	Stock	2.0155	2.016	1.9965	2.0115	23194080.0
2003-08-13 16:00:00	AMZN	Stock	2.011	2.017	2.01	2.017	2123840.0
2003-08-13 17:00:00	AMZN	Stock	2.017	2.0195	2.011	2.013	208000.0
2003-08-13 18:00:00	AMZN	Stock	2.013	2.013	2.0115	2.0115	56000.0
2003-08-13 09:00:00	CL	Stock	28.125	28.125	28.005	28.03	205000.0
2003-08-13 10:00:00	CL	Stock	28.025	28.055	27.93	27.935	477000.0
2003-08-13 11:00:00	CL	Stock	27.92	28.0	27.9	27.99	188600.0
2003-08-13 12:00:00	CL	Stock	27.98	28.015	27.91	27.98	174600.0
2003-08-13 13:00:00	CL	Stock	27.965	27.97	27.915	27.925	124400.0
2003-08-13 14:00:00	CL	Stock	27.93	27.955	27.865	27.875	203400.0
2003-08-13 15:00:00	CL	Stock	27.87	27.87	27.7	27.79	593800.0
2003-08-13 16:00:00	CL	Stock	27.79	27.81	27.79	27.81	103600.0

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

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