PREVIEW / stock_1hour / 2011-07-22

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-07-22.parquet
  size:    935 KB
  rows:    44,470
  symbols: 3,530

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-07-22 04:00:00	AAPL	Stock	13.9032	13.9129	13.9029	13.9129	30800.0
2011-07-22 06:00:00	AAPL	Stock	13.9218	13.9218	13.9018	13.9018	19600.0
2011-07-22 07:00:00	AAPL	Stock	13.9204	13.9286	13.8586	13.8661	406336.0
2011-07-22 08:00:00	AAPL	Stock	13.8746	13.9236	13.8254	13.8514	1185716.0
2011-07-22 09:00:00	AAPL	Stock	13.8461	13.9286	13.8214	13.8962	61657932.0
2011-07-22 10:00:00	AAPL	Stock	13.8957	13.9621	13.8861	13.942	84152796.0
2011-07-22 11:00:00	AAPL	Stock	13.9436	13.9493	13.925	13.9432	37283260.0
2011-07-22 12:00:00	AAPL	Stock	13.9432	13.9864	13.9357	13.9829	47389160.0
2011-07-22 13:00:00	AAPL	Stock	13.9831	14.0532	13.965	14.0514	68165328.0
2011-07-22 14:00:00	AAPL	Stock	14.0504	14.1089	14.0268	14.0843	100858408.0
2011-07-22 15:00:00	AAPL	Stock	14.0843	14.0868	14.0204	14.0464	100962344.0
2011-07-22 16:00:00	AAPL	Stock	14.0459	14.0492	13.9924	14.0414	5180140.0
2011-07-22 17:00:00	AAPL	Stock	14.0421	14.0461	14.0411	14.0461	291340.0
2011-07-22 18:00:00	AAPL	Stock	14.0368	14.0464	13.9571	13.9668	1415036.0
2011-07-22 19:00:00	AAPL	Stock	13.9629	13.9911	13.9496	13.9836	634032.0
2011-07-22 04:00:00	MSFT	Stock	27.5	27.5	26.93	27.05	2100.0
2011-07-22 05:00:00	MSFT	Stock	27.05	27.05	27.05	27.05	100.0
2011-07-22 06:00:00	MSFT	Stock	26.98	27.01	26.86	26.86	16000.0
2011-07-22 07:00:00	MSFT	Stock	26.82	26.9	26.72	26.77	322547.0
2011-07-22 08:00:00	MSFT	Stock	26.79	27.095	26.77	26.87	306057.0
2011-07-22 09:00:00	MSFT	Stock	26.86	27.33	26.68	27.13	17330576.0
2011-07-22 10:00:00	MSFT	Stock	27.125	27.14	26.85	27.11	12640667.0
2011-07-22 11:00:00	MSFT	Stock	27.105	27.15	27.04	27.13	5846545.0
2011-07-22 12:00:00	MSFT	Stock	27.125	27.24	27.09	27.222	6006472.0
2011-07-22 13:00:00	MSFT	Stock	27.23	27.37	27.22	27.349	7101289.0
2011-07-22 14:00:00	MSFT	Stock	27.34	27.49	27.33	27.49	8044031.0
2011-07-22 15:00:00	MSFT	Stock	27.485	27.55	27.42	27.525	16263508.0
2011-07-22 16:00:00	MSFT	Stock	27.525	27.54	27.209	27.5	1748635.0
2011-07-22 17:00:00	MSFT	Stock	27.5	27.51	27.46	27.46	5447.0
2011-07-22 18:00:00	MSFT	Stock	27.48	27.53	27.33	27.33	62504.0
2011-07-22 19:00:00	MSFT	Stock	27.32	27.37	27.27	27.35	18020.0
2011-07-22 06:00:00	NVDA	Stock	0.3678	0.3678	0.3625	0.3625	12000.0
2011-07-22 07:00:00	NVDA	Stock	0.3688	0.3688	0.3688	0.3688	4000.0
2011-07-22 08:00:00	NVDA	Stock	0.3725	0.3725	0.3675	0.3713	677360.0
2011-07-22 09:00:00	NVDA	Stock	0.3705	0.3763	0.369	0.3703	145602680.0
2011-07-22 10:00:00	NVDA	Stock	0.3703	0.372	0.368	0.3713	132504920.0
2011-07-22 11:00:00	NVDA	Stock	0.3711	0.3718	0.366	0.369	103938880.0
2011-07-22 12:00:00	NVDA	Stock	0.369	0.3738	0.369	0.3733	59515360.0
2011-07-22 13:00:00	NVDA	Stock	0.3733	0.375	0.373	0.3748	63224160.0
2011-07-22 14:00:00	NVDA	Stock	0.3745	0.3755	0.373	0.375	66710200.0
2011-07-22 15:00:00	NVDA	Stock	0.3753	0.3755	0.3738	0.375	146048520.0
2011-07-22 16:00:00	NVDA	Stock	0.375	0.3763	0.3692	0.3745	10050200.0
2011-07-22 17:00:00	NVDA	Stock	0.3678	0.3755	0.3678	0.3755	284720.0
2011-07-22 18:00:00	NVDA	Stock	0.3738	0.3738	0.3735	0.3735	253040.0
2011-07-22 19:00:00	NVDA	Stock	0.3735	0.3738	0.3725	0.3735	165840.0
2011-07-22 07:00:00	AMZN	Stock	10.7475	10.7495	10.692	10.692	14000.0
2011-07-22 08:00:00	AMZN	Stock	10.6975	10.7245	10.6605	10.671	24160.0
2011-07-22 09:00:00	AMZN	Stock	10.689	10.7	10.5615	10.5675	9666320.0
2011-07-22 10:00:00	AMZN	Stock	10.567	10.639	10.5555	10.6355	10097060.0
2011-07-22 11:00:00	AMZN	Stock	10.635	10.684	10.604	10.6669	6884400.0

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

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