PREVIEW / stock_30min / 2022-09-13

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-09-13.parquet
  size:    2.1 MB
  rows:    105,916
  symbols: 2,196

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
2022-09-13 04:00:00	AAPL	Stock	164.07	164.68	164.07	164.58	25370.0
2022-09-13 04:30:00	AAPL	Stock	164.52	164.57	164.33	164.55	19208.0
2022-09-13 05:00:00	AAPL	Stock	164.6	164.6	164.35	164.35	9412.0
2022-09-13 05:30:00	AAPL	Stock	164.37	164.51	164.37	164.51	7537.0
2022-09-13 06:00:00	AAPL	Stock	164.45	164.55	164.37	164.52	6545.0
2022-09-13 06:30:00	AAPL	Stock	164.52	164.73	164.5	164.6	20008.0
2022-09-13 07:00:00	AAPL	Stock	164.62	164.9	164.51	164.78	59817.0
2022-09-13 07:30:00	AAPL	Stock	164.83	164.9	164.65	164.68	36048.0
2022-09-13 08:00:00	AAPL	Stock	164.6937	164.9	163.022	164.7	285194.0
2022-09-13 08:30:00	AAPL	Stock	164.73	164.89	159.59	159.6	1649119.0
2022-09-13 09:00:00	AAPL	Stock	159.6	160.2	159.49	160.01	813707.0
2022-09-13 09:30:00	AAPL	Stock	160.0	160.54	158.26	158.2701	13531318.0
2022-09-13 10:00:00	AAPL	Stock	158.28	158.3679	157.54	157.82	7880421.0
2022-09-13 10:30:00	AAPL	Stock	157.8	158.2	156.84	157.23	6616915.0
2022-09-13 11:00:00	AAPL	Stock	157.22	157.27	156.25	156.4599	5182381.0
2022-09-13 11:30:00	AAPL	Stock	156.465	156.68	156.25	156.335	4584790.0
2022-09-13 12:00:00	AAPL	Stock	156.33	156.76	156.15	156.2527	4612633.0
2022-09-13 12:30:00	AAPL	Stock	156.25	156.7	156.19	156.31	3243010.0
2022-09-13 13:00:00	AAPL	Stock	156.3	156.6	155.92	156.51	5470565.0
2022-09-13 13:30:00	AAPL	Stock	156.52	156.67	155.76	155.785	4104657.0
2022-09-13 14:00:00	AAPL	Stock	155.7812	155.87	154.95	155.07	5230419.0
2022-09-13 14:30:00	AAPL	Stock	155.05	155.25	154.59	154.8	5294745.0
2022-09-13 15:00:00	AAPL	Stock	154.79	154.89	154.03	154.05	6335955.0
2022-09-13 15:30:00	AAPL	Stock	154.045	154.26	153.37	153.85	15474800.0
2022-09-13 16:00:00	AAPL	Stock	153.85	154.07	153.57	153.65	16134543.0
2022-09-13 16:30:00	AAPL	Stock	153.65	153.9	153.59	153.88	180710.0
2022-09-13 17:00:00	AAPL	Stock	153.8475	154.17	153.82	153.9867	51386.0
2022-09-13 17:30:00	AAPL	Stock	154.01	154.22	153.84	154.05	206994.0
2022-09-13 18:00:00	AAPL	Stock	154.1	154.1	153.8	154.03	39629.0
2022-09-13 18:30:00	AAPL	Stock	154.06	154.2	154.06	154.19	25822.0
2022-09-13 19:00:00	AAPL	Stock	154.18	154.18	154.01	154.05	33822.0
2022-09-13 19:30:00	AAPL	Stock	154.14	154.3	154.07	154.26	42379.0
2022-09-13 04:00:00	MSFT	Stock	268.05	268.05	267.15	267.92	1662.0
2022-09-13 04:30:00	MSFT	Stock	267.92	268.05	267.92	268.05	283.0
2022-09-13 05:00:00	MSFT	Stock	268.08	268.08	268.08	268.08	100.0
2022-09-13 05:30:00	MSFT	Stock	267.75	267.94	267.75	267.85	563.0
2022-09-13 06:00:00	MSFT	Stock	267.99	268.07	267.99	268.07	400.0
2022-09-13 06:30:00	MSFT	Stock	268.23	268.56	268.23	268.55	825.0
2022-09-13 07:00:00	MSFT	Stock	268.5	268.68	268.33	268.5	4664.0
2022-09-13 07:30:00	MSFT	Stock	268.55	268.8	268.55	268.8	1120.0
2022-09-13 08:00:00	MSFT	Stock	268.71	269.5	265.984	268.4	26788.0
2022-09-13 08:30:00	MSFT	Stock	268.83	268.83	259.14	259.25	243753.0
2022-09-13 09:00:00	MSFT	Stock	259.15	259.65	258.54	258.93	75896.0
2022-09-13 09:30:00	MSFT	Stock	258.99	260.4	257.4	257.42	2531241.0
2022-09-13 10:00:00	MSFT	Stock	257.42	257.7	256.61	257.34	1481158.0
2022-09-13 10:30:00	MSFT	Stock	257.33	257.5396	255.61	255.79	1085532.0
2022-09-13 11:00:00	MSFT	Stock	255.79	255.99	254.62	254.79	1168797.0
2022-09-13 11:30:00	MSFT	Stock	254.815	255.9675	254.65	255.265	1076895.0
2022-09-13 12:00:00	MSFT	Stock	255.24	256.03	254.98	255.165	829778.0
2022-09-13 12:30:00	MSFT	Stock	255.1622	256.0899	254.985	255.87	656359.0

> showing 50 of 105,916 rows — these rows as CSV

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