PREVIEW / stock_1hour / 2016-02-05

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-02-05.parquet
  size:    1.0 MB
  rows:    47,954
  symbols: 3,344

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
2016-02-05 04:00:00	AAPL	Stock	24.1925	24.1925	24.19	24.19	2000.0
2016-02-05 05:00:00	AAPL	Stock	24.1625	24.225	24.1625	24.225	4760.0
2016-02-05 06:00:00	AAPL	Stock	24.2325	24.2325	24.17	24.17	5016.0
2016-02-05 07:00:00	AAPL	Stock	24.22	24.2475	24.2025	24.2025	17240.0
2016-02-05 08:00:00	AAPL	Stock	24.18	24.2275	24.025	24.1225	325656.0
2016-02-05 09:00:00	AAPL	Stock	24.1	24.23	23.9375	24.0175	17889360.0
2016-02-05 10:00:00	AAPL	Stock	24.0162	24.0675	23.745	23.7725	28758944.0
2016-02-05 11:00:00	AAPL	Stock	23.775	23.8575	23.721	23.8025	21056252.0
2016-02-05 12:00:00	AAPL	Stock	23.8	23.895	23.725	23.7825	15035984.0
2016-02-05 13:00:00	AAPL	Stock	23.7812	23.8225	23.6548	23.6825	14414072.0
2016-02-05 14:00:00	AAPL	Stock	23.6802	23.73	23.5025	23.5525	22493296.0
2016-02-05 15:00:00	AAPL	Stock	23.554	23.6775	23.4225	23.5025	39491144.0
2016-02-05 16:00:00	AAPL	Stock	23.505	23.5375	23.4875	23.5	8050300.0
2016-02-05 17:00:00	AAPL	Stock	23.5	23.51	23.4875	23.4925	107160.0
2016-02-05 18:00:00	AAPL	Stock	23.4975	23.4975	23.475	23.4775	27012.0
2016-02-05 19:00:00	AAPL	Stock	23.4775	23.4875	23.4675	23.4875	59696.0
2016-02-05 07:00:00	MSFT	Stock	51.9	51.9	51.79	51.82	1400.0
2016-02-05 08:00:00	MSFT	Stock	51.87	52.0	51.68	51.8	47151.0
2016-02-05 09:00:00	MSFT	Stock	51.75	52.0	51.41	51.48	5793995.0
2016-02-05 10:00:00	MSFT	Stock	51.48	51.75	50.87	50.91	5904848.0
2016-02-05 11:00:00	MSFT	Stock	50.905	50.975	50.295	50.82	5855962.0
2016-02-05 12:00:00	MSFT	Stock	50.82	50.87	50.39	50.56	4975117.0
2016-02-05 13:00:00	MSFT	Stock	50.56	50.56	50.035	50.065	5090570.0
2016-02-05 14:00:00	MSFT	Stock	50.065	50.19	49.66	49.725	9826575.0
2016-02-05 15:00:00	MSFT	Stock	49.73	50.23	49.56	50.16	15721112.0
2016-02-05 16:00:00	MSFT	Stock	50.16	50.3	50.15	50.16	3340181.0
2016-02-05 17:00:00	MSFT	Stock	50.16	50.2	50.15	50.16	5536.0
2016-02-05 18:00:00	MSFT	Stock	50.15	50.2	50.15	50.2	8447.0
2016-02-05 19:00:00	MSFT	Stock	50.19	50.19	50.15	50.15	1300.0
2016-02-05 08:00:00	NVDA	Stock	0.7028	0.7052	0.7028	0.7052	132680.0
2016-02-05 09:00:00	NVDA	Stock	0.7005	0.7083	0.6915	0.6916	24898560.0
2016-02-05 10:00:00	NVDA	Stock	0.6918	0.6932	0.6775	0.6778	76826400.0
2016-02-05 11:00:00	NVDA	Stock	0.6778	0.6782	0.6695	0.6708	61133840.0
2016-02-05 12:00:00	NVDA	Stock	0.6709	0.6753	0.6696	0.6718	50985520.0
2016-02-05 13:00:00	NVDA	Stock	0.6718	0.6738	0.67	0.6716	46117960.0
2016-02-05 14:00:00	NVDA	Stock	0.6716	0.6722	0.665	0.6669	64106520.0
2016-02-05 15:00:00	NVDA	Stock	0.6669	0.6673	0.6588	0.6608	149293560.0
2016-02-05 16:00:00	NVDA	Stock	0.6608	0.6795	0.6593	0.66	84820240.0
2016-02-05 17:00:00	NVDA	Stock	0.6625	0.6625	0.6625	0.6625	32000.0
2016-02-05 18:00:00	NVDA	Stock	0.6608	0.6608	0.6608	0.6608	20000.0
2016-02-05 19:00:00	NVDA	Stock	0.6625	0.6625	0.6625	0.6625	8000.0
2016-02-05 08:00:00	AMZN	Stock	26.65	26.813	26.433	26.5	259260.0
2016-02-05 09:00:00	AMZN	Stock	26.5	26.6555	25.6235	25.8075	30252380.0
2016-02-05 10:00:00	AMZN	Stock	25.7985	25.863	25.2895	25.3	34440140.0
2016-02-05 11:00:00	AMZN	Stock	25.3035	25.5495	25.09	25.548	26643680.0
2016-02-05 12:00:00	AMZN	Stock	25.534	25.6225	25.3376	25.394	13217480.0
2016-02-05 13:00:00	AMZN	Stock	25.3805	25.419	25.11	25.1785	14618120.0
2016-02-05 14:00:00	AMZN	Stock	25.17	25.2275	24.9595	25.0371	23404520.0
2016-02-05 15:00:00	AMZN	Stock	25.05	25.24	25.0	25.1005	24916140.0
2016-02-05 16:00:00	AMZN	Stock	25.099	25.1725	25.015	25.1	1140120.0

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

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