PREVIEW / stock_30min / 2020-02-26

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-02-26.parquet
  size:    1.9 MB
  rows:    91,253
  symbols: 2,442

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-02-26 04:00:00	AAPL	Stock	71.325	71.325	70.36	70.935	188624.0
2020-02-26 04:30:00	AAPL	Stock	71.1875	71.315	70.88	71.0	62352.0
2020-02-26 05:00:00	AAPL	Stock	71.075	71.8625	71.0225	71.7	65220.0
2020-02-26 05:30:00	AAPL	Stock	71.7	71.75	71.25	71.5	45436.0
2020-02-26 06:00:00	AAPL	Stock	71.375	72.1925	71.375	72.075	59032.0
2020-02-26 06:30:00	AAPL	Stock	72.1	72.445	71.8775	71.8775	58760.0
2020-02-26 07:00:00	AAPL	Stock	71.9025	72.175	71.515	71.625	246492.0
2020-02-26 07:30:00	AAPL	Stock	71.655	71.9375	71.4	71.9	169204.0
2020-02-26 08:00:00	AAPL	Stock	71.8875	72.175	71.4	71.98	398428.0
2020-02-26 08:30:00	AAPL	Stock	71.98	72.525	71.9775	72.1125	524560.0
2020-02-26 09:00:00	AAPL	Stock	72.15	72.5	71.3375	71.6675	1111980.0
2020-02-26 09:30:00	AAPL	Stock	71.665	73.36	71.625	73.035	29016728.0
2020-02-26 10:00:00	AAPL	Stock	73.0225	73.945	72.6535	73.703	14902816.0
2020-02-26 10:30:00	AAPL	Stock	73.709	74.4275	73.68	74.09	15140936.0
2020-02-26 11:00:00	AAPL	Stock	74.08	74.47	73.805	74.3875	9690024.0
2020-02-26 11:30:00	AAPL	Stock	74.38	74.3825	73.5825	73.6512	9396264.0
2020-02-26 12:00:00	AAPL	Stock	73.6525	73.735	72.5775	73.2055	12563672.0
2020-02-26 12:30:00	AAPL	Stock	73.22	73.64	73.22	73.4257	7975156.0
2020-02-26 13:00:00	AAPL	Stock	73.4325	73.7075	73.2725	73.555	6396956.0
2020-02-26 13:30:00	AAPL	Stock	73.5475	73.5675	72.305	72.695	12240652.0
2020-02-26 14:00:00	AAPL	Stock	72.675	73.305	72.555	73.02	7811928.0
2020-02-26 14:30:00	AAPL	Stock	73.0225	73.2315	72.7775	72.8575	6601524.0
2020-02-26 15:00:00	AAPL	Stock	72.8632	73.535	72.8632	73.21	7841392.0
2020-02-26 15:30:00	AAPL	Stock	73.2075	73.345	73.025	73.1725	10624540.0
2020-02-26 16:00:00	AAPL	Stock	73.1625	74.395	72.895	73.1625	11039468.0
2020-02-26 16:30:00	AAPL	Stock	73.05	73.1625	72.725	72.73	249424.0
2020-02-26 17:00:00	AAPL	Stock	72.745	72.8225	72.625	72.695	90000.0
2020-02-26 17:30:00	AAPL	Stock	72.715	72.75	72.625	72.65	38856.0
2020-02-26 18:00:00	AAPL	Stock	72.625	72.9725	72.55	72.8225	159860.0
2020-02-26 18:30:00	AAPL	Stock	72.8125	73.0	72.3875	72.625	188892.0
2020-02-26 19:00:00	AAPL	Stock	72.565	72.75	72.0175	72.725	122856.0
2020-02-26 19:30:00	AAPL	Stock	72.6875	72.825	72.5	72.575	138748.0
2020-02-26 04:00:00	MSFT	Stock	166.0	166.0	163.31	165.2	41238.0
2020-02-26 04:30:00	MSFT	Stock	165.5	166.7	165.13	166.08	18621.0
2020-02-26 05:00:00	MSFT	Stock	165.87	168.3	165.5	167.02	23919.0
2020-02-26 05:30:00	MSFT	Stock	167.39	167.48	165.9	166.53	21364.0
2020-02-26 06:00:00	MSFT	Stock	166.14	168.9	166.14	168.59	42838.0
2020-02-26 06:30:00	MSFT	Stock	168.63	169.2	168.35	168.5	12075.0
2020-02-26 07:00:00	MSFT	Stock	168.21	168.64	167.42	167.87	52225.0
2020-02-26 07:30:00	MSFT	Stock	167.79	168.02	166.68	168.02	63404.0
2020-02-26 08:00:00	MSFT	Stock	167.751	168.88	167.0	168.7	80234.0
2020-02-26 08:30:00	MSFT	Stock	168.5	169.84	168.29	168.7	91582.0
2020-02-26 09:00:00	MSFT	Stock	168.8	169.78	168.7	169.71	142224.0
2020-02-26 09:30:00	MSFT	Stock	169.71	172.55	168.86	171.21	7967855.0
2020-02-26 10:00:00	MSFT	Stock	171.19	172.59	170.57	172.214	3646494.0
2020-02-26 10:30:00	MSFT	Stock	172.218	173.26	171.97	172.714	3745630.0
2020-02-26 11:00:00	MSFT	Stock	172.7	172.98	171.87	172.86	2269219.0
2020-02-26 11:30:00	MSFT	Stock	172.85	172.87	171.22	171.4	2066480.0
2020-02-26 12:00:00	MSFT	Stock	171.41	171.56	169.16	170.65	3098399.0
2020-02-26 12:30:00	MSFT	Stock	170.7	171.63	170.34	170.69	1878220.0

> showing 50 of 91,253 rows — these rows as CSV

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