PREVIEW / stock_1hour / 2011-10-27

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-27.parquet
  size:    995 KB
  rows:    47,411
  symbols: 3,557

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-10-27 04:00:00	AAPL	Stock	14.3714	14.5161	14.3714	14.5161	66388.0
2011-10-27 05:00:00	AAPL	Stock	14.5179	14.5179	14.5	14.5089	34440.0
2011-10-27 06:00:00	AAPL	Stock	14.5357	14.5607	14.5179	14.5607	66920.0
2011-10-27 07:00:00	AAPL	Stock	14.5625	14.6032	14.5286	14.5739	1488676.0
2011-10-27 08:00:00	AAPL	Stock	14.5721	14.5829	14.5357	14.5575	4575200.0
2011-10-27 09:00:00	AAPL	Stock	14.5571	14.6071	14.4939	14.5036	75861968.0
2011-10-27 10:00:00	AAPL	Stock	14.5011	14.5121	14.3532	14.4321	97630372.0
2011-10-27 11:00:00	AAPL	Stock	14.4318	14.4689	14.3821	14.4646	48426980.0
2011-10-27 12:00:00	AAPL	Stock	14.4678	14.5089	14.4589	14.4686	43214948.0
2011-10-27 13:00:00	AAPL	Stock	14.4714	14.5579	14.4682	14.5504	50564948.0
2011-10-27 14:00:00	AAPL	Stock	14.5504	14.5657	14.4821	14.4944	54824336.0
2011-10-27 15:00:00	AAPL	Stock	14.4937	14.5375	14.4179	14.4457	84918932.0
2011-10-27 16:00:00	AAPL	Stock	14.4422	14.5636	14.4336	14.4696	23224992.0
2011-10-27 17:00:00	AAPL	Stock	14.4707	14.4707	14.4214	14.4339	1032724.0
2011-10-27 18:00:00	AAPL	Stock	14.4289	14.4532	14.4286	14.4418	171640.0
2011-10-27 19:00:00	AAPL	Stock	14.4461	14.4768	14.4425	14.4643	175896.0
2011-10-27 04:00:00	MSFT	Stock	26.64	26.85	26.64	26.85	8900.0
2011-10-27 05:00:00	MSFT	Stock	26.87	26.99	26.87	26.98	3201.0
2011-10-27 06:00:00	MSFT	Stock	26.98	27.14	26.98	27.14	1500.0
2011-10-27 07:00:00	MSFT	Stock	27.05	27.07	27.0	27.05	25706.0
2011-10-27 08:00:00	MSFT	Stock	27.03	27.1	26.96	27.04	101973.0
2011-10-27 09:00:00	MSFT	Stock	27.03	27.19	26.65	27.02	12658667.0
2011-10-27 10:00:00	MSFT	Stock	27.02	27.05	26.81	27.035	7829322.0
2011-10-27 11:00:00	MSFT	Stock	27.035	27.07	26.91	26.991	5476550.0
2011-10-27 12:00:00	MSFT	Stock	26.995	27.15	26.995	27.08	4730076.0
2011-10-27 13:00:00	MSFT	Stock	27.075	27.31	27.07	27.3	6308348.0
2011-10-27 14:00:00	MSFT	Stock	27.3	27.39	27.28	27.32	10974617.0
2011-10-27 15:00:00	MSFT	Stock	27.322	27.4	27.12	27.26	18372954.0
2011-10-27 16:00:00	MSFT	Stock	27.25	27.386	26.59	27.18	4517854.0
2011-10-27 17:00:00	MSFT	Stock	27.18	27.25	27.16	27.17	31770.0
2011-10-27 18:00:00	MSFT	Stock	27.15	27.25	27.15	27.18	74305.0
2011-10-27 19:00:00	MSFT	Stock	27.17	27.17	27.17	27.17	1000.0
2011-10-27 06:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	6000.0
2011-10-27 07:00:00	NVDA	Stock	0.3775	0.3775	0.3753	0.3775	60000.0
2011-10-27 08:00:00	NVDA	Stock	0.375	0.3803	0.375	0.3803	652400.0
2011-10-27 09:00:00	NVDA	Stock	0.3803	0.3808	0.372	0.3733	74498680.0
2011-10-27 10:00:00	NVDA	Stock	0.373	0.3769	0.3705	0.3769	78845200.0
2011-10-27 11:00:00	NVDA	Stock	0.377	0.377	0.3715	0.375	69232080.0
2011-10-27 12:00:00	NVDA	Stock	0.375	0.378	0.375	0.3761	50573880.0
2011-10-27 13:00:00	NVDA	Stock	0.3763	0.3822	0.376	0.3821	46630400.0
2011-10-27 14:00:00	NVDA	Stock	0.3822	0.3831	0.3798	0.3808	75160520.0
2011-10-27 15:00:00	NVDA	Stock	0.3805	0.385	0.378	0.3813	144475320.0
2011-10-27 16:00:00	NVDA	Stock	0.3813	0.3838	0.3655	0.3822	30382880.0
2011-10-27 17:00:00	NVDA	Stock	0.3818	0.3825	0.3813	0.3813	134880.0
2011-10-27 18:00:00	NVDA	Stock	0.3813	0.3813	0.3813	0.3813	261640.0
2011-10-27 19:00:00	NVDA	Stock	0.383	0.3848	0.382	0.3842	176240.0
2011-10-27 04:00:00	AMZN	Stock	9.993	10.149	9.993	10.149	57080.0
2011-10-27 05:00:00	AMZN	Stock	10.1035	10.149	10.09	10.1255	42000.0
2011-10-27 06:00:00	AMZN	Stock	10.101	10.149	10.101	10.145	22000.0
2011-10-27 07:00:00	AMZN	Stock	10.145	10.1485	10.07	10.0995	909520.0

> showing 50 of 47,411 rows — these rows as CSV

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