PREVIEW / stock_1hour / 2020-10-13

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-13.parquet
  size:    1.2 MB
  rows:    56,922
  symbols: 2,487

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-10-13 04:00:00	AAPL	Stock	124.84	126.18	124.5	126.05	277835.0
2020-10-13 05:00:00	AAPL	Stock	126.06	126.99	125.89	126.97	213494.0
2020-10-13 06:00:00	AAPL	Stock	126.97	127.32	126.21	126.5	367811.0
2020-10-13 07:00:00	AAPL	Stock	126.5	126.6	124.4	126.23	1285887.0
2020-10-13 08:00:00	AAPL	Stock	125.9	126.6	125.3	125.81	2567506.0
2020-10-13 09:00:00	AAPL	Stock	125.81	125.83	121.52	122.871	35128960.0
2020-10-13 10:00:00	AAPL	Stock	122.87	123.92	122.51	123.53	28110828.0
2020-10-13 11:00:00	AAPL	Stock	123.53	124.74	123.14	123.73	25179140.0
2020-10-13 12:00:00	AAPL	Stock	123.73	123.76	122.2	122.64	20229395.0
2020-10-13 13:00:00	AAPL	Stock	122.62	123.68	119.65	120.39	53267831.0
2020-10-13 14:00:00	AAPL	Stock	120.39	121.46	119.875	121.32	33157793.0
2020-10-13 15:00:00	AAPL	Stock	121.312	122.2	121.03	121.05	27857922.0
2020-10-13 16:00:00	AAPL	Stock	121.1	122.395	120.55	120.85	11038855.0
2020-10-13 17:00:00	AAPL	Stock	120.82	121.07	120.7	120.945	334914.0
2020-10-13 18:00:00	AAPL	Stock	120.94	121.48	120.88	121.22	409950.0
2020-10-13 19:00:00	AAPL	Stock	121.27	121.44	121.19	121.29	293598.0
2020-10-13 04:00:00	MSFT	Stock	220.48	222.38	220.48	222.37	3086.0
2020-10-13 05:00:00	MSFT	Stock	222.61	223.9	222.61	223.48	10608.0
2020-10-13 06:00:00	MSFT	Stock	223.8	224.82	223.22	223.68	23140.0
2020-10-13 07:00:00	MSFT	Stock	223.8	224.4	223.32	224.0	117301.0
2020-10-13 08:00:00	MSFT	Stock	223.852	224.4	220.85	222.781	123710.0
2020-10-13 09:00:00	MSFT	Stock	222.77	223.67	221.51	222.05	3163909.0
2020-10-13 10:00:00	MSFT	Stock	222.12	223.11	220.43	223.09	3107466.0
2020-10-13 11:00:00	MSFT	Stock	223.08	224.65	222.39	224.01	2816078.0
2020-10-13 12:00:00	MSFT	Stock	224.01	224.35	222.624	223.52	2000496.0
2020-10-13 13:00:00	MSFT	Stock	223.56	224.12	222.67	222.97	2181923.0
2020-10-13 14:00:00	MSFT	Stock	222.95	224.0	222.32	223.86	2041577.0
2020-10-13 15:00:00	MSFT	Stock	223.86	225.21	222.75	222.83	4777146.0
2020-10-13 16:00:00	MSFT	Stock	222.86	223.75	222.65	223.33	3983734.0
2020-10-13 17:00:00	MSFT	Stock	223.36	223.58	223.2	223.2	7074.0
2020-10-13 18:00:00	MSFT	Stock	223.2	223.83	223.15	223.65	8972.0
2020-10-13 19:00:00	MSFT	Stock	223.65	224.1	223.65	224.0	12987.0
2020-10-13 04:00:00	NVDA	Stock	14.175	14.275	14.175	14.275	57520.0
2020-10-13 05:00:00	NVDA	Stock	14.3445	14.4028	14.3423	14.3773	402720.0
2020-10-13 06:00:00	NVDA	Stock	14.4248	14.4718	14.35	14.3762	161080.0
2020-10-13 07:00:00	NVDA	Stock	14.3562	14.4685	14.3562	14.3938	1209160.0
2020-10-13 08:00:00	NVDA	Stock	14.3938	14.4685	14.3388	14.3388	2273840.0
2020-10-13 09:00:00	NVDA	Stock	14.3388	14.3388	14.0186	14.1437	62337280.0
2020-10-13 10:00:00	NVDA	Stock	14.1472	14.2368	14.0752	14.2274	51396400.0
2020-10-13 11:00:00	NVDA	Stock	14.2318	14.3485	14.2048	14.2165	37573040.0
2020-10-13 12:00:00	NVDA	Stock	14.2189	14.2555	14.1542	14.239	28966760.0
2020-10-13 13:00:00	NVDA	Stock	14.2423	14.264	14.1428	14.1493	24256280.0
2020-10-13 14:00:00	NVDA	Stock	14.1475	14.2375	14.129	14.227	24918120.0
2020-10-13 15:00:00	NVDA	Stock	14.2306	14.3312	14.224	14.2478	42666600.0
2020-10-13 16:00:00	NVDA	Stock	14.2482	14.2585	14.2263	14.25	5944600.0
2020-10-13 17:00:00	NVDA	Stock	14.2442	14.262	14.2408	14.262	109560.0
2020-10-13 18:00:00	NVDA	Stock	14.245	14.26	14.245	14.2562	83120.0
2020-10-13 19:00:00	NVDA	Stock	14.2713	14.2875	14.2588	14.285	162800.0
2020-10-13 04:00:00	AMZN	Stock	172.025	173.7	172.025	173.7	9920.0
2020-10-13 05:00:00	AMZN	Stock	174.161	174.45	174.16	174.4	51560.0

> showing 50 of 56,922 rows — these rows as CSV

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