PREVIEW / stock_1hour / 2013-04-18

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-04-18.parquet
  size:    964 KB
  rows:    44,823
  symbols: 3,452

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-18 04:00:00	AAPL	Stock	14.37	14.37	14.37	14.37	2800.0
2013-04-18 05:00:00	AAPL	Stock	14.3864	14.4375	14.3864	14.4375	50652.0
2013-04-18 06:00:00	AAPL	Stock	14.4464	14.4464	14.4018	14.4286	123872.0
2013-04-18 07:00:00	AAPL	Stock	14.4139	14.5629	14.4139	14.5318	1400728.0
2013-04-18 08:00:00	AAPL	Stock	14.5379	14.55	14.3929	14.4821	7815556.0
2013-04-18 09:00:00	AAPL	Stock	14.4821	14.5511	14.2368	14.25	106475936.0
2013-04-18 10:00:00	AAPL	Stock	14.25	14.2632	14.0557	14.1825	170610860.0
2013-04-18 11:00:00	AAPL	Stock	14.1843	14.1864	14.0557	14.1193	74195100.0
2013-04-18 12:00:00	AAPL	Stock	14.1196	14.155	14.0846	14.125	48067516.0
2013-04-18 13:00:00	AAPL	Stock	14.1296	14.1336	14.0196	14.0314	44720032.0
2013-04-18 14:00:00	AAPL	Stock	14.03	14.0379	13.9194	13.9429	88146632.0
2013-04-18 15:00:00	AAPL	Stock	13.9429	14.0614	13.9252	13.9964	92871492.0
2013-04-18 16:00:00	AAPL	Stock	14.0018	14.1384	13.9125	13.9682	22505364.0
2013-04-18 17:00:00	AAPL	Stock	13.9779	14.0018	13.9539	13.9668	783384.0
2013-04-18 18:00:00	AAPL	Stock	13.9711	13.9811	13.9575	13.9804	260736.0
2013-04-18 19:00:00	AAPL	Stock	13.9775	13.9786	13.9643	13.9707	283724.0
2013-04-18 05:00:00	MSFT	Stock	29.09	29.09	29.09	29.09	200.0
2013-04-18 06:00:00	MSFT	Stock	28.87	28.87	28.87	28.87	200.0
2013-04-18 07:00:00	MSFT	Stock	28.89	28.9	28.89	28.9	1995.0
2013-04-18 08:00:00	MSFT	Stock	28.91	28.95	28.87	28.87	13043.0
2013-04-18 09:00:00	MSFT	Stock	28.87	29.01	28.75	28.83	4263413.0
2013-04-18 10:00:00	MSFT	Stock	28.825	28.845	28.5	28.76	10735378.0
2013-04-18 11:00:00	MSFT	Stock	28.77	28.86	28.67	28.705	7004404.0
2013-04-18 12:00:00	MSFT	Stock	28.705	28.85	28.695	28.806	4150907.0
2013-04-18 13:00:00	MSFT	Stock	28.8	28.87	28.79	28.82	4391675.0
2013-04-18 14:00:00	MSFT	Stock	28.82	28.83	28.71	28.725	5961717.0
2013-04-18 15:00:00	MSFT	Stock	28.72	28.8	28.66	28.79	12777822.0
2013-04-18 16:00:00	MSFT	Stock	28.79	29.48	27.85	29.47	5640628.0
2013-04-18 17:00:00	MSFT	Stock	29.47	29.5	28.79	29.47	219675.0
2013-04-18 18:00:00	MSFT	Stock	29.47	29.65	29.45	29.55	96690.0
2013-04-18 19:00:00	MSFT	Stock	29.58	29.65	29.41	29.63	37751.0
2013-04-18 08:00:00	NVDA	Stock	0.3195	0.3215	0.3195	0.32	180000.0
2013-04-18 09:00:00	NVDA	Stock	0.3205	0.3225	0.3155	0.316	32902960.0
2013-04-18 10:00:00	NVDA	Stock	0.3163	0.3205	0.3143	0.32	69959400.0
2013-04-18 11:00:00	NVDA	Stock	0.32	0.3203	0.316	0.3185	49807360.0
2013-04-18 12:00:00	NVDA	Stock	0.3185	0.3185	0.317	0.3175	32619120.0
2013-04-18 13:00:00	NVDA	Stock	0.3175	0.318	0.316	0.3163	23090840.0
2013-04-18 14:00:00	NVDA	Stock	0.316	0.3165	0.3138	0.315	66299520.0
2013-04-18 15:00:00	NVDA	Stock	0.3151	0.316	0.3135	0.3135	113316200.0
2013-04-18 16:00:00	NVDA	Stock	0.3135	0.319	0.3133	0.3135	13485520.0
2013-04-18 17:00:00	NVDA	Stock	0.3135	0.3135	0.3135	0.3135	230640.0
2013-04-18 04:00:00	AMZN	Stock	13.385	13.385	13.385	13.385	2020.0
2013-04-18 07:00:00	AMZN	Stock	13.423	13.423	13.423	13.423	2000.0
2013-04-18 08:00:00	AMZN	Stock	13.45	13.45	13.3925	13.3965	40100.0
2013-04-18 09:00:00	AMZN	Stock	13.3995	13.3995	13.1665	13.181	8134460.0
2013-04-18 10:00:00	AMZN	Stock	13.1815	13.22	13.057	13.2	11960860.0
2013-04-18 11:00:00	AMZN	Stock	13.1972	13.2015	13.014	13.0595	7843640.0
2013-04-18 12:00:00	AMZN	Stock	13.0655	13.0655	12.9465	12.9615	7079580.0
2013-04-18 13:00:00	AMZN	Stock	12.9625	12.9995	12.9355	12.9595	4364500.0
2013-04-18 14:00:00	AMZN	Stock	12.962	12.9625	12.83	12.871	7974860.0

> showing 50 of 44,823 rows — these rows as CSV

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