PREVIEW / stock_30min / 2020-03-11

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-11.parquet
  size:    1.9 MB
  rows:    92,501
  symbols: 2,449

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-11 04:00:00	AAPL	Stock	69.565	69.8375	68.95	68.95	55128.0
2020-03-11 04:30:00	AAPL	Stock	69.075	70.0	69.035	69.9475	28080.0
2020-03-11 05:00:00	AAPL	Stock	69.805	69.875	69.625	69.8625	12416.0
2020-03-11 05:30:00	AAPL	Stock	69.725	69.725	69.3925	69.5	25284.0
2020-03-11 06:00:00	AAPL	Stock	69.475	69.5	69.2175	69.2275	23380.0
2020-03-11 06:30:00	AAPL	Stock	69.3	69.6875	69.2475	69.485	27452.0
2020-03-11 07:00:00	AAPL	Stock	69.5	69.8	69.225	69.275	237004.0
2020-03-11 07:30:00	AAPL	Stock	69.3225	69.435	68.875	69.375	193976.0
2020-03-11 08:00:00	AAPL	Stock	69.7	69.8248	68.882	69.1415	283048.0
2020-03-11 08:30:00	AAPL	Stock	69.25	69.3	68.88	68.965	373960.0
2020-03-11 09:00:00	AAPL	Stock	69.0365	69.375	68.8945	69.3225	974196.0
2020-03-11 09:30:00	AAPL	Stock	69.3475	69.8078	69.0175	69.36	25314476.0
2020-03-11 10:00:00	AAPL	Stock	69.35	69.8375	68.6875	68.88	14985620.0
2020-03-11 10:30:00	AAPL	Stock	68.885	69.3125	68.75	69.0875	11990104.0
2020-03-11 11:00:00	AAPL	Stock	69.095	69.3075	68.765	69.0275	11434316.0
2020-03-11 11:30:00	AAPL	Stock	69.03	69.4275	68.92	69.235	10643412.0
2020-03-11 12:00:00	AAPL	Stock	69.26	70.305	69.125	69.5875	15304084.0
2020-03-11 12:30:00	AAPL	Stock	69.5875	69.705	68.9112	69.0975	11902916.0
2020-03-11 13:00:00	AAPL	Stock	69.0962	69.325	68.61	69.209	12303644.0
2020-03-11 13:30:00	AAPL	Stock	69.215	69.27	68.7625	69.091	9439076.0
2020-03-11 14:00:00	AAPL	Stock	69.0875	69.2125	68.5275	68.74	9653872.0
2020-03-11 14:30:00	AAPL	Stock	68.7475	69.4925	68.74	68.9675	13836928.0
2020-03-11 15:00:00	AAPL	Stock	68.965	69.1625	68.0525	68.5912	17997856.0
2020-03-11 15:30:00	AAPL	Stock	68.587	69.5825	67.965	68.825	28752964.0
2020-03-11 16:00:00	AAPL	Stock	68.8275	69.25	68.6875	69.2025	16867272.0
2020-03-11 16:30:00	AAPL	Stock	68.8575	69.345	68.8575	69.1275	268556.0
2020-03-11 17:00:00	AAPL	Stock	69.13	69.175	68.7025	68.75	219392.0
2020-03-11 17:30:00	AAPL	Stock	68.75	68.8	68.65	68.6775	224280.0
2020-03-11 18:00:00	AAPL	Stock	68.75	69.4	68.72	69.4	365332.0
2020-03-11 18:30:00	AAPL	Stock	69.4	69.59	69.25	69.465	165336.0
2020-03-11 19:00:00	AAPL	Stock	69.475	69.475	69.0125	69.0125	102820.0
2020-03-11 19:30:00	AAPL	Stock	69.025	69.125	68.69	68.85	248800.0
2020-03-11 04:00:00	MSFT	Stock	157.74	157.79	156.01	156.12	5527.0
2020-03-11 04:30:00	MSFT	Stock	156.33	158.4	156.33	158.0	10073.0
2020-03-11 05:00:00	MSFT	Stock	157.8	158.0	157.6	158.0	3077.0
2020-03-11 05:30:00	MSFT	Stock	157.67	157.8	157.25	157.75	11759.0
2020-03-11 06:00:00	MSFT	Stock	157.77	157.93	156.99	156.99	7314.0
2020-03-11 06:30:00	MSFT	Stock	157.5	157.9	157.46	157.9	961.0
2020-03-11 07:00:00	MSFT	Stock	157.34	157.76	156.8	156.8	20478.0
2020-03-11 07:30:00	MSFT	Stock	156.82	157.0	155.8	156.8	33745.0
2020-03-11 08:00:00	MSFT	Stock	157.57	157.79	156.07	156.2	32079.0
2020-03-11 08:30:00	MSFT	Stock	156.1	156.398	155.39	155.9	48420.0
2020-03-11 09:00:00	MSFT	Stock	155.85	157.7	155.74	157.26	70878.0
2020-03-11 09:30:00	MSFT	Stock	157.22	157.7	155.01	156.64	5381162.0
2020-03-11 10:00:00	MSFT	Stock	156.63	157.24	155.33	155.39	2885405.0
2020-03-11 10:30:00	MSFT	Stock	155.37	156.0	154.55	155.2	2693753.0
2020-03-11 11:00:00	MSFT	Stock	155.19	155.69	153.94	154.14	2294365.0
2020-03-11 11:30:00	MSFT	Stock	154.19	154.94	154.05	154.86	1941770.0
2020-03-11 12:00:00	MSFT	Stock	154.89	156.715	154.44	155.55	2487064.0
2020-03-11 12:30:00	MSFT	Stock	155.55	155.87	153.65	154.023	2097290.0

> showing 50 of 92,501 rows — these rows as CSV

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