PREVIEW / stock_1hour / 2021-03-11

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-11.parquet
  size:    1.5 MB
  rows:    69,304
  symbols: 2,897

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-03-11 04:00:00	AAPL	Stock	122.24	122.59	121.46	122.39	85522.0
2021-03-11 05:00:00	AAPL	Stock	122.4	122.9	122.29	122.81	46108.0
2021-03-11 06:00:00	AAPL	Stock	122.73	122.85	122.38	122.46	27583.0
2021-03-11 07:00:00	AAPL	Stock	122.46	122.6	121.75	122.439	558256.0
2021-03-11 08:00:00	AAPL	Stock	122.45	122.94	120.13	122.42	1060849.0
2021-03-11 09:00:00	AAPL	Stock	122.38	123.21	121.41	121.7	16257391.0
2021-03-11 10:00:00	AAPL	Stock	121.695	122.42	121.26	122.3699	14346922.0
2021-03-11 11:00:00	AAPL	Stock	122.37	122.77	122.01	122.0101	11261792.0
2021-03-11 12:00:00	AAPL	Stock	122.02	122.4501	121.73	121.84	9095526.0
2021-03-11 13:00:00	AAPL	Stock	121.8308	122.31	121.56	121.91	8544554.0
2021-03-11 14:00:00	AAPL	Stock	121.9	122.05	121.7	121.825	6593014.0
2021-03-11 15:00:00	AAPL	Stock	121.825	122.23	121.76	121.95	12284274.0
2021-03-11 16:00:00	AAPL	Stock	121.96	122.06	121.8	121.89	8538021.0
2021-03-11 17:00:00	AAPL	Stock	121.89	121.93	121.72	121.91	113927.0
2021-03-11 18:00:00	AAPL	Stock	121.9	122.14	121.87	122.07	131280.0
2021-03-11 19:00:00	AAPL	Stock	122.04	122.34	122.0	122.3	156925.0
2021-03-11 04:00:00	MSFT	Stock	236.01	236.56	236.0	236.0	5779.0
2021-03-11 05:00:00	MSFT	Stock	236.26	236.5	235.9	236.49	3750.0
2021-03-11 06:00:00	MSFT	Stock	236.25	236.35	235.78	236.0	2058.0
2021-03-11 07:00:00	MSFT	Stock	235.81	236.29	235.02	235.88	47873.0
2021-03-11 08:00:00	MSFT	Stock	235.8	236.14	231.839	235.2	38853.0
2021-03-11 09:00:00	MSFT	Stock	234.9	236.75	233.99	235.2	2535467.0
2021-03-11 10:00:00	MSFT	Stock	235.2	237.61	234.75	237.495	3201746.0
2021-03-11 11:00:00	MSFT	Stock	237.49	238.869	237.02	238.68	2602980.0
2021-03-11 12:00:00	MSFT	Stock	238.69	239.0	237.77	238.24	1770693.0
2021-03-11 13:00:00	MSFT	Stock	238.26	239.17	237.89	238.23	2211343.0
2021-03-11 14:00:00	MSFT	Stock	238.22	238.4879	237.9	238.1	1843909.0
2021-03-11 15:00:00	MSFT	Stock	238.1	238.29	236.95	237.26	3356631.0
2021-03-11 16:00:00	MSFT	Stock	237.18	237.39	237.03	237.18	5934872.0
2021-03-11 17:00:00	MSFT	Stock	237.13	237.18	236.93	237.12	3217.0
2021-03-11 18:00:00	MSFT	Stock	237.1	238.0	237.1	237.8	4781.0
2021-03-11 19:00:00	MSFT	Stock	237.8	237.8	237.5	237.76	6159.0
2021-03-11 04:00:00	NVDA	Stock	12.725	12.8778	12.725	12.8412	39920.0
2021-03-11 05:00:00	NVDA	Stock	12.853	12.8625	12.825	12.8625	67240.0
2021-03-11 06:00:00	NVDA	Stock	12.8515	12.865	12.85	12.855	112960.0
2021-03-11 07:00:00	NVDA	Stock	12.8375	12.875	12.7878	12.875	542480.0
2021-03-11 08:00:00	NVDA	Stock	12.875	12.975	12.4838	12.8753	1536520.0
2021-03-11 09:00:00	NVDA	Stock	12.8678	12.9607	12.7345	12.8803	32074280.0
2021-03-11 10:00:00	NVDA	Stock	12.8805	12.9372	12.7798	12.9143	24925920.0
2021-03-11 11:00:00	NVDA	Stock	12.9171	12.9938	12.878	12.9485	22064840.0
2021-03-11 12:00:00	NVDA	Stock	12.9495	12.9792	12.9059	12.9564	12549680.0
2021-03-11 13:00:00	NVDA	Stock	12.9562	13.0462	12.9333	12.9645	18451200.0
2021-03-11 14:00:00	NVDA	Stock	12.9673	13.0388	12.9673	13.0008	11754120.0
2021-03-11 15:00:00	NVDA	Stock	13.003	13.0458	12.9713	12.9945	26438200.0
2021-03-11 16:00:00	NVDA	Stock	12.9935	13.0075	12.9755	12.9938	26123800.0
2021-03-11 17:00:00	NVDA	Stock	12.9875	12.9963	12.9788	12.9873	117680.0
2021-03-11 18:00:00	NVDA	Stock	12.9982	13.0305	12.9982	13.025	77440.0
2021-03-11 19:00:00	NVDA	Stock	13.028	13.0542	13.0175	13.0542	264760.0
2021-03-11 04:00:00	AMZN	Stock	155.3545	155.425	155.063	155.425	12420.0
2021-03-11 05:00:00	AMZN	Stock	155.6	155.6	155.6	155.6	4560.0

> showing 50 of 69,304 rows — these rows as CSV

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