PREVIEW / stock_1hour / 2020-05-07

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-05-07.parquet
  size:    1.2 MB
  rows:    54,350
  symbols: 2,358

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-05-07 04:00:00	AAPL	Stock	75.7875	76.0	75.7675	76.0	25072.0
2020-05-07 05:00:00	AAPL	Stock	76.0	76.175	76.0	76.1675	15304.0
2020-05-07 06:00:00	AAPL	Stock	76.1075	76.2	75.94	75.94	71412.0
2020-05-07 07:00:00	AAPL	Stock	75.94	75.94	75.6375	75.8875	441880.0
2020-05-07 08:00:00	AAPL	Stock	75.8875	75.925	75.645	75.875	430148.0
2020-05-07 09:00:00	AAPL	Stock	75.8975	76.2925	75.7825	76.14	16895312.0
2020-05-07 10:00:00	AAPL	Stock	76.1375	76.225	75.4925	75.7225	18123372.0
2020-05-07 11:00:00	AAPL	Stock	75.73	76.095	75.655	75.99	10719972.0
2020-05-07 12:00:00	AAPL	Stock	75.9875	76.1	75.8935	76.0425	8096844.0
2020-05-07 13:00:00	AAPL	Stock	76.045	76.095	75.9205	75.9875	6345012.0
2020-05-07 14:00:00	AAPL	Stock	75.985	76.04	75.8	75.9082	8346204.0
2020-05-07 15:00:00	AAPL	Stock	75.905	75.975	75.64	75.9375	18870700.0
2020-05-07 16:00:00	AAPL	Stock	75.935	76.14	75.885	76.0625	6212036.0
2020-05-07 17:00:00	AAPL	Stock	76.075	76.075	75.9525	76.0025	71080.0
2020-05-07 18:00:00	AAPL	Stock	76.05	76.25	76.0	76.25	172256.0
2020-05-07 19:00:00	AAPL	Stock	76.25	76.375	76.0825	76.345	200804.0
2020-05-07 04:00:00	MSFT	Stock	184.41	185.1	184.31	185.07	8396.0
2020-05-07 05:00:00	MSFT	Stock	184.76	185.69	184.68	185.69	7360.0
2020-05-07 06:00:00	MSFT	Stock	185.39	185.67	185.0	185.0	10477.0
2020-05-07 07:00:00	MSFT	Stock	184.6	184.81	184.31	184.67	57534.0
2020-05-07 08:00:00	MSFT	Stock	184.44	184.8	184.3	184.7	74260.0
2020-05-07 09:00:00	MSFT	Stock	184.7	184.86	183.0	184.27	4117045.0
2020-05-07 10:00:00	MSFT	Stock	184.268	184.515	182.58	182.95	4055150.0
2020-05-07 11:00:00	MSFT	Stock	182.96	184.16	182.96	183.816	2981800.0
2020-05-07 12:00:00	MSFT	Stock	183.84	184.0	183.46	183.83	1907095.0
2020-05-07 13:00:00	MSFT	Stock	183.826	184.2	183.71	183.925	1875903.0
2020-05-07 14:00:00	MSFT	Stock	183.925	184.01	183.174	183.645	1913308.0
2020-05-07 15:00:00	MSFT	Stock	183.64	186.5	182.79	183.608	4060338.0
2020-05-07 16:00:00	MSFT	Stock	183.67	184.15	183.5	183.86	2998927.0
2020-05-07 17:00:00	MSFT	Stock	183.91	183.91	183.65	183.84	15157.0
2020-05-07 18:00:00	MSFT	Stock	183.84	184.32	183.71	184.32	34329.0
2020-05-07 19:00:00	MSFT	Stock	184.37	184.48	184.01	184.4	22665.0
2020-05-07 04:00:00	NVDA	Stock	7.5	7.55	7.5	7.5475	105840.0
2020-05-07 05:00:00	NVDA	Stock	7.5475	7.55	7.5475	7.55	32360.0
2020-05-07 07:00:00	NVDA	Stock	7.55	7.5832	7.537	7.5808	564400.0
2020-05-07 08:00:00	NVDA	Stock	7.5775	7.5945	7.5456	7.575	895760.0
2020-05-07 09:00:00	NVDA	Stock	7.5823	7.6853	7.5712	7.6005	74919320.0
2020-05-07 10:00:00	NVDA	Stock	7.6008	7.6179	7.5331	7.558	51522480.0
2020-05-07 11:00:00	NVDA	Stock	7.56	7.6222	7.56	7.6068	34518800.0
2020-05-07 12:00:00	NVDA	Stock	7.6068	7.664	7.604	7.6582	36566840.0
2020-05-07 13:00:00	NVDA	Stock	7.658	7.675	7.639	7.658	30742040.0
2020-05-07 14:00:00	NVDA	Stock	7.6588	7.6588	7.6055	7.643	27121360.0
2020-05-07 15:00:00	NVDA	Stock	7.6425	7.6568	7.609	7.622	47083320.0
2020-05-07 16:00:00	NVDA	Stock	7.6218	7.6498	7.617	7.635	4469560.0
2020-05-07 17:00:00	NVDA	Stock	7.6325	7.645	7.628	7.6345	72600.0
2020-05-07 18:00:00	NVDA	Stock	7.634	7.645	7.634	7.645	395480.0
2020-05-07 19:00:00	NVDA	Stock	7.65	7.675	7.65	7.675	1061280.0
2020-05-07 04:00:00	AMZN	Stock	118.0	118.0	118.0	118.0	4940.0
2020-05-07 06:00:00	AMZN	Stock	118.8895	118.9395	118.673	118.715	37780.0
2020-05-07 07:00:00	AMZN	Stock	118.7495	118.7495	118.2	118.505	272740.0

> showing 50 of 54,350 rows — these rows as CSV

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