PREVIEW / stock_30min / 2023-03-30

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-03-30.parquet
  size:    2.0 MB
  rows:    100,251
  symbols: 1,722

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-03-30 04:00:00	AAPL	Stock	161.15	161.15	160.86	160.86	3837.0
2023-03-30 04:30:00	AAPL	Stock	160.9	160.99	160.9	160.95	1121.0
2023-03-30 05:00:00	AAPL	Stock	160.94	161.08	160.9	161.08	5898.0
2023-03-30 05:30:00	AAPL	Stock	160.99	161.04	160.92	161.04	5284.0
2023-03-30 06:00:00	AAPL	Stock	161.04	161.12	160.95	161.12	5305.0
2023-03-30 06:30:00	AAPL	Stock	161.13	161.29	161.08	161.26	10481.0
2023-03-30 07:00:00	AAPL	Stock	161.2	161.47	161.09	161.47	45573.0
2023-03-30 07:30:00	AAPL	Stock	161.45	161.45	161.08	161.15	30037.0
2023-03-30 08:00:00	AAPL	Stock	161.16	161.49	160.25	161.17	75469.0
2023-03-30 08:30:00	AAPL	Stock	161.13	161.45	161.08	161.22	73667.0
2023-03-30 09:00:00	AAPL	Stock	161.22	161.6	160.77	161.59	266514.0
2023-03-30 09:30:00	AAPL	Stock	161.59	161.97	161.271	161.97	5660753.0
2023-03-30 10:00:00	AAPL	Stock	161.96	162.43	161.5	162.34	4283156.0
2023-03-30 10:30:00	AAPL	Stock	162.335	162.47	162.02	162.32	2942680.0
2023-03-30 11:00:00	AAPL	Stock	162.325	162.395	161.98	162.09	2294581.0
2023-03-30 11:30:00	AAPL	Stock	162.09	162.16	161.95	162.0846	2094060.0
2023-03-30 12:00:00	AAPL	Stock	162.09	162.225	161.9	162.006	2215453.0
2023-03-30 12:30:00	AAPL	Stock	162.01	162.09	161.62	161.7284	1935587.0
2023-03-30 13:00:00	AAPL	Stock	161.725	162.05	161.645	161.84	1527596.0
2023-03-30 13:30:00	AAPL	Stock	161.84	161.85	161.35	161.58	1923703.0
2023-03-30 14:00:00	AAPL	Stock	161.58	162.18	161.545	162.1542	2192068.0
2023-03-30 14:30:00	AAPL	Stock	162.16	162.3318	162.005	162.05	1825370.0
2023-03-30 15:00:00	AAPL	Stock	162.05	162.2018	161.86	162.13	1853898.0
2023-03-30 15:30:00	AAPL	Stock	162.125	162.38	161.99	162.37	4027411.0
2023-03-30 16:00:00	AAPL	Stock	162.36	162.46	162.3	162.36	5918780.0
2023-03-30 16:30:00	AAPL	Stock	162.36	162.43	162.3101	162.35	39720.0
2023-03-30 17:00:00	AAPL	Stock	162.31	162.36	162.3	162.32	18208.0
2023-03-30 17:30:00	AAPL	Stock	162.31	162.3199	162.26	162.27	6617.0
2023-03-30 18:00:00	AAPL	Stock	162.25	162.29	162.2	162.21	8756.0
2023-03-30 18:30:00	AAPL	Stock	162.2	162.29	162.2	162.29	10340.0
2023-03-30 19:00:00	AAPL	Stock	162.3	162.36	162.26	162.3	5163.0
2023-03-30 19:30:00	AAPL	Stock	162.32	162.47	162.32	162.44	15232.0
2023-03-30 04:00:00	MSFT	Stock	281.33	281.43	281.02	281.13	3872.0
2023-03-30 04:30:00	MSFT	Stock	281.04	281.43	281.03	281.42	1009.0
2023-03-30 05:00:00	MSFT	Stock	281.4	281.73	281.4	281.73	1077.0
2023-03-30 05:30:00	MSFT	Stock	281.8	282.72	281.66	282.33	4583.0
2023-03-30 06:00:00	MSFT	Stock	282.35	282.46	282.35	282.46	700.0
2023-03-30 06:30:00	MSFT	Stock	282.29	282.9	282.29	282.6	3179.0
2023-03-30 07:00:00	MSFT	Stock	282.51	282.9	282.49	282.6	12258.0
2023-03-30 07:30:00	MSFT	Stock	282.58	283.67	282.45	283.51	17767.0
2023-03-30 08:00:00	MSFT	Stock	282.74	284.25	280.69	283.79	72957.0
2023-03-30 08:30:00	MSFT	Stock	283.51	284.39	283.0	284.01	56194.0
2023-03-30 09:00:00	MSFT	Stock	283.96	284.72	283.7	284.1	84151.0
2023-03-30 09:30:00	MSFT	Stock	284.23	284.46	282.3273	283.4729	2896898.0
2023-03-30 10:00:00	MSFT	Stock	283.47	283.9	282.21	283.53	1714429.0
2023-03-30 10:30:00	MSFT	Stock	283.55	283.68	282.17	282.76	1092875.0
2023-03-30 11:00:00	MSFT	Stock	282.74	283.75	282.553	282.7	1038453.0
2023-03-30 11:30:00	MSFT	Stock	282.7	283.53	282.44	283.2	847497.0
2023-03-30 12:00:00	MSFT	Stock	283.2	283.59	282.6	282.89	829921.0
2023-03-30 12:30:00	MSFT	Stock	282.89	282.89	281.86	282.08	867944.0

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

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