PREVIEW / stock_1hour / 2011-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-09-20.parquet
  size:    934 KB
  rows:    45,234
  symbols: 3,518

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-09-20 04:00:00	AAPL	Stock	14.6429	14.8018	14.6429	14.7496	70000.0
2011-09-20 05:00:00	AAPL	Stock	14.7796	14.8679	14.7796	14.8661	176260.0
2011-09-20 06:00:00	AAPL	Stock	14.8661	14.8929	14.8589	14.8589	75880.0
2011-09-20 07:00:00	AAPL	Stock	14.8443	14.8879	14.8146	14.8336	1364244.0
2011-09-20 08:00:00	AAPL	Stock	14.8289	14.8571	14.8193	14.8321	4738328.0
2011-09-20 09:00:00	AAPL	Stock	14.8321	14.9357	14.7904	14.8986	126027076.0
2011-09-20 10:00:00	AAPL	Stock	14.8968	15.0714	14.8554	15.0207	152190108.0
2011-09-20 11:00:00	AAPL	Stock	15.0207	15.1021	14.9743	15.0957	90778408.0
2011-09-20 12:00:00	AAPL	Stock	15.0989	15.1021	15.0286	15.0557	57195292.0
2011-09-20 13:00:00	AAPL	Stock	15.0557	15.0646	14.98	15.0211	43787744.0
2011-09-20 14:00:00	AAPL	Stock	15.02	15.0518	14.8804	14.9186	84312536.0
2011-09-20 15:00:00	AAPL	Stock	14.9189	14.9441	14.6854	14.7664	191033444.0
2011-09-20 16:00:00	AAPL	Stock	14.75	15.0188	14.7011	14.8207	9397080.0
2011-09-20 17:00:00	AAPL	Stock	14.8211	14.8318	14.7661	14.7964	1319192.0
2011-09-20 18:00:00	AAPL	Stock	14.7946	14.8018	14.7661	14.7857	460628.0
2011-09-20 19:00:00	AAPL	Stock	14.7857	14.8214	14.7857	14.8211	313600.0
2011-09-20 05:00:00	MSFT	Stock	27.2	27.2	27.2	27.2	200.0
2011-09-20 06:00:00	MSFT	Stock	27.31	27.31	27.31	27.31	500.0
2011-09-20 07:00:00	MSFT	Stock	27.27	27.3	27.27	27.3	2600.0
2011-09-20 08:00:00	MSFT	Stock	27.27	27.35	27.26	27.35	13700.0
2011-09-20 09:00:00	MSFT	Stock	27.32	27.36	27.02	27.22	5968225.0
2011-09-20 10:00:00	MSFT	Stock	27.211	27.47	27.16	27.47	7253194.0
2011-09-20 11:00:00	MSFT	Stock	27.461	27.5	27.38	27.48	5507808.0
2011-09-20 12:00:00	MSFT	Stock	27.48	27.48	27.26	27.333	4126319.0
2011-09-20 13:00:00	MSFT	Stock	27.33	27.36	27.16	27.22	5428037.0
2011-09-20 14:00:00	MSFT	Stock	27.216	27.32	27.12	27.17	5717878.0
2011-09-20 15:00:00	MSFT	Stock	27.17	27.21	26.93	26.97	12009276.0
2011-09-20 16:00:00	MSFT	Stock	26.96	27.271	26.96	27.269	2520424.0
2011-09-20 17:00:00	MSFT	Stock	27.04	27.29	26.98	26.98	179285.0
2011-09-20 18:00:00	MSFT	Stock	27.13	27.37	26.98	27.1	159997.0
2011-09-20 19:00:00	MSFT	Stock	27.1	27.18	27.1	27.15	8149.0
2011-09-20 04:00:00	NVDA	Stock	0.3818	0.3853	0.3818	0.383	60000.0
2011-09-20 05:00:00	NVDA	Stock	0.383	0.383	0.383	0.383	4000.0
2011-09-20 07:00:00	NVDA	Stock	0.3773	0.3825	0.375	0.3825	120000.0
2011-09-20 08:00:00	NVDA	Stock	0.3785	0.384	0.3785	0.3835	1438400.0
2011-09-20 09:00:00	NVDA	Stock	0.3838	0.3848	0.3715	0.3788	104243640.0
2011-09-20 10:00:00	NVDA	Stock	0.3788	0.3813	0.3755	0.3813	158931520.0
2011-09-20 11:00:00	NVDA	Stock	0.3811	0.3848	0.3805	0.382	88253400.0
2011-09-20 12:00:00	NVDA	Stock	0.382	0.382	0.3758	0.3776	79086640.0
2011-09-20 13:00:00	NVDA	Stock	0.3778	0.379	0.3755	0.3763	66588440.0
2011-09-20 14:00:00	NVDA	Stock	0.3762	0.3775	0.3725	0.3725	86882240.0
2011-09-20 15:00:00	NVDA	Stock	0.3726	0.3733	0.367	0.3685	169038440.0
2011-09-20 16:00:00	NVDA	Stock	0.3688	0.3768	0.3684	0.3688	16471720.0
2011-09-20 17:00:00	NVDA	Stock	0.3688	0.3703	0.3678	0.3695	3862480.0
2011-09-20 18:00:00	NVDA	Stock	0.3695	0.3715	0.368	0.3688	547960.0
2011-09-20 19:00:00	NVDA	Stock	0.3692	0.3715	0.3688	0.3713	319600.0
2011-09-20 04:00:00	AMZN	Stock	12.03	12.1275	12.03	12.1275	16000.0
2011-09-20 05:00:00	AMZN	Stock	12.1495	12.215	12.1495	12.215	22000.0
2011-09-20 06:00:00	AMZN	Stock	12.209	12.209	12.208	12.208	4000.0
2011-09-20 07:00:00	AMZN	Stock	12.1845	12.195	12.165	12.1775	135000.0

> showing 50 of 45,234 rows — these rows as CSV

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