PREVIEW / stock_1hour / 2022-06-09

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-09.parquet
  size:    1.4 MB
  rows:    61,799
  symbols: 2,356

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
2022-06-09 04:00:00	AAPL	Stock	147.8	148.53	147.55	148.53	14801.0
2022-06-09 05:00:00	AAPL	Stock	148.5	148.5	148.27	148.33	6808.0
2022-06-09 06:00:00	AAPL	Stock	148.37	149.76	148.28	148.8	61307.0
2022-06-09 07:00:00	AAPL	Stock	148.78	149.29	148.46	148.56	146026.0
2022-06-09 08:00:00	AAPL	Stock	148.75	149.29	147.35	147.69	813875.0
2022-06-09 09:00:00	AAPL	Stock	147.66	147.95	146.38	147.63	8748279.0
2022-06-09 10:00:00	AAPL	Stock	147.63	147.66	146.1416	146.4301	9071754.0
2022-06-09 11:00:00	AAPL	Stock	146.43	146.92	145.95	146.3199	5829629.0
2022-06-09 12:00:00	AAPL	Stock	146.33	146.52	145.8	146.37	5051454.0
2022-06-09 13:00:00	AAPL	Stock	146.38	146.64	145.58	146.0399	4813146.0
2022-06-09 14:00:00	AAPL	Stock	146.04	146.04	144.74	144.755	5342560.0
2022-06-09 15:00:00	AAPL	Stock	144.755	144.79	142.53	142.605	13989593.0
2022-06-09 16:00:00	AAPL	Stock	142.6	142.9	142.0	142.89	7733325.0
2022-06-09 17:00:00	AAPL	Stock	142.89	143.1399	142.64	143.0484	422939.0
2022-06-09 18:00:00	AAPL	Stock	143.03	143.23	142.82	142.9	42143.0
2022-06-09 19:00:00	AAPL	Stock	142.86	143.14	142.75	143.0	59201.0
2022-06-09 04:00:00	MSFT	Stock	269.65	271.27	269.65	271.27	3894.0
2022-06-09 05:00:00	MSFT	Stock	271.3	271.52	271.3	271.4	7763.0
2022-06-09 06:00:00	MSFT	Stock	271.4	272.17	271.4	271.47	2595.0
2022-06-09 07:00:00	MSFT	Stock	271.5	271.75	270.61	270.75	9877.0
2022-06-09 08:00:00	MSFT	Stock	271.4985	271.7	268.91	268.98	46035.0
2022-06-09 09:00:00	MSFT	Stock	268.91	272.12	267.21	271.98	2504385.0
2022-06-09 10:00:00	MSFT	Stock	271.96	272.7081	270.785	271.29	1888408.0
2022-06-09 11:00:00	MSFT	Stock	271.285	272.25	270.15	271.294	1671425.0
2022-06-09 12:00:00	MSFT	Stock	271.26	271.92	270.28	271.7	972176.0
2022-06-09 13:00:00	MSFT	Stock	271.73	272.04	270.12	270.87	1199365.0
2022-06-09 14:00:00	MSFT	Stock	270.8748	270.88	268.31	268.36	1459197.0
2022-06-09 15:00:00	MSFT	Stock	268.3	268.39	264.63	264.7	4054618.0
2022-06-09 16:00:00	MSFT	Stock	264.71	265.6988	264.6378	265.6969	3806669.0
2022-06-09 17:00:00	MSFT	Stock	265.42	265.7132	264.6	265.35	162540.0
2022-06-09 18:00:00	MSFT	Stock	265.44	265.46	265.1	265.28	5824.0
2022-06-09 19:00:00	MSFT	Stock	265.23	265.46	265.2	265.33	4609.0
2022-06-09 04:00:00	NVDA	Stock	18.64	18.76	18.581	18.76	156480.0
2022-06-09 05:00:00	NVDA	Stock	18.757	18.79	18.726	18.735	64620.0
2022-06-09 06:00:00	NVDA	Stock	18.736	18.849	18.69	18.8	76200.0
2022-06-09 07:00:00	NVDA	Stock	18.774	18.82	18.675	18.68	298800.0
2022-06-09 08:00:00	NVDA	Stock	18.7924	18.823	18.48	18.5196	1156760.0
2022-06-09 09:00:00	NVDA	Stock	18.507	18.83	18.428	18.792	48724290.0
2022-06-09 10:00:00	NVDA	Stock	18.8	18.933	18.603	18.695	58863280.0
2022-06-09 11:00:00	NVDA	Stock	18.698	18.719	18.515	18.655	35061130.0
2022-06-09 12:00:00	NVDA	Stock	18.652	18.69	18.552	18.66	27351940.0
2022-06-09 13:00:00	NVDA	Stock	18.669	18.7079	18.428	18.532	29448340.0
2022-06-09 14:00:00	NVDA	Stock	18.5304	18.566	18.331	18.336	29897410.0
2022-06-09 15:00:00	NVDA	Stock	18.334	18.3475	18.041	18.043	58924420.0
2022-06-09 16:00:00	NVDA	Stock	18.044	18.213	17.932	18.1	21471560.0
2022-06-09 17:00:00	NVDA	Stock	18.089	18.089	18.019	18.055	1220700.0
2022-06-09 18:00:00	NVDA	Stock	18.059	18.087	18.021	18.025	98470.0
2022-06-09 19:00:00	NVDA	Stock	18.027	18.045	18.012	18.045	178260.0
2022-06-09 04:00:00	AMZN	Stock	121.2	121.5	120.67	121.4	18209.0
2022-06-09 05:00:00	AMZN	Stock	121.48	121.5	121.15	121.35	11841.0

> showing 50 of 61,799 rows — these rows as CSV

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