PREVIEW / stock_1hour / 2022-02-18

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-18.parquet
  size:    1.4 MB
  rows:    63,345
  symbols: 2,520

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-02-18 04:00:00	AAPL	Stock	169.84	169.91	169.58	169.78	8355.0
2022-02-18 05:00:00	AAPL	Stock	169.8	170.05	169.6	169.89	12811.0
2022-02-18 06:00:00	AAPL	Stock	169.99	170.1	169.61	169.8	15889.0
2022-02-18 07:00:00	AAPL	Stock	169.8	170.07	169.76	169.9	45710.0
2022-02-18 08:00:00	AAPL	Stock	169.9899	170.99	168.67	169.49	274671.0
2022-02-18 09:00:00	AAPL	Stock	169.36	170.5413	167.97	169.01	10442911.0
2022-02-18 10:00:00	AAPL	Stock	169.02	169.1154	167.67	168.06	7922242.0
2022-02-18 11:00:00	AAPL	Stock	168.04	168.36	167.21	167.3	7030431.0
2022-02-18 12:00:00	AAPL	Stock	167.29	168.0711	166.63	166.67	6819990.0
2022-02-18 13:00:00	AAPL	Stock	166.67	167.3	166.19	167.07	5917073.0
2022-02-18 14:00:00	AAPL	Stock	167.06	168.66	167.03	168.2901	7011146.0
2022-02-18 15:00:00	AAPL	Stock	168.29	168.6556	166.76	167.6	11910742.0
2022-02-18 16:00:00	AAPL	Stock	167.42	167.56	167.13	167.39	9416439.0
2022-02-18 17:00:00	AAPL	Stock	167.41	167.42	166.8	166.8	96418.0
2022-02-18 18:00:00	AAPL	Stock	166.81	166.88	166.32	166.47	39475.0
2022-02-18 19:00:00	AAPL	Stock	166.49	166.53	166.3	166.5	30206.0
2022-02-18 04:00:00	MSFT	Stock	291.92	292.27	291.51	292.1	4412.0
2022-02-18 05:00:00	MSFT	Stock	292.5	293.0	292.5	292.8	3446.0
2022-02-18 06:00:00	MSFT	Stock	292.8	293.01	292.57	292.6	5911.0
2022-02-18 07:00:00	MSFT	Stock	292.62	293.0	292.35	293.0	17582.0
2022-02-18 08:00:00	MSFT	Stock	292.85	293.1	290.86	291.9	93414.0
2022-02-18 09:00:00	MSFT	Stock	291.6096	293.86	289.9325	291.29	3670224.0
2022-02-18 10:00:00	MSFT	Stock	291.32	291.505	288.27	289.53	2563631.0
2022-02-18 11:00:00	MSFT	Stock	289.51	290.68	288.45	289.33	2412449.0
2022-02-18 12:00:00	MSFT	Stock	289.32	290.31	287.44	287.4701	2297546.0
2022-02-18 13:00:00	MSFT	Stock	287.5066	287.985	286.305	287.63	2074098.0
2022-02-18 14:00:00	MSFT	Stock	287.62	290.36	287.57	289.93	2494767.0
2022-02-18 15:00:00	MSFT	Stock	289.89	290.5277	286.92	287.82	3876955.0
2022-02-18 16:00:00	MSFT	Stock	287.93	288.89	287.25	287.58	5255037.0
2022-02-18 17:00:00	MSFT	Stock	287.65	287.65	286.27	286.45	24727.0
2022-02-18 18:00:00	MSFT	Stock	286.36	286.5	286.0	286.1	10178.0
2022-02-18 19:00:00	MSFT	Stock	286.06	286.06	285.7	285.8	16530.0
2022-02-18 04:00:00	NVDA	Stock	24.629	24.87	24.615	24.86	164330.0
2022-02-18 05:00:00	NVDA	Stock	24.86	24.86	24.809	24.809	92020.0
2022-02-18 06:00:00	NVDA	Stock	24.801	24.825	24.75	24.754	186400.0
2022-02-18 07:00:00	NVDA	Stock	24.759	24.76	24.634	24.72	657040.0
2022-02-18 08:00:00	NVDA	Stock	24.7308	24.899	24.361	24.52	2168350.0
2022-02-18 09:00:00	NVDA	Stock	24.525	24.986	24.039	24.337	74280320.0
2022-02-18 10:00:00	NVDA	Stock	24.341	24.37	23.296	23.452	110621210.0
2022-02-18 11:00:00	NVDA	Stock	23.44	23.625	23.175	23.4293	66315440.0
2022-02-18 12:00:00	NVDA	Stock	23.422	23.818	23.35	23.383	46996160.0
2022-02-18 13:00:00	NVDA	Stock	23.385	23.625	23.1	23.512	64518370.0
2022-02-18 14:00:00	NVDA	Stock	23.509	24.064	23.501	24.031	77731090.0
2022-02-18 15:00:00	NVDA	Stock	24.034	24.174	23.554	23.639	85866070.0
2022-02-18 16:00:00	NVDA	Stock	23.634	23.68	23.513	23.513	31860810.0
2022-02-18 17:00:00	NVDA	Stock	23.538	23.642	23.291	23.301	1135020.0
2022-02-18 18:00:00	NVDA	Stock	23.3	23.319	23.176	23.207	776020.0
2022-02-18 19:00:00	NVDA	Stock	23.21	23.25	23.18	23.2	586480.0
2022-02-18 04:00:00	AMZN	Stock	155.9005	155.9005	155.9005	155.9005	2000.0
2022-02-18 06:00:00	AMZN	Stock	155.7875	155.7875	155.7875	155.7875	3260.0

> showing 50 of 63,345 rows — these rows as CSV

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