PREVIEW / stock_30min / 2020-03-09

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-03-09.parquet
  size:    2.0 MB
  rows:    99,588
  symbols: 2,441

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-09 04:00:00	AAPL	Stock	67.8325	67.975	66.675	66.84	167548.0
2020-03-09 04:30:00	AAPL	Stock	66.885	67.125	66.625	67.0	128912.0
2020-03-09 05:00:00	AAPL	Stock	67.0425	68.025	67.0425	67.875	113684.0
2020-03-09 05:30:00	AAPL	Stock	67.8	68.15	67.73	67.9	111168.0
2020-03-09 06:00:00	AAPL	Stock	67.875	68.1	67.6	67.97	63552.0
2020-03-09 06:30:00	AAPL	Stock	67.9875	68.1225	67.58	67.7425	193072.0
2020-03-09 07:00:00	AAPL	Stock	67.6925	68.1075	67.13	67.145	390744.0
2020-03-09 07:30:00	AAPL	Stock	67.1625	67.435	67.0425	67.275	339988.0
2020-03-09 08:00:00	AAPL	Stock	67.875	68.05	66.6825	67.025	1120160.0
2020-03-09 08:30:00	AAPL	Stock	67.0	67.05	66.1225	66.1225	1021824.0
2020-03-09 09:00:00	AAPL	Stock	66.075	66.1	65.325	65.895	1373488.0
2020-03-09 09:30:00	AAPL	Stock	65.93	68.775	65.75	68.1755	27929172.0
2020-03-09 10:00:00	AAPL	Stock	68.16	69.345	67.3275	68.58	24748152.0
2020-03-09 10:30:00	AAPL	Stock	68.58	68.8375	67.5775	67.86	16311796.0
2020-03-09 11:00:00	AAPL	Stock	67.8575	68.7675	67.5075	68.25	15424556.0
2020-03-09 11:30:00	AAPL	Stock	68.235	69.405	67.88	69.0325	15953316.0
2020-03-09 12:00:00	AAPL	Stock	69.02	69.5225	68.4825	68.5788	11765480.0
2020-03-09 12:30:00	AAPL	Stock	68.575	68.9725	68.2975	68.7125	10906416.0
2020-03-09 13:00:00	AAPL	Stock	68.709	69.0875	68.275	68.345	9873384.0
2020-03-09 13:30:00	AAPL	Stock	68.36	68.36	67.6	67.7002	10004888.0
2020-03-09 14:00:00	AAPL	Stock	67.71	67.975	67.0	67.2968	12783660.0
2020-03-09 14:30:00	AAPL	Stock	67.2675	67.9	66.98	67.5325	14222740.0
2020-03-09 15:00:00	AAPL	Stock	67.55	68.375	67.2375	68.0365	16766884.0
2020-03-09 15:30:00	AAPL	Stock	68.0325	68.45	66.4675	66.5225	26102852.0
2020-03-09 16:00:00	AAPL	Stock	66.5425	67.1375	66.28	66.745	16664556.0
2020-03-09 16:30:00	AAPL	Stock	66.78	66.875	66.2925	66.3725	402252.0
2020-03-09 17:00:00	AAPL	Stock	66.3775	66.5425	66.125	66.125	141436.0
2020-03-09 17:30:00	AAPL	Stock	66.125	66.125	65.75	66.125	286596.0
2020-03-09 18:00:00	AAPL	Stock	66.125	66.4375	65.545	66.265	209132.0
2020-03-09 18:30:00	AAPL	Stock	66.32	67.375	66.1625	67.3125	297392.0
2020-03-09 19:00:00	AAPL	Stock	67.3125	68.08	67.3125	67.9925	518576.0
2020-03-09 19:30:00	AAPL	Stock	67.955	68.4575	67.9025	68.425	620160.0
2020-03-09 04:00:00	MSFT	Stock	152.07	152.07	150.07	150.21	27643.0
2020-03-09 04:30:00	MSFT	Stock	150.21	151.0	148.6	151.0	26710.0
2020-03-09 05:00:00	MSFT	Stock	150.99	152.94	150.99	152.48	17363.0
2020-03-09 05:30:00	MSFT	Stock	152.6	153.12	152.3	152.6	24761.0
2020-03-09 06:00:00	MSFT	Stock	152.5	152.73	151.6	152.03	28093.0
2020-03-09 06:30:00	MSFT	Stock	152.25	152.77	152.13	152.2	18289.0
2020-03-09 07:00:00	MSFT	Stock	152.5	152.88	150.99	151.1	84617.0
2020-03-09 07:30:00	MSFT	Stock	151.01	151.48	150.24	150.87	59750.0
2020-03-09 08:00:00	MSFT	Stock	152.58	152.88	149.7	150.11	142330.0
2020-03-09 08:30:00	MSFT	Stock	150.15	151.0	149.8	150.9	186461.0
2020-03-09 09:00:00	MSFT	Stock	150.38	151.3	150.1	150.52	268701.0
2020-03-09 09:30:00	MSFT	Stock	150.77	156.93	150.0	155.11	7842772.0
2020-03-09 10:00:00	MSFT	Stock	155.14	157.75	153.48	154.36	6899852.0
2020-03-09 10:30:00	MSFT	Stock	154.3	155.5	153.75	154.32	3720084.0
2020-03-09 11:00:00	MSFT	Stock	154.31	157.0	154.31	155.54	3829313.0
2020-03-09 11:30:00	MSFT	Stock	155.53	157.43	155.05	156.49	2925450.0
2020-03-09 12:00:00	MSFT	Stock	156.49	157.33	155.72	155.775	2140743.0
2020-03-09 12:30:00	MSFT	Stock	155.775	156.405	154.36	154.9	2305252.0

> showing 50 of 99,588 rows — these rows as CSV

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