PREVIEW / stock_1hour / 2011-11-14

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-11-14.parquet
  size:    907 KB
  rows:    43,397
  symbols: 3,507

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-11-14 04:00:00	AAPL	Stock	13.7857	13.7861	13.7857	13.7861	21560.0
2011-11-14 05:00:00	AAPL	Stock	13.7861	13.8643	13.7768	13.8211	60032.0
2011-11-14 06:00:00	AAPL	Stock	13.7982	13.7982	13.7504	13.7504	13748.0
2011-11-14 07:00:00	AAPL	Stock	13.725	13.75	13.6914	13.75	499296.0
2011-11-14 08:00:00	AAPL	Stock	13.7357	13.7757	13.725	13.7354	2075584.0
2011-11-14 09:00:00	AAPL	Stock	13.7321	13.7589	13.6046	13.6775	63410172.0
2011-11-14 10:00:00	AAPL	Stock	13.675	13.7343	13.5768	13.5775	77535976.0
2011-11-14 11:00:00	AAPL	Stock	13.5789	13.6518	13.5466	13.5892	67728276.0
2011-11-14 12:00:00	AAPL	Stock	13.5889	13.5968	13.5179	13.5575	56752220.0
2011-11-14 13:00:00	AAPL	Stock	13.5581	13.6061	13.5329	13.5842	32900588.0
2011-11-14 14:00:00	AAPL	Stock	13.586	13.5946	13.5229	13.525	47253836.0
2011-11-14 15:00:00	AAPL	Stock	13.5264	13.5779	13.5071	13.545	62439188.0
2011-11-14 16:00:00	AAPL	Stock	13.545	13.7364	13.5421	13.5611	15389920.0
2011-11-14 17:00:00	AAPL	Stock	13.5618	13.5636	13.555	13.5586	107240.0
2011-11-14 18:00:00	AAPL	Stock	13.5568	13.5568	13.545	13.5536	167104.0
2011-11-14 19:00:00	AAPL	Stock	13.5589	13.5789	13.5511	13.5786	127960.0
2011-11-14 04:00:00	MSFT	Stock	26.9	26.9	26.9	26.9	100.0
2011-11-14 05:00:00	MSFT	Stock	27.06	27.06	27.06	27.06	100.0
2011-11-14 06:00:00	MSFT	Stock	26.87	26.9	26.76	26.87	1400.0
2011-11-14 07:00:00	MSFT	Stock	26.87	26.92	26.8	26.84	3100.0
2011-11-14 08:00:00	MSFT	Stock	26.85	26.93	26.83	26.91	11482.0
2011-11-14 09:00:00	MSFT	Stock	26.91	26.98	26.77	26.85	3060811.0
2011-11-14 10:00:00	MSFT	Stock	26.84	27.0	26.81	26.915	4478841.0
2011-11-14 11:00:00	MSFT	Stock	26.915	26.99	26.81	26.83	3966866.0
2011-11-14 12:00:00	MSFT	Stock	26.83	26.83	26.66	26.68	3579429.0
2011-11-14 13:00:00	MSFT	Stock	26.68	26.77	26.65	26.76	2855747.0
2011-11-14 14:00:00	MSFT	Stock	26.76	26.8	26.66	26.66	4146647.0
2011-11-14 15:00:00	MSFT	Stock	26.66	26.79	26.65	26.76	6393976.0
2011-11-14 16:00:00	MSFT	Stock	26.76	26.92	26.723	26.78	3520306.0
2011-11-14 17:00:00	MSFT	Stock	26.78	26.79	26.76	26.79	672222.0
2011-11-14 18:00:00	MSFT	Stock	26.76	26.79	26.76	26.77	21600.0
2011-11-14 19:00:00	MSFT	Stock	26.79	26.8	26.78	26.79	10377.0
2011-11-14 06:00:00	NVDA	Stock	0.3713	0.3713	0.3713	0.3713	40000.0
2011-11-14 07:00:00	NVDA	Stock	0.3725	0.3745	0.3725	0.3733	52000.0
2011-11-14 08:00:00	NVDA	Stock	0.3745	0.3745	0.3733	0.3743	176000.0
2011-11-14 09:00:00	NVDA	Stock	0.374	0.3775	0.3713	0.3745	85839160.0
2011-11-14 10:00:00	NVDA	Stock	0.3745	0.3783	0.3703	0.3728	104261080.0
2011-11-14 11:00:00	NVDA	Stock	0.3729	0.3738	0.3695	0.3708	59517320.0
2011-11-14 12:00:00	NVDA	Stock	0.3708	0.3715	0.3675	0.3698	63864320.0
2011-11-14 13:00:00	NVDA	Stock	0.3698	0.3713	0.3683	0.3695	30247200.0
2011-11-14 14:00:00	NVDA	Stock	0.3698	0.3709	0.3662	0.3665	45542920.0
2011-11-14 15:00:00	NVDA	Stock	0.3662	0.3685	0.3662	0.3672	95205120.0
2011-11-14 16:00:00	NVDA	Stock	0.3675	0.3714	0.367	0.3672	13539480.0
2011-11-14 17:00:00	NVDA	Stock	0.3675	0.368	0.3672	0.3672	182400.0
2011-11-14 18:00:00	NVDA	Stock	0.3672	0.3698	0.3672	0.3698	617600.0
2011-11-14 19:00:00	NVDA	Stock	0.3688	0.369	0.3688	0.369	28000.0
2011-11-14 04:00:00	AMZN	Stock	11.0	11.0	10.875	10.875	4000.0
2011-11-14 05:00:00	AMZN	Stock	10.85	10.85	10.85	10.85	2000.0
2011-11-14 07:00:00	AMZN	Stock	10.8	10.872	10.8	10.81	22300.0
2011-11-14 08:00:00	AMZN	Stock	10.8685	10.876	10.81	10.848	251880.0

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

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