PREVIEW / stock_1hour / 2020-03-12

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-12.parquet
  size:    1.3 MB
  rows:    58,275
  symbols: 2,488

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
2020-03-12 04:00:00	AAPL	Stock	65.95	66.185	65.0575	65.275	270736.0
2020-03-12 05:00:00	AAPL	Stock	65.275	65.355	64.8775	65.125	173440.0
2020-03-12 06:00:00	AAPL	Stock	65.0675	65.375	64.9975	65.375	115644.0
2020-03-12 07:00:00	AAPL	Stock	65.4025	65.7475	64.275	64.325	1207728.0
2020-03-12 08:00:00	AAPL	Stock	64.35	65.4338	63.75	64.02	2138840.0
2020-03-12 09:00:00	AAPL	Stock	64.1	64.71	62.595	64.6825	40465420.0
2020-03-12 10:00:00	AAPL	Stock	64.6775	65.6	63.3775	64.85	53295920.0
2020-03-12 11:00:00	AAPL	Stock	64.855	64.8675	62.75	63.1562	35932948.0
2020-03-12 12:00:00	AAPL	Stock	63.15	65.03	62.3825	64.475	44270288.0
2020-03-12 13:00:00	AAPL	Stock	64.482	67.5	63.7625	64.8225	50449740.0
2020-03-12 14:00:00	AAPL	Stock	64.815	64.9625	63.1925	63.43	34926848.0
2020-03-12 15:00:00	AAPL	Stock	63.435	64.5125	62.0	62.0	54484200.0
2020-03-12 16:00:00	AAPL	Stock	62.0	62.8562	60.825	60.875	23240244.0
2020-03-12 17:00:00	AAPL	Stock	60.875	60.9275	59.45	59.9575	1568492.0
2020-03-12 18:00:00	AAPL	Stock	60.0	60.9875	59.6	60.585	1186292.0
2020-03-12 19:00:00	AAPL	Stock	60.5025	60.65	58.8775	59.1625	708744.0
2020-03-12 04:00:00	MSFT	Stock	147.88	148.45	146.1	146.5	71873.0
2020-03-12 05:00:00	MSFT	Stock	146.54	146.8	146.0	146.06	36004.0
2020-03-12 06:00:00	MSFT	Stock	146.1	146.81	145.8	146.6	40799.0
2020-03-12 07:00:00	MSFT	Stock	146.51	147.4	145.12	145.12	271433.0
2020-03-12 08:00:00	MSFT	Stock	147.0	147.2	143.5	145.5	442371.0
2020-03-12 09:00:00	MSFT	Stock	145.5	149.93	141.59	147.26	9500956.0
2020-03-12 10:00:00	MSFT	Stock	147.25	147.51	143.53	146.52	12072296.0
2020-03-12 11:00:00	MSFT	Stock	146.555	146.6	141.74	143.23	8164463.0
2020-03-12 12:00:00	MSFT	Stock	143.2	149.93	141.07	148.06	8466269.0
2020-03-12 13:00:00	MSFT	Stock	148.064	153.47	143.91	147.262	7711419.0
2020-03-12 14:00:00	MSFT	Stock	147.25	147.88	142.91	143.17	6253873.0
2020-03-12 15:00:00	MSFT	Stock	143.24	145.16	138.58	138.76	16225644.0
2020-03-12 16:00:00	MSFT	Stock	138.97	139.64	137.3	137.4	10858613.0
2020-03-12 17:00:00	MSFT	Stock	137.4	137.88	135.0	135.2	127407.0
2020-03-12 18:00:00	MSFT	Stock	135.19	139.06	135.19	137.1	284714.0
2020-03-12 19:00:00	MSFT	Stock	137.1	137.25	134.86	135.4	82412.0
2020-03-12 04:00:00	NVDA	Stock	5.8725	5.9125	5.8025	5.8068	956360.0
2020-03-12 05:00:00	NVDA	Stock	5.8212	5.8425	5.8	5.8425	126120.0
2020-03-12 06:00:00	NVDA	Stock	5.8212	5.8422	5.8125	5.8422	314040.0
2020-03-12 07:00:00	NVDA	Stock	5.8505	5.8623	5.659	5.6595	2389120.0
2020-03-12 08:00:00	NVDA	Stock	5.6583	5.8375	5.6255	5.6688	4854480.0
2020-03-12 09:00:00	NVDA	Stock	5.6625	5.865	5.575	5.8588	93095880.0
2020-03-12 10:00:00	NVDA	Stock	5.859	5.903	5.7353	5.8108	135863440.0
2020-03-12 11:00:00	NVDA	Stock	5.814	5.8142	5.5355	5.542	87937320.0
2020-03-12 12:00:00	NVDA	Stock	5.542	5.745	5.4408	5.7163	96172720.0
2020-03-12 13:00:00	NVDA	Stock	5.7102	5.8975	5.567	5.7004	84692920.0
2020-03-12 14:00:00	NVDA	Stock	5.7025	5.723	5.52	5.5583	55193920.0
2020-03-12 15:00:00	NVDA	Stock	5.5555	5.6663	5.395	5.4009	131069000.0
2020-03-12 16:00:00	NVDA	Stock	5.4078	5.4748	5.2625	5.3125	51812600.0
2020-03-12 17:00:00	NVDA	Stock	5.2875	5.29	5.0508	5.1562	2114200.0
2020-03-12 18:00:00	NVDA	Stock	5.175	5.4078	5.1325	5.24	2264040.0
2020-03-12 19:00:00	NVDA	Stock	5.2538	5.2625	5.1575	5.175	998800.0
2020-03-12 04:00:00	AMZN	Stock	87.5	87.503	87.042	87.2005	79740.0
2020-03-12 05:00:00	AMZN	Stock	87.182	87.222	86.45	86.7415	176340.0

> showing 50 of 58,275 rows — these rows as CSV

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