PREVIEW / stock_1hour / 2011-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-02-16.parquet
  size:    944 KB
  rows:    44,783
  symbols: 3,560

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-02-16 05:00:00	AAPL	Stock	12.8736	12.8768	12.8621	12.8704	30800.0
2011-02-16 06:00:00	AAPL	Stock	12.8471	12.8554	12.8471	12.855	11200.0
2011-02-16 07:00:00	AAPL	Stock	12.8571	12.9018	12.8554	12.8986	482328.0
2011-02-16 08:00:00	AAPL	Stock	12.8986	12.9136	12.8825	12.8982	2981356.0
2011-02-16 09:00:00	AAPL	Stock	12.8993	12.9282	12.875	12.9146	59368540.0
2011-02-16 10:00:00	AAPL	Stock	12.9146	13.0079	12.9	13.0071	109396000.0
2011-02-16 11:00:00	AAPL	Stock	13.0064	13.0321	12.9768	12.9896	81674376.0
2011-02-16 12:00:00	AAPL	Stock	12.9909	12.9918	12.9079	12.975	93321172.0
2011-02-16 13:00:00	AAPL	Stock	12.975	12.9868	12.9591	12.9868	26568780.0
2011-02-16 14:00:00	AAPL	Stock	12.9861	12.9897	12.9525	12.9668	31634484.0
2011-02-16 15:00:00	AAPL	Stock	12.967	12.9821	12.9604	12.9664	52845996.0
2011-02-16 16:00:00	AAPL	Stock	12.9689	12.9785	12.9575	12.96	7310912.0
2011-02-16 17:00:00	AAPL	Stock	12.9604	12.9657	12.8375	12.875	1826440.0
2011-02-16 18:00:00	AAPL	Stock	12.8804	12.9689	12.8571	12.8607	2354520.0
2011-02-16 19:00:00	AAPL	Stock	12.8582	12.875	12.8489	12.8607	2001300.0
2011-02-16 07:00:00	MSFT	Stock	27.0	27.03	27.0	27.03	2300.0
2011-02-16 08:00:00	MSFT	Stock	27.07	27.12	27.05	27.06	33435.0
2011-02-16 09:00:00	MSFT	Stock	27.05	27.07	26.86	26.98	4884980.0
2011-02-16 10:00:00	MSFT	Stock	26.98	27.05	26.85	26.91	10179206.0
2011-02-16 11:00:00	MSFT	Stock	26.91	26.91	26.71	26.742	13524711.0
2011-02-16 12:00:00	MSFT	Stock	26.75	26.75	26.6	26.695	10191963.0
2011-02-16 13:00:00	MSFT	Stock	26.695	26.94	26.62	26.895	11982809.0
2011-02-16 14:00:00	MSFT	Stock	26.9	27.0	26.83	26.958	8248948.0
2011-02-16 15:00:00	MSFT	Stock	26.955	27.025	26.93	27.01	9254600.0
2011-02-16 16:00:00	MSFT	Stock	27.01	27.023	26.847	26.95	1499228.0
2011-02-16 17:00:00	MSFT	Stock	26.98	27.02	26.96	26.98	11159.0
2011-02-16 18:00:00	MSFT	Stock	27.02	27.02	27.0	27.01	12499.0
2011-02-16 19:00:00	MSFT	Stock	27.01	27.01	26.99	26.99	2230.0
2011-02-16 07:00:00	NVDA	Stock	0.5712	0.5712	0.57	0.5712	66000.0
2011-02-16 08:00:00	NVDA	Stock	0.571	0.5863	0.57	0.5725	3055240.0
2011-02-16 09:00:00	NVDA	Stock	0.5725	0.5875	0.5688	0.5819	201425800.0
2011-02-16 10:00:00	NVDA	Stock	0.5818	0.5928	0.5815	0.5859	232632080.0
2011-02-16 11:00:00	NVDA	Stock	0.5858	0.586	0.5805	0.584	128388960.0
2011-02-16 12:00:00	NVDA	Stock	0.584	0.5841	0.5781	0.583	91085640.0
2011-02-16 13:00:00	NVDA	Stock	0.5832	0.5832	0.5775	0.5787	69231920.0
2011-02-16 14:00:00	NVDA	Stock	0.5788	0.5898	0.5775	0.5865	177543120.0
2011-02-16 15:00:00	NVDA	Stock	0.5867	0.5875	0.5838	0.5843	215686640.0
2011-02-16 16:00:00	NVDA	Stock	0.5848	0.6113	0.5625	0.575	122370400.0
2011-02-16 17:00:00	NVDA	Stock	0.575	0.585	0.5562	0.5798	48227080.0
2011-02-16 18:00:00	NVDA	Stock	0.58	0.5845	0.565	0.5818	16478760.0
2011-02-16 19:00:00	NVDA	Stock	0.5818	0.5838	0.5775	0.5832	4963920.0
2011-02-16 04:00:00	AMZN	Stock	9.4945	9.4945	9.4945	9.4945	2000.0
2011-02-16 06:00:00	AMZN	Stock	9.5	9.5	9.5	9.5	2000.0
2011-02-16 07:00:00	AMZN	Stock	9.5	9.5	9.492	9.492	4000.0
2011-02-16 08:00:00	AMZN	Stock	9.4875	9.505	9.4875	9.4945	207920.0
2011-02-16 09:00:00	AMZN	Stock	9.4905	9.5	9.406	9.4345	13367320.0
2011-02-16 10:00:00	AMZN	Stock	9.432	9.4425	9.4035	9.4222	13614100.0
2011-02-16 11:00:00	AMZN	Stock	9.4235	9.4235	9.3595	9.405	17049760.0
2011-02-16 12:00:00	AMZN	Stock	9.4045	9.4085	9.321	9.349	12419980.0
2011-02-16 13:00:00	AMZN	Stock	9.3475	9.389	9.3291	9.3875	8935980.0

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

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