PREVIEW / stock_1hour / 2021-06-07

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-06-07.parquet
  size:    1.4 MB
  rows:    66,245
  symbols: 2,962

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-06-07 04:00:00	AAPL	Stock	125.64	125.65	125.2	125.36	47095.0
2021-06-07 05:00:00	AAPL	Stock	125.36	125.36	125.08	125.2	13967.0
2021-06-07 06:00:00	AAPL	Stock	125.2	125.4	125.17	125.35	8514.0
2021-06-07 07:00:00	AAPL	Stock	125.36	126.26	125.34	126.15	179527.0
2021-06-07 08:00:00	AAPL	Stock	126.0001	126.47	125.43	126.35	411077.0
2021-06-07 09:00:00	AAPL	Stock	126.34	126.34	124.89	125.23	10785092.0
2021-06-07 10:00:00	AAPL	Stock	125.2384	125.41	124.86	125.1	9825046.0
2021-06-07 11:00:00	AAPL	Stock	125.09	125.2	124.8321	125.005	7522009.0
2021-06-07 12:00:00	AAPL	Stock	125.005	125.44	124.99	125.335	5909517.0
2021-06-07 13:00:00	AAPL	Stock	125.33	125.48	125.0117	125.02	5218967.0
2021-06-07 14:00:00	AAPL	Stock	125.03	125.25	124.91	125.2108	5806086.0
2021-06-07 15:00:00	AAPL	Stock	125.2111	126.03	125.155	125.9	10891893.0
2021-06-07 16:00:00	AAPL	Stock	125.97	126.1	125.301	126.0	5522819.0
2021-06-07 17:00:00	AAPL	Stock	126.0	126.02	125.85	125.94	70500.0
2021-06-07 18:00:00	AAPL	Stock	125.96	126.0	125.8	125.87	54847.0
2021-06-07 19:00:00	AAPL	Stock	125.87	125.98	125.81	125.96	69884.0
2021-06-07 04:00:00	MSFT	Stock	249.97	250.01	249.56	250.01	485.0
2021-06-07 05:00:00	MSFT	Stock	250.2	250.2	249.58	249.58	1335.0
2021-06-07 06:00:00	MSFT	Stock	249.4	249.58	249.35	249.58	1541.0
2021-06-07 07:00:00	MSFT	Stock	249.74	250.7	249.6	250.28	24162.0
2021-06-07 08:00:00	MSFT	Stock	249.88	250.7	249.75	250.17	37550.0
2021-06-07 09:00:00	MSFT	Stock	250.27	252.22	249.53	252.11	2443875.0
2021-06-07 10:00:00	MSFT	Stock	252.12	252.96	251.95	252.95	2523619.0
2021-06-07 11:00:00	MSFT	Stock	252.95	253.22	252.22	252.3993	2574611.0
2021-06-07 12:00:00	MSFT	Stock	252.4	252.82	252.24	252.29	1377560.0
2021-06-07 13:00:00	MSFT	Stock	252.31	252.46	252.04	252.29	1294551.0
2021-06-07 14:00:00	MSFT	Stock	252.31	252.79	252.1	252.7199	1030031.0
2021-06-07 15:00:00	MSFT	Stock	252.715	254.09	252.5101	253.86	3543892.0
2021-06-07 16:00:00	MSFT	Stock	253.81	254.6	253.81	254.5	4000605.0
2021-06-07 17:00:00	MSFT	Stock	254.51	254.64	254.38	254.47	10708.0
2021-06-07 18:00:00	MSFT	Stock	254.6	254.7	254.49	254.64	14203.0
2021-06-07 19:00:00	MSFT	Stock	254.64	254.95	254.52	254.9	13617.0
2021-06-07 04:00:00	NVDA	Stock	17.4875	17.4875	17.4875	17.4875	12560.0
2021-06-07 05:00:00	NVDA	Stock	17.501	17.501	17.4482	17.4482	13920.0
2021-06-07 06:00:00	NVDA	Stock	17.4625	17.498	17.4625	17.498	97640.0
2021-06-07 07:00:00	NVDA	Stock	17.4765	17.5962	17.4765	17.5912	530200.0
2021-06-07 08:00:00	NVDA	Stock	17.5075	17.647	17.5	17.6325	1139760.0
2021-06-07 09:00:00	NVDA	Stock	17.6288	17.8125	17.5415	17.6189	77099840.0
2021-06-07 10:00:00	NVDA	Stock	17.625	17.6687	17.3864	17.4742	79105800.0
2021-06-07 11:00:00	NVDA	Stock	17.4745	17.475	17.1928	17.3575	75941040.0
2021-06-07 12:00:00	NVDA	Stock	17.3572	17.475	17.344	17.4666	44394240.0
2021-06-07 13:00:00	NVDA	Stock	17.4656	17.475	17.3875	17.4322	17286880.0
2021-06-07 14:00:00	NVDA	Stock	17.4311	17.5648	17.4292	17.5429	30504880.0
2021-06-07 15:00:00	NVDA	Stock	17.5388	17.661	17.523	17.6145	50166920.0
2021-06-07 16:00:00	NVDA	Stock	17.619	17.6248	17.5975	17.6002	17946200.0
2021-06-07 17:00:00	NVDA	Stock	17.6	17.6002	17.5775	17.5872	99280.0
2021-06-07 18:00:00	NVDA	Stock	17.6	17.6	17.5525	17.5525	52280.0
2021-06-07 19:00:00	NVDA	Stock	17.553	17.5812	17.553	17.5625	267720.0
2021-06-07 05:00:00	AMZN	Stock	159.75	159.75	159.75	159.75	3800.0
2021-06-07 07:00:00	AMZN	Stock	160.15	160.4955	160.15	160.4	51340.0

> showing 50 of 66,245 rows — these rows as CSV

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