PREVIEW / stock_30min / 2020-04-01

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-04-01.parquet
  size:    1.8 MB
  rows:    93,173
  symbols: 2,424

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-04-01 04:00:00	AAPL	Stock	62.75	62.75	61.79	61.8225	46052.0
2020-04-01 04:30:00	AAPL	Stock	61.86	61.885	61.5675	61.8425	25216.0
2020-04-01 05:00:00	AAPL	Stock	61.8375	62.1	61.75	61.75	8000.0
2020-04-01 05:30:00	AAPL	Stock	61.925	62.0725	61.925	62.0	11292.0
2020-04-01 06:00:00	AAPL	Stock	62.0275	62.12	61.8125	61.835	11308.0
2020-04-01 06:30:00	AAPL	Stock	61.905	61.905	61.565	61.75	27848.0
2020-04-01 07:00:00	AAPL	Stock	61.8925	61.9225	61.6	61.8	331608.0
2020-04-01 07:30:00	AAPL	Stock	61.7825	62.175	61.73	62.0	210872.0
2020-04-01 08:00:00	AAPL	Stock	61.7225	62.0925	61.37	61.6475	725360.0
2020-04-01 08:30:00	AAPL	Stock	61.625	61.95	61.61	61.7775	376084.0
2020-04-01 09:00:00	AAPL	Stock	61.69	61.85	61.58	61.6425	299148.0
2020-04-01 09:30:00	AAPL	Stock	61.6425	62.18	61.4245	61.5662	18092172.0
2020-04-01 10:00:00	AAPL	Stock	61.57	61.8625	61.44	61.6032	12215260.0
2020-04-01 10:30:00	AAPL	Stock	61.609	61.925	61.5122	61.7905	8086292.0
2020-04-01 11:00:00	AAPL	Stock	61.7875	62.075	61.625	61.6288	8598616.0
2020-04-01 11:30:00	AAPL	Stock	61.6325	61.71	61.2925	61.4488	8405308.0
2020-04-01 12:00:00	AAPL	Stock	61.445	61.445	61.0875	61.1025	8197532.0
2020-04-01 12:30:00	AAPL	Stock	61.1058	61.24	60.545	60.6425	9866156.0
2020-04-01 13:00:00	AAPL	Stock	60.64	60.965	60.57	60.841	7317188.0
2020-04-01 13:30:00	AAPL	Stock	60.835	60.92	60.65	60.8525	5563640.0
2020-04-01 14:00:00	AAPL	Stock	60.85	60.97	60.525	60.6525	5473076.0
2020-04-01 14:30:00	AAPL	Stock	60.635	60.635	60.225	60.2532	7290920.0
2020-04-01 15:00:00	AAPL	Stock	60.26	60.39	59.9575	60.025	11378976.0
2020-04-01 15:30:00	AAPL	Stock	60.0275	60.475	59.7825	60.19	18342920.0
2020-04-01 16:00:00	AAPL	Stock	60.33	60.33	60.0775	60.185	13161372.0
2020-04-01 16:30:00	AAPL	Stock	60.1875	60.375	60.175	60.33	97520.0
2020-04-01 17:00:00	AAPL	Stock	60.33	60.4125	60.2725	60.405	45900.0
2020-04-01 17:30:00	AAPL	Stock	60.405	60.405	60.2975	60.405	28936.0
2020-04-01 18:00:00	AAPL	Stock	60.41	60.7275	60.41	60.625	122952.0
2020-04-01 18:30:00	AAPL	Stock	60.5625	60.655	60.4525	60.4525	74220.0
2020-04-01 19:00:00	AAPL	Stock	60.5425	60.5725	60.375	60.55	60688.0
2020-04-01 19:30:00	AAPL	Stock	60.515	60.745	60.49	60.71	95428.0
2020-04-01 04:00:00	MSFT	Stock	154.08	154.36	153.2	153.2	10090.0
2020-04-01 04:30:00	MSFT	Stock	153.3	153.8	152.01	153.8	6484.0
2020-04-01 05:00:00	MSFT	Stock	154.0	154.06	153.16	153.16	7319.0
2020-04-01 05:30:00	MSFT	Stock	153.7	154.47	153.7	154.27	1062.0
2020-04-01 06:00:00	MSFT	Stock	154.49	154.51	153.55	153.72	5299.0
2020-04-01 06:30:00	MSFT	Stock	153.76	153.76	153.11	153.5	6838.0
2020-04-01 07:00:00	MSFT	Stock	153.48	153.73	152.65	153.73	112824.0
2020-04-01 07:30:00	MSFT	Stock	153.6	154.0	153.01	153.2	41578.0
2020-04-01 08:00:00	MSFT	Stock	157.71	157.71	152.13	153.2	192822.0
2020-04-01 08:30:00	MSFT	Stock	153.35	154.2	153.0	153.399	71985.0
2020-04-01 09:00:00	MSFT	Stock	153.21	153.95	152.99	152.99	106492.0
2020-04-01 09:30:00	MSFT	Stock	152.99	156.24	152.66	154.94	7088239.0
2020-04-01 10:00:00	MSFT	Stock	155.0	156.22	154.52	155.358	3236263.0
2020-04-01 10:30:00	MSFT	Stock	155.35	156.57	155.02	156.35	2499999.0
2020-04-01 11:00:00	MSFT	Stock	156.355	157.75	155.738	155.898	3160083.0
2020-04-01 11:30:00	MSFT	Stock	155.95	156.14	154.63	155.085	2704800.0
2020-04-01 12:00:00	MSFT	Stock	155.07	155.13	154.27	154.59	2255138.0
2020-04-01 12:30:00	MSFT	Stock	154.59	154.79	152.8	152.81	2843159.0

> showing 50 of 93,173 rows — these rows as CSV

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