PREVIEW / stock_1hour / 2017-02-14

all stock 1-hour files

  file:    by_date/stock_1hour/2017/2017-02-14.parquet
  size:    1.1 MB
  rows:    48,528
  symbols: 3,102

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-02-14 04:00:00	AAPL	Stock	33.2675	33.3725	33.2675	33.3725	2296.0
2017-02-14 05:00:00	AAPL	Stock	33.3625	33.3625	33.3425	33.3425	8212.0
2017-02-14 06:00:00	AAPL	Stock	33.345	33.41	33.3425	33.385	24704.0
2017-02-14 07:00:00	AAPL	Stock	33.3625	33.42	33.3625	33.4	39820.0
2017-02-14 08:00:00	AAPL	Stock	33.395	33.4075	33.25	33.28	364372.0
2017-02-14 09:00:00	AAPL	Stock	33.3	33.435	33.2575	33.3938	15784420.0
2017-02-14 10:00:00	AAPL	Stock	33.3925	33.4675	33.34	33.435	15726320.0
2017-02-14 11:00:00	AAPL	Stock	33.435	33.5975	33.42	33.57	16187944.0
2017-02-14 12:00:00	AAPL	Stock	33.5725	33.675	33.5425	33.6625	9781704.0
2017-02-14 13:00:00	AAPL	Stock	33.6625	33.7375	33.655	33.7272	12590756.0
2017-02-14 14:00:00	AAPL	Stock	33.725	33.75	33.6875	33.715	11048856.0
2017-02-14 15:00:00	AAPL	Stock	33.715	33.7725	33.695	33.7525	22009764.0
2017-02-14 16:00:00	AAPL	Stock	33.7325	33.825	33.705	33.8225	10971132.0
2017-02-14 17:00:00	AAPL	Stock	33.8175	33.8725	33.795	33.805	484800.0
2017-02-14 18:00:00	AAPL	Stock	33.8125	33.855	33.775	33.82	184544.0
2017-02-14 19:00:00	AAPL	Stock	33.825	33.86	33.825	33.86	219356.0
2017-02-14 04:00:00	MSFT	Stock	64.5	64.5	64.5	64.5	200.0
2017-02-14 05:00:00	MSFT	Stock	64.5	64.5	64.5	64.5	284.0
2017-02-14 07:00:00	MSFT	Stock	64.48	64.5	64.48	64.5	1972.0
2017-02-14 08:00:00	MSFT	Stock	64.48	64.51	64.43	64.43	7720.0
2017-02-14 09:00:00	MSFT	Stock	64.44	64.72	64.185	64.25	2648236.0
2017-02-14 10:00:00	MSFT	Stock	64.245	64.28	64.02	64.21	2903032.0
2017-02-14 11:00:00	MSFT	Stock	64.2	64.29	64.1	64.21	1688882.0
2017-02-14 12:00:00	MSFT	Stock	64.215	64.4	64.19	64.36	1224423.0
2017-02-14 13:00:00	MSFT	Stock	64.357	64.43	64.33	64.41	1372190.0
2017-02-14 14:00:00	MSFT	Stock	64.404	64.49	64.34	64.374	1614594.0
2017-02-14 15:00:00	MSFT	Stock	64.38	64.58	64.32	64.57	4311227.0
2017-02-14 16:00:00	MSFT	Stock	64.57	64.6	64.54	64.54	2665834.0
2017-02-14 18:00:00	MSFT	Stock	64.54	64.54	64.51	64.51	1100.0
2017-02-14 19:00:00	MSFT	Stock	64.57	64.57	64.51	64.51	350.0
2017-02-14 04:00:00	NVDA	Stock	2.7068	2.71	2.6955	2.6955	24000.0
2017-02-14 05:00:00	NVDA	Stock	2.695	2.695	2.6912	2.6948	13000.0
2017-02-14 06:00:00	NVDA	Stock	2.6918	2.6948	2.6918	2.6948	30040.0
2017-02-14 07:00:00	NVDA	Stock	2.6948	2.7025	2.692	2.692	295680.0
2017-02-14 08:00:00	NVDA	Stock	2.6952	2.7	2.679	2.69	4361160.0
2017-02-14 09:00:00	NVDA	Stock	2.6912	2.7178	2.6573	2.689	215925720.0
2017-02-14 10:00:00	NVDA	Stock	2.689	2.7483	2.6808	2.7425	234809280.0
2017-02-14 11:00:00	NVDA	Stock	2.7423	2.7538	2.7325	2.7402	100773800.0
2017-02-14 12:00:00	NVDA	Stock	2.7406	2.745	2.7225	2.7284	58402840.0
2017-02-14 13:00:00	NVDA	Stock	2.7282	2.7425	2.7188	2.7278	58132520.0
2017-02-14 14:00:00	NVDA	Stock	2.728	2.7302	2.71	2.712	63881200.0
2017-02-14 15:00:00	NVDA	Stock	2.7121	2.7218	2.7112	2.7195	77469720.0
2017-02-14 16:00:00	NVDA	Stock	2.7195	2.7195	2.7163	2.7163	18158560.0
2017-02-14 17:00:00	NVDA	Stock	2.72	2.7228	2.72	2.722	200400.0
2017-02-14 18:00:00	NVDA	Stock	2.7202	2.7225	2.7195	2.7212	107160.0
2017-02-14 19:00:00	NVDA	Stock	2.7212	2.7225	2.7195	2.7223	70160.0
2017-02-14 04:00:00	AMZN	Stock	41.8	41.8	41.8	41.8	3440.0
2017-02-14 07:00:00	AMZN	Stock	41.871	41.88	41.8565	41.8565	8300.0
2017-02-14 08:00:00	AMZN	Stock	41.905	41.905	41.805	41.81	91280.0
2017-02-14 09:00:00	AMZN	Stock	41.777	41.892	41.7065	41.7755	6937840.0

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

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