PREVIEW / stock_1hour / 2020-10-15

all stock 1-hour files

  file:    by_date/stock_1hour/2020/2020-10-15.parquet
  size:    1.3 MB
  rows:    57,625
  symbols: 2,487

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-10-15 04:00:00	AAPL	Stock	119.58	119.8	117.25	117.83	234473.0
2020-10-15 05:00:00	AAPL	Stock	117.75	118.19	117.34	118.0	180821.0
2020-10-15 06:00:00	AAPL	Stock	118.0	118.88	117.91	118.4	104462.0
2020-10-15 07:00:00	AAPL	Stock	118.5	119.11	118.3	118.89	653168.0
2020-10-15 08:00:00	AAPL	Stock	118.85	121.49	118.32	118.772	1297843.0
2020-10-15 09:00:00	AAPL	Stock	118.83	120.635	118.15	120.2	16643867.0
2020-10-15 10:00:00	AAPL	Stock	120.18	120.38	119.01	119.743	18316042.0
2020-10-15 11:00:00	AAPL	Stock	119.74	120.39	119.17	120.29	12481758.0
2020-10-15 12:00:00	AAPL	Stock	120.281	120.65	119.55	119.81	10862155.0
2020-10-15 13:00:00	AAPL	Stock	119.81	120.44	119.39	120.345	8666884.0
2020-10-15 14:00:00	AAPL	Stock	120.34	120.81	120.2	120.665	9462941.0
2020-10-15 15:00:00	AAPL	Stock	120.66	121.2	120.57	120.745	16782691.0
2020-10-15 16:00:00	AAPL	Stock	120.71	120.75	120.5	120.65	7006375.0
2020-10-15 17:00:00	AAPL	Stock	120.63	120.9	120.6	120.85	471342.0
2020-10-15 18:00:00	AAPL	Stock	120.85	121.1	120.81	120.93	169102.0
2020-10-15 19:00:00	AAPL	Stock	120.98	121.15	120.92	121.0	208707.0
2020-10-15 04:00:00	MSFT	Stock	218.53	218.53	215.78	216.98	23069.0
2020-10-15 05:00:00	MSFT	Stock	216.0	217.38	216.0	217.13	35683.0
2020-10-15 06:00:00	MSFT	Stock	217.35	218.37	216.7	217.51	25888.0
2020-10-15 07:00:00	MSFT	Stock	217.6	218.4	217.47	218.0	53790.0
2020-10-15 08:00:00	MSFT	Stock	217.9	218.47	217.16	217.474	130630.0
2020-10-15 09:00:00	MSFT	Stock	217.3	219.22	216.01	219.22	2705649.0
2020-10-15 10:00:00	MSFT	Stock	219.21	219.29	216.445	217.47	3218064.0
2020-10-15 11:00:00	MSFT	Stock	217.48	218.82	216.67	218.03	1943548.0
2020-10-15 12:00:00	MSFT	Stock	218.0	218.57	217.15	217.77	1442218.0
2020-10-15 13:00:00	MSFT	Stock	217.76	218.85	217.38	218.74	1292287.0
2020-10-15 14:00:00	MSFT	Stock	218.76	219.56	218.67	219.4	1692625.0
2020-10-15 15:00:00	MSFT	Stock	219.4	220.36	219.24	219.66	3606535.0
2020-10-15 16:00:00	MSFT	Stock	219.66	219.682	219.22	219.3	2708436.0
2020-10-15 17:00:00	MSFT	Stock	219.35	219.62	219.35	219.45	5199.0
2020-10-15 18:00:00	MSFT	Stock	219.62	219.68	219.5	219.5	12191.0
2020-10-15 19:00:00	MSFT	Stock	219.64	220.66	219.5	220.15	5528.0
2020-10-15 04:00:00	NVDA	Stock	13.9225	13.9225	13.65	13.7	336200.0
2020-10-15 05:00:00	NVDA	Stock	13.675	13.6762	13.6075	13.64	632960.0
2020-10-15 06:00:00	NVDA	Stock	13.65	13.775	13.65	13.7625	401800.0
2020-10-15 07:00:00	NVDA	Stock	13.7688	13.8225	13.7625	13.7762	1341920.0
2020-10-15 08:00:00	NVDA	Stock	13.7848	13.8238	13.7363	13.8	3057200.0
2020-10-15 09:00:00	NVDA	Stock	13.7812	14.0005	13.7678	13.9885	47884040.0
2020-10-15 10:00:00	NVDA	Stock	13.9923	13.9925	13.7958	13.8792	39800960.0
2020-10-15 11:00:00	NVDA	Stock	13.8756	13.9838	13.8185	13.9126	23920280.0
2020-10-15 12:00:00	NVDA	Stock	13.9131	13.948	13.8412	13.871	20840280.0
2020-10-15 13:00:00	NVDA	Stock	13.8732	13.895	13.8185	13.8895	20439200.0
2020-10-15 14:00:00	NVDA	Stock	13.8925	13.9388	13.8668	13.9285	18944440.0
2020-10-15 15:00:00	NVDA	Stock	13.9285	14.0058	13.913	13.97	35441640.0
2020-10-15 16:00:00	NVDA	Stock	13.97	13.993	13.9625	13.9625	3748960.0
2020-10-15 17:00:00	NVDA	Stock	13.965	13.97	13.9588	13.9592	146440.0
2020-10-15 18:00:00	NVDA	Stock	13.97	13.9875	13.97	13.9782	153400.0
2020-10-15 19:00:00	NVDA	Stock	13.979	14.0062	13.9752	13.9963	345280.0
2020-10-15 04:00:00	AMZN	Stock	165.5	165.5	163.8005	164.0	57760.0
2020-10-15 05:00:00	AMZN	Stock	163.65	164.0	163.65	164.0	22260.0

> showing 50 of 57,625 rows — these rows as CSV

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