PREVIEW / stock_30min / 2020-04-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-09.parquet
  size:    1.9 MB
  rows:    95,566
  symbols: 2,416

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-09 04:00:00	AAPL	Stock	67.1375	67.225	66.6275	66.6275	20736.0
2020-04-09 04:30:00	AAPL	Stock	66.715	66.75	66.6	66.6	23072.0
2020-04-09 05:00:00	AAPL	Stock	66.625	66.625	66.1	66.25	12964.0
2020-04-09 05:30:00	AAPL	Stock	66.4	66.4	66.11	66.1375	4056.0
2020-04-09 06:00:00	AAPL	Stock	66.2225	66.2875	66.0	66.1125	21268.0
2020-04-09 06:30:00	AAPL	Stock	66.1125	66.1125	66.0	66.075	9800.0
2020-04-09 07:00:00	AAPL	Stock	66.105	66.42	66.0025	66.005	89312.0
2020-04-09 07:30:00	AAPL	Stock	66.0025	66.1125	65.85	66.0175	122444.0
2020-04-09 08:00:00	AAPL	Stock	66.1745	66.4452	65.5888	66.0	274968.0
2020-04-09 08:30:00	AAPL	Stock	66.0	67.3225	65.915	67.125	885624.0
2020-04-09 09:00:00	AAPL	Stock	67.1	67.575	67.0	67.25	1051852.0
2020-04-09 09:30:00	AAPL	Stock	67.3	67.5175	66.865	67.4405	19262200.0
2020-04-09 10:00:00	AAPL	Stock	67.4425	67.4602	66.2	66.5938	15835940.0
2020-04-09 10:30:00	AAPL	Stock	66.6025	66.85	66.366	66.595	11273428.0
2020-04-09 11:00:00	AAPL	Stock	66.6	66.615	66.175	66.5068	7842740.0
2020-04-09 11:30:00	AAPL	Stock	66.5	66.9375	66.38	66.7925	8264040.0
2020-04-09 12:00:00	AAPL	Stock	66.7925	66.9175	66.5378	66.5378	5237108.0
2020-04-09 12:30:00	AAPL	Stock	66.535	66.8675	66.425	66.78	5570216.0
2020-04-09 13:00:00	AAPL	Stock	66.785	66.865	66.6742	66.83	4456308.0
2020-04-09 13:30:00	AAPL	Stock	66.8375	66.95	66.555	66.7475	5575132.0
2020-04-09 14:00:00	AAPL	Stock	66.75	66.8175	66.4675	66.675	6165704.0
2020-04-09 14:30:00	AAPL	Stock	66.66	66.915	66.3225	66.5675	8063260.0
2020-04-09 15:00:00	AAPL	Stock	66.57	66.992	66.425	66.985	9150904.0
2020-04-09 15:30:00	AAPL	Stock	66.9825	67.22	66.6025	66.99	15908688.0
2020-04-09 16:00:00	AAPL	Stock	66.9975	67.1125	66.7392	67.05	9417568.0
2020-04-09 16:30:00	AAPL	Stock	67.0625	67.125	67.0475	67.125	114228.0
2020-04-09 17:00:00	AAPL	Stock	67.15	67.2025	67.1075	67.1725	62392.0
2020-04-09 17:30:00	AAPL	Stock	67.1875	67.205	67.15	67.175	29844.0
2020-04-09 18:00:00	AAPL	Stock	67.175	67.3125	67.175	67.3125	53728.0
2020-04-09 18:30:00	AAPL	Stock	67.305	67.3675	67.25	67.35	61460.0
2020-04-09 19:00:00	AAPL	Stock	67.35	67.3775	67.3125	67.3775	28628.0
2020-04-09 19:30:00	AAPL	Stock	67.3775	67.3925	67.265	67.2875	97124.0
2020-04-09 04:00:00	MSFT	Stock	166.43	166.84	165.25	165.6	12261.0
2020-04-09 04:30:00	MSFT	Stock	165.55	165.9	164.6	165.65	8781.0
2020-04-09 05:00:00	MSFT	Stock	165.65	165.65	164.1	164.5	3065.0
2020-04-09 05:30:00	MSFT	Stock	165.04	165.2	164.21	164.21	2641.0
2020-04-09 06:00:00	MSFT	Stock	164.44	164.6	164.1	164.1	5800.0
2020-04-09 06:30:00	MSFT	Stock	164.64	164.68	164.04	164.04	1717.0
2020-04-09 07:00:00	MSFT	Stock	164.4	165.3	163.85	163.85	30021.0
2020-04-09 07:30:00	MSFT	Stock	163.97	164.25	163.75	164.0	21232.0
2020-04-09 08:00:00	MSFT	Stock	165.298	165.347	163.01	163.8	61924.0
2020-04-09 08:30:00	MSFT	Stock	163.9	166.97	163.84	166.62	204292.0
2020-04-09 09:00:00	MSFT	Stock	166.5	167.4	166.01	166.41	251990.0
2020-04-09 09:30:00	MSFT	Stock	166.36	167.37	164.88	166.5	5998129.0
2020-04-09 10:00:00	MSFT	Stock	166.48	166.52	163.33	164.38	5461613.0
2020-04-09 10:30:00	MSFT	Stock	164.4	165.43	163.63	165.148	4205281.0
2020-04-09 11:00:00	MSFT	Stock	165.16	165.22	163.8	165.018	2511429.0
2020-04-09 11:30:00	MSFT	Stock	165.02	165.65	164.61	164.915	1937337.0
2020-04-09 12:00:00	MSFT	Stock	164.92	165.4	164.55	164.59	1664198.0
2020-04-09 12:30:00	MSFT	Stock	164.59	165.455	164.33	165.225	1606827.0

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

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