PREVIEW / stock_30min / 2022-01-07

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-01-07.parquet
  size:    2.2 MB
  rows:    107,386
  symbols: 2,602

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
2022-01-07 04:00:00	AAPL	Stock	171.5	172.09	171.31	172.09	14957.0
2022-01-07 04:30:00	AAPL	Stock	172.19	172.46	172.17	172.22	7348.0
2022-01-07 05:00:00	AAPL	Stock	172.3	172.7	172.16	172.7	9744.0
2022-01-07 05:30:00	AAPL	Stock	172.69	172.83	172.69	172.71	2640.0
2022-01-07 06:00:00	AAPL	Stock	172.72	172.95	172.57	172.94	4347.0
2022-01-07 06:30:00	AAPL	Stock	173.0	173.3	172.82	172.82	12238.0
2022-01-07 07:00:00	AAPL	Stock	172.85	173.09	172.56	172.83	43961.0
2022-01-07 07:30:00	AAPL	Stock	172.83	172.83	172.4	172.42	35159.0
2022-01-07 08:00:00	AAPL	Stock	172.75	173.72	172.2	172.39	276911.0
2022-01-07 08:30:00	AAPL	Stock	172.49	173.06	171.31	171.61	580287.0
2022-01-07 09:00:00	AAPL	Stock	171.61	173.2	171.61	172.9	433331.0
2022-01-07 09:30:00	AAPL	Stock	172.87	174.14	171.47	173.72	10102204.0
2022-01-07 10:00:00	AAPL	Stock	173.72	173.78	172.14	172.185	5789865.0
2022-01-07 10:30:00	AAPL	Stock	172.1973	172.59	171.03	171.4312	5684663.0
2022-01-07 11:00:00	AAPL	Stock	171.44	171.82	171.05	171.78	4091919.0
2022-01-07 11:30:00	AAPL	Stock	171.78	172.72	171.575	172.52	4071197.0
2022-01-07 12:00:00	AAPL	Stock	172.52	172.63	172.02	172.2	2842278.0
2022-01-07 12:30:00	AAPL	Stock	172.19	172.46	171.76	172.2808	2392530.0
2022-01-07 13:00:00	AAPL	Stock	172.285	172.6	172.07	172.17	2364593.0
2022-01-07 13:30:00	AAPL	Stock	172.16	172.55	172.05	172.29	2274116.0
2022-01-07 14:00:00	AAPL	Stock	172.2982	172.4509	171.87	172.13	2474376.0
2022-01-07 14:30:00	AAPL	Stock	172.12	173.1	172.06	173.095	3364613.0
2022-01-07 15:00:00	AAPL	Stock	173.09	173.6881	172.82	173.02	5224302.0
2022-01-07 15:30:00	AAPL	Stock	173.02	173.26	171.9	172.22	7379060.0
2022-01-07 16:00:00	AAPL	Stock	172.19	172.19	171.74	172.0	9171515.0
2022-01-07 16:30:00	AAPL	Stock	172.02	172.17	171.9	172.0	56537.0
2022-01-07 17:00:00	AAPL	Stock	172.01	172.04	171.91	171.99	21386.0
2022-01-07 17:30:00	AAPL	Stock	171.99	171.99	171.76	171.87	22988.0
2022-01-07 18:00:00	AAPL	Stock	171.86	172.05	171.82	172.0	18369.0
2022-01-07 18:30:00	AAPL	Stock	172.1	172.1	171.95	172.01	14744.0
2022-01-07 19:00:00	AAPL	Stock	172.01	172.1	172.01	172.1	13881.0
2022-01-07 19:30:00	AAPL	Stock	172.15	172.15	171.96	172.07	26005.0
2022-01-07 04:00:00	MSFT	Stock	313.5	314.48	312.89	314.48	6478.0
2022-01-07 04:30:00	MSFT	Stock	314.46	314.73	314.31	314.51	5280.0
2022-01-07 05:00:00	MSFT	Stock	314.95	314.95	314.95	314.95	146.0
2022-01-07 05:30:00	MSFT	Stock	315.47	315.48	315.46	315.46	923.0
2022-01-07 06:00:00	MSFT	Stock	315.33	315.88	315.02	315.74	2371.0
2022-01-07 06:30:00	MSFT	Stock	315.8	315.8	315.0	315.0	5214.0
2022-01-07 07:00:00	MSFT	Stock	315.02	315.8	314.82	315.38	14667.0
2022-01-07 07:30:00	MSFT	Stock	315.38	315.38	314.75	314.75	11463.0
2022-01-07 08:00:00	MSFT	Stock	315.7999	317.0188	314.61	315.0534	63964.0
2022-01-07 08:30:00	MSFT	Stock	315.09	316.0	312.0	313.1999	137800.0
2022-01-07 09:00:00	MSFT	Stock	313.18	315.4	313.18	314.15	79103.0
2022-01-07 09:30:00	MSFT	Stock	314.21	316.5	312.31	315.6733	2993381.0
2022-01-07 10:00:00	MSFT	Stock	315.715	316.14	312.5	312.82	1683969.0
2022-01-07 10:30:00	MSFT	Stock	312.845	313.52	310.09	310.91	1982255.0
2022-01-07 11:00:00	MSFT	Stock	310.93	312.66	310.82	312.55	1333643.0
2022-01-07 11:30:00	MSFT	Stock	312.53	314.45	312.1003	313.5543	1221269.0
2022-01-07 12:00:00	MSFT	Stock	313.58	313.75	312.49	313.1121	943646.0
2022-01-07 12:30:00	MSFT	Stock	313.08	313.85	312.33	313.7882	680046.0

> showing 50 of 107,386 rows — these rows as CSV

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