PREVIEW / stock_30min / 2020-12-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-12-23.parquet
  size:    2.2 MB
  rows:    111,716
  symbols: 2,682

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-12-23 04:00:00	AAPL	Stock	131.75	132.38	131.66	132.01	36645.0
2020-12-23 04:30:00	AAPL	Stock	132.11	132.68	132.07	132.67	17964.0
2020-12-23 05:00:00	AAPL	Stock	132.65	132.75	132.6	132.65	8209.0
2020-12-23 05:30:00	AAPL	Stock	132.63	132.7	132.41	132.6	12042.0
2020-12-23 06:00:00	AAPL	Stock	132.6	132.6	132.0	132.03	19713.0
2020-12-23 06:30:00	AAPL	Stock	132.09	132.12	131.65	131.8	15136.0
2020-12-23 07:00:00	AAPL	Stock	131.82	131.88	131.16	131.75	248803.0
2020-12-23 07:30:00	AAPL	Stock	131.7	132.189	131.7	132.189	156832.0
2020-12-23 08:00:00	AAPL	Stock	131.42	132.5	131.16	132.4	482478.0
2020-12-23 08:30:00	AAPL	Stock	132.4	132.59	132.25	132.28	279885.0
2020-12-23 09:00:00	AAPL	Stock	132.28	132.35	132.11	132.13	216933.0
2020-12-23 09:30:00	AAPL	Stock	132.14	132.43	130.78	132.15	15045506.0
2020-12-23 10:00:00	AAPL	Stock	132.15	132.2	131.64	131.734	6173000.0
2020-12-23 10:30:00	AAPL	Stock	131.73	131.89	131.162	131.44	5791995.0
2020-12-23 11:00:00	AAPL	Stock	131.43	131.83	131.25	131.39	4657173.0
2020-12-23 11:30:00	AAPL	Stock	131.39	131.69	131.21	131.56	3632269.0
2020-12-23 12:00:00	AAPL	Stock	131.55	132.12	131.5	132.068	4437851.0
2020-12-23 12:30:00	AAPL	Stock	132.05	132.09	131.8	131.955	2937978.0
2020-12-23 13:00:00	AAPL	Stock	131.955	132.26	131.87	132.08	3286361.0
2020-12-23 13:30:00	AAPL	Stock	132.075	132.1	131.84	132.06	2309717.0
2020-12-23 14:00:00	AAPL	Stock	132.05	132.07	131.62	131.756	2790095.0
2020-12-23 14:30:00	AAPL	Stock	131.76	131.82	131.56	131.735	2646901.0
2020-12-23 15:00:00	AAPL	Stock	131.735	131.87	131.565	131.61	3141352.0
2020-12-23 15:30:00	AAPL	Stock	131.61	131.88	130.92	130.96	8711410.0
2020-12-23 16:00:00	AAPL	Stock	130.95	131.06	130.78	130.9	10400432.0
2020-12-23 16:30:00	AAPL	Stock	130.93	130.96	130.85	130.92	106093.0
2020-12-23 17:00:00	AAPL	Stock	130.94	131.12	130.9	131.1	89532.0
2020-12-23 17:30:00	AAPL	Stock	131.09	131.16	130.96	131.14	44725.0
2020-12-23 18:00:00	AAPL	Stock	131.07	131.14	131.02	131.08	37944.0
2020-12-23 18:30:00	AAPL	Stock	131.03	131.08	130.88	130.92	34811.0
2020-12-23 19:00:00	AAPL	Stock	130.9	131.03	130.9	130.91	34549.0
2020-12-23 19:30:00	AAPL	Stock	130.91	131.05	130.89	131.05	45128.0
2020-12-23 04:00:00	MSFT	Stock	224.0	224.49	224.0	224.49	1384.0
2020-12-23 04:30:00	MSFT	Stock	224.69	224.7	224.69	224.7	436.0
2020-12-23 05:00:00	MSFT	Stock	224.7	224.72	224.57	224.57	954.0
2020-12-23 05:30:00	MSFT	Stock	224.84	224.84	224.8	224.8	1162.0
2020-12-23 06:00:00	MSFT	Stock	224.68	224.68	224.68	224.68	100.0
2020-12-23 06:30:00	MSFT	Stock	224.5	224.5	224.4	224.4	584.0
2020-12-23 07:00:00	MSFT	Stock	224.39	224.39	223.9	224.0	4767.0
2020-12-23 07:30:00	MSFT	Stock	223.92	224.1	223.92	224.02	6081.0
2020-12-23 08:00:00	MSFT	Stock	224.145	224.25	223.49	223.748	14723.0
2020-12-23 08:30:00	MSFT	Stock	223.85	224.05	223.71	223.8	14022.0
2020-12-23 09:00:00	MSFT	Stock	223.8	223.9	223.19	223.19	27351.0
2020-12-23 09:30:00	MSFT	Stock	223.12	223.559	222.08	222.94	1910458.0
2020-12-23 10:00:00	MSFT	Stock	222.94	223.36	222.15	223.18	1067805.0
2020-12-23 10:30:00	MSFT	Stock	223.18	223.28	222.21	222.46	872533.0
2020-12-23 11:00:00	MSFT	Stock	222.46	222.73	222.03	222.12	789699.0
2020-12-23 11:30:00	MSFT	Stock	222.12	222.6	221.95	222.5	677960.0
2020-12-23 12:00:00	MSFT	Stock	222.54	222.91	222.34	222.83	525687.0
2020-12-23 12:30:00	MSFT	Stock	222.82	223.09	222.49	222.84	533399.0

> showing 50 of 111,716 rows — these rows as CSV

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