PREVIEW / stock_1hour / 2005-12-19

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-12-19.parquet
  size:    592 KB
  rows:    28,099
  symbols: 2,155

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-19 05:00:00	AAPL	Stock	2.5482	2.5482	2.5464	2.5482	42000.0
2005-12-19 06:00:00	AAPL	Stock	2.55	2.5518	2.55	2.5518	61600.0
2005-12-19 08:00:00	AAPL	Stock	2.55	2.5536	2.5386	2.5446	1680280.0
2005-12-19 09:00:00	AAPL	Stock	2.5429	2.565	2.5371	2.5493	71786428.0
2005-12-19 10:00:00	AAPL	Stock	2.5496	2.5889	2.5475	2.5804	123325412.0
2005-12-19 11:00:00	AAPL	Stock	2.58	2.5929	2.575	2.5818	62674948.0
2005-12-19 12:00:00	AAPL	Stock	2.5818	2.5868	2.5714	2.5722	42967680.0
2005-12-19 13:00:00	AAPL	Stock	2.5721	2.5725	2.5446	2.5571	72894640.0
2005-12-19 14:00:00	AAPL	Stock	2.5571	2.5818	2.55	2.5682	52581844.0
2005-12-19 15:00:00	AAPL	Stock	2.5682	2.5821	2.5493	2.5496	92876000.0
2005-12-19 16:00:00	AAPL	Stock	2.5493	2.5568	2.5486	2.5554	1810256.0
2005-12-19 17:00:00	AAPL	Stock	2.5554	2.5554	2.5493	2.5518	722680.0
2005-12-19 18:00:00	AAPL	Stock	2.5491	2.5518	2.5491	2.5518	158592.0
2005-12-19 08:00:00	MSFT	Stock	26.9	26.95	26.86	26.89	25825.0
2005-12-19 09:00:00	MSFT	Stock	26.88	26.91	26.71	26.74	9956312.0
2005-12-19 10:00:00	MSFT	Stock	26.74	26.76	26.65	26.68	7668607.0
2005-12-19 11:00:00	MSFT	Stock	26.68	26.74	26.67	26.701	5269786.0
2005-12-19 12:00:00	MSFT	Stock	26.708	26.78	26.69	26.73	7774093.0
2005-12-19 13:00:00	MSFT	Stock	26.73	26.768	26.7	26.71	11107408.0
2005-12-19 14:00:00	MSFT	Stock	26.71	26.77	26.68	26.75	11134360.0
2005-12-19 15:00:00	MSFT	Stock	26.75	26.83	26.73	26.82	12741422.0
2005-12-19 16:00:00	MSFT	Stock	26.83	26.86	26.714	26.8	689014.0
2005-12-19 17:00:00	MSFT	Stock	26.8	26.83	26.78	26.78	24919.0
2005-12-19 18:00:00	MSFT	Stock	26.83	26.83	26.7	26.7	6832.0
2005-12-19 08:00:00	NVDA	Stock	0.3071	0.3071	0.3071	0.3071	12000.0
2005-12-19 09:00:00	NVDA	Stock	0.3087	0.31	0.3067	0.3084	40079280.0
2005-12-19 10:00:00	NVDA	Stock	0.3085	0.3095	0.3071	0.3089	39201960.0
2005-12-19 11:00:00	NVDA	Stock	0.3089	0.3092	0.3072	0.3079	35713800.0
2005-12-19 12:00:00	NVDA	Stock	0.308	0.3088	0.3077	0.3077	17208960.0
2005-12-19 13:00:00	NVDA	Stock	0.3077	0.3077	0.3044	0.305	33190680.0
2005-12-19 14:00:00	NVDA	Stock	0.3049	0.3062	0.3037	0.3053	43310280.0
2005-12-19 15:00:00	NVDA	Stock	0.3053	0.3057	0.3012	0.3019	70572720.0
2005-12-19 16:00:00	NVDA	Stock	0.302	0.3021	0.3008	0.3021	4287600.0
2005-12-19 17:00:00	NVDA	Stock	0.302	0.3023	0.302	0.3023	1072080.0
2005-12-19 18:00:00	NVDA	Stock	0.302	0.302	0.302	0.302	21120.0
2005-12-19 08:00:00	AMZN	Stock	2.458	2.458	2.45	2.4505	46000.0
2005-12-19 09:00:00	AMZN	Stock	2.45	2.4585	2.4275	2.448	16685460.0
2005-12-19 10:00:00	AMZN	Stock	2.4485	2.4825	2.445	2.4755	33677460.0
2005-12-19 11:00:00	AMZN	Stock	2.4756	2.5	2.475	2.4855	30122500.0
2005-12-19 12:00:00	AMZN	Stock	2.486	2.494	2.482	2.484	10234140.0
2005-12-19 13:00:00	AMZN	Stock	2.4835	2.484	2.445	2.4565	25818500.0
2005-12-19 14:00:00	AMZN	Stock	2.456	2.4575	2.4405	2.442	12061800.0
2005-12-19 15:00:00	AMZN	Stock	2.4415	2.4425	2.416	2.4175	35502860.0
2005-12-19 16:00:00	AMZN	Stock	2.4175	2.445	2.416	2.42	727740.0
2005-12-19 17:00:00	AMZN	Stock	2.42	2.42	2.4185	2.4185	32000.0
2005-12-19 18:00:00	AMZN	Stock	2.4185	2.42	2.4185	2.42	80920.0
2005-12-19 08:00:00	CL	Stock	27.97	27.97	27.97	27.97	1800.0
2005-12-19 09:00:00	CL	Stock	27.965	27.985	27.686	27.955	474000.0
2005-12-19 10:00:00	CL	Stock	27.96	28.02	27.905	27.955	699000.0
2005-12-19 11:00:00	CL	Stock	27.951	27.995	27.9275	27.97	463000.0

> showing 50 of 28,099 rows — these rows as CSV

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