PREVIEW / stock_1hour / 2018-09-10

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-09-10.parquet
  size:    1.1 MB
  rows:    49,049
  symbols: 2,772

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
2018-09-10 04:00:00	AAPL	Stock	55.25	55.475	55.25	55.375	89132.0
2018-09-10 05:00:00	AAPL	Stock	55.345	55.345	55.25	55.25	10908.0
2018-09-10 06:00:00	AAPL	Stock	55.1775	55.57	55.175	55.5	111628.0
2018-09-10 07:00:00	AAPL	Stock	55.48	55.6125	55.445	55.575	233876.0
2018-09-10 08:00:00	AAPL	Stock	55.4875	55.6225	55.45	55.465	562792.0
2018-09-10 09:00:00	AAPL	Stock	55.47	55.48	54.3065	54.7025	28044336.0
2018-09-10 10:00:00	AAPL	Stock	54.71	54.7925	54.1175	54.39	26687960.0
2018-09-10 11:00:00	AAPL	Stock	54.39	54.8775	54.265	54.84	17084708.0
2018-09-10 12:00:00	AAPL	Stock	54.8412	54.8425	54.2025	54.2738	13506672.0
2018-09-10 13:00:00	AAPL	Stock	54.27	54.6075	54.2612	54.575	8454584.0
2018-09-10 14:00:00	AAPL	Stock	54.5738	54.6875	54.5305	54.585	7229564.0
2018-09-10 15:00:00	AAPL	Stock	54.585	54.7475	54.5475	54.585	17085888.0
2018-09-10 16:00:00	AAPL	Stock	54.585	54.6025	54.5	54.545	14281192.0
2018-09-10 17:00:00	AAPL	Stock	54.54	54.6	54.53	54.6	39116.0
2018-09-10 18:00:00	AAPL	Stock	54.5875	54.69	54.5875	54.675	82212.0
2018-09-10 19:00:00	AAPL	Stock	54.6875	54.725	54.675	54.6775	36612.0
2018-09-10 04:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	106.0
2018-09-10 05:00:00	MSFT	Stock	108.89	108.89	108.89	108.89	411.0
2018-09-10 06:00:00	MSFT	Stock	108.89	109.03	108.89	108.9	1623.0
2018-09-10 07:00:00	MSFT	Stock	108.65	108.89	108.65	108.85	3458.0
2018-09-10 08:00:00	MSFT	Stock	108.88	108.95	108.74	108.85	12059.0
2018-09-10 09:00:00	MSFT	Stock	108.85	108.97	108.41	108.54	1974106.0
2018-09-10 10:00:00	MSFT	Stock	108.54	108.84	108.36	108.69	2113651.0
2018-09-10 11:00:00	MSFT	Stock	108.69	109.28	108.52	109.17	1807349.0
2018-09-10 12:00:00	MSFT	Stock	109.165	109.35	108.975	109.287	1270706.0
2018-09-10 13:00:00	MSFT	Stock	109.285	109.64	109.2	109.53	1433419.0
2018-09-10 14:00:00	MSFT	Stock	109.53	109.55	109.3	109.49	1094597.0
2018-09-10 15:00:00	MSFT	Stock	109.484	109.57	109.11	109.44	3599696.0
2018-09-10 16:00:00	MSFT	Stock	109.38	109.38	109.113	109.14	4629812.0
2018-09-10 17:00:00	MSFT	Stock	109.22	109.22	109.1	109.22	6897.0
2018-09-10 18:00:00	MSFT	Stock	109.22	109.22	109.15	109.21	12667.0
2018-09-10 19:00:00	MSFT	Stock	109.21	109.28	109.21	109.21	7009.0
2018-09-10 07:00:00	NVDA	Stock	6.8272	6.845	6.825	6.845	173640.0
2018-09-10 08:00:00	NVDA	Stock	6.8398	6.8625	6.8263	6.85	701600.0
2018-09-10 09:00:00	NVDA	Stock	6.8572	6.8575	6.7825	6.8128	30594040.0
2018-09-10 10:00:00	NVDA	Stock	6.8118	6.8823	6.775	6.8698	43004760.0
2018-09-10 11:00:00	NVDA	Stock	6.87	6.8983	6.8463	6.8755	27951120.0
2018-09-10 12:00:00	NVDA	Stock	6.875	6.8873	6.8588	6.875	13696880.0
2018-09-10 13:00:00	NVDA	Stock	6.8743	6.8758	6.8502	6.8602	13289800.0
2018-09-10 14:00:00	NVDA	Stock	6.8605	6.8785	6.8458	6.871	16546520.0
2018-09-10 15:00:00	NVDA	Stock	6.8712	6.886	6.857	6.8685	33089920.0
2018-09-10 16:00:00	NVDA	Stock	6.8682	6.8825	6.8625	6.8688	2093520.0
2018-09-10 17:00:00	NVDA	Stock	6.8688	6.8823	6.8685	6.8685	612000.0
2018-09-10 18:00:00	NVDA	Stock	6.8682	6.875	6.864	6.8682	95520.0
2018-09-10 19:00:00	NVDA	Stock	6.8688	6.8688	6.864	6.864	20920.0
2018-09-10 04:00:00	AMZN	Stock	98.3	98.3	98.3	98.3	2000.0
2018-09-10 05:00:00	AMZN	Stock	98.5155	98.5155	98.5155	98.5155	2000.0
2018-09-10 06:00:00	AMZN	Stock	98.45	98.55	98.45	98.475	10980.0
2018-09-10 07:00:00	AMZN	Stock	98.5	98.5	98.335	98.44	116700.0
2018-09-10 08:00:00	AMZN	Stock	98.4672	98.5	98.35	98.449	330780.0

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

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