PREVIEW / stock_1hour / 2008-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-03-19.parquet
  size:    818 KB
  rows:    40,569
  symbols: 3,281

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-03-19 04:00:00	AAPL	Stock	4.7389	4.7389	4.7389	4.7389	2800.0
2008-03-19 05:00:00	AAPL	Stock	4.6875	4.6875	4.6875	4.6875	2800.0
2008-03-19 06:00:00	AAPL	Stock	4.6875	4.7089	4.6782	4.6975	47600.0
2008-03-19 07:00:00	AAPL	Stock	4.7018	4.725	4.6932	4.7139	616140.0
2008-03-19 08:00:00	AAPL	Stock	4.7196	4.7404	4.7079	4.7321	2896012.0
2008-03-19 09:00:00	AAPL	Stock	4.7314	4.7961	4.7232	4.725	153056932.0
2008-03-19 10:00:00	AAPL	Stock	4.7246	4.7586	4.6772	4.7068	184721124.0
2008-03-19 11:00:00	AAPL	Stock	4.7071	4.735	4.6821	4.7	116673816.0
2008-03-19 12:00:00	AAPL	Stock	4.7002	4.725	4.6821	4.6961	96781580.0
2008-03-19 13:00:00	AAPL	Stock	4.6971	4.7161	4.6646	4.6754	107013760.0
2008-03-19 14:00:00	AAPL	Stock	4.6739	4.7011	4.6439	4.6664	124631584.0
2008-03-19 15:00:00	AAPL	Stock	4.6668	4.7143	4.6311	4.6357	174784176.0
2008-03-19 16:00:00	AAPL	Stock	4.6354	4.7164	4.6274	4.6382	29693300.0
2008-03-19 17:00:00	AAPL	Stock	4.6311	4.6375	4.6286	4.6321	333956.0
2008-03-19 18:00:00	AAPL	Stock	4.6321	4.635	4.6286	4.6286	82432.0
2008-03-19 19:00:00	AAPL	Stock	4.6318	4.635	4.6182	4.6225	312088.0
2008-03-19 08:00:00	MSFT	Stock	29.3	29.42	29.2	29.3	12931.0
2008-03-19 09:00:00	MSFT	Stock	29.34	29.62	29.2	29.37	6550806.0
2008-03-19 10:00:00	MSFT	Stock	29.38	29.43	29.11	29.2	8655811.0
2008-03-19 11:00:00	MSFT	Stock	29.2	29.59	29.17	29.45	8778631.0
2008-03-19 12:00:00	MSFT	Stock	29.45	29.49	29.16	29.21	5713991.0
2008-03-19 13:00:00	MSFT	Stock	29.22	29.31	29.092	29.12	6607420.0
2008-03-19 14:00:00	MSFT	Stock	29.12	29.19	28.93	29.13	7779033.0
2008-03-19 15:00:00	MSFT	Stock	29.14	29.21	28.62	28.62	12724045.0
2008-03-19 16:00:00	MSFT	Stock	28.62	29.41	28.597	28.597	2609388.0
2008-03-19 17:00:00	MSFT	Stock	28.62	29.179	28.62	28.73	9399.0
2008-03-19 18:00:00	MSFT	Stock	28.67	28.75	28.62	28.75	6420.0
2008-03-19 19:00:00	MSFT	Stock	28.75	28.75	28.62	28.62	3225.0
2008-03-19 07:00:00	NVDA	Stock	0.4723	0.4723	0.4723	0.4723	4000.0
2008-03-19 08:00:00	NVDA	Stock	0.475	0.475	0.4668	0.4713	329600.0
2008-03-19 09:00:00	NVDA	Stock	0.4713	0.4738	0.458	0.4635	107030880.0
2008-03-19 10:00:00	NVDA	Stock	0.4635	0.4668	0.4475	0.4555	158276640.0
2008-03-19 11:00:00	NVDA	Stock	0.4555	0.4593	0.453	0.4532	88529240.0
2008-03-19 12:00:00	NVDA	Stock	0.4532	0.4542	0.448	0.4488	74686760.0
2008-03-19 13:00:00	NVDA	Stock	0.4488	0.4512	0.4455	0.4485	79259800.0
2008-03-19 14:00:00	NVDA	Stock	0.4488	0.465	0.445	0.4492	130144280.0
2008-03-19 15:00:00	NVDA	Stock	0.4492	0.4502	0.4415	0.4415	187958280.0
2008-03-19 16:00:00	NVDA	Stock	0.442	0.4525	0.4415	0.4486	46586080.0
2008-03-19 17:00:00	NVDA	Stock	0.4428	0.4428	0.4415	0.4428	103480.0
2008-03-19 19:00:00	NVDA	Stock	0.445	0.445	0.4428	0.4428	64000.0
2008-03-19 08:00:00	AMZN	Stock	3.55	3.565	3.55	3.554	72540.0
2008-03-19 09:00:00	AMZN	Stock	3.555	3.6792	3.551	3.617	33623620.0
2008-03-19 10:00:00	AMZN	Stock	3.616	3.64	3.599	3.6225	36853660.0
2008-03-19 11:00:00	AMZN	Stock	3.622	3.7	3.6145	3.683	27071460.0
2008-03-19 12:00:00	AMZN	Stock	3.682	3.6895	3.6305	3.639	21364900.0
2008-03-19 13:00:00	AMZN	Stock	3.6385	3.6595	3.603	3.605	20596840.0
2008-03-19 14:00:00	AMZN	Stock	3.6055	3.62	3.575	3.616	25465680.0
2008-03-19 15:00:00	AMZN	Stock	3.6155	3.644	3.509	3.509	44875500.0
2008-03-19 16:00:00	AMZN	Stock	3.5085	3.6745	3.5085	3.516	4042260.0
2008-03-19 17:00:00	AMZN	Stock	3.5175	3.6151	3.5085	3.5125	1704080.0

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

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