PREVIEW / stock_1hour / 2021-03-19

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-03-19.parquet
  size:    1.4 MB
  rows:    66,646
  symbols: 2,920

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-19 04:00:00	AAPL	Stock	120.86	121.7	120.86	121.7	30836.0
2021-03-19 05:00:00	AAPL	Stock	121.63	121.66	121.47	121.55	11553.0
2021-03-19 06:00:00	AAPL	Stock	121.47	121.59	121.11	121.3	22642.0
2021-03-19 07:00:00	AAPL	Stock	121.27	121.41	121.0	121.32	168797.0
2021-03-19 08:00:00	AAPL	Stock	121.2401	121.43	121.01	121.14	465738.0
2021-03-19 09:00:00	AAPL	Stock	121.14	121.43	119.73	120.68	23636978.0
2021-03-19 10:00:00	AAPL	Stock	120.68	120.73	119.675	120.5	16893302.0
2021-03-19 11:00:00	AAPL	Stock	120.5052	120.6196	119.86	120.46	10266198.0
2021-03-19 12:00:00	AAPL	Stock	120.47	121.16	120.41	120.925	9527331.0
2021-03-19 13:00:00	AAPL	Stock	120.92	120.95	120.27	120.32	7607433.0
2021-03-19 14:00:00	AAPL	Stock	120.32	120.49	119.89	120.1153	9235491.0
2021-03-19 15:00:00	AAPL	Stock	120.11	120.97	119.85	119.87	20616072.0
2021-03-19 16:00:00	AAPL	Stock	119.86	120.22	119.8538	120.01	59313820.0
2021-03-19 17:00:00	AAPL	Stock	120.01	120.05	119.99	120.03	189926.0
2021-03-19 18:00:00	AAPL	Stock	120.03	120.03	119.95	119.99	384509.0
2021-03-19 19:00:00	AAPL	Stock	119.98	120.05	119.95	120.02	104900.0
2021-03-19 04:00:00	MSFT	Stock	232.75	232.75	232.48	232.48	353.0
2021-03-19 05:00:00	MSFT	Stock	232.33	232.72	232.16	232.33	1845.0
2021-03-19 06:00:00	MSFT	Stock	232.43	232.43	231.86	232.0	5461.0
2021-03-19 07:00:00	MSFT	Stock	231.82	232.0	231.07	231.76	36075.0
2021-03-19 08:00:00	MSFT	Stock	231.5	232.3	231.25	231.85	49133.0
2021-03-19 09:00:00	MSFT	Stock	231.56	232.474	230.28	230.6717	6925400.0
2021-03-19 10:00:00	MSFT	Stock	230.65	231.59	229.3496	231.155	3111244.0
2021-03-19 11:00:00	MSFT	Stock	231.16	231.59	230.17	231.44	1741216.0
2021-03-19 12:00:00	MSFT	Stock	231.43	231.9272	231.13	231.89	1556748.0
2021-03-19 13:00:00	MSFT	Stock	231.89	231.99	231.1	231.58	1583270.0
2021-03-19 14:00:00	MSFT	Stock	231.59	231.74	230.86	231.55	1930213.0
2021-03-19 15:00:00	MSFT	Stock	231.55	231.69	229.89	229.91	3869093.0
2021-03-19 16:00:00	MSFT	Stock	229.91	231.08	229.91	230.66	16260146.0
2021-03-19 17:00:00	MSFT	Stock	230.75	230.93	230.35	230.77	13698.0
2021-03-19 18:00:00	MSFT	Stock	230.8	230.8	230.5	230.64	4594.0
2021-03-19 19:00:00	MSFT	Stock	230.56	230.81	230.5	230.55	12426.0
2021-03-19 04:00:00	NVDA	Stock	12.8475	12.925	12.8475	12.925	35160.0
2021-03-19 05:00:00	NVDA	Stock	12.8975	12.9002	12.8975	12.9002	8520.0
2021-03-19 06:00:00	NVDA	Stock	12.859	12.8778	12.859	12.8778	14240.0
2021-03-19 07:00:00	NVDA	Stock	12.865	12.875	12.825	12.875	280280.0
2021-03-19 08:00:00	NVDA	Stock	12.8605	12.89	12.8438	12.8563	310080.0
2021-03-19 09:00:00	NVDA	Stock	12.85	12.8775	12.6125	12.77	40599920.0
2021-03-19 10:00:00	NVDA	Stock	12.7612	12.8643	12.6178	12.844	20352120.0
2021-03-19 11:00:00	NVDA	Stock	12.8409	12.875	12.7118	12.8115	10985760.0
2021-03-19 12:00:00	NVDA	Stock	12.8238	12.9205	12.8116	12.8968	11306080.0
2021-03-19 13:00:00	NVDA	Stock	12.9005	12.9215	12.8255	12.8813	8504200.0
2021-03-19 14:00:00	NVDA	Stock	12.8833	12.8988	12.8006	12.8398	10275320.0
2021-03-19 15:00:00	NVDA	Stock	12.8375	12.8875	12.7225	12.8458	28946280.0
2021-03-19 16:00:00	NVDA	Stock	12.8458	12.8593	12.8128	12.8225	58272680.0
2021-03-19 17:00:00	NVDA	Stock	12.8227	12.8458	12.8227	12.8252	68400.0
2021-03-19 18:00:00	NVDA	Stock	12.8333	12.842	12.8333	12.8375	237320.0
2021-03-19 19:00:00	NVDA	Stock	12.8458	12.8673	12.8252	12.8295	183000.0
2021-03-19 04:00:00	AMZN	Stock	152.05	152.05	152.05	152.05	2280.0
2021-03-19 05:00:00	AMZN	Stock	152.6505	152.6505	152.6505	152.6505	2000.0

> showing 50 of 66,646 rows — these rows as CSV

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