PREVIEW / stock_30min / 2021-03-12

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-12.parquet
  size:    2.3 MB
  rows:    118,039
  symbols: 2,893

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
2021-03-12 04:00:00	AAPL	Stock	120.37	120.5	119.7	119.81	69178.0
2021-03-12 04:30:00	AAPL	Stock	119.81	120.0	119.58	119.68	18676.0
2021-03-12 05:00:00	AAPL	Stock	119.8	119.8	119.54	119.6	6794.0
2021-03-12 05:30:00	AAPL	Stock	119.6	119.97	119.6	119.86	16209.0
2021-03-12 06:00:00	AAPL	Stock	119.87	119.94	119.66	119.82	24354.0
2021-03-12 06:30:00	AAPL	Stock	119.85	120.16	119.84	120.0	13084.0
2021-03-12 07:00:00	AAPL	Stock	120.08	120.61	119.99	120.43	227918.0
2021-03-12 07:30:00	AAPL	Stock	120.4	120.52	120.18	120.51	145745.0
2021-03-12 08:00:00	AAPL	Stock	120.5	122.112	120.1	120.41	450621.0
2021-03-12 08:30:00	AAPL	Stock	120.4	120.53	120.0	120.15	234446.0
2021-03-12 09:00:00	AAPL	Stock	120.15	120.48	119.95	120.45	405870.0
2021-03-12 09:30:00	AAPL	Stock	120.39	120.59	119.16	119.94	14736777.0
2021-03-12 10:00:00	AAPL	Stock	119.94	120.3	119.27	119.42	8362664.0
2021-03-12 10:30:00	AAPL	Stock	119.44	119.94	119.39	119.595	6302682.0
2021-03-12 11:00:00	AAPL	Stock	119.59	119.88	119.425	119.815	4541149.0
2021-03-12 11:30:00	AAPL	Stock	119.82	120.2	119.59	120.11	4588184.0
2021-03-12 12:00:00	AAPL	Stock	120.12	120.88	119.99	120.8408	5414630.0
2021-03-12 12:30:00	AAPL	Stock	120.8498	121.07	120.5016	120.6808	4066332.0
2021-03-12 13:00:00	AAPL	Stock	120.68	120.9299	120.427	120.8967	3037976.0
2021-03-12 13:30:00	AAPL	Stock	120.89	121.01	120.64	120.642	3082101.0
2021-03-12 14:00:00	AAPL	Stock	120.65	120.79	120.5	120.59	2699168.0
2021-03-12 14:30:00	AAPL	Stock	120.595	120.9	120.51	120.76	2420616.0
2021-03-12 15:00:00	AAPL	Stock	120.76	120.87	120.465	120.755	3495870.0
2021-03-12 15:30:00	AAPL	Stock	120.76	121.17	120.68	121.05	7109098.0
2021-03-12 16:00:00	AAPL	Stock	121.06	121.06	120.91	120.99	5271690.0
2021-03-12 16:30:00	AAPL	Stock	120.99	121.03	120.96	121.01	41034.0
2021-03-12 17:00:00	AAPL	Stock	121.02	121.05	120.98	121.01	36451.0
2021-03-12 17:30:00	AAPL	Stock	121.05	121.11	121.01	121.11	18182.0
2021-03-12 18:00:00	AAPL	Stock	121.09	121.1	120.98	120.98	36152.0
2021-03-12 18:30:00	AAPL	Stock	120.98	121.1	120.97	121.09	26011.0
2021-03-12 19:00:00	AAPL	Stock	121.06	121.1	120.99	121.03	32975.0
2021-03-12 19:30:00	AAPL	Stock	121.01	121.1	121.0	121.08	40162.0
2021-03-12 04:00:00	MSFT	Stock	234.01	234.24	233.5	233.8	5950.0
2021-03-12 04:30:00	MSFT	Stock	233.96	234.05	233.5	233.5	6544.0
2021-03-12 05:00:00	MSFT	Stock	233.58	233.58	232.97	232.97	2047.0
2021-03-12 05:30:00	MSFT	Stock	233.0	233.81	232.68	232.68	8480.0
2021-03-12 06:00:00	MSFT	Stock	232.64	233.43	232.5	232.74	2897.0
2021-03-12 06:30:00	MSFT	Stock	233.25	233.25	232.9	233.06	1197.0
2021-03-12 07:00:00	MSFT	Stock	233.68	234.0	233.05	233.39	27431.0
2021-03-12 07:30:00	MSFT	Stock	233.64	234.57	233.64	234.39	16878.0
2021-03-12 08:00:00	MSFT	Stock	234.3	236.537	233.21	234.49	38196.0
2021-03-12 08:30:00	MSFT	Stock	234.4	234.8866	233.75	234.1	26084.0
2021-03-12 09:00:00	MSFT	Stock	234.0	234.48	233.33	234.07	35506.0
2021-03-12 09:30:00	MSFT	Stock	234.01	235.46	233.37	235.37	2313493.0
2021-03-12 10:00:00	MSFT	Stock	235.4	235.445	233.58	234.08	1425426.0
2021-03-12 10:30:00	MSFT	Stock	234.09	235.16	233.36	233.64	1602043.0
2021-03-12 11:00:00	MSFT	Stock	233.64	234.38	233.23	234.295	1048327.0
2021-03-12 11:30:00	MSFT	Stock	234.305	234.95	234.01	234.59	806929.0
2021-03-12 12:00:00	MSFT	Stock	234.62	235.21	234.4	235.17	632881.0
2021-03-12 12:30:00	MSFT	Stock	235.18	235.54	234.64	234.71	641556.0

> showing 50 of 118,039 rows — these rows as CSV

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