PREVIEW / stock_1hour / 2018-03-27

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-03-27.parquet
  size:    1.1 MB
  rows:    49,262
  symbols: 2,877

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-03-27 04:00:00	AAPL	Stock	43.325	43.55	43.325	43.55	30784.0
2018-03-27 05:00:00	AAPL	Stock	43.55	43.57	43.5175	43.57	13684.0
2018-03-27 06:00:00	AAPL	Stock	43.565	43.62	43.49	43.49	38220.0
2018-03-27 07:00:00	AAPL	Stock	43.465	43.675	43.465	43.535	251316.0
2018-03-27 08:00:00	AAPL	Stock	43.627	43.68	43.3475	43.3875	520388.0
2018-03-27 09:00:00	AAPL	Stock	43.38	43.7875	43.3475	43.66	21444244.0
2018-03-27 10:00:00	AAPL	Stock	43.66	43.6675	43.29	43.3725	15679008.0
2018-03-27 11:00:00	AAPL	Stock	43.3675	43.6525	43.2225	43.5808	12281944.0
2018-03-27 12:00:00	AAPL	Stock	43.585	43.665	43.1525	43.3073	12210752.0
2018-03-27 13:00:00	AAPL	Stock	43.31	43.405	42.8375	42.9388	13085936.0
2018-03-27 14:00:00	AAPL	Stock	42.94	42.9475	42.42	42.4735	20974648.0
2018-03-27 15:00:00	AAPL	Stock	42.4675	42.5075	41.73	42.0875	35132636.0
2018-03-27 16:00:00	AAPL	Stock	42.0875	42.885	42.085	42.12	10223336.0
2018-03-27 17:00:00	AAPL	Stock	42.12	42.12	42.0025	42.1125	5171964.0
2018-03-27 18:00:00	AAPL	Stock	42.11	42.16	42.0625	42.1375	54512.0
2018-03-27 19:00:00	AAPL	Stock	42.1425	42.1875	42.1	42.1875	34396.0
2018-03-27 04:00:00	MSFT	Stock	94.31	94.86	94.31	94.85	9105.0
2018-03-27 05:00:00	MSFT	Stock	94.85	94.97	94.76	94.85	11482.0
2018-03-27 06:00:00	MSFT	Stock	94.85	94.89	94.65	94.65	3726.0
2018-03-27 07:00:00	MSFT	Stock	94.7	94.99	94.55	94.78	43090.0
2018-03-27 08:00:00	MSFT	Stock	94.9	94.97	94.5	94.638	103319.0
2018-03-27 09:00:00	MSFT	Stock	94.6	95.139	94.231	94.65	6391263.0
2018-03-27 10:00:00	MSFT	Stock	94.66	94.85	93.86	93.94	5654684.0
2018-03-27 11:00:00	MSFT	Stock	93.93	94.31	93.41	94.13	3740741.0
2018-03-27 12:00:00	MSFT	Stock	94.14	94.14	92.75	92.96	3621606.0
2018-03-27 13:00:00	MSFT	Stock	92.96	93.21	91.93	92.28	4429250.0
2018-03-27 14:00:00	MSFT	Stock	92.275	92.4	91.2	91.28	5222853.0
2018-03-27 15:00:00	MSFT	Stock	91.28	91.3	88.51	89.48	15425683.0
2018-03-27 16:00:00	MSFT	Stock	89.47	89.85	89.47	89.71	4473665.0
2018-03-27 17:00:00	MSFT	Stock	89.64	89.64	89.47	89.63	493113.0
2018-03-27 18:00:00	MSFT	Stock	89.5	89.63	89.38	89.6	17424.0
2018-03-27 19:00:00	MSFT	Stock	89.67	89.8	89.5	89.8	20094.0
2018-03-27 04:00:00	NVDA	Stock	6.1212	6.1535	6.1212	6.1535	52240.0
2018-03-27 05:00:00	NVDA	Stock	6.165	6.1773	6.165	6.1773	51240.0
2018-03-27 06:00:00	NVDA	Stock	6.175	6.175	6.1588	6.1588	76240.0
2018-03-27 07:00:00	NVDA	Stock	6.1665	6.1935	6.1588	6.1825	1594400.0
2018-03-27 08:00:00	NVDA	Stock	6.1845	6.1962	6.16	6.1603	2452080.0
2018-03-27 09:00:00	NVDA	Stock	6.1675	6.247	6.1398	6.2433	105590680.0
2018-03-27 10:00:00	NVDA	Stock	6.2445	6.25	6.1288	6.1359	103235280.0
2018-03-27 11:00:00	NVDA	Stock	6.1362	6.2038	6.1112	6.1328	69765520.0
2018-03-27 12:00:00	NVDA	Stock	6.133	6.1618	5.8182	5.8915	312452120.0
2018-03-27 13:00:00	NVDA	Stock	5.8945	5.945	5.8062	5.8397	135951880.0
2018-03-27 14:00:00	NVDA	Stock	5.8358	5.898	5.6443	5.6908	244137080.0
2018-03-27 15:00:00	NVDA	Stock	5.6914	5.6984	5.4961	5.6378	379721120.0
2018-03-27 16:00:00	NVDA	Stock	5.6375	5.6825	5.6	5.6088	8241640.0
2018-03-27 17:00:00	NVDA	Stock	5.6125	5.638	5.6038	5.6343	19964680.0
2018-03-27 18:00:00	NVDA	Stock	5.6373	5.6438	5.6125	5.638	1599520.0
2018-03-27 19:00:00	NVDA	Stock	5.633	5.675	5.633	5.6675	1328600.0
2018-03-27 04:00:00	AMZN	Stock	78.65	78.65	78.5	78.5155	18960.0
2018-03-27 05:00:00	AMZN	Stock	78.55	78.7675	78.55	78.7675	20820.0

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

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