PREVIEW / stock_1hour / 2010-09-27

all stock 1-hour files

  file:    by_date/stock_1hour/2010/2010-09-27.parquet
  size:    908 KB
  rows:    43,318
  symbols: 3,490

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-09-27 04:00:00	AAPL	Stock	10.4679	10.4679	10.4679	10.4679	2800.0
2010-09-27 05:00:00	AAPL	Stock	10.4757	10.4982	10.4757	10.4911	14000.0
2010-09-27 06:00:00	AAPL	Stock	10.4911	10.4911	10.4643	10.4643	30800.0
2010-09-27 07:00:00	AAPL	Stock	10.4761	10.4836	10.4643	10.4757	422380.0
2010-09-27 08:00:00	AAPL	Stock	10.4786	10.5346	10.4657	10.5289	5283208.0
2010-09-27 09:00:00	AAPL	Stock	10.5289	10.5321	10.4561	10.4764	98049448.0
2010-09-27 10:00:00	AAPL	Stock	10.4761	10.525	10.4325	10.475	95103400.0
2010-09-27 11:00:00	AAPL	Stock	10.4746	10.475	10.4436	10.4557	46901260.0
2010-09-27 12:00:00	AAPL	Stock	10.455	10.475	10.4464	10.4729	29106896.0
2010-09-27 13:00:00	AAPL	Stock	10.4732	10.505	10.4686	10.4929	43752016.0
2010-09-27 14:00:00	AAPL	Stock	10.4929	10.5075	10.475	10.4907	42887432.0
2010-09-27 15:00:00	AAPL	Stock	10.4908	10.4939	10.3932	10.3936	94654588.0
2010-09-27 16:00:00	AAPL	Stock	10.3943	10.4915	10.3714	10.3821	16713284.0
2010-09-27 17:00:00	AAPL	Stock	10.3807	10.4125	10.3807	10.4036	1660680.0
2010-09-27 18:00:00	AAPL	Stock	10.4036	10.4089	10.3986	10.4079	200900.0
2010-09-27 19:00:00	AAPL	Stock	10.4004	10.4064	10.3929	10.3946	263144.0
2010-09-27 20:00:00	AAPL	Stock	10.4561	10.4561	10.4561	10.4561	11200.0
2010-09-27 04:00:00	MSFT	Stock	24.8	24.8	24.8	24.8	200.0
2010-09-27 07:00:00	MSFT	Stock	24.9	24.91	24.79	24.83	14180.0
2010-09-27 08:00:00	MSFT	Stock	24.79	24.86	24.79	24.83	38799.0
2010-09-27 09:00:00	MSFT	Stock	24.83	24.87	24.73	24.795	2611443.0
2010-09-27 10:00:00	MSFT	Stock	24.8	24.8	24.65	24.69	5390790.0
2010-09-27 11:00:00	MSFT	Stock	24.69	24.72	24.59	24.7	5243203.0
2010-09-27 12:00:00	MSFT	Stock	24.71	24.78	24.7	24.72	4010852.0
2010-09-27 13:00:00	MSFT	Stock	24.715	24.87	24.69	24.86	4399599.0
2010-09-27 14:00:00	MSFT	Stock	24.86	24.99	24.85	24.915	7020948.0
2010-09-27 15:00:00	MSFT	Stock	24.91	24.94	24.7	24.72	9860652.0
2010-09-27 16:00:00	MSFT	Stock	24.718	24.918	24.698	24.74	3778567.0
2010-09-27 17:00:00	MSFT	Stock	24.78	24.78	24.696	24.76	78900.0
2010-09-27 18:00:00	MSFT	Stock	24.8	24.8	24.72	24.72	38468.0
2010-09-27 19:00:00	MSFT	Stock	24.72	24.74	24.71	24.71	6687.0
2010-09-27 07:00:00	NVDA	Stock	0.3073	0.3073	0.3062	0.3073	122000.0
2010-09-27 08:00:00	NVDA	Stock	0.3073	0.3115	0.3073	0.3115	2202080.0
2010-09-27 09:00:00	NVDA	Stock	0.3115	0.3115	0.296	0.2975	164455360.0
2010-09-27 10:00:00	NVDA	Stock	0.2975	0.2995	0.2966	0.298	159024960.0
2010-09-27 11:00:00	NVDA	Stock	0.298	0.2988	0.297	0.2978	95209560.0
2010-09-27 12:00:00	NVDA	Stock	0.2976	0.2982	0.2968	0.2978	59468240.0
2010-09-27 13:00:00	NVDA	Stock	0.2978	0.2998	0.297	0.2996	128799400.0
2010-09-27 14:00:00	NVDA	Stock	0.2998	0.3035	0.2992	0.3015	167949280.0
2010-09-27 15:00:00	NVDA	Stock	0.3015	0.303	0.2988	0.3	202448320.0
2010-09-27 16:00:00	NVDA	Stock	0.3	0.3025	0.299	0.3018	11989440.0
2010-09-27 17:00:00	NVDA	Stock	0.307	0.307	0.2975	0.2975	668800.0
2010-09-27 18:00:00	NVDA	Stock	0.2988	0.2988	0.2972	0.2972	36000.0
2010-09-27 19:00:00	NVDA	Stock	0.2975	0.2975	0.2972	0.2972	39000.0
2010-09-27 04:00:00	AMZN	Stock	8.0085	8.0085	8.0085	8.0085	2000.0
2010-09-27 05:00:00	AMZN	Stock	8.01	8.01	8.0085	8.0085	4000.0
2010-09-27 07:00:00	AMZN	Stock	8.06	8.15	8.02	8.02	235800.0
2010-09-27 08:00:00	AMZN	Stock	8.0495	8.0625	8.02	8.045	334520.0
2010-09-27 09:00:00	AMZN	Stock	8.043	8.045	7.894	7.9115	26954220.0
2010-09-27 10:00:00	AMZN	Stock	7.911	8.0155	7.9075	8.01	25489980.0

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

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