PREVIEW / stock_1hour / 2013-07-01

all stock 1-hour files

  file:    by_date/stock_1hour/2013/2013-07-01.parquet
  size:    997 KB
  rows:    46,206
  symbols: 3,507

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-07-01 04:00:00	AAPL	Stock	14.2311	14.2543	14.2193	14.2193	28000.0
2013-07-01 05:00:00	AAPL	Stock	14.2143	14.2482	14.2107	14.2321	77280.0
2013-07-01 06:00:00	AAPL	Stock	14.2321	14.2857	14.2321	14.2857	134568.0
2013-07-01 07:00:00	AAPL	Stock	14.2854	14.3821	14.2768	14.375	1549660.0
2013-07-01 08:00:00	AAPL	Stock	14.3668	14.3929	14.1193	14.3518	2244340.0
2013-07-01 09:00:00	AAPL	Stock	14.3518	14.515	14.3293	14.4807	69645688.0
2013-07-01 10:00:00	AAPL	Stock	14.4846	14.5861	14.4729	14.5835	61908784.0
2013-07-01 11:00:00	AAPL	Stock	14.5832	14.6493	14.5275	14.6357	47990740.0
2013-07-01 12:00:00	AAPL	Stock	14.6357	14.6979	14.6179	14.6846	47399072.0
2013-07-01 13:00:00	AAPL	Stock	14.6838	14.71	14.6304	14.6388	31141124.0
2013-07-01 14:00:00	AAPL	Stock	14.6404	14.7196	14.6204	14.7054	36496684.0
2013-07-01 15:00:00	AAPL	Stock	14.7032	14.7239	14.5761	14.615	59409168.0
2013-07-01 16:00:00	AAPL	Stock	14.615	14.669	14.5986	14.6089	19651212.0
2013-07-01 17:00:00	AAPL	Stock	14.6129	14.6164	14.6111	14.6143	367080.0
2013-07-01 18:00:00	AAPL	Stock	14.6125	14.6164	14.6071	14.6161	139272.0
2013-07-01 19:00:00	AAPL	Stock	14.6157	14.6304	14.6157	14.6254	59276.0
2013-07-01 08:00:00	MSFT	Stock	34.58	34.67	34.54	34.63	12840.0
2013-07-01 09:00:00	MSFT	Stock	34.62	34.88	34.61	34.84	4486134.0
2013-07-01 10:00:00	MSFT	Stock	34.845	34.99	34.79	34.803	4451065.0
2013-07-01 11:00:00	MSFT	Stock	34.8	34.8	34.59	34.658	3999348.0
2013-07-01 12:00:00	MSFT	Stock	34.655	34.67	34.47	34.53	2820326.0
2013-07-01 13:00:00	MSFT	Stock	34.525	34.55	34.38	34.44	3433492.0
2013-07-01 14:00:00	MSFT	Stock	34.435	34.58	34.4	34.545	2763355.0
2013-07-01 15:00:00	MSFT	Stock	34.545	34.58	34.33	34.36	5254624.0
2013-07-01 16:00:00	MSFT	Stock	34.36	34.776	34.3	34.35	3563630.0
2013-07-01 17:00:00	MSFT	Stock	34.35	34.35	34.28	34.28	3171.0
2013-07-01 18:00:00	MSFT	Stock	34.29	34.29	34.29	34.29	5700.0
2013-07-01 19:00:00	MSFT	Stock	34.3	34.32	34.3	34.3	3432.0
2013-07-01 08:00:00	NVDA	Stock	0.3508	0.351	0.3505	0.3505	2064000.0
2013-07-01 09:00:00	NVDA	Stock	0.351	0.3538	0.3504	0.3515	15225840.0
2013-07-01 10:00:00	NVDA	Stock	0.3513	0.3528	0.3513	0.3525	25575400.0
2013-07-01 11:00:00	NVDA	Stock	0.3522	0.3542	0.3522	0.3538	21599520.0
2013-07-01 12:00:00	NVDA	Stock	0.3539	0.3542	0.3524	0.3531	20039920.0
2013-07-01 13:00:00	NVDA	Stock	0.353	0.3531	0.3513	0.3515	16044840.0
2013-07-01 14:00:00	NVDA	Stock	0.3515	0.3533	0.3508	0.3525	23906480.0
2013-07-01 15:00:00	NVDA	Stock	0.3528	0.3533	0.3515	0.3524	62325080.0
2013-07-01 16:00:00	NVDA	Stock	0.3525	0.3525	0.351	0.3522	12474480.0
2013-07-01 08:00:00	AMZN	Stock	13.8845	13.9525	13.843	13.9425	169160.0
2013-07-01 09:00:00	AMZN	Stock	13.9515	14.034	13.858	14.0075	12047740.0
2013-07-01 10:00:00	AMZN	Stock	14.0075	14.063	13.988	13.9985	8662340.0
2013-07-01 11:00:00	AMZN	Stock	14.002	14.077	13.997	14.0735	5595880.0
2013-07-01 12:00:00	AMZN	Stock	14.071	14.112	14.0565	14.0985	5553820.0
2013-07-01 13:00:00	AMZN	Stock	14.0965	14.1645	14.0805	14.0897	5487160.0
2013-07-01 14:00:00	AMZN	Stock	14.087	14.144	14.0565	14.1438	4323400.0
2013-07-01 15:00:00	AMZN	Stock	14.1405	14.1495	14.055	14.105	8788000.0
2013-07-01 16:00:00	AMZN	Stock	14.105	14.109	13.8609	14.105	4794800.0
2013-07-01 17:00:00	AMZN	Stock	14.105	14.11	14.105	14.105	10500.0
2013-07-01 18:00:00	AMZN	Stock	14.1	14.1	14.1	14.1	4000.0
2013-07-01 19:00:00	AMZN	Stock	14.105	14.12	14.105	14.12	34500.0
2013-07-01 04:00:00	META	Stock	24.99	25.04	24.89	24.93	1316.0

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

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