PREVIEW / stock_30min / 2020-04-23

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-23.parquet
  size:    1.8 MB
  rows:    92,396
  symbols: 2,383

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-23 04:00:00	AAPL	Stock	68.565	68.565	68.55	68.55	1200.0
2020-04-23 05:00:00	AAPL	Stock	68.7	68.9225	68.675	68.88	6200.0
2020-04-23 05:30:00	AAPL	Stock	68.9225	68.99	68.9225	68.99	2140.0
2020-04-23 06:00:00	AAPL	Stock	68.95	68.95	68.5	68.5	4692.0
2020-04-23 06:30:00	AAPL	Stock	68.575	68.69	68.5025	68.685	4988.0
2020-04-23 07:00:00	AAPL	Stock	68.7475	68.8775	68.5825	68.8625	67480.0
2020-04-23 07:30:00	AAPL	Stock	68.855	68.8775	68.725	68.8275	52380.0
2020-04-23 08:00:00	AAPL	Stock	68.8127	68.8775	68.5825	68.8775	131688.0
2020-04-23 08:30:00	AAPL	Stock	68.8775	69.1225	68.8125	69.005	321468.0
2020-04-23 09:00:00	AAPL	Stock	69.0725	69.2	68.94	68.9625	237708.0
2020-04-23 09:30:00	AAPL	Stock	68.98	69.7525	68.7925	69.64	12722220.0
2020-04-23 10:00:00	AAPL	Stock	69.6325	70.22	69.6325	70.145	9309928.0
2020-04-23 10:30:00	AAPL	Stock	70.1475	70.4375	70.145	70.18	7581764.0
2020-04-23 11:00:00	AAPL	Stock	70.1925	70.1975	69.935	70.13	5231716.0
2020-04-23 11:30:00	AAPL	Stock	70.1325	70.1462	69.7825	69.92	4389796.0
2020-04-23 12:00:00	AAPL	Stock	69.9212	70.085	69.8325	70.0588	3898496.0
2020-04-23 12:30:00	AAPL	Stock	70.06	70.0795	68.99	69.624	9505020.0
2020-04-23 13:00:00	AAPL	Stock	69.625	69.89	69.2225	69.3625	5598304.0
2020-04-23 13:30:00	AAPL	Stock	69.3575	69.5575	68.895	69.14	5790964.0
2020-04-23 14:00:00	AAPL	Stock	69.13	69.3273	68.775	69.225	5620688.0
2020-04-23 14:30:00	AAPL	Stock	69.23	69.5225	69.183	69.44	5021488.0
2020-04-23 15:00:00	AAPL	Stock	69.45	69.4825	68.8475	69.0773	5945204.0
2020-04-23 15:30:00	AAPL	Stock	69.07	69.1975	68.7175	68.7175	9249076.0
2020-04-23 16:00:00	AAPL	Stock	68.7425	68.8625	68.475	68.505	10610052.0
2020-04-23 16:30:00	AAPL	Stock	68.54	68.8625	68.475	68.6325	39984.0
2020-04-23 17:00:00	AAPL	Stock	68.6275	68.6275	68.5025	68.5025	28496.0
2020-04-23 17:30:00	AAPL	Stock	68.52	68.585	68.5	68.5625	19788.0
2020-04-23 18:00:00	AAPL	Stock	68.555	68.7225	68.445	68.5675	85272.0
2020-04-23 18:30:00	AAPL	Stock	68.515	68.515	68.2825	68.325	67824.0
2020-04-23 19:00:00	AAPL	Stock	68.3675	68.375	68.2875	68.335	39488.0
2020-04-23 19:30:00	AAPL	Stock	68.29	68.37	68.275	68.275	80992.0
2020-04-23 04:00:00	MSFT	Stock	172.62	172.62	172.62	172.62	300.0
2020-04-23 05:00:00	MSFT	Stock	172.9	172.9	172.9	172.9	100.0
2020-04-23 06:00:00	MSFT	Stock	173.7	173.7	173.4	173.4	608.0
2020-04-23 06:30:00	MSFT	Stock	173.56	173.63	173.35	173.48	2971.0
2020-04-23 07:00:00	MSFT	Stock	173.39	173.5	173.02	173.21	24985.0
2020-04-23 07:30:00	MSFT	Stock	173.2	173.38	173.0	173.3	6212.0
2020-04-23 08:00:00	MSFT	Stock	173.03	173.95	172.81	173.25	16572.0
2020-04-23 08:30:00	MSFT	Stock	173.35	174.5	173.1	174.48	51932.0
2020-04-23 09:00:00	MSFT	Stock	174.5	174.7	174.05	174.26	72384.0
2020-04-23 09:30:00	MSFT	Stock	174.26	175.06	173.55	174.35	3157512.0
2020-04-23 10:00:00	MSFT	Stock	174.32	174.549	173.61	174.32	2197447.0
2020-04-23 10:30:00	MSFT	Stock	174.34	175.04	174.3	174.62	1730264.0
2020-04-23 11:00:00	MSFT	Stock	174.63	174.67	173.8	174.295	1553732.0
2020-04-23 11:30:00	MSFT	Stock	174.3	174.34	173.3	173.575	1617765.0
2020-04-23 12:00:00	MSFT	Stock	173.57	174.194	173.335	174.17	1013263.0
2020-04-23 12:30:00	MSFT	Stock	174.19	174.22	170.91	172.918	2605278.0
2020-04-23 13:00:00	MSFT	Stock	172.91	173.59	171.92	172.28	1510835.0
2020-04-23 13:30:00	MSFT	Stock	172.29	172.74	171.42	171.87	1555866.0
2020-04-23 14:00:00	MSFT	Stock	171.86	172.57	171.12	172.49	1706952.0

> showing 50 of 92,396 rows — these rows as CSV

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