PREVIEW / stock_1hour / 2023-04-06

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-06.parquet
  size:    1.3 MB
  rows:    59,445
  symbols: 1,733

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-04-06 04:00:00	AAPL	Stock	161.79	163.6	160.18	162.74	37580.0
2023-04-06 05:00:00	AAPL	Stock	162.71	162.82	162.29	162.29	17384.0
2023-04-06 06:00:00	AAPL	Stock	162.31	162.73	162.1	162.71	21064.0
2023-04-06 07:00:00	AAPL	Stock	162.66	163.0	162.66	162.91	34901.0
2023-04-06 08:00:00	AAPL	Stock	162.7607	163.0	162.2315	162.36	198385.0
2023-04-06 09:00:00	AAPL	Stock	162.36	162.74	161.92	162.685	5186083.0
2023-04-06 10:00:00	AAPL	Stock	162.69	163.5899	162.54	163.2739	6115603.0
2023-04-06 11:00:00	AAPL	Stock	163.28	164.75	163.18	164.53	5422037.0
2023-04-06 12:00:00	AAPL	Stock	164.53	164.9584	164.405	164.475	3693640.0
2023-04-06 13:00:00	AAPL	Stock	164.475	164.81	164.3	164.81	3266958.0
2023-04-06 14:00:00	AAPL	Stock	164.81	164.94	164.555	164.65	2734321.0
2023-04-06 15:00:00	AAPL	Stock	164.65	164.825	164.32	164.65	5698530.0
2023-04-06 16:00:00	AAPL	Stock	164.65	164.7	164.55	164.6	6306070.0
2023-04-06 17:00:00	AAPL	Stock	164.5999	164.66	164.57	164.58	27278.0
2023-04-06 18:00:00	AAPL	Stock	164.5799	164.6	164.51	164.52	21470.0
2023-04-06 19:00:00	AAPL	Stock	164.57	164.59	164.51	164.59	13087.0
2023-04-06 04:00:00	MSFT	Stock	284.31	284.86	284.2	284.28	3816.0
2023-04-06 05:00:00	MSFT	Stock	284.62	284.62	281.47	281.49	12313.0
2023-04-06 06:00:00	MSFT	Stock	281.55	282.52	281.15	282.5	11204.0
2023-04-06 07:00:00	MSFT	Stock	282.77	283.47	282.48	283.28	16971.0
2023-04-06 08:00:00	MSFT	Stock	282.76	283.5069	282.07	282.1539	51858.0
2023-04-06 09:00:00	MSFT	Stock	282.31	283.72	281.85	283.55	1736782.0
2023-04-06 10:00:00	MSFT	Stock	283.55	284.68	282.75	283.35	2193751.0
2023-04-06 11:00:00	MSFT	Stock	283.39	286.46	283.11	286.4186	1763304.0
2023-04-06 12:00:00	MSFT	Stock	286.42	288.54	286.42	287.97	2590358.0
2023-04-06 13:00:00	MSFT	Stock	287.98	290.64	287.75	290.325	2899303.0
2023-04-06 14:00:00	MSFT	Stock	290.375	291.07	290.26	290.57	2699425.0
2023-04-06 15:00:00	MSFT	Stock	290.56	292.08	290.5301	291.57	5306844.0
2023-04-06 16:00:00	MSFT	Stock	291.55	291.8095	291.53	291.7108	3997358.0
2023-04-06 17:00:00	MSFT	Stock	291.72	291.9467	291.72	291.82	29414.0
2023-04-06 18:00:00	MSFT	Stock	291.82	291.82	291.46	291.59	15406.0
2023-04-06 19:00:00	MSFT	Stock	291.6	291.86	291.41	291.6	14116.0
2023-04-06 04:00:00	NVDA	Stock	26.765	26.796	26.568	26.668	233600.0
2023-04-06 05:00:00	NVDA	Stock	26.639	26.648	26.51	26.51	92240.0
2023-04-06 06:00:00	NVDA	Stock	26.515	26.696	26.488	26.66	241830.0
2023-04-06 07:00:00	NVDA	Stock	26.667	26.796	26.667	26.79	542970.0
2023-04-06 08:00:00	NVDA	Stock	26.73	26.902	26.564	26.675	1491570.0
2023-04-06 09:00:00	NVDA	Stock	26.665	26.7	26.427	26.635	46435410.0
2023-04-06 10:00:00	NVDA	Stock	26.64	26.878	26.622	26.755	54362550.0
2023-04-06 11:00:00	NVDA	Stock	26.757	27.056	26.751	27.01	49807040.0
2023-04-06 12:00:00	NVDA	Stock	27.013	27.061	26.8065	26.815	34068180.0
2023-04-06 13:00:00	NVDA	Stock	26.816	27.003	26.784	26.982	25751130.0
2023-04-06 14:00:00	NVDA	Stock	26.985	27.08	26.936	26.971	29020710.0
2023-04-06 15:00:00	NVDA	Stock	26.974	27.078	26.92	27.034	38488610.0
2023-04-06 16:00:00	NVDA	Stock	27.034	27.05	26.8556	27.021	19766930.0
2023-04-06 17:00:00	NVDA	Stock	27.0195	27.04	27.017	27.033	239970.0
2023-04-06 18:00:00	NVDA	Stock	27.027	27.04	27.02	27.037	189910.0
2023-04-06 19:00:00	NVDA	Stock	27.034	27.059	27.031	27.056	228910.0
2023-04-06 04:00:00	AMZN	Stock	101.0	101.09	100.65	100.8	8865.0
2023-04-06 05:00:00	AMZN	Stock	100.8	100.9	100.52	100.55	12465.0

> showing 50 of 59,445 rows — these rows as CSV

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