PREVIEW / stock_30min / 2020-03-10

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-10.parquet
  size:    1.9 MB
  rows:    93,238
  symbols: 2,431

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-10 04:00:00	AAPL	Stock	68.85	69.4075	68.605	69.2475	67280.0
2020-03-10 04:30:00	AAPL	Stock	69.16	69.75	69.1475	69.75	43668.0
2020-03-10 05:00:00	AAPL	Stock	69.755	70.1125	69.6925	70.1125	61988.0
2020-03-10 05:30:00	AAPL	Stock	70.055	70.4775	69.825	70.0125	89208.0
2020-03-10 06:00:00	AAPL	Stock	70.085	70.2	69.85	69.8975	54528.0
2020-03-10 06:30:00	AAPL	Stock	69.895	70.235	69.795	70.1275	53760.0
2020-03-10 07:00:00	AAPL	Stock	70.195	70.2375	69.4475	69.5225	348636.0
2020-03-10 07:30:00	AAPL	Stock	69.4975	69.845	69.4975	69.6025	218388.0
2020-03-10 08:00:00	AAPL	Stock	69.625	70.175	68.8025	68.8025	1148992.0
2020-03-10 08:30:00	AAPL	Stock	68.795	69.365	68.6875	69.2175	559248.0
2020-03-10 09:00:00	AAPL	Stock	69.175	69.6975	69.125	69.315	598452.0
2020-03-10 09:30:00	AAPL	Stock	69.285	70.09	68.73	69.8	29629412.0
2020-03-10 10:00:00	AAPL	Stock	69.7975	70.4575	69.555	69.9	17981296.0
2020-03-10 10:30:00	AAPL	Stock	69.904	70.0595	68.7375	68.7942	17710572.0
2020-03-10 11:00:00	AAPL	Stock	68.7875	69.3525	67.7925	68.055	18233320.0
2020-03-10 11:30:00	AAPL	Stock	68.056	68.5438	67.3425	68.1675	19375276.0
2020-03-10 12:00:00	AAPL	Stock	68.1775	69.5898	68.175	68.72	15828412.0
2020-03-10 12:30:00	AAPL	Stock	68.724	69.3725	68.415	69.0178	11130988.0
2020-03-10 13:00:00	AAPL	Stock	69.0075	69.5725	68.695	69.086	9779488.0
2020-03-10 13:30:00	AAPL	Stock	69.075	69.4175	68.3125	68.5275	8619468.0
2020-03-10 14:00:00	AAPL	Stock	68.5225	68.895	68.0825	68.7785	9433948.0
2020-03-10 14:30:00	AAPL	Stock	68.78	69.79	68.705	69.561	12291212.0
2020-03-10 15:00:00	AAPL	Stock	69.575	70.37	69.4825	69.665	15928464.0
2020-03-10 15:30:00	AAPL	Stock	69.6475	71.61	69.475	71.4225	25888484.0
2020-03-10 16:00:00	AAPL	Stock	71.42	71.42	70.9375	71.0625	16965592.0
2020-03-10 16:30:00	AAPL	Stock	70.975	71.335	70.935	71.0775	646852.0
2020-03-10 17:00:00	AAPL	Stock	71.12	71.1375	70.75	70.7625	148052.0
2020-03-10 17:30:00	AAPL	Stock	70.775	70.8725	70.6675	70.725	115424.0
2020-03-10 18:00:00	AAPL	Stock	70.74	71.335	70.1575	70.375	218672.0
2020-03-10 18:30:00	AAPL	Stock	70.425	70.5375	69.9125	70.09	122700.0
2020-03-10 19:00:00	AAPL	Stock	70.075	70.22	69.95	69.9625	90904.0
2020-03-10 19:30:00	AAPL	Stock	70.0	70.1225	69.525	69.875	132344.0
2020-03-10 04:00:00	MSFT	Stock	156.0	156.98	155.48	156.69	8417.0
2020-03-10 04:30:00	MSFT	Stock	156.65	157.45	156.5	157.45	9471.0
2020-03-10 05:00:00	MSFT	Stock	157.5	158.58	157.43	158.58	4985.0
2020-03-10 05:30:00	MSFT	Stock	158.5	159.56	158.4	159.13	14602.0
2020-03-10 06:00:00	MSFT	Stock	159.43	159.56	158.76	159.24	7251.0
2020-03-10 06:30:00	MSFT	Stock	159.4	159.75	159.0	159.35	31965.0
2020-03-10 07:00:00	MSFT	Stock	159.36	159.56	158.0	158.0	68139.0
2020-03-10 07:30:00	MSFT	Stock	158.19	159.0	158.09	158.6	40822.0
2020-03-10 08:00:00	MSFT	Stock	158.52	159.5	156.76	156.9	122169.0
2020-03-10 08:30:00	MSFT	Stock	156.88	157.9	155.48	157.5	99368.0
2020-03-10 09:00:00	MSFT	Stock	157.2	158.31	157.2	158.12	81403.0
2020-03-10 09:30:00	MSFT	Stock	158.12	158.3	155.38	156.86	6294583.0
2020-03-10 10:00:00	MSFT	Stock	156.84	159.01	156.51	157.87	3426463.0
2020-03-10 10:30:00	MSFT	Stock	157.9	158.22	154.77	154.79	3557260.0
2020-03-10 11:00:00	MSFT	Stock	154.78	156.19	152.92	153.12	3364581.0
2020-03-10 11:30:00	MSFT	Stock	153.2	155.6	152.58	153.94	3539806.0
2020-03-10 12:00:00	MSFT	Stock	153.95	156.94	153.95	155.665	2779186.0
2020-03-10 12:30:00	MSFT	Stock	155.66	156.67	154.75	155.69	2001597.0

> showing 50 of 93,238 rows — these rows as CSV

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