PREVIEW / stock_1hour / 2023-04-03

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-03.parquet
  size:    1.4 MB
  rows:    61,640
  symbols: 1,756

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
2023-04-03 04:00:00	AAPL	Stock	164.47	164.47	163.73	163.75	27580.0
2023-04-03 05:00:00	AAPL	Stock	163.79	163.98	163.79	163.9	8557.0
2023-04-03 06:00:00	AAPL	Stock	163.96	164.04	163.87	163.95	18288.0
2023-04-03 07:00:00	AAPL	Stock	163.94	164.35	163.94	164.09	54165.0
2023-04-03 08:00:00	AAPL	Stock	164.0691	164.488	163.35	164.14	254945.0
2023-04-03 09:00:00	AAPL	Stock	164.14	165.89	163.88	165.315	7449144.0
2023-04-03 10:00:00	AAPL	Stock	165.315	165.725	164.67	164.8	6857547.0
2023-04-03 11:00:00	AAPL	Stock	164.81	164.97	164.32	164.53	3982276.0
2023-04-03 12:00:00	AAPL	Stock	164.53	164.8	164.41	164.555	3154349.0
2023-04-03 13:00:00	AAPL	Stock	164.55	164.8	164.31	164.71	3255435.0
2023-04-03 14:00:00	AAPL	Stock	164.705	165.75	164.48	165.7429	4709660.0
2023-04-03 15:00:00	AAPL	Stock	165.75	166.29	165.62	166.1	8855580.0
2023-04-03 16:00:00	AAPL	Stock	166.17	166.31	166.01	166.05	5995904.0
2023-04-03 17:00:00	AAPL	Stock	166.05	166.17	165.96	165.99	75697.0
2023-04-03 18:00:00	AAPL	Stock	165.97	166.05	165.97	165.98	9135.0
2023-04-03 19:00:00	AAPL	Stock	165.98	166.02	165.95	166.02	25305.0
2023-04-03 04:00:00	MSFT	Stock	287.48	287.48	283.88	285.64	18694.0
2023-04-03 05:00:00	MSFT	Stock	285.78	286.16	285.78	285.92	3091.0
2023-04-03 06:00:00	MSFT	Stock	285.99	286.5	285.99	286.2	7382.0
2023-04-03 07:00:00	MSFT	Stock	286.34	286.66	285.66	286.1	21721.0
2023-04-03 08:00:00	MSFT	Stock	286.35	286.79	284.86	285.4	136817.0
2023-04-03 09:00:00	MSFT	Stock	285.4	287.97	285.24	287.05	3076594.0
2023-04-03 10:00:00	MSFT	Stock	287.07	288.27	285.77	285.8	2759871.0
2023-04-03 11:00:00	MSFT	Stock	285.81	286.17	284.72	285.22	2283391.0
2023-04-03 12:00:00	MSFT	Stock	285.21	285.5	284.23	284.42	1882803.0
2023-04-03 13:00:00	MSFT	Stock	284.41	285.19	283.95	284.9219	1669586.0
2023-04-03 14:00:00	MSFT	Stock	284.9045	286.46	284.09	286.18	1411316.0
2023-04-03 15:00:00	MSFT	Stock	286.19	287.6	286.15	287.13	3221374.0
2023-04-03 16:00:00	MSFT	Stock	287.23	287.59	286.9	287.1	2821663.0
2023-04-03 17:00:00	MSFT	Stock	287.07	287.2	286.93	287.0	8564.0
2023-04-03 18:00:00	MSFT	Stock	287.04	287.04	286.61	286.9899	2860.0
2023-04-03 19:00:00	MSFT	Stock	286.77	286.97	286.7	286.7	7568.0
2023-04-03 04:00:00	NVDA	Stock	27.732	27.762	27.48	27.516	216210.0
2023-04-03 05:00:00	NVDA	Stock	27.519	27.565	27.517	27.54	85720.0
2023-04-03 06:00:00	NVDA	Stock	27.555	27.582	27.522	27.541	45150.0
2023-04-03 07:00:00	NVDA	Stock	27.541	27.654	27.53	27.58	590520.0
2023-04-03 08:00:00	NVDA	Stock	27.62	27.66	27.366	27.54	1721440.0
2023-04-03 09:00:00	NVDA	Stock	27.547	27.797	27.445	27.5899	42179440.0
2023-04-03 10:00:00	NVDA	Stock	27.591	27.991	27.588	27.617	63776550.0
2023-04-03 11:00:00	NVDA	Stock	27.621	27.654	27.413	27.5222	43694860.0
2023-04-03 12:00:00	NVDA	Stock	27.522	27.62	27.374	27.3829	26871830.0
2023-04-03 13:00:00	NVDA	Stock	27.383	27.502	27.336	27.495	24219330.0
2023-04-03 14:00:00	NVDA	Stock	27.495	27.729	27.452	27.718	28928440.0
2023-04-03 15:00:00	NVDA	Stock	27.72	28.0	27.691	27.966	58369940.0
2023-04-03 16:00:00	NVDA	Stock	27.966	27.999	27.96	27.965	21295910.0
2023-04-03 17:00:00	NVDA	Stock	27.965	27.98	27.916	27.94	605360.0
2023-04-03 18:00:00	NVDA	Stock	27.93	27.94	27.92	27.931	148150.0
2023-04-03 19:00:00	NVDA	Stock	27.933	27.95	27.93	27.93	356800.0
2023-04-03 04:00:00	AMZN	Stock	102.0	102.7	102.0	102.34	23188.0
2023-04-03 05:00:00	AMZN	Stock	102.33	102.48	102.32	102.35	10179.0

> showing 50 of 61,640 rows — these rows as CSV

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