PREVIEW / stock_30min / 2020-09-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-09-09.parquet
  size:    1.9 MB
  rows:    95,890
  symbols: 2,463

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-09-09 04:00:00	AAPL	Stock	114.51	116.24	114.51	116.14	141105.0
2020-09-09 04:30:00	AAPL	Stock	116.18	116.24	115.66	116.07	79379.0
2020-09-09 05:00:00	AAPL	Stock	116.1	116.8	115.61	116.6	66764.0
2020-09-09 05:30:00	AAPL	Stock	116.6	117.19	116.13	117.1	62022.0
2020-09-09 06:00:00	AAPL	Stock	117.02	117.19	116.36	116.75	60455.0
2020-09-09 06:30:00	AAPL	Stock	116.75	116.97	116.49	116.6	36023.0
2020-09-09 07:00:00	AAPL	Stock	116.59	116.64	115.03	116.4	603349.0
2020-09-09 07:30:00	AAPL	Stock	116.4	116.47	115.25	116.18	297620.0
2020-09-09 08:00:00	AAPL	Stock	115.761	116.49	115.03	115.55	1038625.0
2020-09-09 08:30:00	AAPL	Stock	115.67	116.23	115.38	115.75	752843.0
2020-09-09 09:00:00	AAPL	Stock	115.74	117.32	115.6	117.25	1093671.0
2020-09-09 09:30:00	AAPL	Stock	117.31	118.0	115.26	116.39	26044861.0
2020-09-09 10:00:00	AAPL	Stock	116.39	117.7	115.81	117.62	14411430.0
2020-09-09 10:30:00	AAPL	Stock	117.62	118.18	116.92	117.85	12158984.0
2020-09-09 11:00:00	AAPL	Stock	117.85	118.47	116.97	117.835	10594251.0
2020-09-09 11:30:00	AAPL	Stock	117.84	118.0	117.32	117.85	6611451.0
2020-09-09 12:00:00	AAPL	Stock	117.85	118.31	117.66	117.978	6747146.0
2020-09-09 12:30:00	AAPL	Stock	117.98	118.53	117.8	118.417	6321012.0
2020-09-09 13:00:00	AAPL	Stock	118.415	119.14	118.08	118.3	9562563.0
2020-09-09 13:30:00	AAPL	Stock	118.3	118.4	117.3	117.42	7922989.0
2020-09-09 14:00:00	AAPL	Stock	117.42	117.89	117.1	117.52	6852658.0
2020-09-09 14:30:00	AAPL	Stock	117.52	118.29	117.52	117.87	6171473.0
2020-09-09 15:00:00	AAPL	Stock	117.87	118.08	117.52	117.8	6808357.0
2020-09-09 15:30:00	AAPL	Stock	117.8	118.15	116.8	117.18	14147500.0
2020-09-09 16:00:00	AAPL	Stock	117.25	117.48	116.8	117.25	14037325.0
2020-09-09 16:30:00	AAPL	Stock	117.27	117.32	116.9	116.99	188095.0
2020-09-09 17:00:00	AAPL	Stock	116.95	117.19	116.9	117.11	64481.0
2020-09-09 17:30:00	AAPL	Stock	117.1	117.35	117.0	117.26	71857.0
2020-09-09 18:00:00	AAPL	Stock	117.29	118.39	117.29	118.26	316518.0
2020-09-09 18:30:00	AAPL	Stock	118.22	118.41	117.95	118.32	134997.0
2020-09-09 19:00:00	AAPL	Stock	118.31	118.5	118.1	118.4	129489.0
2020-09-09 19:30:00	AAPL	Stock	118.42	118.54	118.0	118.52	171304.0
2020-09-09 04:00:00	MSFT	Stock	205.5	207.18	205.5	206.8	8120.0
2020-09-09 04:30:00	MSFT	Stock	207.0	207.2	205.52	207.19	6392.0
2020-09-09 05:00:00	MSFT	Stock	207.17	207.24	206.32	207.23	8982.0
2020-09-09 05:30:00	MSFT	Stock	207.2	207.48	206.4	207.1	3757.0
2020-09-09 06:00:00	MSFT	Stock	207.01	207.38	206.1	206.8	6807.0
2020-09-09 06:30:00	MSFT	Stock	206.63	207.12	206.62	206.93	2736.0
2020-09-09 07:00:00	MSFT	Stock	206.65	207.0	205.15	206.5	77519.0
2020-09-09 07:30:00	MSFT	Stock	206.5	206.5	205.15	206.2	48696.0
2020-09-09 08:00:00	MSFT	Stock	205.6	207.0	205.39	205.52	115798.0
2020-09-09 08:30:00	MSFT	Stock	205.97	206.25	205.02	205.49	64438.0
2020-09-09 09:00:00	MSFT	Stock	205.32	207.72	205.32	207.65	140261.0
2020-09-09 09:30:00	MSFT	Stock	207.6	209.89	206.7	209.86	6036877.0
2020-09-09 10:00:00	MSFT	Stock	209.89	211.57	209.41	211.07	3742445.0
2020-09-09 10:30:00	MSFT	Stock	211.065	212.06	210.89	211.11	1933067.0
2020-09-09 11:00:00	MSFT	Stock	211.14	211.78	209.83	210.346	1591448.0
2020-09-09 11:30:00	MSFT	Stock	210.36	211.86	210.04	211.85	1629430.0
2020-09-09 12:00:00	MSFT	Stock	211.87	212.49	211.8	212.271	1287505.0
2020-09-09 12:30:00	MSFT	Stock	212.28	213.485	212.267	213.34	1443656.0

> showing 50 of 95,890 rows — these rows as CSV

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