PREVIEW / stock_30min / 2022-01-18

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-18.parquet
  size:    2.3 MB
  rows:    113,322
  symbols: 2,622

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-18 04:00:00	AAPL	Stock	170.85	170.89	169.62	170.0	37563.0
2022-01-18 04:30:00	AAPL	Stock	170.01	170.45	169.7	170.21	14030.0
2022-01-18 05:00:00	AAPL	Stock	170.39	170.73	170.21	170.35	5800.0
2022-01-18 05:30:00	AAPL	Stock	170.5	170.59	170.01	170.16	9980.0
2022-01-18 06:00:00	AAPL	Stock	170.15	170.23	169.65	170.1	9213.0
2022-01-18 06:30:00	AAPL	Stock	170.16	170.3	170.03	170.1	11153.0
2022-01-18 07:00:00	AAPL	Stock	170.23	170.65	170.0	170.09	157669.0
2022-01-18 07:30:00	AAPL	Stock	170.15	170.89	170.0	170.6	88950.0
2022-01-18 08:00:00	AAPL	Stock	170.4171	173.07	170.0	170.53	342212.0
2022-01-18 08:30:00	AAPL	Stock	170.5701	173.07	170.4	170.67	328837.0
2022-01-18 09:00:00	AAPL	Stock	170.65	171.5	170.52	171.5	279359.0
2022-01-18 09:30:00	AAPL	Stock	171.5	172.54	170.59	171.11	10636174.0
2022-01-18 10:00:00	AAPL	Stock	171.11	172.32	170.79	172.31	5703242.0
2022-01-18 10:30:00	AAPL	Stock	172.32	172.32	170.99	171.0801	4032774.0
2022-01-18 11:00:00	AAPL	Stock	171.1	171.1477	170.5	170.5699	4014840.0
2022-01-18 11:30:00	AAPL	Stock	170.56	171.22	170.2	171.1244	4017198.0
2022-01-18 12:00:00	AAPL	Stock	171.14	171.28	169.78	170.0	4129386.0
2022-01-18 12:30:00	AAPL	Stock	169.995	170.11	169.6	169.76	3135455.0
2022-01-18 13:00:00	AAPL	Stock	169.75	170.15	169.57	169.755	3372564.0
2022-01-18 13:30:00	AAPL	Stock	169.75	170.44	169.685	170.345	3229048.0
2022-01-18 14:00:00	AAPL	Stock	170.33	170.531	170.01	170.16	3035907.0
2022-01-18 14:30:00	AAPL	Stock	170.15	170.79	170.14	170.57	3205023.0
2022-01-18 15:00:00	AAPL	Stock	170.5701	170.77	169.84	170.34	3880419.0
2022-01-18 15:30:00	AAPL	Stock	170.34	170.52	169.405	169.83	9215031.0
2022-01-18 16:00:00	AAPL	Stock	169.91	170.25	169.7	170.2	14630869.0
2022-01-18 16:30:00	AAPL	Stock	170.17	170.24	169.8	170.21	57162.0
2022-01-18 17:00:00	AAPL	Stock	170.21	170.21	169.85	169.99	22310.0
2022-01-18 17:30:00	AAPL	Stock	169.99	170.0	169.85	169.92	19516.0
2022-01-18 18:00:00	AAPL	Stock	169.91	170.25	169.82	169.89	39415.0
2022-01-18 18:30:00	AAPL	Stock	169.9	169.9	169.5	169.5	30064.0
2022-01-18 19:00:00	AAPL	Stock	169.54	169.63	169.4	169.6	22214.0
2022-01-18 19:30:00	AAPL	Stock	169.6	169.65	169.3101	169.3101	52311.0
2022-01-18 04:00:00	MSFT	Stock	305.99	305.99	303.32	304.29	23201.0
2022-01-18 04:30:00	MSFT	Stock	304.23	304.82	303.64	304.4	4077.0
2022-01-18 05:00:00	MSFT	Stock	304.7	305.0	304.7	304.95	7424.0
2022-01-18 05:30:00	MSFT	Stock	304.95	304.95	303.97	304.25	1232.0
2022-01-18 06:00:00	MSFT	Stock	304.13	304.3	303.55	303.76	4024.0
2022-01-18 06:30:00	MSFT	Stock	304.0	304.55	303.55	304.27	7692.0
2022-01-18 07:00:00	MSFT	Stock	304.42	304.97	304.1	304.68	34158.0
2022-01-18 07:30:00	MSFT	Stock	304.76	305.28	304.25	305.15	12515.0
2022-01-18 08:00:00	MSFT	Stock	304.78	305.35	300.45	305.0	337097.0
2022-01-18 08:30:00	MSFT	Stock	305.0	307.48	303.5	306.01	325479.0
2022-01-18 09:00:00	MSFT	Stock	306.05	307.29	304.0	304.25	201894.0
2022-01-18 09:30:00	MSFT	Stock	304.25	308.1499	302.38	307.07	4673125.0
2022-01-18 10:00:00	MSFT	Stock	307.11	309.8	306.08	309.5601	2538280.0
2022-01-18 10:30:00	MSFT	Stock	309.55	309.55	306.27	306.71	1699644.0
2022-01-18 11:00:00	MSFT	Stock	306.72	306.79	305.06	305.67	1486334.0
2022-01-18 11:30:00	MSFT	Stock	305.67	306.65	304.58	306.4089	1273589.0
2022-01-18 12:00:00	MSFT	Stock	306.42	306.66	305.19	305.3781	959036.0
2022-01-18 12:30:00	MSFT	Stock	305.36	305.5	304.46	304.69	861585.0

> showing 50 of 113,322 rows — these rows as CSV

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