PREVIEW / stock_1hour / 2020-02-06

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-02-06.parquet
  size:    1.2 MB
  rows:    51,309
  symbols: 2,416

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-02-06 04:00:00	AAPL	Stock	80.775	81.095	80.6975	80.6975	38784.0
2020-02-06 05:00:00	AAPL	Stock	80.675	80.775	80.675	80.7625	11132.0
2020-02-06 06:00:00	AAPL	Stock	80.75	80.875	80.75	80.875	34452.0
2020-02-06 07:00:00	AAPL	Stock	80.845	80.9925	80.72	80.75	157708.0
2020-02-06 08:00:00	AAPL	Stock	80.925	80.9825	80.575	80.6695	568992.0
2020-02-06 09:00:00	AAPL	Stock	80.6625	80.9225	80.0662	80.595	11755100.0
2020-02-06 10:00:00	AAPL	Stock	80.5925	80.625	80.0925	80.422	11736924.0
2020-02-06 11:00:00	AAPL	Stock	80.425	80.7125	80.33	80.4125	8285188.0
2020-02-06 12:00:00	AAPL	Stock	80.4112	80.895	80.385	80.8788	7808572.0
2020-02-06 13:00:00	AAPL	Stock	80.875	81.175	80.84	81.145	9331892.0
2020-02-06 14:00:00	AAPL	Stock	81.148	81.25	81.0	81.1288	9138060.0
2020-02-06 15:00:00	AAPL	Stock	81.1325	81.305	80.98	81.3025	14462264.0
2020-02-06 16:00:00	AAPL	Stock	81.3025	81.3625	81.2925	81.335	7738252.0
2020-02-06 17:00:00	AAPL	Stock	81.335	81.4325	81.335	81.3875	193512.0
2020-02-06 18:00:00	AAPL	Stock	81.41	81.4325	81.39	81.42	93452.0
2020-02-06 19:00:00	AAPL	Stock	81.42	81.425	81.2275	81.375	420092.0
2020-02-06 04:00:00	MSFT	Stock	181.01	182.39	181.01	181.55	9339.0
2020-02-06 05:00:00	MSFT	Stock	181.5	181.67	181.45	181.66	3495.0
2020-02-06 06:00:00	MSFT	Stock	181.5	181.93	181.46	181.78	5976.0
2020-02-06 07:00:00	MSFT	Stock	181.72	181.95	181.11	181.3	34955.0
2020-02-06 08:00:00	MSFT	Stock	181.79	181.9	180.83	181.0	84280.0
2020-02-06 09:00:00	MSFT	Stock	181.0	181.95	180.059	181.95	3600171.0
2020-02-06 10:00:00	MSFT	Stock	181.94	182.4	181.205	182.005	3285490.0
2020-02-06 11:00:00	MSFT	Stock	182.01	182.98	181.92	182.212	2541662.0
2020-02-06 12:00:00	MSFT	Stock	182.21	183.62	182.19	183.6	2219496.0
2020-02-06 13:00:00	MSFT	Stock	183.6	183.82	182.95	183.1	2328514.0
2020-02-06 14:00:00	MSFT	Stock	183.093	183.35	182.271	182.65	2433954.0
2020-02-06 15:00:00	MSFT	Stock	182.645	183.69	182.47	183.64	3744386.0
2020-02-06 16:00:00	MSFT	Stock	183.64	183.83	183.53	183.83	3664700.0
2020-02-06 17:00:00	MSFT	Stock	183.84	184.01	183.72	183.85	23626.0
2020-02-06 18:00:00	MSFT	Stock	183.89	183.96	183.8	183.96	14843.0
2020-02-06 19:00:00	MSFT	Stock	183.96	183.98	183.19	183.47	28639.0
2020-02-06 04:00:00	NVDA	Stock	6.3058	6.3272	6.301	6.301	88880.0
2020-02-06 05:00:00	NVDA	Stock	6.3	6.3	6.3	6.3	20000.0
2020-02-06 06:00:00	NVDA	Stock	6.3	6.3	6.3	6.3	13760.0
2020-02-06 07:00:00	NVDA	Stock	6.308	6.3223	6.3058	6.3058	254240.0
2020-02-06 08:00:00	NVDA	Stock	6.3219	6.3238	6.2705	6.275	1312760.0
2020-02-06 09:00:00	NVDA	Stock	6.2638	6.31	6.222	6.2812	36028400.0
2020-02-06 10:00:00	NVDA	Stock	6.2815	6.2943	6.2488	6.272	26402280.0
2020-02-06 11:00:00	NVDA	Stock	6.2703	6.307	6.2654	6.2938	22389560.0
2020-02-06 12:00:00	NVDA	Stock	6.2938	6.3468	6.2928	6.3285	24802800.0
2020-02-06 13:00:00	NVDA	Stock	6.3276	6.3378	6.3162	6.3348	15346440.0
2020-02-06 14:00:00	NVDA	Stock	6.335	6.3405	6.3132	6.3142	14787920.0
2020-02-06 15:00:00	NVDA	Stock	6.3142	6.3562	6.3125	6.3562	34738560.0
2020-02-06 16:00:00	NVDA	Stock	6.3561	6.3562	6.3181	6.355	10483160.0
2020-02-06 17:00:00	NVDA	Stock	6.3545	6.36	6.35	6.3515	148560.0
2020-02-06 18:00:00	NVDA	Stock	6.3562	6.37	6.3562	6.365	174840.0
2020-02-06 19:00:00	NVDA	Stock	6.3663	6.3672	6.35	6.35	193840.0
2020-02-06 04:00:00	AMZN	Stock	102.6505	102.6505	102.3225	102.3225	8700.0
2020-02-06 07:00:00	AMZN	Stock	102.475	102.555	102.391	102.4	38500.0

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

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