PREVIEW / stock_1hour / 2016-11-01

all stock 1-hour files

  file:    by_date/stock_1hour/2016/2016-11-01.parquet
  size:    1.0 MB
  rows:    47,328
  symbols: 3,167

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-11-01 05:00:00	AAPL	Stock	28.445	28.445	28.445	28.445	400.0
2016-11-01 07:00:00	AAPL	Stock	28.425	28.4375	28.4125	28.4125	24972.0
2016-11-01 08:00:00	AAPL	Stock	28.435	28.435	28.35	28.3875	142932.0
2016-11-01 09:00:00	AAPL	Stock	28.3875	28.4425	28.245	28.2612	13640536.0
2016-11-01 10:00:00	AAPL	Stock	28.2625	28.3	28.1275	28.1975	19778116.0
2016-11-01 11:00:00	AAPL	Stock	28.1975	28.21	28.0525	28.0675	16340088.0
2016-11-01 12:00:00	AAPL	Stock	28.0675	28.07	27.9225	27.95	20292708.0
2016-11-01 13:00:00	AAPL	Stock	27.9475	27.95	27.7	27.81	21991368.0
2016-11-01 14:00:00	AAPL	Stock	27.81	27.8325	27.6325	27.755	24094996.0
2016-11-01 15:00:00	AAPL	Stock	27.7525	27.875	27.725	27.8725	30841360.0
2016-11-01 16:00:00	AAPL	Stock	27.8575	27.8875	27.8575	27.8625	10787380.0
2016-11-01 17:00:00	AAPL	Stock	27.865	27.89	27.8575	27.8575	64224.0
2016-11-01 18:00:00	AAPL	Stock	27.86	27.8875	27.825	27.825	78920.0
2016-11-01 19:00:00	AAPL	Stock	27.8275	27.8675	27.8275	27.85	50580.0
2016-11-01 07:00:00	MSFT	Stock	60.1	60.1	60.08	60.08	500.0
2016-11-01 08:00:00	MSFT	Stock	60.03	60.03	60.03	60.03	1938.0
2016-11-01 09:00:00	MSFT	Stock	60.15	60.15	59.88	59.92	2693065.0
2016-11-01 10:00:00	MSFT	Stock	59.93	59.99	59.81	59.98	3334878.0
2016-11-01 11:00:00	MSFT	Stock	59.98	60.01	59.84	59.87	1879738.0
2016-11-01 12:00:00	MSFT	Stock	59.88	59.89	59.65	59.725	2468039.0
2016-11-01 13:00:00	MSFT	Stock	59.73	59.79	59.41	59.47	2436799.0
2016-11-01 14:00:00	MSFT	Stock	59.47	59.64	59.25	59.54	2977845.0
2016-11-01 15:00:00	MSFT	Stock	59.53	59.9	59.385	59.8	5089976.0
2016-11-01 16:00:00	MSFT	Stock	59.8	59.81	59.74	59.75	1680920.0
2016-11-01 17:00:00	MSFT	Stock	59.78	59.78	59.72	59.78	4508.0
2016-11-01 18:00:00	MSFT	Stock	59.79	59.8	59.75	59.75	2771.0
2016-11-01 19:00:00	MSFT	Stock	59.8	59.8	59.79	59.79	600.0
2016-11-01 06:00:00	NVDA	Stock	1.7805	1.7805	1.7805	1.7805	4000.0
2016-11-01 07:00:00	NVDA	Stock	1.797	1.797	1.797	1.797	8000.0
2016-11-01 08:00:00	NVDA	Stock	1.7875	1.7875	1.7852	1.7852	71160.0
2016-11-01 09:00:00	NVDA	Stock	1.7872	1.7953	1.7688	1.7695	34743360.0
2016-11-01 10:00:00	NVDA	Stock	1.7695	1.7784	1.755	1.7615	52663560.0
2016-11-01 11:00:00	NVDA	Stock	1.7613	1.7655	1.7556	1.7573	47748040.0
2016-11-01 12:00:00	NVDA	Stock	1.7573	1.7575	1.7369	1.742	45337480.0
2016-11-01 13:00:00	NVDA	Stock	1.742	1.7436	1.7168	1.7195	36430440.0
2016-11-01 14:00:00	NVDA	Stock	1.7195	1.7228	1.7072	1.7132	49029840.0
2016-11-01 15:00:00	NVDA	Stock	1.713	1.7278	1.7095	1.7268	75295600.0
2016-11-01 16:00:00	NVDA	Stock	1.7262	1.7413	1.7262	1.7298	7603880.0
2016-11-01 17:00:00	NVDA	Stock	1.7292	1.7348	1.7292	1.7325	96320.0
2016-11-01 18:00:00	NVDA	Stock	1.7343	1.7348	1.729	1.729	156200.0
2016-11-01 19:00:00	NVDA	Stock	1.7288	1.7325	1.7288	1.7325	118880.0
2016-11-01 05:00:00	AMZN	Stock	39.5125	39.5125	39.5	39.5	14000.0
2016-11-01 06:00:00	AMZN	Stock	39.596	39.6005	39.596	39.6005	6000.0
2016-11-01 07:00:00	AMZN	Stock	39.6625	39.6845	39.6	39.6275	81220.0
2016-11-01 08:00:00	AMZN	Stock	39.65	39.997	39.62	39.9055	1125980.0
2016-11-01 09:00:00	AMZN	Stock	39.9075	40.042	39.677	39.768	16824020.0
2016-11-01 10:00:00	AMZN	Stock	39.758	39.7749	39.4055	39.524	18917380.0
2016-11-01 11:00:00	AMZN	Stock	39.528	39.5985	39.4325	39.5103	9503340.0
2016-11-01 12:00:00	AMZN	Stock	39.5035	39.512	39.23	39.2985	10060720.0
2016-11-01 13:00:00	AMZN	Stock	39.2925	39.35	39.094	39.1165	10066160.0

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

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