PREVIEW / stock_1hour / 2021-12-02

all stock 1-hour files

  file:    by_date/stock_1hour/2021/2021-12-02.parquet
  size:    1.5 MB
  rows:    67,220
  symbols: 2,671

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-12-02 04:00:00	AAPL	Stock	163.2	163.45	161.61	161.71	247758.0
2021-12-02 05:00:00	AAPL	Stock	161.71	162.26	161.0	162.1	169952.0
2021-12-02 06:00:00	AAPL	Stock	162.06	162.48	161.22	161.51	191350.0
2021-12-02 07:00:00	AAPL	Stock	161.54	161.57	159.4	159.96	785223.0
2021-12-02 08:00:00	AAPL	Stock	159.7801	164.359	158.5	159.73	1695233.0
2021-12-02 09:00:00	AAPL	Stock	159.72	161.63	157.8	161.369	23324400.0
2021-12-02 10:00:00	AAPL	Stock	161.37	161.37	159.03	160.4901	18226416.0
2021-12-02 11:00:00	AAPL	Stock	160.49	162.48	160.21	162.375	15856068.0
2021-12-02 12:00:00	AAPL	Stock	162.37	163.7	162.0801	163.09	13894728.0
2021-12-02 13:00:00	AAPL	Stock	163.11	163.54	162.54	163.4198	9595858.0
2021-12-02 14:00:00	AAPL	Stock	163.42	163.98	162.93	163.42	10576504.0
2021-12-02 15:00:00	AAPL	Stock	163.42	164.2	163.13	163.79	13867255.0
2021-12-02 16:00:00	AAPL	Stock	163.76	164.18	163.44	163.85	9237123.0
2021-12-02 17:00:00	AAPL	Stock	163.8799	164.1	163.8	163.95	37612.0
2021-12-02 18:00:00	AAPL	Stock	163.86	163.92	162.67	162.77	99239.0
2021-12-02 19:00:00	AAPL	Stock	162.68	162.98	162.12	162.28	140464.0
2021-12-02 04:00:00	MSFT	Stock	331.95	333.29	331.8	332.14	8116.0
2021-12-02 05:00:00	MSFT	Stock	331.91	332.1	330.71	331.71	8366.0
2021-12-02 06:00:00	MSFT	Stock	331.69	332.12	330.99	331.4	6565.0
2021-12-02 07:00:00	MSFT	Stock	331.49	331.66	329.37	330.95	46816.0
2021-12-02 08:00:00	MSFT	Stock	331.7737	331.81	329.5	330.31	49991.0
2021-12-02 09:00:00	MSFT	Stock	330.48	333.49	328.52	332.21	2220706.0
2021-12-02 10:00:00	MSFT	Stock	332.2	332.64	327.8028	329.609	3004605.0
2021-12-02 11:00:00	MSFT	Stock	329.57	331.15	328.59	329.84	1979608.0
2021-12-02 12:00:00	MSFT	Stock	329.845	331.76	329.59	330.955	1723115.0
2021-12-02 13:00:00	MSFT	Stock	330.99	331.7	329.56	330.33	1378906.0
2021-12-02 14:00:00	MSFT	Stock	330.3	330.78	328.99	329.8	1709999.0
2021-12-02 15:00:00	MSFT	Stock	329.83	331.42	328.57	329.49	3937292.0
2021-12-02 16:00:00	MSFT	Stock	329.49	330.41	328.94	330.0	4559861.0
2021-12-02 17:00:00	MSFT	Stock	330.0	330.0	329.61	329.75	6611.0
2021-12-02 18:00:00	MSFT	Stock	329.75	329.8	328.42	328.6	8732.0
2021-12-02 19:00:00	MSFT	Stock	328.0	328.75	327.93	328.1	9449.0
2021-12-02 04:00:00	NVDA	Stock	31.775	31.99	31.669	31.8	315860.0
2021-12-02 05:00:00	NVDA	Stock	31.8	31.8	31.552	31.635	147360.0
2021-12-02 06:00:00	NVDA	Stock	31.635	31.7	31.556	31.615	97980.0
2021-12-02 07:00:00	NVDA	Stock	31.626	31.728	31.094	31.33	1314010.0
2021-12-02 08:00:00	NVDA	Stock	31.5033	31.7244	31.01	31.195	2315970.0
2021-12-02 09:00:00	NVDA	Stock	31.182	32.233	31.025	32.081	53073340.0
2021-12-02 10:00:00	NVDA	Stock	32.09	32.283	31.403	31.91	70450150.0
2021-12-02 11:00:00	NVDA	Stock	31.89	32.223	31.695	32.183	39945610.0
2021-12-02 12:00:00	NVDA	Stock	32.166	32.478	32.111	32.2415	38944110.0
2021-12-02 13:00:00	NVDA	Stock	32.25	32.305	31.905	32.27	32131070.0
2021-12-02 14:00:00	NVDA	Stock	32.266	32.336	32.067	32.2377	25848750.0
2021-12-02 15:00:00	NVDA	Stock	32.253	32.388	31.85	32.111	62306370.0
2021-12-02 16:00:00	NVDA	Stock	32.111	32.457	32.023	32.23	23860700.0
2021-12-02 17:00:00	NVDA	Stock	32.248	32.5	32.207	32.367	503260.0
2021-12-02 18:00:00	NVDA	Stock	32.36	32.378	32.031	32.05	452550.0
2021-12-02 19:00:00	NVDA	Stock	32.027	32.047	31.815	31.875	782140.0
2021-12-02 04:00:00	AMZN	Stock	173.1495	173.15	173.1495	173.15	14380.0
2021-12-02 05:00:00	AMZN	Stock	173.0	173.1845	173.0	173.1845	5220.0

> showing 50 of 67,220 rows — these rows as CSV

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