PREVIEW / stock_1hour / 2007-01-08

all stock 1-hour files

  file:    by_date/stock_1hour/2007/2007-01-08.parquet
  size:    643 KB
  rows:    30,456
  symbols: 2,483

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-01-08 05:00:00	AAPL	Stock	3.0421	3.0443	3.0421	3.0443	11200.0
2007-01-08 06:00:00	AAPL	Stock	3.0429	3.0714	3.0429	3.0686	89320.0
2007-01-08 07:00:00	AAPL	Stock	3.0554	3.0779	3.055	3.075	793520.0
2007-01-08 08:00:00	AAPL	Stock	3.0739	3.0764	3.0489	3.0571	4402272.0
2007-01-08 09:00:00	AAPL	Stock	3.0589	3.0904	3.0504	3.075	161435596.0
2007-01-08 10:00:00	AAPL	Stock	3.0746	3.0864	3.0568	3.0568	154932512.0
2007-01-08 11:00:00	AAPL	Stock	3.0568	3.0746	3.0561	3.0714	93862104.0
2007-01-08 12:00:00	AAPL	Stock	3.0714	3.075	3.0625	3.0667	66878448.0
2007-01-08 13:00:00	AAPL	Stock	3.0667	3.0846	3.0607	3.0789	79893828.0
2007-01-08 14:00:00	AAPL	Stock	3.0789	3.0804	3.0507	3.0557	102868248.0
2007-01-08 15:00:00	AAPL	Stock	3.0561	3.0628	3.0457	3.0521	122394804.0
2007-01-08 16:00:00	AAPL	Stock	3.0525	3.0596	3.05	3.0571	1858136.0
2007-01-08 17:00:00	AAPL	Stock	3.0575	3.06	3.0539	3.0543	684320.0
2007-01-08 18:00:00	AAPL	Stock	3.0564	3.0718	3.0536	3.0554	386316.0
2007-01-08 19:00:00	AAPL	Stock	3.0539	3.0589	3.0539	3.0586	226464.0
2007-01-08 06:00:00	MSFT	Stock	29.62	29.62	29.62	29.62	500.0
2007-01-08 08:00:00	MSFT	Stock	29.6	29.67	29.6	29.65	32295.0
2007-01-08 09:00:00	MSFT	Stock	29.67	29.81	29.64	29.68	5652390.0
2007-01-08 10:00:00	MSFT	Stock	29.69	29.76	29.53	29.72	7858069.0
2007-01-08 11:00:00	MSFT	Stock	29.72	29.82	29.67	29.8	5385875.0
2007-01-08 12:00:00	MSFT	Stock	29.79	29.88	29.78	29.81	4073024.0
2007-01-08 13:00:00	MSFT	Stock	29.81	29.91	29.77	29.89	4071022.0
2007-01-08 14:00:00	MSFT	Stock	29.893	30.0	29.86	29.95	6553934.0
2007-01-08 15:00:00	MSFT	Stock	29.95	30.1	29.674	29.94	12286909.0
2007-01-08 16:00:00	MSFT	Stock	29.94	29.96	29.92	29.93	1844299.0
2007-01-08 17:00:00	MSFT	Stock	29.94	29.94	29.93	29.93	1400.0
2007-01-08 18:00:00	MSFT	Stock	29.93	29.93	29.93	29.93	200.0
2007-01-08 19:00:00	MSFT	Stock	29.92	29.94	29.91	29.94	5593.0
2007-01-08 08:00:00	NVDA	Stock	0.562	0.5628	0.5618	0.5625	135420.0
2007-01-08 09:00:00	NVDA	Stock	0.5642	0.5665	0.5533	0.565	104508420.0
2007-01-08 10:00:00	NVDA	Stock	0.5652	0.5667	0.5597	0.562	99317280.0
2007-01-08 11:00:00	NVDA	Stock	0.5622	0.5692	0.5617	0.5688	86076480.0
2007-01-08 12:00:00	NVDA	Stock	0.5688	0.5717	0.5665	0.5715	91541640.0
2007-01-08 13:00:00	NVDA	Stock	0.5713	0.5742	0.5687	0.5737	57346320.0
2007-01-08 14:00:00	NVDA	Stock	0.5735	0.576	0.5727	0.5728	77018760.0
2007-01-08 15:00:00	NVDA	Stock	0.5727	0.575	0.565	0.5658	118710840.0
2007-01-08 16:00:00	NVDA	Stock	0.5652	0.5667	0.5643	0.5652	842340.0
2007-01-08 17:00:00	NVDA	Stock	0.5657	0.5663	0.5653	0.5658	261000.0
2007-01-08 19:00:00	NVDA	Stock	0.5658	0.5658	0.5658	0.5658	30000.0
2007-01-08 08:00:00	AMZN	Stock	1.92	1.92	1.9185	1.9185	16000.0
2007-01-08 09:00:00	AMZN	Stock	1.9135	1.9155	1.8985	1.9085	9232480.0
2007-01-08 10:00:00	AMZN	Stock	1.909	1.9145	1.8805	1.8815	23633480.0
2007-01-08 11:00:00	AMZN	Stock	1.8815	1.8885	1.8705	1.8778	16025800.0
2007-01-08 12:00:00	AMZN	Stock	1.8775	1.8815	1.8585	1.8715	20790280.0
2007-01-08 13:00:00	AMZN	Stock	1.8715	1.887	1.869	1.882	15321660.0
2007-01-08 14:00:00	AMZN	Stock	1.882	1.893	1.875	1.8765	15473840.0
2007-01-08 15:00:00	AMZN	Stock	1.876	1.8875	1.8695	1.875	25170000.0
2007-01-08 16:00:00	AMZN	Stock	1.875	1.8795	1.8525	1.8625	374840.0
2007-01-08 17:00:00	AMZN	Stock	1.867	1.8685	1.867	1.8685	62000.0
2007-01-08 18:00:00	AMZN	Stock	1.87	1.878	1.87	1.878	32500.0

> showing 50 of 30,456 rows — these rows as CSV

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