PREVIEW / stock_1hour / 2022-02-17

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-02-17.parquet
  size:    1.4 MB
  rows:    62,825
  symbols: 2,517

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-17 04:00:00	AAPL	Stock	172.0	172.0	171.29	171.42	13113.0
2022-02-17 05:00:00	AAPL	Stock	171.45	171.6	171.4	171.58	4399.0
2022-02-17 06:00:00	AAPL	Stock	171.45	171.5	171.42	171.5	1183.0
2022-02-17 07:00:00	AAPL	Stock	171.5	172.0	171.42	171.9	43980.0
2022-02-17 08:00:00	AAPL	Stock	171.7701	172.19	170.9	171.1	501175.0
2022-02-17 09:00:00	AAPL	Stock	171.1	172.55	170.74	171.2006	6326528.0
2022-02-17 10:00:00	AAPL	Stock	171.2	171.91	170.84	171.3401	8590002.0
2022-02-17 11:00:00	AAPL	Stock	171.34	171.6	171.0	171.2	4937105.0
2022-02-17 12:00:00	AAPL	Stock	171.205	171.2614	170.755	170.99	3877278.0
2022-02-17 13:00:00	AAPL	Stock	170.99	171.055	170.19	170.43	4050915.0
2022-02-17 14:00:00	AAPL	Stock	170.4299	170.43	169.31	169.51	6140630.0
2022-02-17 15:00:00	AAPL	Stock	169.51	169.54	168.47	168.92	13246396.0
2022-02-17 16:00:00	AAPL	Stock	168.92	171.5805	168.75	169.03	10955985.0
2022-02-17 17:00:00	AAPL	Stock	169.03	169.11	168.81	168.95	54146.0
2022-02-17 18:00:00	AAPL	Stock	168.95	169.15	168.75	169.06	65145.0
2022-02-17 19:00:00	AAPL	Stock	169.05	169.11	168.52	168.84	54464.0
2022-02-17 04:00:00	MSFT	Stock	297.28	297.61	297.0	297.3	6735.0
2022-02-17 05:00:00	MSFT	Stock	297.4	297.8	297.4	297.8	2815.0
2022-02-17 06:00:00	MSFT	Stock	297.46	297.6	297.3	297.55	1072.0
2022-02-17 07:00:00	MSFT	Stock	297.5	298.44	297.5	298.25	16735.0
2022-02-17 08:00:00	MSFT	Stock	298.0	298.45	295.8	296.0	56143.0
2022-02-17 09:00:00	MSFT	Stock	296.2	299.5	294.41	294.9799	2160811.0
2022-02-17 10:00:00	MSFT	Stock	294.975	295.26	293.54	294.43	2923829.0
2022-02-17 11:00:00	MSFT	Stock	294.425	295.36	294.22	294.61	1990825.0
2022-02-17 12:00:00	MSFT	Stock	294.61	294.85	293.22	294.0	1747813.0
2022-02-17 13:00:00	MSFT	Stock	293.9722	294.1399	293.11	293.58	1270252.0
2022-02-17 14:00:00	MSFT	Stock	293.58	293.81	292.32	292.4	1718308.0
2022-02-17 15:00:00	MSFT	Stock	292.41	292.61	290.0	290.75	4797089.0
2022-02-17 16:00:00	MSFT	Stock	290.73	296.3857	290.09	290.73	6360389.0
2022-02-17 17:00:00	MSFT	Stock	290.73	290.99	290.65	290.77	19577.0
2022-02-17 18:00:00	MSFT	Stock	290.77	291.18	290.58	291.1	28247.0
2022-02-17 19:00:00	MSFT	Stock	291.1	291.28	290.35	290.8	26157.0
2022-02-17 04:00:00	NVDA	Stock	25.815	25.815	25.42	25.56	454050.0
2022-02-17 05:00:00	NVDA	Stock	25.547	25.7	25.53	25.668	278400.0
2022-02-17 06:00:00	NVDA	Stock	25.638	25.658	25.517	25.55	298470.0
2022-02-17 07:00:00	NVDA	Stock	25.532	26.071	25.52	26.045	2457660.0
2022-02-17 08:00:00	NVDA	Stock	25.6451	26.232	25.55	25.73	7098870.0
2022-02-17 09:00:00	NVDA	Stock	25.747	25.9	24.4406	24.6865	118083860.0
2022-02-17 10:00:00	NVDA	Stock	24.6805	24.8324	24.165	24.5641	130812400.0
2022-02-17 11:00:00	NVDA	Stock	24.567	24.991	24.465	24.645	90921420.0
2022-02-17 12:00:00	NVDA	Stock	24.6401	24.799	24.505	24.72	45910520.0
2022-02-17 13:00:00	NVDA	Stock	24.716	24.723	24.447	24.514	41816900.0
2022-02-17 14:00:00	NVDA	Stock	24.513	24.685	24.422	24.5445	51718880.0
2022-02-17 15:00:00	NVDA	Stock	24.545	24.645	24.417	24.5119	88954250.0
2022-02-17 16:00:00	NVDA	Stock	24.521	25.2818	24.35	24.468	28476980.0
2022-02-17 17:00:00	NVDA	Stock	24.465	24.489	24.412	24.432	567940.0
2022-02-17 18:00:00	NVDA	Stock	24.416	24.46	24.38	24.445	541240.0
2022-02-17 19:00:00	NVDA	Stock	24.434	24.459	24.331	24.331	558580.0
2022-02-17 07:00:00	AMZN	Stock	158.426	159.25	158.4135	159.0675	38880.0
2022-02-17 08:00:00	AMZN	Stock	158.7	159.249	157.65	157.65	199460.0

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

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