PREVIEW / stock_1hour / 2015-07-24

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-07-24.parquet
  size:    1.0 MB
  rows:    48,375
  symbols: 3,484

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
2015-07-24 04:00:00	AAPL	Stock	31.3625	31.4125	31.35	31.4075	26608.0
2015-07-24 05:00:00	AAPL	Stock	31.3975	31.3975	31.3575	31.3875	34912.0
2015-07-24 06:00:00	AAPL	Stock	31.3875	31.4125	31.345	31.375	51048.0
2015-07-24 07:00:00	AAPL	Stock	31.3875	31.395	31.325	31.3375	131664.0
2015-07-24 08:00:00	AAPL	Stock	31.345	31.4	31.2625	31.32	848748.0
2015-07-24 09:00:00	AAPL	Stock	31.32	31.4125	31.15	31.3525	24811768.0
2015-07-24 10:00:00	AAPL	Stock	31.3525	31.435	31.2575	31.34	23253268.0
2015-07-24 11:00:00	AAPL	Stock	31.34	31.3975	31.2225	31.2825	14170996.0
2015-07-24 12:00:00	AAPL	Stock	31.2825	31.2838	31.1	31.105	15688636.0
2015-07-24 13:00:00	AAPL	Stock	31.1075	31.1725	30.975	31.075	20418148.0
2015-07-24 14:00:00	AAPL	Stock	31.0725	31.125	30.99	31.11	16313952.0
2015-07-24 15:00:00	AAPL	Stock	31.1118	31.245	31.0525	31.125	32339368.0
2015-07-24 16:00:00	AAPL	Stock	31.115	31.3155	31.1075	31.1525	7146036.0
2015-07-24 17:00:00	AAPL	Stock	31.1525	31.185	31.15	31.1675	101456.0
2015-07-24 18:00:00	AAPL	Stock	31.1725	31.175	31.1475	31.1475	75852.0
2015-07-24 19:00:00	AAPL	Stock	31.1475	31.15	31.1275	31.1325	152244.0
2015-07-24 05:00:00	MSFT	Stock	46.25	46.25	46.25	46.25	100.0
2015-07-24 06:00:00	MSFT	Stock	46.1	46.11	46.1	46.1	3800.0
2015-07-24 07:00:00	MSFT	Stock	46.1	46.11	46.0	46.0	2175.0
2015-07-24 08:00:00	MSFT	Stock	46.03	46.03	45.8	45.8	7820.0
2015-07-24 09:00:00	MSFT	Stock	45.8	46.26	45.77	46.055	3264408.0
2015-07-24 10:00:00	MSFT	Stock	46.07	46.15	45.8	46.06	3991754.0
2015-07-24 11:00:00	MSFT	Stock	46.06	46.32	45.96	46.18	2924104.0
2015-07-24 12:00:00	MSFT	Stock	46.19	46.25	45.995	46.055	1832205.0
2015-07-24 13:00:00	MSFT	Stock	46.05	46.17	46.02	46.12	2434287.0
2015-07-24 14:00:00	MSFT	Stock	46.13	46.17	45.83	45.97	4228513.0
2015-07-24 15:00:00	MSFT	Stock	45.96	46.04	45.835	45.94	6636243.0
2015-07-24 16:00:00	MSFT	Stock	45.94	46.03	45.94	46.027	5678782.0
2015-07-24 17:00:00	MSFT	Stock	46.03	46.2	46.03	46.103	11720.0
2015-07-24 18:00:00	MSFT	Stock	46.103	46.103	46.102	46.102	2546.0
2015-07-24 19:00:00	MSFT	Stock	46.13	46.14	46.08	46.08	4450.0
2015-07-24 09:00:00	NVDA	Stock	0.4948	0.4952	0.4902	0.4906	13290000.0
2015-07-24 10:00:00	NVDA	Stock	0.4905	0.4909	0.4843	0.4843	22701800.0
2015-07-24 11:00:00	NVDA	Stock	0.4843	0.4883	0.484	0.488	25658440.0
2015-07-24 12:00:00	NVDA	Stock	0.488	0.4884	0.4835	0.4855	11676080.0
2015-07-24 13:00:00	NVDA	Stock	0.4855	0.4865	0.4835	0.4862	20130640.0
2015-07-24 14:00:00	NVDA	Stock	0.4862	0.4872	0.4852	0.486	18956280.0
2015-07-24 15:00:00	NVDA	Stock	0.486	0.4878	0.485	0.4855	48790360.0
2015-07-24 16:00:00	NVDA	Stock	0.4855	0.4855	0.4854	0.4855	22316320.0
2015-07-24 17:00:00	NVDA	Stock	0.4875	0.4875	0.4875	0.4875	4000.0
2015-07-24 04:00:00	AMZN	Stock	28.0505	28.4	27.89	28.4	213480.0
2015-07-24 05:00:00	AMZN	Stock	28.4485	28.575	28.315	28.4	369580.0
2015-07-24 06:00:00	AMZN	Stock	28.3995	28.5	28.35	28.4835	160900.0
2015-07-24 07:00:00	AMZN	Stock	28.47	28.969	28.45	28.94	3303520.0
2015-07-24 08:00:00	AMZN	Stock	28.9	29.572	28.75	29.1455	9151860.0
2015-07-24 09:00:00	AMZN	Stock	29.1535	29.1785	27.8085	28.061	99346520.0
2015-07-24 10:00:00	AMZN	Stock	28.0635	28.12	27.532	27.818	56436500.0
2015-07-24 11:00:00	AMZN	Stock	27.8188	28.0685	27.644	27.815	39383320.0
2015-07-24 12:00:00	AMZN	Stock	27.8175	27.85	27.45	27.484	20547900.0
2015-07-24 13:00:00	AMZN	Stock	27.47	27.53	26.7655	27.152	57370620.0

> showing 50 of 48,375 rows — these rows as CSV

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