PREVIEW / stock_30min / 2021-05-18

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-05-18.parquet
  size:    2.2 MB
  rows:    110,320
  symbols: 2,963

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
2021-05-18 04:00:00	AAPL	Stock	126.99	127.33	126.94	127.33	7418.0
2021-05-18 04:30:00	AAPL	Stock	127.34	127.51	127.33	127.38	9455.0
2021-05-18 05:00:00	AAPL	Stock	127.37	127.48	127.29	127.29	5370.0
2021-05-18 05:30:00	AAPL	Stock	127.28	127.38	127.25	127.32	11297.0
2021-05-18 06:00:00	AAPL	Stock	127.38	127.5	127.25	127.25	33224.0
2021-05-18 06:30:00	AAPL	Stock	127.3	127.4	127.1	127.15	5207.0
2021-05-18 07:00:00	AAPL	Stock	127.24	127.24	126.85	126.95	64095.0
2021-05-18 07:30:00	AAPL	Stock	126.99	127.0	126.82	126.95	36839.0
2021-05-18 08:00:00	AAPL	Stock	126.95	127.19	126.85	126.98	174781.0
2021-05-18 08:30:00	AAPL	Stock	127.0	127.09	126.61	126.84	83584.0
2021-05-18 09:00:00	AAPL	Stock	126.84	126.84	126.5	126.55	144897.0
2021-05-18 09:30:00	AAPL	Stock	126.56	126.99	125.91	126.54	8329931.0
2021-05-18 10:00:00	AAPL	Stock	126.535	126.81	126.2846	126.7178	4243494.0
2021-05-18 10:30:00	AAPL	Stock	126.715	126.8154	126.4675	126.675	3382016.0
2021-05-18 11:00:00	AAPL	Stock	126.68	126.8699	126.54	126.6	2796076.0
2021-05-18 11:30:00	AAPL	Stock	126.6	126.62	126.21	126.275	3331817.0
2021-05-18 12:00:00	AAPL	Stock	126.2799	126.49	126.25	126.405	2519844.0
2021-05-18 12:30:00	AAPL	Stock	126.41	126.49	126.1841	126.27	2246787.0
2021-05-18 13:00:00	AAPL	Stock	126.27	126.33	126.095	126.315	2000277.0
2021-05-18 13:30:00	AAPL	Stock	126.31	126.37	126.02	126.04	2053891.0
2021-05-18 14:00:00	AAPL	Stock	126.03	126.1499	125.861	125.9	2360300.0
2021-05-18 14:30:00	AAPL	Stock	125.8948	125.97	125.38	125.6382	3201007.0
2021-05-18 15:00:00	AAPL	Stock	125.635	125.74	125.51	125.5421	2448252.0
2021-05-18 15:30:00	AAPL	Stock	125.545	125.79	124.78	124.85	8165933.0
2021-05-18 16:00:00	AAPL	Stock	124.85	125.05	124.65	124.85	6282367.0
2021-05-18 16:30:00	AAPL	Stock	124.86	124.86	124.55	124.67	76663.0
2021-05-18 17:00:00	AAPL	Stock	124.66	124.68	124.6	124.65	42723.0
2021-05-18 17:30:00	AAPL	Stock	124.63	124.69	124.62	124.64	16653.0
2021-05-18 18:00:00	AAPL	Stock	124.63	124.81	124.62	124.78	27858.0
2021-05-18 18:30:00	AAPL	Stock	124.78	124.78	124.6	124.67	38834.0
2021-05-18 19:00:00	AAPL	Stock	124.62	124.85	124.6	124.76	59834.0
2021-05-18 19:30:00	AAPL	Stock	124.78	124.79	124.4	124.4	84254.0
2021-05-18 04:00:00	MSFT	Stock	247.1	247.1	246.6	246.6	1853.0
2021-05-18 04:30:00	MSFT	Stock	246.9	247.0	246.83	246.9	1523.0
2021-05-18 05:00:00	MSFT	Stock	246.66	247.21	246.66	247.2	585.0
2021-05-18 05:30:00	MSFT	Stock	247.01	247.15	247.0	247.1	5721.0
2021-05-18 06:00:00	MSFT	Stock	247.17	247.17	246.99	247.0	559.0
2021-05-18 06:30:00	MSFT	Stock	247.0	247.12	246.7	246.74	1483.0
2021-05-18 07:00:00	MSFT	Stock	246.76	246.76	246.1	246.27	11424.0
2021-05-18 07:30:00	MSFT	Stock	246.3	246.4	246.15	246.25	5182.0
2021-05-18 08:00:00	MSFT	Stock	246.7	246.99	246.06	246.3	29313.0
2021-05-18 08:30:00	MSFT	Stock	246.33	246.53	245.89	246.01	18742.0
2021-05-18 09:00:00	MSFT	Stock	245.96	246.3	245.55	246.1	26277.0
2021-05-18 09:30:00	MSFT	Stock	246.26	246.41	244.94	245.3181	1722505.0
2021-05-18 10:00:00	MSFT	Stock	245.3	245.89	244.87	245.8754	981289.0
2021-05-18 10:30:00	MSFT	Stock	245.88	245.94	245.455	245.65	752750.0
2021-05-18 11:00:00	MSFT	Stock	245.69	246.12	245.5	245.531	814195.0
2021-05-18 11:30:00	MSFT	Stock	245.54	245.58	245.0	245.0859	701321.0
2021-05-18 12:00:00	MSFT	Stock	245.08	245.61	245.03	245.5669	496208.0
2021-05-18 12:30:00	MSFT	Stock	245.57	245.9299	245.57	245.8	543193.0

> showing 50 of 110,320 rows — these rows as CSV

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