PREVIEW / stock_1hour / 2007-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-05-07.parquet
  size:    716 KB
  rows:    34,323
  symbols: 2,723

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-05-07 09:00:00	AAPL	Stock	3.61	3.6429	3.6075	3.625	61812492.0
2007-05-07 10:00:00	AAPL	Stock	3.6254	3.6743	3.6168	3.6679	182079912.0
2007-05-07 11:00:00	AAPL	Stock	3.6682	3.6868	3.6636	3.6811	116282124.0
2007-05-07 12:00:00	AAPL	Stock	3.6814	3.6871	3.6646	3.6761	77724836.0
2007-05-07 13:00:00	AAPL	Stock	3.6761	3.6864	3.6629	3.6804	49145740.0
2007-05-07 14:00:00	AAPL	Stock	3.6805	3.7268	3.679	3.7211	161679336.0
2007-05-07 15:00:00	AAPL	Stock	3.7207	3.7214	3.6979	3.7111	179571560.0
2007-05-07 16:00:00	AAPL	Stock	3.7107	3.7114	3.7107	3.7114	4947012.0
2007-05-07 09:00:00	MSFT	Stock	30.52	30.71	30.48	30.6	8242933.0
2007-05-07 10:00:00	MSFT	Stock	30.6	30.69	30.58	30.62	6040988.0
2007-05-07 11:00:00	MSFT	Stock	30.62	30.65	30.58	30.62	6210416.0
2007-05-07 12:00:00	MSFT	Stock	30.62	30.63	30.57	30.58	4070685.0
2007-05-07 13:00:00	MSFT	Stock	30.59	30.69	30.58	30.67	6461873.0
2007-05-07 14:00:00	MSFT	Stock	30.67	30.74	30.66	30.73	7045330.0
2007-05-07 15:00:00	MSFT	Stock	30.74	30.76	30.66	30.69	13691087.0
2007-05-07 16:00:00	MSFT	Stock	30.71	30.71	30.71	30.71	1120416.0
2007-05-07 07:00:00	NVDA	Stock	0.5667	0.57	0.5667	0.57	498000.0
2007-05-07 08:00:00	NVDA	Stock	0.5635	0.57	0.5635	0.5667	639780.0
2007-05-07 09:00:00	NVDA	Stock	0.5678	0.5763	0.5668	0.5683	76306140.0
2007-05-07 10:00:00	NVDA	Stock	0.5682	0.5685	0.5583	0.5608	89844840.0
2007-05-07 11:00:00	NVDA	Stock	0.5607	0.5608	0.5557	0.5585	59147520.0
2007-05-07 12:00:00	NVDA	Stock	0.5587	0.5593	0.5575	0.5582	51896460.0
2007-05-07 13:00:00	NVDA	Stock	0.5582	0.5587	0.5553	0.5577	43759380.0
2007-05-07 14:00:00	NVDA	Stock	0.5577	0.5587	0.5537	0.5547	56074920.0
2007-05-07 15:00:00	NVDA	Stock	0.5547	0.5547	0.55	0.5507	122274540.0
2007-05-07 16:00:00	NVDA	Stock	0.5507	0.575	0.55	0.5575	21846960.0
2007-05-07 18:00:00	NVDA	Stock	0.552	0.5522	0.552	0.5522	156000.0
2007-05-07 19:00:00	NVDA	Stock	0.5517	0.5517	0.5517	0.5517	6000.0
2007-05-07 05:00:00	AMZN	Stock	3.1555	3.1555	3.1555	3.1555	4000.0
2007-05-07 07:00:00	AMZN	Stock	3.153	3.153	3.135	3.135	34400.0
2007-05-07 08:00:00	AMZN	Stock	3.1425	3.15	3.131	3.133	1033320.0
2007-05-07 09:00:00	AMZN	Stock	3.133	3.15	3.12	3.1366	25658340.0
2007-05-07 10:00:00	AMZN	Stock	3.137	3.138	3.106	3.112	43262020.0
2007-05-07 11:00:00	AMZN	Stock	3.112	3.1245	3.1085	3.1085	22750680.0
2007-05-07 12:00:00	AMZN	Stock	3.1093	3.1135	3.0825	3.09	36090360.0
2007-05-07 13:00:00	AMZN	Stock	3.09	3.0935	3.071	3.088	29870200.0
2007-05-07 14:00:00	AMZN	Stock	3.0895	3.09	3.05	3.0645	47972620.0
2007-05-07 15:00:00	AMZN	Stock	3.064	3.064	3.0355	3.038	76369880.0
2007-05-07 16:00:00	AMZN	Stock	3.038	3.121	3.038	3.0475	4992340.0
2007-05-07 17:00:00	AMZN	Stock	3.045	3.045	3.0415	3.045	26500.0
2007-05-07 18:00:00	AMZN	Stock	3.0445	3.045	3.0415	3.0425	18000.0
2007-05-07 19:00:00	AMZN	Stock	3.041	3.05	3.0405	3.041	80740.0
2007-05-07 15:00:00	TLT	Stock	88.82	88.84	88.81	88.84	12500.0
2007-05-07 16:00:00	TLT	Stock	88.85	88.85	88.84	88.84	5500.0
2007-05-07 09:00:00	CL	Stock	34.075	34.09	33.87	34.005	782800.0
2007-05-07 10:00:00	CL	Stock	34.005	34.1	33.84	33.845	974400.0
2007-05-07 11:00:00	CL	Stock	33.84	33.985	33.75	33.755	678600.0
2007-05-07 12:00:00	CL	Stock	33.755	33.76	33.68	33.695	800200.0
2007-05-07 13:00:00	CL	Stock	33.69	33.725	33.685	33.715	405400.0
2007-05-07 14:00:00	CL	Stock	33.715	33.765	33.695	33.75	667400.0

> showing 50 of 34,323 rows — these rows as CSV

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