PREVIEW / stock_30min / 2020-01-31

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-01-31.parquet
  size:    1.8 MB
  rows:    87,305
  symbols: 2,437

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-01-31 04:00:00	AAPL	Stock	80.7025	80.75	80.66	80.66	11512.0
2020-01-31 04:30:00	AAPL	Stock	80.66	80.66	80.625	80.635	7532.0
2020-01-31 05:00:00	AAPL	Stock	80.575	80.63	80.4375	80.4375	35172.0
2020-01-31 05:30:00	AAPL	Stock	80.42	80.42	80.3	80.39	19120.0
2020-01-31 06:00:00	AAPL	Stock	80.4325	80.4725	80.39	80.4475	21148.0
2020-01-31 06:30:00	AAPL	Stock	80.3925	80.495	80.3925	80.495	7828.0
2020-01-31 07:00:00	AAPL	Stock	80.4525	80.695	80.4525	80.5875	307112.0
2020-01-31 07:30:00	AAPL	Stock	80.575	80.6825	80.5	80.55	98184.0
2020-01-31 08:00:00	AAPL	Stock	80.58	80.6875	80.405	80.5125	332264.0
2020-01-31 08:30:00	AAPL	Stock	80.5	80.5475	80.425	80.45	164024.0
2020-01-31 09:00:00	AAPL	Stock	80.44	80.5375	80.1875	80.255	550904.0
2020-01-31 09:30:00	AAPL	Stock	80.235	80.67	79.26	79.605	20902704.0
2020-01-31 10:00:00	AAPL	Stock	79.59	79.61	78.7675	78.9075	16513972.0
2020-01-31 10:30:00	AAPL	Stock	78.901	79.234	78.84	78.965	10408976.0
2020-01-31 11:00:00	AAPL	Stock	78.9618	79.2975	78.7675	78.88	9341736.0
2020-01-31 11:30:00	AAPL	Stock	78.8825	79.2025	78.62	79.192	9240232.0
2020-01-31 12:00:00	AAPL	Stock	79.19	79.2275	78.9107	79.0325	4487896.0
2020-01-31 12:30:00	AAPL	Stock	79.03	79.0325	78.55	78.705	7269644.0
2020-01-31 13:00:00	AAPL	Stock	78.695	78.825	78.245	78.3075	7442828.0
2020-01-31 13:30:00	AAPL	Stock	78.3075	78.3075	77.5125	78.145	13192776.0
2020-01-31 14:00:00	AAPL	Stock	78.15	78.4375	77.8125	77.8942	10417080.0
2020-01-31 14:30:00	AAPL	Stock	77.886	78.2575	77.8425	78.046	7279004.0
2020-01-31 15:00:00	AAPL	Stock	78.055	78.14	77.5905	77.7062	10404388.0
2020-01-31 15:30:00	AAPL	Stock	77.7	77.76	77.0725	77.3325	24266808.0
2020-01-31 16:00:00	AAPL	Stock	77.3775	77.425	77.1525	77.195	10975880.0
2020-01-31 16:30:00	AAPL	Stock	77.185	77.3775	77.17	77.275	328584.0
2020-01-31 17:00:00	AAPL	Stock	77.2725	77.3775	77.2	77.25	235832.0
2020-01-31 17:30:00	AAPL	Stock	77.25	77.2975	77.2375	77.27	61572.0
2020-01-31 18:00:00	AAPL	Stock	77.295	77.295	77.215	77.225	75656.0
2020-01-31 18:30:00	AAPL	Stock	77.2275	77.24	77.13	77.185	139476.0
2020-01-31 19:00:00	AAPL	Stock	77.18	77.2075	77.07	77.085	138320.0
2020-01-31 19:30:00	AAPL	Stock	77.075	77.075	77.0	77.0375	137968.0
2020-01-31 04:00:00	MSFT	Stock	172.78	172.86	172.54	172.7	2708.0
2020-01-31 04:30:00	MSFT	Stock	172.7	172.7	172.14	172.14	4666.0
2020-01-31 05:00:00	MSFT	Stock	172.35	172.47	172.21	172.21	1834.0
2020-01-31 05:30:00	MSFT	Stock	172.0	172.01	171.93	172.01	1400.0
2020-01-31 06:00:00	MSFT	Stock	172.2	172.2	172.15	172.15	2954.0
2020-01-31 06:30:00	MSFT	Stock	172.06	172.2	172.06	172.2	413.0
2020-01-31 07:00:00	MSFT	Stock	172.14	172.44	172.1	172.3	25481.0
2020-01-31 07:30:00	MSFT	Stock	172.29	172.38	171.85	172.0	21055.0
2020-01-31 08:00:00	MSFT	Stock	172.28	172.48	171.5	171.88	30378.0
2020-01-31 08:30:00	MSFT	Stock	172.067	172.226	171.88	172.1	15197.0
2020-01-31 09:00:00	MSFT	Stock	172.08	172.45	172.0	172.17	33928.0
2020-01-31 09:30:00	MSFT	Stock	172.19	172.4	171.16	171.71	3795999.0
2020-01-31 10:00:00	MSFT	Stock	171.71	171.71	170.81	170.84	2727322.0
2020-01-31 10:30:00	MSFT	Stock	170.84	171.12	170.28	170.76	2158538.0
2020-01-31 11:00:00	MSFT	Stock	170.78	170.96	169.94	170.09	2084306.0
2020-01-31 11:30:00	MSFT	Stock	170.1	170.68	169.58	170.64	1798687.0
2020-01-31 12:00:00	MSFT	Stock	170.64	170.66	170.18	170.61	982569.0
2020-01-31 12:30:00	MSFT	Stock	170.6	170.6	169.82	170.47	1650437.0

> showing 50 of 87,305 rows — these rows as CSV

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