PREVIEW / stock_1hour / 2005-07-21

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-07-21.parquet
  size:    572 KB
  rows:    27,064
  symbols: 2,027

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-07-21 07:00:00	AAPL	Stock	1.5714	1.5714	1.5714	1.5714	12600.0
2005-07-21 08:00:00	AAPL	Stock	1.5625	1.5721	1.5536	1.5586	1586508.0
2005-07-21 09:00:00	AAPL	Stock	1.5604	1.5729	1.5546	1.5675	80056480.0
2005-07-21 10:00:00	AAPL	Stock	1.5675	1.5696	1.5432	1.5468	74349520.0
2005-07-21 11:00:00	AAPL	Stock	1.5471	1.5629	1.5321	1.5521	51206344.0
2005-07-21 12:00:00	AAPL	Stock	1.5521	1.5636	1.5475	1.5604	40885656.0
2005-07-21 13:00:00	AAPL	Stock	1.5607	1.5661	1.5561	1.5586	28470344.0
2005-07-21 14:00:00	AAPL	Stock	1.5586	1.5596	1.5357	1.5364	54166980.0
2005-07-21 15:00:00	AAPL	Stock	1.5368	1.5489	1.5357	1.5464	62524140.0
2005-07-21 16:00:00	AAPL	Stock	1.5464	1.5518	1.5432	1.5432	1949780.0
2005-07-21 17:00:00	AAPL	Stock	1.5432	1.5456	1.5368	1.5375	309764.0
2005-07-21 18:00:00	AAPL	Stock	1.5375	1.5393	1.5375	1.5375	75600.0
2005-07-21 07:00:00	MSFT	Stock	26.3	26.3	26.21	26.21	7800.0
2005-07-21 08:00:00	MSFT	Stock	26.25	26.29	26.16	26.19	476672.0
2005-07-21 09:00:00	MSFT	Stock	26.19	26.47	26.19	26.46	15089613.0
2005-07-21 10:00:00	MSFT	Stock	26.46	26.47	26.24	26.32	20578997.0
2005-07-21 11:00:00	MSFT	Stock	26.32	26.39	26.3	26.36	8868875.0
2005-07-21 12:00:00	MSFT	Stock	26.36	26.42	26.26	26.38	14322117.0
2005-07-21 13:00:00	MSFT	Stock	26.38	26.45	26.31	26.37	10614746.0
2005-07-21 14:00:00	MSFT	Stock	26.36	26.4	26.19	26.21	12295025.0
2005-07-21 15:00:00	MSFT	Stock	26.21	26.48	26.2	26.44	24347447.0
2005-07-21 16:00:00	MSFT	Stock	26.44	26.5	25.59	25.88	5562123.0
2005-07-21 17:00:00	MSFT	Stock	25.88	26.442	25.82	25.9	444033.0
2005-07-21 18:00:00	MSFT	Stock	25.85	25.98	25.85	25.91	44438.0
2005-07-21 07:00:00	NVDA	Stock	0.2227	0.2227	0.2227	0.2227	12000.0
2005-07-21 08:00:00	NVDA	Stock	0.2167	0.2221	0.2167	0.2212	937440.0
2005-07-21 09:00:00	NVDA	Stock	0.2205	0.2233	0.2164	0.2179	140126280.0
2005-07-21 10:00:00	NVDA	Stock	0.2177	0.2202	0.2177	0.2186	88762080.0
2005-07-21 11:00:00	NVDA	Stock	0.2187	0.2209	0.2186	0.2198	69888960.0
2005-07-21 12:00:00	NVDA	Stock	0.2199	0.2223	0.2196	0.2215	56946360.0
2005-07-21 13:00:00	NVDA	Stock	0.2217	0.2223	0.2203	0.2205	52081200.0
2005-07-21 14:00:00	NVDA	Stock	0.2204	0.2214	0.2198	0.22	56254200.0
2005-07-21 15:00:00	NVDA	Stock	0.22	0.2213	0.2197	0.221	104198520.0
2005-07-21 16:00:00	NVDA	Stock	0.2209	0.2216	0.2198	0.2198	3189600.0
2005-07-21 17:00:00	NVDA	Stock	0.2209	0.2209	0.22	0.2208	826800.0
2005-07-21 18:00:00	NVDA	Stock	0.2213	0.2217	0.2213	0.2217	60000.0
2005-07-21 08:00:00	AMZN	Stock	1.9505	1.9505	1.94	1.941	106000.0
2005-07-21 09:00:00	AMZN	Stock	1.9415	1.955	1.9415	1.952	24860440.0
2005-07-21 10:00:00	AMZN	Stock	1.952	1.9875	1.9495	1.954	53880380.0
2005-07-21 11:00:00	AMZN	Stock	1.9545	1.955	1.935	1.9355	29859880.0
2005-07-21 12:00:00	AMZN	Stock	1.9355	1.938	1.911	1.938	36955120.0
2005-07-21 13:00:00	AMZN	Stock	1.938	1.939	1.919	1.9255	16329280.0
2005-07-21 14:00:00	AMZN	Stock	1.9255	1.926	1.888	1.8914	27276340.0
2005-07-21 15:00:00	AMZN	Stock	1.8915	1.907	1.89	1.8965	28651200.0
2005-07-21 16:00:00	AMZN	Stock	1.901	1.9115	1.8505	1.865	2077960.0
2005-07-21 17:00:00	AMZN	Stock	1.865	1.8975	1.865	1.874	578740.0
2005-07-21 18:00:00	AMZN	Stock	1.8745	1.8775	1.8745	1.8775	87720.0
2005-07-21 09:00:00	CL	Stock	25.71	25.71	25.535	25.62	330400.0
2005-07-21 10:00:00	CL	Stock	25.62	25.625	25.525	25.53	393400.0
2005-07-21 11:00:00	CL	Stock	25.53	25.66	25.525	25.655	285200.0

> showing 50 of 27,064 rows — these rows as CSV

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