PREVIEW / stock_30min / 2020-03-16

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-16.parquet
  size:    1.9 MB
  rows:    98,350
  symbols: 2,457

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-03-16 04:00:00	AAPL	Stock	63.17	64.075	62.4975	62.4975	189316.0
2020-03-16 04:30:00	AAPL	Stock	62.375	62.4425	61.5275	61.55	107056.0
2020-03-16 05:00:00	AAPL	Stock	61.7025	61.9975	61.415	61.89	141420.0
2020-03-16 05:30:00	AAPL	Stock	61.925	62.25	61.805	62.025	58488.0
2020-03-16 06:00:00	AAPL	Stock	61.93	62.15	61.5	61.5625	146160.0
2020-03-16 06:30:00	AAPL	Stock	61.5	61.7425	61.1025	61.2575	181596.0
2020-03-16 07:00:00	AAPL	Stock	61.275	62.075	61.1925	61.375	629960.0
2020-03-16 07:30:00	AAPL	Stock	61.3775	61.855	60.8175	60.89	646088.0
2020-03-16 08:00:00	AAPL	Stock	61.25	61.9575	60.0625	60.0625	1686564.0
2020-03-16 08:30:00	AAPL	Stock	60.06	60.455	59.63	60.1075	1096516.0
2020-03-16 09:00:00	AAPL	Stock	60.085	60.875	59.89	60.4125	1013984.0
2020-03-16 09:30:00	AAPL	Stock	60.4675	63.37	60.0	62.4312	34538592.0
2020-03-16 10:00:00	AAPL	Stock	62.43	63.25	62.0322	62.3425	24399292.0
2020-03-16 10:30:00	AAPL	Stock	62.3375	64.31	62.3275	63.61	23049532.0
2020-03-16 11:00:00	AAPL	Stock	63.59	64.72	63.39	64.615	17595868.0
2020-03-16 11:30:00	AAPL	Stock	64.6075	64.77	63.875	64.5775	13703112.0
2020-03-16 12:00:00	AAPL	Stock	64.575	64.6025	63.4375	63.7225	10416876.0
2020-03-16 12:30:00	AAPL	Stock	63.725	64.175	63.1675	63.3762	8959612.0
2020-03-16 13:00:00	AAPL	Stock	63.3812	63.995	63.27	63.5775	8273732.0
2020-03-16 13:30:00	AAPL	Stock	63.575	63.5775	62.6662	62.7678	10650916.0
2020-03-16 14:00:00	AAPL	Stock	62.7575	62.7875	62.3975	62.741	14366224.0
2020-03-16 14:30:00	AAPL	Stock	62.7425	63.75	62.5025	63.225	16060572.0
2020-03-16 15:00:00	AAPL	Stock	63.2025	63.81	62.5612	62.6	14152672.0
2020-03-16 15:30:00	AAPL	Stock	62.58	63.085	60.0	60.3675	38762192.0
2020-03-16 16:00:00	AAPL	Stock	60.5525	61.4825	60.1625	61.2725	17899404.0
2020-03-16 16:30:00	AAPL	Stock	61.35	61.775	61.0325	61.415	678744.0
2020-03-16 17:00:00	AAPL	Stock	61.4025	61.4025	60.8775	60.88	327876.0
2020-03-16 17:30:00	AAPL	Stock	60.88	61.35	60.8325	61.35	192460.0
2020-03-16 18:00:00	AAPL	Stock	61.325	61.775	60.9025	61.25	2009212.0
2020-03-16 18:30:00	AAPL	Stock	61.3125	61.975	61.3125	61.825	140848.0
2020-03-16 19:00:00	AAPL	Stock	61.8025	62.4875	61.8	62.3625	209800.0
2020-03-16 19:30:00	AAPL	Stock	62.375	62.5	62.25	62.5	196104.0
2020-03-16 04:00:00	MSFT	Stock	147.93	147.93	141.6	141.6	29264.0
2020-03-16 04:30:00	MSFT	Stock	141.5	141.6	140.1	140.8	22942.0
2020-03-16 05:00:00	MSFT	Stock	140.66	141.99	139.9	141.68	26972.0
2020-03-16 05:30:00	MSFT	Stock	141.75	142.88	141.44	142.0	14915.0
2020-03-16 06:00:00	MSFT	Stock	141.97	142.0	140.6	140.6	10892.0
2020-03-16 06:30:00	MSFT	Stock	140.66	141.22	140.6	140.85	9675.0
2020-03-16 07:00:00	MSFT	Stock	140.72	142.6	140.7	141.2	73583.0
2020-03-16 07:30:00	MSFT	Stock	141.21	141.7	140.42	140.99	102726.0
2020-03-16 08:00:00	MSFT	Stock	141.0	142.5	139.7	140.21	254246.0
2020-03-16 08:30:00	MSFT	Stock	140.45	140.64	138.75	140.3	176089.0
2020-03-16 09:00:00	MSFT	Stock	140.3	140.8	139.73	139.9	285486.0
2020-03-16 09:30:00	MSFT	Stock	140.0	144.2	137.49	142.528	8193491.0
2020-03-16 10:00:00	MSFT	Stock	142.51	144.99	141.25	143.699	6068413.0
2020-03-16 10:30:00	MSFT	Stock	143.69	147.77	143.584	145.64	5193357.0
2020-03-16 11:00:00	MSFT	Stock	145.53	149.35	145.43	147.95	4670344.0
2020-03-16 11:30:00	MSFT	Stock	147.98	148.34	145.0	146.07	3447291.0
2020-03-16 12:00:00	MSFT	Stock	146.05	146.62	143.52	144.27	3318741.0
2020-03-16 12:30:00	MSFT	Stock	144.28	145.97	142.455	142.51	2519711.0

> showing 50 of 98,350 rows — these rows as CSV

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