PREVIEW / stock_30min / 2021-02-23

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-02-23.parquet
  size:    2.5 MB
  rows:    127,818
  symbols: 2,839

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-02-23 04:00:00	AAPL	Stock	126.0	126.0	124.52	124.58	66924.0
2021-02-23 04:30:00	AAPL	Stock	124.51	124.72	123.99	124.2	92453.0
2021-02-23 05:00:00	AAPL	Stock	124.2	124.39	121.77	122.45	212558.0
2021-02-23 05:30:00	AAPL	Stock	122.29	123.0	121.58	122.42	152322.0
2021-02-23 06:00:00	AAPL	Stock	122.45	123.29	122.04	123.08	29790.0
2021-02-23 06:30:00	AAPL	Stock	123.01	123.5	122.62	123.36	62050.0
2021-02-23 07:00:00	AAPL	Stock	123.33	123.9	123.21	123.79	343979.0
2021-02-23 07:30:00	AAPL	Stock	123.75	123.78	123.23	123.62	216305.0
2021-02-23 08:00:00	AAPL	Stock	123.62	126.0	122.29	123.17	1424578.0
2021-02-23 08:30:00	AAPL	Stock	123.17	123.8	122.7	123.59	683748.0
2021-02-23 09:00:00	AAPL	Stock	123.58	123.9	123.0	123.77	698845.0
2021-02-23 09:30:00	AAPL	Stock	123.76	123.79	118.39	121.73	29694327.0
2021-02-23 10:00:00	AAPL	Stock	121.72	123.22	121.4	123.21	13287343.0
2021-02-23 10:30:00	AAPL	Stock	123.2	123.93	122.57	123.63	9298175.0
2021-02-23 11:00:00	AAPL	Stock	123.64	124.12	122.81	123.03	7872859.0
2021-02-23 11:30:00	AAPL	Stock	123.01	123.25	122.02	122.13	6263543.0
2021-02-23 12:00:00	AAPL	Stock	122.12	122.54	121.31	122.422	7653714.0
2021-02-23 12:30:00	AAPL	Stock	122.42	122.81	121.5	122.15	7466410.0
2021-02-23 13:00:00	AAPL	Stock	122.14	123.75	121.92	123.54	6382715.0
2021-02-23 13:30:00	AAPL	Stock	123.56	124.6	123.46	124.41	6581032.0
2021-02-23 14:00:00	AAPL	Stock	124.4	125.192	124.19	124.766	7142913.0
2021-02-23 14:30:00	AAPL	Stock	124.76	125.65	124.4	125.63	5704303.0
2021-02-23 15:00:00	AAPL	Stock	125.649	126.7	125.47	126.65	8558289.0
2021-02-23 15:30:00	AAPL	Stock	126.64	126.71	125.66	125.85	9250460.0
2021-02-23 16:00:00	AAPL	Stock	125.86	125.91	125.4	125.6	4887155.0
2021-02-23 16:30:00	AAPL	Stock	125.56	125.69	125.16	125.25	219133.0
2021-02-23 17:00:00	AAPL	Stock	125.25	125.74	125.25	125.6	159626.0
2021-02-23 17:30:00	AAPL	Stock	125.62	125.64	125.33	125.5	73033.0
2021-02-23 18:00:00	AAPL	Stock	125.54	125.79	125.29	125.34	85469.0
2021-02-23 18:30:00	AAPL	Stock	125.35	125.72	125.29	125.69	65310.0
2021-02-23 19:00:00	AAPL	Stock	125.69	125.87	125.1	125.2	160079.0
2021-02-23 19:30:00	AAPL	Stock	125.25	125.7	125.22	125.5	136595.0
2021-02-23 04:00:00	MSFT	Stock	234.7	234.7	232.1	232.1	3000.0
2021-02-23 04:30:00	MSFT	Stock	232.31	233.04	232.0	232.8	7603.0
2021-02-23 05:00:00	MSFT	Stock	232.63	233.18	230.05	231.05	20967.0
2021-02-23 05:30:00	MSFT	Stock	231.04	231.98	230.25	230.34	31662.0
2021-02-23 06:00:00	MSFT	Stock	230.25	230.9	230.06	230.79	9895.0
2021-02-23 06:30:00	MSFT	Stock	230.8	231.3	230.26	230.89	9216.0
2021-02-23 07:00:00	MSFT	Stock	230.94	231.0	230.21	230.7	34647.0
2021-02-23 07:30:00	MSFT	Stock	230.64	230.72	230.44	230.54	27684.0
2021-02-23 08:00:00	MSFT	Stock	230.6	231.0	229.9	230.35	69531.0
2021-02-23 08:30:00	MSFT	Stock	230.47	231.0	229.697	230.5	45746.0
2021-02-23 09:00:00	MSFT	Stock	230.75	231.09	229.77	230.2	58278.0
2021-02-23 09:30:00	MSFT	Stock	230.2	231.5	228.73	230.72	4467599.0
2021-02-23 10:00:00	MSFT	Stock	230.64	232.93	230.23	232.72	2346142.0
2021-02-23 10:30:00	MSFT	Stock	232.73	233.14	231.8	232.57	1561382.0
2021-02-23 11:00:00	MSFT	Stock	232.61	233.36	232.22	232.78	1339585.0
2021-02-23 11:30:00	MSFT	Stock	232.78	233.29	232.15	232.17	1039870.0
2021-02-23 12:00:00	MSFT	Stock	232.16	232.4	231.11	232.32	951737.0
2021-02-23 12:30:00	MSFT	Stock	232.29	232.55	229.99	230.03	1064945.0

> showing 50 of 127,818 rows — these rows as CSV

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