PREVIEW / stock_30min / 2021-09-08

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-08.parquet
  size:    2.2 MB
  rows:    108,642
  symbols: 2,696

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-09-08 04:00:00	AAPL	Stock	156.45	156.72	156.0	156.14	18497.0
2021-09-08 04:30:00	AAPL	Stock	156.25	156.44	156.19	156.27	5445.0
2021-09-08 05:00:00	AAPL	Stock	156.3	156.39	156.24	156.25	4566.0
2021-09-08 05:30:00	AAPL	Stock	156.4	156.69	156.4	156.69	5050.0
2021-09-08 06:00:00	AAPL	Stock	156.69	156.69	156.63	156.64	3607.0
2021-09-08 06:30:00	AAPL	Stock	156.73	156.75	156.7	156.75	5433.0
2021-09-08 07:00:00	AAPL	Stock	156.71	157.039	156.61	156.95	65410.0
2021-09-08 07:30:00	AAPL	Stock	156.96	157.07	156.93	156.97	62607.0
2021-09-08 08:00:00	AAPL	Stock	156.7499	157.06	156.66	156.92	256585.0
2021-09-08 08:30:00	AAPL	Stock	156.94	157.09	156.92	157.06	137645.0
2021-09-08 09:00:00	AAPL	Stock	157.06	157.19	156.95	156.98	153351.0
2021-09-08 09:30:00	AAPL	Stock	156.98	157.04	155.49	155.96	12107845.0
2021-09-08 10:00:00	AAPL	Stock	155.96	156.07	155.285	155.44	5597289.0
2021-09-08 10:30:00	AAPL	Stock	155.45	155.56	153.975	154.12	7552792.0
2021-09-08 11:00:00	AAPL	Stock	154.1108	155.14	154.08	155.035	5890509.0
2021-09-08 11:30:00	AAPL	Stock	155.0378	155.05	154.22	154.3201	4072336.0
2021-09-08 12:00:00	AAPL	Stock	154.32	154.8814	154.11	154.76	3701188.0
2021-09-08 12:30:00	AAPL	Stock	154.76	154.7909	154.2999	154.3301	2623461.0
2021-09-08 13:00:00	AAPL	Stock	154.33	154.655	154.27	154.555	2423652.0
2021-09-08 13:30:00	AAPL	Stock	154.55	155.04	154.54	154.705	2781745.0
2021-09-08 14:00:00	AAPL	Stock	154.7083	155.1	154.699	154.81	2749466.0
2021-09-08 14:30:00	AAPL	Stock	154.81	154.83	154.62	154.7401	2089269.0
2021-09-08 15:00:00	AAPL	Stock	154.745	154.97	154.65	154.835	2329256.0
2021-09-08 15:30:00	AAPL	Stock	154.835	155.13	154.6	155.1199	5014512.0
2021-09-08 16:00:00	AAPL	Stock	155.12	155.12	154.93	155.0	6034280.0
2021-09-08 16:30:00	AAPL	Stock	154.99	155.09	154.98	155.06	14487.0
2021-09-08 17:00:00	AAPL	Stock	155.08	155.14	155.06	155.11	28378.0
2021-09-08 17:30:00	AAPL	Stock	155.11	155.11	155.04	155.1	7460.0
2021-09-08 18:00:00	AAPL	Stock	155.1	155.11	155.04	155.04	18629.0
2021-09-08 18:30:00	AAPL	Stock	155.04	155.06	154.9701	154.9701	14083.0
2021-09-08 19:00:00	AAPL	Stock	154.97	155.0	154.95	155.0	14858.0
2021-09-08 19:30:00	AAPL	Stock	155.0	155.04	154.94	155.0	26156.0
2021-09-08 04:00:00	MSFT	Stock	299.5	299.5	299.22	299.22	300.0
2021-09-08 04:30:00	MSFT	Stock	299.8	299.8	299.8	299.8	346.0
2021-09-08 05:00:00	MSFT	Stock	299.74	299.8	299.69	299.8	400.0
2021-09-08 05:30:00	MSFT	Stock	300.0	300.0	300.0	300.0	354.0
2021-09-08 06:00:00	MSFT	Stock	300.0	300.0	299.8	299.8	986.0
2021-09-08 06:30:00	MSFT	Stock	299.87	299.87	299.87	299.87	183.0
2021-09-08 07:00:00	MSFT	Stock	299.95	300.12	299.95	300.0	4465.0
2021-09-08 07:30:00	MSFT	Stock	299.8	299.85	299.61	299.85	1822.0
2021-09-08 08:00:00	MSFT	Stock	299.95	300.08	299.7	299.71	10444.0
2021-09-08 08:30:00	MSFT	Stock	299.6	299.87	299.6	299.75	2078.0
2021-09-08 09:00:00	MSFT	Stock	299.75	300.08	299.5003	299.77	10275.0
2021-09-08 09:30:00	MSFT	Stock	299.73	300.61	298.55	299.02	1428205.0
2021-09-08 10:00:00	MSFT	Stock	299.02	299.56	298.64	299.06	689425.0
2021-09-08 10:30:00	MSFT	Stock	299.08	299.08	297.4651	297.786	1103509.0
2021-09-08 11:00:00	MSFT	Stock	297.77	298.89	297.75	298.67	646757.0
2021-09-08 11:30:00	MSFT	Stock	298.67	298.745	297.79	298.18	478503.0
2021-09-08 12:00:00	MSFT	Stock	298.18	299.18	297.96	299.1199	529630.0
2021-09-08 12:30:00	MSFT	Stock	299.14	299.18	298.6301	298.6801	345412.0

> showing 50 of 108,642 rows — these rows as CSV

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