PREVIEW / stock_1hour / 2004-08-11

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-11.parquet
  size:    502 KB
  rows:    23,805
  symbols: 1,821

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-08-11 08:00:00	AAPL	Stock	0.5571	0.5571	0.5536	0.5536	11200.0
2004-08-11 09:00:00	AAPL	Stock	0.5536	0.5559	0.545	0.5457	46316984.0
2004-08-11 10:00:00	AAPL	Stock	0.5459	0.5504	0.5413	0.5491	60530568.0
2004-08-11 11:00:00	AAPL	Stock	0.5491	0.5504	0.5411	0.5432	29627080.0
2004-08-11 12:00:00	AAPL	Stock	0.5432	0.5464	0.5404	0.5459	21785456.0
2004-08-11 13:00:00	AAPL	Stock	0.5459	0.5489	0.5423	0.5457	29677816.0
2004-08-11 14:00:00	AAPL	Stock	0.5457	0.5488	0.5429	0.5488	53048352.0
2004-08-11 15:00:00	AAPL	Stock	0.5488	0.5543	0.5488	0.5536	61086872.0
2004-08-11 16:00:00	AAPL	Stock	0.5536	0.5557	0.5534	0.5536	5040672.0
2004-08-11 18:00:00	AAPL	Stock	0.553	0.553	0.5502	0.5502	33600.0
2004-08-11 08:00:00	MSFT	Stock	27.46	27.73	27.35	27.42	204500.0
2004-08-11 09:00:00	MSFT	Stock	27.43	27.51	27.31	27.41	6712128.0
2004-08-11 10:00:00	MSFT	Stock	27.41	27.44	27.21	27.36	9743934.0
2004-08-11 11:00:00	MSFT	Stock	27.37	27.4	27.2	27.229	9486944.0
2004-08-11 12:00:00	MSFT	Stock	27.2207	27.29	27.2	27.25	3903846.0
2004-08-11 13:00:00	MSFT	Stock	27.24	27.36	27.21	27.28	5329661.0
2004-08-11 14:00:00	MSFT	Stock	27.28	27.44	27.21	27.42	5800184.0
2004-08-11 15:00:00	MSFT	Stock	27.42	27.47	27.27	27.41	8759076.0
2004-08-11 16:00:00	MSFT	Stock	27.41	27.4102	27.204	27.41	431680.0
2004-08-11 17:00:00	MSFT	Stock	27.39	27.42	27.36	27.42	668200.0
2004-08-11 18:00:00	MSFT	Stock	27.41	27.41	27.41	27.41	200.0
2004-08-11 08:00:00	NVDA	Stock	0.0858	0.0862	0.0858	0.0862	1344000.0
2004-08-11 09:00:00	NVDA	Stock	0.0861	0.0885	0.0858	0.0867	187058640.0
2004-08-11 10:00:00	NVDA	Stock	0.0866	0.0869	0.0858	0.0867	167317320.0
2004-08-11 11:00:00	NVDA	Stock	0.0867	0.0868	0.0861	0.0864	184092840.0
2004-08-11 12:00:00	NVDA	Stock	0.0863	0.0867	0.086	0.086	63505560.0
2004-08-11 13:00:00	NVDA	Stock	0.0861	0.0868	0.0855	0.0859	66998640.0
2004-08-11 14:00:00	NVDA	Stock	0.0859	0.0866	0.0854	0.0862	67861200.0
2004-08-11 15:00:00	NVDA	Stock	0.0862	0.0868	0.0858	0.086	183840720.0
2004-08-11 16:00:00	NVDA	Stock	0.086	0.0864	0.0859	0.0859	5325960.0
2004-08-11 17:00:00	NVDA	Stock	0.0859	0.0862	0.0859	0.0862	480000.0
2004-08-11 18:00:00	NVDA	Stock	0.0858	0.0862	0.0858	0.0862	274680.0
2004-08-11 08:00:00	AMZN	Stock	1.82	1.8285	1.82	1.82	99500.0
2004-08-11 09:00:00	AMZN	Stock	1.817	1.855	1.7845	1.788	33222360.0
2004-08-11 10:00:00	AMZN	Stock	1.7875	1.823	1.78	1.823	35395040.0
2004-08-11 11:00:00	AMZN	Stock	1.823	1.842	1.8115	1.823	28800560.0
2004-08-11 12:00:00	AMZN	Stock	1.8235	1.8245	1.808	1.811	14137460.0
2004-08-11 13:00:00	AMZN	Stock	1.8115	1.8295	1.8085	1.8125	12615760.0
2004-08-11 14:00:00	AMZN	Stock	1.812	1.8345	1.802	1.8345	20693780.0
2004-08-11 15:00:00	AMZN	Stock	1.8345	1.845	1.8205	1.8275	35090880.0
2004-08-11 16:00:00	AMZN	Stock	1.8275	1.83	1.8075	1.828	770620.0
2004-08-11 17:00:00	AMZN	Stock	1.828	1.828	1.828	1.828	43300.0
2004-08-11 18:00:00	AMZN	Stock	1.828	1.828	1.828	1.828	24000.0
2004-08-11 09:00:00	CL	Stock	26.115	26.22	26.09	26.095	308600.0
2004-08-11 10:00:00	CL	Stock	26.095	26.1	25.675	25.85	1798800.0
2004-08-11 11:00:00	CL	Stock	25.845	25.91	25.755	25.835	729200.0
2004-08-11 12:00:00	CL	Stock	25.845	25.87	25.81	25.855	283400.0
2004-08-11 13:00:00	CL	Stock	25.85	25.895	25.825	25.86	532200.0
2004-08-11 14:00:00	CL	Stock	25.86	25.975	25.83	25.975	781000.0
2004-08-11 15:00:00	CL	Stock	25.975	26.15	25.925	26.11	1058600.0

> showing 50 of 23,805 rows — these rows as CSV

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