PREVIEW / stock_1hour / 2005-04-07

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-04-07.parquet
  size:    539 KB
  rows:    26,088
  symbols: 1,948

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-04-07 08:00:00	AAPL	Stock	1.5179	1.5179	1.5107	1.5107	851480.0
2005-04-07 09:00:00	AAPL	Stock	1.5118	1.5264	1.505	1.5236	63541072.0
2005-04-07 10:00:00	AAPL	Stock	1.5239	1.5282	1.5211	1.5253	71687700.0
2005-04-07 11:00:00	AAPL	Stock	1.5254	1.5339	1.5246	1.5271	56576408.0
2005-04-07 12:00:00	AAPL	Stock	1.5271	1.5304	1.5246	1.5264	47511464.0
2005-04-07 13:00:00	AAPL	Stock	1.5264	1.5275	1.52	1.5203	48816964.0
2005-04-07 14:00:00	AAPL	Stock	1.5204	1.5318	1.5179	1.5304	54239752.0
2005-04-07 15:00:00	AAPL	Stock	1.5304	1.5625	1.5268	1.5554	136270820.0
2005-04-07 16:00:00	AAPL	Stock	1.5546	1.5632	1.545	1.5575	6974800.0
2005-04-07 17:00:00	AAPL	Stock	1.5539	1.5621	1.5289	1.5571	463036.0
2005-04-07 18:00:00	AAPL	Stock	1.5589	1.5625	1.5589	1.5625	151648.0
2005-04-07 08:00:00	MSFT	Stock	24.65	24.68	24.65	24.68	5160.0
2005-04-07 09:00:00	MSFT	Stock	24.68	25.0	24.62	24.85	6634149.0
2005-04-07 10:00:00	MSFT	Stock	24.85	25.0	24.83	24.95	11859808.0
2005-04-07 11:00:00	MSFT	Stock	24.95	25.03	24.88	24.94	10492945.0
2005-04-07 12:00:00	MSFT	Stock	24.94	25.05	24.92	25.02	11261087.0
2005-04-07 13:00:00	MSFT	Stock	25.02	25.07	24.96	24.97	10426172.0
2005-04-07 14:00:00	MSFT	Stock	24.97	25.06	24.97	25.051	8323432.0
2005-04-07 15:00:00	MSFT	Stock	25.058	25.13	24.99	25.1	14919003.0
2005-04-07 16:00:00	MSFT	Stock	25.1	25.11	24.67	25.09	1254594.0
2005-04-07 17:00:00	MSFT	Stock	25.11	25.18	24.97	25.18	93065.0
2005-04-07 18:00:00	MSFT	Stock	25.09	25.09	25.04	25.06	6831.0
2005-04-07 08:00:00	NVDA	Stock	0.195	0.195	0.195	0.195	132000.0
2005-04-07 09:00:00	NVDA	Stock	0.1949	0.1961	0.1921	0.1929	56568840.0
2005-04-07 10:00:00	NVDA	Stock	0.193	0.1952	0.1929	0.195	47221800.0
2005-04-07 11:00:00	NVDA	Stock	0.195	0.1971	0.1949	0.1966	59972520.0
2005-04-07 12:00:00	NVDA	Stock	0.1967	0.1985	0.1964	0.1982	48854760.0
2005-04-07 13:00:00	NVDA	Stock	0.1982	0.1983	0.1968	0.1974	39435240.0
2005-04-07 14:00:00	NVDA	Stock	0.1974	0.1995	0.1972	0.1994	80426640.0
2005-04-07 15:00:00	NVDA	Stock	0.1993	0.2	0.1977	0.1982	137726280.0
2005-04-07 16:00:00	NVDA	Stock	0.1982	0.1987	0.1979	0.1983	4618800.0
2005-04-07 17:00:00	NVDA	Stock	0.198	0.1982	0.197	0.197	328680.0
2005-04-07 08:00:00	AMZN	Stock	1.7255	1.728	1.725	1.7255	136200.0
2005-04-07 09:00:00	AMZN	Stock	1.7255	1.7355	1.725	1.7305	9234480.0
2005-04-07 10:00:00	AMZN	Stock	1.7305	1.736	1.7305	1.7345	9155220.0
2005-04-07 11:00:00	AMZN	Stock	1.734	1.735	1.7275	1.7325	13231400.0
2005-04-07 12:00:00	AMZN	Stock	1.7325	1.7395	1.73	1.7375	6300500.0
2005-04-07 13:00:00	AMZN	Stock	1.7375	1.741	1.7315	1.732	11832900.0
2005-04-07 14:00:00	AMZN	Stock	1.7315	1.743	1.7315	1.741	11318040.0
2005-04-07 15:00:00	AMZN	Stock	1.741	1.746	1.7395	1.7455	12695720.0
2005-04-07 16:00:00	AMZN	Stock	1.745	1.745	1.7435	1.744	675320.0
2005-04-07 17:00:00	AMZN	Stock	1.7445	1.745	1.7355	1.745	226460.0
2005-04-07 09:00:00	CL	Stock	26.455	26.49	26.405	26.44	187200.0
2005-04-07 10:00:00	CL	Stock	26.42	26.46	26.315	26.415	466800.0
2005-04-07 11:00:00	CL	Stock	26.41	26.525	26.37	26.5	376400.0
2005-04-07 12:00:00	CL	Stock	26.49	26.7	26.44	26.635	613800.0
2005-04-07 13:00:00	CL	Stock	26.635	26.645	26.535	26.62	358600.0
2005-04-07 14:00:00	CL	Stock	26.62	26.75	26.57	26.73	460000.0
2005-04-07 15:00:00	CL	Stock	26.725	26.765	26.68	26.765	706400.0
2005-04-07 16:00:00	CL	Stock	26.775	26.775	26.77	26.77	9200.0

> showing 50 of 26,088 rows — these rows as CSV

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