PREVIEW / stock_1hour / 2010-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-05-25.parquet
  size:    937 KB
  rows:    44,712
  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-05-25 04:00:00	AAPL	Stock	8.5714	8.6786	8.5554	8.5554	35280.0
2010-05-25 05:00:00	AAPL	Stock	8.5714	8.5857	8.5554	8.5554	58520.0
2010-05-25 06:00:00	AAPL	Stock	8.5557	8.6214	8.5343	8.6214	124040.0
2010-05-25 07:00:00	AAPL	Stock	8.6071	8.6207	8.5536	8.6207	1033536.0
2010-05-25 08:00:00	AAPL	Stock	8.6221	8.6646	8.5807	8.5936	7578844.0
2010-05-25 09:00:00	AAPL	Stock	8.5939	8.8129	8.47	8.5261	164546200.0
2010-05-25 10:00:00	AAPL	Stock	8.5286	8.6425	8.5114	8.56	192685500.0
2010-05-25 11:00:00	AAPL	Stock	8.5614	8.6207	8.5182	8.5986	113205624.0
2010-05-25 12:00:00	AAPL	Stock	8.6007	8.6479	8.5479	8.5811	84898968.0
2010-05-25 13:00:00	AAPL	Stock	8.5831	8.5875	8.5236	8.5378	71365028.0
2010-05-25 14:00:00	AAPL	Stock	8.5361	8.6929	8.5179	8.6598	146159916.0
2010-05-25 15:00:00	AAPL	Stock	8.658	8.8129	8.6579	8.7571	234553060.0
2010-05-25 16:00:00	AAPL	Stock	8.7571	8.7664	8.5807	8.7664	16253048.0
2010-05-25 17:00:00	AAPL	Stock	8.7664	8.825	8.7664	8.8171	2223032.0
2010-05-25 18:00:00	AAPL	Stock	8.8171	8.8204	8.7579	8.8079	838992.0
2010-05-25 19:00:00	AAPL	Stock	8.8125	8.8268	8.8107	8.8229	677012.0
2010-05-25 20:00:00	AAPL	Stock	8.8086	8.8086	8.8086	8.8086	103600.0
2010-05-25 06:00:00	MSFT	Stock	25.55	25.7	25.55	25.7	5250.0
2010-05-25 07:00:00	MSFT	Stock	25.79	25.85	25.65	25.85	37964.0
2010-05-25 08:00:00	MSFT	Stock	25.89	25.9	25.62	25.65	116175.0
2010-05-25 09:00:00	MSFT	Stock	25.64	26.8	25.38	25.59	10902169.0
2010-05-25 10:00:00	MSFT	Stock	25.59	25.67	25.465	25.64	18395586.0
2010-05-25 11:00:00	MSFT	Stock	25.64	25.82	25.57	25.81	11575914.0
2010-05-25 12:00:00	MSFT	Stock	25.82	25.93	25.66	25.78	8192905.0
2010-05-25 13:00:00	MSFT	Stock	25.77	25.8	25.58	25.65	8570673.0
2010-05-25 14:00:00	MSFT	Stock	25.65	25.88	25.62	25.789	11176384.0
2010-05-25 15:00:00	MSFT	Stock	25.78	26.08	25.68	26.07	23145440.0
2010-05-25 16:00:00	MSFT	Stock	26.06	26.33	25.52	26.07	4291184.0
2010-05-25 17:00:00	MSFT	Stock	26.07	26.26	26.07	26.21	18209.0
2010-05-25 18:00:00	MSFT	Stock	26.26	26.3	26.07	26.3	144720.0
2010-05-25 19:00:00	MSFT	Stock	26.25	26.3	26.2	26.25	6850.0
2010-05-25 20:00:00	MSFT	Stock	26.45	26.45	26.45	26.45	45100.0
2010-05-25 05:00:00	NVDA	Stock	0.3015	0.3015	0.3015	0.3015	4000.0
2010-05-25 07:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	4000.0
2010-05-25 08:00:00	NVDA	Stock	0.3	0.3018	0.299	0.299	415960.0
2010-05-25 09:00:00	NVDA	Stock	0.2975	0.3045	0.2962	0.304	124427280.0
2010-05-25 10:00:00	NVDA	Stock	0.304	0.3098	0.304	0.3061	185368040.0
2010-05-25 11:00:00	NVDA	Stock	0.3061	0.3113	0.3058	0.3113	85566640.0
2010-05-25 12:00:00	NVDA	Stock	0.3111	0.3133	0.3093	0.3113	97088640.0
2010-05-25 13:00:00	NVDA	Stock	0.3113	0.3114	0.3083	0.3095	105035000.0
2010-05-25 14:00:00	NVDA	Stock	0.3094	0.3135	0.3083	0.3128	145042320.0
2010-05-25 15:00:00	NVDA	Stock	0.3126	0.3188	0.312	0.3175	208264760.0
2010-05-25 16:00:00	NVDA	Stock	0.3178	0.318	0.3094	0.3173	4523560.0
2010-05-25 17:00:00	NVDA	Stock	0.318	0.3193	0.318	0.3188	133840.0
2010-05-25 18:00:00	NVDA	Stock	0.3188	0.3193	0.3188	0.3193	32160.0
2010-05-25 19:00:00	NVDA	Stock	0.3183	0.319	0.318	0.319	88920.0
2010-05-25 07:00:00	AMZN	Stock	6.0	6.0	5.95	5.95	44000.0
2010-05-25 08:00:00	AMZN	Stock	5.95	5.9655	5.929	5.9395	181300.0
2010-05-25 09:00:00	AMZN	Stock	5.9415	6.106	5.925	5.983	15287040.0
2010-05-25 10:00:00	AMZN	Stock	5.983	6.081	5.982	6.0725	22376040.0

> showing 50 of 44,712 rows — these rows as CSV

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