PREVIEW / stock_1hour / 2022-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-04-21.parquet
  size:    1.4 MB
  rows:    63,201
  symbols: 2,458

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-04-21 04:00:00	AAPL	Stock	168.3	168.88	168.28	168.88	15809.0
2022-04-21 05:00:00	AAPL	Stock	168.83	168.89	168.5	168.67	8601.0
2022-04-21 06:00:00	AAPL	Stock	168.63	169.02	168.52	168.82	30261.0
2022-04-21 07:00:00	AAPL	Stock	168.8	169.25	168.57	169.13	108742.0
2022-04-21 08:00:00	AAPL	Stock	168.78	169.2104	168.14	169.0	481659.0
2022-04-21 09:00:00	AAPL	Stock	169.01	170.875	168.445	170.05	11019515.0
2022-04-21 10:00:00	AAPL	Stock	170.06	171.0	169.8	170.5425	10895934.0
2022-04-21 11:00:00	AAPL	Stock	170.53	171.53	169.9001	169.93	11269717.0
2022-04-21 12:00:00	AAPL	Stock	169.94	170.44	169.25	169.33	7161363.0
2022-04-21 13:00:00	AAPL	Stock	169.33	169.44	167.87	168.005	7572542.0
2022-04-21 14:00:00	AAPL	Stock	167.9771	168.0361	166.05	166.3272	8257891.0
2022-04-21 15:00:00	AAPL	Stock	166.325	167.135	165.91	166.34	12003678.0
2022-04-21 16:00:00	AAPL	Stock	166.35	166.77	165.95	166.1	6577795.0
2022-04-21 17:00:00	AAPL	Stock	166.24	166.38	166.08	166.09	26211.0
2022-04-21 18:00:00	AAPL	Stock	166.14	166.38	166.01	166.31	45274.0
2022-04-21 19:00:00	AAPL	Stock	166.3001	166.42	165.92	165.92	42228.0
2022-04-21 04:00:00	MSFT	Stock	288.6	289.02	288.6	288.97	2026.0
2022-04-21 05:00:00	MSFT	Stock	288.81	288.81	288.54	288.79	1957.0
2022-04-21 06:00:00	MSFT	Stock	288.81	289.0	288.65	288.98	4289.0
2022-04-21 07:00:00	MSFT	Stock	288.9	289.55	288.61	289.41	17385.0
2022-04-21 08:00:00	MSFT	Stock	288.8984	289.76	288.72	289.3	31177.0
2022-04-21 09:00:00	MSFT	Stock	289.4	293.3	288.32	291.86	2719822.0
2022-04-21 10:00:00	MSFT	Stock	291.82	292.05	288.52	288.985	2596348.0
2022-04-21 11:00:00	MSFT	Stock	288.94	290.0839	286.2	286.2	2113316.0
2022-04-21 12:00:00	MSFT	Stock	286.22	287.92	285.87	286.47	1901890.0
2022-04-21 13:00:00	MSFT	Stock	286.485	286.7	284.92	285.14	1830440.0
2022-04-21 14:00:00	MSFT	Stock	285.11	285.11	282.45	282.79	1968216.0
2022-04-21 15:00:00	MSFT	Stock	282.7804	282.81	280.06	280.81	4233877.0
2022-04-21 16:00:00	MSFT	Stock	280.79	281.4	280.1	280.63	4197690.0
2022-04-21 17:00:00	MSFT	Stock	280.9	280.9921	280.57	280.6048	11202.0
2022-04-21 18:00:00	MSFT	Stock	280.58	281.5	280.27	280.81	7721.0
2022-04-21 19:00:00	MSFT	Stock	280.81	280.99	280.01	280.03	9364.0
2022-04-21 04:00:00	NVDA	Stock	21.825	21.9	21.764	21.781	164650.0
2022-04-21 05:00:00	NVDA	Stock	21.78	21.783	21.674	21.72	75840.0
2022-04-21 06:00:00	NVDA	Stock	21.699	21.819	21.683	21.79	46620.0
2022-04-21 07:00:00	NVDA	Stock	21.75	21.78	21.701	21.73	371860.0
2022-04-21 08:00:00	NVDA	Stock	21.744	21.797	21.601	21.797	1207240.0
2022-04-21 09:00:00	NVDA	Stock	21.785	22.392	21.66	21.775	58730670.0
2022-04-21 10:00:00	NVDA	Stock	21.7795	21.836	21.29	21.3814	60151100.0
2022-04-21 11:00:00	NVDA	Stock	21.378	21.497	20.961	21.008	51299600.0
2022-04-21 12:00:00	NVDA	Stock	21.009	21.0894	20.601	20.7	64266610.0
2022-04-21 13:00:00	NVDA	Stock	20.7	20.83	20.361	20.41	81169930.0
2022-04-21 14:00:00	NVDA	Stock	20.406	20.459	20.051	20.33	71417120.0
2022-04-21 15:00:00	NVDA	Stock	20.3255	20.33	20.0	20.155	77199110.0
2022-04-21 16:00:00	NVDA	Stock	20.169	20.27	20.112	20.225	25299000.0
2022-04-21 17:00:00	NVDA	Stock	20.225	20.234	20.183	20.234	565350.0
2022-04-21 18:00:00	NVDA	Stock	20.225	20.225	20.168	20.18	271050.0
2022-04-21 19:00:00	NVDA	Stock	20.189	20.19	20.08	20.086	532080.0
2022-04-21 06:00:00	AMZN	Stock	155.65	155.65	155.65	155.65	2000.0
2022-04-21 07:00:00	AMZN	Stock	155.45	155.9	155.25	155.562	46020.0

> showing 50 of 63,201 rows — these rows as CSV

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