PREVIEW / stock_30min / 2021-08-25

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-25.parquet
  size:    2.2 MB
  rows:    109,086
  symbols: 2,765

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-08-25 04:00:00	AAPL	Stock	149.72	150.18	149.69	150.0	16860.0
2021-08-25 04:30:00	AAPL	Stock	150.11	150.19	150.09	150.19	7300.0
2021-08-25 05:00:00	AAPL	Stock	150.06	150.16	150.04	150.12	1471.0
2021-08-25 05:30:00	AAPL	Stock	150.1	150.16	149.98	150.16	5484.0
2021-08-25 06:00:00	AAPL	Stock	150.05	150.16	149.99	149.99	12161.0
2021-08-25 06:30:00	AAPL	Stock	150.0	150.24	149.99	150.15	18413.0
2021-08-25 07:00:00	AAPL	Stock	150.08	150.14	149.69	149.74	88887.0
2021-08-25 07:30:00	AAPL	Stock	149.76	149.89	149.65	149.82	38894.0
2021-08-25 08:00:00	AAPL	Stock	149.8999	150.13	149.246	149.72	141227.0
2021-08-25 08:30:00	AAPL	Stock	149.79	149.99	149.7	149.99	102453.0
2021-08-25 09:00:00	AAPL	Stock	149.98	150.09	149.76	149.78	132200.0
2021-08-25 09:30:00	AAPL	Stock	149.82	150.32	149.15	149.3282	8157663.0
2021-08-25 10:00:00	AAPL	Stock	149.33	149.42	148.535	148.6202	5054808.0
2021-08-25 10:30:00	AAPL	Stock	148.625	148.735	148.12	148.4	5564761.0
2021-08-25 11:00:00	AAPL	Stock	148.4	148.715	148.33	148.505	3148497.0
2021-08-25 11:30:00	AAPL	Stock	148.5	148.548	148.17	148.25	2468451.0
2021-08-25 12:00:00	AAPL	Stock	148.2501	148.33	148.06	148.2397	2588937.0
2021-08-25 12:30:00	AAPL	Stock	148.237	148.44	148.16	148.3401	2154679.0
2021-08-25 13:00:00	AAPL	Stock	148.34	148.375	148.01	148.03	2410378.0
2021-08-25 13:30:00	AAPL	Stock	148.035	148.1	147.8	147.86	2754644.0
2021-08-25 14:00:00	AAPL	Stock	147.855	148.0899	147.82	148.03	2607072.0
2021-08-25 14:30:00	AAPL	Stock	148.03	148.37	148.0	148.27	2977544.0
2021-08-25 15:00:00	AAPL	Stock	148.26	148.43	148.215	148.37	2482457.0
2021-08-25 15:30:00	AAPL	Stock	148.3701	148.75	148.34	148.37	4797112.0
2021-08-25 16:00:00	AAPL	Stock	148.37	148.45	148.3	148.34	4983468.0
2021-08-25 16:30:00	AAPL	Stock	148.33	148.43	148.33	148.3765	20123.0
2021-08-25 17:00:00	AAPL	Stock	148.36	148.38	148.33	148.33	13570.0
2021-08-25 17:30:00	AAPL	Stock	148.34	148.37	148.32	148.3399	18079.0
2021-08-25 18:00:00	AAPL	Stock	148.34	148.35	148.3	148.33	3039.0
2021-08-25 18:30:00	AAPL	Stock	148.31	148.33	148.3	148.33	4255.0
2021-08-25 19:00:00	AAPL	Stock	148.34	148.36	148.32	148.32	7960.0
2021-08-25 19:30:00	AAPL	Stock	148.32	148.34	148.3	148.3	10527.0
2021-08-25 04:00:00	MSFT	Stock	303.09	303.09	303.09	303.09	200.0
2021-08-25 05:00:00	MSFT	Stock	303.19	303.2	303.18	303.2	760.0
2021-08-25 05:30:00	MSFT	Stock	303.35	303.35	303.3	303.3	495.0
2021-08-25 06:30:00	MSFT	Stock	303.38	303.38	303.2	303.2	17489.0
2021-08-25 07:00:00	MSFT	Stock	303.4	303.4	302.66	302.75	39032.0
2021-08-25 07:30:00	MSFT	Stock	302.65	303.3	302.65	303.25	11747.0
2021-08-25 08:00:00	MSFT	Stock	303.3454	303.4	302.94	303.26	24772.0
2021-08-25 08:30:00	MSFT	Stock	303.31	303.91	303.3	303.84	25060.0
2021-08-25 09:00:00	MSFT	Stock	303.92	304.65	303.6905	304.36	56703.0
2021-08-25 09:30:00	MSFT	Stock	304.4	304.59	301.12	302.035	2571495.0
2021-08-25 10:00:00	MSFT	Stock	302.04	302.37	301.33	301.87	1056409.0
2021-08-25 10:30:00	MSFT	Stock	301.84	302.3101	301.31	302.09	817643.0
2021-08-25 11:00:00	MSFT	Stock	302.0823	302.55	301.84	302.18	886945.0
2021-08-25 11:30:00	MSFT	Stock	302.18	302.18	301.33	301.3409	500710.0
2021-08-25 12:00:00	MSFT	Stock	301.35	301.52	301.11	301.49	486989.0
2021-08-25 12:30:00	MSFT	Stock	301.48	301.55	301.22	301.505	409465.0
2021-08-25 13:00:00	MSFT	Stock	301.51	301.54	300.8	300.84	678178.0
2021-08-25 13:30:00	MSFT	Stock	300.835	301.19	300.77	301.02	469803.0

> showing 50 of 109,086 rows — these rows as CSV

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