PREVIEW / stock_1hour / 2021-04-21

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-04-21.parquet
  size:    1.4 MB
  rows:    64,903
  symbols: 2,971

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-04-21 04:00:00	AAPL	Stock	132.59	132.64	132.31	132.58	9725.0
2021-04-21 05:00:00	AAPL	Stock	132.58	133.05	132.58	132.71	15996.0
2021-04-21 06:00:00	AAPL	Stock	132.78	133.07	132.64	133.07	11128.0
2021-04-21 07:00:00	AAPL	Stock	132.98	132.99	132.66	132.7	96087.0
2021-04-21 08:00:00	AAPL	Stock	132.97	133.442	132.38	132.69	283567.0
2021-04-21 09:00:00	AAPL	Stock	132.7	133.05	131.3001	132.63	10808208.0
2021-04-21 10:00:00	AAPL	Stock	132.62	132.66	131.9101	132.17	10230633.0
2021-04-21 11:00:00	AAPL	Stock	132.17	133.5	132.09	133.435	9514074.0
2021-04-21 12:00:00	AAPL	Stock	133.4314	133.435	132.75	132.8391	6147219.0
2021-04-21 13:00:00	AAPL	Stock	132.842	133.26	132.82	133.056	4604817.0
2021-04-21 14:00:00	AAPL	Stock	133.0676	133.43	133.05	133.21	4824862.0
2021-04-21 15:00:00	AAPL	Stock	133.205	133.75	133.09	133.49	8602827.0
2021-04-21 16:00:00	AAPL	Stock	133.5	133.54	133.0	133.26	6269363.0
2021-04-21 17:00:00	AAPL	Stock	133.27	133.27	133.12	133.21	69275.0
2021-04-21 18:00:00	AAPL	Stock	133.21	133.3	133.15	133.24	34286.0
2021-04-21 19:00:00	AAPL	Stock	133.23	133.28	132.9	132.9	83705.0
2021-04-21 04:00:00	MSFT	Stock	258.4	258.4	258.1	258.1	1634.0
2021-04-21 05:00:00	MSFT	Stock	258.14	258.14	258.14	258.14	210.0
2021-04-21 06:00:00	MSFT	Stock	258.23	258.65	258.14	258.65	3478.0
2021-04-21 07:00:00	MSFT	Stock	258.67	258.76	258.35	258.5	12066.0
2021-04-21 08:00:00	MSFT	Stock	258.58	258.58	257.55	258.01	18681.0
2021-04-21 09:00:00	MSFT	Stock	258.11	259.7	257.25	259.52	2522761.0
2021-04-21 10:00:00	MSFT	Stock	259.52	260.13	258.26	258.48	2752887.0
2021-04-21 11:00:00	MSFT	Stock	258.49	260.34	258.38	259.902	1990173.0
2021-04-21 12:00:00	MSFT	Stock	259.91	259.93	259.1	259.24	1315285.0
2021-04-21 13:00:00	MSFT	Stock	259.24	259.6	258.9	259.03	1068178.0
2021-04-21 14:00:00	MSFT	Stock	259.03	259.29	258.65	259.1151	1175195.0
2021-04-21 15:00:00	MSFT	Stock	259.11	260.68	258.71	260.62	2918137.0
2021-04-21 16:00:00	MSFT	Stock	260.58	260.6	259.29	260.4	3803150.0
2021-04-21 17:00:00	MSFT	Stock	260.4	260.4	260.25	260.4	1428.0
2021-04-21 18:00:00	MSFT	Stock	260.27	260.3	260.05	260.15	4634.0
2021-04-21 19:00:00	MSFT	Stock	260.25	260.55	260.01	260.55	14110.0
2021-04-21 05:00:00	NVDA	Stock	15.15	15.15	15.137	15.137	24000.0
2021-04-21 06:00:00	NVDA	Stock	15.1615	15.1615	15.1615	15.1615	6160.0
2021-04-21 07:00:00	NVDA	Stock	15.1875	15.1875	15.1688	15.1688	65480.0
2021-04-21 08:00:00	NVDA	Stock	15.1885	15.2092	15.1312	15.175	309080.0
2021-04-21 09:00:00	NVDA	Stock	15.175	15.3358	15.1023	15.3028	25327400.0
2021-04-21 10:00:00	NVDA	Stock	15.3025	15.333	15.157	15.1765	17082520.0
2021-04-21 11:00:00	NVDA	Stock	15.1778	15.289	15.1692	15.2656	13294840.0
2021-04-21 12:00:00	NVDA	Stock	15.263	15.2797	15.1778	15.1839	9082280.0
2021-04-21 13:00:00	NVDA	Stock	15.1798	15.2505	15.1798	15.231	9597600.0
2021-04-21 14:00:00	NVDA	Stock	15.233	15.2648	15.214	15.2306	7086800.0
2021-04-21 15:00:00	NVDA	Stock	15.2295	15.3625	15.1883	15.3605	26961320.0
2021-04-21 16:00:00	NVDA	Stock	15.3605	15.3605	15.305	15.3363	21200040.0
2021-04-21 17:00:00	NVDA	Stock	15.335	15.335	15.3128	15.3128	54880.0
2021-04-21 18:00:00	NVDA	Stock	15.32	15.3355	15.3062	15.3062	13720.0
2021-04-21 19:00:00	NVDA	Stock	15.3248	15.334	15.3218	15.334	143600.0
2021-04-21 07:00:00	AMZN	Stock	166.2	166.2	165.85	165.85	15400.0
2021-04-21 08:00:00	AMZN	Stock	166.05	166.3177	165.72	165.994	27600.0
2021-04-21 09:00:00	AMZN	Stock	166.0525	167.1925	165.1903	167.1413	3867500.0

> showing 50 of 64,903 rows — these rows as CSV

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