PREVIEW / stock_1hour / 2008-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-02-05.parquet
  size:    810 KB
  rows:    40,214
  symbols: 3,235

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-02-05 05:00:00	AAPL	Stock	4.71	4.7107	4.7036	4.7036	14000.0
2008-02-05 06:00:00	AAPL	Stock	4.7168	4.7168	4.6957	4.7132	72100.0
2008-02-05 07:00:00	AAPL	Stock	4.6532	4.7179	4.6532	4.6857	200368.0
2008-02-05 08:00:00	AAPL	Stock	4.6839	4.7743	4.6625	4.6732	12498136.0
2008-02-05 09:00:00	AAPL	Stock	4.6732	4.7571	4.6486	4.7479	179914924.0
2008-02-05 10:00:00	AAPL	Stock	4.7475	4.7857	4.6957	4.7168	206086664.0
2008-02-05 11:00:00	AAPL	Stock	4.7171	4.7211	4.6636	4.6696	125295324.0
2008-02-05 12:00:00	AAPL	Stock	4.6689	4.6818	4.6464	4.655	99414756.0
2008-02-05 13:00:00	AAPL	Stock	4.655	4.6668	4.6096	4.6221	150858204.0
2008-02-05 14:00:00	AAPL	Stock	4.6225	4.6754	4.6036	4.6411	159335904.0
2008-02-05 15:00:00	AAPL	Stock	4.6407	4.6629	4.6168	4.6221	186912684.0
2008-02-05 16:00:00	AAPL	Stock	4.6207	4.6767	4.6154	4.6282	18694004.0
2008-02-05 17:00:00	AAPL	Stock	4.6286	4.6428	4.62	4.6428	829612.0
2008-02-05 18:00:00	AAPL	Stock	4.6339	4.6339	4.6257	4.6289	319396.0
2008-02-05 19:00:00	AAPL	Stock	4.6304	4.6425	4.63	4.6339	601412.0
2008-02-05 07:00:00	MSFT	Stock	30.16	30.19	30.15	30.19	6200.0
2008-02-05 08:00:00	MSFT	Stock	30.19	30.2	29.95	29.95	1164703.0
2008-02-05 09:00:00	MSFT	Stock	29.94	29.99	28.89	29.74	17566405.0
2008-02-05 10:00:00	MSFT	Stock	29.73	29.92	29.64	29.84	19190760.0
2008-02-05 11:00:00	MSFT	Stock	29.84	29.92	29.71	29.83	19858821.0
2008-02-05 12:00:00	MSFT	Stock	29.829	29.83	29.6	29.64	10736995.0
2008-02-05 13:00:00	MSFT	Stock	29.639	29.65	29.32	29.37	16231844.0
2008-02-05 14:00:00	MSFT	Stock	29.37	29.42	29.2	29.21	17206083.0
2008-02-05 15:00:00	MSFT	Stock	29.209	29.39	29.01	29.07	31588676.0
2008-02-05 16:00:00	MSFT	Stock	29.1	29.576	29.03	29.17	3840201.0
2008-02-05 17:00:00	MSFT	Stock	29.03	29.25	29.03	29.2	127161.0
2008-02-05 18:00:00	MSFT	Stock	29.22	29.24	29.17	29.18	10034.0
2008-02-05 19:00:00	MSFT	Stock	29.22	29.28	29.2	29.28	6370.0
2008-02-05 08:00:00	NVDA	Stock	0.6513	0.6513	0.645	0.645	48800.0
2008-02-05 09:00:00	NVDA	Stock	0.6428	0.6428	0.623	0.6303	55803720.0
2008-02-05 10:00:00	NVDA	Stock	0.6303	0.6322	0.6188	0.6218	80345360.0
2008-02-05 11:00:00	NVDA	Stock	0.6218	0.623	0.613	0.6176	86551440.0
2008-02-05 12:00:00	NVDA	Stock	0.6175	0.6193	0.6128	0.616	46120000.0
2008-02-05 13:00:00	NVDA	Stock	0.6158	0.619	0.6105	0.6128	52316640.0
2008-02-05 14:00:00	NVDA	Stock	0.6128	0.6188	0.6103	0.6153	52068240.0
2008-02-05 15:00:00	NVDA	Stock	0.6153	0.6165	0.6095	0.6098	93852920.0
2008-02-05 16:00:00	NVDA	Stock	0.6105	0.6184	0.6098	0.6098	27557000.0
2008-02-05 17:00:00	NVDA	Stock	0.6098	0.615	0.6098	0.615	224240.0
2008-02-05 18:00:00	NVDA	Stock	0.615	0.6162	0.615	0.6162	123400.0
2008-02-05 19:00:00	NVDA	Stock	0.6162	0.6162	0.6162	0.6162	4000.0
2008-02-05 08:00:00	AMZN	Stock	3.6975	3.6975	3.6325	3.65	469600.0
2008-02-05 09:00:00	AMZN	Stock	3.6495	3.7105	3.63	3.706	32785160.0
2008-02-05 10:00:00	AMZN	Stock	3.705	3.7095	3.6085	3.621	42640260.0
2008-02-05 11:00:00	AMZN	Stock	3.623	3.6595	3.6125	3.6545	20493540.0
2008-02-05 12:00:00	AMZN	Stock	3.6555	3.6625	3.6155	3.6295	15015160.0
2008-02-05 13:00:00	AMZN	Stock	3.629	3.64	3.6085	3.621	16817440.0
2008-02-05 14:00:00	AMZN	Stock	3.6215	3.6475	3.61	3.6135	18015040.0
2008-02-05 15:00:00	AMZN	Stock	3.6133	3.6295	3.6	3.6045	37066720.0
2008-02-05 16:00:00	AMZN	Stock	3.604	3.6359	3.604	3.612	9294960.0
2008-02-05 17:00:00	AMZN	Stock	3.6045	3.615	3.6045	3.615	79780.0

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

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