PREVIEW / stock_1hour / 2021-10-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-10-11.parquet
  size:    1.4 MB
  rows:    62,865
  symbols: 2,623

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-10-11 04:00:00	AAPL	Stock	142.05	142.49	142.03	142.18	28195.0
2021-10-11 05:00:00	AAPL	Stock	142.26	142.46	142.22	142.38	12161.0
2021-10-11 06:00:00	AAPL	Stock	142.4	142.4	141.81	141.85	52516.0
2021-10-11 07:00:00	AAPL	Stock	141.9	142.19	141.73	141.92	143627.0
2021-10-11 08:00:00	AAPL	Stock	141.9001	142.25	141.65	142.12	427688.0
2021-10-11 09:00:00	AAPL	Stock	142.13	144.0	141.81	143.93	8647217.0
2021-10-11 10:00:00	AAPL	Stock	143.93	144.81	143.93	144.445	9603856.0
2021-10-11 11:00:00	AAPL	Stock	144.45	144.7	144.34	144.43	5365753.0
2021-10-11 12:00:00	AAPL	Stock	144.43	144.4599	143.86	144.0675	5107534.0
2021-10-11 13:00:00	AAPL	Stock	144.055	144.055	143.38	143.5867	5286549.0
2021-10-11 14:00:00	AAPL	Stock	143.58	143.84	143.23	143.41	4637066.0
2021-10-11 15:00:00	AAPL	Stock	143.41	143.53	142.75	142.8	7604496.0
2021-10-11 16:00:00	AAPL	Stock	142.81	142.82	142.5	142.58	6384517.0
2021-10-11 17:00:00	AAPL	Stock	142.59	142.6	142.54	142.6	35469.0
2021-10-11 18:00:00	AAPL	Stock	142.6	142.64	142.5	142.53	27011.0
2021-10-11 19:00:00	AAPL	Stock	142.53	142.63	142.49	142.59	49333.0
2021-10-11 04:00:00	MSFT	Stock	293.05	293.05	293.0	293.0	244.0
2021-10-11 05:00:00	MSFT	Stock	293.3	293.58	293.2	293.58	836.0
2021-10-11 06:00:00	MSFT	Stock	293.1	293.2	291.73	291.81	4902.0
2021-10-11 07:00:00	MSFT	Stock	292.25	292.75	291.67	291.93	21144.0
2021-10-11 08:00:00	MSFT	Stock	292.6	292.77	291.5563	292.49	43920.0
2021-10-11 09:00:00	MSFT	Stock	292.59	296.52	292.59	296.23	1655843.0
2021-10-11 10:00:00	MSFT	Stock	296.23	297.42	296.08	297.1354	1704428.0
2021-10-11 11:00:00	MSFT	Stock	297.14	297.97	296.7	296.73	1462095.0
2021-10-11 12:00:00	MSFT	Stock	296.74	296.77	295.84	296.6561	1274311.0
2021-10-11 13:00:00	MSFT	Stock	296.6389	296.7168	295.2601	295.8451	1266002.0
2021-10-11 14:00:00	MSFT	Stock	295.855	296.42	295.71	296.18	892056.0
2021-10-11 15:00:00	MSFT	Stock	296.2	296.35	294.1	294.21	1983336.0
2021-10-11 16:00:00	MSFT	Stock	294.23	294.3	293.77	293.86	4157881.0
2021-10-11 17:00:00	MSFT	Stock	294.0	294.07	293.85	293.98	2280.0
2021-10-11 18:00:00	MSFT	Stock	294.01	294.03	293.79	293.85	3887.0
2021-10-11 19:00:00	MSFT	Stock	293.97	294.1	293.84	294.1	5106.0
2021-10-11 04:00:00	NVDA	Stock	20.676	20.681	20.631	20.658	28990.0
2021-10-11 05:00:00	NVDA	Stock	20.647	20.697	20.647	20.665	13940.0
2021-10-11 06:00:00	NVDA	Stock	20.643	20.643	20.5	20.52	51580.0
2021-10-11 07:00:00	NVDA	Stock	20.539	20.589	20.468	20.482	314250.0
2021-10-11 08:00:00	NVDA	Stock	20.585	20.589	20.433	20.55	773960.0
2021-10-11 09:00:00	NVDA	Stock	20.574	20.979	20.511	20.928	19428270.0
2021-10-11 10:00:00	NVDA	Stock	20.924	21.063	20.913	20.969	19653940.0
2021-10-11 11:00:00	NVDA	Stock	20.968	21.0378	20.941	20.96	15459490.0
2021-10-11 12:00:00	NVDA	Stock	20.958	20.986	20.873	20.963	14054530.0
2021-10-11 13:00:00	NVDA	Stock	20.963	20.963	20.823	20.8966	11798190.0
2021-10-11 14:00:00	NVDA	Stock	20.895	20.9589	20.8555	20.914	10091090.0
2021-10-11 15:00:00	NVDA	Stock	20.912	20.93	20.679	20.689	14593210.0
2021-10-11 16:00:00	NVDA	Stock	20.695	20.695	20.612	20.63	18045040.0
2021-10-11 17:00:00	NVDA	Stock	20.645	20.653	20.632	20.641	213910.0
2021-10-11 18:00:00	NVDA	Stock	20.65	20.658	20.634	20.634	218240.0
2021-10-11 19:00:00	NVDA	Stock	20.64	20.695	20.602	20.615	169980.0
2021-10-11 04:00:00	AMZN	Stock	163.95	164.15	163.9	164.15	9000.0
2021-10-11 07:00:00	AMZN	Stock	163.75	163.75	163.2555	163.35	18100.0

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

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