PREVIEW / stock_1hour / 2020-03-24

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-03-24.parquet
  size:    1.2 MB
  rows:    55,688
  symbols: 2,450

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-03-24 04:00:00	AAPL	Stock	58.255	58.8375	57.925	58.3825	150400.0
2020-03-24 05:00:00	AAPL	Stock	58.495	58.97	58.45	58.97	71920.0
2020-03-24 06:00:00	AAPL	Stock	59.0	59.5	59.0	59.125	160612.0
2020-03-24 07:00:00	AAPL	Stock	59.125	59.21	57.875	58.37	1124924.0
2020-03-24 08:00:00	AAPL	Stock	59.045	59.045	57.8075	58.7	1574964.0
2020-03-24 09:00:00	AAPL	Stock	58.675	59.4675	58.5375	59.1315	32347176.0
2020-03-24 10:00:00	AAPL	Stock	59.125	60.86	58.9275	60.3	41548028.0
2020-03-24 11:00:00	AAPL	Stock	60.3	60.5875	59.7625	60.5738	25632428.0
2020-03-24 12:00:00	AAPL	Stock	60.57	60.77	60.03	60.0575	21188888.0
2020-03-24 13:00:00	AAPL	Stock	60.0625	60.3575	59.535	59.635	19913860.0
2020-03-24 14:00:00	AAPL	Stock	59.64	60.75	59.135	60.7225	24379864.0
2020-03-24 15:00:00	AAPL	Stock	60.72	61.9225	60.525	61.72	48268288.0
2020-03-24 16:00:00	AAPL	Stock	61.5	62.0	60.1948	61.8038	25502932.0
2020-03-24 17:00:00	AAPL	Stock	61.815	61.9225	61.5025	61.9225	499356.0
2020-03-24 18:00:00	AAPL	Stock	61.9225	62.25	61.625	62.125	403264.0
2020-03-24 19:00:00	AAPL	Stock	62.1125	62.175	61.1875	61.5	492336.0
2020-03-24 04:00:00	MSFT	Stock	141.28	143.0	141.0	141.66	35397.0
2020-03-24 05:00:00	MSFT	Stock	141.8	143.0	141.66	143.0	22168.0
2020-03-24 06:00:00	MSFT	Stock	143.0	143.45	142.28	142.92	16655.0
2020-03-24 07:00:00	MSFT	Stock	142.76	143.0	140.3	141.05	178704.0
2020-03-24 08:00:00	MSFT	Stock	141.25	142.7	140.06	142.56	331821.0
2020-03-24 09:00:00	MSFT	Stock	142.6	144.86	141.47	142.07	7991997.0
2020-03-24 10:00:00	MSFT	Stock	142.04	145.35	141.27	143.865	9149663.0
2020-03-24 11:00:00	MSFT	Stock	143.87	146.0	143.0	145.934	7834079.0
2020-03-24 12:00:00	MSFT	Stock	145.936	149.6	145.61	146.136	8367137.0
2020-03-24 13:00:00	MSFT	Stock	146.16	147.75	144.59	144.91	6409506.0
2020-03-24 14:00:00	MSFT	Stock	144.92	147.35	143.42	147.3	7678733.0
2020-03-24 15:00:00	MSFT	Stock	147.26	148.5	145.53	148.34	12399719.0
2020-03-24 16:00:00	MSFT	Stock	147.01	148.85	145.697	148.29	9711626.0
2020-03-24 17:00:00	MSFT	Stock	148.32	148.64	147.5	148.34	126595.0
2020-03-24 18:00:00	MSFT	Stock	148.42	149.88	147.8	149.09	83237.0
2020-03-24 19:00:00	MSFT	Stock	149.1	149.2	147.01	147.25	50327.0
2020-03-24 04:00:00	NVDA	Stock	5.556	5.635	5.556	5.5783	193200.0
2020-03-24 05:00:00	NVDA	Stock	5.592	5.7003	5.589	5.7003	171840.0
2020-03-24 06:00:00	NVDA	Stock	5.715	5.7448	5.7	5.7	165280.0
2020-03-24 07:00:00	NVDA	Stock	5.6875	5.7063	5.6208	5.64	1922920.0
2020-03-24 08:00:00	NVDA	Stock	5.675	5.7125	5.5808	5.6475	3269680.0
2020-03-24 09:00:00	NVDA	Stock	5.65	6.1043	5.6365	6.0358	150775840.0
2020-03-24 10:00:00	NVDA	Stock	6.0376	6.1592	5.9865	6.1075	137779800.0
2020-03-24 11:00:00	NVDA	Stock	6.1075	6.3165	6.1038	6.2748	159592960.0
2020-03-24 12:00:00	NVDA	Stock	6.271	6.29	6.1083	6.1172	106323440.0
2020-03-24 13:00:00	NVDA	Stock	6.118	6.16	6.0148	6.0422	108935640.0
2020-03-24 14:00:00	NVDA	Stock	6.0408	6.1528	5.941	6.1483	95545200.0
2020-03-24 15:00:00	NVDA	Stock	6.1468	6.2375	6.124	6.2368	138565440.0
2020-03-24 16:00:00	NVDA	Stock	6.2295	6.2498	6.1875	6.2498	42132840.0
2020-03-24 17:00:00	NVDA	Stock	6.2398	6.2475	6.2	6.225	1786160.0
2020-03-24 18:00:00	NVDA	Stock	6.2198	6.275	6.2198	6.2502	1208240.0
2020-03-24 19:00:00	NVDA	Stock	6.25	6.25	6.1675	6.175	1237680.0
2020-03-24 04:00:00	AMZN	Stock	98.505	98.8115	98.25	98.65	23600.0
2020-03-24 05:00:00	AMZN	Stock	98.654	98.9075	98.625	98.9075	43320.0

> showing 50 of 55,688 rows — these rows as CSV

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