PREVIEW / stock_30min / 2022-04-12

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-12.parquet
  size:    2.2 MB
  rows:    106,643
  symbols: 2,480

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-12 04:00:00	AAPL	Stock	165.0	165.48	165.0	165.3	17581.0
2022-04-12 04:30:00	AAPL	Stock	165.24	165.85	165.2	165.6	22824.0
2022-04-12 05:00:00	AAPL	Stock	165.68	165.75	165.39	165.59	11161.0
2022-04-12 05:30:00	AAPL	Stock	165.61	165.95	165.61	165.95	5101.0
2022-04-12 06:00:00	AAPL	Stock	165.95	165.95	165.5	165.5	8078.0
2022-04-12 06:30:00	AAPL	Stock	165.6	165.89	165.59	165.74	5057.0
2022-04-12 07:00:00	AAPL	Stock	165.71	165.71	165.26	165.56	34000.0
2022-04-12 07:30:00	AAPL	Stock	165.53	165.87	165.4	165.87	40406.0
2022-04-12 08:00:00	AAPL	Stock	165.83	166.25	163.0	166.2	420105.0
2022-04-12 08:30:00	AAPL	Stock	166.22	168.9899	166.22	168.85	809356.0
2022-04-12 09:00:00	AAPL	Stock	168.84	168.88	167.8	168.01	484638.0
2022-04-12 09:30:00	AAPL	Stock	168.02	169.79	166.92	169.33	10585950.0
2022-04-12 10:00:00	AAPL	Stock	169.34	169.87	169.05	169.575	6582402.0
2022-04-12 10:30:00	AAPL	Stock	169.585	169.675	168.07	168.12	4832072.0
2022-04-12 11:00:00	AAPL	Stock	168.11	169.1	167.82	169.08	3641093.0
2022-04-12 11:30:00	AAPL	Stock	169.08	169.375	168.62	168.85	3340378.0
2022-04-12 12:00:00	AAPL	Stock	168.86	168.88	167.775	167.85	3329429.0
2022-04-12 12:30:00	AAPL	Stock	167.85	168.44	167.7028	168.23	2996401.0
2022-04-12 13:00:00	AAPL	Stock	168.22	168.57	167.61	168.11	2881602.0
2022-04-12 13:30:00	AAPL	Stock	168.1055	168.31	167.04	167.155	2776295.0
2022-04-12 14:00:00	AAPL	Stock	167.15	167.8	166.73	166.9308	3817306.0
2022-04-12 14:30:00	AAPL	Stock	166.94	167.75	166.64	167.47	4221230.0
2022-04-12 15:00:00	AAPL	Stock	167.47	167.56	166.6929	167.11	4147264.0
2022-04-12 15:30:00	AAPL	Stock	167.115	168.095	166.97	167.64	7898296.0
2022-04-12 16:00:00	AAPL	Stock	167.64	167.9	167.44	167.75	5444689.0
2022-04-12 16:30:00	AAPL	Stock	167.7899	167.79	167.63	167.69	66750.0
2022-04-12 17:00:00	AAPL	Stock	167.67	167.93	167.6	167.77	8114.0
2022-04-12 17:30:00	AAPL	Stock	167.85	167.89	167.66	167.78	28643.0
2022-04-12 18:00:00	AAPL	Stock	167.8	167.8	167.65	167.7	8427.0
2022-04-12 18:30:00	AAPL	Stock	167.7101	167.8	167.66	167.79	7883.0
2022-04-12 19:00:00	AAPL	Stock	167.84	168.21	167.82	168.2	25175.0
2022-04-12 19:30:00	AAPL	Stock	168.2	168.5	168.08	168.5	28569.0
2022-04-12 04:00:00	MSFT	Stock	285.0	285.51	284.5	285.3	18384.0
2022-04-12 04:30:00	MSFT	Stock	285.15	286.29	285.15	285.97	4001.0
2022-04-12 05:00:00	MSFT	Stock	285.69	285.77	285.2	285.5	2813.0
2022-04-12 05:30:00	MSFT	Stock	285.67	286.5	285.67	286.5	2724.0
2022-04-12 06:00:00	MSFT	Stock	286.41	286.41	285.58	285.94	1973.0
2022-04-12 06:30:00	MSFT	Stock	286.48	286.48	286.34	286.34	1135.0
2022-04-12 07:00:00	MSFT	Stock	285.81	285.85	285.06	285.85	20452.0
2022-04-12 07:30:00	MSFT	Stock	285.97	286.5	285.86	286.48	10901.0
2022-04-12 08:00:00	MSFT	Stock	285.92	287.1899	285.2	286.88	39246.0
2022-04-12 08:30:00	MSFT	Stock	286.9	290.75	286.66	290.16	180766.0
2022-04-12 09:00:00	MSFT	Stock	290.15	290.15	288.5	289.2	70914.0
2022-04-12 09:30:00	MSFT	Stock	289.27	290.64	286.66	290.22	3437514.0
2022-04-12 10:00:00	MSFT	Stock	290.2515	290.739	288.28	288.4	1526127.0
2022-04-12 10:30:00	MSFT	Stock	288.39	288.5	286.09	286.42	1468673.0
2022-04-12 11:00:00	MSFT	Stock	286.4	287.47	285.91	287.31	1291052.0
2022-04-12 11:30:00	MSFT	Stock	287.36	287.97	286.17	286.35	889109.0
2022-04-12 12:00:00	MSFT	Stock	286.37	286.53	284.69	285.0052	1254574.0
2022-04-12 12:30:00	MSFT	Stock	285.0	285.65	284.5007	285.15	965014.0

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

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