PREVIEW / stock_1hour / 2010-12-09

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-12-09.parquet
  size:    933 KB
  rows:    44,227
  symbols: 3,519

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
2010-12-09 04:00:00	AAPL	Stock	11.4821	11.4821	11.4493	11.4493	39200.0
2010-12-09 05:00:00	AAPL	Stock	11.4643	11.4643	11.4539	11.4607	63644.0
2010-12-09 06:00:00	AAPL	Stock	11.4679	11.475	11.4486	11.4743	140000.0
2010-12-09 07:00:00	AAPL	Stock	11.4821	11.53	11.4818	11.5107	428652.0
2010-12-09 08:00:00	AAPL	Stock	11.5054	11.5293	11.4964	11.5268	4164944.0
2010-12-09 09:00:00	AAPL	Stock	11.5268	11.5321	11.4364	11.465	55703032.0
2010-12-09 10:00:00	AAPL	Stock	11.465	11.4732	11.4132	11.4236	59391892.0
2010-12-09 11:00:00	AAPL	Stock	11.4239	11.4514	11.4054	11.4257	32399724.0
2010-12-09 12:00:00	AAPL	Stock	11.4261	11.4425	11.4093	11.4379	20310752.0
2010-12-09 13:00:00	AAPL	Stock	11.4371	11.4514	11.4289	11.4368	23089108.0
2010-12-09 14:00:00	AAPL	Stock	11.4368	11.4393	11.3936	11.4168	36747788.0
2010-12-09 15:00:00	AAPL	Stock	11.4168	11.4461	11.4032	11.4246	50082704.0
2010-12-09 16:00:00	AAPL	Stock	11.4268	11.4961	11.4054	11.4107	6951168.0
2010-12-09 17:00:00	AAPL	Stock	11.4107	11.4646	11.4071	11.4071	230776.0
2010-12-09 18:00:00	AAPL	Stock	11.4175	11.4257	11.4107	11.4257	248332.0
2010-12-09 19:00:00	AAPL	Stock	11.425	11.4282	11.4161	11.4161	275268.0
2010-12-09 04:00:00	MSFT	Stock	27.3	27.3	27.3	27.3	100.0
2010-12-09 05:00:00	MSFT	Stock	27.32	27.32	27.32	27.32	6000.0
2010-12-09 06:00:00	MSFT	Stock	27.32	27.34	27.32	27.32	4900.0
2010-12-09 07:00:00	MSFT	Stock	27.32	27.39	27.27	27.39	19040.0
2010-12-09 08:00:00	MSFT	Stock	27.37	27.4	27.23	27.4	73215.0
2010-12-09 09:00:00	MSFT	Stock	27.41	27.41	27.1	27.29	7349695.0
2010-12-09 10:00:00	MSFT	Stock	27.3	27.3	27.01	27.08	9391380.0
2010-12-09 11:00:00	MSFT	Stock	27.075	27.13	27.03	27.13	5303605.0
2010-12-09 12:00:00	MSFT	Stock	27.12	27.2	27.09	27.12	4120314.0
2010-12-09 13:00:00	MSFT	Stock	27.13	27.19	27.1	27.16	3292681.0
2010-12-09 14:00:00	MSFT	Stock	27.17	27.18	27.05	27.06	3360676.0
2010-12-09 15:00:00	MSFT	Stock	27.065	27.11	27.01	27.09	10830745.0
2010-12-09 16:00:00	MSFT	Stock	27.09	27.27	27.06	27.07	1730350.0
2010-12-09 17:00:00	MSFT	Stock	27.2	27.2	27.08	27.11	10614.0
2010-12-09 18:00:00	MSFT	Stock	27.1	27.12	27.08	27.09	30745.0
2010-12-09 19:00:00	MSFT	Stock	27.09	27.14	27.09	27.13	7300.0
2010-12-09 07:00:00	NVDA	Stock	0.375	0.375	0.3562	0.3562	220000.0
2010-12-09 08:00:00	NVDA	Stock	0.3612	0.3723	0.3612	0.365	6637480.0
2010-12-09 09:00:00	NVDA	Stock	0.3662	0.374	0.3635	0.3692	269949480.0
2010-12-09 10:00:00	NVDA	Stock	0.369	0.3735	0.3668	0.3686	201975120.0
2010-12-09 11:00:00	NVDA	Stock	0.3685	0.3718	0.368	0.3714	81450720.0
2010-12-09 12:00:00	NVDA	Stock	0.3713	0.3718	0.3685	0.3688	97719560.0
2010-12-09 13:00:00	NVDA	Stock	0.3687	0.3703	0.3678	0.3693	50833080.0
2010-12-09 14:00:00	NVDA	Stock	0.3695	0.37	0.3685	0.3697	41610520.0
2010-12-09 15:00:00	NVDA	Stock	0.3695	0.3718	0.3695	0.3715	158810560.0
2010-12-09 16:00:00	NVDA	Stock	0.3718	0.3718	0.3678	0.37	18632320.0
2010-12-09 17:00:00	NVDA	Stock	0.3778	0.3778	0.3703	0.3725	255720.0
2010-12-09 18:00:00	NVDA	Stock	0.3705	0.3725	0.3705	0.3705	36320.0
2010-12-09 19:00:00	NVDA	Stock	0.3705	0.3705	0.3703	0.3705	40000.0
2010-12-09 07:00:00	AMZN	Stock	8.83	8.8805	8.83	8.8805	13400.0
2010-12-09 08:00:00	AMZN	Stock	8.8695	8.89	8.83	8.89	325400.0
2010-12-09 09:00:00	AMZN	Stock	8.889	8.91	8.8	8.837	9067660.0
2010-12-09 10:00:00	AMZN	Stock	8.8325	8.84	8.7015	8.729	27042120.0
2010-12-09 11:00:00	AMZN	Stock	8.73	8.7635	8.7025	8.7215	12345560.0

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

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