PREVIEW / stock_1hour / 2022-05-03

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-03.parquet
  size:    1.4 MB
  rows:    62,546
  symbols: 2,433

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-03 04:00:00	AAPL	Stock	158.1	158.71	157.91	158.01	28165.0
2022-05-03 05:00:00	AAPL	Stock	158.1	158.32	157.8	158.19	11968.0
2022-05-03 06:00:00	AAPL	Stock	158.19	158.21	157.01	157.48	23845.0
2022-05-03 07:00:00	AAPL	Stock	157.44	158.1	157.26	158.1	53118.0
2022-05-03 08:00:00	AAPL	Stock	157.4	158.9	157.31	158.66	597102.0
2022-05-03 09:00:00	AAPL	Stock	158.6598	158.75	156.32	158.11	9374747.0
2022-05-03 10:00:00	AAPL	Stock	158.15	158.64	157.01	157.585	10813504.0
2022-05-03 11:00:00	AAPL	Stock	157.58	159.85	157.3028	159.3441	11714022.0
2022-05-03 12:00:00	AAPL	Stock	159.34	159.88	158.58	159.34	7947949.0
2022-05-03 13:00:00	AAPL	Stock	159.35	160.71	159.11	159.92	7826314.0
2022-05-03 14:00:00	AAPL	Stock	159.93	159.9762	158.22	159.6412	9184733.0
2022-05-03 15:00:00	AAPL	Stock	159.6399	159.92	158.54	159.48	12265652.0
2022-05-03 16:00:00	AAPL	Stock	159.48	160.17	159.28	159.57	5072282.0
2022-05-03 17:00:00	AAPL	Stock	159.5	159.7754	159.47	159.7	62010.0
2022-05-03 18:00:00	AAPL	Stock	159.7	159.94	159.6	159.6001	20531.0
2022-05-03 19:00:00	AAPL	Stock	159.59	159.7	159.45	159.68	28088.0
2022-05-03 04:00:00	MSFT	Stock	284.49	286.12	284.25	284.5	7112.0
2022-05-03 05:00:00	MSFT	Stock	284.0	285.02	284.0	285.02	3453.0
2022-05-03 06:00:00	MSFT	Stock	285.05	285.05	283.4	283.4	1187.0
2022-05-03 07:00:00	MSFT	Stock	283.7	284.4	283.28	284.4	8796.0
2022-05-03 08:00:00	MSFT	Stock	283.43	285.0	283.0018	284.64	23934.0
2022-05-03 09:00:00	MSFT	Stock	284.873	284.91	281.29	283.345	2138244.0
2022-05-03 10:00:00	MSFT	Stock	283.34	284.13	280.26	281.27	2371587.0
2022-05-03 11:00:00	MSFT	Stock	281.25	283.6	280.75	282.5	1751793.0
2022-05-03 12:00:00	MSFT	Stock	282.48	283.73	280.84	281.81	1651350.0
2022-05-03 13:00:00	MSFT	Stock	281.84	283.499	281.55	282.5049	1674457.0
2022-05-03 14:00:00	MSFT	Stock	282.49	282.57	280.15	282.39	2035484.0
2022-05-03 15:00:00	MSFT	Stock	282.36	282.97	280.28	281.83	2659444.0
2022-05-03 16:00:00	MSFT	Stock	281.78	283.21	281.71	281.8985	2717084.0
2022-05-03 17:00:00	MSFT	Stock	282.0001	282.6792	282.0	282.5	18215.0
2022-05-03 18:00:00	MSFT	Stock	282.5	282.5	282.2	282.2	6828.0
2022-05-03 19:00:00	MSFT	Stock	282.2	282.2	281.81	281.9501	4947.0
2022-05-03 04:00:00	NVDA	Stock	19.6	19.711	19.532	19.56	119680.0
2022-05-03 05:00:00	NVDA	Stock	19.554	19.59	19.535	19.59	27380.0
2022-05-03 06:00:00	NVDA	Stock	19.552	19.552	19.395	19.403	112620.0
2022-05-03 07:00:00	NVDA	Stock	19.433	19.514	19.364	19.5	197950.0
2022-05-03 08:00:00	NVDA	Stock	19.385	19.61	19.35	19.55	1231010.0
2022-05-03 09:00:00	NVDA	Stock	19.558	19.601	19.133	19.576	51089320.0
2022-05-03 10:00:00	NVDA	Stock	19.578	19.825	19.289	19.379	76865000.0
2022-05-03 11:00:00	NVDA	Stock	19.376	19.592	19.2799	19.496	49392860.0
2022-05-03 12:00:00	NVDA	Stock	19.493	19.584	19.3	19.4871	35559650.0
2022-05-03 13:00:00	NVDA	Stock	19.492	19.812	19.4798	19.723	45035370.0
2022-05-03 14:00:00	NVDA	Stock	19.722	19.737	19.307	19.648	49008880.0
2022-05-03 15:00:00	NVDA	Stock	19.6465	19.733	19.426	19.61	56214120.0
2022-05-03 16:00:00	NVDA	Stock	19.61	20.099	19.5261	19.875	15390150.0
2022-05-03 17:00:00	NVDA	Stock	19.876	20.167	19.876	20.115	2764400.0
2022-05-03 18:00:00	NVDA	Stock	20.128	20.129	20.05	20.083	408760.0
2022-05-03 19:00:00	NVDA	Stock	20.086	20.094	20.057	20.09	209660.0
2022-05-03 04:00:00	AMZN	Stock	124.5665	124.5665	124.3	124.3	4000.0
2022-05-03 06:00:00	AMZN	Stock	124.0685	124.0685	123.25	123.5	12000.0

> showing 50 of 62,546 rows — these rows as CSV

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