PREVIEW / stock_1hour / 2022-05-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-05-10.parquet
  size:    1.4 MB
  rows:    64,814
  symbols: 2,498

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-10 04:00:00	AAPL	Stock	153.52	154.85	153.52	154.33	82046.0
2022-05-10 05:00:00	AAPL	Stock	154.32	154.64	153.5	153.6	39247.0
2022-05-10 06:00:00	AAPL	Stock	153.6	153.95	153.4	153.5	66022.0
2022-05-10 07:00:00	AAPL	Stock	153.5	153.76	153.19	153.76	92968.0
2022-05-10 08:00:00	AAPL	Stock	153.4802	156.0	153.16	155.53	655158.0
2022-05-10 09:00:00	AAPL	Stock	155.52	156.54	154.14	155.8203	14381844.0
2022-05-10 10:00:00	AAPL	Stock	155.83	156.385	153.96	154.48	14391115.0
2022-05-10 11:00:00	AAPL	Stock	154.48	154.78	153.04	153.76	11914266.0
2022-05-10 12:00:00	AAPL	Stock	153.75	154.34	152.93	153.36	8427391.0
2022-05-10 13:00:00	AAPL	Stock	153.39	156.74	153.25	156.695	11228153.0
2022-05-10 14:00:00	AAPL	Stock	156.7	156.73	155.23	156.07	10122263.0
2022-05-10 15:00:00	AAPL	Stock	156.09	156.62	154.03	154.5	13112744.0
2022-05-10 16:00:00	AAPL	Stock	154.475	154.65	154.1	154.16	10698677.0
2022-05-10 17:00:00	AAPL	Stock	154.15	154.51	154.0	154.3	110250.0
2022-05-10 18:00:00	AAPL	Stock	154.22	154.51	154.2	154.5	27513.0
2022-05-10 19:00:00	AAPL	Stock	154.53	154.7	154.35	154.5	59304.0
2022-05-10 04:00:00	MSFT	Stock	267.24	269.29	267.24	268.55	20082.0
2022-05-10 05:00:00	MSFT	Stock	268.41	268.85	267.76	267.76	5090.0
2022-05-10 06:00:00	MSFT	Stock	267.76	268.54	267.76	268.2	4476.0
2022-05-10 07:00:00	MSFT	Stock	268.0	268.3	266.86	268.19	39133.0
2022-05-10 08:00:00	MSFT	Stock	267.9999	270.9814	266.75	270.67	144101.0
2022-05-10 09:00:00	MSFT	Stock	270.8	272.91	269.08	271.9	4037078.0
2022-05-10 10:00:00	MSFT	Stock	271.91	273.56	267.39	267.5	3794526.0
2022-05-10 11:00:00	MSFT	Stock	267.5075	268.72	265.07	268.055	2840109.0
2022-05-10 12:00:00	MSFT	Stock	268.04	269.34	266.87	267.62	2221982.0
2022-05-10 13:00:00	MSFT	Stock	267.62	273.75	267.31	273.65	3090702.0
2022-05-10 14:00:00	MSFT	Stock	273.7	273.7	270.94	271.65	2366866.0
2022-05-10 15:00:00	MSFT	Stock	271.73	272.64	268.74	269.45	3487914.0
2022-05-10 16:00:00	MSFT	Stock	269.46	269.59	268.6707	268.84	5169013.0
2022-05-10 17:00:00	MSFT	Stock	269.0	269.0	268.6059	268.968	14620.0
2022-05-10 18:00:00	MSFT	Stock	268.88	270.27	268.75	270.25	28948.0
2022-05-10 19:00:00	MSFT	Stock	270.21	270.25	269.5	269.6	8805.0
2022-05-10 04:00:00	NVDA	Stock	17.177	17.399	17.109	17.34	306150.0
2022-05-10 05:00:00	NVDA	Stock	17.352	17.499	17.342	17.4	658500.0
2022-05-10 06:00:00	NVDA	Stock	17.388	17.408	17.302	17.318	62880.0
2022-05-10 07:00:00	NVDA	Stock	17.33	17.35	17.165	17.25	658510.0
2022-05-10 08:00:00	NVDA	Stock	17.3259	17.6	17.156	17.535	3348050.0
2022-05-10 09:00:00	NVDA	Stock	17.526	17.7671	17.109	17.689	78419290.0
2022-05-10 10:00:00	NVDA	Stock	17.685	18.198	17.313	17.335	132274430.0
2022-05-10 11:00:00	NVDA	Stock	17.3375	17.467	17.025	17.344	89091960.0
2022-05-10 12:00:00	NVDA	Stock	17.345	17.522	17.227	17.2897	62168880.0
2022-05-10 13:00:00	NVDA	Stock	17.292	17.941	17.2594	17.93	68097210.0
2022-05-10 14:00:00	NVDA	Stock	17.932	18.076	17.721	17.905	72986190.0
2022-05-10 15:00:00	NVDA	Stock	17.902	18.029	17.564	17.589	67248200.0
2022-05-10 16:00:00	NVDA	Stock	17.59	17.6195	17.505	17.5094	28279200.0
2022-05-10 17:00:00	NVDA	Stock	17.51	17.56	17.505	17.545	163440.0
2022-05-10 18:00:00	NVDA	Stock	17.545	17.591	17.522	17.588	230260.0
2022-05-10 19:00:00	NVDA	Stock	17.575	17.613	17.54	17.54	214610.0
2022-05-10 04:00:00	AMZN	Stock	110.15	110.95	110.0	110.8	41000.0
2022-05-10 05:00:00	AMZN	Stock	110.8	110.85	110.76	110.76	27340.0

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

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