PREVIEW / stock_30min / 2019-10-28

all stock 30-min files

  file:    by_date/stock_30min/2019/2019-10-28.parquet
  size:    1.7 MB
  rows:    83,914
  symbols: 2,517

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-10-28 04:00:00	AAPL	Stock	61.825	61.9625	61.825	61.9625	2908.0
2019-10-28 04:30:00	AAPL	Stock	61.9575	61.9825	61.9	61.9575	22824.0
2019-10-28 05:00:00	AAPL	Stock	61.915	61.9175	61.9	61.9	4764.0
2019-10-28 05:30:00	AAPL	Stock	61.875	61.9	61.855	61.8575	11412.0
2019-10-28 06:00:00	AAPL	Stock	61.86	61.8625	61.8	61.8375	26116.0
2019-10-28 06:30:00	AAPL	Stock	61.8375	61.8625	61.8375	61.8625	6040.0
2019-10-28 07:00:00	AAPL	Stock	61.8375	61.9375	61.8375	61.87	114476.0
2019-10-28 07:30:00	AAPL	Stock	61.85	61.8625	61.785	61.85	54428.0
2019-10-28 08:00:00	AAPL	Stock	61.9125	61.9375	61.4925	61.8475	368468.0
2019-10-28 08:30:00	AAPL	Stock	61.8425	61.98	61.8375	61.9625	241484.0
2019-10-28 09:00:00	AAPL	Stock	61.965	61.9775	61.84	61.8575	421244.0
2019-10-28 09:30:00	AAPL	Stock	61.875	62.09	61.68	62.0062	15526360.0
2019-10-28 10:00:00	AAPL	Stock	62.005	62.1575	61.9575	62.074	7259620.0
2019-10-28 10:30:00	AAPL	Stock	62.073	62.1625	61.9375	62.02	7402208.0
2019-10-28 11:00:00	AAPL	Stock	62.015	62.1825	61.9925	62.1175	4832344.0
2019-10-28 11:30:00	AAPL	Stock	62.12	62.175	62.0325	62.1388	4713892.0
2019-10-28 12:00:00	AAPL	Stock	62.1425	62.18	62.0575	62.14	3951420.0
2019-10-28 12:30:00	AAPL	Stock	62.14	62.1575	62.1	62.1212	2829992.0
2019-10-28 13:00:00	AAPL	Stock	62.12	62.1675	62.113	62.135	2753296.0
2019-10-28 13:30:00	AAPL	Stock	62.135	62.17	62.0875	62.1025	2656236.0
2019-10-28 14:00:00	AAPL	Stock	62.1018	62.13	62.075	62.0875	2931028.0
2019-10-28 14:30:00	AAPL	Stock	62.085	62.145	62.08	62.1238	2214224.0
2019-10-28 15:00:00	AAPL	Stock	62.1238	62.245	62.1225	62.2375	5206956.0
2019-10-28 15:30:00	AAPL	Stock	62.235	62.3125	62.19	62.26	8846012.0
2019-10-28 16:00:00	AAPL	Stock	62.2625	62.29	62.0082	62.225	6425984.0
2019-10-28 16:30:00	AAPL	Stock	62.2175	62.275	62.215	62.2625	166632.0
2019-10-28 17:00:00	AAPL	Stock	62.2675	62.3375	62.25	62.2825	101460.0
2019-10-28 17:30:00	AAPL	Stock	62.2825	62.295	62.25	62.285	30092.0
2019-10-28 18:00:00	AAPL	Stock	62.2775	62.3	62.2625	62.28	28476.0
2019-10-28 18:30:00	AAPL	Stock	62.28	62.295	62.28	62.2875	17456.0
2019-10-28 19:00:00	AAPL	Stock	62.2875	62.3	62.2825	62.3	13280.0
2019-10-28 19:30:00	AAPL	Stock	62.3025	62.325	62.2875	62.2875	51600.0
2019-10-28 04:00:00	MSFT	Stock	145.0	146.44	145.0	146.29	9725.0
2019-10-28 04:30:00	MSFT	Stock	146.0	146.01	145.35	145.4	20702.0
2019-10-28 05:00:00	MSFT	Stock	145.23	145.23	144.95	144.98	15841.0
2019-10-28 05:30:00	MSFT	Stock	145.08	145.18	144.75	145.06	6745.0
2019-10-28 06:00:00	MSFT	Stock	145.05	145.74	145.05	145.27	41541.0
2019-10-28 06:30:00	MSFT	Stock	145.27	145.5	144.82	144.99	30458.0
2019-10-28 07:00:00	MSFT	Stock	144.95	145.5	144.32	144.51	147767.0
2019-10-28 07:30:00	MSFT	Stock	144.65	144.65	144.32	144.4	74103.0
2019-10-28 08:00:00	MSFT	Stock	144.45	145.5	144.1	144.116	253526.0
2019-10-28 08:30:00	MSFT	Stock	144.15	144.55	144.14	144.39	146874.0
2019-10-28 09:00:00	MSFT	Stock	144.39	144.75	143.8	144.61	316525.0
2019-10-28 09:30:00	MSFT	Stock	144.4	145.67	144.28	144.405	9185821.0
2019-10-28 10:00:00	MSFT	Stock	144.405	144.51	144.08	144.348	2436172.0
2019-10-28 10:30:00	MSFT	Stock	144.331	144.339	143.7	143.9	2506245.0
2019-10-28 11:00:00	MSFT	Stock	143.89	144.0	143.645	143.76	1465509.0
2019-10-28 11:30:00	MSFT	Stock	143.76	144.26	143.55	143.994	1723271.0
2019-10-28 12:00:00	MSFT	Stock	144.0	144.015	143.52	143.688	1201851.0
2019-10-28 12:30:00	MSFT	Stock	143.69	143.82	143.55	143.6	770479.0

> showing 50 of 83,914 rows — these rows as CSV

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