PREVIEW / stock_1hour / 2011-05-31

all stock 1-hour files

  file:    by_date/stock_1hour/2011/2011-05-31.parquet
  size:    992 KB
  rows:    46,039
  symbols: 3,570

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-05-31 04:00:00	AAPL	Stock	12.0714	12.1489	12.0714	12.1489	34384.0
2011-05-31 07:00:00	AAPL	Stock	12.1429	12.175	12.1271	12.1339	720580.0
2011-05-31 08:00:00	AAPL	Stock	12.1293	12.1961	12.125	12.1696	2566732.0
2011-05-31 09:00:00	AAPL	Stock	12.1654	12.2843	12.1636	12.2393	77304808.0
2011-05-31 10:00:00	AAPL	Stock	12.2389	12.2889	12.225	12.2632	63566300.0
2011-05-31 11:00:00	AAPL	Stock	12.2639	12.2707	12.2429	12.2514	25172252.0
2011-05-31 12:00:00	AAPL	Stock	12.2511	12.2818	12.2364	12.2593	30113272.0
2011-05-31 13:00:00	AAPL	Stock	12.2593	12.3082	12.2593	12.3071	30181676.0
2011-05-31 14:00:00	AAPL	Stock	12.3071	12.3507	12.3025	12.34	60832100.0
2011-05-31 15:00:00	AAPL	Stock	12.34	12.4193	12.3325	12.4171	91720384.0
2011-05-31 16:00:00	AAPL	Stock	12.4225	12.4332	12.2852	12.4225	25770780.0
2011-05-31 17:00:00	AAPL	Stock	12.4246	12.4411	12.2674	12.4393	659036.0
2011-05-31 18:00:00	AAPL	Stock	12.4304	12.4411	12.4225	12.4404	376348.0
2011-05-31 19:00:00	AAPL	Stock	12.4407	12.4643	12.4407	12.4643	537320.0
2011-05-31 04:00:00	MSFT	Stock	24.92	25.05	24.92	25.05	775.0
2011-05-31 05:00:00	MSFT	Stock	25.0	25.0	25.0	25.0	100.0
2011-05-31 06:00:00	MSFT	Stock	25.05	25.05	25.04	25.04	600.0
2011-05-31 07:00:00	MSFT	Stock	25.04	25.04	25.0	25.0	7050.0
2011-05-31 08:00:00	MSFT	Stock	24.99	24.99	24.87	24.88	46024.0
2011-05-31 09:00:00	MSFT	Stock	24.88	25.06	24.8	24.84	7790282.0
2011-05-31 10:00:00	MSFT	Stock	24.84	24.86	24.75	24.75	8307174.0
2011-05-31 11:00:00	MSFT	Stock	24.75	24.8	24.7	24.73	5197232.0
2011-05-31 12:00:00	MSFT	Stock	24.73	24.78	24.7	24.75	3016622.0
2011-05-31 13:00:00	MSFT	Stock	24.75	24.94	24.75	24.89	5415334.0
2011-05-31 14:00:00	MSFT	Stock	24.89	24.92	24.85	24.915	4115774.0
2011-05-31 15:00:00	MSFT	Stock	24.91	25.02	24.89	25.02	10809836.0
2011-05-31 16:00:00	MSFT	Stock	25.01	25.08	24.841	24.998	13533950.0
2011-05-31 17:00:00	MSFT	Stock	25.04	25.06	24.845	25.05	35535.0
2011-05-31 18:00:00	MSFT	Stock	25.04	25.04	25.01	25.03	20025.0
2011-05-31 19:00:00	MSFT	Stock	25.03	25.04	25.02	25.04	3130.0
2011-05-31 04:00:00	NVDA	Stock	0.494	0.494	0.494	0.494	4000.0
2011-05-31 07:00:00	NVDA	Stock	0.4938	0.5	0.4938	0.4963	508080.0
2011-05-31 08:00:00	NVDA	Stock	0.4985	0.4988	0.495	0.4975	570720.0
2011-05-31 09:00:00	NVDA	Stock	0.4975	0.5	0.4878	0.488	160363160.0
2011-05-31 10:00:00	NVDA	Stock	0.4878	0.4908	0.485	0.49	170928320.0
2011-05-31 11:00:00	NVDA	Stock	0.4898	0.495	0.4895	0.4942	88317840.0
2011-05-31 12:00:00	NVDA	Stock	0.4942	0.496	0.4923	0.4942	66748040.0
2011-05-31 13:00:00	NVDA	Stock	0.4944	0.4998	0.4942	0.4995	91640120.0
2011-05-31 14:00:00	NVDA	Stock	0.4995	0.4998	0.4979	0.4989	84120440.0
2011-05-31 15:00:00	NVDA	Stock	0.4988	0.5013	0.4985	0.5008	236948480.0
2011-05-31 16:00:00	NVDA	Stock	0.501	0.5025	0.4901	0.5025	295479280.0
2011-05-31 17:00:00	NVDA	Stock	0.5018	0.5025	0.5009	0.5018	556520.0
2011-05-31 18:00:00	NVDA	Stock	0.502	0.5025	0.502	0.5025	124000.0
2011-05-31 19:00:00	NVDA	Stock	0.5025	0.5025	0.5013	0.5015	200920.0
2011-05-31 04:00:00	AMZN	Stock	9.749	9.749	9.749	9.749	2000.0
2011-05-31 07:00:00	AMZN	Stock	9.806	9.924	9.8045	9.8045	40000.0
2011-05-31 08:00:00	AMZN	Stock	9.8045	9.8055	9.783	9.8	31040.0
2011-05-31 09:00:00	AMZN	Stock	9.8	9.922	9.797	9.8625	12017440.0
2011-05-31 10:00:00	AMZN	Stock	9.8655	9.888	9.7675	9.8145	10044000.0
2011-05-31 11:00:00	AMZN	Stock	9.8125	9.8535	9.789	9.804	5867740.0

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

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