PREVIEW / stock_30min / 2021-03-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-03-23.parquet
  size:    2.3 MB
  rows:    114,816
  symbols: 2,915

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-23 04:00:00	AAPL	Stock	123.02	123.02	122.31	122.48	11596.0
2021-03-23 04:30:00	AAPL	Stock	122.49	122.71	122.36	122.68	13966.0
2021-03-23 05:00:00	AAPL	Stock	122.68	122.87	122.2	122.35	12499.0
2021-03-23 05:30:00	AAPL	Stock	122.25	122.68	122.25	122.5	6168.0
2021-03-23 06:00:00	AAPL	Stock	122.35	122.88	122.35	122.52	8293.0
2021-03-23 06:30:00	AAPL	Stock	122.53	122.93	122.53	122.72	21218.0
2021-03-23 07:00:00	AAPL	Stock	122.84	123.24	122.76	123.139	91809.0
2021-03-23 07:30:00	AAPL	Stock	123.13	123.31	123.06	123.11	68737.0
2021-03-23 08:00:00	AAPL	Stock	122.8818	123.698	122.86	123.03	244459.0
2021-03-23 08:30:00	AAPL	Stock	123.02	123.54	123.0	123.42	212194.0
2021-03-23 09:00:00	AAPL	Stock	123.42	123.48	123.2215	123.34	133229.0
2021-03-23 09:30:00	AAPL	Stock	123.31	123.69	122.5382	122.7591	9703338.0
2021-03-23 10:00:00	AAPL	Stock	122.755	123.76	122.62	123.09	6838777.0
2021-03-23 10:30:00	AAPL	Stock	123.0801	123.26	122.6	123.24	6459431.0
2021-03-23 11:00:00	AAPL	Stock	123.24	124.24	123.075	123.7	7846984.0
2021-03-23 11:30:00	AAPL	Stock	123.6909	123.76	122.84	123.18	5914860.0
2021-03-23 12:00:00	AAPL	Stock	123.175	123.36	122.66	122.9311	4211547.0
2021-03-23 12:30:00	AAPL	Stock	122.94	123.149	122.68	123.149	3172941.0
2021-03-23 13:00:00	AAPL	Stock	123.1499	123.615	123.11	123.2855	3508085.0
2021-03-23 13:30:00	AAPL	Stock	123.28	123.3	122.92	123.0498	3015613.0
2021-03-23 14:00:00	AAPL	Stock	123.045	123.345	122.95	123.295	3113202.0
2021-03-23 14:30:00	AAPL	Stock	123.29	123.43	122.52	122.5358	4389316.0
2021-03-23 15:00:00	AAPL	Stock	122.5213	122.82	122.35	122.52	5552781.0
2021-03-23 15:30:00	AAPL	Stock	122.51	122.69	122.14	122.535	8572195.0
2021-03-23 16:00:00	AAPL	Stock	122.54	122.69	122.51	122.58	8900663.0
2021-03-23 16:30:00	AAPL	Stock	122.56	122.69	122.51	122.66	42417.0
2021-03-23 17:00:00	AAPL	Stock	122.62	122.68	122.55	122.56	31966.0
2021-03-23 17:30:00	AAPL	Stock	122.56	122.63	122.56	122.58	22205.0
2021-03-23 18:00:00	AAPL	Stock	122.62	122.62	122.42	122.42	54866.0
2021-03-23 18:30:00	AAPL	Stock	122.47	122.56	122.3	122.41	275555.0
2021-03-23 19:00:00	AAPL	Stock	122.4	122.44	122.34	122.42	13999.0
2021-03-23 19:30:00	AAPL	Stock	122.38	122.45	122.31	122.45	48213.0
2021-03-23 04:00:00	MSFT	Stock	236.38	236.38	236.38	236.38	100.0
2021-03-23 04:30:00	MSFT	Stock	235.9	236.1	235.9	236.1	2506.0
2021-03-23 05:00:00	MSFT	Stock	235.56	235.56	235.5	235.5	700.0
2021-03-23 05:30:00	MSFT	Stock	235.18	235.2	235.01	235.01	7425.0
2021-03-23 06:00:00	MSFT	Stock	235.18	235.75	235.18	235.25	5611.0
2021-03-23 06:30:00	MSFT	Stock	235.75	236.15	235.75	236.15	421.0
2021-03-23 07:00:00	MSFT	Stock	235.93	236.3	235.58	236.2	2516.0
2021-03-23 07:30:00	MSFT	Stock	236.31	236.64	236.31	236.64	3495.0
2021-03-23 08:00:00	MSFT	Stock	235.93	236.65	235.401	236.3	16892.0
2021-03-23 08:30:00	MSFT	Stock	236.3	237.0	236.2	237.0	3641.0
2021-03-23 09:00:00	MSFT	Stock	236.95	237.5	236.65	237.37	25940.0
2021-03-23 09:30:00	MSFT	Stock	237.42	238.94	237.29	237.93	2474365.0
2021-03-23 10:00:00	MSFT	Stock	237.84	239.46	237.57	239.09	1678632.0
2021-03-23 10:30:00	MSFT	Stock	239.1	239.87	238.0075	239.86	1331179.0
2021-03-23 11:00:00	MSFT	Stock	239.83	241.05	239.76	240.58	1923760.0
2021-03-23 11:30:00	MSFT	Stock	240.58	240.92	239.85	240.12	1218495.0
2021-03-23 12:00:00	MSFT	Stock	240.16	240.55	238.95	239.765	1005311.0
2021-03-23 12:30:00	MSFT	Stock	239.76	240.04	239.27	240.01	803164.0

> showing 50 of 114,816 rows — these rows as CSV

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