PREVIEW / stock_30min / 2020-10-22

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-10-22.parquet
  size:    1.9 MB
  rows:    97,504
  symbols: 2,519

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-22 04:00:00	AAPL	Stock	116.0	116.7	116.0	116.69	36361.0
2020-10-22 04:30:00	AAPL	Stock	116.65	116.69	116.31	116.31	12764.0
2020-10-22 05:00:00	AAPL	Stock	116.32	116.43	116.32	116.4	8133.0
2020-10-22 05:30:00	AAPL	Stock	116.44	116.47	116.31	116.47	7233.0
2020-10-22 06:00:00	AAPL	Stock	116.32	116.9	116.2	116.69	21127.0
2020-10-22 06:30:00	AAPL	Stock	116.6	117.12	116.38	116.91	29068.0
2020-10-22 07:00:00	AAPL	Stock	116.93	117.04	116.69	116.95	163926.0
2020-10-22 07:30:00	AAPL	Stock	116.94	117.05	116.76	116.98	106470.0
2020-10-22 08:00:00	AAPL	Stock	116.68	117.19	116.68	117.12	390685.0
2020-10-22 08:30:00	AAPL	Stock	117.13	117.58	117.1	117.29	440275.0
2020-10-22 09:00:00	AAPL	Stock	117.29	117.5	117.15	117.4	306025.0
2020-10-22 09:30:00	AAPL	Stock	117.41	118.04	117.18	117.275	10025853.0
2020-10-22 10:00:00	AAPL	Stock	117.27	117.37	116.171	116.2	7275858.0
2020-10-22 10:30:00	AAPL	Stock	116.21	116.25	114.59	115.61	14484986.0
2020-10-22 11:00:00	AAPL	Stock	115.6	116.1	115.33	115.796	8950103.0
2020-10-22 11:30:00	AAPL	Stock	115.8	115.905	115.32	115.39	4753982.0
2020-10-22 12:00:00	AAPL	Stock	115.4	115.52	115.06	115.35	4905864.0
2020-10-22 12:30:00	AAPL	Stock	115.341	115.74	114.97	115.64	5680041.0
2020-10-22 13:00:00	AAPL	Stock	115.63	116.125	115.4	115.94	5166232.0
2020-10-22 13:30:00	AAPL	Stock	115.945	116.0	115.38	115.538	4828250.0
2020-10-22 14:00:00	AAPL	Stock	115.535	115.82	115.32	115.667	3829122.0
2020-10-22 14:30:00	AAPL	Stock	115.67	115.93	115.51	115.82	3426192.0
2020-10-22 15:00:00	AAPL	Stock	115.82	116.09	115.5	116.01	4116246.0
2020-10-22 15:30:00	AAPL	Stock	116.02	116.34	115.6	115.774	8875445.0
2020-10-22 16:00:00	AAPL	Stock	115.75	115.98	115.6	115.89	5284653.0
2020-10-22 16:30:00	AAPL	Stock	115.87	115.95	115.8	115.8	68064.0
2020-10-22 17:00:00	AAPL	Stock	115.79	115.91	115.79	115.87	53376.0
2020-10-22 17:30:00	AAPL	Stock	115.85	115.94	115.81	115.93	56449.0
2020-10-22 18:00:00	AAPL	Stock	115.93	116.23	115.91	116.18	113172.0
2020-10-22 18:30:00	AAPL	Stock	116.18	116.2	116.05	116.05	51598.0
2020-10-22 19:00:00	AAPL	Stock	116.05	116.06	115.84	115.97	81436.0
2020-10-22 19:30:00	AAPL	Stock	115.97	116.1	115.95	116.1	68658.0
2020-10-22 04:00:00	MSFT	Stock	214.28	214.28	214.28	214.28	1150.0
2020-10-22 05:30:00	MSFT	Stock	214.58	214.68	214.58	214.68	380.0
2020-10-22 06:00:00	MSFT	Stock	214.31	214.69	214.0	214.69	2721.0
2020-10-22 06:30:00	MSFT	Stock	214.41	214.55	214.05	214.28	3077.0
2020-10-22 07:00:00	MSFT	Stock	214.04	214.66	214.02	214.25	9699.0
2020-10-22 07:30:00	MSFT	Stock	214.32	214.51	214.01	214.25	14220.0
2020-10-22 08:00:00	MSFT	Stock	214.51	214.7	213.52	214.11	47255.0
2020-10-22 08:30:00	MSFT	Stock	214.19	214.43	214.0	214.1	35667.0
2020-10-22 09:00:00	MSFT	Stock	214.22	214.422	213.96	214.02	58600.0
2020-10-22 09:30:00	MSFT	Stock	213.96	216.055	213.9	214.257	2350200.0
2020-10-22 10:00:00	MSFT	Stock	214.24	214.354	212.66	213.12	1442917.0
2020-10-22 10:30:00	MSFT	Stock	213.13	213.28	211.7	212.83	1573649.0
2020-10-22 11:00:00	MSFT	Stock	212.8	213.755	212.27	213.519	1043320.0
2020-10-22 11:30:00	MSFT	Stock	213.54	213.85	213.01	213.12	730436.0
2020-10-22 12:00:00	MSFT	Stock	213.16	213.225	212.54	212.91	726598.0
2020-10-22 12:30:00	MSFT	Stock	212.89	213.81	212.16	213.72	799249.0
2020-10-22 13:00:00	MSFT	Stock	213.72	214.5	213.51	214.46	1007292.0
2020-10-22 13:30:00	MSFT	Stock	214.45	215.15	214.18	214.92	721180.0

> showing 50 of 97,504 rows — these rows as CSV

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