PREVIEW / stock_1hour / 2018-10-02

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-10-02.parquet
  size:    1.1 MB
  rows:    49,821
  symbols: 2,786

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-10-02 06:00:00	AAPL	Stock	56.4375	56.5625	56.4175	56.5175	49124.0
2018-10-02 07:00:00	AAPL	Stock	56.5375	56.6925	56.5125	56.66	136424.0
2018-10-02 08:00:00	AAPL	Stock	56.5562	56.95	56.5562	56.75	229568.0
2018-10-02 09:00:00	AAPL	Stock	56.77	57.335	56.6575	57.3075	13138764.0
2018-10-02 10:00:00	AAPL	Stock	57.31	57.3575	57.08	57.285	12785144.0
2018-10-02 11:00:00	AAPL	Stock	57.285	57.4625	57.18	57.4525	10843968.0
2018-10-02 12:00:00	AAPL	Stock	57.4525	57.5	57.2575	57.3	8250020.0
2018-10-02 13:00:00	AAPL	Stock	57.3025	57.46	57.2542	57.3825	5666672.0
2018-10-02 14:00:00	AAPL	Stock	57.381	57.5	57.3375	57.3962	6998108.0
2018-10-02 15:00:00	AAPL	Stock	57.3962	57.435	56.98	57.3225	15917272.0
2018-10-02 16:00:00	AAPL	Stock	57.3225	57.3625	57.1635	57.31	8612908.0
2018-10-02 17:00:00	AAPL	Stock	57.315	57.3225	57.275	57.29	15432.0
2018-10-02 18:00:00	AAPL	Stock	57.3125	57.3625	57.3125	57.36	23640.0
2018-10-02 19:00:00	AAPL	Stock	57.3475	57.375	57.2875	57.375	72252.0
2018-10-02 05:00:00	MSFT	Stock	115.25	115.25	115.25	115.25	475.0
2018-10-02 06:00:00	MSFT	Stock	115.37	115.38	115.37	115.38	500.0
2018-10-02 07:00:00	MSFT	Stock	115.37	115.44	115.15	115.44	3561.0
2018-10-02 08:00:00	MSFT	Stock	115.37	115.4	115.21	115.39	4136.0
2018-10-02 09:00:00	MSFT	Stock	115.3	115.5	114.44	115.132	2308742.0
2018-10-02 10:00:00	MSFT	Stock	115.14	115.59	114.98	115.38	2380034.0
2018-10-02 11:00:00	MSFT	Stock	115.38	115.84	115.26	115.755	1650319.0
2018-10-02 12:00:00	MSFT	Stock	115.76	115.84	115.26	115.41	1212029.0
2018-10-02 13:00:00	MSFT	Stock	115.41	115.74	115.375	115.495	891813.0
2018-10-02 14:00:00	MSFT	Stock	115.5	115.67	115.33	115.448	1188836.0
2018-10-02 15:00:00	MSFT	Stock	115.45	115.52	114.78	115.14	3653445.0
2018-10-02 16:00:00	MSFT	Stock	115.15	115.605	115.01	115.25	4967072.0
2018-10-02 17:00:00	MSFT	Stock	115.26	115.35	115.15	115.15	15241.0
2018-10-02 18:00:00	MSFT	Stock	115.08	115.2	115.07	115.07	2893.0
2018-10-02 19:00:00	MSFT	Stock	115.16	115.17	115.03	115.1	6196.0
2018-10-02 04:00:00	NVDA	Stock	7.2	7.2	7.1902	7.1902	66760.0
2018-10-02 05:00:00	NVDA	Stock	7.1708	7.1708	7.1502	7.1502	71640.0
2018-10-02 06:00:00	NVDA	Stock	7.1782	7.1782	7.1782	7.1782	4000.0
2018-10-02 07:00:00	NVDA	Stock	7.1888	7.2085	7.1655	7.1875	460840.0
2018-10-02 08:00:00	NVDA	Stock	7.1802	7.225	7.175	7.225	513920.0
2018-10-02 09:00:00	NVDA	Stock	7.2225	7.301	7.17	7.2962	63931040.0
2018-10-02 10:00:00	NVDA	Stock	7.2972	7.319	7.2528	7.3029	67216400.0
2018-10-02 11:00:00	NVDA	Stock	7.3028	7.3028	7.2275	7.2535	47922840.0
2018-10-02 12:00:00	NVDA	Stock	7.254	7.269	7.2175	7.2286	26233160.0
2018-10-02 13:00:00	NVDA	Stock	7.2298	7.247	7.2028	7.2092	15433920.0
2018-10-02 14:00:00	NVDA	Stock	7.2103	7.2145	7.1502	7.1535	38952920.0
2018-10-02 15:00:00	NVDA	Stock	7.1534	7.1688	7.1395	7.163	59060600.0
2018-10-02 16:00:00	NVDA	Stock	7.162	7.302	7.1603	7.1625	8791200.0
2018-10-02 17:00:00	NVDA	Stock	7.165	7.169	7.1628	7.1645	93960.0
2018-10-02 18:00:00	NVDA	Stock	7.164	7.1675	7.1495	7.1495	470680.0
2018-10-02 19:00:00	NVDA	Stock	7.15	7.17	7.1438	7.16	205720.0
2018-10-02 04:00:00	AMZN	Stock	100.25	100.25	99.9	99.9	16860.0
2018-10-02 05:00:00	AMZN	Stock	99.8	99.8	99.8	99.8	38200.0
2018-10-02 06:00:00	AMZN	Stock	99.8105	99.927	99.7	99.75	60120.0
2018-10-02 07:00:00	AMZN	Stock	99.887	99.9	99.6975	99.875	235000.0
2018-10-02 08:00:00	AMZN	Stock	99.87	100.47	99.68	99.9975	828500.0

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

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