PREVIEW / stock_1hour / 2011-10-12

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-10-12.parquet
  size:    943 KB
  rows:    46,011
  symbols: 3,515

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-10-12 04:00:00	AAPL	Stock	14.375	14.4196	14.3571	14.4082	92876.0
2011-10-12 05:00:00	AAPL	Stock	14.4139	14.4518	14.4036	14.4518	131460.0
2011-10-12 06:00:00	AAPL	Stock	14.4518	14.4518	14.4286	14.4286	43372.0
2011-10-12 07:00:00	AAPL	Stock	14.4143	14.4475	14.3929	14.4036	1056552.0
2011-10-12 08:00:00	AAPL	Stock	14.4036	14.5432	14.3929	14.5364	6362888.0
2011-10-12 09:00:00	AAPL	Stock	14.5407	14.6161	14.525	14.5957	117419820.0
2011-10-12 10:00:00	AAPL	Stock	14.5936	14.5979	14.4825	14.51	92777496.0
2011-10-12 11:00:00	AAPL	Stock	14.5104	14.5868	14.5093	14.5329	51580704.0
2011-10-12 12:00:00	AAPL	Stock	14.5329	14.5461	14.4725	14.5153	50941940.0
2011-10-12 13:00:00	AAPL	Stock	14.5145	14.56	14.4971	14.5093	38121832.0
2011-10-12 14:00:00	AAPL	Stock	14.5093	14.5357	14.3114	14.3333	110890164.0
2011-10-12 15:00:00	AAPL	Stock	14.3379	14.4354	14.2907	14.3611	128533692.0
2011-10-12 16:00:00	AAPL	Stock	14.3607	14.5389	14.3432	14.3579	10053092.0
2011-10-12 17:00:00	AAPL	Stock	14.3571	14.3607	14.3507	14.3557	609784.0
2011-10-12 18:00:00	AAPL	Stock	14.3571	14.3643	14.3536	14.3586	517916.0
2011-10-12 19:00:00	AAPL	Stock	14.3589	14.3643	14.3518	14.3518	222068.0
2011-10-12 05:00:00	MSFT	Stock	27.11	27.25	27.11	27.25	300.0
2011-10-12 07:00:00	MSFT	Stock	27.18	27.21	27.15	27.15	1385.0
2011-10-12 08:00:00	MSFT	Stock	27.08	27.19	27.0	27.16	122923.0
2011-10-12 09:00:00	MSFT	Stock	27.16	27.2	26.95	26.98	5144808.0
2011-10-12 10:00:00	MSFT	Stock	26.99	27.305	26.93	27.11	7995142.0
2011-10-12 11:00:00	MSFT	Stock	27.11	27.22	27.08	27.13	3901739.0
2011-10-12 12:00:00	MSFT	Stock	27.13	27.26	27.1	27.23	4571317.0
2011-10-12 13:00:00	MSFT	Stock	27.225	27.3	27.12	27.155	4436795.0
2011-10-12 14:00:00	MSFT	Stock	27.15	27.31	27.13	27.19	5159223.0
2011-10-12 15:00:00	MSFT	Stock	27.195	27.26	26.9	26.95	14507139.0
2011-10-12 16:00:00	MSFT	Stock	26.94	27.268	26.86	26.9	5236315.0
2011-10-12 17:00:00	MSFT	Stock	26.88	26.96	26.87	26.9	21520.0
2011-10-12 18:00:00	MSFT	Stock	26.91	26.96	26.91	26.91	7027.0
2011-10-12 19:00:00	MSFT	Stock	26.91	26.91	26.89	26.89	3500.0
2011-10-12 04:00:00	NVDA	Stock	0.3668	0.3668	0.3668	0.3668	8000.0
2011-10-12 07:00:00	NVDA	Stock	0.372	0.372	0.372	0.372	16000.0
2011-10-12 08:00:00	NVDA	Stock	0.37	0.3738	0.37	0.3738	784240.0
2011-10-12 09:00:00	NVDA	Stock	0.3723	0.3745	0.3692	0.3709	59842240.0
2011-10-12 10:00:00	NVDA	Stock	0.371	0.3725	0.3665	0.3666	96353400.0
2011-10-12 11:00:00	NVDA	Stock	0.3668	0.37	0.3665	0.3678	47998560.0
2011-10-12 12:00:00	NVDA	Stock	0.3678	0.3692	0.367	0.3682	39165160.0
2011-10-12 13:00:00	NVDA	Stock	0.3684	0.37	0.368	0.37	49185400.0
2011-10-12 14:00:00	NVDA	Stock	0.37	0.3713	0.3682	0.3688	91728040.0
2011-10-12 15:00:00	NVDA	Stock	0.3688	0.37	0.365	0.3652	208219160.0
2011-10-12 16:00:00	NVDA	Stock	0.365	0.3702	0.365	0.3692	15785840.0
2011-10-12 17:00:00	NVDA	Stock	0.3665	0.3675	0.364	0.3652	153080.0
2011-10-12 18:00:00	NVDA	Stock	0.365	0.365	0.365	0.365	32000.0
2011-10-12 19:00:00	NVDA	Stock	0.365	0.3655	0.365	0.3652	140000.0
2011-10-12 04:00:00	AMZN	Stock	11.766	11.766	11.766	11.766	2000.0
2011-10-12 06:00:00	AMZN	Stock	11.967	11.9785	11.855	11.855	11980.0
2011-10-12 07:00:00	AMZN	Stock	11.9	11.908	11.875	11.89	130800.0
2011-10-12 08:00:00	AMZN	Stock	11.894	11.925	11.87	11.9105	364200.0
2011-10-12 09:00:00	AMZN	Stock	11.9005	11.9725	11.7165	11.9225	22446080.0
2011-10-12 10:00:00	AMZN	Stock	11.9315	12.053	11.89	11.958	23659100.0

> showing 50 of 46,011 rows — these rows as CSV

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