PREVIEW / stock_1hour / 2022-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-06-29.parquet
  size:    1.4 MB
  rows:    61,827
  symbols: 2,257

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-29 04:00:00	AAPL	Stock	137.44	138.0	137.3	137.46	13071.0
2022-06-29 05:00:00	AAPL	Stock	137.5	137.52	136.88	136.9	15285.0
2022-06-29 06:00:00	AAPL	Stock	136.87	137.3	136.87	137.06	20233.0
2022-06-29 07:00:00	AAPL	Stock	137.22	137.72	136.95	137.6	58921.0
2022-06-29 08:00:00	AAPL	Stock	137.09	138.38	136.92	137.33	265554.0
2022-06-29 09:00:00	AAPL	Stock	137.2201	139.63	136.67	139.5299	8727507.0
2022-06-29 10:00:00	AAPL	Stock	139.51	140.67	138.75	140.06	10579690.0
2022-06-29 11:00:00	AAPL	Stock	140.07	140.27	139.44	140.0	6561435.0
2022-06-29 12:00:00	AAPL	Stock	139.99	140.05	138.695	139.13	5529307.0
2022-06-29 13:00:00	AAPL	Stock	139.14	139.72	138.7399	139.64	4642261.0
2022-06-29 14:00:00	AAPL	Stock	139.64	140.18	138.93	139.16	5676457.0
2022-06-29 15:00:00	AAPL	Stock	139.165	140.05	138.81	139.25	10991850.0
2022-06-29 16:00:00	AAPL	Stock	139.24	139.49	139.0	139.2	5454182.0
2022-06-29 17:00:00	AAPL	Stock	139.2	139.21	139.05	139.08	24225.0
2022-06-29 18:00:00	AAPL	Stock	139.15	139.23	139.08	139.15	129628.0
2022-06-29 19:00:00	AAPL	Stock	139.11	139.18	138.9999	139.14	22132.0
2022-06-29 04:00:00	MSFT	Stock	256.57	257.16	256.52	256.72	2426.0
2022-06-29 05:00:00	MSFT	Stock	256.06	256.06	255.51	255.51	898.0
2022-06-29 06:00:00	MSFT	Stock	255.78	256.16	255.75	255.8	2402.0
2022-06-29 07:00:00	MSFT	Stock	255.81	257.2	255.61	257.2	12552.0
2022-06-29 08:00:00	MSFT	Stock	256.0	257.77	255.61	256.48	40234.0
2022-06-29 09:00:00	MSFT	Stock	256.81	260.8	255.76	260.755	2134671.0
2022-06-29 10:00:00	MSFT	Stock	260.7	261.97	259.34	260.92	2512713.0
2022-06-29 11:00:00	MSFT	Stock	260.92	261.94	260.16	260.32	1593780.0
2022-06-29 12:00:00	MSFT	Stock	260.32	260.54	258.63	259.67	1156408.0
2022-06-29 13:00:00	MSFT	Stock	259.705	260.52	259.17	260.52	988116.0
2022-06-29 14:00:00	MSFT	Stock	260.54	261.61	259.92	259.9587	1379124.0
2022-06-29 15:00:00	MSFT	Stock	259.94	260.85	259.3	260.27	2608043.0
2022-06-29 16:00:00	MSFT	Stock	260.25	260.44	258.17	260.26	2487075.0
2022-06-29 17:00:00	MSFT	Stock	260.07	260.2499	260.0145	260.2499	2170.0
2022-06-29 18:00:00	MSFT	Stock	260.26	260.26	259.78	260.17	63373.0
2022-06-29 19:00:00	MSFT	Stock	260.02	260.02	259.7	259.73	6399.0
2022-06-29 04:00:00	NVDA	Stock	15.981	16.005	15.936	15.95	71450.0
2022-06-29 05:00:00	NVDA	Stock	15.959	15.976	15.845	15.845	75810.0
2022-06-29 06:00:00	NVDA	Stock	15.849	15.877	15.832	15.877	150330.0
2022-06-29 07:00:00	NVDA	Stock	15.876	15.92	15.812	15.92	224340.0
2022-06-29 08:00:00	NVDA	Stock	15.8581	16.066	15.807	15.87	1036650.0
2022-06-29 09:00:00	NVDA	Stock	15.87	15.92	15.17	15.4445	89018060.0
2022-06-29 10:00:00	NVDA	Stock	15.4458	15.617	15.249	15.4406	76676320.0
2022-06-29 11:00:00	NVDA	Stock	15.4368	15.577	15.341	15.4968	49504360.0
2022-06-29 12:00:00	NVDA	Stock	15.494	15.509	15.295	15.4188	33066830.0
2022-06-29 13:00:00	NVDA	Stock	15.417	15.475	15.333	15.4437	31581490.0
2022-06-29 14:00:00	NVDA	Stock	15.442	15.497	15.338	15.398	31364710.0
2022-06-29 15:00:00	NVDA	Stock	15.397	15.556	15.377	15.546	59689190.0
2022-06-29 16:00:00	NVDA	Stock	15.544	15.569	15.534	15.558	17618820.0
2022-06-29 17:00:00	NVDA	Stock	15.558	15.5731	15.555	15.561	216320.0
2022-06-29 18:00:00	NVDA	Stock	15.566	15.6	15.542	15.562	482240.0
2022-06-29 19:00:00	NVDA	Stock	15.565	15.595	15.55	15.555	191350.0
2022-06-29 04:00:00	AMZN	Stock	107.76	107.96	107.48	107.67	10536.0
2022-06-29 05:00:00	AMZN	Stock	107.69	107.87	106.87	106.87	11781.0

> showing 50 of 61,827 rows — these rows as CSV

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