PREVIEW / stock_1hour / 2015-02-03

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-02-03.parquet
  size:    1.1 MB
  rows:    49,506
  symbols: 3,535

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
2015-02-03 04:00:00	AAPL	Stock	29.66	29.74	29.66	29.6625	25216.0
2015-02-03 05:00:00	AAPL	Stock	29.665	29.72	29.6375	29.72	20204.0
2015-02-03 06:00:00	AAPL	Stock	29.65	29.7175	29.6375	29.6775	48536.0
2015-02-03 07:00:00	AAPL	Stock	29.6775	29.71	29.63	29.675	168648.0
2015-02-03 08:00:00	AAPL	Stock	29.6825	29.7175	29.6125	29.715	1112036.0
2015-02-03 09:00:00	AAPL	Stock	29.715	29.7725	29.5575	29.7125	31848200.0
2015-02-03 10:00:00	AAPL	Stock	29.7125	29.76	29.5275	29.535	36465960.0
2015-02-03 11:00:00	AAPL	Stock	29.531	29.5825	29.4525	29.4725	25443120.0
2015-02-03 12:00:00	AAPL	Stock	29.4575	29.565	29.4025	29.55	19388836.0
2015-02-03 13:00:00	AAPL	Stock	29.5512	29.613	29.5125	29.605	17104616.0
2015-02-03 14:00:00	AAPL	Stock	29.6042	29.62	29.525	29.605	15504404.0
2015-02-03 15:00:00	AAPL	Stock	29.605	29.695	29.5425	29.65	29113136.0
2015-02-03 16:00:00	AAPL	Stock	29.6625	29.7455	29.5615	29.5925	17865820.0
2015-02-03 17:00:00	AAPL	Stock	29.5925	29.6	29.58	29.5875	121844.0
2015-02-03 18:00:00	AAPL	Stock	29.595	29.6625	29.5825	29.6	133688.0
2015-02-03 19:00:00	AAPL	Stock	29.5925	29.6	29.5925	29.6	80436.0
2015-02-03 04:00:00	MSFT	Stock	41.4	41.5	41.4	41.4	5575.0
2015-02-03 05:00:00	MSFT	Stock	41.5	41.5	41.49	41.5	4100.0
2015-02-03 06:00:00	MSFT	Stock	41.49	41.5	41.49	41.5	1675.0
2015-02-03 07:00:00	MSFT	Stock	41.51	41.59	41.42	41.42	13911.0
2015-02-03 08:00:00	MSFT	Stock	41.42	41.59	41.38	41.45	23156.0
2015-02-03 09:00:00	MSFT	Stock	41.45	41.93	41.44	41.563	5897175.0
2015-02-03 10:00:00	MSFT	Stock	41.565	41.6	41.17	41.215	9561374.0
2015-02-03 11:00:00	MSFT	Stock	41.21	41.28	41.07	41.1	6644261.0
2015-02-03 12:00:00	MSFT	Stock	41.1	41.29	41.045	41.235	4122846.0
2015-02-03 13:00:00	MSFT	Stock	41.235	41.37	41.19	41.32	3588332.0
2015-02-03 14:00:00	MSFT	Stock	41.33	41.38	41.12	41.28	5686657.0
2015-02-03 15:00:00	MSFT	Stock	41.28	41.6	41.23	41.59	11662082.0
2015-02-03 16:00:00	MSFT	Stock	41.6	41.6	41.168	41.5	2974033.0
2015-02-03 17:00:00	MSFT	Stock	41.48	41.6	41.48	41.57	16582.0
2015-02-03 18:00:00	MSFT	Stock	41.5	41.6	41.5	41.52	8863.0
2015-02-03 19:00:00	MSFT	Stock	41.55	41.55	41.5	41.5	2634.0
2015-02-03 08:00:00	NVDA	Stock	0.4912	0.4912	0.4912	0.4912	32000.0
2015-02-03 09:00:00	NVDA	Stock	0.494	0.5032	0.4915	0.5032	33487720.0
2015-02-03 10:00:00	NVDA	Stock	0.503	0.5031	0.495	0.495	36854440.0
2015-02-03 11:00:00	NVDA	Stock	0.4948	0.499	0.4945	0.4975	17603320.0
2015-02-03 12:00:00	NVDA	Stock	0.4972	0.4982	0.496	0.4972	13018680.0
2015-02-03 13:00:00	NVDA	Stock	0.4972	0.4991	0.4963	0.499	11962960.0
2015-02-03 14:00:00	NVDA	Stock	0.4992	0.4996	0.4975	0.4991	12480320.0
2015-02-03 15:00:00	NVDA	Stock	0.4991	0.503	0.499	0.5026	38026920.0
2015-02-03 16:00:00	NVDA	Stock	0.5028	0.5031	0.4983	0.4983	10616680.0
2015-02-03 04:00:00	AMZN	Stock	18.195	18.195	18.195	18.195	14000.0
2015-02-03 07:00:00	AMZN	Stock	18.2005	18.2245	18.163	18.163	61640.0
2015-02-03 08:00:00	AMZN	Stock	18.2235	18.2235	18.1205	18.1205	669500.0
2015-02-03 09:00:00	AMZN	Stock	18.14	18.3908	18.0105	18.172	24917700.0
2015-02-03 10:00:00	AMZN	Stock	18.1715	18.319	18.0175	18.147	26822320.0
2015-02-03 11:00:00	AMZN	Stock	18.146	18.26	18.0812	18.114	13516880.0
2015-02-03 12:00:00	AMZN	Stock	18.114	18.23	18.0755	18.174	9430780.0
2015-02-03 13:00:00	AMZN	Stock	18.1737	18.187	18.0805	18.1105	8323500.0
2015-02-03 14:00:00	AMZN	Stock	18.115	18.25	18.0605	18.246	10181380.0

> showing 50 of 49,506 rows — these rows as CSV

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