PREVIEW / stock_1hour / 2016-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-06-07.parquet
  size:    1.0 MB
  rows:    48,765
  symbols: 3,315

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-06-07 04:00:00	AAPL	Stock	24.6925	24.7675	24.6925	24.7675	8400.0
2016-06-07 05:00:00	AAPL	Stock	24.7875	24.8175	24.7875	24.8175	7924.0
2016-06-07 06:00:00	AAPL	Stock	24.84	24.84	24.775	24.775	17236.0
2016-06-07 07:00:00	AAPL	Stock	24.7825	24.7875	24.76	24.775	74788.0
2016-06-07 08:00:00	AAPL	Stock	24.7875	24.795	24.745	24.7625	235500.0
2016-06-07 09:00:00	AAPL	Stock	24.7625	24.95	24.725	24.9375	15291148.0
2016-06-07 10:00:00	AAPL	Stock	24.94	24.9675	24.8203	24.8425	14849132.0
2016-06-07 11:00:00	AAPL	Stock	24.8425	24.8925	24.8125	24.8282	10301984.0
2016-06-07 12:00:00	AAPL	Stock	24.8275	24.875	24.8255	24.8612	6475928.0
2016-06-07 13:00:00	AAPL	Stock	24.8625	24.865	24.8225	24.8275	5489472.0
2016-06-07 14:00:00	AAPL	Stock	24.8275	24.87	24.7725	24.7875	6978944.0
2016-06-07 15:00:00	AAPL	Stock	24.7875	24.825	24.74	24.76	15797392.0
2016-06-07 16:00:00	AAPL	Stock	24.7575	24.9345	24.7575	24.7575	6639072.0
2016-06-07 17:00:00	AAPL	Stock	24.7575	24.76	24.745	24.75	44900.0
2016-06-07 18:00:00	AAPL	Stock	24.75	24.77	24.75	24.7575	9540.0
2016-06-07 19:00:00	AAPL	Stock	24.7575	24.7725	24.7375	24.75	62000.0
2016-06-07 08:00:00	MSFT	Stock	52.41	52.41	52.29	52.29	2300.0
2016-06-07 09:00:00	MSFT	Stock	52.27	52.62	52.15	52.575	1734758.0
2016-06-07 10:00:00	MSFT	Stock	52.58	52.7	52.48	52.685	2729928.0
2016-06-07 11:00:00	MSFT	Stock	52.68	52.73	52.405	52.445	2056325.0
2016-06-07 12:00:00	MSFT	Stock	52.44	52.52	52.39	52.51	1285336.0
2016-06-07 13:00:00	MSFT	Stock	52.515	52.53	52.38	52.395	1398935.0
2016-06-07 14:00:00	MSFT	Stock	52.394	52.425	52.27	52.321	1657895.0
2016-06-07 15:00:00	MSFT	Stock	52.32	52.355	52.1	52.1	5081991.0
2016-06-07 16:00:00	MSFT	Stock	52.1	52.15	52.1	52.14	2817457.0
2016-06-07 17:00:00	MSFT	Stock	52.1	52.1	52.03	52.1	3900.0
2016-06-07 18:00:00	MSFT	Stock	52.1	52.1	52.06	52.09	2700.0
2016-06-07 19:00:00	MSFT	Stock	52.07	52.07	52.07	52.07	200.0
2016-06-07 08:00:00	NVDA	Stock	1.1625	1.1625	1.1625	1.1625	4000.0
2016-06-07 09:00:00	NVDA	Stock	1.162	1.1695	1.1615	1.1682	25020280.0
2016-06-07 10:00:00	NVDA	Stock	1.1685	1.1685	1.1619	1.1626	22811680.0
2016-06-07 11:00:00	NVDA	Stock	1.1626	1.1642	1.1593	1.1605	31033080.0
2016-06-07 12:00:00	NVDA	Stock	1.1605	1.1628	1.16	1.1625	15944320.0
2016-06-07 13:00:00	NVDA	Stock	1.1628	1.165	1.16	1.1608	21497160.0
2016-06-07 14:00:00	NVDA	Stock	1.1609	1.1633	1.1598	1.1624	24453520.0
2016-06-07 15:00:00	NVDA	Stock	1.1622	1.1624	1.1578	1.1585	39493160.0
2016-06-07 16:00:00	NVDA	Stock	1.1582	1.163	1.1582	1.162	1392240.0
2016-06-07 17:00:00	NVDA	Stock	1.1582	1.1582	1.1582	1.1582	160000.0
2016-06-07 18:00:00	NVDA	Stock	1.1585	1.161	1.1582	1.161	23400.0
2016-06-07 19:00:00	NVDA	Stock	1.161	1.161	1.1592	1.1592	48000.0
2016-06-07 06:00:00	AMZN	Stock	36.5215	36.5495	36.5215	36.5485	26000.0
2016-06-07 07:00:00	AMZN	Stock	36.501	36.54	36.489	36.53	108980.0
2016-06-07 08:00:00	AMZN	Stock	36.5	36.5	36.413	36.474	723960.0
2016-06-07 09:00:00	AMZN	Stock	36.4735	36.525	36.2515	36.4045	7383340.0
2016-06-07 10:00:00	AMZN	Stock	36.4195	36.473	36.0275	36.1105	13660160.0
2016-06-07 11:00:00	AMZN	Stock	36.1105	36.25	36.1022	36.1995	6687020.0
2016-06-07 12:00:00	AMZN	Stock	36.2014	36.311	36.1608	36.2855	3217340.0
2016-06-07 13:00:00	AMZN	Stock	36.2855	36.304	36.1325	36.157	2686760.0
2016-06-07 14:00:00	AMZN	Stock	36.1735	36.222	36.115	36.1351	4526800.0
2016-06-07 15:00:00	AMZN	Stock	36.135	36.23	36.115	36.1895	6923980.0

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

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