PREVIEW / stock_1hour / 2021-08-18

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-08-18.parquet
  size:    1.4 MB
  rows:    64,303
  symbols: 2,783

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-08-18 04:00:00	AAPL	Stock	149.99	150.51	149.99	150.36	29958.0
2021-08-18 05:00:00	AAPL	Stock	150.4	150.69	150.32	150.38	19402.0
2021-08-18 06:00:00	AAPL	Stock	150.38	150.68	150.32	150.64	8160.0
2021-08-18 07:00:00	AAPL	Stock	150.61	150.7	150.26	150.31	103111.0
2021-08-18 08:00:00	AAPL	Stock	150.3899	150.65	149.8799	149.98	231216.0
2021-08-18 09:00:00	AAPL	Stock	149.97	150.72	149.4	149.755	9149955.0
2021-08-18 10:00:00	AAPL	Stock	149.75	150.4399	149.14	149.29	10533042.0
2021-08-18 11:00:00	AAPL	Stock	149.271	149.28	148.18	148.46	9528638.0
2021-08-18 12:00:00	AAPL	Stock	148.4493	148.93	148.35	148.6689	5942043.0
2021-08-18 13:00:00	AAPL	Stock	148.66	148.7	147.91	148.17	5275293.0
2021-08-18 14:00:00	AAPL	Stock	148.16	148.689	147.72	147.99	10921283.0
2021-08-18 15:00:00	AAPL	Stock	147.98	147.99	146.15	146.36	17612530.0
2021-08-18 16:00:00	AAPL	Stock	146.36	146.36	145.98	146.24	5961320.0
2021-08-18 17:00:00	AAPL	Stock	146.25	146.54	146.15	146.34	87533.0
2021-08-18 18:00:00	AAPL	Stock	146.34	146.44	146.29	146.44	44658.0
2021-08-18 19:00:00	AAPL	Stock	146.44	146.5	146.295	146.36	65279.0
2021-08-18 04:00:00	MSFT	Stock	292.2	292.6	291.85	292.39	4693.0
2021-08-18 05:00:00	MSFT	Stock	292.37	292.74	292.37	292.5	4850.0
2021-08-18 06:00:00	MSFT	Stock	292.4	292.87	292.01	292.87	3331.0
2021-08-18 07:00:00	MSFT	Stock	292.87	293.0	292.17	292.4	14148.0
2021-08-18 08:00:00	MSFT	Stock	292.5	292.95	292.0	292.1	31984.0
2021-08-18 09:00:00	MSFT	Stock	292.04	294.82	291.65	294.225	2075612.0
2021-08-18 10:00:00	MSFT	Stock	294.2	294.6	293.14	293.5376	1863262.0
2021-08-18 11:00:00	MSFT	Stock	293.53	293.68	292.74	293.46	1285068.0
2021-08-18 12:00:00	MSFT	Stock	293.45	294.12	293.15	293.41	1034956.0
2021-08-18 13:00:00	MSFT	Stock	293.4	293.56	293.095	293.405	821046.0
2021-08-18 14:00:00	MSFT	Stock	293.43	294.2	292.7926	293.57	1974311.0
2021-08-18 15:00:00	MSFT	Stock	293.56	293.57	290.27	290.73	3400263.0
2021-08-18 16:00:00	MSFT	Stock	290.73	290.84	289.91	290.25	3755293.0
2021-08-18 17:00:00	MSFT	Stock	290.1701	290.35	290.02	290.25	13332.0
2021-08-18 18:00:00	MSFT	Stock	290.35	290.7	290.35	290.59	7367.0
2021-08-18 19:00:00	MSFT	Stock	290.6	290.79	290.36	290.75	12326.0
2021-08-18 04:00:00	NVDA	Stock	19.44	19.5	19.43	19.47	62390.0
2021-08-18 05:00:00	NVDA	Stock	19.474	19.538	19.471	19.501	31150.0
2021-08-18 06:00:00	NVDA	Stock	19.528	19.563	19.482	19.559	83340.0
2021-08-18 07:00:00	NVDA	Stock	19.514	19.566	19.508	19.515	249030.0
2021-08-18 08:00:00	NVDA	Stock	19.56	19.569	19.475	19.495	786780.0
2021-08-18 09:00:00	NVDA	Stock	19.49	19.6337	19.36	19.592	24264010.0
2021-08-18 10:00:00	NVDA	Stock	19.595	19.622	19.456	19.4877	18485790.0
2021-08-18 11:00:00	NVDA	Stock	19.49	19.51	19.314	19.369	20694680.0
2021-08-18 12:00:00	NVDA	Stock	19.3696	19.431	19.263	19.362	20236480.0
2021-08-18 13:00:00	NVDA	Stock	19.36	19.417	19.2917	19.351	12438810.0
2021-08-18 14:00:00	NVDA	Stock	19.351	19.4425	19.1835	19.369	27313740.0
2021-08-18 15:00:00	NVDA	Stock	19.367	19.377	19.0	19.04	46735710.0
2021-08-18 16:00:00	NVDA	Stock	19.029	19.454	18.5	19.36	28263610.0
2021-08-18 17:00:00	NVDA	Stock	19.351	19.638	19.275	19.605	8364400.0
2021-08-18 18:00:00	NVDA	Stock	19.601	19.65	19.41	19.49	3385040.0
2021-08-18 19:00:00	NVDA	Stock	19.49	19.54	19.45	19.48	890000.0
2021-08-18 06:00:00	AMZN	Stock	162.5	162.5	162.5	162.5	2000.0
2021-08-18 07:00:00	AMZN	Stock	162.325	162.4175	162.26	162.35	64480.0

> showing 50 of 64,303 rows — these rows as CSV

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