PREVIEW / stock_1hour / 2022-09-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-09-29.parquet
  size:    1.3 MB
  rows:    61,895
  symbols: 2,228

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-29 04:00:00	AAPL	Stock	148.19	148.19	147.33	147.49	72562.0
2022-09-29 05:00:00	AAPL	Stock	147.6	148.19	147.47	148.0	66825.0
2022-09-29 06:00:00	AAPL	Stock	148.05	148.1	145.38	146.23	362055.0
2022-09-29 07:00:00	AAPL	Stock	146.38	147.0	146.22	146.59	437100.0
2022-09-29 08:00:00	AAPL	Stock	146.64	149.466	145.79	146.55	907191.0
2022-09-29 09:00:00	AAPL	Stock	146.51	147.2	143.73	144.1	17726679.0
2022-09-29 10:00:00	AAPL	Stock	144.1	144.29	142.73	143.2	18702142.0
2022-09-29 11:00:00	AAPL	Stock	143.19	143.92	142.35	143.585	11731369.0
2022-09-29 12:00:00	AAPL	Stock	143.59	143.94	142.13	142.1459	8784524.0
2022-09-29 13:00:00	AAPL	Stock	142.145	142.73	141.45	141.489	9520094.0
2022-09-29 14:00:00	AAPL	Stock	141.48	141.665	140.68	140.74	12374422.0
2022-09-29 15:00:00	AAPL	Stock	140.735	142.65	140.72	142.59	21222285.0
2022-09-29 16:00:00	AAPL	Stock	142.59	142.93	141.95	142.02	10276036.0
2022-09-29 17:00:00	AAPL	Stock	142.0002	142.07	141.6	141.89	110053.0
2022-09-29 18:00:00	AAPL	Stock	141.87	142.41	141.87	142.15	95113.0
2022-09-29 19:00:00	AAPL	Stock	142.19	142.5	142.19	142.41	73111.0
2022-09-29 04:00:00	MSFT	Stock	238.02	238.59	237.6	237.84	4413.0
2022-09-29 05:00:00	MSFT	Stock	238.17	239.39	238.17	239.03	2990.0
2022-09-29 06:00:00	MSFT	Stock	238.8	239.02	237.98	237.98	2605.0
2022-09-29 07:00:00	MSFT	Stock	238.53	239.25	238.52	238.52	13951.0
2022-09-29 08:00:00	MSFT	Stock	239.05	240.468	237.02	237.7529	51992.0
2022-09-29 09:00:00	MSFT	Stock	237.75	239.95	236.0	236.04	2403857.0
2022-09-29 10:00:00	MSFT	Stock	236.06	236.415	234.41	235.44	3138973.0
2022-09-29 11:00:00	MSFT	Stock	235.43	237.07	235.15	236.77	2006441.0
2022-09-29 12:00:00	MSFT	Stock	236.77	236.91	235.11	235.24	1393590.0
2022-09-29 13:00:00	MSFT	Stock	235.22	236.225	234.95	235.02	1462152.0
2022-09-29 14:00:00	MSFT	Stock	235.03	235.84	234.535	234.93	2008595.0
2022-09-29 15:00:00	MSFT	Stock	234.93	238.0	234.91	237.49	5017534.0
2022-09-29 16:00:00	MSFT	Stock	237.52	238.12	237.24	237.85	4337206.0
2022-09-29 17:00:00	MSFT	Stock	237.9958	238.0	237.1	237.33	7739.0
2022-09-29 18:00:00	MSFT	Stock	237.57	238.84	237.57	238.49	15060.0
2022-09-29 19:00:00	MSFT	Stock	238.55	240.0	238.42	240.0	15925.0
2022-09-29 04:00:00	NVDA	Stock	12.6	12.6	12.48	12.515	105150.0
2022-09-29 05:00:00	NVDA	Stock	12.538	12.588	12.538	12.568	118670.0
2022-09-29 06:00:00	NVDA	Stock	12.552	12.571	12.493	12.571	116830.0
2022-09-29 07:00:00	NVDA	Stock	12.555	12.624	12.548	12.568	397380.0
2022-09-29 08:00:00	NVDA	Stock	12.574	12.7042	12.448	12.452	2062860.0
2022-09-29 09:00:00	NVDA	Stock	12.446	12.5	12.231	12.2425	66185110.0
2022-09-29 10:00:00	NVDA	Stock	12.243	12.2592	12.035	12.1661	77258830.0
2022-09-29 11:00:00	NVDA	Stock	12.167	12.2409	12.122	12.226	49464660.0
2022-09-29 12:00:00	NVDA	Stock	12.226	12.27	12.105	12.1183	44830970.0
2022-09-29 13:00:00	NVDA	Stock	12.1218	12.124	12.0	12.004	37389740.0
2022-09-29 14:00:00	NVDA	Stock	12.0025	12.054	11.946	12.0169	50833540.0
2022-09-29 15:00:00	NVDA	Stock	12.017	12.26	12.017	12.225	82899640.0
2022-09-29 16:00:00	NVDA	Stock	12.22	12.245	12.152	12.215	29237300.0
2022-09-29 17:00:00	NVDA	Stock	12.214	12.219	12.165	12.178	285870.0
2022-09-29 18:00:00	NVDA	Stock	12.179	12.209	12.163	12.187	339540.0
2022-09-29 19:00:00	NVDA	Stock	12.188	12.221	12.18	12.208	498100.0
2022-09-29 04:00:00	AMZN	Stock	116.97	117.0	115.9	116.28	19978.0
2022-09-29 05:00:00	AMZN	Stock	116.32	116.88	116.32	116.87	5249.0

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

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