PREVIEW / stock_30min / 2020-03-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-23.parquet
  size:    1.9 MB
  rows:    97,187
  symbols: 2,459

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-23 04:00:00	AAPL	Stock	56.22	56.22	55.37	55.75	135528.0
2020-03-23 04:30:00	AAPL	Stock	55.75	55.875	55.625	55.6875	46368.0
2020-03-23 05:00:00	AAPL	Stock	55.75	56.095	55.7	55.7	20740.0
2020-03-23 05:30:00	AAPL	Stock	56.0325	56.375	55.9375	56.1	92716.0
2020-03-23 06:00:00	AAPL	Stock	56.0375	56.4375	56.0375	56.225	49728.0
2020-03-23 06:30:00	AAPL	Stock	56.25	56.75	56.25	56.75	47360.0
2020-03-23 07:00:00	AAPL	Stock	56.7425	56.7425	56.05	56.0725	386880.0
2020-03-23 07:30:00	AAPL	Stock	56.0725	56.1	55.625	55.75	350684.0
2020-03-23 08:00:00	AAPL	Stock	56.3738	59.525	55.63	58.275	2637060.0
2020-03-23 08:30:00	AAPL	Stock	58.275	58.875	57.7	58.57	1050832.0
2020-03-23 09:00:00	AAPL	Stock	58.5525	58.875	56.8875	57.0	1497812.0
2020-03-23 09:30:00	AAPL	Stock	57.02	57.125	54.5	56.0375	40978144.0
2020-03-23 10:00:00	AAPL	Stock	56.0488	56.17	55.0	55.4392	21596664.0
2020-03-23 10:30:00	AAPL	Stock	55.44	55.89	54.65	54.7608	15745152.0
2020-03-23 11:00:00	AAPL	Stock	54.78	55.33	53.4125	53.7685	20961000.0
2020-03-23 11:30:00	AAPL	Stock	53.78	54.2475	53.1525	54.1925	19873224.0
2020-03-23 12:00:00	AAPL	Stock	54.175	55.0975	53.77	54.804	17653372.0
2020-03-23 12:30:00	AAPL	Stock	54.824	56.36	54.4725	56.1875	19295256.0
2020-03-23 13:00:00	AAPL	Stock	56.2012	56.775	55.3865	55.4862	15971200.0
2020-03-23 13:30:00	AAPL	Stock	55.4975	56.1615	55.015	55.3175	14045324.0
2020-03-23 14:00:00	AAPL	Stock	55.32	55.432	54.55	55.265	11988200.0
2020-03-23 14:30:00	AAPL	Stock	55.2475	55.5965	54.75	54.9812	10046092.0
2020-03-23 15:00:00	AAPL	Stock	54.99	55.2175	54.255	54.4375	11776860.0
2020-03-23 15:30:00	AAPL	Stock	54.44	56.7	54.3652	55.8575	28287928.0
2020-03-23 16:00:00	AAPL	Stock	56.0925	56.2225	55.6275	55.875	19208868.0
2020-03-23 16:30:00	AAPL	Stock	55.875	56.0925	55.75	55.875	407952.0
2020-03-23 17:00:00	AAPL	Stock	55.975	56.125	55.8425	56.125	75708.0
2020-03-23 17:30:00	AAPL	Stock	56.15	56.4925	56.0975	56.425	143060.0
2020-03-23 18:00:00	AAPL	Stock	56.4275	56.95	56.39	56.915	375504.0
2020-03-23 18:30:00	AAPL	Stock	56.925	56.95	56.665	56.8	202396.0
2020-03-23 19:00:00	AAPL	Stock	56.855	57.45	56.8	57.0625	253436.0
2020-03-23 19:30:00	AAPL	Stock	57.075	57.125	56.7875	57.0	320168.0
2020-03-23 04:00:00	MSFT	Stock	133.49	134.62	133.1	133.8	13417.0
2020-03-23 04:30:00	MSFT	Stock	133.8	134.0	133.5	133.63	5921.0
2020-03-23 05:00:00	MSFT	Stock	133.74	134.5	133.74	133.77	5673.0
2020-03-23 05:30:00	MSFT	Stock	134.49	135.49	134.49	134.8	8255.0
2020-03-23 06:00:00	MSFT	Stock	134.61	135.0	134.35	134.68	6625.0
2020-03-23 06:30:00	MSFT	Stock	134.8	135.87	134.8	135.55	47557.0
2020-03-23 07:00:00	MSFT	Stock	135.5	136.0	135.16	135.2	61196.0
2020-03-23 07:30:00	MSFT	Stock	135.13	135.13	134.02	134.72	50364.0
2020-03-23 08:00:00	MSFT	Stock	135.99	144.0	134.01	140.5	327366.0
2020-03-23 08:30:00	MSFT	Stock	140.51	142.45	138.3	141.24	163192.0
2020-03-23 09:00:00	MSFT	Stock	141.24	142.4	136.85	137.09	221891.0
2020-03-23 09:30:00	MSFT	Stock	137.04	139.0	134.52	138.99	10412362.0
2020-03-23 10:00:00	MSFT	Stock	138.955	140.57	137.18	137.64	5221144.0
2020-03-23 10:30:00	MSFT	Stock	137.72	138.67	135.61	135.695	3320135.0
2020-03-23 11:00:00	MSFT	Stock	135.74	137.03	134.4	134.47	3728301.0
2020-03-23 11:30:00	MSFT	Stock	134.49	135.29	132.52	134.74	4576974.0
2020-03-23 12:00:00	MSFT	Stock	134.71	138.0	134.64	136.736	4314939.0
2020-03-23 12:30:00	MSFT	Stock	136.69	140.0	135.7	139.3	3671545.0

> showing 50 of 97,187 rows — these rows as CSV

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