PREVIEW / stock_1hour / 2004-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2004/2004-08-18.parquet
  size:    502 KB
  rows:    23,717
  symbols: 1,820

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-18 08:00:00	AAPL	Stock	0.5393	0.5473	0.5393	0.5473	137200.0
2004-08-18 09:00:00	AAPL	Stock	0.5464	0.5536	0.5445	0.5514	28426776.0
2004-08-18 10:00:00	AAPL	Stock	0.5516	0.5639	0.5514	0.5607	76867056.0
2004-08-18 11:00:00	AAPL	Stock	0.5611	0.5621	0.5588	0.5614	22369704.0
2004-08-18 12:00:00	AAPL	Stock	0.5614	0.567	0.5613	0.5646	28890736.0
2004-08-18 13:00:00	AAPL	Stock	0.5646	0.5679	0.5623	0.5654	43222312.0
2004-08-18 14:00:00	AAPL	Stock	0.5654	0.5673	0.5629	0.565	42855960.0
2004-08-18 15:00:00	AAPL	Stock	0.565	0.5688	0.5629	0.5675	96197528.0
2004-08-18 16:00:00	AAPL	Stock	0.567	0.5677	0.5657	0.567	10243184.0
2004-08-18 17:00:00	AAPL	Stock	0.5663	0.5663	0.5663	0.5663	67200.0
2004-08-18 18:00:00	AAPL	Stock	0.5663	0.5663	0.5663	0.5663	5600.0
2004-08-18 08:00:00	MSFT	Stock	27.05	27.05	26.95	27.05	12673.0
2004-08-18 09:00:00	MSFT	Stock	27.02	27.05	26.89	26.99	4373581.0
2004-08-18 10:00:00	MSFT	Stock	26.99	27.26	26.98	27.2	9576140.0
2004-08-18 11:00:00	MSFT	Stock	27.21	27.23	27.1	27.14	7157095.0
2004-08-18 12:00:00	MSFT	Stock	27.13	27.161	27.1	27.119	3014550.0
2004-08-18 13:00:00	MSFT	Stock	27.11	27.2	27.1	27.16	3707175.0
2004-08-18 14:00:00	MSFT	Stock	27.15	27.28	27.15	27.27	8187911.0
2004-08-18 15:00:00	MSFT	Stock	27.27	27.5	27.2	27.47	13725133.0
2004-08-18 16:00:00	MSFT	Stock	27.47	27.51	27.45	27.45	5547812.0
2004-08-18 17:00:00	MSFT	Stock	27.43	27.48	27.42	27.45	25000.0
2004-08-18 18:00:00	MSFT	Stock	27.45	27.46	27.45	27.46	2100.0
2004-08-18 08:00:00	NVDA	Stock	0.0921	0.0925	0.0916	0.0925	1284000.0
2004-08-18 09:00:00	NVDA	Stock	0.0922	0.0942	0.0911	0.0936	135279000.0
2004-08-18 10:00:00	NVDA	Stock	0.0937	0.0963	0.0934	0.0957	165881040.0
2004-08-18 11:00:00	NVDA	Stock	0.0958	0.096	0.095	0.0958	111394200.0
2004-08-18 12:00:00	NVDA	Stock	0.0959	0.0959	0.0952	0.0956	41918040.0
2004-08-18 13:00:00	NVDA	Stock	0.0955	0.0961	0.0949	0.0951	85293840.0
2004-08-18 14:00:00	NVDA	Stock	0.0951	0.0967	0.0951	0.0967	97720080.0
2004-08-18 15:00:00	NVDA	Stock	0.0967	0.0975	0.0965	0.0975	153102360.0
2004-08-18 16:00:00	NVDA	Stock	0.0975	0.0977	0.097	0.0973	10541040.0
2004-08-18 17:00:00	NVDA	Stock	0.0973	0.0975	0.0972	0.0972	204000.0
2004-08-18 18:00:00	NVDA	Stock	0.0968	0.0975	0.0967	0.0975	569520.0
2004-08-18 08:00:00	AMZN	Stock	1.901	1.901	1.8855	1.8875	86000.0
2004-08-18 09:00:00	AMZN	Stock	1.883	1.9025	1.871	1.892	24193740.0
2004-08-18 10:00:00	AMZN	Stock	1.892	1.9275	1.8915	1.9205	39898360.0
2004-08-18 11:00:00	AMZN	Stock	1.9215	1.9245	1.904	1.9125	16438520.0
2004-08-18 12:00:00	AMZN	Stock	1.912	1.925	1.902	1.9235	12657140.0
2004-08-18 13:00:00	AMZN	Stock	1.923	1.9535	1.92	1.9455	24997720.0
2004-08-18 14:00:00	AMZN	Stock	1.9455	1.956	1.942	1.9475	21374960.0
2004-08-18 15:00:00	AMZN	Stock	1.9475	1.977	1.943	1.966	44479080.0
2004-08-18 16:00:00	AMZN	Stock	1.966	1.974	1.963	1.97	1512600.0
2004-08-18 17:00:00	AMZN	Stock	1.97	1.9705	1.9675	1.97	168080.0
2004-08-18 09:00:00	CL	Stock	25.815	25.97	25.8	25.915	182600.0
2004-08-18 10:00:00	CL	Stock	25.91	25.995	25.9	25.905	338400.0
2004-08-18 11:00:00	CL	Stock	25.905	25.905	25.78	25.825	337400.0
2004-08-18 12:00:00	CL	Stock	25.82	25.82	25.78	25.805	190600.0
2004-08-18 13:00:00	CL	Stock	25.8	25.835	25.78	25.79	197600.0
2004-08-18 14:00:00	CL	Stock	25.79	25.925	25.775	25.925	569800.0
2004-08-18 15:00:00	CL	Stock	25.92	26.07	25.915	26.07	1017400.0

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

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