PREVIEW / stock_1hour / 2007-11-13

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-11-13.parquet
  size:    814 KB
  rows:    40,082
  symbols: 3,197

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-11-13 04:00:00	AAPL	Stock	5.5107	5.5107	5.5107	5.5107	14000.0
2007-11-13 05:00:00	AAPL	Stock	5.5143	5.5275	5.5143	5.5179	56000.0
2007-11-13 06:00:00	AAPL	Stock	5.5179	5.6071	5.5179	5.5986	238672.0
2007-11-13 07:00:00	AAPL	Stock	5.5714	5.6518	5.5679	5.6429	3023748.0
2007-11-13 08:00:00	AAPL	Stock	5.6429	5.75	5.6214	5.7454	32125716.0
2007-11-13 09:00:00	AAPL	Stock	5.7468	5.8271	5.7193	5.8129	298731328.0
2007-11-13 10:00:00	AAPL	Stock	5.8129	5.9403	5.7982	5.9354	310036328.0
2007-11-13 11:00:00	AAPL	Stock	5.935	6.0721	5.8714	6.0232	274367744.0
2007-11-13 12:00:00	AAPL	Stock	6.0232	6.0571	5.9214	5.9393	165979324.0
2007-11-13 13:00:00	AAPL	Stock	5.9393	6.0496	5.9332	6.0089	175231112.0
2007-11-13 14:00:00	AAPL	Stock	6.0079	6.0568	5.9643	6.0418	175340676.0
2007-11-13 15:00:00	AAPL	Stock	6.0425	6.1064	6.0411	6.0666	264275144.0
2007-11-13 16:00:00	AAPL	Stock	6.0671	6.0896	5.4914	6.0671	34305712.0
2007-11-13 17:00:00	AAPL	Stock	6.0689	6.07	6.0259	6.0571	5320980.0
2007-11-13 18:00:00	AAPL	Stock	6.0554	6.0889	6.0539	6.0714	1228752.0
2007-11-13 19:00:00	AAPL	Stock	6.0714	6.0893	6.0679	6.0857	1075816.0
2007-11-13 06:00:00	MSFT	Stock	33.4	33.4	33.4	33.4	140.0
2007-11-13 07:00:00	MSFT	Stock	33.63	33.64	33.5	33.63	6800.0
2007-11-13 08:00:00	MSFT	Stock	33.59	33.64	33.27	33.62	49753.0
2007-11-13 09:00:00	MSFT	Stock	33.64	33.7	33.44	33.48	13080748.0
2007-11-13 10:00:00	MSFT	Stock	33.48	33.78	33.47	33.66	16341773.0
2007-11-13 11:00:00	MSFT	Stock	33.65	33.69	33.53	33.59	12265966.0
2007-11-13 12:00:00	MSFT	Stock	33.59	33.63	33.55	33.57	7090577.0
2007-11-13 13:00:00	MSFT	Stock	33.58	33.87	33.54	33.81	11331899.0
2007-11-13 14:00:00	MSFT	Stock	33.81	34.08	33.7	34.06	12486001.0
2007-11-13 15:00:00	MSFT	Stock	34.07	34.67	33.845	34.42	26184544.0
2007-11-13 16:00:00	MSFT	Stock	34.42	34.46	33.145	34.39	5055603.0
2007-11-13 17:00:00	MSFT	Stock	34.46	34.47	34.34	34.42	671365.0
2007-11-13 18:00:00	MSFT	Stock	34.43	34.46	34.2	34.32	38420.0
2007-11-13 19:00:00	MSFT	Stock	34.31	34.34	34.21	34.31	9717.0
2007-11-13 04:00:00	NVDA	Stock	0.7525	0.7525	0.7525	0.7525	4000.0
2007-11-13 07:00:00	NVDA	Stock	0.7525	0.7622	0.7525	0.7622	76000.0
2007-11-13 08:00:00	NVDA	Stock	0.7622	0.7735	0.7622	0.7688	823560.0
2007-11-13 09:00:00	NVDA	Stock	0.7685	0.7942	0.7558	0.78	124299280.0
2007-11-13 10:00:00	NVDA	Stock	0.78	0.7928	0.7753	0.7928	101557760.0
2007-11-13 11:00:00	NVDA	Stock	0.7928	0.7982	0.7925	0.7935	73457240.0
2007-11-13 12:00:00	NVDA	Stock	0.794	0.7995	0.7928	0.7955	65046160.0
2007-11-13 13:00:00	NVDA	Stock	0.7955	0.8095	0.795	0.8058	64124520.0
2007-11-13 14:00:00	NVDA	Stock	0.8058	0.8168	0.8055	0.812	90590320.0
2007-11-13 15:00:00	NVDA	Stock	0.812	0.8178	0.8102	0.817	131667080.0
2007-11-13 16:00:00	NVDA	Stock	0.8162	0.82	0.7508	0.8065	56953840.0
2007-11-13 17:00:00	NVDA	Stock	0.817	0.817	0.8125	0.8162	3382120.0
2007-11-13 18:00:00	NVDA	Stock	0.8155	0.8155	0.8155	0.8155	38000.0
2007-11-13 19:00:00	NVDA	Stock	0.8188	0.8198	0.8125	0.8125	80000.0
2007-11-13 07:00:00	AMZN	Stock	3.9	3.9495	3.8995	3.904	15500.0
2007-11-13 08:00:00	AMZN	Stock	3.904	3.9375	3.9035	3.9375	295200.0
2007-11-13 09:00:00	AMZN	Stock	3.94	3.979	3.8885	3.974	25097460.0
2007-11-13 10:00:00	AMZN	Stock	3.9735	3.9755	3.905	3.942	37777040.0
2007-11-13 11:00:00	AMZN	Stock	3.94	3.9995	3.9275	3.9875	35584420.0
2007-11-13 12:00:00	AMZN	Stock	3.986	3.9915	3.9475	3.9625	17296980.0

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

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