PREVIEW / stock_1hour / 2019-05-24

all stock 1-hour files

  file:    by_date/stock_1hour/2019/2019-05-24.parquet
  size:    1.1 MB
  rows:    48,653
  symbols: 2,590

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
2019-05-24 04:00:00	AAPL	Stock	45.125	45.31	45.1175	45.265	20504.0
2019-05-24 05:00:00	AAPL	Stock	45.25	45.275	45.175	45.175	5332.0
2019-05-24 06:00:00	AAPL	Stock	45.235	45.2675	45.18	45.2025	27120.0
2019-05-24 07:00:00	AAPL	Stock	45.1875	45.25	44.88	45.02	242996.0
2019-05-24 08:00:00	AAPL	Stock	44.98	45.245	44.855	45.025	406712.0
2019-05-24 09:00:00	AAPL	Stock	45.025	45.535	45.0	45.3475	15743232.0
2019-05-24 10:00:00	AAPL	Stock	45.3425	45.4525	44.9875	45.0475	14497704.0
2019-05-24 11:00:00	AAPL	Stock	45.0475	45.095	44.9125	45.0	8975672.0
2019-05-24 12:00:00	AAPL	Stock	45.0	45.125	44.9275	45.1052	6801852.0
2019-05-24 13:00:00	AAPL	Stock	45.1125	45.1325	44.895	44.91	5827660.0
2019-05-24 14:00:00	AAPL	Stock	44.91	44.9242	44.78	44.8475	7984728.0
2019-05-24 15:00:00	AAPL	Stock	44.845	44.9397	44.655	44.765	15818224.0
2019-05-24 16:00:00	AAPL	Stock	44.7775	44.7775	44.6675	44.7422	6160804.0
2019-05-24 17:00:00	AAPL	Stock	44.7375	44.7425	44.6625	44.6625	120772.0
2019-05-24 18:00:00	AAPL	Stock	44.65	44.7125	44.61	44.7125	37208.0
2019-05-24 19:00:00	AAPL	Stock	44.64	44.6975	44.5725	44.585	22492.0
2019-05-24 04:00:00	MSFT	Stock	127.6	127.6	127.2	127.3	2600.0
2019-05-24 05:00:00	MSFT	Stock	127.07	127.07	127.0	127.0	1400.0
2019-05-24 06:00:00	MSFT	Stock	127.2	127.3	127.17	127.29	1907.0
2019-05-24 07:00:00	MSFT	Stock	127.07	127.15	126.78	126.78	17434.0
2019-05-24 08:00:00	MSFT	Stock	127.175	127.2	126.61	126.88	33017.0
2019-05-24 09:00:00	MSFT	Stock	126.88	127.415	126.62	126.84	2030323.0
2019-05-24 10:00:00	MSFT	Stock	126.85	126.98	126.15	126.265	1943198.0
2019-05-24 11:00:00	MSFT	Stock	126.28	126.72	126.24	126.52	1226130.0
2019-05-24 12:00:00	MSFT	Stock	126.52	126.99	126.4	126.87	1238546.0
2019-05-24 13:00:00	MSFT	Stock	126.88	126.93	126.53	126.62	817290.0
2019-05-24 14:00:00	MSFT	Stock	126.625	126.72	126.4	126.6	892830.0
2019-05-24 15:00:00	MSFT	Stock	126.6	126.67	125.97	126.23	2705810.0
2019-05-24 16:00:00	MSFT	Stock	126.24	126.29	126.0	126.29	1483070.0
2019-05-24 17:00:00	MSFT	Stock	126.22	126.28	126.16	126.16	4993.0
2019-05-24 18:00:00	MSFT	Stock	126.15	126.26	126.15	126.26	2789.0
2019-05-24 19:00:00	MSFT	Stock	126.24	126.29	126.24	126.24	5848.0
2019-05-24 04:00:00	NVDA	Stock	3.7025	3.7102	3.7025	3.7102	16000.0
2019-05-24 05:00:00	NVDA	Stock	3.7095	3.7095	3.7013	3.7088	20680.0
2019-05-24 06:00:00	NVDA	Stock	3.7083	3.7138	3.7032	3.7032	100640.0
2019-05-24 07:00:00	NVDA	Stock	3.7075	3.7093	3.6925	3.6975	352080.0
2019-05-24 08:00:00	NVDA	Stock	3.71	3.715	3.6913	3.6982	2188160.0
2019-05-24 09:00:00	NVDA	Stock	3.6982	3.7375	3.693	3.7144	72679840.0
2019-05-24 10:00:00	NVDA	Stock	3.7148	3.72	3.65	3.6678	53119160.0
2019-05-24 11:00:00	NVDA	Stock	3.6677	3.6763	3.6575	3.6602	35869600.0
2019-05-24 12:00:00	NVDA	Stock	3.66	3.6688	3.649	3.6622	28604520.0
2019-05-24 13:00:00	NVDA	Stock	3.6635	3.664	3.6378	3.6459	29081200.0
2019-05-24 14:00:00	NVDA	Stock	3.6462	3.6492	3.633	3.647	22119440.0
2019-05-24 15:00:00	NVDA	Stock	3.647	3.6562	3.622	3.6282	59741880.0
2019-05-24 16:00:00	NVDA	Stock	3.6288	3.635	3.6203	3.6302	23149800.0
2019-05-24 17:00:00	NVDA	Stock	3.63	3.6305	3.6252	3.6255	320600.0
2019-05-24 18:00:00	NVDA	Stock	3.6288	3.6308	3.6275	3.6288	58880.0
2019-05-24 19:00:00	NVDA	Stock	3.625	3.6252	3.6203	3.6203	150040.0
2019-05-24 04:00:00	AMZN	Stock	91.365	91.5	91.365	91.5	21280.0
2019-05-24 05:00:00	AMZN	Stock	91.45	91.55	91.4	91.45	45540.0

> showing 50 of 48,653 rows — these rows as CSV

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