PREVIEW / stock_1hour / 2004-08-20

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-20.parquet
  size:    496 KB
  rows:    23,569
  symbols: 1,813

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-20 08:00:00	AAPL	Stock	0.547	0.5482	0.547	0.5482	89040.0
2004-08-20 09:00:00	AAPL	Stock	0.5473	0.5527	0.5459	0.5502	33173056.0
2004-08-20 10:00:00	AAPL	Stock	0.5502	0.5521	0.5445	0.5459	47372528.0
2004-08-20 11:00:00	AAPL	Stock	0.5459	0.5473	0.5457	0.5464	27544832.0
2004-08-20 12:00:00	AAPL	Stock	0.5463	0.5491	0.5452	0.5489	25683896.0
2004-08-20 13:00:00	AAPL	Stock	0.5489	0.5509	0.5486	0.5495	31810912.0
2004-08-20 14:00:00	AAPL	Stock	0.5495	0.5527	0.5491	0.5518	46704728.0
2004-08-20 15:00:00	AAPL	Stock	0.5518	0.5534	0.5489	0.5498	65653056.0
2004-08-20 16:00:00	AAPL	Stock	0.5498	0.5511	0.5498	0.55	3855488.0
2004-08-20 17:00:00	AAPL	Stock	0.55	0.55	0.55	0.55	397600.0
2004-08-20 08:00:00	MSFT	Stock	27.05	27.05	27.04	27.04	5100.0
2004-08-20 09:00:00	MSFT	Stock	27.09	27.17	27.01	27.11	4065425.0
2004-08-20 10:00:00	MSFT	Stock	27.11	27.19	27.1	27.16	4933837.0
2004-08-20 11:00:00	MSFT	Stock	27.16	27.17	27.0699	27.1	5658369.0
2004-08-20 12:00:00	MSFT	Stock	27.1	27.22	27.08	27.2	4213252.0
2004-08-20 13:00:00	MSFT	Stock	27.19	27.21	27.14	27.17	3179351.0
2004-08-20 14:00:00	MSFT	Stock	27.18	27.23	27.13	27.23	4788885.0
2004-08-20 15:00:00	MSFT	Stock	27.22	27.37	27.17	27.19	14940077.0
2004-08-20 16:00:00	MSFT	Stock	27.19	27.25	27.18	27.2	3179892.0
2004-08-20 17:00:00	MSFT	Stock	27.24	27.24	27.21	27.21	2300.0
2004-08-20 18:00:00	MSFT	Stock	27.21	27.21	27.21	27.21	4000.0
2004-08-20 08:00:00	NVDA	Stock	0.0978	0.0978	0.097	0.097	280800.0
2004-08-20 09:00:00	NVDA	Stock	0.0969	0.0992	0.0958	0.0991	124535760.0
2004-08-20 10:00:00	NVDA	Stock	0.099	0.0999	0.0987	0.0995	180704520.0
2004-08-20 11:00:00	NVDA	Stock	0.0993	0.0997	0.0986	0.0992	104453280.0
2004-08-20 12:00:00	NVDA	Stock	0.0992	0.101	0.0992	0.1009	130784760.0
2004-08-20 13:00:00	NVDA	Stock	0.1008	0.1026	0.1005	0.1024	173318280.0
2004-08-20 14:00:00	NVDA	Stock	0.1024	0.1037	0.1018	0.1024	201893640.0
2004-08-20 15:00:00	NVDA	Stock	0.1024	0.1043	0.1023	0.1029	249467640.0
2004-08-20 16:00:00	NVDA	Stock	0.1032	0.1032	0.1023	0.1029	4231800.0
2004-08-20 17:00:00	NVDA	Stock	0.1029	0.104	0.1028	0.1037	616800.0
2004-08-20 18:00:00	NVDA	Stock	0.1037	0.1037	0.1036	0.1036	234000.0
2004-08-20 08:00:00	AMZN	Stock	1.9155	1.9245	1.908	1.9175	108000.0
2004-08-20 09:00:00	AMZN	Stock	1.9175	1.965	1.9055	1.9605	28007000.0
2004-08-20 10:00:00	AMZN	Stock	1.9605	1.9755	1.9595	1.964	26623200.0
2004-08-20 11:00:00	AMZN	Stock	1.9645	1.9695	1.955	1.966	11243480.0
2004-08-20 12:00:00	AMZN	Stock	1.967	1.9795	1.9615	1.9785	9637760.0
2004-08-20 13:00:00	AMZN	Stock	1.9776	1.9825	1.9695	1.9795	9761140.0
2004-08-20 14:00:00	AMZN	Stock	1.978	1.9925	1.978	1.991	17678600.0
2004-08-20 15:00:00	AMZN	Stock	1.991	1.9955	1.9775	1.9775	25604360.0
2004-08-20 16:00:00	AMZN	Stock	1.977	1.984	1.9755	1.9815	1904380.0
2004-08-20 17:00:00	AMZN	Stock	1.9755	1.982	1.9755	1.9805	143760.0
2004-08-20 18:00:00	AMZN	Stock	1.98	1.98	1.98	1.98	20000.0
2004-08-20 09:00:00	CL	Stock	25.965	26.11	25.895	26.06	257800.0
2004-08-20 10:00:00	CL	Stock	26.06	26.2	26.015	26.125	352600.0
2004-08-20 11:00:00	CL	Stock	26.125	26.17	26.09	26.17	270000.0
2004-08-20 12:00:00	CL	Stock	26.17	26.305	26.135	26.3	255600.0
2004-08-20 13:00:00	CL	Stock	26.3	26.335	26.24	26.285	185400.0
2004-08-20 14:00:00	CL	Stock	26.285	26.38	26.28	26.32	336600.0
2004-08-20 15:00:00	CL	Stock	26.32	26.345	26.27	26.305	553000.0

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

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