PREVIEW / stock_1hour / 2021-07-14

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-07-14.parquet
  size:    1.4 MB
  rows:    65,402
  symbols: 2,884

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
2021-07-14 04:00:00	AAPL	Stock	146.7	147.62	146.11	147.45	118757.0
2021-07-14 05:00:00	AAPL	Stock	147.4	148.09	147.4	147.97	54620.0
2021-07-14 06:00:00	AAPL	Stock	147.95	148.09	147.8	148.0	98678.0
2021-07-14 07:00:00	AAPL	Stock	147.88	148.78	147.7	148.62	611030.0
2021-07-14 08:00:00	AAPL	Stock	147.7499	148.77	145.276	148.41	1349497.0
2021-07-14 09:00:00	AAPL	Stock	148.41	148.96	145.6022	148.35	21084445.0
2021-07-14 10:00:00	AAPL	Stock	148.37	149.32	148.11	149.3184	20968041.0
2021-07-14 11:00:00	AAPL	Stock	149.315	149.45	147.93	148.015	16181949.0
2021-07-14 12:00:00	AAPL	Stock	148.015	149.2083	147.9745	148.93	11143503.0
2021-07-14 13:00:00	AAPL	Stock	148.93	149.1	148.6	148.9561	6407608.0
2021-07-14 14:00:00	AAPL	Stock	148.95	149.46	148.895	149.312	8381386.0
2021-07-14 15:00:00	AAPL	Stock	149.3142	149.57	148.82	149.21	18661423.0
2021-07-14 16:00:00	AAPL	Stock	149.15	149.32	149.02	149.26	9231197.0
2021-07-14 17:00:00	AAPL	Stock	149.3	149.54	149.28	149.43	132690.0
2021-07-14 18:00:00	AAPL	Stock	149.41	149.49	149.27	149.49	89826.0
2021-07-14 19:00:00	AAPL	Stock	149.49	149.52	149.43	149.51	69247.0
2021-07-14 04:00:00	MSFT	Stock	281.0	281.57	280.79	281.57	3041.0
2021-07-14 05:00:00	MSFT	Stock	281.7	282.5	281.7	282.2	15034.0
2021-07-14 06:00:00	MSFT	Stock	282.07	282.25	281.95	282.04	6269.0
2021-07-14 07:00:00	MSFT	Stock	282.05	282.25	281.31	282.16	24046.0
2021-07-14 08:00:00	MSFT	Stock	281.92	282.99	281.58	282.27	38444.0
2021-07-14 09:00:00	MSFT	Stock	282.38	282.75	280.55	282.12	2439527.0
2021-07-14 10:00:00	MSFT	Stock	282.13	283.54	282.079	283.205	2733549.0
2021-07-14 11:00:00	MSFT	Stock	283.21	283.66	281.6167	281.69	2292106.0
2021-07-14 12:00:00	MSFT	Stock	281.67	283.05	281.66	282.57	1352115.0
2021-07-14 13:00:00	MSFT	Stock	282.58	282.67	281.9101	282.3	1059459.0
2021-07-14 14:00:00	MSFT	Stock	282.295	283.29	282.23	282.995	1289880.0
2021-07-14 15:00:00	MSFT	Stock	282.98	283.55	282.25	282.51	3707926.0
2021-07-14 16:00:00	MSFT	Stock	282.51	282.8	282.5	282.5	3277347.0
2021-07-14 17:00:00	MSFT	Stock	282.55	282.6	282.4268	282.5	6062.0
2021-07-14 18:00:00	MSFT	Stock	282.5	282.6	282.41	282.52	7886.0
2021-07-14 19:00:00	MSFT	Stock	282.56	282.71	282.555	282.71	2030.0
2021-07-14 04:00:00	NVDA	Stock	20.25	20.2548	20.0002	20.1875	28000.0
2021-07-14 05:00:00	NVDA	Stock	20.2455	20.3263	20.2455	20.3263	60960.0
2021-07-14 06:00:00	NVDA	Stock	20.3235	20.3235	20.3	20.3008	42920.0
2021-07-14 07:00:00	NVDA	Stock	20.3003	20.3713	20.3	20.3625	1193000.0
2021-07-14 08:00:00	NVDA	Stock	20.3	20.3998	20.3	20.3625	973760.0
2021-07-14 09:00:00	NVDA	Stock	20.372	20.4178	20.0778	20.1572	33109920.0
2021-07-14 10:00:00	NVDA	Stock	20.1651	20.2766	20.0138	20.1053	26535040.0
2021-07-14 11:00:00	NVDA	Stock	20.1023	20.131	19.7528	19.759	50435120.0
2021-07-14 12:00:00	NVDA	Stock	19.7628	19.962	19.7628	19.9332	46263120.0
2021-07-14 13:00:00	NVDA	Stock	19.9298	19.9518	19.8375	19.8773	13760080.0
2021-07-14 14:00:00	NVDA	Stock	19.8791	19.9428	19.8628	19.9352	10604160.0
2021-07-14 15:00:00	NVDA	Stock	19.9341	19.9575	19.8082	19.8415	26303640.0
2021-07-14 16:00:00	NVDA	Stock	19.8415	19.8725	19.82	19.8415	18318480.0
2021-07-14 17:00:00	NVDA	Stock	19.8415	19.8728	19.8388	19.8728	163200.0
2021-07-14 18:00:00	NVDA	Stock	19.8662	19.874	19.863	19.863	49680.0
2021-07-14 19:00:00	NVDA	Stock	19.8625	19.8748	19.8563	19.87	117920.0
2021-07-14 04:00:00	AMZN	Stock	184.5	184.5	184.5	184.5	4000.0
2021-07-14 05:00:00	AMZN	Stock	185.2275	185.2275	184.9	184.9	4640.0

> showing 50 of 65,402 rows — these rows as CSV

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