PREVIEW / stock_1hour / 2008-05-20

all stock 1-hour files

  file:    by_date/stock_1hour/2008/2008-05-20.parquet
  size:    842 KB
  rows:    40,366
  symbols: 3,318

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-05-20 05:00:00	AAPL	Stock	6.5661	6.5661	6.5614	6.5614	11200.0
2008-05-20 06:00:00	AAPL	Stock	6.5711	6.5711	6.5539	6.5539	14000.0
2008-05-20 07:00:00	AAPL	Stock	6.5182	6.5446	6.5182	6.5357	61488.0
2008-05-20 08:00:00	AAPL	Stock	6.5304	6.5621	6.5018	6.5057	4914392.0
2008-05-20 09:00:00	AAPL	Stock	6.5054	6.5779	6.4329	6.5324	167755028.0
2008-05-20 10:00:00	AAPL	Stock	6.5318	6.5868	6.5036	6.5843	175983052.0
2008-05-20 11:00:00	AAPL	Stock	6.5843	6.5893	6.5357	6.5736	101421376.0
2008-05-20 12:00:00	AAPL	Stock	6.5736	6.6382	6.565	6.6018	103273016.0
2008-05-20 13:00:00	AAPL	Stock	6.6018	6.625	6.5375	6.5393	81158560.0
2008-05-20 14:00:00	AAPL	Stock	6.5389	6.6243	6.5261	6.5907	127241156.0
2008-05-20 15:00:00	AAPL	Stock	6.5918	6.6486	6.5768	6.6411	180985056.0
2008-05-20 16:00:00	AAPL	Stock	6.6449	6.6457	6.5709	6.6389	10033324.0
2008-05-20 17:00:00	AAPL	Stock	6.6375	6.6429	6.6139	6.6243	683396.0
2008-05-20 18:00:00	AAPL	Stock	6.6243	6.6321	6.6214	6.6321	235592.0
2008-05-20 19:00:00	AAPL	Stock	6.6304	6.6304	6.6218	6.625	200620.0
2008-05-20 08:00:00	MSFT	Stock	29.46	29.5	29.36	29.42	33894.0
2008-05-20 09:00:00	MSFT	Stock	29.41	29.43	29.01	29.01	5727109.0
2008-05-20 10:00:00	MSFT	Stock	29.01	29.02	28.87	28.99	12604146.0
2008-05-20 11:00:00	MSFT	Stock	28.99	29.05	28.63	28.728	12898385.0
2008-05-20 12:00:00	MSFT	Stock	28.72	28.85	28.64	28.76	9540041.0
2008-05-20 13:00:00	MSFT	Stock	28.76	28.92	28.73	28.82	8633387.0
2008-05-20 14:00:00	MSFT	Stock	28.82	28.96	28.756	28.89	7243472.0
2008-05-20 15:00:00	MSFT	Stock	28.89	28.98	28.737	28.77	15727656.0
2008-05-20 16:00:00	MSFT	Stock	28.79	29.275	28.76	28.76	2360092.0
2008-05-20 17:00:00	MSFT	Stock	28.79	28.84	28.75	28.77	134188.0
2008-05-20 18:00:00	MSFT	Stock	28.83	28.83	28.78	28.79	4400.0
2008-05-20 19:00:00	MSFT	Stock	28.82	28.85	28.81	28.82	28396.0
2008-05-20 07:00:00	NVDA	Stock	0.5938	0.5938	0.5938	0.5938	32000.0
2008-05-20 08:00:00	NVDA	Stock	0.5933	0.5955	0.5878	0.59	255000.0
2008-05-20 09:00:00	NVDA	Stock	0.59	0.59	0.5758	0.5863	130293600.0
2008-05-20 10:00:00	NVDA	Stock	0.5863	0.588	0.579	0.5855	157567640.0
2008-05-20 11:00:00	NVDA	Stock	0.5855	0.5858	0.5752	0.576	83183840.0
2008-05-20 12:00:00	NVDA	Stock	0.576	0.5822	0.576	0.5788	65523920.0
2008-05-20 13:00:00	NVDA	Stock	0.5788	0.584	0.577	0.579	82690720.0
2008-05-20 14:00:00	NVDA	Stock	0.5788	0.5812	0.576	0.5777	81720000.0
2008-05-20 15:00:00	NVDA	Stock	0.5777	0.582	0.5762	0.582	142595320.0
2008-05-20 16:00:00	NVDA	Stock	0.582	0.584	0.5792	0.5806	6627920.0
2008-05-20 17:00:00	NVDA	Stock	0.5825	0.5825	0.582	0.582	228000.0
2008-05-20 18:00:00	NVDA	Stock	0.5822	0.584	0.582	0.584	104000.0
2008-05-20 19:00:00	NVDA	Stock	0.5828	0.5828	0.5828	0.5828	36000.0
2008-05-20 07:00:00	AMZN	Stock	4.105	4.105	4.105	4.105	2000.0
2008-05-20 08:00:00	AMZN	Stock	4.12	4.125	4.0855	4.0855	238100.0
2008-05-20 09:00:00	AMZN	Stock	4.086	4.135	4.0515	4.0615	30494680.0
2008-05-20 10:00:00	AMZN	Stock	4.0615	4.067	4.01	4.0235	33988760.0
2008-05-20 11:00:00	AMZN	Stock	4.0235	4.044	4.0015	4.041	19449900.0
2008-05-20 12:00:00	AMZN	Stock	4.041	4.064	4.0355	4.0535	14312440.0
2008-05-20 13:00:00	AMZN	Stock	4.0535	4.0665	4.0395	4.0445	13649740.0
2008-05-20 14:00:00	AMZN	Stock	4.0455	4.046	4.028	4.0365	14609100.0
2008-05-20 15:00:00	AMZN	Stock	4.036	4.0465	4.021	4.031	24866360.0
2008-05-20 16:00:00	AMZN	Stock	4.036	4.1053	4.0335	4.0375	1841500.0

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

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