PREVIEW / stock_30min / 2021-02-01

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-02-01.parquet
  size:    2.3 MB
  rows:    119,423
  symbols: 2,748

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-01 04:00:00	AAPL	Stock	133.52	134.99	133.51	134.85	84869.0
2021-02-01 04:30:00	AAPL	Stock	134.79	135.0	134.46	134.8	55898.0
2021-02-01 05:00:00	AAPL	Stock	134.82	134.9	134.25	134.52	66107.0
2021-02-01 05:30:00	AAPL	Stock	134.53	134.59	134.05	134.31	24423.0
2021-02-01 06:00:00	AAPL	Stock	134.32	134.9	134.29	134.89	25106.0
2021-02-01 06:30:00	AAPL	Stock	134.89	134.92	134.01	134.45	27574.0
2021-02-01 07:00:00	AAPL	Stock	134.45	134.53	133.5	134.15	471914.0
2021-02-01 07:30:00	AAPL	Stock	134.14	134.3	133.78	133.91	182649.0
2021-02-01 08:00:00	AAPL	Stock	133.91	134.36	133.52	133.84	539899.0
2021-02-01 08:30:00	AAPL	Stock	133.85	134.14	133.82	133.94	274967.0
2021-02-01 09:00:00	AAPL	Stock	133.94	134.06	133.5	133.69	389228.0
2021-02-01 09:30:00	AAPL	Stock	133.69	134.8	130.93	132.3	15967610.0
2021-02-01 10:00:00	AAPL	Stock	132.27	133.29	131.2	133.09	8450488.0
2021-02-01 10:30:00	AAPL	Stock	133.116	133.84	132.46	132.97	7204173.0
2021-02-01 11:00:00	AAPL	Stock	132.961	134.1	132.29	134.03	6351516.0
2021-02-01 11:30:00	AAPL	Stock	134.021	134.43	133.65	133.77	5652601.0
2021-02-01 12:00:00	AAPL	Stock	133.77	134.93	133.76	134.92	5630332.0
2021-02-01 12:30:00	AAPL	Stock	134.93	134.95	134.31	134.82	4560098.0
2021-02-01 13:00:00	AAPL	Stock	134.83	135.38	134.63	134.89	5147101.0
2021-02-01 13:30:00	AAPL	Stock	134.892	135.12	134.27	134.738	4678880.0
2021-02-01 14:00:00	AAPL	Stock	134.74	134.775	133.96	134.41	3950208.0
2021-02-01 14:30:00	AAPL	Stock	134.41	134.57	133.88	134.23	3692333.0
2021-02-01 15:00:00	AAPL	Stock	134.23	134.57	134.18	134.43	3572195.0
2021-02-01 15:30:00	AAPL	Stock	134.43	134.84	134.04	134.1	8703512.0
2021-02-01 16:00:00	AAPL	Stock	134.14	134.22	133.81	133.91	7231314.0
2021-02-01 16:30:00	AAPL	Stock	133.9	134.03	133.67	134.0	115067.0
2021-02-01 17:00:00	AAPL	Stock	134.0	134.07	133.98	134.02	88527.0
2021-02-01 17:30:00	AAPL	Stock	134.02	134.15	133.98	134.12	48199.0
2021-02-01 18:00:00	AAPL	Stock	134.12	134.49	134.11	134.27	65596.0
2021-02-01 18:30:00	AAPL	Stock	134.31	134.35	134.25	134.31	62500.0
2021-02-01 19:00:00	AAPL	Stock	134.31	134.31	134.0	134.08	47547.0
2021-02-01 19:30:00	AAPL	Stock	134.08	134.25	133.95	134.05	86227.0
2021-02-01 04:00:00	MSFT	Stock	234.5	234.88	234.2	234.2	38815.0
2021-02-01 04:30:00	MSFT	Stock	234.2	234.53	233.8	234.44	30761.0
2021-02-01 05:00:00	MSFT	Stock	234.53	234.53	234.45	234.53	27229.0
2021-02-01 05:30:00	MSFT	Stock	234.45	234.67	234.33	234.45	13237.0
2021-02-01 06:00:00	MSFT	Stock	234.53	234.82	234.53	234.82	46687.0
2021-02-01 06:30:00	MSFT	Stock	234.85	235.1	234.43	234.95	31974.0
2021-02-01 07:00:00	MSFT	Stock	235.0	235.06	234.1	234.3	76165.0
2021-02-01 07:30:00	MSFT	Stock	234.32	234.95	234.32	234.42	38359.0
2021-02-01 08:00:00	MSFT	Stock	234.62	235.03	231.39	234.67	46133.0
2021-02-01 08:30:00	MSFT	Stock	234.65	235.08	234.6	235.0	34582.0
2021-02-01 09:00:00	MSFT	Stock	235.07	235.6	234.26	235.18	75319.0
2021-02-01 09:30:00	MSFT	Stock	235.09	235.65	232.43	233.74	3166948.0
2021-02-01 10:00:00	MSFT	Stock	233.66	235.25	233.04	235.0	1345803.0
2021-02-01 10:30:00	MSFT	Stock	235.03	237.6	235.03	236.74	2378716.0
2021-02-01 11:00:00	MSFT	Stock	236.75	238.03	235.95	237.98	1414598.0
2021-02-01 11:30:00	MSFT	Stock	237.97	240.28	237.96	239.88	2511135.0
2021-02-01 12:00:00	MSFT	Stock	239.88	242.5	239.88	242.468	2375286.0
2021-02-01 12:30:00	MSFT	Stock	242.47	242.5	240.52	241.25	1518192.0

> showing 50 of 119,423 rows — these rows as CSV

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