PREVIEW / stock_1hour / 2010-07-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-07-27.parquet
  size:    904 KB
  rows:    43,090
  symbols: 3,465

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-07-27 05:00:00	AAPL	Stock	9.2718	9.2718	9.25	9.26	26348.0
2010-07-27 06:00:00	AAPL	Stock	9.2507	9.2693	9.2507	9.2693	21000.0
2010-07-27 07:00:00	AAPL	Stock	9.2689	9.2693	9.2104	9.2282	371000.0
2010-07-27 08:00:00	AAPL	Stock	9.2282	9.3193	9.2143	9.2979	3962980.0
2010-07-27 09:00:00	AAPL	Stock	9.2982	9.4071	9.2879	9.3979	110931884.0
2010-07-27 10:00:00	AAPL	Stock	9.3954	9.4193	9.3464	9.3661	115795092.0
2010-07-27 11:00:00	AAPL	Stock	9.3674	9.3885	9.3268	9.3871	57689296.0
2010-07-27 12:00:00	AAPL	Stock	9.3879	9.4204	9.3768	9.4071	64903160.0
2010-07-27 13:00:00	AAPL	Stock	9.4073	9.4232	9.3821	9.4107	53568144.0
2010-07-27 14:00:00	AAPL	Stock	9.41	9.4446	9.4029	9.4371	71132824.0
2010-07-27 15:00:00	AAPL	Stock	9.4371	9.4571	9.425	9.4318	89162248.0
2010-07-27 16:00:00	AAPL	Stock	9.4304	9.4385	9.2648	9.4314	7992852.0
2010-07-27 17:00:00	AAPL	Stock	9.4318	9.4375	9.4257	9.4375	323624.0
2010-07-27 18:00:00	AAPL	Stock	9.4393	9.4414	9.4314	9.4336	3377276.0
2010-07-27 19:00:00	AAPL	Stock	9.4332	9.4404	9.4257	9.4321	418012.0
2010-07-27 06:00:00	MSFT	Stock	26.35	26.37	26.24	26.24	2400.0
2010-07-27 07:00:00	MSFT	Stock	26.24	26.3	26.23	26.23	8050.0
2010-07-27 08:00:00	MSFT	Stock	26.25	26.28	26.19	26.2	63164.0
2010-07-27 09:00:00	MSFT	Stock	26.2	26.24	26.06	26.09	7409113.0
2010-07-27 10:00:00	MSFT	Stock	26.08	26.16	25.99	26.05	13026882.0
2010-07-27 11:00:00	MSFT	Stock	26.056	26.09	25.96	26.08	7487342.0
2010-07-27 12:00:00	MSFT	Stock	26.09	26.12	26.03	26.08	3606239.0
2010-07-27 13:00:00	MSFT	Stock	26.075	26.09	26.0	26.06	4232784.0
2010-07-27 14:00:00	MSFT	Stock	26.06	26.11	26.01	26.06	5135712.0
2010-07-27 15:00:00	MSFT	Stock	26.055	26.18	25.97	26.16	10513826.0
2010-07-27 16:00:00	MSFT	Stock	26.15	26.235	26.05	26.15	6477055.0
2010-07-27 17:00:00	MSFT	Stock	26.15	26.16	26.15	26.15	5500.0
2010-07-27 18:00:00	MSFT	Stock	26.15	26.16	26.12	26.12	17371.0
2010-07-27 19:00:00	MSFT	Stock	26.12	26.15	26.05	26.15	5286.0
2010-07-27 08:00:00	NVDA	Stock	0.2612	0.2663	0.2583	0.265	6643440.0
2010-07-27 09:00:00	NVDA	Stock	0.2652	0.266	0.2588	0.2608	109878800.0
2010-07-27 10:00:00	NVDA	Stock	0.2608	0.262	0.2586	0.2592	145661000.0
2010-07-27 11:00:00	NVDA	Stock	0.2592	0.2603	0.2583	0.2594	75003000.0
2010-07-27 12:00:00	NVDA	Stock	0.2595	0.2623	0.2591	0.262	82519160.0
2010-07-27 13:00:00	NVDA	Stock	0.262	0.2628	0.2605	0.2625	84530960.0
2010-07-27 14:00:00	NVDA	Stock	0.2625	0.2645	0.2618	0.2623	70725680.0
2010-07-27 15:00:00	NVDA	Stock	0.2621	0.2635	0.2612	0.2618	97393760.0
2010-07-27 16:00:00	NVDA	Stock	0.2615	0.2632	0.261	0.2615	6795640.0
2010-07-27 17:00:00	NVDA	Stock	0.2614	0.2615	0.2608	0.2608	219560.0
2010-07-27 18:00:00	NVDA	Stock	0.2608	0.2632	0.2605	0.2632	592000.0
2010-07-27 19:00:00	NVDA	Stock	0.2632	0.2632	0.2625	0.2632	499200.0
2010-07-27 08:00:00	AMZN	Stock	5.9205	5.9425	5.92	5.9225	173160.0
2010-07-27 09:00:00	AMZN	Stock	5.9215	5.9405	5.853	5.863	21052400.0
2010-07-27 10:00:00	AMZN	Stock	5.863	5.892	5.8	5.8025	30898620.0
2010-07-27 11:00:00	AMZN	Stock	5.8025	5.812	5.7533	5.806	25163060.0
2010-07-27 12:00:00	AMZN	Stock	5.806	5.8075	5.7565	5.7645	14790780.0
2010-07-27 13:00:00	AMZN	Stock	5.7635	5.8145	5.7575	5.8125	14828400.0
2010-07-27 14:00:00	AMZN	Stock	5.8125	5.8615	5.8115	5.8512	21606920.0
2010-07-27 15:00:00	AMZN	Stock	5.8518	5.8715	5.8395	5.8545	23492840.0
2010-07-27 16:00:00	AMZN	Stock	5.8515	5.8695	5.8264	5.862	1129940.0

> showing 50 of 43,090 rows — these rows as CSV

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