PREVIEW / stock_30min / 2022-04-27

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-04-27.parquet
  size:    2.2 MB
  rows:    107,652
  symbols: 2,510

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-04-27 04:00:00	AAPL	Stock	157.2	158.4	156.69	158.07	61834.0
2022-04-27 04:30:00	AAPL	Stock	158.14	158.16	157.4	157.8	18763.0
2022-04-27 05:00:00	AAPL	Stock	157.85	157.86	157.52	157.7	15700.0
2022-04-27 05:30:00	AAPL	Stock	157.72	157.87	157.7	157.87	18875.0
2022-04-27 06:00:00	AAPL	Stock	157.91	157.95	157.7	157.7	13325.0
2022-04-27 06:30:00	AAPL	Stock	157.69	158.12	157.5	157.91	24834.0
2022-04-27 07:00:00	AAPL	Stock	157.84	158.0	156.13	156.13	121166.0
2022-04-27 07:30:00	AAPL	Stock	156.19	156.73	156.09	156.51	127640.0
2022-04-27 08:00:00	AAPL	Stock	157.5	158.0	156.02	156.52	274787.0
2022-04-27 08:30:00	AAPL	Stock	156.5	156.9	156.03	156.09	155538.0
2022-04-27 09:00:00	AAPL	Stock	156.14	156.36	155.1	155.93	274618.0
2022-04-27 09:30:00	AAPL	Stock	155.92	158.9293	155.46	158.091	9310432.0
2022-04-27 10:00:00	AAPL	Stock	158.1022	158.39	155.67	155.72	6078361.0
2022-04-27 10:30:00	AAPL	Stock	155.71	157.645	155.38	157.3506	5926791.0
2022-04-27 11:00:00	AAPL	Stock	157.37	158.41	157.3375	157.85	5328625.0
2022-04-27 11:30:00	AAPL	Stock	157.87	158.6699	157.42	157.62	4123295.0
2022-04-27 12:00:00	AAPL	Stock	157.64	159.72	157.0	159.51	4233281.0
2022-04-27 12:30:00	AAPL	Stock	159.51	159.79	158.8	159.0447	3273944.0
2022-04-27 13:00:00	AAPL	Stock	159.05	159.1081	157.981	158.89	3529056.0
2022-04-27 13:30:00	AAPL	Stock	158.89	159.03	158.28	158.95	2804912.0
2022-04-27 14:00:00	AAPL	Stock	158.945	159.0	157.57	157.59	3108764.0
2022-04-27 14:30:00	AAPL	Stock	157.58	158.21	156.5	156.75	3484625.0
2022-04-27 15:00:00	AAPL	Stock	156.7564	156.98	156.27	156.74	4517404.0
2022-04-27 15:30:00	AAPL	Stock	156.73	157.39	156.17	156.6	8634729.0
2022-04-27 16:00:00	AAPL	Stock	156.52	158.0	156.4	157.93	6342079.0
2022-04-27 16:30:00	AAPL	Stock	157.94	158.7	156.57	158.4	256590.0
2022-04-27 17:00:00	AAPL	Stock	158.58	158.85	158.25	158.85	144096.0
2022-04-27 17:30:00	AAPL	Stock	158.79	159.4	158.75	159.08	120384.0
2022-04-27 18:00:00	AAPL	Stock	159.06	159.1	158.61	158.95	74098.0
2022-04-27 18:30:00	AAPL	Stock	158.88	158.95	158.51	158.61	37853.0
2022-04-27 19:00:00	AAPL	Stock	158.55	158.75	158.53	158.6	26666.0
2022-04-27 19:30:00	AAPL	Stock	158.61	158.95	158.5	158.77	47840.0
2022-04-27 04:00:00	MSFT	Stock	284.67	285.54	283.0	284.86	41723.0
2022-04-27 04:30:00	MSFT	Stock	284.72	284.8	283.66	284.77	21821.0
2022-04-27 05:00:00	MSFT	Stock	284.35	285.0	283.98	284.99	9291.0
2022-04-27 05:30:00	MSFT	Stock	285.0	285.29	284.37	284.85	11620.0
2022-04-27 06:00:00	MSFT	Stock	284.83	285.05	284.1	284.12	9358.0
2022-04-27 06:30:00	MSFT	Stock	284.1	284.9	283.51	284.73	21640.0
2022-04-27 07:00:00	MSFT	Stock	284.7	284.9	279.76	280.7	120258.0
2022-04-27 07:30:00	MSFT	Stock	280.5	281.5	279.05	279.73	102347.0
2022-04-27 08:00:00	MSFT	Stock	282.5812	285.0	278.57	279.66	187769.0
2022-04-27 08:30:00	MSFT	Stock	279.07	282.0	279.07	281.4	158888.0
2022-04-27 09:00:00	MSFT	Stock	281.5	282.95	279.6	282.15	288248.0
2022-04-27 09:30:00	MSFT	Stock	282.29	286.49	279.92	285.04	8187296.0
2022-04-27 10:00:00	MSFT	Stock	285.09	285.19	279.16	282.0	5191147.0
2022-04-27 10:30:00	MSFT	Stock	281.985	287.2	281.405	285.62	4228888.0
2022-04-27 11:00:00	MSFT	Stock	285.615	289.14	285.497	288.2661	3830001.0
2022-04-27 11:30:00	MSFT	Stock	288.27	289.13	285.8013	286.055	2528871.0
2022-04-27 12:00:00	MSFT	Stock	286.085	290.24	284.94	289.84	2787504.0
2022-04-27 12:30:00	MSFT	Stock	289.86	290.97	288.7	288.93	2236200.0

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

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