PREVIEW / stock_1hour / 2014-06-06

all stock 1-hour files

  file:    by_date/stock_1hour/2014/2014-06-06.parquet
  size:    1.0 MB
  rows:    47,741
  symbols: 3,540

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
2014-06-06 04:00:00	AAPL	Stock	23.1714	23.1911	23.1539	23.1786	67200.0
2014-06-06 05:00:00	AAPL	Stock	23.1746	23.1786	23.1643	23.1786	22400.0
2014-06-06 06:00:00	AAPL	Stock	23.1896	23.1964	23.1714	23.1714	60788.0
2014-06-06 07:00:00	AAPL	Stock	23.1779	23.1779	23.1371	23.1611	537292.0
2014-06-06 08:00:00	AAPL	Stock	23.1554	23.1743	23.1089	23.1707	1717268.0
2014-06-06 09:00:00	AAPL	Stock	23.1711	23.2318	23.0668	23.1379	47912704.0
2014-06-06 10:00:00	AAPL	Stock	23.1418	23.1586	23.0536	23.1225	34466096.0
2014-06-06 11:00:00	AAPL	Stock	23.1225	23.212	23.1043	23.2032	31137904.0
2014-06-06 12:00:00	AAPL	Stock	23.2043	23.2593	23.1839	23.2046	35212744.0
2014-06-06 13:00:00	AAPL	Stock	23.2059	23.2071	23.0168	23.0607	41855604.0
2014-06-06 14:00:00	AAPL	Stock	23.0599	23.1829	23.0511	23.1575	27698104.0
2014-06-06 15:00:00	AAPL	Stock	23.1592	23.1607	23.0436	23.0561	52811052.0
2014-06-06 16:00:00	AAPL	Stock	23.0561	23.1554	23.0357	23.0639	15753752.0
2014-06-06 17:00:00	AAPL	Stock	23.0625	23.0714	23.055	23.0664	458024.0
2014-06-06 18:00:00	AAPL	Stock	23.0664	23.0725	23.0625	23.0643	148064.0
2014-06-06 19:00:00	AAPL	Stock	23.0629	23.0711	23.0536	23.0589	245532.0
2014-06-06 05:00:00	MSFT	Stock	41.24	41.24	41.24	41.24	300.0
2014-06-06 06:00:00	MSFT	Stock	41.2	41.2	41.2	41.2	500.0
2014-06-06 08:00:00	MSFT	Stock	41.2	41.38	41.2	41.3	11191.0
2014-06-06 09:00:00	MSFT	Stock	41.29	41.66	41.24	41.398	4400424.0
2014-06-06 10:00:00	MSFT	Stock	41.4	41.425	41.26	41.36	2527403.0
2014-06-06 11:00:00	MSFT	Stock	41.36	41.46	41.3	41.376	2081891.0
2014-06-06 12:00:00	MSFT	Stock	41.37	41.48	41.33	41.44	1347290.0
2014-06-06 13:00:00	MSFT	Stock	41.44	41.45	41.31	41.45	1588729.0
2014-06-06 14:00:00	MSFT	Stock	41.442	41.48	41.34	41.48	2223904.0
2014-06-06 15:00:00	MSFT	Stock	41.475	41.59	41.37	41.48	5264613.0
2014-06-06 16:00:00	MSFT	Stock	41.48	41.48	41.43	41.48	3457163.0
2014-06-06 17:00:00	MSFT	Stock	41.48	41.48	41.47	41.47	502.0
2014-06-06 18:00:00	MSFT	Stock	41.45	41.48	41.43	41.48	900.0
2014-06-06 09:00:00	NVDA	Stock	0.4763	0.4788	0.475	0.4779	27086720.0
2014-06-06 10:00:00	NVDA	Stock	0.4778	0.48	0.4768	0.4793	36067600.0
2014-06-06 11:00:00	NVDA	Stock	0.4791	0.4798	0.4758	0.4759	15107520.0
2014-06-06 12:00:00	NVDA	Stock	0.4758	0.4759	0.4745	0.4751	12821840.0
2014-06-06 13:00:00	NVDA	Stock	0.475	0.4755	0.4746	0.475	8593920.0
2014-06-06 14:00:00	NVDA	Stock	0.4748	0.4753	0.4745	0.4748	14233560.0
2014-06-06 15:00:00	NVDA	Stock	0.4749	0.476	0.4745	0.4758	34250880.0
2014-06-06 16:00:00	NVDA	Stock	0.4758	0.4765	0.475	0.4758	9340640.0
2014-06-06 05:00:00	AMZN	Stock	16.288	16.2995	16.288	16.2995	4000.0
2014-06-06 06:00:00	AMZN	Stock	16.2815	16.2815	16.2	16.2675	15880.0
2014-06-06 07:00:00	AMZN	Stock	16.2535	16.2645	16.245	16.25	73480.0
2014-06-06 08:00:00	AMZN	Stock	16.2285	16.2645	16.15	16.226	748040.0
2014-06-06 09:00:00	AMZN	Stock	16.2285	16.533	16.224	16.4911	30593540.0
2014-06-06 10:00:00	AMZN	Stock	16.4915	16.5	16.295	16.4585	21317620.0
2014-06-06 11:00:00	AMZN	Stock	16.4675	16.544	16.4305	16.45	11287440.0
2014-06-06 12:00:00	AMZN	Stock	16.45	16.477	16.3926	16.463	6855600.0
2014-06-06 13:00:00	AMZN	Stock	16.4635	16.5	16.42	16.4712	5306580.0
2014-06-06 14:00:00	AMZN	Stock	16.468	16.5175	16.45	16.4915	5126260.0
2014-06-06 15:00:00	AMZN	Stock	16.4875	16.507	16.431	16.4825	11811740.0
2014-06-06 16:00:00	AMZN	Stock	16.4835	16.4835	16.4315	16.478	879500.0
2014-06-06 17:00:00	AMZN	Stock	16.4825	16.4875	16.48	16.4835	1525340.0

> showing 50 of 47,741 rows — these rows as CSV

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