PREVIEW / stock_30min / 2021-05-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-05-20.parquet
  size:    2.1 MB
  rows:    107,728
  symbols: 2,972

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-20 04:00:00	AAPL	Stock	124.91	124.91	124.58	124.58	6980.0
2021-05-20 04:30:00	AAPL	Stock	124.43	124.43	124.25	124.26	3422.0
2021-05-20 05:00:00	AAPL	Stock	124.24	124.4	124.11	124.14	7737.0
2021-05-20 05:30:00	AAPL	Stock	124.14	124.31	124.09	124.28	4713.0
2021-05-20 06:00:00	AAPL	Stock	124.33	124.55	124.33	124.55	3992.0
2021-05-20 06:30:00	AAPL	Stock	124.32	124.87	124.32	124.87	10295.0
2021-05-20 07:00:00	AAPL	Stock	124.76	125.2	124.7	125.0	98765.0
2021-05-20 07:30:00	AAPL	Stock	125.03	125.22	125.01	125.03	30621.0
2021-05-20 08:00:00	AAPL	Stock	124.818	125.22	124.71	125.05	148648.0
2021-05-20 08:30:00	AAPL	Stock	125.05	125.55	125.02	125.55	189893.0
2021-05-20 09:00:00	AAPL	Stock	125.55	125.71	125.1	125.23	220375.0
2021-05-20 09:30:00	AAPL	Stock	125.23	126.22	125.1	125.84	9136533.0
2021-05-20 10:00:00	AAPL	Stock	125.835	126.45	125.76	126.37	4780087.0
2021-05-20 10:30:00	AAPL	Stock	126.365	126.47	126.12	126.36	3693787.0
2021-05-20 11:00:00	AAPL	Stock	126.36	126.79	126.28	126.77	3773228.0
2021-05-20 11:30:00	AAPL	Stock	126.78	127.265	126.72	127.045	5145581.0
2021-05-20 12:00:00	AAPL	Stock	127.05	127.07	126.7	126.81	3697539.0
2021-05-20 12:30:00	AAPL	Stock	126.82	127.05	126.67	126.97	3432938.0
2021-05-20 13:00:00	AAPL	Stock	126.97	127.32	126.895	127.255	2883169.0
2021-05-20 13:30:00	AAPL	Stock	127.2523	127.37	126.93	127.155	2664794.0
2021-05-20 14:00:00	AAPL	Stock	127.16	127.4066	127.09	127.3901	2589548.0
2021-05-20 14:30:00	AAPL	Stock	127.4	127.6	127.32	127.53	2945196.0
2021-05-20 15:00:00	AAPL	Stock	127.53	127.72	127.36	127.7	3357727.0
2021-05-20 15:30:00	AAPL	Stock	127.7	127.72	127.2	127.31	7248646.0
2021-05-20 16:00:00	AAPL	Stock	127.31	127.455	127.26	127.34	8465933.0
2021-05-20 16:30:00	AAPL	Stock	127.33	127.49	127.32	127.42	31767.0
2021-05-20 17:00:00	AAPL	Stock	127.36	127.4	127.35	127.37	18733.0
2021-05-20 17:30:00	AAPL	Stock	127.37	127.43	127.36	127.43	25821.0
2021-05-20 18:00:00	AAPL	Stock	127.41	127.43	127.36	127.38	26455.0
2021-05-20 18:30:00	AAPL	Stock	127.4	127.41	127.38	127.38	11514.0
2021-05-20 19:00:00	AAPL	Stock	127.39	127.4	127.36	127.39	9348.0
2021-05-20 19:30:00	AAPL	Stock	127.42	127.55	127.38	127.55	53753.0
2021-05-20 04:00:00	MSFT	Stock	243.39	243.39	243.02	243.02	983.0
2021-05-20 04:30:00	MSFT	Stock	242.9	242.9	242.5	242.5	1371.0
2021-05-20 05:00:00	MSFT	Stock	242.43	242.45	242.0	242.0	1255.0
2021-05-20 05:30:00	MSFT	Stock	241.5	241.57	241.5	241.57	442.0
2021-05-20 06:00:00	MSFT	Stock	241.81	241.81	241.81	241.81	200.0
2021-05-20 06:30:00	MSFT	Stock	241.7	242.45	241.7	242.25	2961.0
2021-05-20 07:00:00	MSFT	Stock	242.85	243.35	242.45	243.12	17134.0
2021-05-20 07:30:00	MSFT	Stock	242.97	243.27	242.91	242.91	4636.0
2021-05-20 08:00:00	MSFT	Stock	242.46	243.44	242.46	242.8	10389.0
2021-05-20 08:30:00	MSFT	Stock	243.1	243.85	243.1	243.75	14187.0
2021-05-20 09:00:00	MSFT	Stock	243.73	244.38	243.5	243.85	28612.0
2021-05-20 09:30:00	MSFT	Stock	243.85	246.45	243.85	245.53	2179320.0
2021-05-20 10:00:00	MSFT	Stock	245.535	246.53	245.52	246.37	1091904.0
2021-05-20 10:30:00	MSFT	Stock	246.39	246.96	246.3044	246.3901	960997.0
2021-05-20 11:00:00	MSFT	Stock	246.41	247.06	245.99	247.01	1118370.0
2021-05-20 11:30:00	MSFT	Stock	247.01	247.95	246.95	247.35	1006977.0
2021-05-20 12:00:00	MSFT	Stock	247.36	247.3852	246.4	246.71	1020500.0
2021-05-20 12:30:00	MSFT	Stock	246.72	247.05	246.46	246.9	746161.0

> showing 50 of 107,728 rows — these rows as CSV

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