PREVIEW / stock_1hour / 2010-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-04-23.parquet
  size:    927 KB
  rows:    43,732
  symbols: 3,494

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-04-23 04:00:00	AAPL	Stock	9.5264	9.5714	9.5121	9.5221	185640.0
2010-04-23 05:00:00	AAPL	Stock	9.5464	9.5589	9.5429	9.5589	70952.0
2010-04-23 06:00:00	AAPL	Stock	9.5607	9.5607	9.5457	9.55	62272.0
2010-04-23 07:00:00	AAPL	Stock	9.5625	9.5625	9.5357	9.5586	370160.0
2010-04-23 08:00:00	AAPL	Stock	9.55	9.6036	9.55	9.6	6344156.0
2010-04-23 09:00:00	AAPL	Stock	9.5982	9.7207	9.5357	9.6991	218293712.0
2010-04-23 10:00:00	AAPL	Stock	9.6993	9.7129	9.6329	9.6514	170679432.0
2010-04-23 11:00:00	AAPL	Stock	9.6514	9.6714	9.6071	9.6207	103729164.0
2010-04-23 12:00:00	AAPL	Stock	9.6207	9.6707	9.6036	9.6671	61222336.0
2010-04-23 13:00:00	AAPL	Stock	9.6668	9.6675	9.6254	9.6449	43219204.0
2010-04-23 14:00:00	AAPL	Stock	9.6439	9.7025	9.6314	9.6992	71553272.0
2010-04-23 15:00:00	AAPL	Stock	9.6989	9.7029	9.6518	9.6732	89073852.0
2010-04-23 16:00:00	AAPL	Stock	9.6714	9.6754	9.5129	9.6714	17170356.0
2010-04-23 17:00:00	AAPL	Stock	9.5126	9.6839	9.5126	9.6786	550676.0
2010-04-23 18:00:00	AAPL	Stock	9.6757	9.6786	9.6696	9.6746	731444.0
2010-04-23 19:00:00	AAPL	Stock	9.6732	9.6775	9.6732	9.6775	356860.0
2010-04-23 04:00:00	MSFT	Stock	30.48	30.48	30.37	30.46	1150.0
2010-04-23 05:00:00	MSFT	Stock	30.46	30.49	30.46	30.49	2350.0
2010-04-23 06:00:00	MSFT	Stock	30.51	30.55	30.39	30.55	12279.0
2010-04-23 07:00:00	MSFT	Stock	30.56	31.05	30.56	30.85	1070732.0
2010-04-23 08:00:00	MSFT	Stock	31.0	31.29	30.7	30.95	3682902.0
2010-04-23 09:00:00	MSFT	Stock	30.99	31.58	30.95	31.0	29638367.0
2010-04-23 10:00:00	MSFT	Stock	31.01	31.22	30.79	30.829	25650092.0
2010-04-23 11:00:00	MSFT	Stock	30.82	30.94	30.7	30.902	12748991.0
2010-04-23 12:00:00	MSFT	Stock	30.9	31.0	30.82	30.895	9495691.0
2010-04-23 13:00:00	MSFT	Stock	30.9	30.91	30.65	30.832	11265066.0
2010-04-23 14:00:00	MSFT	Stock	30.84	30.95	30.75	30.81	9763695.0
2010-04-23 15:00:00	MSFT	Stock	30.81	31.0	30.72	31.0	17570262.0
2010-04-23 16:00:00	MSFT	Stock	30.99	31.39	30.805	30.91	4365209.0
2010-04-23 17:00:00	MSFT	Stock	31.383	31.383	30.91	30.91	12047.0
2010-04-23 18:00:00	MSFT	Stock	30.93	30.93	30.86	30.86	9511.0
2010-04-23 19:00:00	MSFT	Stock	30.86	30.89	30.85	30.89	25160.0
2010-04-23 08:00:00	NVDA	Stock	0.4162	0.4168	0.4162	0.4168	48000.0
2010-04-23 09:00:00	NVDA	Stock	0.4162	0.4165	0.4115	0.414	57307120.0
2010-04-23 10:00:00	NVDA	Stock	0.4138	0.415	0.4065	0.408	158120320.0
2010-04-23 11:00:00	NVDA	Stock	0.4078	0.409	0.4065	0.4068	114812760.0
2010-04-23 12:00:00	NVDA	Stock	0.4065	0.4093	0.4038	0.409	99186520.0
2010-04-23 13:00:00	NVDA	Stock	0.4088	0.4102	0.408	0.4088	87960520.0
2010-04-23 14:00:00	NVDA	Stock	0.4088	0.41	0.4072	0.4098	77216040.0
2010-04-23 15:00:00	NVDA	Stock	0.4098	0.4112	0.4083	0.4108	127088760.0
2010-04-23 16:00:00	NVDA	Stock	0.41	0.4168	0.409	0.4108	8650480.0
2010-04-23 17:00:00	NVDA	Stock	0.4169	0.4169	0.4108	0.4108	112920.0
2010-04-23 19:00:00	NVDA	Stock	0.4102	0.4102	0.4102	0.4102	8000.0
2010-04-23 04:00:00	AMZN	Stock	7.1385	7.1385	7.1385	7.1385	10000.0
2010-04-23 07:00:00	AMZN	Stock	7.1855	7.1855	7.0935	7.14	731080.0
2010-04-23 08:00:00	AMZN	Stock	7.1325	7.247	7.1025	7.183	7900920.0
2010-04-23 09:00:00	AMZN	Stock	7.182	7.4545	7.177	7.3452	107184380.0
2010-04-23 10:00:00	AMZN	Stock	7.346	7.3935	7.2275	7.2345	75184280.0
2010-04-23 11:00:00	AMZN	Stock	7.2345	7.314	7.1365	7.2125	58422520.0
2010-04-23 12:00:00	AMZN	Stock	7.21	7.24	7.16	7.2055	28396200.0

> showing 50 of 43,732 rows — these rows as CSV

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