PREVIEW / stock_1hour / 2016-05-06

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-05-06.parquet
  size:    1.0 MB
  rows:    47,729
  symbols: 3,288

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-05-06 04:00:00	AAPL	Stock	23.31	23.31	23.31	23.31	1168.0
2016-05-06 05:00:00	AAPL	Stock	23.37	23.37	23.37	23.37	1252.0
2016-05-06 06:00:00	AAPL	Stock	23.33	23.33	23.2875	23.3225	2400.0
2016-05-06 07:00:00	AAPL	Stock	23.335	23.3525	23.2875	23.2925	33004.0
2016-05-06 08:00:00	AAPL	Stock	23.315	23.3525	23.25	23.29	529044.0
2016-05-06 09:00:00	AAPL	Stock	23.29	23.3625	23.2025	23.265	15856916.0
2016-05-06 10:00:00	AAPL	Stock	23.2638	23.3575	23.1275	23.1625	22152312.0
2016-05-06 11:00:00	AAPL	Stock	23.1625	23.25	23.025	23.0487	23731188.0
2016-05-06 12:00:00	AAPL	Stock	23.0498	23.08	22.9975	23.0525	23178436.0
2016-05-06 13:00:00	AAPL	Stock	23.0538	23.1175	22.9625	23.0512	23360756.0
2016-05-06 14:00:00	AAPL	Stock	23.0525	23.2	23.0525	23.18	23086672.0
2016-05-06 15:00:00	AAPL	Stock	23.18	23.2	23.105	23.18	24743128.0
2016-05-06 16:00:00	AAPL	Stock	23.18	23.195	23.035	23.1825	7005764.0
2016-05-06 17:00:00	AAPL	Stock	23.18	23.1825	23.165	23.175	57264.0
2016-05-06 18:00:00	AAPL	Stock	23.175	23.1825	23.17	23.17	45328.0
2016-05-06 19:00:00	AAPL	Stock	23.17	23.185	23.165	23.1675	36292.0
2016-05-06 08:00:00	MSFT	Stock	49.78	49.85	49.63	49.7	23489.0
2016-05-06 09:00:00	MSFT	Stock	49.7	50.0	49.7	49.874	3265991.0
2016-05-06 10:00:00	MSFT	Stock	49.88	49.955	49.72	49.774	3935149.0
2016-05-06 11:00:00	MSFT	Stock	49.77	49.88	49.66	49.76	2604477.0
2016-05-06 12:00:00	MSFT	Stock	49.755	49.88	49.695	49.88	1877810.0
2016-05-06 13:00:00	MSFT	Stock	49.88	50.205	49.86	50.2	2305929.0
2016-05-06 14:00:00	MSFT	Stock	50.21	50.33	50.11	50.245	2835157.0
2016-05-06 15:00:00	MSFT	Stock	50.245	50.39	50.17	50.39	4859486.0
2016-05-06 16:00:00	MSFT	Stock	50.38	50.39	49.782	50.38	1705833.0
2016-05-06 17:00:00	MSFT	Stock	50.37	50.39	50.37	50.39	3654.0
2016-05-06 18:00:00	MSFT	Stock	50.39	50.39	50.36	50.36	1600.0
2016-05-06 19:00:00	MSFT	Stock	50.38	50.38	50.38	50.38	100.0
2016-05-06 07:00:00	NVDA	Stock	0.8792	0.8792	0.8792	0.8792	20000.0
2016-05-06 08:00:00	NVDA	Stock	0.8725	0.8725	0.871	0.871	20000.0
2016-05-06 09:00:00	NVDA	Stock	0.8712	0.88	0.8705	0.8766	14738680.0
2016-05-06 10:00:00	NVDA	Stock	0.8765	0.88	0.8711	0.8748	37838600.0
2016-05-06 11:00:00	NVDA	Stock	0.8748	0.8768	0.8718	0.8728	22153880.0
2016-05-06 12:00:00	NVDA	Stock	0.8728	0.8785	0.8725	0.8782	13252400.0
2016-05-06 13:00:00	NVDA	Stock	0.8783	0.8835	0.8778	0.8832	19933440.0
2016-05-06 14:00:00	NVDA	Stock	0.8832	0.8856	0.8824	0.8828	17733560.0
2016-05-06 15:00:00	NVDA	Stock	0.8825	0.8845	0.8818	0.8832	41492000.0
2016-05-06 16:00:00	NVDA	Stock	0.8832	0.8848	0.8789	0.8835	888480.0
2016-05-06 17:00:00	NVDA	Stock	0.8835	0.8835	0.8832	0.8835	48000.0
2016-05-06 18:00:00	NVDA	Stock	0.8855	0.8855	0.8838	0.8838	20000.0
2016-05-06 04:00:00	AMZN	Stock	33.35	33.35	33.35	33.35	2440.0
2016-05-06 06:00:00	AMZN	Stock	32.9455	33.05	32.9455	33.05	4000.0
2016-05-06 07:00:00	AMZN	Stock	32.902	32.902	32.828	32.875	10420.0
2016-05-06 08:00:00	AMZN	Stock	32.88	32.9015	32.7255	32.777	304280.0
2016-05-06 09:00:00	AMZN	Stock	32.777	33.1695	32.777	32.9148	9947200.0
2016-05-06 10:00:00	AMZN	Stock	32.921	33.194	32.8665	33.0445	11534960.0
2016-05-06 11:00:00	AMZN	Stock	33.035	33.1845	33.006	33.1065	6946080.0
2016-05-06 12:00:00	AMZN	Stock	33.105	33.3	33.0565	33.278	5280540.0
2016-05-06 13:00:00	AMZN	Stock	33.2795	33.545	33.2795	33.5392	12977220.0
2016-05-06 14:00:00	AMZN	Stock	33.542	33.8475	33.472	33.6	9936660.0

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

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