PREVIEW / stock_1hour / 2012-12-12

all stock 1-hour files

  file:    by_date/stock_1hour/2012/2012-12-12.parquet
  size:    954 KB
  rows:    45,020
  symbols: 3,500

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-12-12 04:00:00	AAPL	Stock	19.4436	19.5529	19.4436	19.5143	99988.0
2012-12-12 05:00:00	AAPL	Stock	19.5018	19.5304	19.4907	19.5143	170072.0
2012-12-12 06:00:00	AAPL	Stock	19.5036	19.5182	19.4643	19.4893	215320.0
2012-12-12 07:00:00	AAPL	Stock	19.4893	19.5243	19.4732	19.5	772464.0
2012-12-12 08:00:00	AAPL	Stock	19.5	19.6221	19.4768	19.5607	6354068.0
2012-12-12 09:00:00	AAPL	Stock	19.5643	19.5879	19.2954	19.3239	84959588.0
2012-12-12 10:00:00	AAPL	Stock	19.3239	19.3571	19.1525	19.2161	91691628.0
2012-12-12 11:00:00	AAPL	Stock	19.2104	19.325	19.1679	19.1996	50283268.0
2012-12-12 12:00:00	AAPL	Stock	19.2	19.4421	19.1968	19.4082	64165612.0
2012-12-12 13:00:00	AAPL	Stock	19.4075	19.4236	19.3	19.3478	47582248.0
2012-12-12 14:00:00	AAPL	Stock	19.3557	19.3764	19.2554	19.2925	44010708.0
2012-12-12 15:00:00	AAPL	Stock	19.295	19.3125	19.1557	19.2471	80626168.0
2012-12-12 16:00:00	AAPL	Stock	19.26	19.438	19.2143	19.25	7630728.0
2012-12-12 17:00:00	AAPL	Stock	19.2536	19.2639	19.2475	19.2529	191492.0
2012-12-12 18:00:00	AAPL	Stock	19.2589	19.2789	19.2589	19.2782	208544.0
2012-12-12 19:00:00	AAPL	Stock	19.2768	19.2811	19.2679	19.2718	321888.0
2012-12-12 08:00:00	MSFT	Stock	27.39	27.48	27.38	27.47	10178.0
2012-12-12 09:00:00	MSFT	Stock	27.32	27.62	27.32	27.54	5132870.0
2012-12-12 10:00:00	MSFT	Stock	27.545	27.55	27.32	27.345	5684036.0
2012-12-12 11:00:00	MSFT	Stock	27.34	27.44	27.33	27.35	4382057.0
2012-12-12 12:00:00	MSFT	Stock	27.35	27.55	27.3	27.49	9999098.0
2012-12-12 13:00:00	MSFT	Stock	27.5	27.51	27.39	27.43	3814194.0
2012-12-12 14:00:00	MSFT	Stock	27.42	27.45	27.25	27.26	4294189.0
2012-12-12 15:00:00	MSFT	Stock	27.27	27.27	27.08	27.24	8410935.0
2012-12-12 16:00:00	MSFT	Stock	27.23	27.47	27.17	27.2	1301693.0
2012-12-12 17:00:00	MSFT	Stock	27.2	27.416	27.2	27.2	5076.0
2012-12-12 18:00:00	MSFT	Stock	27.2	27.23	27.2	27.23	6246.0
2012-12-12 19:00:00	MSFT	Stock	27.23	27.25	27.23	27.25	13239.0
2012-12-12 08:00:00	NVDA	Stock	0.318	0.3205	0.318	0.3205	44000.0
2012-12-12 09:00:00	NVDA	Stock	0.3205	0.3205	0.3138	0.3152	53548480.0
2012-12-12 10:00:00	NVDA	Stock	0.315	0.3168	0.313	0.3133	90333320.0
2012-12-12 11:00:00	NVDA	Stock	0.3135	0.3135	0.3118	0.3119	52331880.0
2012-12-12 12:00:00	NVDA	Stock	0.3119	0.315	0.3118	0.3143	40890680.0
2012-12-12 13:00:00	NVDA	Stock	0.3145	0.315	0.3138	0.3145	29501200.0
2012-12-12 14:00:00	NVDA	Stock	0.3148	0.3148	0.3125	0.3136	54574040.0
2012-12-12 15:00:00	NVDA	Stock	0.3135	0.3138	0.3118	0.313	65287040.0
2012-12-12 16:00:00	NVDA	Stock	0.313	0.3138	0.3115	0.3123	5847280.0
2012-12-12 04:00:00	AMZN	Stock	12.5395	12.5395	12.5395	12.5395	2000.0
2012-12-12 07:00:00	AMZN	Stock	12.583	12.5995	12.583	12.595	6000.0
2012-12-12 08:00:00	AMZN	Stock	12.5745	12.613	12.5295	12.6	195480.0
2012-12-12 09:00:00	AMZN	Stock	12.5345	12.5945	12.503	12.538	6281040.0
2012-12-12 10:00:00	AMZN	Stock	12.535	12.595	12.53	12.5516	7587040.0
2012-12-12 11:00:00	AMZN	Stock	12.5515	12.5925	12.542	12.556	5159000.0
2012-12-12 12:00:00	AMZN	Stock	12.555	12.6705	12.5505	12.6562	6003080.0
2012-12-12 13:00:00	AMZN	Stock	12.6545	12.674	12.6115	12.6575	4332360.0
2012-12-12 14:00:00	AMZN	Stock	12.661	12.718	12.6115	12.632	9500180.0
2012-12-12 15:00:00	AMZN	Stock	12.6267	12.6366	12.564	12.5885	10404360.0
2012-12-12 16:00:00	AMZN	Stock	12.587	12.6095	12.5668	12.588	2928700.0
2012-12-12 17:00:00	AMZN	Stock	12.596	12.596	12.588	12.588	44200.0
2012-12-12 18:00:00	AMZN	Stock	12.5875	12.6	12.5875	12.6	4000.0

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

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