PREVIEW / stock_1hour / 2008-06-04

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-06-04.parquet
  size:    851 KB
  rows:    40,784
  symbols: 3,308

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-06-04 06:00:00	AAPL	Stock	6.6179	6.6179	6.6179	6.6179	2800.0
2008-06-04 07:00:00	AAPL	Stock	6.5929	6.5943	6.5786	6.5929	109900.0
2008-06-04 08:00:00	AAPL	Stock	6.5929	6.6132	6.5729	6.5804	2642248.0
2008-06-04 09:00:00	AAPL	Stock	6.5804	6.6107	6.5561	6.5621	95049668.0
2008-06-04 10:00:00	AAPL	Stock	6.5625	6.6721	6.5439	6.665	152554360.0
2008-06-04 11:00:00	AAPL	Stock	6.6643	6.6818	6.6371	6.6372	79050300.0
2008-06-04 12:00:00	AAPL	Stock	6.6375	6.6768	6.6296	6.6411	78543808.0
2008-06-04 13:00:00	AAPL	Stock	6.6418	6.6539	6.6157	6.6468	72669436.0
2008-06-04 14:00:00	AAPL	Stock	6.6475	6.65	6.5511	6.5671	120150520.0
2008-06-04 15:00:00	AAPL	Stock	6.5668	6.6179	6.5629	6.6121	116528188.0
2008-06-04 16:00:00	AAPL	Stock	6.6139	6.6229	6.5902	6.6168	6848632.0
2008-06-04 17:00:00	AAPL	Stock	6.6168	6.6243	6.615	6.6182	300244.0
2008-06-04 18:00:00	AAPL	Stock	6.6229	6.6229	6.6125	6.6157	249760.0
2008-06-04 19:00:00	AAPL	Stock	6.6157	6.6196	6.6157	6.6196	198408.0
2008-06-04 20:00:00	AAPL	Stock	6.6354	6.6354	6.6354	6.6354	30800.0
2008-06-04 08:00:00	MSFT	Stock	27.3	27.35	27.25	27.33	779753.0
2008-06-04 09:00:00	MSFT	Stock	27.33	27.52	27.22	27.271	9562501.0
2008-06-04 10:00:00	MSFT	Stock	27.28	27.53	27.2	27.47	15684367.0
2008-06-04 11:00:00	MSFT	Stock	27.47	27.64	27.46	27.56	9303716.0
2008-06-04 12:00:00	MSFT	Stock	27.56	27.56	27.32	27.34	9640268.0
2008-06-04 13:00:00	MSFT	Stock	27.35	27.46	27.26	27.43	7972275.0
2008-06-04 14:00:00	MSFT	Stock	27.43	27.55	27.28	27.37	12297827.0
2008-06-04 15:00:00	MSFT	Stock	27.36	27.59	27.3	27.54	12118089.0
2008-06-04 16:00:00	MSFT	Stock	27.53	27.562	27.31	27.54	1264274.0
2008-06-04 17:00:00	MSFT	Stock	27.52	27.64	27.52	27.63	65926.0
2008-06-04 18:00:00	MSFT	Stock	27.62	27.62	27.56	27.6	15740.0
2008-06-04 19:00:00	MSFT	Stock	27.61	27.62	27.58	27.62	4542.0
2008-06-04 20:00:00	MSFT	Stock	27.5	27.5	27.5	27.5	10800.0
2008-06-04 08:00:00	NVDA	Stock	0.5963	0.5963	0.5925	0.595	530000.0
2008-06-04 09:00:00	NVDA	Stock	0.593	0.593	0.5825	0.589	110380560.0
2008-06-04 10:00:00	NVDA	Stock	0.589	0.6053	0.5888	0.6038	149175200.0
2008-06-04 11:00:00	NVDA	Stock	0.6038	0.6048	0.5998	0.603	88960560.0
2008-06-04 12:00:00	NVDA	Stock	0.603	0.6073	0.5992	0.5998	80029720.0
2008-06-04 13:00:00	NVDA	Stock	0.5995	0.6053	0.5975	0.6048	86632720.0
2008-06-04 14:00:00	NVDA	Stock	0.6048	0.6068	0.5998	0.6005	132478120.0
2008-06-04 15:00:00	NVDA	Stock	0.6003	0.6065	0.6	0.6055	169198240.0
2008-06-04 16:00:00	NVDA	Stock	0.6058	0.6063	0.5994	0.606	13069160.0
2008-06-04 17:00:00	NVDA	Stock	0.6073	0.6088	0.6073	0.6088	16000.0
2008-06-04 18:00:00	NVDA	Stock	0.606	0.6085	0.606	0.6075	188000.0
2008-06-04 19:00:00	NVDA	Stock	0.6075	0.608	0.6043	0.6043	110400.0
2008-06-04 20:00:00	NVDA	Stock	0.6013	0.6013	0.6013	0.6013	908000.0
2008-06-04 08:00:00	AMZN	Stock	4.005	4.005	3.9925	3.9925	15220.0
2008-06-04 09:00:00	AMZN	Stock	3.975	4.071	3.975	4.036	18325700.0
2008-06-04 10:00:00	AMZN	Stock	4.0375	4.085	4.0105	4.0715	24545360.0
2008-06-04 11:00:00	AMZN	Stock	4.071	4.091	4.0555	4.0565	16223920.0
2008-06-04 12:00:00	AMZN	Stock	4.056	4.062	4.0375	4.04	15367500.0
2008-06-04 13:00:00	AMZN	Stock	4.041	4.071	4.032	4.07	8357820.0
2008-06-04 14:00:00	AMZN	Stock	4.07	4.073	4.0235	4.0435	17126580.0
2008-06-04 15:00:00	AMZN	Stock	4.0435	4.079	4.04	4.075	24911400.0
2008-06-04 16:00:00	AMZN	Stock	4.074	4.088	4.0565	4.075	947000.0

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

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