PREVIEW / stock_1hour / 2010-01-20

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-01-20.parquet
  size:    902 KB
  rows:    42,801
  symbols: 3,424

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-01-20 04:00:00	AAPL	Stock	7.6786	7.6786	7.6714	7.6714	14000.0
2010-01-20 05:00:00	AAPL	Stock	7.665	7.6839	7.665	7.6839	16800.0
2010-01-20 06:00:00	AAPL	Stock	7.6836	7.6836	7.67	7.6782	105364.0
2010-01-20 07:00:00	AAPL	Stock	7.6714	7.6786	7.6521	7.6786	440748.0
2010-01-20 08:00:00	AAPL	Stock	7.6732	7.6839	7.6396	7.6518	2739548.0
2010-01-20 09:00:00	AAPL	Stock	7.6486	7.6982	7.5768	7.5932	104272672.0
2010-01-20 10:00:00	AAPL	Stock	7.5932	7.6029	7.5011	7.5132	153279364.0
2010-01-20 11:00:00	AAPL	Stock	7.5143	7.5407	7.4821	7.5164	95021948.0
2010-01-20 12:00:00	AAPL	Stock	7.5161	7.5564	7.5125	7.5232	56119980.0
2010-01-20 13:00:00	AAPL	Stock	7.5236	7.5471	7.5054	7.5388	48947304.0
2010-01-20 14:00:00	AAPL	Stock	7.5393	7.5518	7.5232	7.5382	52003588.0
2010-01-20 15:00:00	AAPL	Stock	7.5382	7.5704	7.5232	7.5654	84555800.0
2010-01-20 16:00:00	AAPL	Stock	7.5693	7.6741	7.5236	7.5657	6918520.0
2010-01-20 17:00:00	AAPL	Stock	7.5686	7.5911	7.5686	7.5807	1255912.0
2010-01-20 18:00:00	AAPL	Stock	7.5821	7.5889	7.5614	7.5768	630280.0
2010-01-20 19:00:00	AAPL	Stock	7.5818	7.5871	7.5789	7.5871	223804.0
2010-01-20 05:00:00	MSFT	Stock	30.93	30.93	30.89	30.89	400.0
2010-01-20 06:00:00	MSFT	Stock	30.85	30.85	30.85	30.85	150.0
2010-01-20 07:00:00	MSFT	Stock	30.77	30.88	30.77	30.88	3374.0
2010-01-20 08:00:00	MSFT	Stock	30.95	30.98	30.91	30.92	6777.0
2010-01-20 09:00:00	MSFT	Stock	30.93	30.94	30.53	30.64	7587939.0
2010-01-20 10:00:00	MSFT	Stock	30.64	30.7	30.35	30.44	11781974.0
2010-01-20 11:00:00	MSFT	Stock	30.432	30.5	30.31	30.42	7723479.0
2010-01-20 12:00:00	MSFT	Stock	30.43	30.49	30.36	30.39	4319405.0
2010-01-20 13:00:00	MSFT	Stock	30.39	30.52	30.36	30.48	4908162.0
2010-01-20 14:00:00	MSFT	Stock	30.48	30.54	30.42	30.5	3807816.0
2010-01-20 15:00:00	MSFT	Stock	30.492	30.62	30.47	30.58	7929147.0
2010-01-20 16:00:00	MSFT	Stock	30.57	30.62	30.39	30.58	4395957.0
2010-01-20 17:00:00	MSFT	Stock	30.61	30.68	30.61	30.64	27009.0
2010-01-20 18:00:00	MSFT	Stock	30.65	30.65	30.6	30.6	4125.0
2010-01-20 19:00:00	MSFT	Stock	30.61	30.65	30.61	30.65	6200.0
2010-01-20 08:00:00	NVDA	Stock	0.4305	0.4305	0.4302	0.4302	41400.0
2010-01-20 09:00:00	NVDA	Stock	0.4302	0.4358	0.4245	0.4342	91148800.0
2010-01-20 10:00:00	NVDA	Stock	0.4342	0.4355	0.4268	0.4293	162598560.0
2010-01-20 11:00:00	NVDA	Stock	0.4293	0.431	0.4258	0.4285	63933240.0
2010-01-20 12:00:00	NVDA	Stock	0.4285	0.43	0.4258	0.426	59002160.0
2010-01-20 13:00:00	NVDA	Stock	0.426	0.43	0.425	0.429	84284400.0
2010-01-20 14:00:00	NVDA	Stock	0.429	0.4328	0.4285	0.4318	91463320.0
2010-01-20 15:00:00	NVDA	Stock	0.4318	0.4345	0.4312	0.4338	158483240.0
2010-01-20 16:00:00	NVDA	Stock	0.434	0.4342	0.4306	0.434	7208680.0
2010-01-20 17:00:00	NVDA	Stock	0.4345	0.4345	0.4345	0.4345	4000.0
2010-01-20 18:00:00	NVDA	Stock	0.4342	0.4342	0.4342	0.4342	40000.0
2010-01-20 19:00:00	NVDA	Stock	0.4342	0.4355	0.4342	0.4355	12000.0
2010-01-20 08:00:00	AMZN	Stock	6.3595	6.3595	6.3325	6.339	87220.0
2010-01-20 09:00:00	AMZN	Stock	6.334	6.46	6.325	6.4185	34628980.0
2010-01-20 10:00:00	AMZN	Stock	6.417	6.4465	6.303	6.3155	41732160.0
2010-01-20 11:00:00	AMZN	Stock	6.3155	6.342	6.265	6.2687	29436220.0
2010-01-20 12:00:00	AMZN	Stock	6.2685	6.2895	6.263	6.276	12450300.0
2010-01-20 13:00:00	AMZN	Stock	6.277	6.305	6.254	6.287	16027700.0
2010-01-20 14:00:00	AMZN	Stock	6.286	6.3075	6.2585	6.266	16570080.0

> showing 50 of 42,801 rows — these rows as CSV

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