PREVIEW / stock_30min / 2020-03-13

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-13.parquet
  size:    1.9 MB
  rows:    96,537
  symbols: 2,465

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-13 04:00:00	AAPL	Stock	63.775	65.4225	63.775	64.3775	152148.0
2020-03-13 04:30:00	AAPL	Stock	64.1025	64.1025	63.5	63.8025	66752.0
2020-03-13 05:00:00	AAPL	Stock	63.895	64.4975	63.575	64.25	49156.0
2020-03-13 05:30:00	AAPL	Stock	64.35	64.7	64.25	64.6975	21492.0
2020-03-13 06:00:00	AAPL	Stock	64.625	65.3125	64.5	64.875	252416.0
2020-03-13 06:30:00	AAPL	Stock	64.8875	65.12	64.665	65.0075	79716.0
2020-03-13 07:00:00	AAPL	Stock	65.005	65.4125	64.5	65.35	711344.0
2020-03-13 07:30:00	AAPL	Stock	65.3275	66.0	65.3125	65.9	701764.0
2020-03-13 08:00:00	AAPL	Stock	64.8125	67.04	64.5	66.92	1954656.0
2020-03-13 08:30:00	AAPL	Stock	66.9125	67.1725	66.5575	66.81	1053892.0
2020-03-13 09:00:00	AAPL	Stock	66.8	66.875	65.995	66.2225	1010432.0
2020-03-13 09:30:00	AAPL	Stock	66.2225	66.3925	63.3575	64.8725	49319956.0
2020-03-13 10:00:00	AAPL	Stock	64.86	66.125	64.575	65.6225	26101676.0
2020-03-13 10:30:00	AAPL	Stock	65.6175	65.8112	64.25	64.275	16354428.0
2020-03-13 11:00:00	AAPL	Stock	64.27	65.3225	64.225	64.2498	15366100.0
2020-03-13 11:30:00	AAPL	Stock	64.255	64.7225	63.2375	64.3378	18807708.0
2020-03-13 12:00:00	AAPL	Stock	64.3375	64.6675	63.7128	64.1938	12251592.0
2020-03-13 12:30:00	AAPL	Stock	64.19	65.76	64.153	64.91	16928592.0
2020-03-13 13:00:00	AAPL	Stock	64.9132	65.75	64.6375	65.577	12042668.0
2020-03-13 13:30:00	AAPL	Stock	65.565	66.0	65.025	65.58	13311488.0
2020-03-13 14:00:00	AAPL	Stock	65.5838	65.619	64.2775	64.5412	12867304.0
2020-03-13 14:30:00	AAPL	Stock	64.5225	65.0125	64.04	64.8175	12878928.0
2020-03-13 15:00:00	AAPL	Stock	64.8	65.5	64.6225	65.3037	14121580.0
2020-03-13 15:30:00	AAPL	Stock	65.3075	69.98	63.59	69.515	47580980.0
2020-03-13 16:00:00	AAPL	Stock	69.4925	69.5	68.625	68.7075	23686596.0
2020-03-13 16:30:00	AAPL	Stock	68.7025	68.775	68.4075	68.6875	851812.0
2020-03-13 17:00:00	AAPL	Stock	68.6875	68.7625	68.6875	68.75	429124.0
2020-03-13 17:30:00	AAPL	Stock	68.775	68.7775	68.6	68.73	142672.0
2020-03-13 18:00:00	AAPL	Stock	68.7375	69.0875	68.7375	69.075	262344.0
2020-03-13 18:30:00	AAPL	Stock	69.035	69.075	68.25	68.4875	178500.0
2020-03-13 19:00:00	AAPL	Stock	68.475	68.545	68.375	68.44	126960.0
2020-03-13 19:30:00	AAPL	Stock	68.445	68.5	68.1375	68.375	196420.0
2020-03-13 04:00:00	MSFT	Stock	143.9	146.1	143.03	144.3	24184.0
2020-03-13 04:30:00	MSFT	Stock	143.7	143.7	141.9	142.7	17018.0
2020-03-13 05:00:00	MSFT	Stock	142.02	143.79	142.0	143.79	3274.0
2020-03-13 05:30:00	MSFT	Stock	143.41	144.5	143.3	144.2	13258.0
2020-03-13 06:00:00	MSFT	Stock	144.48	145.29	143.9	144.49	12687.0
2020-03-13 06:30:00	MSFT	Stock	144.6	145.3	143.95	145.0	9020.0
2020-03-13 07:00:00	MSFT	Stock	145.0	146.0	144.11	146.0	82298.0
2020-03-13 07:30:00	MSFT	Stock	145.99	148.3	145.95	148.3	100193.0
2020-03-13 08:00:00	MSFT	Stock	144.505	149.1	144.2	148.9	201480.0
2020-03-13 08:30:00	MSFT	Stock	148.81	149.3	148.3	149.03	146162.0
2020-03-13 09:00:00	MSFT	Stock	149.03	149.25	147.5	147.64	241007.0
2020-03-13 09:30:00	MSFT	Stock	147.54	148.67	143.0	144.67	10196223.0
2020-03-13 10:00:00	MSFT	Stock	144.64	147.78	144.07	146.73	5889470.0
2020-03-13 10:30:00	MSFT	Stock	146.77	147.12	143.0	143.17	4165861.0
2020-03-13 11:00:00	MSFT	Stock	143.13	145.4	142.225	142.227	3674038.0
2020-03-13 11:30:00	MSFT	Stock	142.27	145.11	140.73	144.37	4753621.0
2020-03-13 12:00:00	MSFT	Stock	144.33	144.89	142.4	143.1	3106370.0
2020-03-13 12:30:00	MSFT	Stock	143.08	146.52	143.0	144.9	3425935.0

> showing 50 of 96,537 rows — these rows as CSV

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