PREVIEW / stock_30min / 2020-11-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-17.parquet
  size:    2.0 MB
  rows:    101,086
  symbols: 2,551

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-11-17 04:00:00	AAPL	Stock	119.99	119.99	119.49	119.85	8353.0
2020-11-17 04:30:00	AAPL	Stock	119.77	119.85	119.72	119.79	4099.0
2020-11-17 05:00:00	AAPL	Stock	119.73	119.73	119.61	119.69	3481.0
2020-11-17 05:30:00	AAPL	Stock	119.69	119.74	119.47	119.6	11054.0
2020-11-17 06:00:00	AAPL	Stock	119.6	119.6	119.4	119.6	9287.0
2020-11-17 06:30:00	AAPL	Stock	119.61	119.69	119.55	119.65	2918.0
2020-11-17 07:00:00	AAPL	Stock	119.68	119.86	119.42	119.5	93804.0
2020-11-17 07:30:00	AAPL	Stock	119.53	119.78	119.5	119.76	77455.0
2020-11-17 08:00:00	AAPL	Stock	119.8	119.88	119.45	119.7	154653.0
2020-11-17 08:30:00	AAPL	Stock	119.69	119.73	119.5	119.73	131913.0
2020-11-17 09:00:00	AAPL	Stock	119.74	119.85	119.49	119.5	191073.0
2020-11-17 09:30:00	AAPL	Stock	119.53	120.31	118.96	119.142	11159489.0
2020-11-17 10:00:00	AAPL	Stock	119.135	119.91	119.11	119.85	5152427.0
2020-11-17 10:30:00	AAPL	Stock	119.85	120.53	119.771	120.36	5861480.0
2020-11-17 11:00:00	AAPL	Stock	120.36	120.4	119.6	119.82	4391825.0
2020-11-17 11:30:00	AAPL	Stock	119.83	120.22	119.68	120.22	3340928.0
2020-11-17 12:00:00	AAPL	Stock	120.22	120.34	120.015	120.205	2944363.0
2020-11-17 12:30:00	AAPL	Stock	120.205	120.49	120.18	120.475	2553835.0
2020-11-17 13:00:00	AAPL	Stock	120.47	120.674	120.28	120.48	3165916.0
2020-11-17 13:30:00	AAPL	Stock	120.475	120.542	120.3	120.36	1974076.0
2020-11-17 14:00:00	AAPL	Stock	120.36	120.615	120.252	120.304	2776582.0
2020-11-17 14:30:00	AAPL	Stock	120.3	120.55	119.96	120.014	3174118.0
2020-11-17 15:00:00	AAPL	Stock	120.014	120.15	119.54	119.77	4293403.0
2020-11-17 15:30:00	AAPL	Stock	119.77	119.81	119.32	119.36	6977037.0
2020-11-17 16:00:00	AAPL	Stock	119.36	119.49	119.36	119.45	7539494.0
2020-11-17 16:30:00	AAPL	Stock	119.45	119.48	119.36	119.42	73331.0
2020-11-17 17:00:00	AAPL	Stock	119.39	119.47	119.35	119.45	21872.0
2020-11-17 17:30:00	AAPL	Stock	119.42	119.47	119.41	119.41	20053.0
2020-11-17 18:00:00	AAPL	Stock	119.4	119.43	119.3	119.3	27657.0
2020-11-17 18:30:00	AAPL	Stock	119.35	119.45	119.25	119.25	56098.0
2020-11-17 19:00:00	AAPL	Stock	119.31	119.4	119.25	119.32	35458.0
2020-11-17 19:30:00	AAPL	Stock	119.27	119.28	119.11	119.2	78764.0
2020-11-17 04:00:00	MSFT	Stock	217.63	217.8	217.4	217.72	2510.0
2020-11-17 04:30:00	MSFT	Stock	217.7	217.7	217.7	217.7	234.0
2020-11-17 05:00:00	MSFT	Stock	217.42	217.42	217.4	217.4	362.0
2020-11-17 05:30:00	MSFT	Stock	217.22	217.22	217.0	217.0	527.0
2020-11-17 06:00:00	MSFT	Stock	216.5	216.55	216.5	216.55	497.0
2020-11-17 06:30:00	MSFT	Stock	216.94	216.96	216.79	216.8	639.0
2020-11-17 07:00:00	MSFT	Stock	216.68	216.88	215.56	216.0	18472.0
2020-11-17 07:30:00	MSFT	Stock	215.98	216.21	215.8	216.21	7194.0
2020-11-17 08:00:00	MSFT	Stock	216.69	216.98	215.85	216.2	12441.0
2020-11-17 08:30:00	MSFT	Stock	216.21	216.3	215.8	216.2	17204.0
2020-11-17 09:00:00	MSFT	Stock	216.21	216.72	216.0	216.23	22542.0
2020-11-17 09:30:00	MSFT	Stock	216.1	217.68	215.71	215.78	2048180.0
2020-11-17 10:00:00	MSFT	Stock	215.76	216.73	215.72	216.345	918349.0
2020-11-17 10:30:00	MSFT	Stock	216.36	217.035	216.16	216.925	801237.0
2020-11-17 11:00:00	MSFT	Stock	216.93	217.0	215.1	215.47	1264925.0
2020-11-17 11:30:00	MSFT	Stock	215.498	215.8	214.75	215.77	1285036.0
2020-11-17 12:00:00	MSFT	Stock	215.76	216.31	215.57	215.91	749745.0
2020-11-17 12:30:00	MSFT	Stock	215.92	216.15	215.665	215.99	596708.0

> showing 50 of 101,086 rows — these rows as CSV

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