PREVIEW / stock_1hour / 2009-04-23

all stock 1-hour files

  file:    by_date/stock_1hour/2009/2009-04-23.parquet
  size:    814 KB
  rows:    40,080
  symbols: 3,295

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
2009-04-23 04:00:00	AAPL	Stock	4.4696	4.4696	4.4696	4.4696	2800.0
2009-04-23 05:00:00	AAPL	Stock	4.4793	4.4964	4.4793	4.4964	39088.0
2009-04-23 06:00:00	AAPL	Stock	4.4993	4.5296	4.4993	4.505	133840.0
2009-04-23 07:00:00	AAPL	Stock	4.5043	4.5357	4.4743	4.5082	3142328.0
2009-04-23 08:00:00	AAPL	Stock	4.5075	4.5786	4.4821	4.5746	21006412.0
2009-04-23 09:00:00	AAPL	Stock	4.5743	4.5786	4.4179	4.4411	221170544.0
2009-04-23 10:00:00	AAPL	Stock	4.4407	4.5093	4.4289	4.4562	167375292.0
2009-04-23 11:00:00	AAPL	Stock	4.4571	4.4893	4.4111	4.4746	93196432.0
2009-04-23 12:00:00	AAPL	Stock	4.475	4.5046	4.4689	4.4961	94765384.0
2009-04-23 13:00:00	AAPL	Stock	4.4961	4.5107	4.47	4.4948	90883324.0
2009-04-23 14:00:00	AAPL	Stock	4.4948	4.4964	4.4504	4.48	87361792.0
2009-04-23 15:00:00	AAPL	Stock	4.4796	4.495	4.4475	4.4864	134692796.0
2009-04-23 16:00:00	AAPL	Stock	4.4864	4.4875	4.4607	4.4821	15330728.0
2009-04-23 17:00:00	AAPL	Stock	4.4839	4.495	4.475	4.4768	745780.0
2009-04-23 18:00:00	AAPL	Stock	4.4768	4.4821	4.4643	4.4686	1311268.0
2009-04-23 19:00:00	AAPL	Stock	4.4686	4.4686	4.4636	4.4646	280700.0
2009-04-23 20:00:00	AAPL	Stock	4.4836	4.4836	4.4836	4.4836	324800.0
2009-04-23 07:00:00	MSFT	Stock	19.14	19.14	18.95	18.95	5110.0
2009-04-23 08:00:00	MSFT	Stock	19.05	19.16	19.0	19.05	31475.0
2009-04-23 09:00:00	MSFT	Stock	19.06	19.06	18.57	18.615	7372654.0
2009-04-23 10:00:00	MSFT	Stock	18.61	18.74	18.5	18.52	10484761.0
2009-04-23 11:00:00	MSFT	Stock	18.52	18.65	18.5	18.548	6484223.0
2009-04-23 12:00:00	MSFT	Stock	18.54	18.817	18.52	18.59	6532374.0
2009-04-23 13:00:00	MSFT	Stock	18.59	18.63	18.52	18.55	10331059.0
2009-04-23 14:00:00	MSFT	Stock	18.55	18.65	18.47	18.61	13083165.0
2009-04-23 15:00:00	MSFT	Stock	18.615	18.94	18.595	18.92	17225551.0
2009-04-23 16:00:00	MSFT	Stock	18.93	20.03	17.89	19.67	11824270.0
2009-04-23 17:00:00	MSFT	Stock	19.66	19.9	19.55	19.66	1410440.0
2009-04-23 18:00:00	MSFT	Stock	19.67	19.67	18.92	19.4	357977.0
2009-04-23 19:00:00	MSFT	Stock	19.38	19.56	19.38	19.5	93115.0
2009-04-23 07:00:00	NVDA	Stock	0.3	0.3	0.3	0.3	8000.0
2009-04-23 08:00:00	NVDA	Stock	0.2945	0.2965	0.2945	0.2965	242000.0
2009-04-23 09:00:00	NVDA	Stock	0.2872	0.289	0.2765	0.2778	96439400.0
2009-04-23 10:00:00	NVDA	Stock	0.2775	0.2812	0.276	0.2763	117538680.0
2009-04-23 11:00:00	NVDA	Stock	0.2763	0.2763	0.2705	0.2715	93831080.0
2009-04-23 12:00:00	NVDA	Stock	0.2715	0.2758	0.2712	0.2758	57442520.0
2009-04-23 13:00:00	NVDA	Stock	0.2754	0.2781	0.2749	0.2763	91169360.0
2009-04-23 14:00:00	NVDA	Stock	0.276	0.2792	0.2746	0.277	66080440.0
2009-04-23 15:00:00	NVDA	Stock	0.277	0.2803	0.275	0.2795	214211040.0
2009-04-23 16:00:00	NVDA	Stock	0.2803	0.2803	0.2763	0.2799	3759520.0
2009-04-23 18:00:00	NVDA	Stock	0.28	0.2812	0.28	0.28	100000.0
2009-04-23 19:00:00	NVDA	Stock	0.2795	0.2795	0.2792	0.2792	100000.0
2009-04-23 07:00:00	AMZN	Stock	4.0605	4.0605	4.01	4.01	112940.0
2009-04-23 08:00:00	AMZN	Stock	4.01	4.0745	4.01	4.063	1257540.0
2009-04-23 09:00:00	AMZN	Stock	4.0635	4.103	4.05	4.069	31544860.0
2009-04-23 10:00:00	AMZN	Stock	4.0695	4.0925	4.0285	4.0325	35502000.0
2009-04-23 11:00:00	AMZN	Stock	4.033	4.034	4.003	4.0097	20211740.0
2009-04-23 12:00:00	AMZN	Stock	4.009	4.031	4.0065	4.0225	16673680.0
2009-04-23 13:00:00	AMZN	Stock	4.0219	4.0255	4.0065	4.0155	21845240.0
2009-04-23 14:00:00	AMZN	Stock	4.015	4.0175	3.9655	3.9845	40122840.0

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

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