PREVIEW / stock_30min / 2020-10-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-23.parquet
  size:    1.9 MB
  rows:    95,372
  symbols: 2,509

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-10-23 04:00:00	AAPL	Stock	116.25	116.65	116.25	116.56	38551.0
2020-10-23 04:30:00	AAPL	Stock	116.57	116.59	116.1	116.29	31664.0
2020-10-23 05:00:00	AAPL	Stock	116.17	116.55	116.05	116.4	27291.0
2020-10-23 05:30:00	AAPL	Stock	116.35	116.47	116.2	116.26	4961.0
2020-10-23 06:00:00	AAPL	Stock	116.29	116.3	115.88	115.96	11922.0
2020-10-23 06:30:00	AAPL	Stock	115.96	116.5	115.96	116.35	16833.0
2020-10-23 07:00:00	AAPL	Stock	116.3	116.35	116.1	116.28	76304.0
2020-10-23 07:30:00	AAPL	Stock	116.3	116.42	116.25	116.3	41403.0
2020-10-23 08:00:00	AAPL	Stock	116.27	116.48	116.03	116.4	196522.0
2020-10-23 08:30:00	AAPL	Stock	116.36	116.45	116.18	116.26	124885.0
2020-10-23 09:00:00	AAPL	Stock	116.27	116.38	116.2	116.36	220472.0
2020-10-23 09:30:00	AAPL	Stock	116.38	116.55	115.37	115.47	9014973.0
2020-10-23 10:00:00	AAPL	Stock	115.46	115.46	114.74	115.06	7778307.0
2020-10-23 10:30:00	AAPL	Stock	115.05	115.36	114.78	115.04	5194519.0
2020-10-23 11:00:00	AAPL	Stock	115.04	115.32	114.54	114.865	5208694.0
2020-10-23 11:30:00	AAPL	Stock	114.86	114.9	114.28	114.6	5564074.0
2020-10-23 12:00:00	AAPL	Stock	114.592	114.99	114.33	114.489	5303468.0
2020-10-23 12:30:00	AAPL	Stock	114.486	115.05	114.425	114.83	4633141.0
2020-10-23 13:00:00	AAPL	Stock	114.82	115.11	114.77	115.0	3309026.0
2020-10-23 13:30:00	AAPL	Stock	115.0	115.16	114.8	114.86	3173188.0
2020-10-23 14:00:00	AAPL	Stock	114.855	115.09	114.71	114.776	3366946.0
2020-10-23 14:30:00	AAPL	Stock	114.78	114.85	114.41	114.42	3975576.0
2020-10-23 15:00:00	AAPL	Stock	114.424	114.77	114.4	114.6	3923237.0
2020-10-23 15:30:00	AAPL	Stock	114.595	115.085	114.4	115.05	7813501.0
2020-10-23 16:00:00	AAPL	Stock	115.04	115.052	114.97	115.0	4170012.0
2020-10-23 16:30:00	AAPL	Stock	115.0	115.02	114.99	115.0	104313.0
2020-10-23 17:00:00	AAPL	Stock	115.0	115.07	114.99	115.06	46598.0
2020-10-23 17:30:00	AAPL	Stock	115.06	115.29	115.04	115.09	99360.0
2020-10-23 18:00:00	AAPL	Stock	115.07	115.22	115.07	115.07	70951.0
2020-10-23 18:30:00	AAPL	Stock	115.08	115.15	115.03	115.08	45994.0
2020-10-23 19:00:00	AAPL	Stock	115.08	115.1	115.05	115.1	23926.0
2020-10-23 19:30:00	AAPL	Stock	115.1	115.1	115.02	115.09	48666.0
2020-10-23 04:30:00	MSFT	Stock	215.2	215.2	215.0	215.0	3011.0
2020-10-23 05:00:00	MSFT	Stock	215.0	215.3	214.57	215.3	1458.0
2020-10-23 05:30:00	MSFT	Stock	215.1	215.5	215.07	215.08	2396.0
2020-10-23 06:00:00	MSFT	Stock	214.79	214.79	214.07	214.07	1006.0
2020-10-23 06:30:00	MSFT	Stock	214.44	214.82	214.44	214.82	322.0
2020-10-23 07:00:00	MSFT	Stock	215.05	215.26	214.77	215.16	5331.0
2020-10-23 07:30:00	MSFT	Stock	215.2	215.41	215.05	215.19	4967.0
2020-10-23 08:00:00	MSFT	Stock	215.36	215.51	214.9	215.5	12327.0
2020-10-23 08:30:00	MSFT	Stock	215.5	215.5	215.4	215.5	8924.0
2020-10-23 09:00:00	MSFT	Stock	215.45	215.65	214.85	214.93	28240.0
2020-10-23 09:30:00	MSFT	Stock	215.03	215.29	213.16	214.38	2318519.0
2020-10-23 10:00:00	MSFT	Stock	214.32	215.34	213.53	215.05	1074998.0
2020-10-23 10:30:00	MSFT	Stock	215.03	215.73	214.43	215.04	965328.0
2020-10-23 11:00:00	MSFT	Stock	215.03	215.59	214.16	214.49	907097.0
2020-10-23 11:30:00	MSFT	Stock	214.485	214.85	213.8	214.85	838139.0
2020-10-23 12:00:00	MSFT	Stock	214.84	215.33	214.25	214.87	992360.0
2020-10-23 12:30:00	MSFT	Stock	214.86	215.28	214.61	214.78	740770.0
2020-10-23 13:00:00	MSFT	Stock	214.78	215.54	214.77	215.4	609581.0

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

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