PREVIEW / stock_1hour / 2011-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-09.parquet
  size:    926 KB
  rows:    44,174
  symbols: 3,550

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-06-09 04:00:00	AAPL	Stock	11.9054	11.9125	11.9054	11.91	14000.0
2011-06-09 06:00:00	AAPL	Stock	11.9054	11.9054	11.9054	11.9054	5600.0
2011-06-09 07:00:00	AAPL	Stock	11.8929	11.8929	11.8896	11.8929	30800.0
2011-06-09 08:00:00	AAPL	Stock	11.8911	11.9054	11.8571	11.8825	1356488.0
2011-06-09 09:00:00	AAPL	Stock	11.8893	11.9025	11.8125	11.8774	53284056.0
2011-06-09 10:00:00	AAPL	Stock	11.8779	11.8779	11.8143	11.8568	58449468.0
2011-06-09 11:00:00	AAPL	Stock	11.8561	11.8954	11.8286	11.8348	35584724.0
2011-06-09 12:00:00	AAPL	Stock	11.8339	11.8839	11.8307	11.8654	23151940.0
2011-06-09 13:00:00	AAPL	Stock	11.8639	11.8782	11.8475	11.8481	16513140.0
2011-06-09 14:00:00	AAPL	Stock	11.8482	11.8782	11.8464	11.8746	19232332.0
2011-06-09 15:00:00	AAPL	Stock	11.875	11.9168	11.8393	11.8393	54878684.0
2011-06-09 16:00:00	AAPL	Stock	11.8396	11.8863	11.8268	11.8332	10851624.0
2011-06-09 17:00:00	AAPL	Stock	11.8329	11.8332	11.8304	11.8329	34860.0
2011-06-09 18:00:00	AAPL	Stock	11.8332	11.8389	11.8271	11.8304	134540.0
2011-06-09 19:00:00	AAPL	Stock	11.8339	11.8375	11.8271	11.8271	268772.0
2011-06-09 07:00:00	MSFT	Stock	24.02	24.02	24.02	24.02	300.0
2011-06-09 08:00:00	MSFT	Stock	24.04	24.07	24.01	24.02	29375.0
2011-06-09 09:00:00	MSFT	Stock	24.01	24.03	23.82	23.9	5234749.0
2011-06-09 10:00:00	MSFT	Stock	23.9	23.95	23.84	23.892	6188667.0
2011-06-09 11:00:00	MSFT	Stock	23.9	23.98	23.87	23.97	4609806.0
2011-06-09 12:00:00	MSFT	Stock	23.972	24.0	23.94	23.955	2109421.0
2011-06-09 13:00:00	MSFT	Stock	23.955	23.99	23.92	23.94	2913896.0
2011-06-09 14:00:00	MSFT	Stock	23.93	24.0	23.92	24.0	2720422.0
2011-06-09 15:00:00	MSFT	Stock	24.0	24.04	23.94	23.94	14931680.0
2011-06-09 16:00:00	MSFT	Stock	23.94	23.982	23.89	23.982	3687844.0
2011-06-09 17:00:00	MSFT	Stock	23.96	23.96	23.93	23.93	3668.0
2011-06-09 18:00:00	MSFT	Stock	23.93	23.96	23.93	23.96	8152.0
2011-06-09 19:00:00	MSFT	Stock	23.91	23.94	23.9	23.9	3565.0
2011-06-09 08:00:00	NVDA	Stock	0.4432	0.4452	0.4405	0.4425	214000.0
2011-06-09 09:00:00	NVDA	Stock	0.4422	0.4432	0.4185	0.4278	223921320.0
2011-06-09 10:00:00	NVDA	Stock	0.4278	0.437	0.4275	0.4327	180920360.0
2011-06-09 11:00:00	NVDA	Stock	0.4328	0.4338	0.4293	0.431	82182840.0
2011-06-09 12:00:00	NVDA	Stock	0.4308	0.4332	0.4302	0.4328	43195920.0
2011-06-09 13:00:00	NVDA	Stock	0.4328	0.4362	0.4325	0.436	43670040.0
2011-06-09 14:00:00	NVDA	Stock	0.4358	0.4372	0.4345	0.4372	46562160.0
2011-06-09 15:00:00	NVDA	Stock	0.437	0.4375	0.434	0.4342	91761240.0
2011-06-09 16:00:00	NVDA	Stock	0.4342	0.4357	0.4309	0.4357	2804200.0
2011-06-09 17:00:00	NVDA	Stock	0.4342	0.4355	0.433	0.433	174800.0
2011-06-09 18:00:00	NVDA	Stock	0.4338	0.4355	0.4338	0.4355	159400.0
2011-06-09 19:00:00	NVDA	Stock	0.4352	0.4352	0.4352	0.4352	4000.0
2011-06-09 04:00:00	AMZN	Stock	9.4075	9.4075	9.4075	9.4075	2000.0
2011-06-09 08:00:00	AMZN	Stock	9.415	9.499	9.4	9.4275	165780.0
2011-06-09 09:00:00	AMZN	Stock	9.4275	9.5015	9.29	9.3193	13509080.0
2011-06-09 10:00:00	AMZN	Stock	9.3265	9.4975	9.2855	9.4203	21555460.0
2011-06-09 11:00:00	AMZN	Stock	9.4205	9.4795	9.404	9.4485	7307220.0
2011-06-09 12:00:00	AMZN	Stock	9.449	9.5105	9.4355	9.4902	6418660.0
2011-06-09 13:00:00	AMZN	Stock	9.493	9.4995	9.469	9.4868	3673000.0
2011-06-09 14:00:00	AMZN	Stock	9.4874	9.5083	9.4725	9.4999	4193500.0
2011-06-09 15:00:00	AMZN	Stock	9.502	9.588	9.48	9.48	22498080.0
2011-06-09 16:00:00	AMZN	Stock	9.48	9.5365	9.4025	9.4835	4078620.0

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

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