PREVIEW / stock_1hour / 2021-01-26

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-01-26.parquet
  size:    1.4 MB
  rows:    67,518
  symbols: 2,723

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-01-26 04:00:00	AAPL	Stock	142.91	143.28	142.68	142.68	38313.0
2021-01-26 05:00:00	AAPL	Stock	142.78	143.12	142.78	143.12	22260.0
2021-01-26 06:00:00	AAPL	Stock	143.13	143.5	143.0	143.23	48262.0
2021-01-26 07:00:00	AAPL	Stock	143.25	143.77	143.15	143.26	434965.0
2021-01-26 08:00:00	AAPL	Stock	142.92	143.77	142.57	143.18	655113.0
2021-01-26 09:00:00	AAPL	Stock	143.19	144.3	141.37	143.05	17865112.0
2021-01-26 10:00:00	AAPL	Stock	143.04	143.22	141.89	142.7	14225171.0
2021-01-26 11:00:00	AAPL	Stock	142.69	143.18	141.83	141.92	10508317.0
2021-01-26 12:00:00	AAPL	Stock	141.93	142.45	141.91	142.2	7354658.0
2021-01-26 13:00:00	AAPL	Stock	142.211	143.2	142.04	142.962	7094673.0
2021-01-26 14:00:00	AAPL	Stock	142.965	143.37	142.63	142.91	7796525.0
2021-01-26 15:00:00	AAPL	Stock	142.92	143.32	142.76	143.185	10806824.0
2021-01-26 16:00:00	AAPL	Stock	143.18	145.0	143.16	144.27	6222135.0
2021-01-26 17:00:00	AAPL	Stock	144.25	144.95	144.19	144.92	493021.0
2021-01-26 18:00:00	AAPL	Stock	144.88	145.0	144.62	144.9	361629.0
2021-01-26 19:00:00	AAPL	Stock	144.91	145.07	144.76	145.02	412273.0
2021-01-26 04:00:00	MSFT	Stock	229.01	229.49	229.0	229.2	3243.0
2021-01-26 05:00:00	MSFT	Stock	229.44	229.88	229.44	229.7	886.0
2021-01-26 06:00:00	MSFT	Stock	229.8	230.75	229.75	230.3	27446.0
2021-01-26 07:00:00	MSFT	Stock	230.2	231.45	230.03	231.15	143338.0
2021-01-26 08:00:00	MSFT	Stock	229.53	233.0	228.96	231.92	239864.0
2021-01-26 09:00:00	MSFT	Stock	232.04	232.99	230.08	231.975	4838985.0
2021-01-26 10:00:00	MSFT	Stock	232.0	234.18	230.89	233.583	6058816.0
2021-01-26 11:00:00	MSFT	Stock	233.665	233.86	231.23	231.41	3500619.0
2021-01-26 12:00:00	MSFT	Stock	231.402	232.98	231.402	232.046	2826771.0
2021-01-26 13:00:00	MSFT	Stock	232.04	233.69	231.715	233.183	2473693.0
2021-01-26 14:00:00	MSFT	Stock	233.17	233.74	232.53	233.509	3060829.0
2021-01-26 15:00:00	MSFT	Stock	233.51	233.95	231.77	232.583	6314286.0
2021-01-26 16:00:00	MSFT	Stock	232.33	247.7	231.8	242.2	9465305.0
2021-01-26 17:00:00	MSFT	Stock	242.08	242.44	239.5	240.16	563183.0
2021-01-26 18:00:00	MSFT	Stock	240.28	245.0	240.21	241.91	534719.0
2021-01-26 19:00:00	MSFT	Stock	242.09	242.18	240.9	240.92	175130.0
2021-01-26 06:00:00	NVDA	Stock	13.6225	13.6225	13.6225	13.6225	4000.0
2021-01-26 07:00:00	NVDA	Stock	13.6128	13.6553	13.5975	13.6075	197000.0
2021-01-26 08:00:00	NVDA	Stock	13.6532	13.6872	13.55	13.5738	281720.0
2021-01-26 09:00:00	NVDA	Stock	13.605	13.6448	13.4375	13.5882	24892720.0
2021-01-26 10:00:00	NVDA	Stock	13.5931	13.6308	13.4925	13.5425	23116320.0
2021-01-26 11:00:00	NVDA	Stock	13.5555	13.5633	13.4576	13.4588	12533520.0
2021-01-26 12:00:00	NVDA	Stock	13.4586	13.528	13.4538	13.4788	12239320.0
2021-01-26 13:00:00	NVDA	Stock	13.4788	13.4895	13.46	13.4782	9164800.0
2021-01-26 14:00:00	NVDA	Stock	13.4782	13.485	13.428	13.4625	10200520.0
2021-01-26 15:00:00	NVDA	Stock	13.4625	13.5093	13.3875	13.4352	26933160.0
2021-01-26 16:00:00	NVDA	Stock	13.4352	13.5925	13.4	13.4378	5878480.0
2021-01-26 17:00:00	NVDA	Stock	13.4522	13.465	13.4352	13.465	350200.0
2021-01-26 18:00:00	NVDA	Stock	13.4628	13.4865	13.4358	13.436	276920.0
2021-01-26 19:00:00	NVDA	Stock	13.436	13.4875	13.435	13.4875	255560.0
2021-01-26 07:00:00	AMZN	Stock	164.8445	164.85	164.5	164.5	69520.0
2021-01-26 08:00:00	AMZN	Stock	164.947	164.947	164.5	164.8415	31960.0
2021-01-26 09:00:00	AMZN	Stock	164.994	165.6	164.1435	165.4474	5440860.0
2021-01-26 10:00:00	AMZN	Stock	165.4769	166.5715	165.0	166.3355	8388180.0

> showing 50 of 67,518 rows — these rows as CSV

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