PREVIEW / stock_1hour / 2021-09-20

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-09-20.parquet
  size:    1.5 MB
  rows:    68,450
  symbols: 2,708

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
2021-09-20 04:00:00	AAPL	Stock	144.96	144.96	144.2	144.24	93723.0
2021-09-20 05:00:00	AAPL	Stock	144.23	144.32	143.89	144.08	83328.0
2021-09-20 06:00:00	AAPL	Stock	144.1	144.4	144.09	144.23	50596.0
2021-09-20 07:00:00	AAPL	Stock	144.23	144.37	143.55	143.73	924341.0
2021-09-20 08:00:00	AAPL	Stock	143.73	144.38	142.96	143.45	1111471.0
2021-09-20 09:00:00	AAPL	Stock	143.44	144.84	143.06	143.84	16005546.0
2021-09-20 10:00:00	AAPL	Stock	143.85	143.96	142.48	142.75	15317147.0
2021-09-20 11:00:00	AAPL	Stock	142.73	143.325	142.48	142.5	9263021.0
2021-09-20 12:00:00	AAPL	Stock	142.497	142.74	142.09	142.2079	11065593.0
2021-09-20 13:00:00	AAPL	Stock	142.209	142.64	141.85	142.36	9369474.0
2021-09-20 14:00:00	AAPL	Stock	142.36	142.48	141.27	141.5	11739447.0
2021-09-20 15:00:00	AAPL	Stock	141.49	143.12	141.34	142.97	18750144.0
2021-09-20 16:00:00	AAPL	Stock	142.985	143.11	142.69	142.9	10734067.0
2021-09-20 17:00:00	AAPL	Stock	142.89	143.09	142.8	142.91	84201.0
2021-09-20 18:00:00	AAPL	Stock	142.9	143.02	142.88	142.88	57406.0
2021-09-20 19:00:00	AAPL	Stock	142.88	143.09	142.67	142.99	115231.0
2021-09-20 04:00:00	MSFT	Stock	297.96	297.96	296.13	297.15	18068.0
2021-09-20 05:00:00	MSFT	Stock	297.03	297.29	296.51	296.8	7714.0
2021-09-20 06:00:00	MSFT	Stock	296.8	297.59	296.8	296.94	15455.0
2021-09-20 07:00:00	MSFT	Stock	296.83	297.25	295.67	296.02	137349.0
2021-09-20 08:00:00	MSFT	Stock	296.511	297.08	295.3	296.0	131912.0
2021-09-20 09:00:00	MSFT	Stock	295.9	298.72	295.19	296.9	3172801.0
2021-09-20 10:00:00	MSFT	Stock	296.89	297.06	293.95	294.24	3099072.0
2021-09-20 11:00:00	MSFT	Stock	294.2	295.26	293.26	293.29	2189643.0
2021-09-20 12:00:00	MSFT	Stock	293.3	293.52	292.41	292.774	2028535.0
2021-09-20 13:00:00	MSFT	Stock	292.79	293.2867	291.88	292.68	2038804.0
2021-09-20 14:00:00	MSFT	Stock	292.69	292.9584	290.22	290.77	2844751.0
2021-09-20 15:00:00	MSFT	Stock	290.76	294.86	289.52	294.26	5669549.0
2021-09-20 16:00:00	MSFT	Stock	294.3	295.2	292.95	293.88	6280224.0
2021-09-20 17:00:00	MSFT	Stock	293.89	294.2	293.82	294.1	14550.0
2021-09-20 18:00:00	MSFT	Stock	294.07	294.2	293.88	294.0	9051.0
2021-09-20 19:00:00	MSFT	Stock	293.99	294.75	293.58	294.75	23059.0
2021-09-20 04:00:00	NVDA	Stock	21.67	21.67	21.45	21.506	183160.0
2021-09-20 05:00:00	NVDA	Stock	21.474	21.539	21.457	21.5	64630.0
2021-09-20 06:00:00	NVDA	Stock	21.499	21.528	21.45	21.474	70250.0
2021-09-20 07:00:00	NVDA	Stock	21.474	21.528	21.292	21.339	1079340.0
2021-09-20 08:00:00	NVDA	Stock	21.51	21.5453	21.034	21.132	2683540.0
2021-09-20 09:00:00	NVDA	Stock	21.12	21.433	20.793	21.394	48806760.0
2021-09-20 10:00:00	NVDA	Stock	21.394	21.409	20.968	20.995	43506270.0
2021-09-20 11:00:00	NVDA	Stock	20.996	21.199	20.91	21.0115	28842190.0
2021-09-20 12:00:00	NVDA	Stock	21.012	21.02	20.828	20.87	24207600.0
2021-09-20 13:00:00	NVDA	Stock	20.865	20.915	20.791	20.865	19266770.0
2021-09-20 14:00:00	NVDA	Stock	20.872	20.895	20.662	20.738	27310000.0
2021-09-20 15:00:00	NVDA	Stock	20.734	21.133	20.729	21.113	47587670.0
2021-09-20 16:00:00	NVDA	Stock	21.117	21.1415	21.052	21.112	22484610.0
2021-09-20 17:00:00	NVDA	Stock	21.104	21.173	21.104	21.165	108580.0
2021-09-20 18:00:00	NVDA	Stock	21.157	21.166	21.113	21.137	165700.0
2021-09-20 19:00:00	NVDA	Stock	21.13	21.166	21.055	21.166	460540.0
2021-09-20 04:00:00	AMZN	Stock	172.4165	172.4165	170.897	171.125	10000.0
2021-09-20 05:00:00	AMZN	Stock	171.0	171.0	170.85	170.85	4000.0

> showing 50 of 68,450 rows — these rows as CSV

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