PREVIEW / stock_1hour / 2005-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2005/2005-05-31.parquet
  size:    563 KB
  rows:    26,546
  symbols: 1,994

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-05-31 08:00:00	AAPL	Stock	1.4429	1.4443	1.4386	1.4429	300860.0
2005-05-31 09:00:00	AAPL	Stock	1.4411	1.4554	1.4354	1.4371	47103868.0
2005-05-31 10:00:00	AAPL	Stock	1.4375	1.4532	1.4364	1.4429	60632152.0
2005-05-31 11:00:00	AAPL	Stock	1.4429	1.4486	1.4375	1.4389	38281572.0
2005-05-31 12:00:00	AAPL	Stock	1.4389	1.4432	1.4371	1.439	26457704.0
2005-05-31 13:00:00	AAPL	Stock	1.4393	1.4536	1.4386	1.4404	24664528.0
2005-05-31 14:00:00	AAPL	Stock	1.4404	1.4421	1.4375	1.4407	37124164.0
2005-05-31 15:00:00	AAPL	Stock	1.4407	1.4411	1.4136	1.4182	135015580.0
2005-05-31 16:00:00	AAPL	Stock	1.4196	1.4218	1.4179	1.4182	5037480.0
2005-05-31 17:00:00	AAPL	Stock	1.4191	1.4354	1.4182	1.4211	1494892.0
2005-05-31 18:00:00	AAPL	Stock	1.4229	1.4229	1.4229	1.4229	33600.0
2005-05-31 07:00:00	MSFT	Stock	26.0	26.01	25.97	26.01	4000.0
2005-05-31 08:00:00	MSFT	Stock	26.01	26.05	26.01	26.03	29378.0
2005-05-31 09:00:00	MSFT	Stock	26.02	26.03	25.94	25.949	5388466.0
2005-05-31 10:00:00	MSFT	Stock	25.94	26.01	25.85	25.85	6071047.0
2005-05-31 11:00:00	MSFT	Stock	25.85	25.9	25.79	25.86	5380580.0
2005-05-31 12:00:00	MSFT	Stock	25.87	25.94	25.84	25.86	3490561.0
2005-05-31 13:00:00	MSFT	Stock	25.85	25.88	25.83	25.83	2858055.0
2005-05-31 14:00:00	MSFT	Stock	25.83	25.97	25.75	25.842	4699308.0
2005-05-31 15:00:00	MSFT	Stock	25.85	25.96	25.79	25.81	10117010.0
2005-05-31 16:00:00	MSFT	Stock	25.81	25.83	25.75	25.8	1420770.0
2005-05-31 17:00:00	MSFT	Stock	25.816	25.82	25.8	25.8	510354.0
2005-05-31 18:00:00	MSFT	Stock	25.8	25.8	25.8	25.8	1000.0
2005-05-31 08:00:00	NVDA	Stock	0.2271	0.2293	0.2271	0.2293	84000.0
2005-05-31 09:00:00	NVDA	Stock	0.2287	0.2302	0.2239	0.2242	82608360.0
2005-05-31 10:00:00	NVDA	Stock	0.2242	0.2264	0.2221	0.2247	163008240.0
2005-05-31 11:00:00	NVDA	Stock	0.2247	0.2288	0.2238	0.2256	60537360.0
2005-05-31 12:00:00	NVDA	Stock	0.2255	0.2257	0.2237	0.2252	43934640.0
2005-05-31 13:00:00	NVDA	Stock	0.2252	0.2266	0.2251	0.2266	30651840.0
2005-05-31 14:00:00	NVDA	Stock	0.2265	0.2273	0.2254	0.2266	98760960.0
2005-05-31 15:00:00	NVDA	Stock	0.2266	0.2268	0.2256	0.2265	172806840.0
2005-05-31 16:00:00	NVDA	Stock	0.2263	0.2271	0.2251	0.2266	22215960.0
2005-05-31 17:00:00	NVDA	Stock	0.2267	0.2267	0.2258	0.2266	1209840.0
2005-05-31 18:00:00	NVDA	Stock	0.2261	0.2266	0.2261	0.2266	121680.0
2005-05-31 08:00:00	AMZN	Stock	1.777	1.777	1.777	1.777	2000.0
2005-05-31 09:00:00	AMZN	Stock	1.772	1.7815	1.7645	1.772	8868120.0
2005-05-31 10:00:00	AMZN	Stock	1.772	1.802	1.772	1.789	21215000.0
2005-05-31 11:00:00	AMZN	Stock	1.7895	1.791	1.776	1.777	14194240.0
2005-05-31 12:00:00	AMZN	Stock	1.7765	1.778	1.772	1.7735	6595760.0
2005-05-31 13:00:00	AMZN	Stock	1.7735	1.775	1.771	1.7745	4187580.0
2005-05-31 14:00:00	AMZN	Stock	1.7745	1.7765	1.768	1.776	9932680.0
2005-05-31 15:00:00	AMZN	Stock	1.7765	1.781	1.7725	1.7755	20989140.0
2005-05-31 16:00:00	AMZN	Stock	1.7805	1.7805	1.775	1.776	1183440.0
2005-05-31 17:00:00	AMZN	Stock	1.7766	1.777	1.7718	1.7718	322720.0
2005-05-31 18:00:00	AMZN	Stock	1.7755	1.7775	1.7725	1.7775	11120.0
2005-05-31 09:00:00	CL	Stock	25.08	25.13	25.035	25.045	482200.0
2005-05-31 10:00:00	CL	Stock	25.06	25.115	25.0	25.01	442000.0
2005-05-31 11:00:00	CL	Stock	25.01	25.0105	24.94	24.98	240000.0
2005-05-31 12:00:00	CL	Stock	24.985	25.02	24.97	25.0	197400.0
2005-05-31 13:00:00	CL	Stock	24.995	25.02	24.97	25.0	163400.0

> showing 50 of 26,546 rows — these rows as CSV

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