PREVIEW / stock_1hour / 2021-07-12

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-12.parquet
  size:    1.4 MB
  rows:    65,055
  symbols: 2,884

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
2021-07-12 04:00:00	AAPL	Stock	144.8	145.54	144.75	145.53	30529.0
2021-07-12 05:00:00	AAPL	Stock	145.54	145.65	145.49	145.55	21389.0
2021-07-12 06:00:00	AAPL	Stock	145.54	145.54	145.3	145.35	26372.0
2021-07-12 07:00:00	AAPL	Stock	145.37	145.85	145.3	145.78	257048.0
2021-07-12 08:00:00	AAPL	Stock	145.4501	146.2	144.748	146.11	739538.0
2021-07-12 09:00:00	AAPL	Stock	146.11	146.32	144.09	144.6298	17036344.0
2021-07-12 10:00:00	AAPL	Stock	144.625	145.25	144.0	144.9893	13285267.0
2021-07-12 11:00:00	AAPL	Stock	144.985	145.155	144.575	144.85	6733775.0
2021-07-12 12:00:00	AAPL	Stock	144.86	145.075	144.63	144.7086	3996926.0
2021-07-12 13:00:00	AAPL	Stock	144.705	144.76	144.16	144.4	4771271.0
2021-07-12 14:00:00	AAPL	Stock	144.4	144.75	144.35	144.7434	4435156.0
2021-07-12 15:00:00	AAPL	Stock	144.75	144.8	144.42	144.51	8374425.0
2021-07-12 16:00:00	AAPL	Stock	144.5	144.77	144.35	144.57	7104862.0
2021-07-12 17:00:00	AAPL	Stock	144.55	144.55	144.41	144.43	39658.0
2021-07-12 18:00:00	AAPL	Stock	144.45	144.48	144.4	144.46	30184.0
2021-07-12 19:00:00	AAPL	Stock	144.45	144.48	144.41	144.41	45665.0
2021-07-12 04:00:00	MSFT	Stock	277.63	278.47	277.63	278.2	1347.0
2021-07-12 05:00:00	MSFT	Stock	278.5	278.7	278.5	278.7	3050.0
2021-07-12 06:00:00	MSFT	Stock	278.5	278.7	277.98	278.49	8449.0
2021-07-12 07:00:00	MSFT	Stock	278.22	278.95	278.22	278.84	30979.0
2021-07-12 08:00:00	MSFT	Stock	278.5	279.5	278.4	279.35	32394.0
2021-07-12 09:00:00	MSFT	Stock	279.33	279.77	277.6	277.92	2023461.0
2021-07-12 10:00:00	MSFT	Stock	277.93	277.94	276.825	277.72	1831118.0
2021-07-12 11:00:00	MSFT	Stock	277.72	277.97	276.77	277.22	1089745.0
2021-07-12 12:00:00	MSFT	Stock	277.23	277.46	276.58	277.2617	986440.0
2021-07-12 13:00:00	MSFT	Stock	277.25	277.4086	277.065	277.34	668210.0
2021-07-12 14:00:00	MSFT	Stock	277.35	277.94	277.31	277.44	1038349.0
2021-07-12 15:00:00	MSFT	Stock	277.45	277.72	276.96	277.32	2517316.0
2021-07-12 16:00:00	MSFT	Stock	277.32	277.49	277.22	277.25	4487283.0
2021-07-12 17:00:00	MSFT	Stock	277.22	277.26	277.22	277.26	1297.0
2021-07-12 18:00:00	MSFT	Stock	277.26	277.305	277.21	277.21	1748.0
2021-07-12 19:00:00	MSFT	Stock	277.22	277.31	277.21	277.31	1940.0
2021-07-12 04:00:00	NVDA	Stock	20.05	20.0885	20.05	20.05	55240.0
2021-07-12 05:00:00	NVDA	Stock	20.1	20.1	20.0875	20.0875	16280.0
2021-07-12 06:00:00	NVDA	Stock	20.0625	20.0625	20.0375	20.0558	34400.0
2021-07-12 07:00:00	NVDA	Stock	20.0875	20.166	20.075	20.1138	339800.0
2021-07-12 08:00:00	NVDA	Stock	20.1	20.175	20.1	20.1403	700480.0
2021-07-12 09:00:00	NVDA	Stock	20.1575	20.475	20.1265	20.2088	45090360.0
2021-07-12 10:00:00	NVDA	Stock	20.2169	20.4535	20.188	20.397	35188680.0
2021-07-12 11:00:00	NVDA	Stock	20.4032	20.4373	20.3192	20.4055	18930560.0
2021-07-12 12:00:00	NVDA	Stock	20.392	20.4924	20.3413	20.35	21621200.0
2021-07-12 13:00:00	NVDA	Stock	20.3514	20.382	20.3021	20.3519	13696400.0
2021-07-12 14:00:00	NVDA	Stock	20.355	20.445	20.3251	20.3954	15174920.0
2021-07-12 15:00:00	NVDA	Stock	20.4	20.5328	20.3962	20.5135	31307360.0
2021-07-12 16:00:00	NVDA	Stock	20.5205	20.524	20.4753	20.5128	15894840.0
2021-07-12 17:00:00	NVDA	Stock	20.5138	20.5218	20.5138	20.5188	105960.0
2021-07-12 18:00:00	NVDA	Stock	20.5195	20.5238	20.5148	20.515	101840.0
2021-07-12 19:00:00	NVDA	Stock	20.5222	20.5413	20.5173	20.5245	204680.0
2021-07-12 05:00:00	AMZN	Stock	186.85	186.85	186.5845	186.65	7300.0
2021-07-12 06:00:00	AMZN	Stock	186.65	186.65	186.65	186.65	2000.0

> showing 50 of 65,055 rows — these rows as CSV

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