PREVIEW / stock_30min / 2020-03-18

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-18.parquet
  size:    1.9 MB
  rows:    97,439
  symbols: 2,472

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-03-18 04:00:00	AAPL	Stock	59.9275	59.9275	59.5125	59.875	72028.0
2020-03-18 04:30:00	AAPL	Stock	59.825	60.15	59.5225	59.995	86248.0
2020-03-18 05:00:00	AAPL	Stock	59.9	59.925	59.65	59.7375	58972.0
2020-03-18 05:30:00	AAPL	Stock	59.6925	59.775	59.5	59.625	47300.0
2020-03-18 06:00:00	AAPL	Stock	59.675	59.68	59.1225	59.1225	67764.0
2020-03-18 06:30:00	AAPL	Stock	59.125	59.375	59.0	59.125	113828.0
2020-03-18 07:00:00	AAPL	Stock	59.125	59.4625	59.0625	59.26	573784.0
2020-03-18 07:30:00	AAPL	Stock	59.35	59.8375	59.2525	59.8125	316196.0
2020-03-18 08:00:00	AAPL	Stock	59.25	60.45	59.1025	60.25	1063976.0
2020-03-18 08:30:00	AAPL	Stock	60.2	60.492	59.8065	60.115	884800.0
2020-03-18 09:00:00	AAPL	Stock	60.125	60.3	59.8625	59.9375	470460.0
2020-03-18 09:30:00	AAPL	Stock	59.9375	61.6025	59.802	61.18	32428104.0
2020-03-18 10:00:00	AAPL	Stock	61.1625	62.0	60.9325	61.812	16690280.0
2020-03-18 10:30:00	AAPL	Stock	61.8112	61.99	61.125	61.3375	12276444.0
2020-03-18 11:00:00	AAPL	Stock	61.3325	61.4725	60.875	61.0488	14151272.0
2020-03-18 11:30:00	AAPL	Stock	61.06	61.7	60.825	61.52	13162040.0
2020-03-18 12:00:00	AAPL	Stock	61.5075	61.6225	60.9275	61.5075	11921012.0
2020-03-18 12:30:00	AAPL	Stock	61.5175	61.5875	60.5	60.525	11438912.0
2020-03-18 13:00:00	AAPL	Stock	60.065	60.8125	60.0475	60.1275	12465872.0
2020-03-18 13:30:00	AAPL	Stock	60.104	60.5625	59.5	60.265	17724128.0
2020-03-18 14:00:00	AAPL	Stock	60.295	60.3575	59.3202	59.45	14758644.0
2020-03-18 14:30:00	AAPL	Stock	59.46	60.5	59.28	60.4875	15742956.0
2020-03-18 15:00:00	AAPL	Stock	60.4875	60.515	59.6875	59.8285	17560788.0
2020-03-18 15:30:00	AAPL	Stock	59.8075	62.5	59.6825	62.25	30023888.0
2020-03-18 16:00:00	AAPL	Stock	61.6675	62.5	61.3125	61.65	16839024.0
2020-03-18 16:30:00	AAPL	Stock	61.65	61.925	61.4	61.7475	344200.0
2020-03-18 17:00:00	AAPL	Stock	61.7575	61.85	61.55	61.6875	115332.0
2020-03-18 17:30:00	AAPL	Stock	61.745	61.785	61.7125	61.775	78900.0
2020-03-18 18:00:00	AAPL	Stock	61.785	61.855	61.0	61.2025	261220.0
2020-03-18 18:30:00	AAPL	Stock	61.1925	62.5	61.075	62.3125	260976.0
2020-03-18 19:00:00	AAPL	Stock	62.16	62.8	62.125	62.75	342836.0
2020-03-18 19:30:00	AAPL	Stock	62.75	63.5	62.75	63.4375	380824.0
2020-03-18 04:00:00	MSFT	Stock	139.7	139.7	138.03	138.6	11438.0
2020-03-18 04:30:00	MSFT	Stock	138.55	139.64	138.55	139.31	2483.0
2020-03-18 05:00:00	MSFT	Stock	139.41	139.5	138.7	138.7	3611.0
2020-03-18 05:30:00	MSFT	Stock	138.55	138.7	138.4	138.4	2000.0
2020-03-18 06:00:00	MSFT	Stock	138.5	138.5	137.0	137.0	9084.0
2020-03-18 06:30:00	MSFT	Stock	137.07	137.8	137.07	137.52	4384.0
2020-03-18 07:00:00	MSFT	Stock	137.77	138.1	136.96	137.49	95234.0
2020-03-18 07:30:00	MSFT	Stock	137.5	138.91	137.48	138.85	44046.0
2020-03-18 08:00:00	MSFT	Stock	137.9	138.91	137.0	138.44	79782.0
2020-03-18 08:30:00	MSFT	Stock	138.44	138.63	137.5	137.75	76215.0
2020-03-18 09:00:00	MSFT	Stock	138.02	138.8	137.21	137.32	73301.0
2020-03-18 09:30:00	MSFT	Stock	137.32	144.053	136.8	143.07	7918605.0
2020-03-18 10:00:00	MSFT	Stock	143.1	146.0	142.04	143.88	4109599.0
2020-03-18 10:30:00	MSFT	Stock	143.82	145.65	141.66	142.34	3370930.0
2020-03-18 11:00:00	MSFT	Stock	142.37	143.02	140.54	141.65	3538732.0
2020-03-18 11:30:00	MSFT	Stock	141.68	144.11	141.22	143.33	3420809.0
2020-03-18 12:00:00	MSFT	Stock	143.33	143.4	141.421	142.98	2983532.0
2020-03-18 12:30:00	MSFT	Stock	143.02	143.25	139.42	139.43	2992008.0

> showing 50 of 97,439 rows — these rows as CSV

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