PREVIEW / stock_1hour / 2021-05-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-05-11.parquet
  size:    1.5 MB
  rows:    68,791
  symbols: 3,009

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-05-11 04:00:00	AAPL	Stock	124.75	125.25	124.04	124.77	81041.0
2021-05-11 05:00:00	AAPL	Stock	124.61	125.0	124.55	124.74	63589.0
2021-05-11 06:00:00	AAPL	Stock	124.65	124.69	124.12	124.53	84412.0
2021-05-11 07:00:00	AAPL	Stock	124.35	124.77	123.7	123.7	611343.0
2021-05-11 08:00:00	AAPL	Stock	124.4	124.7696	122.9	123.0	1285728.0
2021-05-11 09:00:00	AAPL	Stock	123.0	126.85	122.77	124.7085	21711900.0
2021-05-11 10:00:00	AAPL	Stock	124.71	124.72	123.26	124.24	17573613.0
2021-05-11 11:00:00	AAPL	Stock	124.24	125.42	123.9416	125.13	12581996.0
2021-05-11 12:00:00	AAPL	Stock	125.14	125.725	124.73	124.9595	9525967.0
2021-05-11 13:00:00	AAPL	Stock	124.95	126.1699	124.885	125.926	8656320.0
2021-05-11 14:00:00	AAPL	Stock	125.9299	126.27	125.5101	125.735	9416144.0
2021-05-11 15:00:00	AAPL	Stock	125.73	126.22	125.28	125.85	13188313.0
2021-05-11 16:00:00	AAPL	Stock	125.85	125.94	125.53	125.65	6613657.0
2021-05-11 17:00:00	AAPL	Stock	125.65	126.85	125.5	125.65	55383.0
2021-05-11 18:00:00	AAPL	Stock	125.65	125.88	125.62	125.62	38811.0
2021-05-11 19:00:00	AAPL	Stock	125.64	125.76	125.45	125.72	50245.0
2021-05-11 04:00:00	MSFT	Stock	243.66	244.05	243.21	243.74	17448.0
2021-05-11 05:00:00	MSFT	Stock	244.18	244.49	243.91	244.3	14186.0
2021-05-11 06:00:00	MSFT	Stock	243.89	244.46	243.64	244.34	18819.0
2021-05-11 07:00:00	MSFT	Stock	244.34	245.88	243.65	244.15	99091.0
2021-05-11 08:00:00	MSFT	Stock	244.24	245.5	243.7	244.51	130898.0
2021-05-11 09:00:00	MSFT	Stock	244.51	247.18	242.57	244.82	4140499.0
2021-05-11 10:00:00	MSFT	Stock	244.82	245.7797	243.87	245.19	3645959.0
2021-05-11 11:00:00	MSFT	Stock	245.16	246.6	244.18	245.94	2553885.0
2021-05-11 12:00:00	MSFT	Stock	245.98	246.48	244.66	245.05	1762340.0
2021-05-11 13:00:00	MSFT	Stock	245.03	245.93	244.87	245.14	1839934.0
2021-05-11 14:00:00	MSFT	Stock	245.17	246.16	244.7	245.7199	2354537.0
2021-05-11 15:00:00	MSFT	Stock	245.69	246.5	244.85	246.228	3440083.0
2021-05-11 16:00:00	MSFT	Stock	246.23	246.38	245.51	245.67	4774856.0
2021-05-11 17:00:00	MSFT	Stock	245.67	247.18	245.55	245.61	4208.0
2021-05-11 18:00:00	MSFT	Stock	245.78	245.93	245.64	245.9	2230.0
2021-05-11 19:00:00	MSFT	Stock	245.81	245.9	245.62	245.78	7315.0
2021-05-11 04:00:00	NVDA	Stock	13.9805	14.0	13.925	13.925	105520.0
2021-05-11 05:00:00	NVDA	Stock	13.914	13.914	13.9008	13.9008	17760.0
2021-05-11 06:00:00	NVDA	Stock	13.8732	13.8875	13.8732	13.8875	41240.0
2021-05-11 07:00:00	NVDA	Stock	13.8875	13.9062	13.775	13.8	834640.0
2021-05-11 08:00:00	NVDA	Stock	13.875	13.9125	13.7312	13.7965	1519640.0
2021-05-11 09:00:00	NVDA	Stock	13.796	14.179	13.7155	14.1588	38179440.0
2021-05-11 10:00:00	NVDA	Stock	14.1635	14.1722	13.8732	14.03	31104760.0
2021-05-11 11:00:00	NVDA	Stock	14.0325	14.223	13.9447	14.19	23826120.0
2021-05-11 12:00:00	NVDA	Stock	14.1946	14.2695	14.1312	14.1647	14808280.0
2021-05-11 13:00:00	NVDA	Stock	14.1652	14.3548	14.16	14.2902	13239840.0
2021-05-11 14:00:00	NVDA	Stock	14.294	14.3295	14.2233	14.2628	12047520.0
2021-05-11 15:00:00	NVDA	Stock	14.2628	14.33	14.1992	14.3062	20509960.0
2021-05-11 16:00:00	NVDA	Stock	14.3042	14.3075	14.2812	14.29	9583920.0
2021-05-11 17:00:00	NVDA	Stock	14.2902	14.2958	14.2658	14.279	99240.0
2021-05-11 18:00:00	NVDA	Stock	14.282	14.2998	14.275	14.2875	54280.0
2021-05-11 19:00:00	NVDA	Stock	14.285	14.3058	14.285	14.2875	32440.0
2021-05-11 04:00:00	AMZN	Stock	157.75	157.75	157.251	157.392	27000.0
2021-05-11 05:00:00	AMZN	Stock	157.25	157.25	157.25	157.25	15420.0

> showing 50 of 68,791 rows — these rows as CSV

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