PREVIEW / stock_1hour / 2022-06-28

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-28.parquet
  size:    1.4 MB
  rows:    62,043
  symbols: 2,340

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-06-28 04:00:00	AAPL	Stock	142.01	142.44	141.59	142.44	19735.0
2022-06-28 05:00:00	AAPL	Stock	142.4	142.62	142.34	142.38	20839.0
2022-06-28 06:00:00	AAPL	Stock	142.37	142.43	142.24	142.42	16357.0
2022-06-28 07:00:00	AAPL	Stock	142.35	142.65	142.3	142.4	73918.0
2022-06-28 08:00:00	AAPL	Stock	142.42	142.66	141.77	142.1	256201.0
2022-06-28 09:00:00	AAPL	Stock	142.13	143.422	141.89	142.4	7202833.0
2022-06-28 10:00:00	AAPL	Stock	142.4	142.55	140.37	140.795	8972389.0
2022-06-28 11:00:00	AAPL	Stock	140.79	141.03	138.835	139.0509	7009744.0
2022-06-28 12:00:00	AAPL	Stock	139.06	139.43	138.65	139.31	6104690.0
2022-06-28 13:00:00	AAPL	Stock	139.3022	139.305	138.5	138.8175	4140540.0
2022-06-28 14:00:00	AAPL	Stock	138.82	139.08	137.58	138.01	5084531.0
2022-06-28 15:00:00	AAPL	Stock	138.0072	138.25	137.325	137.44	11569620.0
2022-06-28 16:00:00	AAPL	Stock	137.45	137.79	137.3	137.45	9140191.0
2022-06-28 17:00:00	AAPL	Stock	137.48	137.52	137.4	137.4299	134868.0
2022-06-28 18:00:00	AAPL	Stock	137.46	137.62	137.46	137.58	22149.0
2022-06-28 19:00:00	AAPL	Stock	137.55	137.8	137.33	137.71	56365.0
2022-06-28 04:00:00	MSFT	Stock	265.65	265.65	265.65	265.65	100.0
2022-06-28 05:00:00	MSFT	Stock	265.3	265.3	265.3	265.3	332.0
2022-06-28 06:00:00	MSFT	Stock	265.15	266.15	265.15	265.82	450.0
2022-06-28 07:00:00	MSFT	Stock	265.94	266.5	265.94	266.3	13800.0
2022-06-28 08:00:00	MSFT	Stock	266.3133	266.4374	264.228	265.45	30163.0
2022-06-28 09:00:00	MSFT	Stock	265.49	266.91	263.03	263.3	2228083.0
2022-06-28 10:00:00	MSFT	Stock	263.31	263.57	261.44	262.395	2151901.0
2022-06-28 11:00:00	MSFT	Stock	262.37	262.37	258.98	259.28	2000951.0
2022-06-28 12:00:00	MSFT	Stock	259.26	259.5	258.13	259.08	1820006.0
2022-06-28 13:00:00	MSFT	Stock	259.0787	259.3	258.01	258.885	1416563.0
2022-06-28 14:00:00	MSFT	Stock	258.9	259.42	256.89	257.47	1679925.0
2022-06-28 15:00:00	MSFT	Stock	257.475	257.65	256.32	256.48	3787071.0
2022-06-28 16:00:00	MSFT	Stock	256.46	257.2	256.4021	256.58	4263263.0
2022-06-28 17:00:00	MSFT	Stock	256.55	256.6817	256.35	256.46	30190.0
2022-06-28 18:00:00	MSFT	Stock	256.59	256.99	256.51	256.99	4762.0
2022-06-28 19:00:00	MSFT	Stock	256.7	256.78	256.51	256.64	3302.0
2022-06-28 04:00:00	NVDA	Stock	16.955	17.001	16.927	16.973	67100.0
2022-06-28 05:00:00	NVDA	Stock	16.987	16.99	16.932	16.933	40800.0
2022-06-28 06:00:00	NVDA	Stock	16.937	16.945	16.937	16.945	3770.0
2022-06-28 07:00:00	NVDA	Stock	16.957	16.993	16.935	16.935	148070.0
2022-06-28 08:00:00	NVDA	Stock	16.968	16.993	16.8269	16.8997	922530.0
2022-06-28 09:00:00	NVDA	Stock	16.9	17.202	16.785	16.892	51547240.0
2022-06-28 10:00:00	NVDA	Stock	16.894	16.937	16.42	16.4995	72729980.0
2022-06-28 11:00:00	NVDA	Stock	16.497	16.525	16.095	16.1225	51185750.0
2022-06-28 12:00:00	NVDA	Stock	16.124	16.233	16.051	16.188	41354230.0
2022-06-28 13:00:00	NVDA	Stock	16.186	16.186	16.02	16.097	29357720.0
2022-06-28 14:00:00	NVDA	Stock	16.092	16.162	15.9612	16.027	29388720.0
2022-06-28 15:00:00	NVDA	Stock	16.023	16.064	15.945	15.982	55998920.0
2022-06-28 16:00:00	NVDA	Stock	15.982	15.982	15.96	15.981	31657860.0
2022-06-28 17:00:00	NVDA	Stock	15.9808	15.988	15.968	15.98	793790.0
2022-06-28 18:00:00	NVDA	Stock	15.982	16.005	15.98	15.99	137410.0
2022-06-28 19:00:00	NVDA	Stock	15.991	15.993	15.97	15.975	201690.0
2022-06-28 04:00:00	AMZN	Stock	113.41	114.22	113.41	114.0	8841.0
2022-06-28 05:00:00	AMZN	Stock	114.07	114.17	113.75	113.94	17975.0

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

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