PREVIEW / stock_1hour / 2021-12-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-07.parquet
  size:    1.5 MB
  rows:    67,220
  symbols: 2,682

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-12-07 04:00:00	AAPL	Stock	168.22	168.63	166.14	168.08	90993.0
2021-12-07 05:00:00	AAPL	Stock	168.15	168.9	168.15	168.85	60800.0
2021-12-07 06:00:00	AAPL	Stock	168.85	168.91	168.06	168.4	71609.0
2021-12-07 07:00:00	AAPL	Stock	168.35	168.8	168.12	168.52	259978.0
2021-12-07 08:00:00	AAPL	Stock	168.2999	169.45	164.907	168.95	624533.0
2021-12-07 09:00:00	AAPL	Stock	168.94	170.78	168.34	170.1552	18447078.0
2021-12-07 10:00:00	AAPL	Stock	170.15	171.28	169.97	170.745	17216741.0
2021-12-07 11:00:00	AAPL	Stock	170.74	171.4773	170.48	171.0666	11615737.0
2021-12-07 12:00:00	AAPL	Stock	171.0711	171.58	170.81	171.11	8367126.0
2021-12-07 13:00:00	AAPL	Stock	171.1	171.14	170.321	170.45	7098580.0
2021-12-07 14:00:00	AAPL	Stock	170.44	170.445	169.45	169.93	8312870.0
2021-12-07 15:00:00	AAPL	Stock	169.93	171.27	169.8101	171.2	15490429.0
2021-12-07 16:00:00	AAPL	Stock	171.2	173.8799	170.84	172.8	13115876.0
2021-12-07 17:00:00	AAPL	Stock	172.75	173.29	171.18	172.6	211227.0
2021-12-07 18:00:00	AAPL	Stock	172.6	172.6	172.11	172.35	135341.0
2021-12-07 19:00:00	AAPL	Stock	172.37	172.6	172.07	172.58	180494.0
2021-12-07 04:00:00	MSFT	Stock	330.19	333.5	330.19	332.45	10273.0
2021-12-07 05:00:00	MSFT	Stock	332.32	332.86	332.0	332.36	8386.0
2021-12-07 06:00:00	MSFT	Stock	332.7	332.75	331.7	332.12	6166.0
2021-12-07 07:00:00	MSFT	Stock	331.81	331.81	331.0	331.4	33551.0
2021-12-07 08:00:00	MSFT	Stock	331.69	331.75	331.0	331.25	46354.0
2021-12-07 09:00:00	MSFT	Stock	331.43	332.76	330.1	332.5	3044311.0
2021-12-07 10:00:00	MSFT	Stock	332.54	335.6	332.08	335.29	3230030.0
2021-12-07 11:00:00	MSFT	Stock	335.3	335.8	334.67	335.01	2226106.0
2021-12-07 12:00:00	MSFT	Stock	335.01	335.78	334.67	335.4637	1577282.0
2021-12-07 13:00:00	MSFT	Stock	335.46	335.68	334.64	335.23	1572730.0
2021-12-07 14:00:00	MSFT	Stock	335.22	335.26	333.56	333.89	1785287.0
2021-12-07 15:00:00	MSFT	Stock	333.88	335.3	332.09	334.92	3920246.0
2021-12-07 16:00:00	MSFT	Stock	334.92	335.4347	334.5	335.25	5119337.0
2021-12-07 17:00:00	MSFT	Stock	335.25	335.75	335.19	335.5	13716.0
2021-12-07 18:00:00	MSFT	Stock	335.35	335.35	334.92	335.29	106858.0
2021-12-07 19:00:00	MSFT	Stock	335.2	335.93	335.0	335.93	14017.0
2021-12-07 04:00:00	NVDA	Stock	30.95	31.245	30.757	30.922	342870.0
2021-12-07 05:00:00	NVDA	Stock	30.93	31.2	30.9	31.16	172300.0
2021-12-07 06:00:00	NVDA	Stock	31.174	31.174	30.995	31.0	120320.0
2021-12-07 07:00:00	NVDA	Stock	31.0	31.12	30.8	31.12	1049900.0
2021-12-07 08:00:00	NVDA	Stock	30.9658	31.227	30.8157	31.029	1966370.0
2021-12-07 09:00:00	NVDA	Stock	31.048	31.16	30.651	30.96	59755170.0
2021-12-07 10:00:00	NVDA	Stock	30.9532	31.845	30.925	31.548	92731530.0
2021-12-07 11:00:00	NVDA	Stock	31.554	31.893	31.529	31.7805	62835810.0
2021-12-07 12:00:00	NVDA	Stock	31.7805	32.168	31.764	32.0988	48549740.0
2021-12-07 13:00:00	NVDA	Stock	32.0979	32.253	31.963	32.236	45412960.0
2021-12-07 14:00:00	NVDA	Stock	32.241	32.325	31.945	32.0815	58871170.0
2021-12-07 15:00:00	NVDA	Stock	32.079	32.449	32.033	32.432	68497420.0
2021-12-07 16:00:00	NVDA	Stock	32.433	32.5	32.4	32.497	26871600.0
2021-12-07 17:00:00	NVDA	Stock	32.49	32.55	32.371	32.43	595680.0
2021-12-07 18:00:00	NVDA	Stock	32.48	32.48	32.301	32.355	1577900.0
2021-12-07 19:00:00	NVDA	Stock	32.372	32.45	32.326	32.45	337260.0
2021-12-07 04:00:00	AMZN	Stock	173.8595	174.75	173.8595	174.35	8520.0
2021-12-07 05:00:00	AMZN	Stock	174.75	174.75	174.75	174.75	2280.0

> showing 50 of 67,220 rows — these rows as CSV

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