PREVIEW / stock_1hour / 2020-12-17

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-12-17.parquet
  size:    1.4 MB
  rows:    63,458
  symbols: 2,687

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-12-17 04:00:00	AAPL	Stock	128.2	128.5	128.2	128.4	21180.0
2020-12-17 05:00:00	AAPL	Stock	128.4	128.42	128.15	128.27	5070.0
2020-12-17 06:00:00	AAPL	Stock	128.29	128.34	128.16	128.18	9242.0
2020-12-17 07:00:00	AAPL	Stock	128.16	128.54	128.16	128.47	201829.0
2020-12-17 08:00:00	AAPL	Stock	128.4	128.59	127.59	128.57	388876.0
2020-12-17 09:00:00	AAPL	Stock	128.58	129.58	128.52	128.941	14207085.0
2020-12-17 10:00:00	AAPL	Stock	128.955	129.2	128.19	128.781	13120358.0
2020-12-17 11:00:00	AAPL	Stock	128.79	129.04	128.045	128.39	8865771.0
2020-12-17 12:00:00	AAPL	Stock	128.4	128.57	128.143	128.471	7013761.0
2020-12-17 13:00:00	AAPL	Stock	128.48	128.71	128.28	128.455	5605779.0
2020-12-17 14:00:00	AAPL	Stock	128.46	128.54	128.12	128.455	6322438.0
2020-12-17 15:00:00	AAPL	Stock	128.459	128.83	128.24	128.65	10492181.0
2020-12-17 16:00:00	AAPL	Stock	128.65	128.75	128.53	128.57	9815105.0
2020-12-17 17:00:00	AAPL	Stock	128.58	128.59	128.27	128.41	89101.0
2020-12-17 18:00:00	AAPL	Stock	128.42	128.59	128.33	128.45	61183.0
2020-12-17 19:00:00	AAPL	Stock	128.42	128.52	128.31	128.35	59116.0
2020-12-17 04:00:00	MSFT	Stock	219.9	220.73	219.9	220.71	2888.0
2020-12-17 05:00:00	MSFT	Stock	220.62	220.62	220.2	220.2	1042.0
2020-12-17 06:00:00	MSFT	Stock	220.12	220.3	219.7	219.74	6584.0
2020-12-17 07:00:00	MSFT	Stock	219.86	220.0	219.64	219.9	33684.0
2020-12-17 08:00:00	MSFT	Stock	219.8	219.95	218.82	219.686	47290.0
2020-12-17 09:00:00	MSFT	Stock	219.63	220.89	219.23	219.56	3195630.0
2020-12-17 10:00:00	MSFT	Stock	219.56	219.64	218.07	218.138	4276805.0
2020-12-17 11:00:00	MSFT	Stock	218.13	218.66	217.92	218.65	2432430.0
2020-12-17 12:00:00	MSFT	Stock	218.66	218.95	218.28	218.87	1797205.0
2020-12-17 13:00:00	MSFT	Stock	218.88	219.72	218.88	219.33	1925805.0
2020-12-17 14:00:00	MSFT	Stock	219.32	219.35	218.48	218.66	1673079.0
2020-12-17 15:00:00	MSFT	Stock	218.66	219.5	218.27	219.42	3335707.0
2020-12-17 16:00:00	MSFT	Stock	219.42	219.68	219.25	219.36	6432027.0
2020-12-17 17:00:00	MSFT	Stock	219.31	219.31	217.5	218.2	45642.0
2020-12-17 18:00:00	MSFT	Stock	218.25	218.73	218.14	218.4	23395.0
2020-12-17 19:00:00	MSFT	Stock	218.4	218.5	218.01	218.5	9437.0
2020-12-17 05:00:00	NVDA	Stock	13.2812	13.2812	13.275	13.275	19600.0
2020-12-17 06:00:00	NVDA	Stock	13.3135	13.3135	13.3135	13.3135	4000.0
2020-12-17 07:00:00	NVDA	Stock	13.3	13.321	13.3	13.32	129880.0
2020-12-17 08:00:00	NVDA	Stock	13.3125	13.3341	13.2755	13.325	733360.0
2020-12-17 09:00:00	NVDA	Stock	13.325	13.3795	13.2632	13.2741	27587080.0
2020-12-17 10:00:00	NVDA	Stock	13.277	13.3477	13.2423	13.2502	32456920.0
2020-12-17 11:00:00	NVDA	Stock	13.2505	13.286	13.1785	13.2282	24011680.0
2020-12-17 12:00:00	NVDA	Stock	13.23	13.29	13.2122	13.2674	14292320.0
2020-12-17 13:00:00	NVDA	Stock	13.2677	13.3158	13.2645	13.3112	11658360.0
2020-12-17 14:00:00	NVDA	Stock	13.3095	13.352	13.3008	13.3099	14223640.0
2020-12-17 15:00:00	NVDA	Stock	13.309	13.3452	13.2645	13.3438	26863440.0
2020-12-17 16:00:00	NVDA	Stock	13.3412	13.3625	13.3251	13.3428	29563880.0
2020-12-17 17:00:00	NVDA	Stock	13.3355	13.3395	13.325	13.3378	136800.0
2020-12-17 18:00:00	NVDA	Stock	13.3363	13.3375	13.3262	13.3312	120640.0
2020-12-17 19:00:00	NVDA	Stock	13.3355	13.3465	13.3338	13.34	174280.0
2020-12-17 06:00:00	AMZN	Stock	162.799	162.799	162.7	162.7	4000.0
2020-12-17 07:00:00	AMZN	Stock	162.5995	162.5995	162.35	162.55	95880.0
2020-12-17 08:00:00	AMZN	Stock	162.4001	162.55	162.048	162.5	130640.0

> showing 50 of 63,458 rows — these rows as CSV

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