PREVIEW / stock_1hour / 2022-05-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-18.parquet
  size:    1.4 MB
  rows:    63,564
  symbols: 2,415

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-05-18 04:00:00	AAPL	Stock	148.79	148.85	148.12	148.18	13510.0
2022-05-18 05:00:00	AAPL	Stock	148.39	148.64	148.28	148.52	10979.0
2022-05-18 06:00:00	AAPL	Stock	148.7	148.78	148.01	148.3	30759.0
2022-05-18 07:00:00	AAPL	Stock	148.34	148.39	147.38	147.55	112707.0
2022-05-18 08:00:00	AAPL	Stock	148.27	149.19	146.75	146.7901	586270.0
2022-05-18 09:00:00	AAPL	Stock	146.87	147.3601	145.78	145.9026	8833050.0
2022-05-18 10:00:00	AAPL	Stock	145.905	146.6	144.8201	145.42	11127017.0
2022-05-18 11:00:00	AAPL	Stock	145.415	145.42	142.76	142.76	11690833.0
2022-05-18 12:00:00	AAPL	Stock	142.775	143.69	142.14	143.5501	9796073.0
2022-05-18 13:00:00	AAPL	Stock	143.55	143.564	141.36	141.73	9103381.0
2022-05-18 14:00:00	AAPL	Stock	141.72	141.94	139.9	140.0917	11964878.0
2022-05-18 15:00:00	AAPL	Stock	140.1017	141.2	140.07	140.82	18871332.0
2022-05-18 16:00:00	AAPL	Stock	140.83	141.16	140.18	140.88	12744569.0
2022-05-18 17:00:00	AAPL	Stock	140.88	140.95	140.65	140.87	94310.0
2022-05-18 18:00:00	AAPL	Stock	140.83	141.2	140.8	141.2	124545.0
2022-05-18 19:00:00	AAPL	Stock	141.11	141.12	140.0	140.2	217723.0
2022-05-18 04:00:00	MSFT	Stock	264.59	265.3	264.59	264.62	16567.0
2022-05-18 05:00:00	MSFT	Stock	265.15	265.42	265.06	265.06	1655.0
2022-05-18 06:00:00	MSFT	Stock	265.5	265.5	264.93	265.1	4647.0
2022-05-18 07:00:00	MSFT	Stock	265.4	265.4	263.92	264.06	18024.0
2022-05-18 08:00:00	MSFT	Stock	265.1086	266.06	263.3	263.411	47179.0
2022-05-18 09:00:00	MSFT	Stock	263.409	263.99	261.09	261.262	1802277.0
2022-05-18 10:00:00	MSFT	Stock	261.265	262.27	259.7705	260.3	2371944.0
2022-05-18 11:00:00	MSFT	Stock	260.25	260.25	256.82	256.87	1934132.0
2022-05-18 12:00:00	MSFT	Stock	256.88	257.96	256.4	257.85	1666209.0
2022-05-18 13:00:00	MSFT	Stock	257.82	257.84	254.38	255.22	1743549.0
2022-05-18 14:00:00	MSFT	Stock	255.21	255.85	253.93	254.1025	1936539.0
2022-05-18 15:00:00	MSFT	Stock	254.1289	254.95	252.77	254.14	5065732.0
2022-05-18 16:00:00	MSFT	Stock	254.14	254.6	253.21	254.26	7239107.0
2022-05-18 17:00:00	MSFT	Stock	254.2001	254.49	254.11	254.15	11639.0
2022-05-18 18:00:00	MSFT	Stock	254.3	255.0	254.11	254.75	32015.0
2022-05-18 19:00:00	MSFT	Stock	254.8	254.8	252.28	252.65	16164.0
2022-05-18 04:00:00	NVDA	Stock	18.146	18.146	17.97	18.001	106060.0
2022-05-18 05:00:00	NVDA	Stock	18.015	18.045	18.0	18.027	30090.0
2022-05-18 06:00:00	NVDA	Stock	18.067	18.088	18.001	18.009	84360.0
2022-05-18 07:00:00	NVDA	Stock	18.049	18.082	17.87	17.9	472950.0
2022-05-18 08:00:00	NVDA	Stock	18.06	18.2224	17.732	17.75	1372450.0
2022-05-18 09:00:00	NVDA	Stock	17.75	17.9733	17.558	17.84	56986930.0
2022-05-18 10:00:00	NVDA	Stock	17.8377	18.118	17.82	18.0226	74436790.0
2022-05-18 11:00:00	NVDA	Stock	18.02	18.021	17.305	17.344	67951610.0
2022-05-18 12:00:00	NVDA	Stock	17.344	17.3775	17.117	17.34	49491160.0
2022-05-18 13:00:00	NVDA	Stock	17.34	17.346	16.946	16.989	40106920.0
2022-05-18 14:00:00	NVDA	Stock	16.993	17.081	16.864	16.905	41723080.0
2022-05-18 15:00:00	NVDA	Stock	16.9045	17.1	16.8678	16.94	73673840.0
2022-05-18 16:00:00	NVDA	Stock	16.94	16.949	16.65	16.75	39173770.0
2022-05-18 17:00:00	NVDA	Stock	16.75	16.938	16.75	16.825	385220.0
2022-05-18 18:00:00	NVDA	Stock	16.829	16.85	16.77	16.825	476880.0
2022-05-18 19:00:00	NVDA	Stock	16.81	16.81	16.519	16.519	585920.0
2022-05-18 06:00:00	AMZN	Stock	114.6	114.6	113.75	113.9	18520.0
2022-05-18 07:00:00	AMZN	Stock	113.9	113.95	112.665	112.995	95920.0

> showing 50 of 63,564 rows — these rows as CSV

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