PREVIEW / stock_1hour / 2022-03-15

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-15.parquet
  size:    1.4 MB
  rows:    64,274
  symbols: 2,487

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-03-15 04:00:00	AAPL	Stock	149.4	150.9	149.12	149.3	93527.0
2022-03-15 05:00:00	AAPL	Stock	149.3	150.0	148.93	149.4	53558.0
2022-03-15 06:00:00	AAPL	Stock	149.5	150.76	149.5	150.22	39897.0
2022-03-15 07:00:00	AAPL	Stock	150.24	150.89	150.03	150.26	151884.0
2022-03-15 08:00:00	AAPL	Stock	150.4518	152.16	150.01	150.98	678215.0
2022-03-15 09:00:00	AAPL	Stock	150.99	152.2989	150.31	151.5607	10557958.0
2022-03-15 10:00:00	AAPL	Stock	151.56	152.775	150.68	152.5	11277099.0
2022-03-15 11:00:00	AAPL	Stock	152.515	154.22	152.29	153.3383	9784227.0
2022-03-15 12:00:00	AAPL	Stock	153.33	154.67	153.03	154.115	7710544.0
2022-03-15 13:00:00	AAPL	Stock	154.13	154.18	153.13	153.6982	5707096.0
2022-03-15 14:00:00	AAPL	Stock	153.69	154.4499	152.83	154.4	7604594.0
2022-03-15 15:00:00	AAPL	Stock	154.39	155.57	154.27	155.16	14677908.0
2022-03-15 16:00:00	AAPL	Stock	155.08	155.15	154.71	154.96	11240396.0
2022-03-15 17:00:00	AAPL	Stock	154.94	155.06	154.84	154.85	28733.0
2022-03-15 18:00:00	AAPL	Stock	154.89	154.9	154.59	154.77	46925.0
2022-03-15 19:00:00	AAPL	Stock	154.73	155.1	154.65	155.0	36750.0
2022-03-15 04:00:00	MSFT	Stock	275.8	276.88	275.15	275.4	6848.0
2022-03-15 05:00:00	MSFT	Stock	275.43	277.18	274.62	275.85	8719.0
2022-03-15 06:00:00	MSFT	Stock	277.04	278.59	276.6	278.28	7729.0
2022-03-15 07:00:00	MSFT	Stock	278.21	279.0	277.02	277.51	12217.0
2022-03-15 08:00:00	MSFT	Stock	278.1666	280.88	277.0	279.3	64210.0
2022-03-15 09:00:00	MSFT	Stock	279.5	281.87	278.725	280.3399	2632903.0
2022-03-15 10:00:00	MSFT	Stock	280.33	281.99	279.375	280.99	2681772.0
2022-03-15 11:00:00	MSFT	Stock	281.02	284.81	280.695	282.8	2672126.0
2022-03-15 12:00:00	MSFT	Stock	282.78	285.24	281.62	284.53	2264509.0
2022-03-15 13:00:00	MSFT	Stock	284.51	284.86	282.98	284.45	1631902.0
2022-03-15 14:00:00	MSFT	Stock	284.44	284.99	282.5	284.92	1868154.0
2022-03-15 15:00:00	MSFT	Stock	284.92	287.82	284.65	287.25	4743268.0
2022-03-15 16:00:00	MSFT	Stock	287.15	287.32	286.502	286.56	6197276.0
2022-03-15 17:00:00	MSFT	Stock	286.7	287.0	286.61	286.9	6482.0
2022-03-15 18:00:00	MSFT	Stock	286.9	286.9	286.62	286.6501	7403.0
2022-03-15 19:00:00	MSFT	Stock	286.6999	287.3	286.25	287.28	16825.0
2022-03-15 04:00:00	NVDA	Stock	21.3505	21.4	21.037	21.037	64610.0
2022-03-15 05:00:00	NVDA	Stock	21.08	21.22	20.987	21.113	99840.0
2022-03-15 06:00:00	NVDA	Stock	21.127	21.5	21.127	21.494	60320.0
2022-03-15 07:00:00	NVDA	Stock	21.465	21.53	21.281	21.367	499910.0
2022-03-15 08:00:00	NVDA	Stock	21.444	21.7	21.28	21.535	1839700.0
2022-03-15 09:00:00	NVDA	Stock	21.515	21.849	21.322	21.759	39340300.0
2022-03-15 10:00:00	NVDA	Stock	21.756	22.587	21.7344	22.454	67656260.0
2022-03-15 11:00:00	NVDA	Stock	22.448	22.807	22.416	22.539	50580610.0
2022-03-15 12:00:00	NVDA	Stock	22.544	22.827	22.456	22.733	43128970.0
2022-03-15 13:00:00	NVDA	Stock	22.733	22.834	22.622	22.786	32736430.0
2022-03-15 14:00:00	NVDA	Stock	22.783	22.869	22.5536	22.849	36271410.0
2022-03-15 15:00:00	NVDA	Stock	22.848	23.038	22.79	22.963	62652170.0
2022-03-15 16:00:00	NVDA	Stock	22.973	22.989	22.89	22.95	26844830.0
2022-03-15 17:00:00	NVDA	Stock	22.944	23.118	22.9319	23.05	761340.0
2022-03-15 18:00:00	NVDA	Stock	23.051	23.085	23.003	23.069	161350.0
2022-03-15 19:00:00	NVDA	Stock	23.075	23.11	23.04	23.062	340750.0
2022-03-15 05:00:00	AMZN	Stock	141.5	141.5	141.5	141.5	16000.0
2022-03-15 06:00:00	AMZN	Stock	141.67	143.086	141.67	143.086	22580.0

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

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