PREVIEW / stock_30min / 2020-07-01

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-07-01.parquet
  size:    1.9 MB
  rows:    96,814
  symbols: 2,440

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
2020-07-01 04:00:00	AAPL	Stock	91.035	91.115	91.0025	91.115	4348.0
2020-07-01 04:30:00	AAPL	Stock	91.03	91.03	91.03	91.03	400.0
2020-07-01 05:00:00	AAPL	Stock	91.0525	91.0525	91.0	91.0	6300.0
2020-07-01 06:00:00	AAPL	Stock	91.0325	91.0325	90.95	90.95	3928.0
2020-07-01 06:30:00	AAPL	Stock	90.9725	90.9975	90.7075	90.7075	26256.0
2020-07-01 07:00:00	AAPL	Stock	90.765	90.9375	90.6425	90.8	97704.0
2020-07-01 07:30:00	AAPL	Stock	90.75	90.75	90.57	90.7	64100.0
2020-07-01 08:00:00	AAPL	Stock	90.57	90.985	90.5325	90.97	194040.0
2020-07-01 08:30:00	AAPL	Stock	90.94	91.3	90.94	91.3	170780.0
2020-07-01 09:00:00	AAPL	Stock	91.3025	91.55	91.25	91.2825	423400.0
2020-07-01 09:30:00	AAPL	Stock	91.255	91.8375	91.15	91.4925	13808016.0
2020-07-01 10:00:00	AAPL	Stock	91.4975	91.69	91.38	91.5825	5774564.0
2020-07-01 10:30:00	AAPL	Stock	91.585	91.7425	91.41	91.695	7010704.0
2020-07-01 11:00:00	AAPL	Stock	91.7	91.8025	91.5325	91.5775	6227108.0
2020-07-01 11:30:00	AAPL	Stock	91.5825	91.7225	91.535	91.5575	3715672.0
2020-07-01 12:00:00	AAPL	Stock	91.5625	91.6225	91.49	91.555	3350540.0
2020-07-01 12:30:00	AAPL	Stock	91.555	91.84	91.47	91.66	5623892.0
2020-07-01 13:00:00	AAPL	Stock	91.6725	91.685	91.385	91.48	3285996.0
2020-07-01 13:30:00	AAPL	Stock	91.485	91.6375	91.4675	91.615	2930516.0
2020-07-01 14:00:00	AAPL	Stock	91.6075	91.72	91.3375	91.4125	5378588.0
2020-07-01 14:30:00	AAPL	Stock	91.4075	91.54	90.9775	91.275	8035160.0
2020-07-01 15:00:00	AAPL	Stock	91.275	91.345	91.125	91.135	6737868.0
2020-07-01 15:30:00	AAPL	Stock	91.1362	91.425	91.0	91.0025	9258076.0
2020-07-01 16:00:00	AAPL	Stock	91.0275	91.055	90.94	90.94	5218208.0
2020-07-01 16:30:00	AAPL	Stock	90.9575	91.0275	90.9075	90.91	58400.0
2020-07-01 17:00:00	AAPL	Stock	90.91	90.93	90.875	90.9	40328.0
2020-07-01 17:30:00	AAPL	Stock	90.9175	90.95	90.905	90.9475	12176.0
2020-07-01 18:00:00	AAPL	Stock	90.9475	90.9475	90.9	90.9	20272.0
2020-07-01 18:30:00	AAPL	Stock	90.93	90.9975	90.925	90.9875	43316.0
2020-07-01 19:00:00	AAPL	Stock	90.9975	91.025	90.9775	91.0	22948.0
2020-07-01 19:30:00	AAPL	Stock	90.99	91.15	90.9775	91.0275	61316.0
2020-07-01 04:30:00	MSFT	Stock	203.32	203.32	203.26	203.26	200.0
2020-07-01 05:30:00	MSFT	Stock	203.3	203.3	203.0	203.0	1557.0
2020-07-01 06:00:00	MSFT	Stock	203.32	203.33	203.32	203.32	1050.0
2020-07-01 06:30:00	MSFT	Stock	203.38	203.38	202.4	202.4	3753.0
2020-07-01 07:00:00	MSFT	Stock	202.48	202.99	202.3	202.69	17007.0
2020-07-01 07:30:00	MSFT	Stock	202.51	202.51	202.03	202.16	7253.0
2020-07-01 08:00:00	MSFT	Stock	202.701	203.51	202.04	202.7	25013.0
2020-07-01 08:30:00	MSFT	Stock	202.8	203.35	202.71	203.22	33062.0
2020-07-01 09:00:00	MSFT	Stock	203.26	203.59	203.0	203.0	47252.0
2020-07-01 09:30:00	MSFT	Stock	203.0	203.77	201.77	202.73	3719250.0
2020-07-01 10:00:00	MSFT	Stock	202.73	204.115	202.59	204.0	1987945.0
2020-07-01 10:30:00	MSFT	Stock	204.02	204.515	203.691	204.49	1649350.0
2020-07-01 11:00:00	MSFT	Stock	204.53	205.0	204.34	204.42	1766023.0
2020-07-01 11:30:00	MSFT	Stock	204.46	205.32	204.28	204.9	1443580.0
2020-07-01 12:00:00	MSFT	Stock	204.906	205.09	204.68	204.956	1016123.0
2020-07-01 12:30:00	MSFT	Stock	204.97	205.34	204.49	204.76	1184075.0
2020-07-01 13:00:00	MSFT	Stock	204.76	205.005	204.01	204.94	1109100.0
2020-07-01 13:30:00	MSFT	Stock	204.95	205.41	204.69	205.33	1298495.0
2020-07-01 14:00:00	MSFT	Stock	205.32	205.935	205.12	205.7	1529964.0

> showing 50 of 96,814 rows — these rows as CSV

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