PREVIEW / stock_30min / 2023-04-06

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-04-06.parquet
  size:    2.0 MB
  rows:    98,675
  symbols: 1,733

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-06 04:00:00	AAPL	Stock	161.79	163.6	160.18	162.96	30867.0
2023-04-06 04:30:00	AAPL	Stock	162.93	162.94	162.66	162.74	6713.0
2023-04-06 05:00:00	AAPL	Stock	162.71	162.82	162.65	162.76	5548.0
2023-04-06 05:30:00	AAPL	Stock	162.8	162.82	162.29	162.29	11836.0
2023-04-06 06:00:00	AAPL	Stock	162.31	162.5	162.1	162.5	10997.0
2023-04-06 06:30:00	AAPL	Stock	162.49	162.73	162.49	162.71	10067.0
2023-04-06 07:00:00	AAPL	Stock	162.66	162.99	162.66	162.78	26228.0
2023-04-06 07:30:00	AAPL	Stock	162.8	163.0	162.8	162.91	8673.0
2023-04-06 08:00:00	AAPL	Stock	162.7607	163.0	162.2315	162.6	100437.0
2023-04-06 08:30:00	AAPL	Stock	162.6	162.66	162.26	162.36	97948.0
2023-04-06 09:00:00	AAPL	Stock	162.36	162.48	161.92	162.4	98792.0
2023-04-06 09:30:00	AAPL	Stock	162.4	162.74	162.0	162.685	5087291.0
2023-04-06 10:00:00	AAPL	Stock	162.69	163.33	162.54	163.32	3212851.0
2023-04-06 10:30:00	AAPL	Stock	163.3168	163.5899	163.1	163.2739	2902752.0
2023-04-06 11:00:00	AAPL	Stock	163.28	164.37	163.18	164.2318	2894202.0
2023-04-06 11:30:00	AAPL	Stock	164.24	164.75	164.01	164.53	2527835.0
2023-04-06 12:00:00	AAPL	Stock	164.53	164.9584	164.405	164.58	2054416.0
2023-04-06 12:30:00	AAPL	Stock	164.58	164.87	164.4126	164.475	1639224.0
2023-04-06 13:00:00	AAPL	Stock	164.475	164.605	164.3	164.34	1500572.0
2023-04-06 13:30:00	AAPL	Stock	164.34	164.81	164.34	164.81	1766386.0
2023-04-06 14:00:00	AAPL	Stock	164.81	164.87	164.555	164.81	1345463.0
2023-04-06 14:30:00	AAPL	Stock	164.81	164.94	164.6	164.65	1388858.0
2023-04-06 15:00:00	AAPL	Stock	164.65	164.825	164.47	164.515	1883191.0
2023-04-06 15:30:00	AAPL	Stock	164.52	164.7599	164.32	164.65	3815339.0
2023-04-06 16:00:00	AAPL	Stock	164.65	164.7	164.57	164.62	6283740.0
2023-04-06 16:30:00	AAPL	Stock	164.64	164.66	164.55	164.6	22330.0
2023-04-06 17:00:00	AAPL	Stock	164.5999	164.66	164.58	164.6	20874.0
2023-04-06 17:30:00	AAPL	Stock	164.62	164.62	164.57	164.58	6404.0
2023-04-06 18:00:00	AAPL	Stock	164.5799	164.59	164.51	164.59	15646.0
2023-04-06 18:30:00	AAPL	Stock	164.54	164.6	164.52	164.52	5824.0
2023-04-06 19:00:00	AAPL	Stock	164.57	164.57	164.51	164.52	3236.0
2023-04-06 19:30:00	AAPL	Stock	164.55	164.59	164.5101	164.59	9851.0
2023-04-06 04:00:00	MSFT	Stock	284.31	284.86	284.2	284.2	2424.0
2023-04-06 04:30:00	MSFT	Stock	284.2	284.59	284.2	284.28	1392.0
2023-04-06 05:00:00	MSFT	Stock	284.62	284.62	284.37	284.37	1384.0
2023-04-06 05:30:00	MSFT	Stock	284.01	284.01	281.47	281.49	10929.0
2023-04-06 06:00:00	MSFT	Stock	281.55	282.12	281.15	282.05	6040.0
2023-04-06 06:30:00	MSFT	Stock	282.2	282.52	282.07	282.5	5164.0
2023-04-06 07:00:00	MSFT	Stock	282.77	282.98	282.48	282.7	12132.0
2023-04-06 07:30:00	MSFT	Stock	282.8	283.47	282.8	283.28	4839.0
2023-04-06 08:00:00	MSFT	Stock	282.76	283.5069	282.07	282.8	29723.0
2023-04-06 08:30:00	MSFT	Stock	282.63	283.2	282.1	282.1539	22135.0
2023-04-06 09:00:00	MSFT	Stock	282.31	283.28	281.85	283.2	20015.0
2023-04-06 09:30:00	MSFT	Stock	283.21	283.72	282.03	283.55	1716767.0
2023-04-06 10:00:00	MSFT	Stock	283.55	284.68	283.36	283.9	1330899.0
2023-04-06 10:30:00	MSFT	Stock	283.9	284.08	282.75	283.35	862852.0
2023-04-06 11:00:00	MSFT	Stock	283.39	285.23	283.11	285.08	830384.0
2023-04-06 11:30:00	MSFT	Stock	285.08	286.46	284.96	286.4186	932920.0
2023-04-06 12:00:00	MSFT	Stock	286.42	288.3407	286.42	288.07	1511958.0
2023-04-06 12:30:00	MSFT	Stock	288.09	288.54	287.87	287.97	1078400.0

> showing 50 of 98,675 rows — these rows as CSV

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