PREVIEW / stock_1hour / 2004-08-31

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-31.parquet
  size:    502 KB
  rows:    23,786
  symbols: 1,817

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-31 08:00:00	AAPL	Stock	0.6121	0.6121	0.6021	0.6118	853440.0
2004-08-31 09:00:00	AAPL	Stock	0.612	0.6241	0.6077	0.6232	78446480.0
2004-08-31 10:00:00	AAPL	Stock	0.6227	0.6232	0.6129	0.6138	64251432.0
2004-08-31 11:00:00	AAPL	Stock	0.6136	0.6136	0.6071	0.6084	53751768.0
2004-08-31 12:00:00	AAPL	Stock	0.6084	0.6129	0.6079	0.6096	25453736.0
2004-08-31 13:00:00	AAPL	Stock	0.6096	0.6114	0.608	0.6109	19014576.0
2004-08-31 14:00:00	AAPL	Stock	0.6106	0.612	0.6082	0.6111	47924352.0
2004-08-31 15:00:00	AAPL	Stock	0.6113	0.6154	0.6096	0.6148	51143400.0
2004-08-31 16:00:00	AAPL	Stock	0.6141	0.6159	0.6129	0.6159	17553704.0
2004-08-31 17:00:00	AAPL	Stock	0.6159	0.6178	0.6159	0.6178	2718800.0
2004-08-31 18:00:00	AAPL	Stock	0.6132	0.6132	0.6132	0.6132	28000.0
2004-08-31 08:00:00	MSFT	Stock	27.305	27.31	27.3	27.31	124028.0
2004-08-31 09:00:00	MSFT	Stock	27.31	27.32	27.19	27.21	4175949.0
2004-08-31 10:00:00	MSFT	Stock	27.21	27.22	27.11	27.12	7773150.0
2004-08-31 11:00:00	MSFT	Stock	27.12	27.15	27.06	27.09	5039928.0
2004-08-31 12:00:00	MSFT	Stock	27.09	27.1482	27.05	27.11	4405154.0
2004-08-31 13:00:00	MSFT	Stock	27.11	27.15	27.09	27.111	5595918.0
2004-08-31 14:00:00	MSFT	Stock	27.11	27.2	27.07	27.18	6623308.0
2004-08-31 15:00:00	MSFT	Stock	27.17	27.32	27.13	27.31	11041217.0
2004-08-31 16:00:00	MSFT	Stock	27.32	27.33	27.28	27.3	4308632.0
2004-08-31 17:00:00	MSFT	Stock	27.3	27.3	27.28	27.28	165785.0
2004-08-31 08:00:00	NVDA	Stock	0.1043	0.1044	0.1042	0.1043	3926400.0
2004-08-31 09:00:00	NVDA	Stock	0.1043	0.1052	0.1037	0.1037	42929520.0
2004-08-31 10:00:00	NVDA	Stock	0.1037	0.1037	0.1017	0.1021	118374720.0
2004-08-31 11:00:00	NVDA	Stock	0.1021	0.1021	0.1006	0.1015	88945920.0
2004-08-31 12:00:00	NVDA	Stock	0.1014	0.1034	0.1012	0.1024	79936080.0
2004-08-31 13:00:00	NVDA	Stock	0.1024	0.1036	0.1022	0.1032	48525240.0
2004-08-31 14:00:00	NVDA	Stock	0.1032	0.1042	0.1027	0.1041	59586120.0
2004-08-31 15:00:00	NVDA	Stock	0.1041	0.1043	0.103	0.1037	117713760.0
2004-08-31 16:00:00	NVDA	Stock	0.1037	0.1039	0.1032	0.1038	6462720.0
2004-08-31 17:00:00	NVDA	Stock	0.1038	0.1038	0.1038	0.1038	2574000.0
2004-08-31 18:00:00	NVDA	Stock	0.103	0.103	0.1029	0.1029	60000.0
2004-08-31 08:00:00	AMZN	Stock	1.9175	1.921	1.9125	1.921	1423460.0
2004-08-31 09:00:00	AMZN	Stock	1.9205	1.9425	1.9105	1.9385	14678520.0
2004-08-31 10:00:00	AMZN	Stock	1.938	1.9385	1.893	1.903	32211220.0
2004-08-31 11:00:00	AMZN	Stock	1.9025	1.909	1.898	1.905	11176880.0
2004-08-31 12:00:00	AMZN	Stock	1.905	1.9125	1.9025	1.905	5978020.0
2004-08-31 13:00:00	AMZN	Stock	1.9045	1.9075	1.8995	1.9035	7152120.0
2004-08-31 14:00:00	AMZN	Stock	1.9035	1.911	1.8965	1.9095	17703060.0
2004-08-31 15:00:00	AMZN	Stock	1.9095	1.9145	1.9	1.907	22619880.0
2004-08-31 16:00:00	AMZN	Stock	1.906	1.913	1.9035	1.909	2517440.0
2004-08-31 17:00:00	AMZN	Stock	1.907	1.909	1.907	1.909	373600.0
2004-08-31 09:00:00	CL	Stock	26.83	26.95	26.76	26.9	184200.0
2004-08-31 10:00:00	CL	Stock	26.895	26.91	26.85	26.905	147200.0
2004-08-31 11:00:00	CL	Stock	26.9	26.9	26.805	26.835	227600.0
2004-08-31 12:00:00	CL	Stock	26.83	26.975	26.83	26.93	376000.0
2004-08-31 13:00:00	CL	Stock	26.925	26.93	26.86	26.895	198000.0
2004-08-31 14:00:00	CL	Stock	26.89	27.05	26.89	27.04	495000.0
2004-08-31 15:00:00	CL	Stock	27.04	27.045	26.94	26.98	764000.0
2004-08-31 16:00:00	CL	Stock	26.99	27.0	26.99	27.0	79800.0

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

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