PREVIEW / stock_1hour / 2009-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-05-26.parquet
  size:    849 KB
  rows:    41,503
  symbols: 3,353

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
2009-05-26 04:00:00	AAPL	Stock	4.3843	4.3843	4.3843	4.3843	2800.0
2009-05-26 05:00:00	AAPL	Stock	4.3836	4.4464	4.3836	4.4286	157556.0
2009-05-26 06:00:00	AAPL	Stock	4.4536	4.4643	4.4536	4.4643	352800.0
2009-05-26 07:00:00	AAPL	Stock	4.4643	4.4839	4.4643	4.4714	998704.0
2009-05-26 08:00:00	AAPL	Stock	4.4696	4.4918	4.4571	4.465	4318972.0
2009-05-26 09:00:00	AAPL	Stock	4.4654	4.5621	4.4471	4.5518	113820252.0
2009-05-26 10:00:00	AAPL	Stock	4.5518	4.6179	4.5505	4.6093	124511408.0
2009-05-26 11:00:00	AAPL	Stock	4.6093	4.6368	4.6043	4.6196	74183564.0
2009-05-26 12:00:00	AAPL	Stock	4.6196	4.6393	4.6114	4.6364	48224064.0
2009-05-26 13:00:00	AAPL	Stock	4.6368	4.6718	4.6343	4.6696	64773352.0
2009-05-26 14:00:00	AAPL	Stock	4.67	4.6725	4.6432	4.6446	64199968.0
2009-05-26 15:00:00	AAPL	Stock	4.6444	4.6711	4.6404	4.6696	119192416.0
2009-05-26 16:00:00	AAPL	Stock	4.6696	4.6743	4.6117	4.6736	15849736.0
2009-05-26 17:00:00	AAPL	Stock	4.6732	4.6786	4.6307	4.6754	1406748.0
2009-05-26 18:00:00	AAPL	Stock	4.6707	4.6871	4.6707	4.6839	2725240.0
2009-05-26 19:00:00	AAPL	Stock	4.6832	4.7	4.6832	4.6964	1049160.0
2009-05-26 07:00:00	MSFT	Stock	19.7	19.79	19.7	19.79	1400.0
2009-05-26 08:00:00	MSFT	Stock	19.75	19.82	19.65	19.66	12010.0
2009-05-26 09:00:00	MSFT	Stock	19.63	19.99	19.43	19.98	5455847.0
2009-05-26 10:00:00	MSFT	Stock	20.0	20.29	19.98	20.19	10265214.0
2009-05-26 11:00:00	MSFT	Stock	20.2	20.35	20.15	20.3	5294498.0
2009-05-26 12:00:00	MSFT	Stock	20.3	20.421	20.26	20.39	4130850.0
2009-05-26 13:00:00	MSFT	Stock	20.39	20.45	20.33	20.42	3780722.0
2009-05-26 14:00:00	MSFT	Stock	20.43	20.45	20.32	20.35	3726830.0
2009-05-26 15:00:00	MSFT	Stock	20.36	20.4	20.22	20.35	8875151.0
2009-05-26 16:00:00	MSFT	Stock	20.36	20.368	20.213	20.33	2608556.0
2009-05-26 17:00:00	MSFT	Stock	20.31	20.4	20.31	20.35	5200.0
2009-05-26 18:00:00	MSFT	Stock	20.35	20.35	20.35	20.35	2100.0
2009-05-26 19:00:00	MSFT	Stock	20.34	20.41	20.33	20.41	4214.0
2009-05-26 08:00:00	NVDA	Stock	0.2453	0.2458	0.2445	0.245	565000.0
2009-05-26 09:00:00	NVDA	Stock	0.245	0.2563	0.2408	0.2543	167330040.0
2009-05-26 10:00:00	NVDA	Stock	0.2543	0.2608	0.2538	0.258	196711080.0
2009-05-26 11:00:00	NVDA	Stock	0.2578	0.2585	0.2553	0.2558	69315320.0
2009-05-26 12:00:00	NVDA	Stock	0.2555	0.2575	0.254	0.2565	66796400.0
2009-05-26 13:00:00	NVDA	Stock	0.2565	0.257	0.2547	0.2564	50394160.0
2009-05-26 14:00:00	NVDA	Stock	0.2565	0.2575	0.256	0.2565	68062840.0
2009-05-26 15:00:00	NVDA	Stock	0.2563	0.259	0.2563	0.2585	210859240.0
2009-05-26 16:00:00	NVDA	Stock	0.2585	0.26	0.2565	0.258	22333400.0
2009-05-26 17:00:00	NVDA	Stock	0.2585	0.2588	0.2572	0.2575	294000.0
2009-05-26 18:00:00	NVDA	Stock	0.2575	0.2575	0.2575	0.2575	4000.0
2009-05-26 08:00:00	AMZN	Stock	3.777	3.777	3.773	3.775	37980.0
2009-05-26 09:00:00	AMZN	Stock	3.765	3.8325	3.7275	3.824	18436520.0
2009-05-26 10:00:00	AMZN	Stock	3.8275	3.9235	3.8265	3.8795	36633520.0
2009-05-26 11:00:00	AMZN	Stock	3.8785	3.8985	3.8525	3.8928	14079380.0
2009-05-26 12:00:00	AMZN	Stock	3.8925	3.9165	3.881	3.9108	10293900.0
2009-05-26 13:00:00	AMZN	Stock	3.91	3.92	3.89	3.9117	10070360.0
2009-05-26 14:00:00	AMZN	Stock	3.9115	3.924	3.897	3.9005	11954640.0
2009-05-26 15:00:00	AMZN	Stock	3.9015	3.92	3.8875	3.9195	24893980.0
2009-05-26 16:00:00	AMZN	Stock	3.9135	3.925	3.8776	3.9155	6938060.0
2009-05-26 17:00:00	AMZN	Stock	3.917	3.917	3.9115	3.9115	20000.0

> showing 50 of 41,503 rows — these rows as CSV

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