PREVIEW / stock_1hour / 2022-10-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-10-10.parquet
  size:    1.3 MB
  rows:    59,323
  symbols: 2,133

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-10-10 04:00:00	AAPL	Stock	139.95	139.95	138.9	139.24	64216.0
2022-10-10 05:00:00	AAPL	Stock	139.26	139.9	139.26	139.9	24554.0
2022-10-10 06:00:00	AAPL	Stock	139.95	140.08	139.84	139.93	70670.0
2022-10-10 07:00:00	AAPL	Stock	139.95	140.4	139.9	140.18	128646.0
2022-10-10 08:00:00	AAPL	Stock	140.14	140.8	139.8115	140.8	208059.0
2022-10-10 09:00:00	AAPL	Stock	140.8	140.85	138.67	138.77	9817195.0
2022-10-10 10:00:00	AAPL	Stock	138.79	140.46	138.5729	139.5822	10237644.0
2022-10-10 11:00:00	AAPL	Stock	139.58	140.82	139.23	140.46	7776660.0
2022-10-10 12:00:00	AAPL	Stock	140.4679	140.5195	139.56	139.581	5137570.0
2022-10-10 13:00:00	AAPL	Stock	139.57	141.89	139.055	141.2699	8695863.0
2022-10-10 14:00:00	AAPL	Stock	141.27	141.3992	140.4194	140.79	6943784.0
2022-10-10 15:00:00	AAPL	Stock	140.79	141.54	140.12	140.35	10394374.0
2022-10-10 16:00:00	AAPL	Stock	140.36	140.66	140.26	140.5	6162716.0
2022-10-10 17:00:00	AAPL	Stock	140.47	140.54	140.35	140.43	16504.0
2022-10-10 18:00:00	AAPL	Stock	140.47	140.97	140.45	140.86	21907.0
2022-10-10 19:00:00	AAPL	Stock	140.86	141.2	140.75	140.92	35168.0
2022-10-10 04:00:00	MSFT	Stock	233.31	233.31	232.08	232.5	6685.0
2022-10-10 05:00:00	MSFT	Stock	232.68	234.0	232.68	234.0	830.0
2022-10-10 06:00:00	MSFT	Stock	233.5	233.6	233.2	233.2	2010.0
2022-10-10 07:00:00	MSFT	Stock	233.23	233.74	233.23	233.56	7986.0
2022-10-10 08:00:00	MSFT	Stock	233.3612	233.88	232.71	233.62	83723.0
2022-10-10 09:00:00	MSFT	Stock	233.71	234.559	230.5999	230.97	3138089.0
2022-10-10 10:00:00	MSFT	Stock	230.99	231.6	228.36	229.03	3657459.0
2022-10-10 11:00:00	MSFT	Stock	229.02	230.32	228.44	229.2	2280153.0
2022-10-10 12:00:00	MSFT	Stock	229.2	229.2183	227.41	227.42	2146674.0
2022-10-10 13:00:00	MSFT	Stock	227.42	230.7	226.73	230.0201	2809104.0
2022-10-10 14:00:00	MSFT	Stock	230.02	230.79	228.96	229.678	2101268.0
2022-10-10 15:00:00	MSFT	Stock	229.68	230.74	228.87	229.09	3844922.0
2022-10-10 16:00:00	MSFT	Stock	229.25	229.5997	228.51	229.42	3038361.0
2022-10-10 17:00:00	MSFT	Stock	229.42	229.6	229.32	229.35	11843.0
2022-10-10 18:00:00	MSFT	Stock	229.38	229.88	229.35	229.84	4982.0
2022-10-10 19:00:00	MSFT	Stock	229.85	230.38	229.83	230.25	4062.0
2022-10-10 04:00:00	NVDA	Stock	12.028	12.028	11.892	11.918	209040.0
2022-10-10 05:00:00	NVDA	Stock	11.931	11.981	11.915	11.98	70810.0
2022-10-10 06:00:00	NVDA	Stock	11.936	11.941	11.922	11.925	65120.0
2022-10-10 07:00:00	NVDA	Stock	11.94	11.991	11.923	11.969	260800.0
2022-10-10 08:00:00	NVDA	Stock	11.97	12.075	11.9052	12.052	1194520.0
2022-10-10 09:00:00	NVDA	Stock	12.067	12.1243	11.6352	11.646	85826680.0
2022-10-10 10:00:00	NVDA	Stock	11.6465	11.712	11.4081	11.4675	109559280.0
2022-10-10 11:00:00	NVDA	Stock	11.4675	11.695	11.447	11.6593	80261610.0
2022-10-10 12:00:00	NVDA	Stock	11.66	11.661	11.496	11.518	49125510.0
2022-10-10 13:00:00	NVDA	Stock	11.517	11.808	11.446	11.7508	70189100.0
2022-10-10 14:00:00	NVDA	Stock	11.749	11.778	11.633	11.692	62379350.0
2022-10-10 15:00:00	NVDA	Stock	11.694	11.8025	11.655	11.665	91824670.0
2022-10-10 16:00:00	NVDA	Stock	11.666	11.686	11.635	11.639	22434890.0
2022-10-10 17:00:00	NVDA	Stock	11.64	11.67	11.6048	11.6246	558580.0
2022-10-10 18:00:00	NVDA	Stock	11.62	11.642	11.603	11.642	205820.0
2022-10-10 19:00:00	NVDA	Stock	11.642	11.67	11.6	11.6	405380.0
2022-10-10 04:00:00	AMZN	Stock	114.05	114.2	113.5	113.83	15720.0
2022-10-10 05:00:00	AMZN	Stock	113.92	114.46	113.92	114.44	7626.0

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

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