PREVIEW / stock_1hour / 2022-01-27

all stock 1-hour files

  file:    by_date/stock_1hour/2022/2022-01-27.parquet
  size:    1.4 MB
  rows:    65,334
  symbols: 2,697

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
2022-01-27 04:00:00	AAPL	Stock	160.33	160.92	159.28	160.92	49182.0
2022-01-27 05:00:00	AAPL	Stock	160.8	161.3	159.33	159.53	28617.0
2022-01-27 06:00:00	AAPL	Stock	159.65	161.1	159.52	161.0	39809.0
2022-01-27 07:00:00	AAPL	Stock	161.0	161.7	160.51	161.56	154308.0
2022-01-27 08:00:00	AAPL	Stock	160.9999	162.06	159.321	162.03	718862.0
2022-01-27 09:00:00	AAPL	Stock	162.02	163.84	161.7	163.07	11095672.0
2022-01-27 10:00:00	AAPL	Stock	163.08	163.81	161.68	162.97	12303193.0
2022-01-27 11:00:00	AAPL	Stock	162.96	163.39	162.18	162.67	9176547.0
2022-01-27 12:00:00	AAPL	Stock	162.689	162.705	160.08	160.905	11570044.0
2022-01-27 13:00:00	AAPL	Stock	160.9	161.14	158.59	159.7899	11487515.0
2022-01-27 14:00:00	AAPL	Stock	159.77	160.65	158.77	159.37	10649194.0
2022-01-27 15:00:00	AAPL	Stock	159.375	159.97	158.28	159.2	18245607.0
2022-01-27 16:00:00	AAPL	Stock	159.09	166.0	157.5	165.17	12618932.0
2022-01-27 17:00:00	AAPL	Stock	165.65	168.0	163.17	167.29	4095478.0
2022-01-27 18:00:00	AAPL	Stock	167.2001	168.38	166.41	166.7	1223528.0
2022-01-27 19:00:00	AAPL	Stock	166.7	167.3	165.75	167.25	574443.0
2022-01-27 04:00:00	MSFT	Stock	296.71	299.71	296.57	299.0	21221.0
2022-01-27 05:00:00	MSFT	Stock	299.0	299.01	296.03	296.09	8068.0
2022-01-27 06:00:00	MSFT	Stock	296.44	299.45	296.44	299.1	5241.0
2022-01-27 07:00:00	MSFT	Stock	299.0	300.25	297.03	299.74	30594.0
2022-01-27 08:00:00	MSFT	Stock	298.2298	301.29	296.71	301.25	126746.0
2022-01-27 09:00:00	MSFT	Stock	301.12	307.3	301.12	306.35	6276089.0
2022-01-27 10:00:00	MSFT	Stock	306.33	306.79	302.34	304.89	6414299.0
2022-01-27 11:00:00	MSFT	Stock	304.87	306.55	303.6	305.329	5308495.0
2022-01-27 12:00:00	MSFT	Stock	305.36	305.42	300.2	302.176	4470470.0
2022-01-27 13:00:00	MSFT	Stock	302.15	302.77	298.51	300.07	4151678.0
2022-01-27 14:00:00	MSFT	Stock	300.05	301.86	298.2423	299.005	3342123.0
2022-01-27 15:00:00	MSFT	Stock	298.98	302.15	297.93	299.79	5011794.0
2022-01-27 16:00:00	MSFT	Stock	299.79	302.0	299.15	301.4	3848106.0
2022-01-27 17:00:00	MSFT	Stock	301.7	303.59	301.25	303.0	112546.0
2022-01-27 18:00:00	MSFT	Stock	303.17	303.17	301.42	301.42	34282.0
2022-01-27 19:00:00	MSFT	Stock	301.42	302.4	300.4	302.0	51093.0
2022-01-27 04:00:00	NVDA	Stock	22.826	23.414	22.772	23.25	378500.0
2022-01-27 05:00:00	NVDA	Stock	23.27	23.4	22.9	22.927	342830.0
2022-01-27 06:00:00	NVDA	Stock	22.903	23.114	22.899	23.105	331510.0
2022-01-27 07:00:00	NVDA	Stock	23.177	23.187	23.0	23.15	570960.0
2022-01-27 08:00:00	NVDA	Stock	23.04	23.39	22.7151	23.37	1166720.0
2022-01-27 09:00:00	NVDA	Stock	23.38	23.995	23.026	23.1256	58742320.0
2022-01-27 10:00:00	NVDA	Stock	23.134	23.2	22.308	22.5845	72267420.0
2022-01-27 11:00:00	NVDA	Stock	22.58	22.73	22.264	22.408	55611400.0
2022-01-27 12:00:00	NVDA	Stock	22.407	22.466	21.952	22.223	51099560.0
2022-01-27 13:00:00	NVDA	Stock	22.219	22.312	21.675	22.048	52458440.0
2022-01-27 14:00:00	NVDA	Stock	22.043	22.287	21.825	22.0829	42266580.0
2022-01-27 15:00:00	NVDA	Stock	22.091	22.226	21.751	21.93	60299010.0
2022-01-27 16:00:00	NVDA	Stock	21.9335	22.198	21.7	22.15	21445330.0
2022-01-27 17:00:00	NVDA	Stock	22.158	22.33	22.008	22.218	918090.0
2022-01-27 18:00:00	NVDA	Stock	22.24	22.246	22.13	22.155	541550.0
2022-01-27 19:00:00	NVDA	Stock	22.149	22.2	22.065	22.19	489920.0
2022-01-27 04:00:00	AMZN	Stock	138.8725	138.8725	138.8725	138.8725	4000.0
2022-01-27 05:00:00	AMZN	Stock	139.1105	139.1105	139.1105	139.1105	2000.0

> showing 50 of 65,334 rows — these rows as CSV

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