PREVIEW / stock_1hour / 2015-04-27

all stock 1-hour files

  file:    by_date/stock_1hour/2015/2015-04-27.parquet
  size:    1.1 MB
  rows:    49,679
  symbols: 3,524

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-04-27 04:00:00	AAPL	Stock	32.745	32.8	32.7	32.775	89344.0
2015-04-27 05:00:00	AAPL	Stock	32.775	32.775	32.735	32.77	78784.0
2015-04-27 06:00:00	AAPL	Stock	32.775	32.7975	32.75	32.795	241316.0
2015-04-27 07:00:00	AAPL	Stock	32.795	32.93	32.785	32.9	784900.0
2015-04-27 08:00:00	AAPL	Stock	32.8975	33.12	32.625	33.0125	4063196.0
2015-04-27 09:00:00	AAPL	Stock	33.0125	33.25	32.99	33.244	52682072.0
2015-04-27 10:00:00	AAPL	Stock	33.245	33.2825	33.1425	33.1725	36213316.0
2015-04-27 11:00:00	AAPL	Stock	33.171	33.205	33.0875	33.1412	25284500.0
2015-04-27 12:00:00	AAPL	Stock	33.1412	33.23	33.13	33.19	23553348.0
2015-04-27 13:00:00	AAPL	Stock	33.19	33.19	33.0275	33.0625	25097496.0
2015-04-27 14:00:00	AAPL	Stock	33.0625	33.1125	32.7875	32.8975	47977952.0
2015-04-27 15:00:00	AAPL	Stock	32.8975	33.1725	32.8	33.1725	68252860.0
2015-04-27 16:00:00	AAPL	Stock	33.1625	34.0	32.4775	33.6625	50166316.0
2015-04-27 17:00:00	AAPL	Stock	33.6625	33.815	33.5325	33.6075	10046400.0
2015-04-27 18:00:00	AAPL	Stock	33.6	33.655	33.5625	33.61	2422672.0
2015-04-27 19:00:00	AAPL	Stock	33.6	33.6075	33.55	33.605	1384520.0
2015-04-27 04:00:00	MSFT	Stock	48.5	48.5	47.58	47.65	7930.0
2015-04-27 05:00:00	MSFT	Stock	47.57	47.65	47.5	47.57	3171.0
2015-04-27 06:00:00	MSFT	Stock	47.58	47.71	47.58	47.6	20628.0
2015-04-27 07:00:00	MSFT	Stock	47.65	47.7	47.6	47.67	31210.0
2015-04-27 08:00:00	MSFT	Stock	47.66	47.87	47.51	47.55	81538.0
2015-04-27 09:00:00	MSFT	Stock	47.55	47.7	47.2	47.665	9060559.0
2015-04-27 10:00:00	MSFT	Stock	47.66	47.74	47.28	47.54	8980298.0
2015-04-27 11:00:00	MSFT	Stock	47.55	47.88	47.49	47.81	7181123.0
2015-04-27 12:00:00	MSFT	Stock	47.817	48.13	47.72	47.755	7270464.0
2015-04-27 13:00:00	MSFT	Stock	47.755	47.99	47.73	47.86	5881743.0
2015-04-27 14:00:00	MSFT	Stock	47.86	48.0	47.815	47.9	4944491.0
2015-04-27 15:00:00	MSFT	Stock	47.9	48.03	47.81	48.03	9774705.0
2015-04-27 16:00:00	MSFT	Stock	48.03	48.03	47.501	47.94	3399110.0
2015-04-27 17:00:00	MSFT	Stock	47.96	47.99	47.95	47.97	13600.0
2015-04-27 18:00:00	MSFT	Stock	47.95	47.95	47.93	47.93	7445.0
2015-04-27 19:00:00	MSFT	Stock	47.93	48.0	47.93	47.99	20891.0
2015-04-27 07:00:00	NVDA	Stock	0.5472	0.5472	0.5472	0.5472	5600.0
2015-04-27 08:00:00	NVDA	Stock	0.5525	0.5528	0.5508	0.5528	675240.0
2015-04-27 09:00:00	NVDA	Stock	0.5535	0.562	0.5478	0.562	29756560.0
2015-04-27 10:00:00	NVDA	Stock	0.562	0.5648	0.558	0.5584	38203360.0
2015-04-27 11:00:00	NVDA	Stock	0.5582	0.5592	0.5562	0.5565	31004720.0
2015-04-27 12:00:00	NVDA	Stock	0.5568	0.5569	0.5531	0.5558	35704560.0
2015-04-27 13:00:00	NVDA	Stock	0.5558	0.557	0.5545	0.5548	13966760.0
2015-04-27 14:00:00	NVDA	Stock	0.5548	0.5558	0.5538	0.5555	17712240.0
2015-04-27 15:00:00	NVDA	Stock	0.5552	0.5558	0.553	0.555	49816640.0
2015-04-27 16:00:00	NVDA	Stock	0.5548	0.5594	0.5545	0.5594	18495320.0
2015-04-27 07:00:00	AMZN	Stock	22.3125	22.3125	22.15	22.15	132980.0
2015-04-27 08:00:00	AMZN	Stock	22.17	22.2655	22.15	22.262	396720.0
2015-04-27 09:00:00	AMZN	Stock	22.2625	22.3495	22.125	22.2375	23123880.0
2015-04-27 10:00:00	AMZN	Stock	22.2346	22.2885	22.084	22.145	20278780.0
2015-04-27 11:00:00	AMZN	Stock	22.1378	22.229	22.105	22.126	8077000.0
2015-04-27 12:00:00	AMZN	Stock	22.1254	22.1315	21.9575	21.985	11085600.0
2015-04-27 13:00:00	AMZN	Stock	21.9885	22.25	21.9515	22.0465	10460220.0
2015-04-27 14:00:00	AMZN	Stock	22.0455	22.0749	21.9855	22.017	7651860.0

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

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