PREVIEW / stock_1hour / 2009-12-16

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-12-16.parquet
  size:    920 KB
  rows:    44,727
  symbols: 3,438

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-12-16 07:00:00	AAPL	Stock	6.9714	6.9889	6.9654	6.9882	160272.0
2009-12-16 08:00:00	AAPL	Stock	6.9889	6.9889	6.9375	6.9611	1136016.0
2009-12-16 09:00:00	AAPL	Stock	6.9625	7.0054	6.9554	6.9982	60180512.0
2009-12-16 10:00:00	AAPL	Stock	6.9982	7.0179	6.9857	6.9889	57881236.0
2009-12-16 11:00:00	AAPL	Stock	6.9884	7.0036	6.9807	6.9964	35200088.0
2009-12-16 12:00:00	AAPL	Stock	6.9957	7.0057	6.9768	6.9775	23808988.0
2009-12-16 13:00:00	AAPL	Stock	6.9775	6.9907	6.9707	6.9718	17495800.0
2009-12-16 14:00:00	AAPL	Stock	6.9714	6.9964	6.9518	6.9604	60600876.0
2009-12-16 15:00:00	AAPL	Stock	6.9604	6.98	6.9482	6.9654	71478904.0
2009-12-16 16:00:00	AAPL	Stock	6.9654	6.9815	6.9346	6.9664	21898184.0
2009-12-16 17:00:00	AAPL	Stock	6.9996	6.9996	6.9661	6.9732	110208.0
2009-12-16 18:00:00	AAPL	Stock	6.9732	6.9746	6.9643	6.9679	207144.0
2009-12-16 19:00:00	AAPL	Stock	6.9711	6.9714	6.9679	6.9696	63112.0
2009-12-16 08:00:00	MSFT	Stock	30.1	30.18	30.1	30.14	10686.0
2009-12-16 09:00:00	MSFT	Stock	30.14	30.35	30.04	30.285	5262155.0
2009-12-16 10:00:00	MSFT	Stock	30.31	30.37	30.29	30.33	6800775.0
2009-12-16 11:00:00	MSFT	Stock	30.33	30.41	30.3	30.37	5732945.0
2009-12-16 12:00:00	MSFT	Stock	30.37	30.4	30.31	30.36	3797530.0
2009-12-16 13:00:00	MSFT	Stock	30.37	30.38	30.31	30.322	5795374.0
2009-12-16 14:00:00	MSFT	Stock	30.33	30.35	30.175	30.18	8299140.0
2009-12-16 15:00:00	MSFT	Stock	30.18	30.29	30.09	30.09	10582111.0
2009-12-16 16:00:00	MSFT	Stock	30.1	30.287	30.02	30.1	7322853.0
2009-12-16 17:00:00	MSFT	Stock	30.38	30.38	30.1	30.13	2750.0
2009-12-16 18:00:00	MSFT	Stock	30.1	30.13	30.1	30.1	1402.0
2009-12-16 19:00:00	MSFT	Stock	30.1	30.1	30.1	30.1	2084.0
2009-12-16 08:00:00	NVDA	Stock	0.393	0.404	0.3928	0.395	100000.0
2009-12-16 09:00:00	NVDA	Stock	0.399	0.4175	0.399	0.4142	307905800.0
2009-12-16 10:00:00	NVDA	Stock	0.4145	0.422	0.4125	0.42	404715280.0
2009-12-16 11:00:00	NVDA	Stock	0.42	0.4222	0.4175	0.4188	172424680.0
2009-12-16 12:00:00	NVDA	Stock	0.4188	0.42	0.416	0.4198	129163680.0
2009-12-16 13:00:00	NVDA	Stock	0.4198	0.4245	0.4192	0.4225	145390400.0
2009-12-16 14:00:00	NVDA	Stock	0.4228	0.4272	0.4208	0.424	238821440.0
2009-12-16 15:00:00	NVDA	Stock	0.424	0.4258	0.4215	0.4228	236002520.0
2009-12-16 16:00:00	NVDA	Stock	0.4228	0.424	0.3913	0.4228	28668760.0
2009-12-16 17:00:00	NVDA	Stock	0.4185	0.4232	0.4185	0.423	328000.0
2009-12-16 18:00:00	NVDA	Stock	0.4232	0.4238	0.423	0.4238	148000.0
2009-12-16 19:00:00	NVDA	Stock	0.4238	0.4242	0.423	0.4242	221080.0
2009-12-16 06:00:00	AMZN	Stock	6.524	6.524	6.524	6.524	6000.0
2009-12-16 07:00:00	AMZN	Stock	6.55	6.555	6.535	6.55	179000.0
2009-12-16 08:00:00	AMZN	Stock	6.555	6.5575	6.531	6.555	307700.0
2009-12-16 09:00:00	AMZN	Stock	6.552	6.5725	6.5125	6.555	19532380.0
2009-12-16 10:00:00	AMZN	Stock	6.555	6.571	6.4645	6.4866	45498120.0
2009-12-16 11:00:00	AMZN	Stock	6.4875	6.4925	6.433	6.454	29569680.0
2009-12-16 12:00:00	AMZN	Stock	6.4546	6.4585	6.4255	6.441	17940880.0
2009-12-16 13:00:00	AMZN	Stock	6.4405	6.468	6.4255	6.4335	12742780.0
2009-12-16 14:00:00	AMZN	Stock	6.433	6.446	6.3835	6.391	30191600.0
2009-12-16 15:00:00	AMZN	Stock	6.391	6.422	6.3825	6.4175	32771400.0
2009-12-16 16:00:00	AMZN	Stock	6.4175	6.5115	6.3983	6.4255	12315100.0
2009-12-16 17:00:00	AMZN	Stock	6.4305	6.433	6.4255	6.43	160140.0
2009-12-16 18:00:00	AMZN	Stock	6.4255	6.4325	6.425	6.4325	19000.0

> showing 50 of 44,727 rows — these rows as CSV

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