PREVIEW / stock_30min / 2021-09-20

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-09-20.parquet
  size:    2.3 MB
  rows:    116,687
  symbols: 2,708

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-20 04:00:00	AAPL	Stock	144.96	144.96	144.2	144.35	62889.0
2021-09-20 04:30:00	AAPL	Stock	144.35	144.59	144.2	144.24	30834.0
2021-09-20 05:00:00	AAPL	Stock	144.23	144.32	144.0	144.18	30292.0
2021-09-20 05:30:00	AAPL	Stock	144.15	144.2	143.89	144.08	53036.0
2021-09-20 06:00:00	AAPL	Stock	144.1	144.4	144.09	144.36	20126.0
2021-09-20 06:30:00	AAPL	Stock	144.31	144.4	144.15	144.23	30470.0
2021-09-20 07:00:00	AAPL	Stock	144.23	144.37	143.83	143.9	649053.0
2021-09-20 07:30:00	AAPL	Stock	143.86	143.86	143.55	143.73	275288.0
2021-09-20 08:00:00	AAPL	Stock	143.73	144.38	143.15	143.2	641782.0
2021-09-20 08:30:00	AAPL	Stock	143.2	143.49	142.96	143.45	469689.0
2021-09-20 09:00:00	AAPL	Stock	143.44	143.91	143.25	143.86	587419.0
2021-09-20 09:30:00	AAPL	Stock	143.86	144.84	143.06	143.84	15418127.0
2021-09-20 10:00:00	AAPL	Stock	143.85	143.96	142.48	142.94	9786106.0
2021-09-20 10:30:00	AAPL	Stock	142.93	143.09	142.48	142.75	5531041.0
2021-09-20 11:00:00	AAPL	Stock	142.73	143.325	142.51	143.0899	4982534.0
2021-09-20 11:30:00	AAPL	Stock	143.0899	143.175	142.48	142.5	4280487.0
2021-09-20 12:00:00	AAPL	Stock	142.497	142.74	142.1	142.43	6496909.0
2021-09-20 12:30:00	AAPL	Stock	142.42	142.479	142.09	142.2079	4568684.0
2021-09-20 13:00:00	AAPL	Stock	142.209	142.3955	141.85	142.35	5515595.0
2021-09-20 13:30:00	AAPL	Stock	142.355	142.64	142.25	142.36	3853879.0
2021-09-20 14:00:00	AAPL	Stock	142.36	142.48	141.64	141.6501	5165428.0
2021-09-20 14:30:00	AAPL	Stock	141.66	141.86	141.27	141.5	6574019.0
2021-09-20 15:00:00	AAPL	Stock	141.49	142.02	141.34	142.0175	6100142.0
2021-09-20 15:30:00	AAPL	Stock	142.01	143.12	141.9312	142.97	12650002.0
2021-09-20 16:00:00	AAPL	Stock	142.985	143.11	142.69	142.87	10660993.0
2021-09-20 16:30:00	AAPL	Stock	142.9	143.0	142.77	142.9	73074.0
2021-09-20 17:00:00	AAPL	Stock	142.89	143.09	142.8	143.01	49029.0
2021-09-20 17:30:00	AAPL	Stock	143.0	143.05	142.9	142.91	35172.0
2021-09-20 18:00:00	AAPL	Stock	142.9	143.02	142.89	143.02	37491.0
2021-09-20 18:30:00	AAPL	Stock	143.02	143.02	142.88	142.88	19915.0
2021-09-20 19:00:00	AAPL	Stock	142.88	142.91	142.76	142.78	25058.0
2021-09-20 19:30:00	AAPL	Stock	142.8	143.09	142.67	142.99	90173.0
2021-09-20 04:00:00	MSFT	Stock	297.96	297.96	296.13	296.99	13450.0
2021-09-20 04:30:00	MSFT	Stock	297.07	297.57	296.89	297.15	4618.0
2021-09-20 05:00:00	MSFT	Stock	297.03	297.29	296.81	297.22	1793.0
2021-09-20 05:30:00	MSFT	Stock	297.2	297.2	296.51	296.8	5921.0
2021-09-20 06:00:00	MSFT	Stock	296.8	297.3	296.8	297.3	5586.0
2021-09-20 06:30:00	MSFT	Stock	297.26	297.59	296.82	296.94	9869.0
2021-09-20 07:00:00	MSFT	Stock	296.83	297.25	296.06	296.1	68664.0
2021-09-20 07:30:00	MSFT	Stock	296.12	296.55	295.67	296.02	68685.0
2021-09-20 08:00:00	MSFT	Stock	296.511	297.08	295.3	295.85	67577.0
2021-09-20 08:30:00	MSFT	Stock	295.95	296.55	295.6	296.0	64335.0
2021-09-20 09:00:00	MSFT	Stock	295.9	297.28	295.7	296.6	108966.0
2021-09-20 09:30:00	MSFT	Stock	296.33	298.72	295.19	296.9	3063835.0
2021-09-20 10:00:00	MSFT	Stock	296.89	297.06	294.86	295.67	1769945.0
2021-09-20 10:30:00	MSFT	Stock	295.67	295.936	293.95	294.24	1329127.0
2021-09-20 11:00:00	MSFT	Stock	294.2	295.16	293.91	295.11	1128616.0
2021-09-20 11:30:00	MSFT	Stock	295.12	295.26	293.26	293.29	1061027.0
2021-09-20 12:00:00	MSFT	Stock	293.3	293.52	292.6401	293.12	1168739.0
2021-09-20 12:30:00	MSFT	Stock	293.11	293.26	292.41	292.774	859796.0

> showing 50 of 116,687 rows — these rows as CSV

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