PREVIEW / stock_1hour / 2013-04-24

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-24.parquet
  size:    980 KB
  rows:    46,173
  symbols: 3,487

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
2013-04-24 04:00:00	AAPL	Stock	14.4829	14.6075	14.4829	14.5632	121800.0
2013-04-24 05:00:00	AAPL	Stock	14.5554	14.5554	14.5179	14.5321	209440.0
2013-04-24 06:00:00	AAPL	Stock	14.5346	14.5346	14.3482	14.3911	584640.0
2013-04-24 07:00:00	AAPL	Stock	14.4154	14.5	14.0893	14.1661	9755396.0
2013-04-24 08:00:00	AAPL	Stock	14.1696	14.4595	13.9668	14.0357	31597552.0
2013-04-24 09:00:00	AAPL	Stock	14.035	14.8304	13.9946	14.5814	284007864.0
2013-04-24 10:00:00	AAPL	Stock	14.5868	14.6511	14.1979	14.2996	217444752.0
2013-04-24 11:00:00	AAPL	Stock	14.3	14.3925	14.2679	14.2861	78880116.0
2013-04-24 12:00:00	AAPL	Stock	14.2857	14.3679	14.2768	14.3264	39082708.0
2013-04-24 13:00:00	AAPL	Stock	14.3296	14.5239	14.3269	14.4554	78906688.0
2013-04-24 14:00:00	AAPL	Stock	14.45	14.6943	14.44	14.6479	95514076.0
2013-04-24 15:00:00	AAPL	Stock	14.6477	14.6496	14.4589	14.4846	104492276.0
2013-04-24 16:00:00	AAPL	Stock	14.4846	14.5194	14.0776	14.4821	10971184.0
2013-04-24 17:00:00	AAPL	Stock	14.485	14.4893	14.4696	14.4768	7438564.0
2013-04-24 18:00:00	AAPL	Stock	14.4739	14.4807	14.4664	14.4668	173040.0
2013-04-24 19:00:00	AAPL	Stock	14.47	14.4886	14.4696	14.4732	110404.0
2013-04-24 06:00:00	MSFT	Stock	30.65	30.65	30.65	30.65	3150.0
2013-04-24 07:00:00	MSFT	Stock	30.58	30.65	30.55	30.65	4640.0
2013-04-24 08:00:00	MSFT	Stock	30.58	30.6	30.55	30.56	40490.0
2013-04-24 09:00:00	MSFT	Stock	30.56	30.83	30.56	30.83	5779610.0
2013-04-24 10:00:00	MSFT	Stock	30.83	31.04	30.785	31.03	12543840.0
2013-04-24 11:00:00	MSFT	Stock	31.02	31.11	31.02	31.073	8091598.0
2013-04-24 12:00:00	MSFT	Stock	31.075	31.18	31.06	31.112	8909734.0
2013-04-24 13:00:00	MSFT	Stock	31.115	31.58	31.11	31.525	18692602.0
2013-04-24 14:00:00	MSFT	Stock	31.521	31.75	31.51	31.75	9732775.0
2013-04-24 15:00:00	MSFT	Stock	31.74	31.92	31.7	31.76	19904805.0
2013-04-24 16:00:00	MSFT	Stock	31.76	31.83	30.6	31.74	5287852.0
2013-04-24 17:00:00	MSFT	Stock	31.74	31.76	31.71	31.71	36445.0
2013-04-24 18:00:00	MSFT	Stock	31.73	31.76	31.71	31.76	54344.0
2013-04-24 19:00:00	MSFT	Stock	31.72	31.76	31.71	31.76	4100.0
2013-04-24 09:00:00	NVDA	Stock	0.324	0.3298	0.3238	0.3293	37067920.0
2013-04-24 10:00:00	NVDA	Stock	0.3295	0.33	0.3255	0.3284	77722320.0
2013-04-24 11:00:00	NVDA	Stock	0.3284	0.331	0.3278	0.3303	57506480.0
2013-04-24 12:00:00	NVDA	Stock	0.3303	0.3322	0.3293	0.3321	62474560.0
2013-04-24 13:00:00	NVDA	Stock	0.3322	0.335	0.3315	0.3338	80191000.0
2013-04-24 14:00:00	NVDA	Stock	0.334	0.3361	0.3339	0.336	94388720.0
2013-04-24 15:00:00	NVDA	Stock	0.3361	0.3368	0.3338	0.334	130396760.0
2013-04-24 16:00:00	NVDA	Stock	0.334	0.3358	0.323	0.3358	16225600.0
2013-04-24 17:00:00	NVDA	Stock	0.334	0.334	0.3338	0.3338	461560.0
2013-04-24 18:00:00	NVDA	Stock	0.335	0.335	0.334	0.334	52800.0
2013-04-24 06:00:00	AMZN	Stock	13.4745	13.4745	13.4745	13.4745	2000.0
2013-04-24 07:00:00	AMZN	Stock	13.4975	13.498	13.4975	13.498	38620.0
2013-04-24 08:00:00	AMZN	Stock	13.4825	13.498	13.45	13.472	145500.0
2013-04-24 09:00:00	AMZN	Stock	13.4725	13.5735	13.3975	13.479	6828600.0
2013-04-24 10:00:00	AMZN	Stock	13.4775	13.531	13.3405	13.507	7974820.0
2013-04-24 11:00:00	AMZN	Stock	13.5095	13.549	13.44	13.46	3532600.0
2013-04-24 12:00:00	AMZN	Stock	13.4675	13.491	13.4296	13.4413	2577380.0
2013-04-24 13:00:00	AMZN	Stock	13.44	13.49	13.4205	13.428	2410660.0
2013-04-24 14:00:00	AMZN	Stock	13.4278	13.5045	13.4278	13.5045	2741600.0
2013-04-24 15:00:00	AMZN	Stock	13.5035	13.5065	13.4355	13.4405	6800920.0

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

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