PREVIEW / stock_1hour / 2012-06-18

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-06-18.parquet
  size:    939 KB
  rows:    45,204
  symbols: 3,518

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-06-18 04:00:00	AAPL	Stock	20.5414	20.5414	20.4893	20.4893	94220.0
2012-06-18 06:00:00	AAPL	Stock	20.4886	20.4886	20.4864	20.4864	25200.0
2012-06-18 07:00:00	AAPL	Stock	20.5	20.5	20.4382	20.4514	242984.0
2012-06-18 08:00:00	AAPL	Stock	20.4557	20.5046	20.3789	20.4275	1767108.0
2012-06-18 09:00:00	AAPL	Stock	20.4239	20.6924	20.3704	20.6118	68791688.0
2012-06-18 10:00:00	AAPL	Stock	20.6196	20.8525	20.5968	20.7957	91862848.0
2012-06-18 11:00:00	AAPL	Stock	20.7989	20.8357	20.7321	20.8164	49180880.0
2012-06-18 12:00:00	AAPL	Stock	20.8193	20.8304	20.7793	20.8157	26077688.0
2012-06-18 13:00:00	AAPL	Stock	20.8157	20.9275	20.8036	20.9275	44784908.0
2012-06-18 14:00:00	AAPL	Stock	20.9279	20.9961	20.8893	20.9379	69346032.0
2012-06-18 15:00:00	AAPL	Stock	20.9373	20.9689	20.8771	20.9218	71498224.0
2012-06-18 16:00:00	AAPL	Stock	20.9218	20.9621	20.4913	20.9268	11836720.0
2012-06-18 17:00:00	AAPL	Stock	20.9268	20.95	20.9268	20.9446	508396.0
2012-06-18 18:00:00	AAPL	Stock	20.9429	20.9446	20.9214	20.9321	183064.0
2012-06-18 19:00:00	AAPL	Stock	20.9304	20.95	20.9214	20.9286	472724.0
2012-06-18 04:00:00	MSFT	Stock	30.99	30.99	30.05	30.05	1290.0
2012-06-18 06:00:00	MSFT	Stock	30.05	30.05	30.05	30.05	700.0
2012-06-18 07:00:00	MSFT	Stock	30.16	30.16	30.0	30.08	12601.0
2012-06-18 08:00:00	MSFT	Stock	30.08	30.14	29.95	29.98	98468.0
2012-06-18 09:00:00	MSFT	Stock	30.0	30.03	29.71	29.82	6345905.0
2012-06-18 10:00:00	MSFT	Stock	29.82	30.03	29.79	29.945	11413565.0
2012-06-18 11:00:00	MSFT	Stock	29.97	30.02	29.8	29.868	7917871.0
2012-06-18 12:00:00	MSFT	Stock	29.86	29.86	29.75	29.78	4577888.0
2012-06-18 13:00:00	MSFT	Stock	29.785	29.87	29.728	29.845	4770373.0
2012-06-18 14:00:00	MSFT	Stock	29.85	29.89	29.79	29.815	4700830.0
2012-06-18 15:00:00	MSFT	Stock	29.817	29.84	29.72	29.84	11256093.0
2012-06-18 16:00:00	MSFT	Stock	29.84	30.0	29.784	29.9	7052488.0
2012-06-18 17:00:00	MSFT	Stock	29.92	30.09	29.91	30.0	127492.0
2012-06-18 18:00:00	MSFT	Stock	30.0	30.02	29.9	29.95	37076.0
2012-06-18 19:00:00	MSFT	Stock	29.98	30.18	29.8	30.09	141631.0
2012-06-18 08:00:00	NVDA	Stock	0.3062	0.3062	0.3062	0.3062	52000.0
2012-06-18 09:00:00	NVDA	Stock	0.3052	0.3088	0.3045	0.308	27528280.0
2012-06-18 10:00:00	NVDA	Stock	0.3078	0.3083	0.3045	0.3048	55543480.0
2012-06-18 11:00:00	NVDA	Stock	0.3048	0.3059	0.3025	0.3059	42115160.0
2012-06-18 12:00:00	NVDA	Stock	0.306	0.3075	0.305	0.3062	21667560.0
2012-06-18 13:00:00	NVDA	Stock	0.3061	0.31	0.3061	0.31	31272680.0
2012-06-18 14:00:00	NVDA	Stock	0.31	0.3125	0.3088	0.3108	45554160.0
2012-06-18 15:00:00	NVDA	Stock	0.3105	0.3118	0.309	0.31	65473280.0
2012-06-18 16:00:00	NVDA	Stock	0.3103	0.3112	0.3078	0.3098	5780840.0
2012-06-18 17:00:00	NVDA	Stock	0.3098	0.312	0.3098	0.3115	92000.0
2012-06-18 18:00:00	NVDA	Stock	0.31	0.3123	0.3098	0.3123	164000.0
2012-06-18 19:00:00	NVDA	Stock	0.3123	0.3148	0.3123	0.3143	328000.0
2012-06-18 04:00:00	AMZN	Stock	10.87	10.87	10.87	10.87	2000.0
2012-06-18 05:00:00	AMZN	Stock	10.89	10.89	10.89	10.89	23960.0
2012-06-18 07:00:00	AMZN	Stock	10.9245	10.94	10.9245	10.94	20000.0
2012-06-18 08:00:00	AMZN	Stock	10.875	10.9215	10.8505	10.851	108700.0
2012-06-18 09:00:00	AMZN	Stock	10.8515	11.0275	10.836	10.969	12619620.0
2012-06-18 10:00:00	AMZN	Stock	10.9635	11.075	10.9615	11.0385	10329520.0
2012-06-18 11:00:00	AMZN	Stock	11.036	11.115	11.0035	11.0945	8426360.0
2012-06-18 12:00:00	AMZN	Stock	11.0905	11.1325	11.07	11.1155	5960900.0

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

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