PREVIEW / stock_1hour / 2011-05-26

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-26.parquet
  size:    931 KB
  rows:    43,819
  symbols: 3,534

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-05-26 04:00:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	2800.0
2011-05-26 05:00:00	AAPL	Stock	12.0357	12.0357	12.0357	12.0357	8400.0
2011-05-26 06:00:00	AAPL	Stock	12.0607	12.0607	12.0461	12.0461	5600.0
2011-05-26 07:00:00	AAPL	Stock	12.0532	12.0532	12.0357	12.0357	35840.0
2011-05-26 08:00:00	AAPL	Stock	12.0432	12.0571	11.9911	12.0107	1110816.0
2011-05-26 09:00:00	AAPL	Stock	12.0011	12.0318	11.9596	11.9661	46469780.0
2011-05-26 10:00:00	AAPL	Stock	11.964	11.99	11.9507	11.9536	39455248.0
2011-05-26 11:00:00	AAPL	Stock	11.9546	11.9811	11.9441	11.9682	27427148.0
2011-05-26 12:00:00	AAPL	Stock	11.9686	12.01	11.9646	11.9982	26110728.0
2011-05-26 13:00:00	AAPL	Stock	12.0	12.0075	11.9732	11.9821	15569820.0
2011-05-26 14:00:00	AAPL	Stock	11.9821	12.0004	11.9721	11.9879	19575360.0
2011-05-26 15:00:00	AAPL	Stock	11.9875	12.0	11.9586	11.9639	36931608.0
2011-05-26 16:00:00	AAPL	Stock	11.9643	12.02	11.9604	11.9643	5311880.0
2011-05-26 17:00:00	AAPL	Stock	11.9607	11.9629	11.9575	11.9607	77532.0
2011-05-26 18:00:00	AAPL	Stock	11.9643	11.9679	11.9571	11.9632	96656.0
2011-05-26 19:00:00	AAPL	Stock	11.9639	11.9721	11.9639	11.9643	89124.0
2011-05-26 07:00:00	MSFT	Stock	24.36	24.46	24.36	24.41	22262.0
2011-05-26 08:00:00	MSFT	Stock	24.39	24.42	24.27	24.32	61160.0
2011-05-26 09:00:00	MSFT	Stock	24.31	24.75	24.3	24.59	13655614.0
2011-05-26 10:00:00	MSFT	Stock	24.585	24.72	24.53	24.606	13196276.0
2011-05-26 11:00:00	MSFT	Stock	24.61	24.86	24.6	24.73	12958159.0
2011-05-26 12:00:00	MSFT	Stock	24.73	24.84	24.69	24.785	6691948.0
2011-05-26 13:00:00	MSFT	Stock	24.785	24.84	24.75	24.82	6131948.0
2011-05-26 14:00:00	MSFT	Stock	24.82	24.88	24.79	24.819	6360463.0
2011-05-26 15:00:00	MSFT	Stock	24.82	24.83	24.66	24.67	13370146.0
2011-05-26 16:00:00	MSFT	Stock	24.67	24.804	24.66	24.7	2155510.0
2011-05-26 17:00:00	MSFT	Stock	24.7	24.75	24.7	24.75	19165.0
2011-05-26 18:00:00	MSFT	Stock	24.75	24.78	24.67	24.74	45330.0
2011-05-26 19:00:00	MSFT	Stock	24.74	24.74	24.68	24.7	8175.0
2011-05-26 08:00:00	NVDA	Stock	0.459	0.46	0.4588	0.4588	193200.0
2011-05-26 09:00:00	NVDA	Stock	0.4603	0.464	0.4578	0.4593	63305080.0
2011-05-26 10:00:00	NVDA	Stock	0.4593	0.4683	0.4585	0.4628	130709440.0
2011-05-26 11:00:00	NVDA	Stock	0.463	0.4665	0.4625	0.465	61874280.0
2011-05-26 12:00:00	NVDA	Stock	0.4652	0.4683	0.4645	0.4675	53595240.0
2011-05-26 13:00:00	NVDA	Stock	0.4675	0.4715	0.4666	0.4705	113401480.0
2011-05-26 14:00:00	NVDA	Stock	0.4708	0.4725	0.4691	0.4715	99020040.0
2011-05-26 15:00:00	NVDA	Stock	0.4715	0.4745	0.4695	0.4705	162703640.0
2011-05-26 16:00:00	NVDA	Stock	0.4705	0.474	0.4668	0.474	13224800.0
2011-05-26 17:00:00	NVDA	Stock	0.4705	0.4732	0.4688	0.4732	120000.0
2011-05-26 18:00:00	NVDA	Stock	0.473	0.4732	0.4715	0.4718	56000.0
2011-05-26 19:00:00	NVDA	Stock	0.4725	0.4732	0.4705	0.4708	65600.0
2011-05-26 08:00:00	AMZN	Stock	9.6395	9.6395	9.59	9.5995	35800.0
2011-05-26 09:00:00	AMZN	Stock	9.6	9.672	9.544	9.624	14472020.0
2011-05-26 10:00:00	AMZN	Stock	9.629	9.7415	9.62	9.6445	20687680.0
2011-05-26 11:00:00	AMZN	Stock	9.6465	9.75	9.6438	9.73	8960500.0
2011-05-26 12:00:00	AMZN	Stock	9.7335	9.772	9.7205	9.768	5647000.0
2011-05-26 13:00:00	AMZN	Stock	9.7705	9.7775	9.734	9.7385	6158480.0
2011-05-26 14:00:00	AMZN	Stock	9.7385	9.8225	9.737	9.817	9144660.0
2011-05-26 15:00:00	AMZN	Stock	9.815	9.8171	9.7425	9.75	13802040.0
2011-05-26 16:00:00	AMZN	Stock	9.75	9.7936	9.7144	9.7575	1864960.0

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

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