PREVIEW / stock_1hour / 2022-08-01

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-08-01.parquet
  size:    1.4 MB
  rows:    62,941
  symbols: 2,350

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-08-01 04:00:00	AAPL	Stock	161.98	162.25	161.79	162.01	21197.0
2022-08-01 05:00:00	AAPL	Stock	161.92	162.16	161.92	162.16	15367.0
2022-08-01 06:00:00	AAPL	Stock	162.1	162.19	162.01	162.1	8286.0
2022-08-01 07:00:00	AAPL	Stock	162.05	162.3	162.0	162.06	63429.0
2022-08-01 08:00:00	AAPL	Stock	162.09	162.3	161.0	161.2	703471.0
2022-08-01 09:00:00	AAPL	Stock	161.2	163.11	160.85	162.768	9116008.0
2022-08-01 10:00:00	AAPL	Stock	162.74	163.59	162.1805	163.2	8972356.0
2022-08-01 11:00:00	AAPL	Stock	163.22	163.37	162.705	163.16	5427743.0
2022-08-01 12:00:00	AAPL	Stock	163.19	163.2382	161.95	162.1001	4650487.0
2022-08-01 13:00:00	AAPL	Stock	162.11	162.13	160.89	161.35	5409534.0
2022-08-01 14:00:00	AAPL	Stock	161.355	162.2499	160.99	162.175	5119035.0
2022-08-01 15:00:00	AAPL	Stock	162.17	162.25	161.19	161.57	7854412.0
2022-08-01 16:00:00	AAPL	Stock	161.57	161.75	161.47	161.6044	5823303.0
2022-08-01 17:00:00	AAPL	Stock	161.61	161.77	161.56	161.6231	35212.0
2022-08-01 18:00:00	AAPL	Stock	161.61	161.61	161.35	161.46	16138.0
2022-08-01 19:00:00	AAPL	Stock	161.42	161.61	161.31	161.4	24921.0
2022-08-01 04:00:00	MSFT	Stock	282.0	282.0	279.95	279.95	3998.0
2022-08-01 05:00:00	MSFT	Stock	279.8	280.05	279.71	279.99	4105.0
2022-08-01 06:00:00	MSFT	Stock	279.84	279.93	279.52	279.52	1356.0
2022-08-01 07:00:00	MSFT	Stock	279.9	280.09	278.72	279.75	34002.0
2022-08-01 08:00:00	MSFT	Stock	279.97	280.09	278.63	278.84	62103.0
2022-08-01 09:00:00	MSFT	Stock	278.83	279.0	276.7431	278.7	2238993.0
2022-08-01 10:00:00	MSFT	Stock	278.55	281.21	277.73	281.1101	2503683.0
2022-08-01 11:00:00	MSFT	Stock	281.12	281.28	279.86	280.34	1401133.0
2022-08-01 12:00:00	MSFT	Stock	280.35	280.48	278.22	278.75	1344314.0
2022-08-01 13:00:00	MSFT	Stock	278.745	278.78	275.84	277.12	1665260.0
2022-08-01 14:00:00	MSFT	Stock	277.13	278.33	276.5784	278.2248	1371139.0
2022-08-01 15:00:00	MSFT	Stock	278.255	279.0	277.56	278.02	2373798.0
2022-08-01 16:00:00	MSFT	Stock	278.01	278.43	278.01	278.1993	3082689.0
2022-08-01 17:00:00	MSFT	Stock	278.2082	278.43	278.01	278.04	3108.0
2022-08-01 18:00:00	MSFT	Stock	278.01	278.01	277.58	277.6	3607.0
2022-08-01 19:00:00	MSFT	Stock	277.8	278.12	277.63	277.65	4354.0
2022-08-01 04:00:00	NVDA	Stock	18.181	18.181	18.1	18.108	137700.0
2022-08-01 05:00:00	NVDA	Stock	18.105	18.15	18.105	18.13	10340.0
2022-08-01 06:00:00	NVDA	Stock	18.14	18.163	18.14	18.16	21980.0
2022-08-01 07:00:00	NVDA	Stock	18.16	18.255	18.155	18.208	347270.0
2022-08-01 08:00:00	NVDA	Stock	18.1682	18.26	18.0	18.0832	1318220.0
2022-08-01 09:00:00	NVDA	Stock	18.066	18.483	17.99	18.37	61914950.0
2022-08-01 10:00:00	NVDA	Stock	18.373	18.846	18.334	18.793	89406350.0
2022-08-01 11:00:00	NVDA	Stock	18.795	18.831	18.51	18.639	48281850.0
2022-08-01 12:00:00	NVDA	Stock	18.6395	18.667	18.4801	18.525	34092750.0
2022-08-01 13:00:00	NVDA	Stock	18.524	18.524	18.243	18.3126	38897650.0
2022-08-01 14:00:00	NVDA	Stock	18.312	18.571	18.2764	18.552	36101640.0
2022-08-01 15:00:00	NVDA	Stock	18.553	18.598	18.355	18.442	50666030.0
2022-08-01 16:00:00	NVDA	Stock	18.441	18.558	18.429	18.536	16550110.0
2022-08-01 17:00:00	NVDA	Stock	18.544	18.55	18.49	18.5	235390.0
2022-08-01 18:00:00	NVDA	Stock	18.487	18.493	18.463	18.475	64330.0
2022-08-01 19:00:00	NVDA	Stock	18.477	18.481	18.445	18.475	166520.0
2022-08-01 04:00:00	AMZN	Stock	135.35	135.35	134.39	134.66	13996.0
2022-08-01 05:00:00	AMZN	Stock	134.56	134.99	134.56	134.75	13110.0

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

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