PREVIEW / stock_1hour / 2023-04-11

all stock 1-hour files

  file:    by_date/stock_1hour/2023/2023-04-11.parquet
  size:    1.3 MB
  rows:    59,966
  symbols: 1,754

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
2023-04-11 04:00:00	AAPL	Stock	162.02	162.65	162.02	162.33	15943.0
2023-04-11 05:00:00	AAPL	Stock	162.4	162.52	162.2	162.52	4283.0
2023-04-11 06:00:00	AAPL	Stock	162.71	162.74	162.18	162.22	15097.0
2023-04-11 07:00:00	AAPL	Stock	162.21	162.35	161.8	161.9	40703.0
2023-04-11 08:00:00	AAPL	Stock	162.1	162.36	161.57	161.8	125014.0
2023-04-11 09:00:00	AAPL	Stock	161.8	162.36	161.08	161.23	5508294.0
2023-04-11 10:00:00	AAPL	Stock	161.225	161.38	160.56	160.73	6813704.0
2023-04-11 11:00:00	AAPL	Stock	160.735	161.12	160.51	160.975	3954108.0
2023-04-11 12:00:00	AAPL	Stock	160.979	161.52	160.84	161.3768	3896042.0
2023-04-11 13:00:00	AAPL	Stock	161.38	161.81	161.07	161.78	3156168.0
2023-04-11 14:00:00	AAPL	Stock	161.785	161.83	161.49	161.585	3115409.0
2023-04-11 15:00:00	AAPL	Stock	161.595	161.6199	160.55	160.8	7175941.0
2023-04-11 16:00:00	AAPL	Stock	160.8	160.88	160.71	160.8	5516013.0
2023-04-11 17:00:00	AAPL	Stock	160.81	160.827	160.65	160.7	81618.0
2023-04-11 18:00:00	AAPL	Stock	160.75	160.88	160.72	160.8558	11694.0
2023-04-11 19:00:00	AAPL	Stock	160.86	161.0	160.78	161.0	19536.0
2023-04-11 04:00:00	MSFT	Stock	288.92	289.23	288.46	289.0	8812.0
2023-04-11 05:00:00	MSFT	Stock	289.2	289.2	287.8	288.0	22200.0
2023-04-11 06:00:00	MSFT	Stock	288.0	288.25	285.9	286.5	20708.0
2023-04-11 07:00:00	MSFT	Stock	286.7	286.8	283.85	284.67	73636.0
2023-04-11 08:00:00	MSFT	Stock	284.55	289.63	283.98	284.2	126193.0
2023-04-11 09:00:00	MSFT	Stock	284.19	285.98	282.94	283.985	4001318.0
2023-04-11 10:00:00	MSFT	Stock	283.96	284.1	282.43	282.761	3090825.0
2023-04-11 11:00:00	MSFT	Stock	282.76	283.11	281.64	282.79	2882237.0
2023-04-11 12:00:00	MSFT	Stock	282.78	283.84	282.78	283.635	2035698.0
2023-04-11 13:00:00	MSFT	Stock	283.65	283.8	282.67	283.5903	1470780.0
2023-04-11 14:00:00	MSFT	Stock	283.6	284.17	283.11	284.1	1540872.0
2023-04-11 15:00:00	MSFT	Stock	284.11	284.1396	282.38	282.87	2998467.0
2023-04-11 16:00:00	MSFT	Stock	282.83	283.4	282.7	283.2	2690851.0
2023-04-11 17:00:00	MSFT	Stock	283.03	283.19	282.83	282.847	23390.0
2023-04-11 18:00:00	MSFT	Stock	282.8	283.16	282.8	283.0	4356.0
2023-04-11 19:00:00	MSFT	Stock	283.0	283.25	282.83	282.94	9353.0
2023-04-11 04:00:00	NVDA	Stock	27.6	27.709	27.6	27.709	100140.0
2023-04-11 05:00:00	NVDA	Stock	27.71	27.779	27.71	27.765	128460.0
2023-04-11 06:00:00	NVDA	Stock	27.77	27.77	27.688	27.708	116160.0
2023-04-11 07:00:00	NVDA	Stock	27.718	27.734	27.52	27.611	673840.0
2023-04-11 08:00:00	NVDA	Stock	27.628	27.74	27.492	27.603	1128350.0
2023-04-11 09:00:00	NVDA	Stock	27.63	27.79	27.255	27.412	45820300.0
2023-04-11 10:00:00	NVDA	Stock	27.413	27.514	27.149	27.181	42891200.0
2023-04-11 11:00:00	NVDA	Stock	27.181	27.33	27.126	27.272	31586250.0
2023-04-11 12:00:00	NVDA	Stock	27.2758	27.425	27.205	27.312	25289200.0
2023-04-11 13:00:00	NVDA	Stock	27.315	27.431	27.217	27.399	20052230.0
2023-04-11 14:00:00	NVDA	Stock	27.4	27.42	27.3021	27.351	20827830.0
2023-04-11 15:00:00	NVDA	Stock	27.35	27.388	27.1341	27.169	36781360.0
2023-04-11 16:00:00	NVDA	Stock	27.169	27.17	27.131	27.14	14344190.0
2023-04-11 17:00:00	NVDA	Stock	27.14	27.146	27.126	27.14	199480.0
2023-04-11 18:00:00	NVDA	Stock	27.145	27.146	27.131	27.135	78500.0
2023-04-11 19:00:00	NVDA	Stock	27.141	27.146	27.125	27.145	334390.0
2023-04-11 04:00:00	AMZN	Stock	102.0	102.28	101.81	102.28	8614.0
2023-04-11 05:00:00	AMZN	Stock	102.28	102.49	102.04	102.49	10387.0

> showing 50 of 59,966 rows — these rows as CSV

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