PREVIEW / stock_1hour / 2020-06-29

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-06-29.parquet
  size:    1.3 MB
  rows:    58,002
  symbols: 2,451

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
2020-06-29 04:00:00	AAPL	Stock	88.5	88.6625	88.45	88.6625	5600.0
2020-06-29 05:00:00	AAPL	Stock	88.6625	88.7725	88.575	88.7725	14812.0
2020-06-29 06:00:00	AAPL	Stock	88.6275	88.745	88.5075	88.745	87852.0
2020-06-29 07:00:00	AAPL	Stock	88.68	88.8	88.0875	88.75	353112.0
2020-06-29 08:00:00	AAPL	Stock	88.755	88.8675	88.215	88.475	415976.0
2020-06-29 09:00:00	AAPL	Stock	88.48	89.12	87.82	88.77	18068160.0
2020-06-29 10:00:00	AAPL	Stock	88.7732	89.7725	88.6725	89.5498	18341556.0
2020-06-29 11:00:00	AAPL	Stock	89.55	90.2375	89.2275	90.01	15449268.0
2020-06-29 12:00:00	AAPL	Stock	90.02	90.5435	89.95	90.345	10540140.0
2020-06-29 13:00:00	AAPL	Stock	90.35	90.45	89.9775	90.1963	8586360.0
2020-06-29 14:00:00	AAPL	Stock	90.2025	90.36	89.74	89.8582	7794832.0
2020-06-29 15:00:00	AAPL	Stock	89.8625	90.5075	89.63	90.5	15721096.0
2020-06-29 16:00:00	AAPL	Stock	90.445	90.7175	90.375	90.6625	9357904.0
2020-06-29 17:00:00	AAPL	Stock	90.6625	90.6625	90.5	90.55	44428.0
2020-06-29 18:00:00	AAPL	Stock	90.5575	90.81	90.5575	90.75	137840.0
2020-06-29 19:00:00	AAPL	Stock	90.7625	90.8	90.625	90.625	135152.0
2020-06-29 04:00:00	MSFT	Stock	195.5	196.33	195.5	196.28	2350.0
2020-06-29 05:00:00	MSFT	Stock	196.6	196.6	196.16	196.16	1907.0
2020-06-29 06:00:00	MSFT	Stock	196.35	197.4	196.04	197.0	5620.0
2020-06-29 07:00:00	MSFT	Stock	196.25	197.4	196.0	196.92	39760.0
2020-06-29 08:00:00	MSFT	Stock	196.4	197.4	195.923	196.5	53478.0
2020-06-29 09:00:00	MSFT	Stock	196.305	196.48	193.55	194.88	3656997.0
2020-06-29 10:00:00	MSFT	Stock	194.88	196.84	194.38	196.09	3446750.0
2020-06-29 11:00:00	MSFT	Stock	196.11	197.76	195.63	197.399	2661633.0
2020-06-29 12:00:00	MSFT	Stock	197.4	198.1	197.4	197.5	1825975.0
2020-06-29 13:00:00	MSFT	Stock	197.5	198.17	197.15	198.03	1480437.0
2020-06-29 14:00:00	MSFT	Stock	198.035	198.2	197.09	197.28	1728060.0
2020-06-29 15:00:00	MSFT	Stock	197.3	198.53	196.8	198.5	3662638.0
2020-06-29 16:00:00	MSFT	Stock	198.44	199.19	198.3	198.9	2735986.0
2020-06-29 17:00:00	MSFT	Stock	198.92	199.16	198.44	198.72	68096.0
2020-06-29 18:00:00	MSFT	Stock	198.83	199.5	198.76	199.0	9876.0
2020-06-29 19:00:00	MSFT	Stock	199.15	199.29	199.0	199.0	6614.0
2020-06-29 04:00:00	NVDA	Stock	9.15	9.15	9.15	9.15	66320.0
2020-06-29 05:00:00	NVDA	Stock	9.1625	9.1625	9.1625	9.1625	19800.0
2020-06-29 06:00:00	NVDA	Stock	9.1618	9.162	9.131	9.162	48040.0
2020-06-29 07:00:00	NVDA	Stock	9.162	9.235	9.1402	9.235	650040.0
2020-06-29 08:00:00	NVDA	Stock	9.145	9.2382	9.1345	9.18	1231920.0
2020-06-29 09:00:00	NVDA	Stock	9.163	9.2005	8.9	9.0068	64114200.0
2020-06-29 10:00:00	NVDA	Stock	9.0092	9.1188	8.9974	9.0645	55506920.0
2020-06-29 11:00:00	NVDA	Stock	9.0675	9.1048	9.0038	9.0928	49368000.0
2020-06-29 12:00:00	NVDA	Stock	9.0928	9.185	9.0922	9.175	31538400.0
2020-06-29 13:00:00	NVDA	Stock	9.1732	9.1898	9.13	9.173	21194040.0
2020-06-29 14:00:00	NVDA	Stock	9.172	9.1795	9.1188	9.1338	17694480.0
2020-06-29 15:00:00	NVDA	Stock	9.135	9.2045	9.1042	9.203	31692200.0
2020-06-29 16:00:00	NVDA	Stock	9.2	9.325	9.1975	9.3	21521560.0
2020-06-29 17:00:00	NVDA	Stock	9.2975	9.2995	9.2625	9.266	272000.0
2020-06-29 18:00:00	NVDA	Stock	9.2763	9.31	9.2678	9.3088	611800.0
2020-06-29 19:00:00	NVDA	Stock	9.305	9.315	9.2865	9.3	330520.0
2020-06-29 04:00:00	AMZN	Stock	135.005	135.025	135.005	135.025	4020.0
2020-06-29 05:00:00	AMZN	Stock	134.9995	135.0035	134.9995	135.0	12000.0

> showing 50 of 58,002 rows — these rows as CSV

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