PREVIEW / stock_1hour / 2007-10-03

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-10-03.parquet
  size:    793 KB
  rows:    39,134
  symbols: 3,130

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-10-03 05:00:00	AAPL	Stock	5.6439	5.6439	5.6429	5.6429	28000.0
2007-10-03 06:00:00	AAPL	Stock	5.6214	5.6214	5.6214	5.6214	14000.0
2007-10-03 07:00:00	AAPL	Stock	5.6211	5.65	5.62	5.6339	452088.0
2007-10-03 08:00:00	AAPL	Stock	5.6286	5.6589	5.6214	5.6346	5843628.0
2007-10-03 09:00:00	AAPL	Stock	5.6339	5.6536	5.6086	5.6136	90205080.0
2007-10-03 10:00:00	AAPL	Stock	5.6125	5.6679	5.6125	5.6636	144603032.0
2007-10-03 11:00:00	AAPL	Stock	5.6639	5.685	5.6525	5.6621	99172192.0
2007-10-03 12:00:00	AAPL	Stock	5.6614	5.6732	5.6504	5.6696	51618112.0
2007-10-03 13:00:00	AAPL	Stock	5.6693	5.6821	5.6343	5.6418	87801084.0
2007-10-03 14:00:00	AAPL	Stock	5.6414	5.6443	5.6075	5.6211	108753428.0
2007-10-03 15:00:00	AAPL	Stock	5.6207	5.6479	5.615	5.6411	89071668.0
2007-10-03 16:00:00	AAPL	Stock	5.6411	5.65	5.6282	5.6421	13265448.0
2007-10-03 17:00:00	AAPL	Stock	5.64	5.6471	5.6393	5.6457	793744.0
2007-10-03 18:00:00	AAPL	Stock	5.6446	5.6482	5.6361	5.64	664804.0
2007-10-03 19:00:00	AAPL	Stock	5.64	5.6468	5.6339	5.6468	294728.0
2007-10-03 08:00:00	MSFT	Stock	29.67	29.7	29.63	29.66	409156.0
2007-10-03 09:00:00	MSFT	Stock	29.66	29.71	29.46	29.53	2933078.0
2007-10-03 10:00:00	MSFT	Stock	29.53	29.61	29.53	29.59	4645421.0
2007-10-03 11:00:00	MSFT	Stock	29.59	29.85	29.47	29.489	5651464.0
2007-10-03 12:00:00	MSFT	Stock	29.485	29.49	29.36	29.4	4235556.0
2007-10-03 13:00:00	MSFT	Stock	29.39	29.43	29.32	29.38	3652795.0
2007-10-03 14:00:00	MSFT	Stock	29.38	29.39	29.29	29.39	4467417.0
2007-10-03 15:00:00	MSFT	Stock	29.38	29.47	29.31	29.47	9337640.0
2007-10-03 16:00:00	MSFT	Stock	29.47	29.591	29.379	29.591	2249968.0
2007-10-03 17:00:00	MSFT	Stock	29.47	29.52	29.383	29.52	52021.0
2007-10-03 18:00:00	MSFT	Stock	29.45	29.61	29.44	29.45	27426.0
2007-10-03 19:00:00	MSFT	Stock	29.45	29.45	29.26	29.42	1126.0
2007-10-03 08:00:00	NVDA	Stock	0.9222	0.9222	0.9092	0.9125	703240.0
2007-10-03 09:00:00	NVDA	Stock	0.9125	0.9188	0.905	0.9082	61707960.0
2007-10-03 10:00:00	NVDA	Stock	0.9082	0.9115	0.9045	0.908	67422000.0
2007-10-03 11:00:00	NVDA	Stock	0.908	0.9108	0.9038	0.9045	48175440.0
2007-10-03 12:00:00	NVDA	Stock	0.9048	0.905	0.8938	0.8963	66181720.0
2007-10-03 13:00:00	NVDA	Stock	0.8963	0.8963	0.8855	0.8888	64097160.0
2007-10-03 14:00:00	NVDA	Stock	0.8888	0.8893	0.8808	0.8855	65622960.0
2007-10-03 15:00:00	NVDA	Stock	0.8855	0.897	0.8855	0.8953	84360560.0
2007-10-03 16:00:00	NVDA	Stock	0.8953	0.9088	0.8888	0.9088	3595720.0
2007-10-03 17:00:00	NVDA	Stock	0.8928	0.8928	0.8928	0.8928	20000.0
2007-10-03 18:00:00	NVDA	Stock	0.8943	0.8943	0.8888	0.8888	75600.0
2007-10-03 07:00:00	AMZN	Stock	4.665	4.665	4.6	4.6385	28000.0
2007-10-03 08:00:00	AMZN	Stock	4.618	4.625	4.6	4.6	184420.0
2007-10-03 09:00:00	AMZN	Stock	4.6	4.62	4.589	4.5955	8597120.0
2007-10-03 10:00:00	AMZN	Stock	4.5955	4.6175	4.595	4.6135	14714860.0
2007-10-03 11:00:00	AMZN	Stock	4.614	4.6175	4.61	4.6105	13437520.0
2007-10-03 12:00:00	AMZN	Stock	4.6105	4.64	4.6105	4.63	17701780.0
2007-10-03 13:00:00	AMZN	Stock	4.63	4.6315	4.614	4.619	10272620.0
2007-10-03 14:00:00	AMZN	Stock	4.619	4.6205	4.6025	4.6175	16404760.0
2007-10-03 15:00:00	AMZN	Stock	4.6175	4.6334	4.61	4.6235	17133180.0
2007-10-03 16:00:00	AMZN	Stock	4.6235	4.625	4.6017	4.6175	2751540.0
2007-10-03 17:00:00	AMZN	Stock	4.614	4.6199	4.614	4.6175	175940.0
2007-10-03 18:00:00	AMZN	Stock	4.6105	4.6125	4.61	4.6125	22020.0

> showing 50 of 39,134 rows — these rows as CSV

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