PREVIEW / stock_1hour / 2007-12-18

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-12-18.parquet
  size:    819 KB
  rows:    40,657
  symbols: 3,255

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
2007-12-18 04:00:00	AAPL	Stock	6.6321	6.6321	6.6321	6.6321	2800.0
2007-12-18 05:00:00	AAPL	Stock	6.6736	6.6786	6.6736	6.6786	16800.0
2007-12-18 06:00:00	AAPL	Stock	6.6786	6.6804	6.6621	6.6732	128660.0
2007-12-18 07:00:00	AAPL	Stock	6.6964	6.6964	6.6454	6.6607	507584.0
2007-12-18 08:00:00	AAPL	Stock	6.6643	6.8114	6.6571	6.6689	6957916.0
2007-12-18 09:00:00	AAPL	Stock	6.6661	6.6904	6.5786	6.6182	129859436.0
2007-12-18 10:00:00	AAPL	Stock	6.6182	6.6275	6.4679	6.5389	212559480.0
2007-12-18 11:00:00	AAPL	Stock	6.5393	6.5686	6.4118	6.4254	151128404.0
2007-12-18 12:00:00	AAPL	Stock	6.4268	6.4786	6.3786	6.4736	164731756.0
2007-12-18 13:00:00	AAPL	Stock	6.4732	6.6046	6.4575	6.5818	181673352.0
2007-12-18 14:00:00	AAPL	Stock	6.5814	6.6307	6.5443	6.58	175139524.0
2007-12-18 15:00:00	AAPL	Stock	6.5796	6.6014	6.5096	6.5347	184243724.0
2007-12-18 16:00:00	AAPL	Stock	6.5343	6.5857	6.4732	6.535	13902196.0
2007-12-18 17:00:00	AAPL	Stock	6.5486	6.6293	6.535	6.5464	1114008.0
2007-12-18 18:00:00	AAPL	Stock	6.5482	6.5536	6.5464	6.5504	416080.0
2007-12-18 19:00:00	AAPL	Stock	6.5536	6.5575	6.5457	6.5536	275800.0
2007-12-18 07:00:00	MSFT	Stock	34.64	34.64	34.64	34.64	800.0
2007-12-18 08:00:00	MSFT	Stock	34.7	34.78	34.63	34.71	15850.0
2007-12-18 09:00:00	MSFT	Stock	34.71	34.72	34.45	34.56	6017661.0
2007-12-18 10:00:00	MSFT	Stock	34.55	34.69	34.47	34.58	7730970.0
2007-12-18 11:00:00	MSFT	Stock	34.58	34.64	34.3	34.34	7484899.0
2007-12-18 12:00:00	MSFT	Stock	34.332	34.4	34.21	34.34	4868488.0
2007-12-18 13:00:00	MSFT	Stock	34.34	34.658	34.3	34.658	4995387.0
2007-12-18 14:00:00	MSFT	Stock	34.65	35.0	34.6	34.76	8931690.0
2007-12-18 15:00:00	MSFT	Stock	34.76	34.92	34.68	34.78	9030064.0
2007-12-18 16:00:00	MSFT	Stock	34.774	35.031	34.39	34.74	2904385.0
2007-12-18 17:00:00	MSFT	Stock	34.74	35.02	34.74	35.02	3563.0
2007-12-18 18:00:00	MSFT	Stock	34.74	34.84	34.74	34.84	800276.0
2007-12-18 19:00:00	MSFT	Stock	34.75	34.84	34.75	34.84	10124.0
2007-12-18 08:00:00	NVDA	Stock	0.832	0.8475	0.832	0.845	240000.0
2007-12-18 09:00:00	NVDA	Stock	0.845	0.856	0.8382	0.852	37219800.0
2007-12-18 10:00:00	NVDA	Stock	0.852	0.8562	0.8445	0.8548	71095840.0
2007-12-18 11:00:00	NVDA	Stock	0.8548	0.8555	0.8402	0.8405	50470640.0
2007-12-18 12:00:00	NVDA	Stock	0.8408	0.85	0.8363	0.8472	52041800.0
2007-12-18 13:00:00	NVDA	Stock	0.8475	0.86	0.8472	0.8552	55598000.0
2007-12-18 14:00:00	NVDA	Stock	0.855	0.8625	0.8528	0.8545	51451120.0
2007-12-18 15:00:00	NVDA	Stock	0.8545	0.8582	0.8492	0.8532	63365240.0
2007-12-18 16:00:00	NVDA	Stock	0.8532	0.8532	0.832	0.8517	15363720.0
2007-12-18 17:00:00	NVDA	Stock	0.8532	0.8532	0.8532	0.8532	19680.0
2007-12-18 18:00:00	NVDA	Stock	0.85	0.85	0.85	0.85	8000.0
2007-12-18 07:00:00	AMZN	Stock	4.337	4.337	4.337	4.337	10000.0
2007-12-18 08:00:00	AMZN	Stock	4.2785	4.3135	4.2515	4.29	373600.0
2007-12-18 09:00:00	AMZN	Stock	4.2875	4.3235	4.2375	4.2825	23750160.0
2007-12-18 10:00:00	AMZN	Stock	4.284	4.299	4.2338	4.2785	22779640.0
2007-12-18 11:00:00	AMZN	Stock	4.2785	4.2965	4.2055	4.2135	14354040.0
2007-12-18 12:00:00	AMZN	Stock	4.2135	4.238	4.193	4.227	13329680.0
2007-12-18 13:00:00	AMZN	Stock	4.227	4.344	4.2135	4.337	22254100.0
2007-12-18 14:00:00	AMZN	Stock	4.337	4.3705	4.3145	4.3235	20449920.0
2007-12-18 15:00:00	AMZN	Stock	4.323	4.373	4.316	4.3495	22944220.0
2007-12-18 16:00:00	AMZN	Stock	4.3445	4.3565	4.2545	4.2953	2733480.0

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

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