PREVIEW / stock_30min / 2020-11-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-23.parquet
  size:    2.1 MB
  rows:    107,211
  symbols: 2,589

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-23 04:00:00	AAPL	Stock	117.31	117.91	117.31	117.74	15277.0
2020-11-23 04:30:00	AAPL	Stock	117.84	117.84	117.67	117.67	6439.0
2020-11-23 05:00:00	AAPL	Stock	117.67	117.7	117.59	117.59	1820.0
2020-11-23 05:30:00	AAPL	Stock	117.51	117.66	117.5	117.5	10220.0
2020-11-23 06:00:00	AAPL	Stock	117.48	117.55	117.3	117.53	11809.0
2020-11-23 06:30:00	AAPL	Stock	117.55	117.66	117.43	117.45	7904.0
2020-11-23 07:00:00	AAPL	Stock	117.6	117.7	117.45	117.56	150389.0
2020-11-23 07:30:00	AAPL	Stock	117.56	117.67	117.55	117.62	64651.0
2020-11-23 08:00:00	AAPL	Stock	117.47	117.65	117.4	117.45	177407.0
2020-11-23 08:30:00	AAPL	Stock	117.46	117.55	117.1	117.39	267105.0
2020-11-23 09:00:00	AAPL	Stock	117.352	117.59	117.11	117.19	266280.0
2020-11-23 09:30:00	AAPL	Stock	117.19	117.62	116.73	117.01	13051223.0
2020-11-23 10:00:00	AAPL	Stock	117.01	117.07	115.1	115.4	11956860.0
2020-11-23 10:30:00	AAPL	Stock	115.38	115.71	115.27	115.43	7089356.0
2020-11-23 11:00:00	AAPL	Stock	115.435	115.445	114.22	114.347	10503944.0
2020-11-23 11:30:00	AAPL	Stock	114.345	114.76	113.8	114.49	8240386.0
2020-11-23 12:00:00	AAPL	Stock	114.5	115.2	114.27	115.126	5802079.0
2020-11-23 12:30:00	AAPL	Stock	115.12	115.329	114.85	115.3	4286478.0
2020-11-23 13:00:00	AAPL	Stock	115.291	115.36	114.92	114.994	3685174.0
2020-11-23 13:30:00	AAPL	Stock	114.995	115.03	114.595	114.615	4680799.0
2020-11-23 14:00:00	AAPL	Stock	114.616	114.68	114.01	114.059	6300380.0
2020-11-23 14:30:00	AAPL	Stock	114.06	114.58	114.0	114.2	7133655.0
2020-11-23 15:00:00	AAPL	Stock	114.205	114.47	113.99	114.035	6716009.0
2020-11-23 15:30:00	AAPL	Stock	114.04	114.18	113.75	113.88	13223756.0
2020-11-23 16:00:00	AAPL	Stock	113.85	114.1	113.85	114.04	6172560.0
2020-11-23 16:30:00	AAPL	Stock	114.04	114.14	113.85	114.05	124953.0
2020-11-23 17:00:00	AAPL	Stock	114.05	114.07	113.85	114.05	97820.0
2020-11-23 17:30:00	AAPL	Stock	114.05	114.06	113.98	114.0	155072.0
2020-11-23 18:00:00	AAPL	Stock	114.0	114.75	113.99	114.54	238931.0
2020-11-23 18:30:00	AAPL	Stock	114.54	114.9	114.0	114.45	305818.0
2020-11-23 19:00:00	AAPL	Stock	114.41	114.5	114.35	114.49	109861.0
2020-11-23 19:30:00	AAPL	Stock	114.43	114.6	114.42	114.6	114671.0
2020-11-23 04:00:00	MSFT	Stock	211.5	211.5	211.3	211.3	1419.0
2020-11-23 04:30:00	MSFT	Stock	211.23	211.29	211.23	211.29	600.0
2020-11-23 05:00:00	MSFT	Stock	211.19	211.19	211.12	211.12	1794.0
2020-11-23 05:30:00	MSFT	Stock	211.27	211.27	211.12	211.13	1952.0
2020-11-23 06:00:00	MSFT	Stock	211.13	211.13	210.91	211.01	1272.0
2020-11-23 06:30:00	MSFT	Stock	210.7	210.88	210.6	210.6	5239.0
2020-11-23 07:00:00	MSFT	Stock	210.7	210.75	210.52	210.6	19939.0
2020-11-23 07:30:00	MSFT	Stock	210.84	210.95	210.58	210.9	14266.0
2020-11-23 08:00:00	MSFT	Stock	210.581	211.0	210.55	210.71	30061.0
2020-11-23 08:30:00	MSFT	Stock	210.66	210.977	210.39	210.7	27830.0
2020-11-23 09:00:00	MSFT	Stock	210.65	211.0	210.65	210.85	24059.0
2020-11-23 09:30:00	MSFT	Stock	210.85	212.29	210.85	211.66	1877457.0
2020-11-23 10:00:00	MSFT	Stock	211.66	211.84	209.26	209.516	1703207.0
2020-11-23 10:30:00	MSFT	Stock	209.5	210.4	209.36	210.4	1312953.0
2020-11-23 11:00:00	MSFT	Stock	210.385	210.44	208.35	208.66	1555817.0
2020-11-23 11:30:00	MSFT	Stock	208.69	208.92	208.16	208.6	1265965.0
2020-11-23 12:00:00	MSFT	Stock	208.58	209.33	208.31	209.21	756335.0
2020-11-23 12:30:00	MSFT	Stock	209.25	209.66	209.0	209.63	643444.0

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

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