PREVIEW / stock_1hour / 2021-07-29

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-29.parquet
  size:    1.4 MB
  rows:    65,317
  symbols: 2,835

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-29 04:00:00	AAPL	Stock	145.14	145.69	144.98	145.0	25024.0
2021-07-29 05:00:00	AAPL	Stock	145.0	145.38	144.94	145.23	11560.0
2021-07-29 06:00:00	AAPL	Stock	145.21	145.21	144.5	144.8	23496.0
2021-07-29 07:00:00	AAPL	Stock	144.79	145.17	144.7	145.15	111980.0
2021-07-29 08:00:00	AAPL	Stock	145.02	145.46	144.618	144.83	399283.0
2021-07-29 09:00:00	AAPL	Stock	144.84	146.55	144.58	146.2257	9886918.0
2021-07-29 10:00:00	AAPL	Stock	146.22	146.49	145.61	146.075	9489677.0
2021-07-29 11:00:00	AAPL	Stock	146.075	146.12	145.52	145.76	6581091.0
2021-07-29 12:00:00	AAPL	Stock	145.765	146.07	145.68	145.95	3951460.0
2021-07-29 13:00:00	AAPL	Stock	145.95	146.17	145.68	145.8015	3879580.0
2021-07-29 14:00:00	AAPL	Stock	145.81	146.01	145.76	145.805	3295186.0
2021-07-29 15:00:00	AAPL	Stock	145.8	145.86	145.55	145.62	6485952.0
2021-07-29 16:00:00	AAPL	Stock	145.64	145.64	144.8	144.83	4970520.0
2021-07-29 17:00:00	AAPL	Stock	144.83	145.64	144.6	144.6	133284.0
2021-07-29 18:00:00	AAPL	Stock	144.6	145.25	144.6	144.75	119364.0
2021-07-29 19:00:00	AAPL	Stock	144.71	144.76	144.33	144.34	105310.0
2021-07-29 04:00:00	MSFT	Stock	286.25	286.8	285.73	286.56	1997.0
2021-07-29 05:00:00	MSFT	Stock	286.43	287.2	286.0	286.3	3104.0
2021-07-29 06:00:00	MSFT	Stock	286.3	286.3	285.43	286.09	2405.0
2021-07-29 07:00:00	MSFT	Stock	286.0	286.4	285.7	286.4	9284.0
2021-07-29 08:00:00	MSFT	Stock	285.9866	286.9	285.5901	285.77	25004.0
2021-07-29 09:00:00	MSFT	Stock	285.86	288.618	285.73	288.21	2035928.0
2021-07-29 10:00:00	MSFT	Stock	288.21	288.39	286.26	286.94	2352300.0
2021-07-29 11:00:00	MSFT	Stock	286.9436	287.16	286.08	286.26	1470579.0
2021-07-29 12:00:00	MSFT	Stock	286.26	286.665	286.17	286.26	1025462.0
2021-07-29 13:00:00	MSFT	Stock	286.29	287.01	286.2	286.75	1137761.0
2021-07-29 14:00:00	MSFT	Stock	286.765	287.15	286.66	287.101	1118739.0
2021-07-29 15:00:00	MSFT	Stock	287.09	287.17	286.44	286.48	2326971.0
2021-07-29 16:00:00	MSFT	Stock	286.5	286.7	268.8552	286.0	2643616.0
2021-07-29 17:00:00	MSFT	Stock	285.77	285.98	285.4	285.41	21497.0
2021-07-29 18:00:00	MSFT	Stock	285.5	286.0	285.5	285.97	39404.0
2021-07-29 19:00:00	MSFT	Stock	285.84	285.85	284.4	284.42	19047.0
2021-07-29 04:00:00	NVDA	Stock	19.575	19.684	19.575	19.62	73340.0
2021-07-29 05:00:00	NVDA	Stock	19.6	19.63	19.6	19.616	23810.0
2021-07-29 06:00:00	NVDA	Stock	19.615	19.615	19.455	19.455	26890.0
2021-07-29 07:00:00	NVDA	Stock	19.505	19.535	19.482	19.529	98110.0
2021-07-29 08:00:00	NVDA	Stock	19.4815	19.575	19.45	19.461	497580.0
2021-07-29 09:00:00	NVDA	Stock	19.455	19.829	19.328	19.7071	28729100.0
2021-07-29 10:00:00	NVDA	Stock	19.7175	19.841	19.611	19.784	29466170.0
2021-07-29 11:00:00	NVDA	Stock	19.785	19.853	19.724	19.745	17096310.0
2021-07-29 12:00:00	NVDA	Stock	19.744	19.814	19.647	19.712	13132090.0
2021-07-29 13:00:00	NVDA	Stock	19.711	19.746	19.653	19.6945	8819440.0
2021-07-29 14:00:00	NVDA	Stock	19.696	19.707	19.638	19.6697	9297760.0
2021-07-29 15:00:00	NVDA	Stock	19.669	19.703	19.563	19.655	21956280.0
2021-07-29 16:00:00	NVDA	Stock	19.655	19.675	19.455	19.484	15253610.0
2021-07-29 17:00:00	NVDA	Stock	19.499	19.5	19.403	19.41	249350.0
2021-07-29 18:00:00	NVDA	Stock	19.42	19.569	19.42	19.5	413770.0
2021-07-29 19:00:00	NVDA	Stock	19.513	19.516	19.355	19.375	303870.0
2021-07-29 06:00:00	AMZN	Stock	180.907	180.907	180.907	180.907	16240.0
2021-07-29 07:00:00	AMZN	Stock	181.3695	181.737	181.35	181.6	112700.0

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

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