PREVIEW / stock_1hour / 2012-07-20

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-07-20.parquet
  size:    922 KB
  rows:    43,328
  symbols: 3,463

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
2012-07-20 05:00:00	AAPL	Stock	21.9646	21.9646	21.9643	21.9643	8400.0
2012-07-20 06:00:00	AAPL	Stock	21.9643	21.9871	21.9643	21.9646	25200.0
2012-07-20 07:00:00	AAPL	Stock	21.9646	21.9782	21.8214	21.8571	502152.0
2012-07-20 08:00:00	AAPL	Stock	21.8739	21.9643	21.8507	21.8829	1930908.0
2012-07-20 09:00:00	AAPL	Stock	21.8857	21.9625	21.8432	21.8957	70646324.0
2012-07-20 10:00:00	AAPL	Stock	21.8904	21.9104	21.8004	21.8471	57443148.0
2012-07-20 11:00:00	AAPL	Stock	21.8457	21.8507	21.7214	21.7271	47148416.0
2012-07-20 12:00:00	AAPL	Stock	21.7225	21.725	21.6504	21.7196	50023316.0
2012-07-20 13:00:00	AAPL	Stock	21.72	21.7343	21.6611	21.6839	25909744.0
2012-07-20 14:00:00	AAPL	Stock	21.683	21.7186	21.675	21.6889	19072312.0
2012-07-20 15:00:00	AAPL	Stock	21.687	21.7071	21.5643	21.5643	85791104.0
2012-07-20 16:00:00	AAPL	Stock	21.5607	21.7531	21.5507	21.5782	18332048.0
2012-07-20 17:00:00	AAPL	Stock	21.5768	21.5804	21.5714	21.5775	358288.0
2012-07-20 18:00:00	AAPL	Stock	21.5768	21.5768	21.5625	21.5732	201432.0
2012-07-20 19:00:00	AAPL	Stock	21.5743	21.5757	21.5696	21.5743	271628.0
2012-07-20 04:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	4200.0
2012-07-20 05:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	500.0
2012-07-20 06:00:00	MSFT	Stock	31.22	31.22	31.22	31.22	262.0
2012-07-20 07:00:00	MSFT	Stock	31.2	31.25	31.09	31.16	26967.0
2012-07-20 08:00:00	MSFT	Stock	31.16	31.29	30.665	30.99	382637.0
2012-07-20 09:00:00	MSFT	Stock	30.99	31.12	30.54	30.793	17102602.0
2012-07-20 10:00:00	MSFT	Stock	30.795	30.84	30.14	30.345	12345319.0
2012-07-20 11:00:00	MSFT	Stock	30.348	30.51	30.28	30.35	5568388.0
2012-07-20 12:00:00	MSFT	Stock	30.35	30.36	30.2	30.35	3942953.0
2012-07-20 13:00:00	MSFT	Stock	30.34	30.36	30.2	30.24	3710470.0
2012-07-20 14:00:00	MSFT	Stock	30.245	30.3	30.13	30.185	3617350.0
2012-07-20 15:00:00	MSFT	Stock	30.185	30.25	30.05	30.08	10888720.0
2012-07-20 16:00:00	MSFT	Stock	30.09	30.466	30.05	30.06	3382734.0
2012-07-20 17:00:00	MSFT	Stock	30.06	30.11	30.06	30.09	6886.0
2012-07-20 18:00:00	MSFT	Stock	30.07	30.08	30.07	30.07	2285.0
2012-07-20 19:00:00	MSFT	Stock	30.07	30.09	30.07	30.09	3347.0
2012-07-20 08:00:00	NVDA	Stock	0.3291	0.3291	0.3291	0.3291	20000.0
2012-07-20 09:00:00	NVDA	Stock	0.326	0.33	0.3255	0.327	58388760.0
2012-07-20 10:00:00	NVDA	Stock	0.327	0.3288	0.3235	0.3243	60955280.0
2012-07-20 11:00:00	NVDA	Stock	0.3245	0.3248	0.3205	0.3215	60963160.0
2012-07-20 12:00:00	NVDA	Stock	0.3215	0.3215	0.3193	0.3195	50146040.0
2012-07-20 13:00:00	NVDA	Stock	0.3195	0.3203	0.3168	0.319	68878120.0
2012-07-20 14:00:00	NVDA	Stock	0.3191	0.32	0.3188	0.3198	42831040.0
2012-07-20 15:00:00	NVDA	Stock	0.3198	0.3203	0.3194	0.32	85156000.0
2012-07-20 16:00:00	NVDA	Stock	0.32	0.3219	0.3193	0.32	15050240.0
2012-07-20 18:00:00	NVDA	Stock	0.32	0.32	0.32	0.32	20000.0
2012-07-20 19:00:00	NVDA	Stock	0.3195	0.32	0.3195	0.32	52000.0
2012-07-20 05:00:00	AMZN	Stock	11.35	11.35	11.35	11.35	2000.0
2012-07-20 07:00:00	AMZN	Stock	11.225	11.234	11.195	11.195	117880.0
2012-07-20 08:00:00	AMZN	Stock	11.195	11.308	11.195	11.225	664020.0
2012-07-20 09:00:00	AMZN	Stock	11.2255	11.3615	11.2035	11.3525	17260040.0
2012-07-20 10:00:00	AMZN	Stock	11.353	11.431	11.341	11.406	15519260.0
2012-07-20 11:00:00	AMZN	Stock	11.4055	11.425	11.315	11.3304	7573060.0
2012-07-20 12:00:00	AMZN	Stock	11.329	11.335	11.295	11.33	5058340.0
2012-07-20 13:00:00	AMZN	Stock	11.3336	11.3975	11.3235	11.3936	4368840.0

> showing 50 of 43,328 rows — these rows as CSV

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