PREVIEW / stock_1hour / 2019-11-07

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-11-07.parquet
  size:    1.1 MB
  rows:    50,862
  symbols: 2,526

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
2019-11-07 04:00:00	AAPL	Stock	64.54	64.7	64.4375	64.5525	75072.0
2019-11-07 05:00:00	AAPL	Stock	64.5625	64.595	64.5	64.5	39920.0
2019-11-07 06:00:00	AAPL	Stock	64.5175	64.525	64.5	64.5	16844.0
2019-11-07 07:00:00	AAPL	Stock	64.5	64.72	64.485	64.655	307888.0
2019-11-07 08:00:00	AAPL	Stock	64.6828	64.7175	64.51	64.63	468232.0
2019-11-07 09:00:00	AAPL	Stock	64.625	64.78	64.5275	64.616	11696296.0
2019-11-07 10:00:00	AAPL	Stock	64.6175	64.8975	64.5575	64.8525	13147324.0
2019-11-07 11:00:00	AAPL	Stock	64.855	65.01	64.7675	64.95	9054952.0
2019-11-07 12:00:00	AAPL	Stock	64.9625	65.0	64.83	64.9912	8194124.0
2019-11-07 13:00:00	AAPL	Stock	64.9925	65.075	64.9375	65.0425	7914928.0
2019-11-07 14:00:00	AAPL	Stock	65.045	65.0875	64.75	64.9662	9838152.0
2019-11-07 15:00:00	AAPL	Stock	64.9688	64.9975	64.5875	64.875	13358864.0
2019-11-07 16:00:00	AAPL	Stock	64.8575	64.8625	64.76	64.8125	4861360.0
2019-11-07 17:00:00	AAPL	Stock	64.8575	64.8575	64.7875	64.805	115652.0
2019-11-07 18:00:00	AAPL	Stock	64.8025	64.85	64.8025	64.825	66320.0
2019-11-07 19:00:00	AAPL	Stock	64.83	64.9	64.775	64.8625	68360.0
2019-11-07 04:00:00	MSFT	Stock	144.65	145.0	144.65	144.99	3539.0
2019-11-07 05:00:00	MSFT	Stock	144.99	144.99	144.93	144.93	800.0
2019-11-07 06:00:00	MSFT	Stock	144.83	144.83	144.7	144.8	885.0
2019-11-07 07:00:00	MSFT	Stock	144.63	144.65	144.51	144.58	23437.0
2019-11-07 08:00:00	MSFT	Stock	144.55	144.65	144.4	144.53	39476.0
2019-11-07 09:00:00	MSFT	Stock	144.43	144.87	143.67	144.69	2129037.0
2019-11-07 10:00:00	MSFT	Stock	144.69	144.88	144.54	144.737	1783584.0
2019-11-07 11:00:00	MSFT	Stock	144.74	144.85	144.38	144.77	1612899.0
2019-11-07 12:00:00	MSFT	Stock	144.78	144.83	144.51	144.75	1071295.0
2019-11-07 13:00:00	MSFT	Stock	144.746	144.746	144.58	144.71	964302.0
2019-11-07 14:00:00	MSFT	Stock	144.71	144.83	144.0	144.31	1763118.0
2019-11-07 15:00:00	MSFT	Stock	144.31	144.53	143.8	144.28	2752940.0
2019-11-07 16:00:00	MSFT	Stock	144.26	144.665	144.08	144.22	2730867.0
2019-11-07 17:00:00	MSFT	Stock	144.29	144.3	144.17	144.21	2801.0
2019-11-07 18:00:00	MSFT	Stock	144.26	144.37	144.22	144.33	8466.0
2019-11-07 19:00:00	MSFT	Stock	144.39	144.4	144.13	144.2	5845.0
2019-11-07 04:00:00	NVDA	Stock	5.2625	5.27	5.25	5.2698	93560.0
2019-11-07 05:00:00	NVDA	Stock	5.2725	5.2868	5.2653	5.2868	166680.0
2019-11-07 06:00:00	NVDA	Stock	5.2878	5.2898	5.2798	5.2875	69000.0
2019-11-07 07:00:00	NVDA	Stock	5.2775	5.2822	5.2613	5.2748	929880.0
2019-11-07 08:00:00	NVDA	Stock	5.2775	5.2838	5.2628	5.2733	2028760.0
2019-11-07 09:00:00	NVDA	Stock	5.27	5.2925	5.2198	5.2228	61567400.0
2019-11-07 10:00:00	NVDA	Stock	5.2256	5.2718	5.2238	5.2693	42064760.0
2019-11-07 11:00:00	NVDA	Stock	5.27	5.2775	5.2522	5.27	29745720.0
2019-11-07 12:00:00	NVDA	Stock	5.2705	5.274	5.2591	5.2722	16638560.0
2019-11-07 13:00:00	NVDA	Stock	5.2712	5.2722	5.2318	5.2358	20554640.0
2019-11-07 14:00:00	NVDA	Stock	5.2365	5.2485	5.1683	5.2031	31805440.0
2019-11-07 15:00:00	NVDA	Stock	5.2033	5.2102	5.1635	5.21	35588720.0
2019-11-07 16:00:00	NVDA	Stock	5.2085	5.2188	5.1833	5.2182	3322080.0
2019-11-07 17:00:00	NVDA	Stock	5.2188	5.225	5.2188	5.225	152040.0
2019-11-07 18:00:00	NVDA	Stock	5.225	5.2305	5.2202	5.2305	237240.0
2019-11-07 19:00:00	NVDA	Stock	5.2305	5.2312	5.2102	5.2102	232960.0
2019-11-07 04:00:00	AMZN	Stock	90.2	90.45	90.2	90.45	9840.0
2019-11-07 05:00:00	AMZN	Stock	90.383	90.383	90.383	90.383	5480.0

> showing 50 of 50,862 rows — these rows as CSV

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