PREVIEW / stock_30min / 2020-06-08

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-06-08.parquet
  size:    2.1 MB
  rows:    104,316
  symbols: 2,407

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-06-08 04:00:00	AAPL	Stock	82.75	82.7525	82.5625	82.575	7164.0
2020-06-08 04:30:00	AAPL	Stock	82.75	82.85	82.7475	82.775	14596.0
2020-06-08 05:00:00	AAPL	Stock	82.8475	82.875	82.7475	82.7475	6156.0
2020-06-08 05:30:00	AAPL	Stock	82.7475	82.7475	82.675	82.675	2528.0
2020-06-08 06:00:00	AAPL	Stock	82.61	82.65	82.575	82.65	3944.0
2020-06-08 06:30:00	AAPL	Stock	82.655	82.72	82.65	82.66	6740.0
2020-06-08 07:00:00	AAPL	Stock	82.6475	82.875	82.5875	82.7775	214000.0
2020-06-08 07:30:00	AAPL	Stock	82.7825	82.8675	82.5875	82.6975	100528.0
2020-06-08 08:00:00	AAPL	Stock	82.75	82.8725	82.4625	82.67	281584.0
2020-06-08 08:30:00	AAPL	Stock	82.6725	82.7875	82.64	82.67	188328.0
2020-06-08 09:00:00	AAPL	Stock	82.685	82.7875	82.425	82.5575	511068.0
2020-06-08 09:30:00	AAPL	Stock	82.5625	82.845	82.2025	82.28	12642648.0
2020-06-08 10:00:00	AAPL	Stock	82.2788	82.3175	81.83	82.13	8265604.0
2020-06-08 10:30:00	AAPL	Stock	82.13	82.5378	82.1075	82.5025	4876924.0
2020-06-08 11:00:00	AAPL	Stock	82.5075	82.7275	82.4275	82.725	3473940.0
2020-06-08 11:30:00	AAPL	Stock	82.73	82.7375	82.4222	82.6225	3407228.0
2020-06-08 12:00:00	AAPL	Stock	82.63	82.6775	82.4575	82.495	2462252.0
2020-06-08 12:30:00	AAPL	Stock	82.5	82.6575	82.4825	82.625	1953832.0
2020-06-08 13:00:00	AAPL	Stock	82.6325	82.675	82.4875	82.6658	2173412.0
2020-06-08 13:30:00	AAPL	Stock	82.6675	83.11	82.6275	83.109	5175944.0
2020-06-08 14:00:00	AAPL	Stock	83.1025	83.195	82.9875	83.179	4201092.0
2020-06-08 14:30:00	AAPL	Stock	83.1762	83.2675	83.0838	83.195	4585120.0
2020-06-08 15:00:00	AAPL	Stock	83.1975	83.1975	83.04	83.085	3454564.0
2020-06-08 15:30:00	AAPL	Stock	83.09	83.4	83.075	83.3825	9485532.0
2020-06-08 16:00:00	AAPL	Stock	83.3875	83.4	83.2875	83.325	7149264.0
2020-06-08 16:30:00	AAPL	Stock	83.325	83.37	83.3125	83.35	18188.0
2020-06-08 17:00:00	AAPL	Stock	83.3125	83.3375	83.295	83.3125	8224.0
2020-06-08 17:30:00	AAPL	Stock	83.295	83.305	83.295	83.305	7780.0
2020-06-08 18:00:00	AAPL	Stock	83.2875	83.325	83.23	83.25	26320.0
2020-06-08 18:30:00	AAPL	Stock	83.2275	83.2475	83.15	83.15	8600.0
2020-06-08 19:00:00	AAPL	Stock	83.15	83.1875	83.11	83.1625	18428.0
2020-06-08 19:30:00	AAPL	Stock	83.105	83.245	83.0775	83.2	34828.0
2020-06-08 04:00:00	MSFT	Stock	187.02	187.04	186.6	186.6	1436.0
2020-06-08 04:30:00	MSFT	Stock	187.05	187.05	186.78	187.05	590.0
2020-06-08 05:00:00	MSFT	Stock	187.19	187.19	187.02	187.02	1025.0
2020-06-08 05:30:00	MSFT	Stock	186.97	186.97	186.8	186.8	1852.0
2020-06-08 06:00:00	MSFT	Stock	186.6	186.63	186.6	186.6	425.0
2020-06-08 06:30:00	MSFT	Stock	186.51	186.77	186.5	186.5	2928.0
2020-06-08 07:00:00	MSFT	Stock	186.6	186.93	185.95	186.38	49133.0
2020-06-08 07:30:00	MSFT	Stock	186.2	186.39	185.5	185.8	35772.0
2020-06-08 08:00:00	MSFT	Stock	186.12	186.95	185.5	186.05	57960.0
2020-06-08 08:30:00	MSFT	Stock	186.14	186.6	186.0	186.31	51957.0
2020-06-08 09:00:00	MSFT	Stock	186.3	186.55	185.42	185.83	99934.0
2020-06-08 09:30:00	MSFT	Stock	185.79	186.29	184.62	185.13	4800940.0
2020-06-08 10:00:00	MSFT	Stock	185.13	185.22	184.44	185.21	2557687.0
2020-06-08 10:30:00	MSFT	Stock	185.2	185.68	185.1	185.335	2114338.0
2020-06-08 11:00:00	MSFT	Stock	185.34	186.2	185.332	186.165	1670835.0
2020-06-08 11:30:00	MSFT	Stock	186.16	186.45	185.58	186.35	1386137.0
2020-06-08 12:00:00	MSFT	Stock	186.37	186.62	186.2	186.325	974522.0
2020-06-08 12:30:00	MSFT	Stock	186.33	187.195	186.33	186.89	1110718.0

> showing 50 of 104,316 rows — these rows as CSV

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