PREVIEW / stock_30min / 2020-04-17

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-17.parquet
  size:    1.9 MB
  rows:    94,763
  symbols: 2,403

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-04-17 04:00:00	AAPL	Stock	72.1975	72.625	72.0	72.09	177376.0
2020-04-17 04:30:00	AAPL	Stock	72.0675	72.175	71.75	71.875	73048.0
2020-04-17 05:00:00	AAPL	Stock	71.85	72.1475	71.85	72.085	43852.0
2020-04-17 05:30:00	AAPL	Stock	72.085	72.335	71.9525	72.25	53764.0
2020-04-17 06:00:00	AAPL	Stock	72.25	72.4975	72.235	72.3725	50088.0
2020-04-17 06:30:00	AAPL	Stock	72.2625	72.5	72.2125	72.4825	83368.0
2020-04-17 07:00:00	AAPL	Stock	72.4425	72.8325	72.025	72.125	757776.0
2020-04-17 07:30:00	AAPL	Stock	72.1225	72.1375	71.7025	71.7125	745716.0
2020-04-17 08:00:00	AAPL	Stock	72.6575	72.8325	71.5	71.78	1376004.0
2020-04-17 08:30:00	AAPL	Stock	71.78	71.8625	71.3625	71.4585	1183316.0
2020-04-17 09:00:00	AAPL	Stock	71.435	71.45	70.735	71.2	1413480.0
2020-04-17 09:30:00	AAPL	Stock	71.19	71.7362	70.695	71.01	28866352.0
2020-04-17 10:00:00	AAPL	Stock	71.0025	71.0625	70.18	70.2388	13706988.0
2020-04-17 10:30:00	AAPL	Stock	70.2375	70.515	69.83	70.445	14210992.0
2020-04-17 11:00:00	AAPL	Stock	70.4412	70.6475	69.8525	69.9758	10019832.0
2020-04-17 11:30:00	AAPL	Stock	69.9775	70.4675	69.9175	70.155	8363104.0
2020-04-17 12:00:00	AAPL	Stock	70.1625	70.2725	69.9475	70.04	7016328.0
2020-04-17 12:30:00	AAPL	Stock	70.045	70.385	70.015	70.3012	6878908.0
2020-04-17 13:00:00	AAPL	Stock	70.3	70.345	70.0	70.0212	4908860.0
2020-04-17 13:30:00	AAPL	Stock	70.02	70.2538	69.9	69.9275	5582640.0
2020-04-17 14:00:00	AAPL	Stock	69.92	69.9208	69.5925	69.6045	8390488.0
2020-04-17 14:30:00	AAPL	Stock	69.595	69.6025	69.215	69.5725	11178956.0
2020-04-17 15:00:00	AAPL	Stock	69.5775	70.0075	69.5325	69.9965	10854232.0
2020-04-17 15:30:00	AAPL	Stock	69.9975	70.74	69.9975	70.7	24092532.0
2020-04-17 16:00:00	AAPL	Stock	70.635	70.8375	70.2005	70.7	15163100.0
2020-04-17 16:30:00	AAPL	Stock	70.6825	70.72	70.63	70.6325	193636.0
2020-04-17 17:00:00	AAPL	Stock	70.6272	70.6425	70.5625	70.575	136824.0
2020-04-17 17:30:00	AAPL	Stock	70.575	70.635	70.5075	70.5075	95284.0
2020-04-17 18:00:00	AAPL	Stock	70.5075	70.51	70.4	70.4375	68876.0
2020-04-17 18:30:00	AAPL	Stock	70.45	70.5875	70.41	70.5875	90568.0
2020-04-17 19:00:00	AAPL	Stock	70.6	70.6	70.475	70.5	21364.0
2020-04-17 19:30:00	AAPL	Stock	70.5375	70.555	70.445	70.555	36580.0
2020-04-17 04:00:00	MSFT	Stock	181.32	181.32	180.05	180.66	5726.0
2020-04-17 04:30:00	MSFT	Stock	180.62	181.0	180.5	180.96	6894.0
2020-04-17 05:00:00	MSFT	Stock	180.85	181.0	180.54	180.61	13455.0
2020-04-17 05:30:00	MSFT	Stock	180.61	181.15	180.44	181.15	16182.0
2020-04-17 06:00:00	MSFT	Stock	181.25	181.25	180.6	181.25	9065.0
2020-04-17 06:30:00	MSFT	Stock	181.3	181.73	181.14	181.35	7432.0
2020-04-17 07:00:00	MSFT	Stock	181.35	181.98	180.92	181.0	100357.0
2020-04-17 07:30:00	MSFT	Stock	181.04	181.1	180.6	180.8	32699.0
2020-04-17 08:00:00	MSFT	Stock	181.886	181.97	180.51	180.52	90919.0
2020-04-17 08:30:00	MSFT	Stock	180.53	180.75	180.0	180.262	106374.0
2020-04-17 09:00:00	MSFT	Stock	180.1	180.7	178.88	179.5	261727.0
2020-04-17 09:30:00	MSFT	Stock	179.39	180.0	177.0	178.433	8511484.0
2020-04-17 10:00:00	MSFT	Stock	178.42	179.827	178.35	178.59	3938555.0
2020-04-17 10:30:00	MSFT	Stock	178.6	178.73	177.68	177.915	2543094.0
2020-04-17 11:00:00	MSFT	Stock	177.92	178.53	176.455	176.61	2781930.0
2020-04-17 11:30:00	MSFT	Stock	176.61	177.48	176.16	176.688	2462509.0
2020-04-17 12:00:00	MSFT	Stock	176.72	176.73	175.91	176.25	2150924.0
2020-04-17 12:30:00	MSFT	Stock	176.26	177.29	176.13	177.07	1819947.0

> showing 50 of 94,763 rows — these rows as CSV

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