PREVIEW / stock_1hour / 2011-06-24

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-06-24.parquet
  size:    999 KB
  rows:    46,359
  symbols: 3,549

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-06-24 04:00:00	AAPL	Stock	11.8636	11.8636	11.8636	11.8636	2800.0
2011-06-24 05:00:00	AAPL	Stock	11.9111	11.9111	11.9071	11.9071	50400.0
2011-06-24 06:00:00	AAPL	Stock	11.9018	11.9018	11.8632	11.8643	35840.0
2011-06-24 07:00:00	AAPL	Stock	11.8611	11.8611	11.8229	11.8229	298312.0
2011-06-24 08:00:00	AAPL	Stock	11.8393	11.8464	11.7829	11.8311	2587340.0
2011-06-24 09:00:00	AAPL	Stock	11.8271	11.8982	11.8061	11.8404	80088736.0
2011-06-24 10:00:00	AAPL	Stock	11.8393	11.8496	11.7093	11.7454	86301180.0
2011-06-24 11:00:00	AAPL	Stock	11.7457	11.7832	11.7139	11.7436	44996084.0
2011-06-24 12:00:00	AAPL	Stock	11.7436	11.765	11.6886	11.6968	35732144.0
2011-06-24 13:00:00	AAPL	Stock	11.6968	11.7339	11.6518	11.7018	47213096.0
2011-06-24 14:00:00	AAPL	Stock	11.7036	11.7043	11.6575	11.6714	35263760.0
2011-06-24 15:00:00	AAPL	Stock	11.6736	11.6796	11.6104	11.6554	78051876.0
2011-06-24 16:00:00	AAPL	Stock	11.6554	11.7333	11.6268	11.6343	18632460.0
2011-06-24 17:00:00	AAPL	Stock	11.6411	11.7469	11.6386	11.7469	578088.0
2011-06-24 18:00:00	AAPL	Stock	11.6429	11.6554	11.6314	11.6357	189392.0
2011-06-24 19:00:00	AAPL	Stock	11.6375	11.6414	11.6311	11.6414	104524.0
2011-06-24 05:00:00	MSFT	Stock	24.8	24.8	24.8	24.8	150.0
2011-06-24 06:00:00	MSFT	Stock	24.63	24.63	24.63	24.63	100.0
2011-06-24 07:00:00	MSFT	Stock	24.62	24.62	24.62	24.62	300.0
2011-06-24 08:00:00	MSFT	Stock	24.58	24.71	24.3	24.71	29679.0
2011-06-24 09:00:00	MSFT	Stock	24.7	24.7	24.305	24.335	6388255.0
2011-06-24 10:00:00	MSFT	Stock	24.34	24.38	24.21	24.3	9226266.0
2011-06-24 11:00:00	MSFT	Stock	24.305	24.35	24.26	24.3	6478698.0
2011-06-24 12:00:00	MSFT	Stock	24.3	24.31	24.19	24.23	6822588.0
2011-06-24 13:00:00	MSFT	Stock	24.23	24.32	24.21	24.28	4986480.0
2011-06-24 14:00:00	MSFT	Stock	24.28	24.29	24.23	24.25	5210917.0
2011-06-24 15:00:00	MSFT	Stock	24.25	24.33	24.215	24.29	12822651.0
2011-06-24 16:00:00	MSFT	Stock	24.3	24.32	24.23	24.312	26469047.0
2011-06-24 17:00:00	MSFT	Stock	24.298	24.32	24.26	24.32	6476481.0
2011-06-24 18:00:00	MSFT	Stock	24.3	24.306	24.24	24.25	314171.0
2011-06-24 19:00:00	MSFT	Stock	24.25	24.25	24.19	24.19	16800.0
2011-06-24 07:00:00	NVDA	Stock	0.405	0.4053	0.405	0.4053	20000.0
2011-06-24 08:00:00	NVDA	Stock	0.4025	0.407	0.4025	0.407	108480.0
2011-06-24 09:00:00	NVDA	Stock	0.4035	0.4068	0.4	0.404	52050200.0
2011-06-24 10:00:00	NVDA	Stock	0.404	0.4045	0.3953	0.3968	82789440.0
2011-06-24 11:00:00	NVDA	Stock	0.3968	0.397	0.3918	0.3962	91421400.0
2011-06-24 12:00:00	NVDA	Stock	0.3965	0.3973	0.394	0.3948	35788800.0
2011-06-24 13:00:00	NVDA	Stock	0.3948	0.3958	0.3938	0.3958	35306640.0
2011-06-24 14:00:00	NVDA	Stock	0.3958	0.3958	0.3935	0.3948	48108840.0
2011-06-24 15:00:00	NVDA	Stock	0.395	0.395	0.391	0.3935	132162320.0
2011-06-24 16:00:00	NVDA	Stock	0.3935	0.3959	0.3908	0.3933	38551600.0
2011-06-24 17:00:00	NVDA	Stock	0.3915	0.3937	0.3913	0.3913	1738640.0
2011-06-24 18:00:00	NVDA	Stock	0.3936	0.3942	0.3913	0.3913	144360.0
2011-06-24 19:00:00	NVDA	Stock	0.3935	0.3935	0.3935	0.3935	8000.0
2011-06-24 06:00:00	AMZN	Stock	9.7145	9.7145	9.7145	9.7145	2000.0
2011-06-24 07:00:00	AMZN	Stock	9.665	9.665	9.665	9.665	2000.0
2011-06-24 08:00:00	AMZN	Stock	9.7095	9.71	9.665	9.683	67000.0
2011-06-24 09:00:00	AMZN	Stock	9.689	9.746	9.6395	9.6667	9121160.0
2011-06-24 10:00:00	AMZN	Stock	9.6665	9.685	9.6165	9.68	9923220.0
2011-06-24 11:00:00	AMZN	Stock	9.6775	9.7275	9.6655	9.6785	6438160.0

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

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