PREVIEW / stock_30min / 2021-08-19

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-08-19.parquet
  size:    2.2 MB
  rows:    113,089
  symbols: 2,801

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-19 04:00:00	AAPL	Stock	145.66	145.66	144.38	144.39	46957.0
2021-08-19 04:30:00	AAPL	Stock	144.5	144.68	144.24	144.62	38440.0
2021-08-19 05:00:00	AAPL	Stock	144.61	144.83	144.46	144.75	34896.0
2021-08-19 05:30:00	AAPL	Stock	144.75	145.46	144.75	145.3	35227.0
2021-08-19 06:00:00	AAPL	Stock	145.42	145.65	145.13	145.38	20166.0
2021-08-19 06:30:00	AAPL	Stock	145.28	145.36	145.0	145.09	15552.0
2021-08-19 07:00:00	AAPL	Stock	145.1	145.3	144.56	144.66	206510.0
2021-08-19 07:30:00	AAPL	Stock	144.66	145.05	144.62	144.75	127444.0
2021-08-19 08:00:00	AAPL	Stock	144.75	145.48	144.57	145.27	420602.0
2021-08-19 08:30:00	AAPL	Stock	145.22	145.28	144.65	144.68	354519.0
2021-08-19 09:00:00	AAPL	Stock	144.68	145.34	144.6	145.06	480756.0
2021-08-19 09:30:00	AAPL	Stock	145.07	146.2899	144.5	145.11	13442148.0
2021-08-19 10:00:00	AAPL	Stock	145.11	146.2499	145.1	146.05	6585501.0
2021-08-19 10:30:00	AAPL	Stock	146.04	146.52	145.5201	146.3713	4777824.0
2021-08-19 11:00:00	AAPL	Stock	146.379	146.72	146.19	146.4299	4210966.0
2021-08-19 11:30:00	AAPL	Stock	146.435	147.67	146.42	147.62	5261557.0
2021-08-19 12:00:00	AAPL	Stock	147.62	147.75	147.22	147.445	3853686.0
2021-08-19 12:30:00	AAPL	Stock	147.445	148.0	147.44	147.623	3477515.0
2021-08-19 13:00:00	AAPL	Stock	147.625	147.75	146.96	146.9609	3588388.0
2021-08-19 13:30:00	AAPL	Stock	146.9686	147.24	146.7	146.81	3410600.0
2021-08-19 14:00:00	AAPL	Stock	146.81	146.96	146.06	146.09	3772373.0
2021-08-19 14:30:00	AAPL	Stock	146.08	146.86	145.84	146.835	4546596.0
2021-08-19 15:00:00	AAPL	Stock	146.83	147.24	146.8	147.23	3938160.0
2021-08-19 15:30:00	AAPL	Stock	147.224	147.3	146.35	146.67	6594223.0
2021-08-19 16:00:00	AAPL	Stock	146.7	146.85	146.43	146.71	8017784.0
2021-08-19 16:30:00	AAPL	Stock	146.71	146.73	146.65	146.67	432215.0
2021-08-19 17:00:00	AAPL	Stock	146.68	146.74	146.67	146.68	11648.0
2021-08-19 17:30:00	AAPL	Stock	146.69	146.7	146.65	146.65	4369.0
2021-08-19 18:00:00	AAPL	Stock	146.65	146.75	146.65	146.75	9917.0
2021-08-19 18:30:00	AAPL	Stock	146.75	146.75	146.63	146.7	8754.0
2021-08-19 19:00:00	AAPL	Stock	146.68	146.71	146.65	146.69	6602.0
2021-08-19 19:30:00	AAPL	Stock	146.69	146.7	146.56	146.56	41756.0
2021-08-19 04:00:00	MSFT	Stock	289.4	289.56	287.25	287.48	19628.0
2021-08-19 04:30:00	MSFT	Stock	287.57	287.8	287.35	287.79	5713.0
2021-08-19 05:00:00	MSFT	Stock	287.6	288.44	287.48	288.44	6363.0
2021-08-19 05:30:00	MSFT	Stock	288.4	289.4	288.4	289.0	9144.0
2021-08-19 06:00:00	MSFT	Stock	288.97	289.47	288.96	289.4	4236.0
2021-08-19 06:30:00	MSFT	Stock	288.91	288.91	288.22	288.22	1495.0
2021-08-19 07:00:00	MSFT	Stock	288.61	288.76	288.26	288.6	17229.0
2021-08-19 07:30:00	MSFT	Stock	288.69	289.15	288.25	288.39	15957.0
2021-08-19 08:00:00	MSFT	Stock	288.361	291.456	288.26	289.0	38551.0
2021-08-19 08:30:00	MSFT	Stock	289.0	290.73	288.35	288.35	900197.0
2021-08-19 09:00:00	MSFT	Stock	288.38	289.5	288.38	288.86	33700.0
2021-08-19 09:30:00	MSFT	Stock	288.89	291.64	288.64	290.76	2227873.0
2021-08-19 10:00:00	MSFT	Stock	290.77	291.91	290.69	291.75	1036723.0
2021-08-19 10:30:00	MSFT	Stock	291.7699	292.9	291.19	292.8	989258.0
2021-08-19 11:00:00	MSFT	Stock	292.8	293.82	292.55	293.42	980173.0
2021-08-19 11:30:00	MSFT	Stock	293.41	294.65	293.41	294.43	852873.0
2021-08-19 12:00:00	MSFT	Stock	294.47	296.64	294.465	295.19	2757160.0
2021-08-19 12:30:00	MSFT	Stock	295.19	296.89	295.11	296.79	1355574.0

> showing 50 of 113,089 rows — these rows as CSV

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