PREVIEW / stock_1hour / 2019-07-19

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-07-19.parquet
  size:    1.1 MB
  rows:    49,542
  symbols: 2,576

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-07-19 04:00:00	AAPL	Stock	51.5875	51.675	51.5325	51.5325	11656.0
2019-07-19 05:00:00	AAPL	Stock	51.525	51.575	51.505	51.505	32056.0
2019-07-19 06:00:00	AAPL	Stock	51.4975	51.4975	51.3	51.39	20796.0
2019-07-19 07:00:00	AAPL	Stock	51.4625	51.48	51.39	51.4	107760.0
2019-07-19 08:00:00	AAPL	Stock	51.4275	51.5175	51.39	51.5175	195068.0
2019-07-19 09:00:00	AAPL	Stock	51.4975	51.645	51.1725	51.2775	12520060.0
2019-07-19 10:00:00	AAPL	Stock	51.2788	51.395	51.1575	51.24	8963984.0
2019-07-19 11:00:00	AAPL	Stock	51.245	51.33	51.0675	51.1425	7258464.0
2019-07-19 12:00:00	AAPL	Stock	51.14	51.2875	51.1325	51.2463	4378876.0
2019-07-19 13:00:00	AAPL	Stock	51.2475	51.25	51.14	51.207	4206744.0
2019-07-19 14:00:00	AAPL	Stock	51.2078	51.245	50.86	50.935	6811444.0
2019-07-19 15:00:00	AAPL	Stock	50.9325	50.9325	50.59	50.6425	13570308.0
2019-07-19 16:00:00	AAPL	Stock	50.6475	50.6475	50.5875	50.6175	6273864.0
2019-07-19 17:00:00	AAPL	Stock	50.6175	50.625	50.5625	50.6	193040.0
2019-07-19 18:00:00	AAPL	Stock	50.6	50.64	50.59	50.61	28124.0
2019-07-19 19:00:00	AAPL	Stock	50.61	50.625	50.5775	50.6	44076.0
2019-07-19 04:00:00	MSFT	Stock	140.26	141.15	140.2	141.05	21091.0
2019-07-19 05:00:00	MSFT	Stock	141.08	141.4	141.0	141.39	9825.0
2019-07-19 06:00:00	MSFT	Stock	141.25	141.3	141.0	141.07	40598.0
2019-07-19 07:00:00	MSFT	Stock	141.1	141.1	140.23	140.85	180327.0
2019-07-19 08:00:00	MSFT	Stock	140.95	141.1	139.64	140.34	586048.0
2019-07-19 09:00:00	MSFT	Stock	140.26	141.0	138.88	139.335	10076745.0
2019-07-19 10:00:00	MSFT	Stock	139.33	139.67	138.46	138.63	5954463.0
2019-07-19 11:00:00	MSFT	Stock	138.63	139.2	138.04	138.25	4304848.0
2019-07-19 12:00:00	MSFT	Stock	138.26	138.77	138.12	138.635	2749327.0
2019-07-19 13:00:00	MSFT	Stock	138.64	138.68	137.62	137.84	2911469.0
2019-07-19 14:00:00	MSFT	Stock	137.84	137.895	136.61	137.0	4249387.0
2019-07-19 15:00:00	MSFT	Stock	137.0	137.11	136.45	136.62	6308811.0
2019-07-19 16:00:00	MSFT	Stock	136.62	136.78	136.1	136.11	4470432.0
2019-07-19 17:00:00	MSFT	Stock	136.12	136.55	136.08	136.36	24874.0
2019-07-19 18:00:00	MSFT	Stock	136.45	136.45	136.3	136.39	6629.0
2019-07-19 19:00:00	MSFT	Stock	136.39	136.55	136.32	136.49	15031.0
2019-07-19 05:00:00	NVDA	Stock	4.2825	4.2825	4.2825	4.2825	4000.0
2019-07-19 06:00:00	NVDA	Stock	4.2765	4.2775	4.2635	4.2635	34120.0
2019-07-19 07:00:00	NVDA	Stock	4.265	4.2705	4.265	4.2705	48760.0
2019-07-19 08:00:00	NVDA	Stock	4.265	4.2812	4.2625	4.2812	936600.0
2019-07-19 09:00:00	NVDA	Stock	4.2815	4.2995	4.262	4.2741	51619360.0
2019-07-19 10:00:00	NVDA	Stock	4.2738	4.282	4.2525	4.2743	50999720.0
2019-07-19 11:00:00	NVDA	Stock	4.2748	4.2889	4.253	4.2711	39628960.0
2019-07-19 12:00:00	NVDA	Stock	4.2715	4.2842	4.2678	4.274	26235760.0
2019-07-19 13:00:00	NVDA	Stock	4.2748	4.2768	4.2658	4.2765	20866880.0
2019-07-19 14:00:00	NVDA	Stock	4.2765	4.28	4.245	4.246	38423120.0
2019-07-19 15:00:00	NVDA	Stock	4.2453	4.2453	4.205	4.211	61620800.0
2019-07-19 16:00:00	NVDA	Stock	4.211	4.211	4.1825	4.1825	29492000.0
2019-07-19 17:00:00	NVDA	Stock	4.1825	4.1925	4.1763	4.1763	737960.0
2019-07-19 18:00:00	NVDA	Stock	4.1805	4.1875	4.1805	4.1875	512960.0
2019-07-19 19:00:00	NVDA	Stock	4.1855	4.187	4.18	4.184	196600.0
2019-07-19 04:00:00	AMZN	Stock	99.8	99.85	99.769	99.769	11000.0
2019-07-19 05:00:00	AMZN	Stock	99.65	99.65	99.65	99.65	3720.0
2019-07-19 06:00:00	AMZN	Stock	99.45	99.45	99.45	99.45	2000.0

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

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