PREVIEW / stock_30min / 2022-04-21

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-21.parquet
  size:    2.2 MB
  rows:    106,931
  symbols: 2,458

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-04-21 04:00:00	AAPL	Stock	168.3	168.82	168.28	168.74	9235.0
2022-04-21 04:30:00	AAPL	Stock	168.73	168.88	168.7	168.88	6574.0
2022-04-21 05:00:00	AAPL	Stock	168.83	168.89	168.65	168.75	5890.0
2022-04-21 05:30:00	AAPL	Stock	168.5	168.69	168.5	168.67	2711.0
2022-04-21 06:00:00	AAPL	Stock	168.63	168.69	168.52	168.65	2600.0
2022-04-21 06:30:00	AAPL	Stock	168.8	169.02	168.79	168.82	27661.0
2022-04-21 07:00:00	AAPL	Stock	168.8	169.25	168.57	169.2	72045.0
2022-04-21 07:30:00	AAPL	Stock	169.2	169.23	168.85	169.13	36697.0
2022-04-21 08:00:00	AAPL	Stock	168.78	169.2104	168.14	169.06	380977.0
2022-04-21 08:30:00	AAPL	Stock	169.04	169.07	168.52	169.0	100682.0
2022-04-21 09:00:00	AAPL	Stock	169.01	169.1	168.7	168.93	204789.0
2022-04-21 09:30:00	AAPL	Stock	168.87	170.875	168.445	170.05	10814726.0
2022-04-21 10:00:00	AAPL	Stock	170.06	170.78	169.8	170.695	5563094.0
2022-04-21 10:30:00	AAPL	Stock	170.7	171.0	170.14	170.5425	5332840.0
2022-04-21 11:00:00	AAPL	Stock	170.53	171.53	170.39	171.19	5456310.0
2022-04-21 11:30:00	AAPL	Stock	171.185	171.3591	169.9001	169.93	5813407.0
2022-04-21 12:00:00	AAPL	Stock	169.94	170.44	169.7	169.735	4037988.0
2022-04-21 12:30:00	AAPL	Stock	169.72	170.1	169.25	169.33	3123375.0
2022-04-21 13:00:00	AAPL	Stock	169.33	169.44	168.05	168.97	4361707.0
2022-04-21 13:30:00	AAPL	Stock	168.97	169.18	167.87	168.005	3210835.0
2022-04-21 14:00:00	AAPL	Stock	167.9771	167.9771	167.12	167.405	3489782.0
2022-04-21 14:30:00	AAPL	Stock	167.39	168.0361	166.05	166.3272	4768109.0
2022-04-21 15:00:00	AAPL	Stock	166.325	166.84	165.91	166.72	4235849.0
2022-04-21 15:30:00	AAPL	Stock	166.7	167.135	166.0	166.34	7767829.0
2022-04-21 16:00:00	AAPL	Stock	166.35	166.52	165.95	166.15	6463479.0
2022-04-21 16:30:00	AAPL	Stock	166.15	166.77	166.0	166.1	114316.0
2022-04-21 17:00:00	AAPL	Stock	166.24	166.38	166.08	166.15	16862.0
2022-04-21 17:30:00	AAPL	Stock	166.2	166.2	166.09	166.09	9349.0
2022-04-21 18:00:00	AAPL	Stock	166.14	166.26	166.01	166.26	15005.0
2022-04-21 18:30:00	AAPL	Stock	166.29	166.38	166.28	166.31	30269.0
2022-04-21 19:00:00	AAPL	Stock	166.3001	166.39	166.23	166.39	12672.0
2022-04-21 19:30:00	AAPL	Stock	166.38	166.42	165.92	165.92	29556.0
2022-04-21 04:00:00	MSFT	Stock	288.6	289.02	288.6	288.75	831.0
2022-04-21 04:30:00	MSFT	Stock	288.72	289.0	288.72	288.97	1195.0
2022-04-21 05:00:00	MSFT	Stock	288.81	288.81	288.81	288.81	100.0
2022-04-21 05:30:00	MSFT	Stock	288.56	288.79	288.54	288.79	1857.0
2022-04-21 06:00:00	MSFT	Stock	288.81	288.82	288.65	288.82	1045.0
2022-04-21 06:30:00	MSFT	Stock	289.0	289.0	288.9	288.98	3244.0
2022-04-21 07:00:00	MSFT	Stock	288.9	289.44	288.61	289.44	8667.0
2022-04-21 07:30:00	MSFT	Stock	289.44	289.55	289.2	289.41	8718.0
2022-04-21 08:00:00	MSFT	Stock	288.8984	289.76	288.75	289.0079	15200.0
2022-04-21 08:30:00	MSFT	Stock	289.25	289.45	288.72	289.3	15977.0
2022-04-21 09:00:00	MSFT	Stock	289.4	289.5	288.32	288.44	22171.0
2022-04-21 09:30:00	MSFT	Stock	288.44	293.3	288.44	291.86	2697651.0
2022-04-21 10:00:00	MSFT	Stock	291.82	292.05	289.71	291.49	1309301.0
2022-04-21 10:30:00	MSFT	Stock	291.519	291.76	288.52	288.985	1287047.0
2022-04-21 11:00:00	MSFT	Stock	288.94	290.0839	288.625	289.08	981355.0
2022-04-21 11:30:00	MSFT	Stock	289.05	289.3197	286.2	286.2	1131961.0
2022-04-21 12:00:00	MSFT	Stock	286.22	286.835	285.87	286.6501	952616.0
2022-04-21 12:30:00	MSFT	Stock	286.68	287.92	286.11	286.47	949274.0

> showing 50 of 106,931 rows — these rows as CSV

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