PREVIEW / stock_1hour / 2021-02-16

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-02-16.parquet
  size:    1.5 MB
  rows:    73,011
  symbols: 2,827

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-02-16 04:00:00	AAPL	Stock	135.78	136.44	135.78	136.05	45139.0
2021-02-16 05:00:00	AAPL	Stock	136.05	136.14	135.82	136.09	16846.0
2021-02-16 06:00:00	AAPL	Stock	136.07	136.35	135.98	136.31	27182.0
2021-02-16 07:00:00	AAPL	Stock	136.31	136.31	135.87	135.93	156524.0
2021-02-16 08:00:00	AAPL	Stock	136.1	136.17	135.58	135.6	385134.0
2021-02-16 09:00:00	AAPL	Stock	135.6	136.01	134.69	135.045	10235186.0
2021-02-16 10:00:00	AAPL	Stock	135.045	135.15	134.15	134.32	9776839.0
2021-02-16 11:00:00	AAPL	Stock	134.305	134.325	132.95	133.105	12912960.0
2021-02-16 12:00:00	AAPL	Stock	133.11	133.73	132.91	133.475	7223483.0
2021-02-16 13:00:00	AAPL	Stock	133.48	133.56	132.79	132.921	6101266.0
2021-02-16 14:00:00	AAPL	Stock	132.928	133.64	132.92	133.165	5373623.0
2021-02-16 15:00:00	AAPL	Stock	133.17	133.46	133.02	133.16	8843389.0
2021-02-16 16:00:00	AAPL	Stock	133.19	133.25	132.88	132.97	6272558.0
2021-02-16 17:00:00	AAPL	Stock	132.96	133.19	132.95	133.02	457126.0
2021-02-16 18:00:00	AAPL	Stock	133.05	133.07	132.771	132.78	157194.0
2021-02-16 19:00:00	AAPL	Stock	132.79	132.8	132.61	132.65	183919.0
2021-02-16 04:00:00	MSFT	Stock	245.85	245.99	245.41	245.41	4848.0
2021-02-16 05:00:00	MSFT	Stock	245.41	245.55	245.41	245.55	4231.0
2021-02-16 06:00:00	MSFT	Stock	245.66	245.99	245.56	245.81	3231.0
2021-02-16 07:00:00	MSFT	Stock	245.75	245.8	245.36	245.7	30024.0
2021-02-16 08:00:00	MSFT	Stock	245.6	245.9	244.378	245.4	39054.0
2021-02-16 09:00:00	MSFT	Stock	245.45	246.13	244.08	244.4	2347385.0
2021-02-16 10:00:00	MSFT	Stock	244.4	244.73	243.795	244.0	2308857.0
2021-02-16 11:00:00	MSFT	Stock	244.025	244.45	243.35	243.488	1725741.0
2021-02-16 12:00:00	MSFT	Stock	243.43	244.37	242.92	244.28	1488962.0
2021-02-16 13:00:00	MSFT	Stock	244.28	244.78	243.47	243.515	1040537.0
2021-02-16 14:00:00	MSFT	Stock	243.51	244.08	243.2	243.464	1057669.0
2021-02-16 15:00:00	MSFT	Stock	243.46	244.03	243.15	243.71	2862845.0
2021-02-16 16:00:00	MSFT	Stock	243.7	243.7	243.38	243.38	6048801.0
2021-02-16 17:00:00	MSFT	Stock	243.38	243.7	243.25	243.34	56816.0
2021-02-16 18:00:00	MSFT	Stock	243.37	243.41	243.02	243.04	5834.0
2021-02-16 19:00:00	MSFT	Stock	243.02	243.25	242.52	243.25	9692.0
2021-02-16 04:00:00	NVDA	Stock	15.036	15.1	15.036	15.0742	60640.0
2021-02-16 05:00:00	NVDA	Stock	15.075	15.075	15.075	15.075	4000.0
2021-02-16 06:00:00	NVDA	Stock	15.0875	15.1	15.0872	15.0992	44680.0
2021-02-16 07:00:00	NVDA	Stock	15.1	15.1555	15.0875	15.1528	459720.0
2021-02-16 08:00:00	NVDA	Stock	15.1	15.1595	15.0999	15.1	1069680.0
2021-02-16 09:00:00	NVDA	Stock	15.086	15.1858	14.95	15.1258	42605120.0
2021-02-16 10:00:00	NVDA	Stock	15.1333	15.272	15.1	15.2152	37047600.0
2021-02-16 11:00:00	NVDA	Stock	15.2125	15.2315	15.041	15.0535	27692720.0
2021-02-16 12:00:00	NVDA	Stock	15.0528	15.1848	15.017	15.1721	22534840.0
2021-02-16 13:00:00	NVDA	Stock	15.175	15.3435	15.1695	15.261	34709400.0
2021-02-16 14:00:00	NVDA	Stock	15.2645	15.3725	15.2613	15.3658	28092720.0
2021-02-16 15:00:00	NVDA	Stock	15.3625	15.3658	15.2785	15.3302	39215160.0
2021-02-16 16:00:00	NVDA	Stock	15.3302	15.3498	15.3062	15.312	13681760.0
2021-02-16 17:00:00	NVDA	Stock	15.3	15.33	15.3	15.325	166200.0
2021-02-16 18:00:00	NVDA	Stock	15.33	15.3458	15.3142	15.325	161280.0
2021-02-16 19:00:00	NVDA	Stock	15.2875	15.2875	15.265	15.2875	106040.0
2021-02-16 05:00:00	AMZN	Stock	164.15	164.25	164.15	164.25	14920.0
2021-02-16 06:00:00	AMZN	Stock	164.5	164.5	164.26	164.26	29260.0

> showing 50 of 73,011 rows — these rows as CSV

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