PREVIEW / stock_1hour / 2020-10-19

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-19.parquet
  size:    1.3 MB
  rows:    57,456
  symbols: 2,508

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-19 04:00:00	AAPL	Stock	120.1	121.05	119.8	120.8	105594.0
2020-10-19 05:00:00	AAPL	Stock	120.8	120.96	120.5	120.7	37724.0
2020-10-19 06:00:00	AAPL	Stock	120.53	120.63	120.08	120.6	37141.0
2020-10-19 07:00:00	AAPL	Stock	120.51	120.64	119.9	120.03	459007.0
2020-10-19 08:00:00	AAPL	Stock	120.05	120.5	119.78	119.87	792293.0
2020-10-19 09:00:00	AAPL	Stock	119.87	120.419	119.02	119.545	12764368.0
2020-10-19 10:00:00	AAPL	Stock	119.54	119.585	118.17	118.865	18099727.0
2020-10-19 11:00:00	AAPL	Stock	118.865	119.7	118.73	118.76	12645828.0
2020-10-19 12:00:00	AAPL	Stock	118.765	119.14	118.4	118.77	9969904.0
2020-10-19 13:00:00	AAPL	Stock	118.765	118.97	117.6	118.03	10120441.0
2020-10-19 14:00:00	AAPL	Stock	118.02	118.1	116.84	116.85	14283733.0
2020-10-19 15:00:00	AAPL	Stock	116.86	116.9	115.66	116.0	23509569.0
2020-10-19 16:00:00	AAPL	Stock	116.0	116.8	115.98	116.71	7624237.0
2020-10-19 17:00:00	AAPL	Stock	116.73	116.9	116.5	116.75	242922.0
2020-10-19 18:00:00	AAPL	Stock	116.79	116.95	116.64	116.86	184229.0
2020-10-19 19:00:00	AAPL	Stock	116.86	117.1	116.76	117.09	235609.0
2020-10-19 04:00:00	MSFT	Stock	220.29	221.33	220.29	221.0	1795.0
2020-10-19 05:00:00	MSFT	Stock	221.02	221.32	221.02	221.1	500.0
2020-10-19 06:00:00	MSFT	Stock	221.1	221.29	220.52	221.29	9929.0
2020-10-19 07:00:00	MSFT	Stock	221.19	221.38	221.0	221.24	32975.0
2020-10-19 08:00:00	MSFT	Stock	221.22	221.31	219.12	220.83	46187.0
2020-10-19 09:00:00	MSFT	Stock	220.85	222.3	220.1	220.2	2399608.0
2020-10-19 10:00:00	MSFT	Stock	220.22	220.538	217.718	218.28	2979306.0
2020-10-19 11:00:00	MSFT	Stock	218.27	218.83	217.34	217.97	1888731.0
2020-10-19 12:00:00	MSFT	Stock	218.0	218.53	217.2	218.11	1725588.0
2020-10-19 13:00:00	MSFT	Stock	218.1	218.27	216.54	216.88	1515088.0
2020-10-19 14:00:00	MSFT	Stock	216.86	217.25	215.1	215.18	2543877.0
2020-10-19 15:00:00	MSFT	Stock	215.2	215.38	213.72	214.24	5856792.0
2020-10-19 16:00:00	MSFT	Stock	214.33	215.78	214.22	215.78	4548457.0
2020-10-19 17:00:00	MSFT	Stock	215.66	215.99	215.1	215.76	12722.0
2020-10-19 18:00:00	MSFT	Stock	215.99	216.25	215.6	215.9	21849.0
2020-10-19 19:00:00	MSFT	Stock	216.0	216.5	215.8	216.15	14826.0
2020-10-19 04:00:00	NVDA	Stock	13.98	13.9963	13.9315	13.9722	101080.0
2020-10-19 05:00:00	NVDA	Stock	13.9875	13.9875	13.9782	13.9782	27000.0
2020-10-19 06:00:00	NVDA	Stock	13.9405	13.9492	13.875	13.9	143360.0
2020-10-19 07:00:00	NVDA	Stock	13.9012	13.9212	13.8738	13.9	360480.0
2020-10-19 08:00:00	NVDA	Stock	13.905	13.925	13.85	13.8725	1358840.0
2020-10-19 09:00:00	NVDA	Stock	13.875	13.9835	13.7523	13.8675	47826960.0
2020-10-19 10:00:00	NVDA	Stock	13.8648	13.9135	13.672	13.728	40383960.0
2020-10-19 11:00:00	NVDA	Stock	13.7278	13.805	13.7105	13.7145	23311280.0
2020-10-19 12:00:00	NVDA	Stock	13.714	13.7852	13.6828	13.757	18327480.0
2020-10-19 13:00:00	NVDA	Stock	13.7608	13.78	13.635	13.696	19743200.0
2020-10-19 14:00:00	NVDA	Stock	13.6942	13.7312	13.5638	13.565	24320720.0
2020-10-19 15:00:00	NVDA	Stock	13.565	13.565	13.4068	13.4985	57468280.0
2020-10-19 16:00:00	NVDA	Stock	13.4978	13.5688	13.4928	13.5688	11869080.0
2020-10-19 17:00:00	NVDA	Stock	13.562	13.5962	13.562	13.5938	261200.0
2020-10-19 18:00:00	NVDA	Stock	13.6	13.6238	13.575	13.5798	269880.0
2020-10-19 19:00:00	NVDA	Stock	13.5842	13.6125	13.584	13.6125	111320.0
2020-10-19 04:00:00	AMZN	Stock	165.86	165.86	165.75	165.75	27320.0
2020-10-19 05:00:00	AMZN	Stock	165.85	166.0	165.85	166.0	6000.0

> showing 50 of 57,456 rows — these rows as CSV

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