PREVIEW / stock_1hour / 2011-05-25

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-25.parquet
  size:    944 KB
  rows:    45,295
  symbols: 3,536

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-05-25 04:00:00	AAPL	Stock	11.8164	11.8368	11.8164	11.8368	8400.0
2011-05-25 05:00:00	AAPL	Stock	11.8571	11.8632	11.8571	11.8579	11200.0
2011-05-25 06:00:00	AAPL	Stock	11.8579	11.8857	11.8571	11.8821	69720.0
2011-05-25 07:00:00	AAPL	Stock	11.8689	11.8821	11.8571	11.875	110208.0
2011-05-25 08:00:00	AAPL	Stock	11.8754	11.9036	11.8661	11.8982	860804.0
2011-05-25 09:00:00	AAPL	Stock	11.9011	11.9816	11.8839	11.9625	51175180.0
2011-05-25 10:00:00	AAPL	Stock	11.9643	12.0	11.925	11.9632	57804292.0
2011-05-25 11:00:00	AAPL	Stock	11.9614	12.02	11.9546	12.0029	38840928.0
2011-05-25 12:00:00	AAPL	Stock	12.0029	12.0186	11.9932	12.0185	16811480.0
2011-05-25 13:00:00	AAPL	Stock	12.0175	12.0211	11.9861	12.0014	20282976.0
2011-05-25 14:00:00	AAPL	Stock	12.0025	12.0711	11.9964	12.0689	30878708.0
2011-05-25 15:00:00	AAPL	Stock	12.0671	12.0914	12.0196	12.0196	59553172.0
2011-05-25 16:00:00	AAPL	Stock	12.02	12.0784	11.9451	12.0246	7841512.0
2011-05-25 17:00:00	AAPL	Stock	12.0061	12.0271	12.0061	12.02	296408.0
2011-05-25 18:00:00	AAPL	Stock	12.02	12.0371	12.02	12.0371	162120.0
2011-05-25 19:00:00	AAPL	Stock	12.0357	12.04	12.0343	12.0375	142968.0
2011-05-25 04:00:00	MSFT	Stock	24.07	24.07	24.0	24.0	1282.0
2011-05-25 06:00:00	MSFT	Stock	24.09	24.09	24.09	24.09	500.0
2011-05-25 08:00:00	MSFT	Stock	24.12	24.17	24.11	24.12	3800.0
2011-05-25 09:00:00	MSFT	Stock	24.11	24.3	24.09	24.22	4207200.0
2011-05-25 10:00:00	MSFT	Stock	24.215	24.31	24.2	24.217	5549680.0
2011-05-25 11:00:00	MSFT	Stock	24.215	24.3	24.21	24.25	3602045.0
2011-05-25 12:00:00	MSFT	Stock	24.245	24.29	24.22	24.235	4108931.0
2011-05-25 13:00:00	MSFT	Stock	24.235	24.25	24.21	24.21	2953817.0
2011-05-25 14:00:00	MSFT	Stock	24.21	24.25	24.17	24.24	3414867.0
2011-05-25 15:00:00	MSFT	Stock	24.235	24.31	24.18	24.2	7533540.0
2011-05-25 16:00:00	MSFT	Stock	24.191	24.308	24.109	24.188	2121155.0
2011-05-25 17:00:00	MSFT	Stock	24.235	24.4	24.18	24.35	108325.0
2011-05-25 18:00:00	MSFT	Stock	24.35	24.4	24.19	24.34	80125.0
2011-05-25 19:00:00	MSFT	Stock	24.38	24.4	24.31	24.31	10530.0
2011-05-25 07:00:00	NVDA	Stock	0.4552	0.4552	0.4552	0.4552	72000.0
2011-05-25 08:00:00	NVDA	Stock	0.4532	0.4542	0.4498	0.4502	889800.0
2011-05-25 09:00:00	NVDA	Stock	0.452	0.4578	0.4468	0.4572	87881080.0
2011-05-25 10:00:00	NVDA	Stock	0.4575	0.461	0.453	0.4588	114087200.0
2011-05-25 11:00:00	NVDA	Stock	0.4588	0.462	0.458	0.4608	54568520.0
2011-05-25 12:00:00	NVDA	Stock	0.4605	0.461	0.459	0.4603	52729480.0
2011-05-25 13:00:00	NVDA	Stock	0.4605	0.4605	0.4562	0.4585	50846880.0
2011-05-25 14:00:00	NVDA	Stock	0.4585	0.4603	0.458	0.4595	57342320.0
2011-05-25 15:00:00	NVDA	Stock	0.4598	0.4612	0.458	0.4588	108890880.0
2011-05-25 16:00:00	NVDA	Stock	0.459	0.4608	0.453	0.46	1160000.0
2011-05-25 17:00:00	NVDA	Stock	0.4595	0.4598	0.4595	0.4598	59160.0
2011-05-25 18:00:00	NVDA	Stock	0.4598	0.46	0.4598	0.46	159160.0
2011-05-25 19:00:00	NVDA	Stock	0.46	0.46	0.4585	0.46	36400.0
2011-05-25 04:00:00	AMZN	Stock	9.651	9.651	9.651	9.651	2800.0
2011-05-25 08:00:00	AMZN	Stock	9.6595	9.6605	9.645	9.652	110700.0
2011-05-25 09:00:00	AMZN	Stock	9.6575	9.7175	9.603	9.632	15529620.0
2011-05-25 10:00:00	AMZN	Stock	9.6305	9.676	9.5795	9.58	19938480.0
2011-05-25 11:00:00	AMZN	Stock	9.581	9.6275	9.557	9.619	15141280.0
2011-05-25 12:00:00	AMZN	Stock	9.6185	9.6395	9.5985	9.602	7330120.0
2011-05-25 13:00:00	AMZN	Stock	9.6015	9.625	9.5925	9.6215	6318920.0

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

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