PREVIEW / stock_1hour / 2017-01-10

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-01-10.parquet
  size:    1.0 MB
  rows:    48,411
  symbols: 3,120

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
2017-01-10 06:00:00	AAPL	Stock	29.7875	29.7875	29.7875	29.7875	1312.0
2017-01-10 07:00:00	AAPL	Stock	29.75	29.7925	29.75	29.775	18408.0
2017-01-10 08:00:00	AAPL	Stock	29.7825	29.7825	29.675	29.7375	189868.0
2017-01-10 09:00:00	AAPL	Stock	29.73	29.7425	29.575	29.695	16889836.0
2017-01-10 10:00:00	AAPL	Stock	29.695	29.7375	29.6275	29.685	14744560.0
2017-01-10 11:00:00	AAPL	Stock	29.685	29.845	29.685	29.7875	12882340.0
2017-01-10 12:00:00	AAPL	Stock	29.7865	29.83	29.77	29.78	6224832.0
2017-01-10 13:00:00	AAPL	Stock	29.7815	29.7975	29.7	29.71	7794928.0
2017-01-10 14:00:00	AAPL	Stock	29.7078	29.7975	29.6925	29.77	7805436.0
2017-01-10 15:00:00	AAPL	Stock	29.77	29.805	29.73	29.7775	11514224.0
2017-01-10 16:00:00	AAPL	Stock	29.7775	29.7875	29.7525	29.77	11792432.0
2017-01-10 17:00:00	AAPL	Stock	29.7675	29.7775	29.7675	29.7775	13220.0
2017-01-10 18:00:00	AAPL	Stock	29.765	29.765	29.7625	29.7625	8800.0
2017-01-10 19:00:00	AAPL	Stock	29.7625	29.7875	29.7525	29.7875	22940.0
2017-01-10 06:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	194.0
2017-01-10 07:00:00	MSFT	Stock	62.7	62.7	62.7	62.7	5585.0
2017-01-10 08:00:00	MSFT	Stock	62.71	62.74	62.65	62.65	12311.0
2017-01-10 09:00:00	MSFT	Stock	62.65	62.79	62.28	62.48	2233182.0
2017-01-10 10:00:00	MSFT	Stock	62.485	62.8	62.39	62.674	2881865.0
2017-01-10 11:00:00	MSFT	Stock	62.68	63.07	62.66	62.97	2009029.0
2017-01-10 12:00:00	MSFT	Stock	62.98	62.987	62.79	62.79	1366671.0
2017-01-10 13:00:00	MSFT	Stock	62.79	62.83	62.615	62.63	1261798.0
2017-01-10 14:00:00	MSFT	Stock	62.63	62.77	62.57	62.665	1698851.0
2017-01-10 15:00:00	MSFT	Stock	62.68	62.74	62.59	62.62	2276355.0
2017-01-10 16:00:00	MSFT	Stock	62.62	62.7	62.54	62.54	2697048.0
2017-01-10 17:00:00	MSFT	Stock	62.72	62.72	62.68	62.72	4884.0
2017-01-10 18:00:00	MSFT	Stock	62.66	62.71	62.66	62.71	370.0
2017-01-10 19:00:00	MSFT	Stock	62.66	62.7	62.66	62.7	300.0
2017-01-10 04:00:00	NVDA	Stock	2.7	2.7	2.7	2.7	4000.0
2017-01-10 06:00:00	NVDA	Stock	2.7048	2.7122	2.7048	2.7088	65920.0
2017-01-10 07:00:00	NVDA	Stock	2.7075	2.7095	2.695	2.7075	482520.0
2017-01-10 08:00:00	NVDA	Stock	2.7063	2.7095	2.6878	2.689	3039320.0
2017-01-10 09:00:00	NVDA	Stock	2.6938	2.7298	2.6645	2.6712	154487480.0
2017-01-10 10:00:00	NVDA	Stock	2.6722	2.725	2.6423	2.6875	180311720.0
2017-01-10 11:00:00	NVDA	Stock	2.6882	2.7082	2.6685	2.6718	90799800.0
2017-01-10 12:00:00	NVDA	Stock	2.6725	2.6843	2.6613	2.664	66576480.0
2017-01-10 13:00:00	NVDA	Stock	2.664	2.675	2.6493	2.656	56130760.0
2017-01-10 14:00:00	NVDA	Stock	2.6557	2.6608	2.6438	2.6448	58322560.0
2017-01-10 15:00:00	NVDA	Stock	2.6455	2.6653	2.6408	2.6618	89091720.0
2017-01-10 16:00:00	NVDA	Stock	2.6618	2.6778	2.6592	2.6625	149746840.0
2017-01-10 17:00:00	NVDA	Stock	2.6638	2.68	2.6605	2.6625	790160.0
2017-01-10 18:00:00	NVDA	Stock	2.6602	2.6602	2.6525	2.66	526240.0
2017-01-10 19:00:00	NVDA	Stock	2.6548	2.6592	2.6525	2.6525	188520.0
2017-01-10 08:00:00	AMZN	Stock	39.9	39.9	39.85	39.8515	70520.0
2017-01-10 09:00:00	AMZN	Stock	39.85	39.8735	39.55	39.6755	6842320.0
2017-01-10 10:00:00	AMZN	Stock	39.685	39.821	39.4772	39.62	10164780.0
2017-01-10 11:00:00	AMZN	Stock	39.6245	39.78	39.609	39.7375	6615400.0
2017-01-10 12:00:00	AMZN	Stock	39.75	39.8625	39.7395	39.8037	5177580.0
2017-01-10 13:00:00	AMZN	Stock	39.7983	39.9	39.775	39.7936	4822440.0
2017-01-10 14:00:00	AMZN	Stock	39.795	39.7995	39.6965	39.7825	4310880.0

> showing 50 of 48,411 rows — these rows as CSV

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