PREVIEW / stock_1hour / 2004-11-11

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-11-11.parquet
  size:    517 KB
  rows:    24,306
  symbols: 1,862

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
2004-11-11 08:00:00	AAPL	Stock	0.9813	0.9857	0.98	0.9821	415016.0
2004-11-11 09:00:00	AAPL	Stock	0.9821	0.9821	0.9684	0.971	27649944.0
2004-11-11 10:00:00	AAPL	Stock	0.9711	0.9893	0.9702	0.9846	108192392.0
2004-11-11 11:00:00	AAPL	Stock	0.9845	0.9857	0.977	0.9838	54354776.0
2004-11-11 12:00:00	AAPL	Stock	0.9838	0.9854	0.9793	0.9811	25963056.0
2004-11-11 13:00:00	AAPL	Stock	0.9809	0.9864	0.9802	0.9855	24368960.0
2004-11-11 14:00:00	AAPL	Stock	0.9857	0.9889	0.9823	0.9848	51819880.0
2004-11-11 15:00:00	AAPL	Stock	0.9848	0.9898	0.9827	0.9886	71909656.0
2004-11-11 16:00:00	AAPL	Stock	0.9886	1.0048	0.9857	0.9884	5048344.0
2004-11-11 17:00:00	AAPL	Stock	0.9882	0.9911	0.9875	0.9911	623000.0
2004-11-11 18:00:00	AAPL	Stock	0.9909	0.9913	0.9871	0.9911	852880.0
2004-11-11 08:00:00	MSFT	Stock	29.85	29.9	29.83	29.87	92353.0
2004-11-11 09:00:00	MSFT	Stock	29.87	29.95	29.82	29.948	4899163.0
2004-11-11 10:00:00	MSFT	Stock	29.95	30.08	29.92	30.06	15867769.0
2004-11-11 11:00:00	MSFT	Stock	30.06	30.07	29.94	29.999	13993954.0
2004-11-11 12:00:00	MSFT	Stock	29.999	30.05	29.92	29.94	7957604.0
2004-11-11 13:00:00	MSFT	Stock	29.94	29.95	29.86	29.911	10128973.0
2004-11-11 14:00:00	MSFT	Stock	29.91	29.98	29.89	29.91	9504592.0
2004-11-11 15:00:00	MSFT	Stock	29.91	30.0	29.9	29.99	14948244.0
2004-11-11 16:00:00	MSFT	Stock	29.99	30.0	29.93	29.97	1916349.0
2004-11-11 17:00:00	MSFT	Stock	29.95	30.01	29.93	30.0	1461720.0
2004-11-11 18:00:00	MSFT	Stock	30.0	30.02	29.98	30.0	34548.0
2004-11-11 08:00:00	NVDA	Stock	0.1486	0.1496	0.1486	0.1488	312000.0
2004-11-11 09:00:00	NVDA	Stock	0.1491	0.1497	0.148	0.1482	34813560.0
2004-11-11 10:00:00	NVDA	Stock	0.1482	0.1492	0.1479	0.1483	65991240.0
2004-11-11 11:00:00	NVDA	Stock	0.1483	0.1485	0.1476	0.148	40555800.0
2004-11-11 12:00:00	NVDA	Stock	0.1481	0.1482	0.1477	0.1482	22793880.0
2004-11-11 13:00:00	NVDA	Stock	0.1482	0.1492	0.148	0.1492	55732320.0
2004-11-11 14:00:00	NVDA	Stock	0.1491	0.15	0.149	0.1492	95952600.0
2004-11-11 15:00:00	NVDA	Stock	0.1492	0.1506	0.1487	0.1506	143694360.0
2004-11-11 16:00:00	NVDA	Stock	0.1506	0.1507	0.1497	0.1506	12669240.0
2004-11-11 17:00:00	NVDA	Stock	0.15	0.1509	0.15	0.1509	429120.0
2004-11-11 08:00:00	AMZN	Stock	1.9175	1.925	1.905	1.925	110000.0
2004-11-11 09:00:00	AMZN	Stock	1.925	1.925	1.9035	1.92	10075980.0
2004-11-11 10:00:00	AMZN	Stock	1.9205	1.925	1.882	1.9035	28883520.0
2004-11-11 11:00:00	AMZN	Stock	1.9035	1.917	1.8965	1.917	16591340.0
2004-11-11 12:00:00	AMZN	Stock	1.917	1.931	1.916	1.927	12855820.0
2004-11-11 13:00:00	AMZN	Stock	1.9275	1.928	1.9215	1.9235	11115260.0
2004-11-11 14:00:00	AMZN	Stock	1.924	1.9475	1.9235	1.947	16490000.0
2004-11-11 15:00:00	AMZN	Stock	1.9465	1.95	1.938	1.942	24676860.0
2004-11-11 16:00:00	AMZN	Stock	1.9455	1.9515	1.9415	1.9415	3630420.0
2004-11-11 17:00:00	AMZN	Stock	1.9505	1.955	1.9415	1.9525	322160.0
2004-11-11 09:00:00	CL	Stock	23.425	23.5	23.375	23.49	482000.0
2004-11-11 10:00:00	CL	Stock	23.48	23.549	23.46	23.495	739800.0
2004-11-11 11:00:00	CL	Stock	23.495	23.595	23.475	23.58	564600.0
2004-11-11 12:00:00	CL	Stock	23.56	23.61	23.545	23.565	671600.0
2004-11-11 13:00:00	CL	Stock	23.565	23.685	23.54	23.675	549600.0
2004-11-11 14:00:00	CL	Stock	23.675	23.805	23.665	23.76	1190600.0
2004-11-11 15:00:00	CL	Stock	23.755	23.76	23.665	23.7	861000.0
2004-11-11 16:00:00	CL	Stock	23.69	23.69	23.69	23.69	2600.0

> showing 50 of 24,306 rows — these rows as CSV

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