PREVIEW / stock_1hour / 2022-09-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-28.parquet
  size:    1.4 MB
  rows:    62,975
  symbols: 2,217

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-09-28 04:00:00	AAPL	Stock	149.47	149.75	146.5	146.68	252995.0
2022-09-28 05:00:00	AAPL	Stock	146.6	146.77	145.69	145.75	116705.0
2022-09-28 06:00:00	AAPL	Stock	145.72	147.27	145.61	145.91	411943.0
2022-09-28 07:00:00	AAPL	Stock	145.95	146.4	145.66	146.0	475566.0
2022-09-28 08:00:00	AAPL	Stock	146.34	151.76	145.66	147.84	1812012.0
2022-09-28 09:00:00	AAPL	Stock	147.84	148.5	144.84	145.8	22940032.0
2022-09-28 10:00:00	AAPL	Stock	145.805	147.43	145.16	146.239	22633662.0
2022-09-28 11:00:00	AAPL	Stock	146.24	147.415	146.06	147.3601	13488646.0
2022-09-28 12:00:00	AAPL	Stock	147.37	147.76	146.9	147.76	11112069.0
2022-09-28 13:00:00	AAPL	Stock	147.76	148.38	147.21	147.4	11428707.0
2022-09-28 14:00:00	AAPL	Stock	147.4	149.09	147.3528	148.8	11367683.0
2022-09-28 15:00:00	AAPL	Stock	148.7988	150.6414	148.74	149.8	19549389.0
2022-09-28 16:00:00	AAPL	Stock	149.84	149.94	147.5515	149.53	10313057.0
2022-09-28 17:00:00	AAPL	Stock	149.49	149.54	149.41	149.5	67326.0
2022-09-28 18:00:00	AAPL	Stock	149.51	149.83	149.45	149.48	72165.0
2022-09-28 19:00:00	AAPL	Stock	149.51	149.56	149.26	149.37	75580.0
2022-09-28 04:00:00	MSFT	Stock	234.49	234.79	233.61	234.45	17738.0
2022-09-28 05:00:00	MSFT	Stock	234.38	234.38	232.74	233.25	8385.0
2022-09-28 06:00:00	MSFT	Stock	233.01	236.89	233.0	235.46	43221.0
2022-09-28 07:00:00	MSFT	Stock	235.03	235.28	234.03	234.45	26380.0
2022-09-28 08:00:00	MSFT	Stock	235.0107	237.45	234.04	236.5	58503.0
2022-09-28 09:00:00	MSFT	Stock	236.64	237.2	234.84	235.15	3136439.0
2022-09-28 10:00:00	MSFT	Stock	235.16	239.28	234.73	238.86	3631263.0
2022-09-28 11:00:00	MSFT	Stock	238.84	239.87	237.85	239.84	2629159.0
2022-09-28 12:00:00	MSFT	Stock	239.86	241.06	239.52	239.98	1991475.0
2022-09-28 13:00:00	MSFT	Stock	240.0	240.95	239.37	239.97	1558264.0
2022-09-28 14:00:00	MSFT	Stock	239.97	240.86	239.751	240.46	1393374.0
2022-09-28 15:00:00	MSFT	Stock	240.46	242.33	240.36	241.03	3598661.0
2022-09-28 16:00:00	MSFT	Stock	240.75	241.16	240.6	240.6248	4662208.0
2022-09-28 17:00:00	MSFT	Stock	240.6852	240.8	240.59	240.77	2584.0
2022-09-28 18:00:00	MSFT	Stock	240.88	241.07	240.15	240.15	7411.0
2022-09-28 19:00:00	MSFT	Stock	240.23	240.84	240.23	240.31	2449.0
2022-09-28 04:00:00	NVDA	Stock	12.355	12.355	12.17	12.24	233480.0
2022-09-28 05:00:00	NVDA	Stock	12.226	12.231	12.12	12.137	136760.0
2022-09-28 06:00:00	NVDA	Stock	12.15	12.299	12.14	12.23	893440.0
2022-09-28 07:00:00	NVDA	Stock	12.234	12.274	12.175	12.235	496900.0
2022-09-28 08:00:00	NVDA	Stock	12.22	12.408	12.1361	12.359	2627880.0
2022-09-28 09:00:00	NVDA	Stock	12.353	12.651	12.325	12.588	69292070.0
2022-09-28 10:00:00	NVDA	Stock	12.589	12.71	12.485	12.635	75443320.0
2022-09-28 11:00:00	NVDA	Stock	12.636	12.75	12.602	12.731	56086990.0
2022-09-28 12:00:00	NVDA	Stock	12.731	12.7425	12.516	12.554	55044320.0
2022-09-28 13:00:00	NVDA	Stock	12.555	12.637	12.529	12.585	47642850.0
2022-09-28 14:00:00	NVDA	Stock	12.581	12.688	12.565	12.667	38645540.0
2022-09-28 15:00:00	NVDA	Stock	12.6685	12.823	12.656	12.728	73790670.0
2022-09-28 16:00:00	NVDA	Stock	12.736	12.741	12.715	12.72	25332700.0
2022-09-28 17:00:00	NVDA	Stock	12.717	12.724	12.717	12.721	243050.0
2022-09-28 18:00:00	NVDA	Stock	12.72	12.736	12.701	12.703	226390.0
2022-09-28 19:00:00	NVDA	Stock	12.705	12.71	12.653	12.682	429040.0
2022-09-28 04:00:00	AMZN	Stock	113.97	113.97	112.72	113.15	17310.0
2022-09-28 05:00:00	AMZN	Stock	113.09	113.09	112.04	112.25	22762.0

> showing 50 of 62,975 rows — these rows as CSV

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