PREVIEW / stock_1hour / 2023-05-09

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-05-09.parquet
  size:    1.3 MB
  rows:    60,246
  symbols: 1,650

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
2023-05-09 04:00:00	AAPL	Stock	173.43	173.43	172.64	172.82	14949.0
2023-05-09 05:00:00	AAPL	Stock	172.85	172.85	172.7	172.72	8328.0
2023-05-09 06:00:00	AAPL	Stock	172.8	172.9	172.64	172.8	4957.0
2023-05-09 07:00:00	AAPL	Stock	172.85	172.98	172.5	172.73	42312.0
2023-05-09 08:00:00	AAPL	Stock	172.84	173.02	172.51	172.55	90413.0
2023-05-09 09:00:00	AAPL	Stock	172.56	173.54	172.23	172.775	6136977.0
2023-05-09 10:00:00	AAPL	Stock	172.78	172.89	172.145	172.515	5279776.0
2023-05-09 11:00:00	AAPL	Stock	172.51	172.64	171.82	171.855	4232388.0
2023-05-09 12:00:00	AAPL	Stock	171.85	172.43	171.81	172.369	2951528.0
2023-05-09 13:00:00	AAPL	Stock	172.37	172.48	171.96	172.085	2584141.0
2023-05-09 14:00:00	AAPL	Stock	172.09	172.3576	171.92	172.072	2687077.0
2023-05-09 15:00:00	AAPL	Stock	172.075	172.235	171.6	171.78	6856922.0
2023-05-09 16:00:00	AAPL	Stock	171.8	171.87	171.64	171.75	4934791.0
2023-05-09 17:00:00	AAPL	Stock	171.75	171.76	171.66	171.71	15207.0
2023-05-09 18:00:00	AAPL	Stock	171.71	171.908	171.7	171.85	16999.0
2023-05-09 19:00:00	AAPL	Stock	171.88	171.97	171.7601	171.94	17057.0
2023-05-09 04:00:00	MSFT	Stock	307.5	308.3	307.0	307.04	3047.0
2023-05-09 05:00:00	MSFT	Stock	307.29	307.29	306.76	307.04	950.0
2023-05-09 06:00:00	MSFT	Stock	307.0	307.0	306.77	306.81	500.0
2023-05-09 07:00:00	MSFT	Stock	306.99	307.0	306.65	307.0	4722.0
2023-05-09 08:00:00	MSFT	Stock	306.85	307.72	306.62	306.62	34916.0
2023-05-09 09:00:00	MSFT	Stock	306.5019	310.04	306.44	308.978	2757885.0
2023-05-09 10:00:00	MSFT	Stock	308.98	309.3531	307.9531	308.11	2283856.0
2023-05-09 11:00:00	MSFT	Stock	308.1	308.43	307.06	307.28	1747663.0
2023-05-09 12:00:00	MSFT	Stock	307.27	307.83	306.61	307.7093	1242708.0
2023-05-09 13:00:00	MSFT	Stock	307.75	308.29	307.67	308.07	1013568.0
2023-05-09 14:00:00	MSFT	Stock	308.09	308.31	306.68	306.89	1394869.0
2023-05-09 15:00:00	MSFT	Stock	306.89	307.3	306.31	306.94	3064213.0
2023-05-09 16:00:00	MSFT	Stock	306.93	307.28	306.69	307.07	2170611.0
2023-05-09 17:00:00	MSFT	Stock	307.12	307.18	307.07	307.07	5235.0
2023-05-09 18:00:00	MSFT	Stock	307.09	307.34	307.0	307.25	5225.0
2023-05-09 19:00:00	MSFT	Stock	307.18	307.44	307.0001	307.44	2344.0
2023-05-09 04:00:00	NVDA	Stock	29.0	29.05	28.922	28.942	63020.0
2023-05-09 05:00:00	NVDA	Stock	28.923	28.931	28.904	28.904	17170.0
2023-05-09 06:00:00	NVDA	Stock	28.935	28.942	28.913	28.93	14720.0
2023-05-09 07:00:00	NVDA	Stock	28.947	28.949	28.915	28.941	333670.0
2023-05-09 08:00:00	NVDA	Stock	29.09	29.09	28.823	28.9	1630400.0
2023-05-09 09:00:00	NVDA	Stock	28.9	28.973	28.567	28.714	41984710.0
2023-05-09 10:00:00	NVDA	Stock	28.718	28.762	28.496	28.595	46582430.0
2023-05-09 11:00:00	NVDA	Stock	28.592	28.645	28.467	28.496	27253250.0
2023-05-09 12:00:00	NVDA	Stock	28.493	28.691	28.45	28.6323	25609270.0
2023-05-09 13:00:00	NVDA	Stock	28.634	28.6858	28.562	28.683	17918560.0
2023-05-09 14:00:00	NVDA	Stock	28.687	28.769	28.651	28.703	24500070.0
2023-05-09 15:00:00	NVDA	Stock	28.705	28.736	28.533	28.57	33040850.0
2023-05-09 16:00:00	NVDA	Stock	28.501	28.571	28.501	28.513	13161280.0
2023-05-09 17:00:00	NVDA	Stock	28.514	28.539	28.5	28.539	161980.0
2023-05-09 18:00:00	NVDA	Stock	28.539	28.558	28.529	28.55	108830.0
2023-05-09 19:00:00	NVDA	Stock	28.555	28.565	28.537	28.562	125410.0
2023-05-09 04:00:00	AMZN	Stock	105.59	105.64	105.29	105.38	11666.0
2023-05-09 05:00:00	AMZN	Stock	105.48	105.8	105.36	105.78	15300.0

> showing 50 of 60,246 rows — these rows as CSV

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