PREVIEW / stock_1hour / 2018-12-21

all stock 1-hour files

  file:    by_date/stock_1hour/2018/2018-12-21.parquet
  size:    1.1 MB
  rows:    51,168
  symbols: 2,746

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-12-21 04:00:00	AAPL	Stock	39.25	39.25	39.0675	39.1175	7336.0
2018-12-21 05:00:00	AAPL	Stock	39.125	39.255	39.1175	39.255	10192.0
2018-12-21 06:00:00	AAPL	Stock	39.3025	39.3625	39.3025	39.3625	15164.0
2018-12-21 07:00:00	AAPL	Stock	39.335	39.365	39.1	39.2075	168908.0
2018-12-21 08:00:00	AAPL	Stock	39.2125	39.55	39.1025	39.375	1379448.0
2018-12-21 09:00:00	AAPL	Stock	39.4	39.54	38.775	39.2975	53906576.0
2018-12-21 10:00:00	AAPL	Stock	39.3	39.44	38.8825	39.01	28225876.0
2018-12-21 11:00:00	AAPL	Stock	39.005	39.0175	38.5475	38.6025	28805224.0
2018-12-21 12:00:00	AAPL	Stock	38.605	38.62	38.015	38.4575	33010492.0
2018-12-21 13:00:00	AAPL	Stock	38.4552	38.58	38.1125	38.2048	19293712.0
2018-12-21 14:00:00	AAPL	Stock	38.2075	38.4125	38.035	38.1075	19278240.0
2018-12-21 15:00:00	AAPL	Stock	38.105	38.1525	37.4075	37.69	54472016.0
2018-12-21 16:00:00	AAPL	Stock	37.68	37.7775	37.55	37.66	93199800.0
2018-12-21 17:00:00	AAPL	Stock	37.6575	37.7	37.55	37.61	378072.0
2018-12-21 18:00:00	AAPL	Stock	37.585	37.6	37.525	37.535	92616.0
2018-12-21 19:00:00	AAPL	Stock	37.5375	37.5625	37.5	37.525	145648.0
2018-12-21 04:00:00	MSFT	Stock	102.3	102.3	101.7	101.8	2479.0
2018-12-21 06:00:00	MSFT	Stock	102.09	102.35	102.09	102.25	1624.0
2018-12-21 07:00:00	MSFT	Stock	102.02	102.1	101.59	101.92	14935.0
2018-12-21 08:00:00	MSFT	Stock	101.92	102.69	101.59	102.39	58738.0
2018-12-21 09:00:00	MSFT	Stock	102.39	103.0	100.28	100.65	19244654.0
2018-12-21 10:00:00	MSFT	Stock	100.66	102.65	99.98	101.58	8694137.0
2018-12-21 11:00:00	MSFT	Stock	101.58	101.6	100.21	100.36	5508411.0
2018-12-21 12:00:00	MSFT	Stock	100.36	100.41	98.13	99.45	9717002.0
2018-12-21 13:00:00	MSFT	Stock	99.45	100.24	99.16	99.62	6469625.0
2018-12-21 14:00:00	MSFT	Stock	99.625	99.93	98.6	99.03	5683067.0
2018-12-21 15:00:00	MSFT	Stock	99.03	99.2	97.46	98.18	13798449.0
2018-12-21 16:00:00	MSFT	Stock	98.23	98.75	98.1	98.75	30034562.0
2018-12-21 17:00:00	MSFT	Stock	98.64	98.64	98.23	98.49	58697.0
2018-12-21 18:00:00	MSFT	Stock	98.25	98.25	98.0	98.06	7802.0
2018-12-21 19:00:00	MSFT	Stock	98.2	98.38	98.05	98.08	7729.0
2018-12-21 04:00:00	NVDA	Stock	3.3775	3.3918	3.375	3.3918	25960.0
2018-12-21 05:00:00	NVDA	Stock	3.3912	3.3912	3.3775	3.3775	34960.0
2018-12-21 06:00:00	NVDA	Stock	3.3908	3.3908	3.385	3.385	8000.0
2018-12-21 07:00:00	NVDA	Stock	3.3812	3.3925	3.375	3.3875	422400.0
2018-12-21 08:00:00	NVDA	Stock	3.3934	3.4215	3.3838	3.4062	2377840.0
2018-12-21 09:00:00	NVDA	Stock	3.4062	3.4432	3.3275	3.3403	110447960.0
2018-12-21 10:00:00	NVDA	Stock	3.3375	3.4005	3.2908	3.3465	103741400.0
2018-12-21 11:00:00	NVDA	Stock	3.348	3.348	3.2912	3.2943	68464040.0
2018-12-21 12:00:00	NVDA	Stock	3.2957	3.3058	3.2425	3.2795	93326760.0
2018-12-21 13:00:00	NVDA	Stock	3.2823	3.315	3.2695	3.2822	54347080.0
2018-12-21 14:00:00	NVDA	Stock	3.2815	3.3052	3.2455	3.2783	68757280.0
2018-12-21 15:00:00	NVDA	Stock	3.277	3.2815	3.2115	3.2395	153959520.0
2018-12-21 16:00:00	NVDA	Stock	3.2393	3.25	3.225	3.2403	19938400.0
2018-12-21 17:00:00	NVDA	Stock	3.245	3.2664	3.2225	3.225	796520.0
2018-12-21 18:00:00	NVDA	Stock	3.2248	3.2292	3.2178	3.225	308760.0
2018-12-21 19:00:00	NVDA	Stock	3.224	3.2325	3.2165	3.22	358720.0
2018-12-21 04:00:00	AMZN	Stock	73.1	73.293	73.1	73.293	4000.0
2018-12-21 05:00:00	AMZN	Stock	73.257	73.257	73.257	73.257	4000.0
2018-12-21 06:00:00	AMZN	Stock	73.5	73.588	73.5	73.5	10000.0

> showing 50 of 51,168 rows — these rows as CSV

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