PREVIEW / stock_30min / 2020-03-02

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-02.parquet
  size:    1.9 MB
  rows:    93,550
  symbols: 2,447

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-02 04:00:00	AAPL	Stock	70.75	71.21	70.16	70.75	365208.0
2020-03-02 04:30:00	AAPL	Stock	70.7875	70.7875	69.75	70.0	152656.0
2020-03-02 05:00:00	AAPL	Stock	70.1	70.25	69.8875	70.1575	97696.0
2020-03-02 05:30:00	AAPL	Stock	70.1925	70.3525	69.81	69.81	158448.0
2020-03-02 06:00:00	AAPL	Stock	69.7675	69.7675	69.0275	69.0825	104120.0
2020-03-02 06:30:00	AAPL	Stock	69.0825	69.1475	68.25	68.4325	108624.0
2020-03-02 07:00:00	AAPL	Stock	68.425	69.3125	68.16	69.2875	558572.0
2020-03-02 07:30:00	AAPL	Stock	69.2975	69.6025	69.075	69.5375	409972.0
2020-03-02 08:00:00	AAPL	Stock	68.875	69.6275	68.625	69.0625	1513176.0
2020-03-02 08:30:00	AAPL	Stock	69.0625	69.8125	69.01	69.75	653628.0
2020-03-02 09:00:00	AAPL	Stock	69.8125	70.675	69.75	70.5725	1145236.0
2020-03-02 09:30:00	AAPL	Stock	70.57	71.0575	69.43	70.41	39484088.0
2020-03-02 10:00:00	AAPL	Stock	70.39	70.595	69.9475	70.3232	19641280.0
2020-03-02 10:30:00	AAPL	Stock	70.3262	71.6025	69.985	71.2718	21324012.0
2020-03-02 11:00:00	AAPL	Stock	71.26	72.5375	71.2325	72.4062	28086220.0
2020-03-02 11:30:00	AAPL	Stock	72.415	73.225	72.285	73.1775	21708796.0
2020-03-02 12:00:00	AAPL	Stock	73.1825	73.3875	72.2625	72.4925	21332840.0
2020-03-02 12:30:00	AAPL	Stock	72.4938	73.1875	72.3575	73.0075	14354484.0
2020-03-02 13:00:00	AAPL	Stock	73.0075	73.07	71.95	72.1075	11285640.0
2020-03-02 13:30:00	AAPL	Stock	72.1125	72.7775	71.875	72.6575	10854992.0
2020-03-02 14:00:00	AAPL	Stock	72.6512	72.9825	72.51	72.575	10435780.0
2020-03-02 14:30:00	AAPL	Stock	72.565	72.6912	71.716	72.085	12844192.0
2020-03-02 15:00:00	AAPL	Stock	72.081	73.0675	72.015	72.9072	13873328.0
2020-03-02 15:30:00	AAPL	Stock	72.9275	75.36	72.769	74.705	30805440.0
2020-03-02 16:00:00	AAPL	Stock	74.705	74.72	74.135	74.325	17207224.0
2020-03-02 16:30:00	AAPL	Stock	74.3375	74.7025	74.285	74.4125	253632.0
2020-03-02 17:00:00	AAPL	Stock	74.3625	74.4875	74.3	74.3125	147748.0
2020-03-02 17:30:00	AAPL	Stock	74.3	74.7025	74.2425	74.3875	171704.0
2020-03-02 18:00:00	AAPL	Stock	74.3625	74.47	74.2725	74.3725	141624.0
2020-03-02 18:30:00	AAPL	Stock	74.375	74.575	74.2125	74.495	142644.0
2020-03-02 19:00:00	AAPL	Stock	74.5	74.8	74.39	74.6	232536.0
2020-03-02 19:30:00	AAPL	Stock	74.62	74.775	74.505	74.7475	131844.0
2020-03-02 04:00:00	MSFT	Stock	166.15	166.43	164.5	165.37	66462.0
2020-03-02 04:30:00	MSFT	Stock	165.51	165.83	163.83	164.2	29551.0
2020-03-02 05:00:00	MSFT	Stock	163.8	163.89	163.23	163.89	7195.0
2020-03-02 05:30:00	MSFT	Stock	164.0	164.46	163.38	163.54	20342.0
2020-03-02 06:00:00	MSFT	Stock	163.36	163.36	162.0	162.0	12747.0
2020-03-02 06:30:00	MSFT	Stock	161.85	162.48	159.91	161.25	24043.0
2020-03-02 07:00:00	MSFT	Stock	160.9	162.08	160.0	161.25	60416.0
2020-03-02 07:30:00	MSFT	Stock	161.55	162.4	161.01	162.2	64639.0
2020-03-02 08:00:00	MSFT	Stock	161.3	162.65	160.5	161.5	173566.0
2020-03-02 08:30:00	MSFT	Stock	161.25	163.6	161.25	163.6	103339.0
2020-03-02 09:00:00	MSFT	Stock	163.52	165.25	163.37	165.0	237149.0
2020-03-02 09:30:00	MSFT	Stock	164.85	166.57	163.73	165.23	9007172.0
2020-03-02 10:00:00	MSFT	Stock	165.23	165.65	162.31	163.39	4169719.0
2020-03-02 10:30:00	MSFT	Stock	163.41	165.9	162.58	164.78	3769966.0
2020-03-02 11:00:00	MSFT	Stock	164.78	167.12	164.4	166.935	3979675.0
2020-03-02 11:30:00	MSFT	Stock	166.97	168.53	166.35	168.51	4274241.0
2020-03-02 12:00:00	MSFT	Stock	168.51	168.67	166.84	167.776	2911085.0
2020-03-02 12:30:00	MSFT	Stock	167.75	168.8	167.67	168.65	2226638.0

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

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