PREVIEW / stock_30min / 2023-04-12

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-12.parquet
  size:    2.0 MB
  rows:    100,703
  symbols: 1,760

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
2023-04-12 04:00:00	AAPL	Stock	160.7	160.86	160.7	160.86	5985.0
2023-04-12 04:30:00	AAPL	Stock	160.82	160.95	160.82	160.85	14834.0
2023-04-12 05:00:00	AAPL	Stock	160.9	160.9	160.82	160.88	4881.0
2023-04-12 05:30:00	AAPL	Stock	160.89	160.9	160.86	160.9	2722.0
2023-04-12 06:00:00	AAPL	Stock	160.98	161.1	160.98	161.1	2828.0
2023-04-12 06:30:00	AAPL	Stock	160.88	160.89	160.62	160.62	6890.0
2023-04-12 07:00:00	AAPL	Stock	160.63	160.8	160.63	160.64	4827.0
2023-04-12 07:30:00	AAPL	Stock	160.62	160.92	160.62	160.91	2996.0
2023-04-12 08:00:00	AAPL	Stock	160.621	160.8996	160.398	160.68	51208.0
2023-04-12 08:30:00	AAPL	Stock	160.85	162.3	160.85	161.59	376600.0
2023-04-12 09:00:00	AAPL	Stock	161.6	161.94	160.97	161.19	263555.0
2023-04-12 09:30:00	AAPL	Stock	161.22	162.06	160.49	160.98	5903566.0
2023-04-12 10:00:00	AAPL	Stock	160.97	161.94	160.76	161.915	3551793.0
2023-04-12 10:30:00	AAPL	Stock	161.92	162.05	160.66	160.66	3140256.0
2023-04-12 11:00:00	AAPL	Stock	160.66	161.0	160.265	160.96	2535719.0
2023-04-12 11:30:00	AAPL	Stock	160.95	161.6582	160.81	161.565	2128442.0
2023-04-12 12:00:00	AAPL	Stock	161.57	161.72	161.4102	161.48	1947030.0
2023-04-12 12:30:00	AAPL	Stock	161.48	161.68	161.36	161.54	1353216.0
2023-04-12 13:00:00	AAPL	Stock	161.54	161.8019	161.2707	161.53	1534017.0
2023-04-12 13:30:00	AAPL	Stock	161.54	161.65	161.23	161.3201	1125342.0
2023-04-12 14:00:00	AAPL	Stock	161.32	161.74	160.77	160.91	2306230.0
2023-04-12 14:30:00	AAPL	Stock	160.91	160.91	160.41	160.785	2418469.0
2023-04-12 15:00:00	AAPL	Stock	160.7704	160.98	159.78	159.85	3082532.0
2023-04-12 15:30:00	AAPL	Stock	159.845	160.346	159.78	160.13	5370956.0
2023-04-12 16:00:00	AAPL	Stock	160.13	160.34	160.01	160.02	5439929.0
2023-04-12 16:30:00	AAPL	Stock	160.02	160.1	160.01	160.06	37063.0
2023-04-12 17:00:00	AAPL	Stock	160.03	160.04	159.94	159.96	10338.0
2023-04-12 17:30:00	AAPL	Stock	159.96	160.0	159.95	159.96	4997.0
2023-04-12 18:00:00	AAPL	Stock	159.98	160.0	159.88	159.93	12044.0
2023-04-12 18:30:00	AAPL	Stock	159.9	159.9478	159.75	159.76	24669.0
2023-04-12 19:00:00	AAPL	Stock	159.85	159.99	159.78	159.96	7011.0
2023-04-12 19:30:00	AAPL	Stock	159.96	159.98	159.75	159.8	10456.0
2023-04-12 04:00:00	MSFT	Stock	282.69	283.23	282.69	283.23	1662.0
2023-04-12 05:00:00	MSFT	Stock	283.0	283.02	282.9	282.9	2078.0
2023-04-12 05:30:00	MSFT	Stock	283.08	283.23	283.08	283.1	1253.0
2023-04-12 06:00:00	MSFT	Stock	283.23	283.23	283.01	283.15	446.0
2023-04-12 06:30:00	MSFT	Stock	283.15	283.27	283.03	283.05	2371.0
2023-04-12 07:00:00	MSFT	Stock	283.13	283.13	282.6	282.7	4836.0
2023-04-12 07:30:00	MSFT	Stock	282.87	283.5	282.87	283.4	7775.0
2023-04-12 08:00:00	MSFT	Stock	283.7	283.8165	282.5	282.5	38316.0
2023-04-12 08:30:00	MSFT	Stock	283.5	287.3799	283.33	285.24	170261.0
2023-04-12 09:00:00	MSFT	Stock	285.0038	285.3	283.82	284.79	107495.0
2023-04-12 09:30:00	MSFT	Stock	284.79	285.989	281.96	283.3801	2983161.0
2023-04-12 10:00:00	MSFT	Stock	283.37	285.86	283.27	285.78	1903656.0
2023-04-12 10:30:00	MSFT	Stock	285.7675	286.05	283.28	283.28	1566979.0
2023-04-12 11:00:00	MSFT	Stock	283.29	284.53	283.03	284.4499	1157329.0
2023-04-12 11:30:00	MSFT	Stock	284.45	285.25	284.12	285.071	775781.0
2023-04-12 12:00:00	MSFT	Stock	285.07	285.66	284.91	285.24	546104.0
2023-04-12 12:30:00	MSFT	Stock	285.24	286.03	285.02	285.95	658330.0
2023-04-12 13:00:00	MSFT	Stock	285.95	286.77	285.38	286.6	847858.0

> showing 50 of 100,703 rows — these rows as CSV

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