PREVIEW / stock_30min / 2020-01-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-23.parquet
  size:    1.8 MB
  rows:    86,298
  symbols: 2,456

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-01-23 04:00:00	AAPL	Stock	79.25	79.2525	79.25	79.25	4324.0
2020-01-23 04:30:00	AAPL	Stock	79.365	79.38	79.2775	79.2775	5736.0
2020-01-23 05:00:00	AAPL	Stock	79.2875	79.4	79.2875	79.4	1632.0
2020-01-23 05:30:00	AAPL	Stock	79.44	79.5	79.44	79.455	5672.0
2020-01-23 06:00:00	AAPL	Stock	79.5	79.535	79.4875	79.495	21860.0
2020-01-23 06:30:00	AAPL	Stock	79.4625	79.4625	79.425	79.425	2232.0
2020-01-23 07:00:00	AAPL	Stock	79.5	79.5625	79.425	79.425	78932.0
2020-01-23 07:30:00	AAPL	Stock	79.4125	79.4275	79.335	79.3525	106772.0
2020-01-23 08:00:00	AAPL	Stock	79.5748	79.5825	79.275	79.375	255500.0
2020-01-23 08:30:00	AAPL	Stock	79.385	79.45	79.3125	79.315	191016.0
2020-01-23 09:00:00	AAPL	Stock	79.3175	79.5	79.275	79.46	194196.0
2020-01-23 09:30:00	AAPL	Stock	79.465	79.6225	78.9125	79.2825	13088620.0
2020-01-23 10:00:00	AAPL	Stock	79.2675	79.4175	79.0725	79.4065	6621264.0
2020-01-23 10:30:00	AAPL	Stock	79.409	79.53	79.1575	79.3325	6314628.0
2020-01-23 11:00:00	AAPL	Stock	79.3375	79.4375	79.2275	79.2525	4517912.0
2020-01-23 11:30:00	AAPL	Stock	79.2475	79.4775	79.245	79.3775	3926452.0
2020-01-23 12:00:00	AAPL	Stock	79.375	79.49	79.3192	79.4715	2287004.0
2020-01-23 12:30:00	AAPL	Stock	79.475	79.5488	79.4225	79.4287	2339728.0
2020-01-23 13:00:00	AAPL	Stock	79.425	79.605	79.35	79.515	3089876.0
2020-01-23 13:30:00	AAPL	Stock	79.5125	79.7225	79.5125	79.685	3837468.0
2020-01-23 14:00:00	AAPL	Stock	79.6825	79.765	79.66	79.7225	3575544.0
2020-01-23 14:30:00	AAPL	Stock	79.7245	79.8125	79.6348	79.81	3479044.0
2020-01-23 15:00:00	AAPL	Stock	79.8052	79.875	79.65	79.8	4584144.0
2020-01-23 15:30:00	AAPL	Stock	79.8	79.89	79.73	79.8225	8692316.0
2020-01-23 16:00:00	AAPL	Stock	79.8075	79.9	79.8075	79.8425	11869548.0
2020-01-23 16:30:00	AAPL	Stock	79.8425	79.845	79.8075	79.845	74684.0
2020-01-23 17:00:00	AAPL	Stock	79.845	79.8975	79.835	79.84	55128.0
2020-01-23 17:30:00	AAPL	Stock	79.8625	79.895	79.85	79.885	22744.0
2020-01-23 18:00:00	AAPL	Stock	79.875	79.9375	79.8625	79.875	72676.0
2020-01-23 18:30:00	AAPL	Stock	79.875	79.925	79.875	79.9125	71676.0
2020-01-23 19:00:00	AAPL	Stock	79.925	79.9375	79.9175	79.9375	30308.0
2020-01-23 19:30:00	AAPL	Stock	79.9275	79.9375	79.8875	79.895	42056.0
2020-01-23 04:00:00	MSFT	Stock	165.72	165.97	165.72	165.97	1261.0
2020-01-23 05:00:00	MSFT	Stock	165.9	165.9	165.9	165.9	100.0
2020-01-23 05:30:00	MSFT	Stock	165.97	165.97	165.97	165.97	100.0
2020-01-23 06:00:00	MSFT	Stock	166.05	166.15	166.05	166.15	500.0
2020-01-23 06:30:00	MSFT	Stock	166.1	166.1	166.1	166.1	100.0
2020-01-23 07:00:00	MSFT	Stock	166.11	166.14	165.88	165.88	4349.0
2020-01-23 07:30:00	MSFT	Stock	165.82	165.9	165.6	165.72	5627.0
2020-01-23 08:00:00	MSFT	Stock	166.0	166.07	165.49	165.61	22661.0
2020-01-23 08:30:00	MSFT	Stock	165.61	166.0	165.61	165.7	21309.0
2020-01-23 09:00:00	MSFT	Stock	165.7	166.24	165.676	166.21	23724.0
2020-01-23 09:30:00	MSFT	Stock	166.19	166.35	165.27	166.2	2168832.0
2020-01-23 10:00:00	MSFT	Stock	166.19	166.59	166.021	166.39	1166646.0
2020-01-23 10:30:00	MSFT	Stock	166.4	166.62	166.084	166.22	871467.0
2020-01-23 11:00:00	MSFT	Stock	166.21	166.34	165.76	165.76	754580.0
2020-01-23 11:30:00	MSFT	Stock	165.75	166.12	165.61	165.97	577351.0
2020-01-23 12:00:00	MSFT	Stock	165.946	166.23	165.875	166.16	547596.0
2020-01-23 12:30:00	MSFT	Stock	166.16	166.19	165.88	165.91	369196.0
2020-01-23 13:00:00	MSFT	Stock	165.916	166.22	165.8	165.94	447429.0

> showing 50 of 86,298 rows — these rows as CSV

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