PREVIEW / stock_1hour / 2008-02-12

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-12.parquet
  size:    813 KB
  rows:    40,504
  symbols: 3,284

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
2008-02-12 05:00:00	AAPL	Stock	4.6418	4.6429	4.6418	4.6429	11200.0
2008-02-12 06:00:00	AAPL	Stock	4.6439	4.6782	4.6439	4.6714	119560.0
2008-02-12 07:00:00	AAPL	Stock	4.6643	4.6786	4.6482	4.6589	448280.0
2008-02-12 08:00:00	AAPL	Stock	4.6529	4.6754	4.6429	4.6704	5684028.0
2008-02-12 09:00:00	AAPL	Stock	4.6704	4.6786	4.6071	4.6071	176868776.0
2008-02-12 10:00:00	AAPL	Stock	4.6071	4.6525	4.5811	4.6519	252629748.0
2008-02-12 11:00:00	AAPL	Stock	4.6518	4.6529	4.5968	4.5989	101702580.0
2008-02-12 12:00:00	AAPL	Stock	4.5989	4.6043	4.5364	4.5611	128188732.0
2008-02-12 13:00:00	AAPL	Stock	4.5611	4.5625	4.5089	4.544	114413740.0
2008-02-12 14:00:00	AAPL	Stock	4.5439	4.5443	4.4857	4.5182	125077400.0
2008-02-12 15:00:00	AAPL	Stock	4.5186	4.5193	4.415	4.46	302277472.0
2008-02-12 16:00:00	AAPL	Stock	4.4611	4.5569	4.4536	4.4707	17100944.0
2008-02-12 17:00:00	AAPL	Stock	4.4714	4.6061	4.4643	4.4664	503860.0
2008-02-12 18:00:00	AAPL	Stock	4.4732	4.4732	4.4679	4.4714	123368.0
2008-02-12 19:00:00	AAPL	Stock	4.4714	4.4714	4.4554	4.4557	842716.0
2008-02-12 06:00:00	MSFT	Stock	28.23	28.23	28.23	28.23	200.0
2008-02-12 07:00:00	MSFT	Stock	28.3	28.45	28.28	28.28	29320.0
2008-02-12 08:00:00	MSFT	Stock	28.3	28.44	28.3	28.4	93361.0
2008-02-12 09:00:00	MSFT	Stock	28.4	28.62	28.319	28.41	14653135.0
2008-02-12 10:00:00	MSFT	Stock	28.41	28.604	28.4	28.5	11929782.0
2008-02-12 11:00:00	MSFT	Stock	28.5	28.5	28.26	28.27	8587544.0
2008-02-12 12:00:00	MSFT	Stock	28.28	28.33	28.11	28.22	8317404.0
2008-02-12 13:00:00	MSFT	Stock	28.23	28.38	28.22	28.36	7477156.0
2008-02-12 14:00:00	MSFT	Stock	28.35	28.41	28.28	28.4	8878557.0
2008-02-12 15:00:00	MSFT	Stock	28.41	28.41	28.14	28.34	20745502.0
2008-02-12 16:00:00	MSFT	Stock	28.33	28.425	28.28	28.31	3605702.0
2008-02-12 17:00:00	MSFT	Stock	28.32	28.36	28.32	28.34	22889.0
2008-02-12 18:00:00	MSFT	Stock	28.33	28.35	28.33	28.35	7950.0
2008-02-12 19:00:00	MSFT	Stock	28.35	28.35	28.33	28.35	17360.0
2008-02-12 09:00:00	NVDA	Stock	0.6355	0.6423	0.6328	0.6415	70925280.0
2008-02-12 10:00:00	NVDA	Stock	0.6418	0.657	0.641	0.6548	116465120.0
2008-02-12 11:00:00	NVDA	Stock	0.6545	0.659	0.6513	0.656	58834320.0
2008-02-12 12:00:00	NVDA	Stock	0.656	0.6575	0.6485	0.6522	54731640.0
2008-02-12 13:00:00	NVDA	Stock	0.6522	0.6568	0.649	0.6515	56495320.0
2008-02-12 14:00:00	NVDA	Stock	0.6515	0.6545	0.647	0.6538	86304680.0
2008-02-12 15:00:00	NVDA	Stock	0.6538	0.654	0.641	0.65	146098960.0
2008-02-12 16:00:00	NVDA	Stock	0.6513	0.6532	0.649	0.65	7246760.0
2008-02-12 17:00:00	NVDA	Stock	0.6532	0.656	0.6532	0.656	2154000.0
2008-02-12 18:00:00	NVDA	Stock	0.6558	0.6558	0.655	0.655	47400.0
2008-02-12 19:00:00	NVDA	Stock	0.655	0.6553	0.6538	0.6553	143720.0
2008-02-12 07:00:00	AMZN	Stock	3.795	3.795	3.795	3.795	2000.0
2008-02-12 08:00:00	AMZN	Stock	3.775	3.79	3.775	3.7845	71060.0
2008-02-12 09:00:00	AMZN	Stock	3.785	3.81	3.7445	3.798	21714960.0
2008-02-12 10:00:00	AMZN	Stock	3.7965	3.8275	3.784	3.8225	26442080.0
2008-02-12 11:00:00	AMZN	Stock	3.8235	3.839	3.811	3.82	15292960.0
2008-02-12 12:00:00	AMZN	Stock	3.8198	3.8335	3.7975	3.8315	21778420.0
2008-02-12 13:00:00	AMZN	Stock	3.832	3.8525	3.824	3.849	18003180.0
2008-02-12 14:00:00	AMZN	Stock	3.8495	3.85	3.7855	3.7955	26286580.0
2008-02-12 15:00:00	AMZN	Stock	3.7945	3.7975	3.6895	3.723	50655060.0
2008-02-12 16:00:00	AMZN	Stock	3.7235	3.7956	3.6645	3.7225	6992140.0

> showing 50 of 40,504 rows — these rows as CSV

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