PREVIEW / stock_1hour / 2011-06-23

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-23.parquet
  size:    942 KB
  rows:    44,764
  symbols: 3,533

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
2011-06-23 04:00:00	AAPL	Stock	11.4846	11.4846	11.4846	11.4846	2800.0
2011-06-23 06:00:00	AAPL	Stock	11.4654	11.4654	11.4421	11.4421	43064.0
2011-06-23 07:00:00	AAPL	Stock	11.4461	11.4821	11.4386	11.4596	359548.0
2011-06-23 08:00:00	AAPL	Stock	11.4643	11.4643	11.3571	11.3818	3189648.0
2011-06-23 09:00:00	AAPL	Stock	11.3818	11.4914	11.3614	11.48	73644536.0
2011-06-23 10:00:00	AAPL	Stock	11.48	11.6057	11.4643	11.5357	107612232.0
2011-06-23 11:00:00	AAPL	Stock	11.5364	11.6071	11.52	11.6025	50227632.0
2011-06-23 12:00:00	AAPL	Stock	11.6021	11.6868	11.6018	11.6864	59778180.0
2011-06-23 13:00:00	AAPL	Stock	11.6864	11.7318	11.6607	11.6937	68199264.0
2011-06-23 14:00:00	AAPL	Stock	11.6939	11.74	11.62	11.7387	58127832.0
2011-06-23 15:00:00	AAPL	Stock	11.7396	11.8461	11.6868	11.83	115732652.0
2011-06-23 16:00:00	AAPL	Stock	11.8349	11.8411	11.5435	11.8018	16493232.0
2011-06-23 17:00:00	AAPL	Stock	11.8032	11.8218	11.8032	11.8193	475160.0
2011-06-23 18:00:00	AAPL	Stock	11.8211	11.8575	11.8211	11.8454	925708.0
2011-06-23 19:00:00	AAPL	Stock	11.8464	11.8529	11.8393	11.85	289100.0
2011-06-23 07:00:00	MSFT	Stock	24.5	24.5	24.5	24.5	400.0
2011-06-23 08:00:00	MSFT	Stock	24.5	24.56	24.43	24.49	41004.0
2011-06-23 09:00:00	MSFT	Stock	24.49	24.53	24.36	24.4	6069451.0
2011-06-23 10:00:00	MSFT	Stock	24.4	24.4	24.2	24.249	11193839.0
2011-06-23 11:00:00	MSFT	Stock	24.245	24.31	24.21	24.305	6430791.0
2011-06-23 12:00:00	MSFT	Stock	24.302	24.34	24.26	24.335	6520315.0
2011-06-23 13:00:00	MSFT	Stock	24.34	24.46	24.29	24.34	5918194.0
2011-06-23 14:00:00	MSFT	Stock	24.34	24.52	24.27	24.52	5964335.0
2011-06-23 15:00:00	MSFT	Stock	24.49	24.65	24.42	24.64	13845248.0
2011-06-23 16:00:00	MSFT	Stock	24.63	24.64	24.3	24.51	3052132.0
2011-06-23 17:00:00	MSFT	Stock	24.51	24.55	24.51	24.55	1700.0
2011-06-23 18:00:00	MSFT	Stock	24.55	24.63	24.55	24.58	12100.0
2011-06-23 19:00:00	MSFT	Stock	24.57	24.6	24.57	24.57	1200.0
2011-06-23 07:00:00	NVDA	Stock	0.3982	0.3982	0.3982	0.3982	4000.0
2011-06-23 08:00:00	NVDA	Stock	0.3928	0.3935	0.3848	0.388	223000.0
2011-06-23 09:00:00	NVDA	Stock	0.3878	0.3895	0.385	0.386	70509280.0
2011-06-23 10:00:00	NVDA	Stock	0.3862	0.393	0.3855	0.3925	124134480.0
2011-06-23 11:00:00	NVDA	Stock	0.3925	0.3965	0.389	0.3958	109171640.0
2011-06-23 12:00:00	NVDA	Stock	0.3956	0.4003	0.395	0.4003	102541280.0
2011-06-23 13:00:00	NVDA	Stock	0.4001	0.4025	0.3998	0.4018	80878960.0
2011-06-23 14:00:00	NVDA	Stock	0.4015	0.4032	0.3985	0.4031	72375720.0
2011-06-23 15:00:00	NVDA	Stock	0.4031	0.4079	0.402	0.4053	157175160.0
2011-06-23 16:00:00	NVDA	Stock	0.4053	0.4079	0.3967	0.401	16276880.0
2011-06-23 17:00:00	NVDA	Stock	0.4005	0.401	0.4	0.401	493400.0
2011-06-23 18:00:00	NVDA	Stock	0.4025	0.4032	0.4025	0.4032	66000.0
2011-06-23 19:00:00	NVDA	Stock	0.4013	0.4028	0.4	0.4028	138960.0
2011-06-23 07:00:00	AMZN	Stock	9.55	9.55	9.533	9.533	4000.0
2011-06-23 08:00:00	AMZN	Stock	9.5375	9.5375	9.465	9.475	459480.0
2011-06-23 09:00:00	AMZN	Stock	9.475	9.5275	9.436	9.4605	13604680.0
2011-06-23 10:00:00	AMZN	Stock	9.4625	9.4977	9.415	9.4405	18131840.0
2011-06-23 11:00:00	AMZN	Stock	9.4405	9.5445	9.4205	9.5375	8688620.0
2011-06-23 12:00:00	AMZN	Stock	9.536	9.569	9.4945	9.552	6862380.0
2011-06-23 13:00:00	AMZN	Stock	9.553	9.6094	9.547	9.584	8401100.0
2011-06-23 14:00:00	AMZN	Stock	9.584	9.6395	9.5355	9.6375	8075120.0
2011-06-23 15:00:00	AMZN	Stock	9.64	9.723	9.6005	9.708	23377540.0

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

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