PREVIEW / stock_30min / 2020-03-19

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-19.parquet
  size:    1.9 MB
  rows:    95,229
  symbols: 2,446

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-19 04:00:00	AAPL	Stock	61.4975	62.25	61.15	62.25	45760.0
2020-03-19 04:30:00	AAPL	Stock	62.375	62.75	62.05	62.5	33384.0
2020-03-19 05:00:00	AAPL	Stock	62.495	62.5725	62.0375	62.0375	8844.0
2020-03-19 05:30:00	AAPL	Stock	61.81	61.975	61.5875	61.5875	8332.0
2020-03-19 06:00:00	AAPL	Stock	61.3925	61.4075	61.035	61.275	19284.0
2020-03-19 06:30:00	AAPL	Stock	61.42	61.5825	61.2475	61.26	38520.0
2020-03-19 07:00:00	AAPL	Stock	61.4325	61.915	61.41	61.515	184624.0
2020-03-19 07:30:00	AAPL	Stock	61.4975	61.4975	60.7625	60.9025	142100.0
2020-03-19 08:00:00	AAPL	Stock	61.41	61.745	60.375	60.5	407836.0
2020-03-19 08:30:00	AAPL	Stock	60.5	61.5	60.4625	61.3785	385588.0
2020-03-19 09:00:00	AAPL	Stock	61.4475	61.9475	61.349	61.835	903140.0
2020-03-19 09:30:00	AAPL	Stock	61.855	62.605	60.6525	62.5412	28322560.0
2020-03-19 10:00:00	AAPL	Stock	62.5375	63.21	62.0	62.1975	22769452.0
2020-03-19 10:30:00	AAPL	Stock	62.1975	62.44	60.7425	61.1625	19066064.0
2020-03-19 11:00:00	AAPL	Stock	61.1875	62.5	61.14	62.42	15008832.0
2020-03-19 11:30:00	AAPL	Stock	62.4225	62.8125	61.7275	61.79	15793904.0
2020-03-19 12:00:00	AAPL	Stock	61.78	62.1775	61.31	61.7692	12068916.0
2020-03-19 12:30:00	AAPL	Stock	61.7715	62.305	61.3	61.8938	12699420.0
2020-03-19 13:00:00	AAPL	Stock	61.9025	62.4312	61.765	61.9812	9467816.0
2020-03-19 13:30:00	AAPL	Stock	61.9775	62.658	61.8025	62.3375	9802440.0
2020-03-19 14:00:00	AAPL	Stock	62.3525	62.5825	62.02	62.4375	9233104.0
2020-03-19 14:30:00	AAPL	Stock	62.4375	62.955	62.3	62.4025	12681276.0
2020-03-19 15:00:00	AAPL	Stock	62.3875	62.5275	61.665	62.1625	13807872.0
2020-03-19 15:30:00	AAPL	Stock	62.165	62.5075	60.9175	61.195	21057632.0
2020-03-19 16:00:00	AAPL	Stock	61.1925	61.2775	60.8775	61.2425	22459076.0
2020-03-19 16:30:00	AAPL	Stock	61.2425	61.255	60.8775	61.1	484684.0
2020-03-19 17:00:00	AAPL	Stock	61.1	61.2475	61.025	61.2	141720.0
2020-03-19 17:30:00	AAPL	Stock	61.175	61.2175	61.025	61.15	87248.0
2020-03-19 18:00:00	AAPL	Stock	61.15	61.37	61.035	61.2025	215524.0
2020-03-19 18:30:00	AAPL	Stock	61.1375	61.195	61.0	61.0625	148280.0
2020-03-19 19:00:00	AAPL	Stock	61.125	61.1875	60.88	60.9425	115624.0
2020-03-19 19:30:00	AAPL	Stock	61.0025	61.0125	60.8075	60.8125	100688.0
2020-03-19 04:00:00	MSFT	Stock	140.08	142.55	139.0	142.4	11460.0
2020-03-19 04:30:00	MSFT	Stock	143.0	143.4	142.5	143.4	3054.0
2020-03-19 05:00:00	MSFT	Stock	143.4	143.4	142.0	142.0	11293.0
2020-03-19 05:30:00	MSFT	Stock	141.8	142.92	141.5	141.62	7480.0
2020-03-19 06:00:00	MSFT	Stock	141.3	141.3	140.0	140.77	13704.0
2020-03-19 06:30:00	MSFT	Stock	140.75	141.05	140.13	140.5	10981.0
2020-03-19 07:00:00	MSFT	Stock	140.64	141.74	140.12	140.75	42793.0
2020-03-19 07:30:00	MSFT	Stock	140.56	140.68	139.07	139.16	71376.0
2020-03-19 08:00:00	MSFT	Stock	141.49	141.75	138.3	138.33	109399.0
2020-03-19 08:30:00	MSFT	Stock	138.4	140.644	138.4	140.0	83220.0
2020-03-19 09:00:00	MSFT	Stock	140.45	142.68	140.0	142.68	263324.0
2020-03-19 09:30:00	MSFT	Stock	142.68	144.8	139.0	144.735	8306369.0
2020-03-19 10:00:00	MSFT	Stock	144.717	148.5	143.33	145.8	7199956.0
2020-03-19 10:30:00	MSFT	Stock	145.839	146.963	141.16	143.05	5339987.0
2020-03-19 11:00:00	MSFT	Stock	143.01	146.48	142.22	145.863	4632552.0
2020-03-19 11:30:00	MSFT	Stock	145.89	147.42	145.07	145.645	4103540.0
2020-03-19 12:00:00	MSFT	Stock	145.61	146.47	143.92	145.67	3045657.0
2020-03-19 12:30:00	MSFT	Stock	145.76	148.0	144.57	146.908	3294923.0

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

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