PREVIEW / stock_1hour / 2022-03-10

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-03-10.parquet
  size:    1.4 MB
  rows:    64,124
  symbols: 2,485

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-10 04:00:00	AAPL	Stock	161.75	162.0	160.64	160.99	37895.0
2022-03-10 05:00:00	AAPL	Stock	161.0	161.34	160.5	160.53	18643.0
2022-03-10 06:00:00	AAPL	Stock	160.53	160.75	159.92	160.1	24998.0
2022-03-10 07:00:00	AAPL	Stock	160.24	160.94	160.0	160.0	188892.0
2022-03-10 08:00:00	AAPL	Stock	160.4002	162.48	159.85	160.18	755295.0
2022-03-10 09:00:00	AAPL	Stock	160.18	160.4	158.03	158.921	13011626.0
2022-03-10 10:00:00	AAPL	Stock	158.93	158.95	157.6	157.78	11583793.0
2022-03-10 11:00:00	AAPL	Stock	157.77	157.77	156.4	157.3601	11195142.0
2022-03-10 12:00:00	AAPL	Stock	157.36	157.5	156.0	156.07	8042902.0
2022-03-10 13:00:00	AAPL	Stock	156.06	157.738	155.98	157.55	8299603.0
2022-03-10 14:00:00	AAPL	Stock	157.55	159.19	157.41	159.015	9504829.0
2022-03-10 15:00:00	AAPL	Stock	159.02	159.08	157.41	158.52	13201478.0
2022-03-10 16:00:00	AAPL	Stock	158.36	158.52	157.99	158.19	10739375.0
2022-03-10 17:00:00	AAPL	Stock	158.15	158.52	157.87	158.0	48650.0
2022-03-10 18:00:00	AAPL	Stock	158.04	158.5	158.04	158.36	68709.0
2022-03-10 19:00:00	AAPL	Stock	158.4	158.54	158.0	158.05	82834.0
2022-03-10 04:00:00	MSFT	Stock	288.5	288.5	283.25	283.85	5817.0
2022-03-10 05:00:00	MSFT	Stock	284.09	284.18	283.5	283.62	5013.0
2022-03-10 06:00:00	MSFT	Stock	283.12	283.99	282.0	282.58	4903.0
2022-03-10 07:00:00	MSFT	Stock	283.07	283.5	282.2	282.31	33738.0
2022-03-10 08:00:00	MSFT	Stock	282.5784	286.0	282.01	282.24	74442.0
2022-03-10 09:00:00	MSFT	Stock	282.4	285.09	282.1	284.21	3042156.0
2022-03-10 10:00:00	MSFT	Stock	284.2	285.0	281.86	282.1919	2932657.0
2022-03-10 11:00:00	MSFT	Stock	282.17	282.18	280.58	281.603	2461968.0
2022-03-10 12:00:00	MSFT	Stock	281.62	283.0	281.42	282.31	1699558.0
2022-03-10 13:00:00	MSFT	Stock	282.3	285.085	282.25	284.62	2006463.0
2022-03-10 14:00:00	MSFT	Stock	284.64	286.6	284.33	286.185	1970691.0
2022-03-10 15:00:00	MSFT	Stock	286.24	286.52	284.61	285.55	2641437.0
2022-03-10 16:00:00	MSFT	Stock	285.59	285.59	284.8	285.07	4145421.0
2022-03-10 17:00:00	MSFT	Stock	284.997	285.59	284.75	284.75	9158.0
2022-03-10 18:00:00	MSFT	Stock	284.88	285.9	284.87	285.65	14327.0
2022-03-10 19:00:00	MSFT	Stock	285.65	285.79	285.1	285.31	10264.0
2022-03-10 04:00:00	NVDA	Stock	22.55	22.8	22.55	22.612	105500.0
2022-03-10 05:00:00	NVDA	Stock	22.686	22.686	22.51	22.51	94320.0
2022-03-10 06:00:00	NVDA	Stock	22.503	22.551	22.4	22.422	91540.0
2022-03-10 07:00:00	NVDA	Stock	22.444	22.534	22.422	22.425	620120.0
2022-03-10 08:00:00	NVDA	Stock	22.425	22.673	22.335	22.37	2343380.0
2022-03-10 09:00:00	NVDA	Stock	22.38	22.7	22.142	22.426	45861840.0
2022-03-10 10:00:00	NVDA	Stock	22.42	22.528	21.985	22.03	55667870.0
2022-03-10 11:00:00	NVDA	Stock	22.028	22.141	21.882	22.128	34932620.0
2022-03-10 12:00:00	NVDA	Stock	22.131	22.239	22.006	22.04	28083660.0
2022-03-10 13:00:00	NVDA	Stock	22.037	22.388	22.02	22.366	27468590.0
2022-03-10 14:00:00	NVDA	Stock	22.371	22.745	22.33	22.685	38223050.0
2022-03-10 15:00:00	NVDA	Stock	22.689	22.788	22.534	22.664	43011430.0
2022-03-10 16:00:00	NVDA	Stock	22.658	22.705	22.579	22.628	26084710.0
2022-03-10 17:00:00	NVDA	Stock	22.58	22.658	22.55	22.571	132260.0
2022-03-10 18:00:00	NVDA	Stock	22.61	22.71	22.61	22.665	251820.0
2022-03-10 19:00:00	NVDA	Stock	22.665	22.69	22.6	22.6	176240.0
2022-03-10 04:00:00	AMZN	Stock	148.75	149.0	148.75	148.75	35400.0
2022-03-10 05:00:00	AMZN	Stock	148.65	148.65	147.6	148.5	36040.0

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

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