PREVIEW / stock_30min / 2020-04-15

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-15.parquet
  size:    1.8 MB
  rows:    93,330
  symbols: 2,368

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-15 04:00:00	AAPL	Stock	70.955	71.175	70.955	71.1725	70752.0
2020-04-15 04:30:00	AAPL	Stock	71.1425	71.1425	70.7475	70.8	36756.0
2020-04-15 05:00:00	AAPL	Stock	70.8375	70.8375	70.6275	70.775	66056.0
2020-04-15 05:30:00	AAPL	Stock	70.825	70.855	70.7525	70.7525	8644.0
2020-04-15 06:00:00	AAPL	Stock	70.7675	70.95	70.6925	70.75	29544.0
2020-04-15 06:30:00	AAPL	Stock	70.7075	70.875	70.705	70.8125	44968.0
2020-04-15 07:00:00	AAPL	Stock	70.81	71.2325	70.7975	71.2325	133844.0
2020-04-15 07:30:00	AAPL	Stock	71.2325	71.275	71.075	71.075	179392.0
2020-04-15 08:00:00	AAPL	Stock	70.875	71.9375	69.9	70.5	787908.0
2020-04-15 08:30:00	AAPL	Stock	70.45	70.5025	70.09	70.3515	721020.0
2020-04-15 09:00:00	AAPL	Stock	70.3625	70.61	70.143	70.61	574352.0
2020-04-15 09:30:00	AAPL	Stock	70.6	70.795	70.1575	70.605	15938164.0
2020-04-15 10:00:00	AAPL	Stock	70.6	70.6712	70.25	70.376	7635424.0
2020-04-15 10:30:00	AAPL	Stock	70.375	71.1875	70.325	71.105	9186720.0
2020-04-15 11:00:00	AAPL	Stock	71.1	71.25	70.75	70.8425	8444980.0
2020-04-15 11:30:00	AAPL	Stock	70.835	70.9975	70.64	70.7402	4567888.0
2020-04-15 12:00:00	AAPL	Stock	70.741	70.9075	70.5108	70.7825	4642328.0
2020-04-15 12:30:00	AAPL	Stock	70.7775	71.16	70.7575	71.045	5089376.0
2020-04-15 13:00:00	AAPL	Stock	71.04	71.4	70.9625	71.125	5309924.0
2020-04-15 13:30:00	AAPL	Stock	71.1265	71.2375	70.9872	71.0162	3748296.0
2020-04-15 14:00:00	AAPL	Stock	71.0125	71.3825	71.0095	71.3575	4316600.0
2020-04-15 14:30:00	AAPL	Stock	71.37	71.52	71.1875	71.52	4943816.0
2020-04-15 15:00:00	AAPL	Stock	71.5125	71.5825	71.1225	71.21	6657944.0
2020-04-15 15:30:00	AAPL	Stock	71.1945	71.2725	70.9825	71.1125	10519768.0
2020-04-15 16:00:00	AAPL	Stock	71.1075	71.2	71.0155	71.2	14387972.0
2020-04-15 16:30:00	AAPL	Stock	71.225	71.225	71.0375	71.1125	81004.0
2020-04-15 17:00:00	AAPL	Stock	71.1275	71.13	71.03	71.03	51824.0
2020-04-15 17:30:00	AAPL	Stock	71.0525	71.085	71.025	71.0375	17852.0
2020-04-15 18:00:00	AAPL	Stock	71.085	71.15	70.875	70.9375	65052.0
2020-04-15 18:30:00	AAPL	Stock	70.9375	70.9375	70.655	70.655	35080.0
2020-04-15 19:00:00	AAPL	Stock	70.65	70.6525	70.5	70.575	26484.0
2020-04-15 19:30:00	AAPL	Stock	70.65	70.8	70.62	70.75	45368.0
2020-04-15 04:00:00	MSFT	Stock	172.02	172.4	171.65	172.2	7353.0
2020-04-15 04:30:00	MSFT	Stock	172.26	172.26	171.7	171.89	10512.0
2020-04-15 05:00:00	MSFT	Stock	171.9	171.9	171.4	171.61	9452.0
2020-04-15 05:30:00	MSFT	Stock	171.56	171.7	171.47	171.7	1010.0
2020-04-15 06:00:00	MSFT	Stock	171.78	171.87	171.62	171.62	4188.0
2020-04-15 06:30:00	MSFT	Stock	171.7	172.08	171.5	172.08	3506.0
2020-04-15 07:00:00	MSFT	Stock	171.65	172.41	171.63	172.4	24251.0
2020-04-15 07:30:00	MSFT	Stock	172.45	172.79	172.2	172.3	26506.0
2020-04-15 08:00:00	MSFT	Stock	172.0	174.1	170.86	170.96	242001.0
2020-04-15 08:30:00	MSFT	Stock	171.0	171.1	170.25	170.35	79204.0
2020-04-15 09:00:00	MSFT	Stock	170.39	171.09	170.05	170.89	154386.0
2020-04-15 09:30:00	MSFT	Stock	170.89	171.55	169.24	170.452	5063599.0
2020-04-15 10:00:00	MSFT	Stock	170.43	171.2	170.02	170.855	3165427.0
2020-04-15 10:30:00	MSFT	Stock	170.84	173.48	170.69	173.095	3655447.0
2020-04-15 11:00:00	MSFT	Stock	173.08	173.4	171.95	172.63	1884367.0
2020-04-15 11:30:00	MSFT	Stock	172.659	172.9	171.53	171.64	1410084.0
2020-04-15 12:00:00	MSFT	Stock	171.64	172.46	171.42	172.37	1470165.0
2020-04-15 12:30:00	MSFT	Stock	172.371	172.92	172.095	172.53	1345174.0

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

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