PREVIEW / stock_1hour / 2012-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-05-10.parquet
  size:    945 KB
  rows:    45,205
  symbols: 3,524

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
2012-05-10 04:00:00	AAPL	Stock	20.3571	20.3571	20.2821	20.2893	104244.0
2012-05-10 05:00:00	AAPL	Stock	20.2771	20.2771	20.2643	20.2643	36428.0
2012-05-10 06:00:00	AAPL	Stock	20.2643	20.3725	20.2643	20.3725	77252.0
2012-05-10 07:00:00	AAPL	Stock	20.3739	20.5357	20.3739	20.4964	523964.0
2012-05-10 08:00:00	AAPL	Stock	20.4911	20.5318	20.4186	20.5054	3047212.0
2012-05-10 09:00:00	AAPL	Stock	20.5039	20.5671	20.4232	20.4957	70472612.0
2012-05-10 10:00:00	AAPL	Stock	20.4961	20.5321	20.3846	20.4442	67856236.0
2012-05-10 11:00:00	AAPL	Stock	20.4396	20.4804	20.4111	20.445	31724896.0
2012-05-10 12:00:00	AAPL	Stock	20.4454	20.4992	20.3964	20.4968	34953128.0
2012-05-10 13:00:00	AAPL	Stock	20.4959	20.5096	20.4196	20.4411	28603652.0
2012-05-10 14:00:00	AAPL	Stock	20.4407	20.4643	20.4029	20.4089	22041684.0
2012-05-10 15:00:00	AAPL	Stock	20.4089	20.4389	20.3015	20.3743	56667268.0
2012-05-10 16:00:00	AAPL	Stock	20.3757	20.4606	20.3436	20.3571	13150928.0
2012-05-10 17:00:00	AAPL	Stock	20.3279	20.3486	20.25	20.2679	947044.0
2012-05-10 18:00:00	AAPL	Stock	20.2582	20.2821	20.2411	20.2679	454440.0
2012-05-10 19:00:00	AAPL	Stock	20.2704	20.2714	20.2357	20.2536	325892.0
2012-05-10 07:00:00	MSFT	Stock	30.74	30.97	30.74	30.97	1850.0
2012-05-10 08:00:00	MSFT	Stock	30.7	30.9	30.7	30.85	16839.0
2012-05-10 09:00:00	MSFT	Stock	30.85	31.02	30.63	30.71	6982677.0
2012-05-10 10:00:00	MSFT	Stock	30.706	30.8	30.47	30.63	7230774.0
2012-05-10 11:00:00	MSFT	Stock	30.62	30.71	30.5	30.53	4217884.0
2012-05-10 12:00:00	MSFT	Stock	30.53	30.695	30.45	30.695	3816208.0
2012-05-10 13:00:00	MSFT	Stock	30.7	30.77	30.59	30.59	3560586.0
2012-05-10 14:00:00	MSFT	Stock	30.595	30.84	30.59	30.82	6595104.0
2012-05-10 15:00:00	MSFT	Stock	30.812	30.85	30.67	30.74	8185863.0
2012-05-10 16:00:00	MSFT	Stock	30.74	30.85	30.63	30.71	1841740.0
2012-05-10 17:00:00	MSFT	Stock	30.76	30.76	30.61	30.62	9351.0
2012-05-10 18:00:00	MSFT	Stock	30.62	30.62	30.46	30.47	3660.0
2012-05-10 19:00:00	MSFT	Stock	30.48	30.61	30.46	30.58	4429.0
2012-05-10 08:00:00	NVDA	Stock	0.3163	0.3295	0.316	0.317	685800.0
2012-05-10 09:00:00	NVDA	Stock	0.3185	0.3185	0.3068	0.3093	58076840.0
2012-05-10 10:00:00	NVDA	Stock	0.3093	0.31	0.3055	0.3078	86974560.0
2012-05-10 11:00:00	NVDA	Stock	0.3078	0.3083	0.3062	0.3066	52705760.0
2012-05-10 12:00:00	NVDA	Stock	0.3065	0.3118	0.3058	0.3105	91345320.0
2012-05-10 13:00:00	NVDA	Stock	0.3108	0.3125	0.3105	0.3114	51390360.0
2012-05-10 14:00:00	NVDA	Stock	0.3113	0.3125	0.3093	0.3094	55232920.0
2012-05-10 15:00:00	NVDA	Stock	0.3094	0.3108	0.3078	0.3103	189048440.0
2012-05-10 16:00:00	NVDA	Stock	0.3105	0.3133	0.307	0.3123	8638520.0
2012-05-10 17:00:00	NVDA	Stock	0.3113	0.3113	0.3088	0.3088	63000.0
2012-05-10 18:00:00	NVDA	Stock	0.309	0.3123	0.3062	0.3123	439800.0
2012-05-10 19:00:00	NVDA	Stock	0.31	0.31	0.3062	0.3088	152200.0
2012-05-10 07:00:00	AMZN	Stock	11.17	11.17	11.1675	11.1675	4000.0
2012-05-10 08:00:00	AMZN	Stock	11.1665	11.2485	11.12	11.233	465420.0
2012-05-10 09:00:00	AMZN	Stock	11.233	11.295	11.1955	11.218	10888760.0
2012-05-10 10:00:00	AMZN	Stock	11.2158	11.2275	11.0975	11.1175	11889940.0
2012-05-10 11:00:00	AMZN	Stock	11.1185	11.224	11.1	11.2195	10952520.0
2012-05-10 12:00:00	AMZN	Stock	11.219	11.377	11.194	11.347	14271200.0
2012-05-10 13:00:00	AMZN	Stock	11.348	11.454	11.345	11.397	17140100.0
2012-05-10 14:00:00	AMZN	Stock	11.397	11.4342	11.355	11.3685	9026900.0
2012-05-10 15:00:00	AMZN	Stock	11.366	11.3835	11.305	11.3425	13910900.0

> showing 50 of 45,205 rows — these rows as CSV

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