PREVIEW / stock_1hour / 2005-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-02.parquet
  size:    574 KB
  rows:    27,039
  symbols: 2,134

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
2005-12-02 07:00:00	AAPL	Stock	2.5571	2.5679	2.5571	2.5661	75348.0
2005-12-02 08:00:00	AAPL	Stock	2.5657	2.5964	2.5618	2.5804	6506052.0
2005-12-02 09:00:00	AAPL	Stock	2.5804	2.59	2.545	2.5682	166211836.0
2005-12-02 10:00:00	AAPL	Stock	2.5682	2.5893	2.525	2.5296	252752444.0
2005-12-02 11:00:00	AAPL	Stock	2.5296	2.5611	2.5257	2.56	93520000.0
2005-12-02 12:00:00	AAPL	Stock	2.5593	2.5754	2.5429	2.5489	72937452.0
2005-12-02 13:00:00	AAPL	Stock	2.5486	2.5779	2.5486	2.5707	76171368.0
2005-12-02 14:00:00	AAPL	Stock	2.5711	2.5811	2.5607	2.5768	74724832.0
2005-12-02 15:00:00	AAPL	Stock	2.5768	2.5979	2.5768	2.5939	140963424.0
2005-12-02 16:00:00	AAPL	Stock	2.5943	2.5961	2.5893	2.5929	3442432.0
2005-12-02 17:00:00	AAPL	Stock	2.5939	2.5968	2.5918	2.5968	522256.0
2005-12-02 18:00:00	AAPL	Stock	2.5957	2.5961	2.5921	2.5939	247380.0
2005-12-02 08:00:00	MSFT	Stock	27.9	27.93	27.89	27.93	15684.0
2005-12-02 09:00:00	MSFT	Stock	27.93	27.95	27.79	27.94	5488080.0
2005-12-02 10:00:00	MSFT	Stock	27.94	28.1	27.92	28.01	6969885.0
2005-12-02 11:00:00	MSFT	Stock	28.0	28.05	27.93	27.95	4498042.0
2005-12-02 12:00:00	MSFT	Stock	27.95	27.97	27.8	27.87	4998757.0
2005-12-02 13:00:00	MSFT	Stock	27.87	27.97	27.84	27.96	5568439.0
2005-12-02 14:00:00	MSFT	Stock	27.95	27.99	27.92	27.98	4603831.0
2005-12-02 15:00:00	MSFT	Stock	27.98	28.06	27.95	28.0	9015550.0
2005-12-02 16:00:00	MSFT	Stock	27.99	28.03	27.97	28.03	53825.0
2005-12-02 17:00:00	MSFT	Stock	28.0	28.0	28.0	28.0	5945.0
2005-12-02 09:00:00	NVDA	Stock	0.3058	0.3067	0.3033	0.3049	57206760.0
2005-12-02 10:00:00	NVDA	Stock	0.3047	0.307	0.3047	0.3056	58195440.0
2005-12-02 11:00:00	NVDA	Stock	0.3055	0.3056	0.3035	0.3042	25479720.0
2005-12-02 12:00:00	NVDA	Stock	0.3042	0.3048	0.3008	0.3019	29803080.0
2005-12-02 13:00:00	NVDA	Stock	0.3021	0.3037	0.302	0.3032	35152080.0
2005-12-02 14:00:00	NVDA	Stock	0.3032	0.3052	0.3025	0.3033	49358520.0
2005-12-02 15:00:00	NVDA	Stock	0.3033	0.3058	0.3031	0.3049	67936200.0
2005-12-02 16:00:00	NVDA	Stock	0.305	0.305	0.3049	0.3049	1955040.0
2005-12-02 18:00:00	NVDA	Stock	0.3049	0.3049	0.3049	0.3049	120000.0
2005-12-02 08:00:00	AMZN	Stock	2.4325	2.455	2.4325	2.45	95000.0
2005-12-02 09:00:00	AMZN	Stock	2.45	2.458	2.4355	2.4525	19905780.0
2005-12-02 10:00:00	AMZN	Stock	2.452	2.4765	2.448	2.455	40072660.0
2005-12-02 11:00:00	AMZN	Stock	2.455	2.46	2.437	2.4375	12008340.0
2005-12-02 12:00:00	AMZN	Stock	2.438	2.445	2.42	2.43	16019640.0
2005-12-02 13:00:00	AMZN	Stock	2.431	2.4475	2.429	2.4465	7441820.0
2005-12-02 14:00:00	AMZN	Stock	2.4475	2.45	2.436	2.4365	8600760.0
2005-12-02 15:00:00	AMZN	Stock	2.4365	2.457	2.436	2.4525	19443220.0
2005-12-02 16:00:00	AMZN	Stock	2.4505	2.4555	2.445	2.455	1231640.0
2005-12-02 17:00:00	AMZN	Stock	2.454	2.454	2.453	2.453	18980.0
2005-12-02 18:00:00	AMZN	Stock	2.453	2.454	2.4525	2.4525	26900.0
2005-12-02 09:00:00	CL	Stock	27.45	27.45	27.35	27.385	455000.0
2005-12-02 10:00:00	CL	Stock	27.38	27.535	27.36	27.445	570000.0
2005-12-02 11:00:00	CL	Stock	27.445	27.545	27.43	27.51	419600.0
2005-12-02 12:00:00	CL	Stock	27.51	27.525	27.405	27.415	272000.0
2005-12-02 13:00:00	CL	Stock	27.415	27.48	27.37	27.475	309800.0
2005-12-02 14:00:00	CL	Stock	27.475	27.5	27.455	27.475	182200.0
2005-12-02 15:00:00	CL	Stock	27.475	27.51	27.425	27.495	718400.0

> showing 49 of 27,039 rows — these rows as CSV

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