PREVIEW / stock_1hour / 2022-05-02

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-02.parquet
  size:    1.4 MB
  rows:    64,150
  symbols: 2,511

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-02 04:00:00	AAPL	Stock	158.6	158.8	157.69	157.82	43019.0
2022-05-02 05:00:00	AAPL	Stock	157.85	158.49	157.85	158.24	16025.0
2022-05-02 06:00:00	AAPL	Stock	158.06	158.59	158.0	158.03	19934.0
2022-05-02 07:00:00	AAPL	Stock	158.19	158.24	156.2	156.33	250104.0
2022-05-02 08:00:00	AAPL	Stock	158.0801	158.87	156.13	156.45	795657.0
2022-05-02 09:00:00	AAPL	Stock	156.5	158.04	155.31	156.79	13973390.0
2022-05-02 10:00:00	AAPL	Stock	156.79	157.71	154.59	156.29	19759801.0
2022-05-02 11:00:00	AAPL	Stock	156.29	156.58	155.01	155.845	12134433.0
2022-05-02 12:00:00	AAPL	Stock	155.84	156.594	154.83	155.095	9677890.0
2022-05-02 13:00:00	AAPL	Stock	155.1	155.34	153.705	154.0641	9648785.0
2022-05-02 14:00:00	AAPL	Stock	154.06	154.74	153.27	153.86	9561889.0
2022-05-02 15:00:00	AAPL	Stock	153.84	158.23	153.785	157.96	22068690.0
2022-05-02 16:00:00	AAPL	Stock	157.9	158.3	156.95	157.98	9552953.0
2022-05-02 17:00:00	AAPL	Stock	157.95	158.16	157.91	157.95	71886.0
2022-05-02 18:00:00	AAPL	Stock	157.93	157.99	157.4	157.5599	86430.0
2022-05-02 19:00:00	AAPL	Stock	157.55	157.96	157.55	157.91	38668.0
2022-05-02 04:00:00	MSFT	Stock	278.12	279.38	278.06	278.17	9618.0
2022-05-02 05:00:00	MSFT	Stock	278.21	278.91	278.15	278.88	1775.0
2022-05-02 06:00:00	MSFT	Stock	278.41	279.0	277.95	277.95	1247.0
2022-05-02 07:00:00	MSFT	Stock	278.27	278.3	275.8	276.0	26996.0
2022-05-02 08:00:00	MSFT	Stock	278.2489	278.6433	275.4355	276.23	49244.0
2022-05-02 09:00:00	MSFT	Stock	276.5882	280.5	276.22	279.79	3011618.0
2022-05-02 10:00:00	MSFT	Stock	279.76	282.49	277.05	279.98	3705860.0
2022-05-02 11:00:00	MSFT	Stock	279.98	280.81	277.75	280.81	2208096.0
2022-05-02 12:00:00	MSFT	Stock	280.76	282.3	279.69	280.245	2692889.0
2022-05-02 13:00:00	MSFT	Stock	280.29	280.77	278.64	279.36	1982970.0
2022-05-02 14:00:00	MSFT	Stock	279.35	280.205	277.42	278.29	2171596.0
2022-05-02 15:00:00	MSFT	Stock	278.29	284.94	278.06	284.6	5248071.0
2022-05-02 16:00:00	MSFT	Stock	284.47	284.6601	283.75	284.0502	3811557.0
2022-05-02 17:00:00	MSFT	Stock	284.1	284.45	283.8655	284.01	16239.0
2022-05-02 18:00:00	MSFT	Stock	283.8	284.05	283.0	283.15	28652.0
2022-05-02 19:00:00	MSFT	Stock	283.54	284.31	283.26	284.1	14622.0
2022-05-02 04:00:00	NVDA	Stock	18.586	18.777	18.541	18.59	164070.0
2022-05-02 05:00:00	NVDA	Stock	18.61	18.669	18.535	18.635	123900.0
2022-05-02 06:00:00	NVDA	Stock	18.604	18.7	18.563	18.65	47460.0
2022-05-02 07:00:00	NVDA	Stock	18.638	18.645	18.293	18.34	817680.0
2022-05-02 08:00:00	NVDA	Stock	18.6255	18.942	18.3	18.393	1227110.0
2022-05-02 09:00:00	NVDA	Stock	18.39	19.12	18.39	18.931	59088690.0
2022-05-02 10:00:00	NVDA	Stock	18.9379	19.18	18.61	18.832	75743580.0
2022-05-02 11:00:00	NVDA	Stock	18.837	19.0319	18.7281	19.015	53747340.0
2022-05-02 12:00:00	NVDA	Stock	19.009	19.214	18.8315	18.863	51324220.0
2022-05-02 13:00:00	NVDA	Stock	18.868	18.916	18.565	18.7365	42942280.0
2022-05-02 14:00:00	NVDA	Stock	18.7371	19.0315	18.606	18.901	55394200.0
2022-05-02 15:00:00	NVDA	Stock	18.899	19.574	18.86	19.536	91506210.0
2022-05-02 16:00:00	NVDA	Stock	19.536	19.594	19.465	19.589	22486160.0
2022-05-02 17:00:00	NVDA	Stock	19.579	19.64	19.57	19.595	688490.0
2022-05-02 18:00:00	NVDA	Stock	19.585	19.6	19.535	19.56	198470.0
2022-05-02 19:00:00	NVDA	Stock	19.558	19.594	19.552	19.569	206740.0
2022-05-02 04:00:00	AMZN	Stock	124.85	124.85	124.85	124.85	9420.0
2022-05-02 05:00:00	AMZN	Stock	124.543	124.543	124.543	124.543	2640.0

> showing 50 of 64,150 rows — these rows as CSV

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