PREVIEW / stock_30min / 2021-11-18

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-11-18.parquet
  size:    2.3 MB
  rows:    114,023
  symbols: 2,707

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-11-18 04:00:00	AAPL	Stock	153.71	154.4	153.71	154.22	18970.0
2021-11-18 04:30:00	AAPL	Stock	154.2	154.22	153.98	154.01	5898.0
2021-11-18 05:00:00	AAPL	Stock	154.01	154.07	153.81	153.81	9720.0
2021-11-18 05:30:00	AAPL	Stock	153.89	154.0	153.85	154.0	2504.0
2021-11-18 06:00:00	AAPL	Stock	153.97	153.97	153.8	153.83	10131.0
2021-11-18 06:30:00	AAPL	Stock	153.85	153.97	153.83	153.97	8894.0
2021-11-18 07:00:00	AAPL	Stock	153.94	153.98	153.82	153.82	41381.0
2021-11-18 07:30:00	AAPL	Stock	153.84	153.94	153.71	153.75	33693.0
2021-11-18 08:00:00	AAPL	Stock	153.9	153.99	153.107	153.85	198394.0
2021-11-18 08:30:00	AAPL	Stock	153.85	153.98	153.72	153.72	107700.0
2021-11-18 09:00:00	AAPL	Stock	153.71	153.95	153.6	153.65	183250.0
2021-11-18 09:30:00	AAPL	Stock	153.65	154.615	153.05	154.4199	8887452.0
2021-11-18 10:00:00	AAPL	Stock	154.415	154.58	153.56	154.17	5725683.0
2021-11-18 10:30:00	AAPL	Stock	154.175	154.49	153.98	154.16	4041877.0
2021-11-18 11:00:00	AAPL	Stock	154.15	154.44	153.88	154.07	2717380.0
2021-11-18 11:30:00	AAPL	Stock	154.07	154.87	154.06	154.63	4489790.0
2021-11-18 12:00:00	AAPL	Stock	154.63	156.54	154.54	156.4991	8676993.0
2021-11-18 12:30:00	AAPL	Stock	156.505	157.87	155.975	157.215	21279305.0
2021-11-18 13:00:00	AAPL	Stock	157.215	157.75	156.7	157.435	7362470.0
2021-11-18 13:30:00	AAPL	Stock	157.43	157.77	157.28	157.5012	4979095.0
2021-11-18 14:00:00	AAPL	Stock	157.5	158.4	157.3904	157.9367	8917480.0
2021-11-18 14:30:00	AAPL	Stock	157.931	158.0	157.37	157.64	4594979.0
2021-11-18 15:00:00	AAPL	Stock	157.64	157.98	157.6	157.9085	3762943.0
2021-11-18 15:30:00	AAPL	Stock	157.905	158.67	157.7	157.89	14178383.0
2021-11-18 16:00:00	AAPL	Stock	157.9	158.08	157.65	157.88	10470630.0
2021-11-18 16:30:00	AAPL	Stock	157.9	158.07	157.87	158.05	109556.0
2021-11-18 17:00:00	AAPL	Stock	158.07	158.28	157.76	157.78	178379.0
2021-11-18 17:30:00	AAPL	Stock	157.79	157.79	157.67	157.69	58984.0
2021-11-18 18:00:00	AAPL	Stock	157.73	157.86	157.68	157.86	46673.0
2021-11-18 18:30:00	AAPL	Stock	157.85	157.87	157.6	157.6	42936.0
2021-11-18 19:00:00	AAPL	Stock	157.59	157.77	157.58	157.64	30036.0
2021-11-18 19:30:00	AAPL	Stock	157.66	157.7499	157.6	157.73	37372.0
2021-11-18 04:00:00	MSFT	Stock	340.0	340.6	340.0	340.35	2612.0
2021-11-18 04:30:00	MSFT	Stock	340.38	340.38	340.3	340.3	935.0
2021-11-18 05:00:00	MSFT	Stock	340.19	340.19	339.89	339.89	320.0
2021-11-18 05:30:00	MSFT	Stock	340.2	340.2	340.0	340.05	599.0
2021-11-18 06:00:00	MSFT	Stock	340.01	340.02	339.52	340.02	2389.0
2021-11-18 06:30:00	MSFT	Stock	340.3	340.3	340.3	340.3	460.0
2021-11-18 07:00:00	MSFT	Stock	340.29	340.29	339.45	339.45	7675.0
2021-11-18 07:30:00	MSFT	Stock	339.45	339.45	339.03	339.06	4333.0
2021-11-18 08:00:00	MSFT	Stock	339.55	340.35	338.83	338.93	19041.0
2021-11-18 08:30:00	MSFT	Stock	339.01	339.39	338.5	339.12	1244097.0
2021-11-18 09:00:00	MSFT	Stock	338.5	339.1	337.63	337.93	27634.0
2021-11-18 09:30:00	MSFT	Stock	338.18	340.34	337.12	340.04	1639882.0
2021-11-18 10:00:00	MSFT	Stock	340.06	340.35	338.68	339.56	886268.0
2021-11-18 10:30:00	MSFT	Stock	339.615	340.155	339.33	339.37	608993.0
2021-11-18 11:00:00	MSFT	Stock	339.34	340.075	339.17	339.77	507967.0
2021-11-18 11:30:00	MSFT	Stock	339.75	342.09	339.75	341.48	893841.0
2021-11-18 12:00:00	MSFT	Stock	341.47	342.42	341.41	342.17	654597.0
2021-11-18 12:30:00	MSFT	Stock	342.18	342.45	340.32	340.8	692968.0

> showing 50 of 114,023 rows — these rows as CSV

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