PREVIEW / stock_30min / 2019-08-21

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-08-21.parquet
  size:    1.7 MB
  rows:    85,531
  symbols: 2,562

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
2019-08-21 04:00:00	AAPL	Stock	52.775	53.11	52.775	53.05	13980.0
2019-08-21 04:30:00	AAPL	Stock	53.045	53.135	53.045	53.135	7260.0
2019-08-21 05:00:00	AAPL	Stock	53.1125	53.15	53.0875	53.15	22152.0
2019-08-21 05:30:00	AAPL	Stock	53.1525	53.2	53.09	53.1125	10512.0
2019-08-21 06:00:00	AAPL	Stock	53.09	53.09	53.045	53.08	19412.0
2019-08-21 06:30:00	AAPL	Stock	53.1125	53.1125	53.05	53.075	9180.0
2019-08-21 07:00:00	AAPL	Stock	53.1	53.1	53.0	53.07	87472.0
2019-08-21 07:30:00	AAPL	Stock	53.05	53.075	53.0	53.0525	90952.0
2019-08-21 08:00:00	AAPL	Stock	53.06	53.1	53.0	53.065	126512.0
2019-08-21 08:30:00	AAPL	Stock	53.065	53.115	53.0425	53.115	90988.0
2019-08-21 09:00:00	AAPL	Stock	53.1025	53.2425	53.1	53.2425	248728.0
2019-08-21 09:30:00	AAPL	Stock	53.2475	53.3175	53.1	53.286	11559264.0
2019-08-21 10:00:00	AAPL	Stock	53.285	53.3575	53.2162	53.2832	5819772.0
2019-08-21 10:30:00	AAPL	Stock	53.2825	53.3335	53.22	53.3025	5659920.0
2019-08-21 11:00:00	AAPL	Stock	53.3	53.4125	53.2225	53.3475	5026600.0
2019-08-21 11:30:00	AAPL	Stock	53.345	53.3875	53.2875	53.335	3661064.0
2019-08-21 12:00:00	AAPL	Stock	53.34	53.3425	53.2175	53.265	3512760.0
2019-08-21 12:30:00	AAPL	Stock	53.265	53.2975	53.23	53.2875	2583248.0
2019-08-21 13:00:00	AAPL	Stock	53.285	53.3375	53.2525	53.2605	2287492.0
2019-08-21 13:30:00	AAPL	Stock	53.26	53.265	53.05	53.085	3611812.0
2019-08-21 14:00:00	AAPL	Stock	53.085	53.2625	52.9008	53.2325	6047380.0
2019-08-21 14:30:00	AAPL	Stock	53.2338	53.2448	53.0075	53.07	4113668.0
2019-08-21 15:00:00	AAPL	Stock	53.0675	53.1575	53.0275	53.135	4374216.0
2019-08-21 15:30:00	AAPL	Stock	53.14	53.1825	53.03	53.1625	6828824.0
2019-08-21 16:00:00	AAPL	Stock	53.16	53.175	53.0645	53.14	8284212.0
2019-08-21 16:30:00	AAPL	Stock	53.175	53.2	53.165	53.1875	23092.0
2019-08-21 17:00:00	AAPL	Stock	53.1875	53.21	53.1825	53.1825	10360.0
2019-08-21 17:30:00	AAPL	Stock	53.21	53.2375	53.2075	53.2125	18448.0
2019-08-21 18:00:00	AAPL	Stock	53.225	53.375	53.225	53.28	102988.0
2019-08-21 18:30:00	AAPL	Stock	53.2825	53.3375	53.2725	53.29	30296.0
2019-08-21 19:00:00	AAPL	Stock	53.3	53.33	53.3	53.3125	21032.0
2019-08-21 19:30:00	AAPL	Stock	53.3125	53.3475	53.2875	53.3475	36600.0
2019-08-21 04:00:00	MSFT	Stock	137.7	138.1	137.7	138.1	1267.0
2019-08-21 04:30:00	MSFT	Stock	138.2	138.25	138.2	138.25	1070.0
2019-08-21 05:30:00	MSFT	Stock	138.33	138.44	138.33	138.44	1516.0
2019-08-21 06:00:00	MSFT	Stock	138.3	138.3	138.3	138.3	100.0
2019-08-21 07:00:00	MSFT	Stock	138.2	138.28	137.81	138.2	14352.0
2019-08-21 07:30:00	MSFT	Stock	138.25	138.25	138.13	138.2	2410.0
2019-08-21 08:00:00	MSFT	Stock	138.1	138.28	137.69	138.28	37634.0
2019-08-21 08:30:00	MSFT	Stock	138.21	138.33	138.2	138.2	7735.0
2019-08-21 09:00:00	MSFT	Stock	138.22	138.72	138.22	138.45	62736.0
2019-08-21 09:30:00	MSFT	Stock	138.51	139.494	138.22	139.1	2072351.0
2019-08-21 10:00:00	MSFT	Stock	139.1	139.19	138.7	138.87	864265.0
2019-08-21 10:30:00	MSFT	Stock	138.86	138.96	138.64	138.93	805816.0
2019-08-21 11:00:00	MSFT	Stock	138.92	139.063	138.72	138.945	683546.0
2019-08-21 11:30:00	MSFT	Stock	138.94	139.11	138.73	138.855	811296.0
2019-08-21 12:00:00	MSFT	Stock	138.86	138.904	138.71	138.75	496261.0
2019-08-21 12:30:00	MSFT	Stock	138.74	138.87	138.64	138.77	482140.0
2019-08-21 13:00:00	MSFT	Stock	138.762	138.78	138.675	138.72	325381.0
2019-08-21 13:30:00	MSFT	Stock	138.73	138.73	138.47	138.53	493943.0

> showing 50 of 85,531 rows — these rows as CSV

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