PREVIEW / stock_30min / 2023-06-15

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-06-15.parquet
  size:    2.1 MB
  rows:    103,538
  symbols: 1,598

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-06-15 04:00:00	AAPL	Stock	183.84	183.88	183.56	183.65	8458.0
2023-06-15 04:30:00	AAPL	Stock	183.53	183.53	183.3	183.35	2672.0
2023-06-15 05:00:00	AAPL	Stock	183.36	183.39	183.01	183.04	4453.0
2023-06-15 05:30:00	AAPL	Stock	183.05	183.28	183.01	183.1	4752.0
2023-06-15 06:00:00	AAPL	Stock	183.1	183.15	183.01	183.12	10473.0
2023-06-15 06:30:00	AAPL	Stock	183.11	183.26	183.03	183.25	5319.0
2023-06-15 07:00:00	AAPL	Stock	183.14	183.45	183.05	183.14	28228.0
2023-06-15 07:30:00	AAPL	Stock	183.2	183.22	183.04	183.19	15233.0
2023-06-15 08:00:00	AAPL	Stock	183.25	183.89	183.0215	183.15	84266.0
2023-06-15 08:30:00	AAPL	Stock	183.15	183.7	183.02	183.68	96761.0
2023-06-15 09:00:00	AAPL	Stock	183.68	184.02	183.45	183.97	106993.0
2023-06-15 09:30:00	AAPL	Stock	183.98	185.2	183.78	185.196	7896940.0
2023-06-15 10:00:00	AAPL	Stock	185.195	185.84	185.0	185.84	4804099.0
2023-06-15 10:30:00	AAPL	Stock	185.84	185.85	185.11	185.42	3017083.0
2023-06-15 11:00:00	AAPL	Stock	185.425	185.86	185.23	185.84	2660190.0
2023-06-15 11:30:00	AAPL	Stock	185.83	185.9585	185.45	185.5484	2513024.0
2023-06-15 12:00:00	AAPL	Stock	185.55	185.56	185.08	185.2	2255278.0
2023-06-15 12:30:00	AAPL	Stock	185.2	185.38	185.03	185.1079	1445908.0
2023-06-15 13:00:00	AAPL	Stock	185.11	185.14	184.55	185.09	1844073.0
2023-06-15 13:30:00	AAPL	Stock	185.09	185.75	185.07	185.6735	2119756.0
2023-06-15 14:00:00	AAPL	Stock	185.69	185.85	185.46	185.805	2135265.0
2023-06-15 14:30:00	AAPL	Stock	185.81	186.52	185.77	186.34	3954128.0
2023-06-15 15:00:00	AAPL	Stock	186.34	186.45	185.69	186.18	3579201.0
2023-06-15 15:30:00	AAPL	Stock	186.175	186.37	185.69	186.03	6199051.0
2023-06-15 16:00:00	AAPL	Stock	186.01	186.04	185.6	185.75	9194301.0
2023-06-15 16:30:00	AAPL	Stock	185.75	186.01	185.55	185.72	51924.0
2023-06-15 17:00:00	AAPL	Stock	185.72	185.74	185.62	185.6212	18073.0
2023-06-15 17:30:00	AAPL	Stock	185.653	185.85	185.653	185.8	19233.0
2023-06-15 18:00:00	AAPL	Stock	185.81	185.81	185.53	185.69	14212.0
2023-06-15 18:30:00	AAPL	Stock	185.69	185.71	185.54	185.64	5042.0
2023-06-15 19:00:00	AAPL	Stock	185.66	185.7	185.65	185.66	2937.0
2023-06-15 19:30:00	AAPL	Stock	185.67	185.76	185.67	185.73	13260.0
2023-06-15 04:00:00	MSFT	Stock	337.35	337.35	336.8	336.8	938.0
2023-06-15 04:30:00	MSFT	Stock	336.56	336.56	336.0	336.0	774.0
2023-06-15 05:00:00	MSFT	Stock	335.82	336.18	335.0	335.12	3442.0
2023-06-15 05:30:00	MSFT	Stock	335.24	335.24	334.82	335.1	2092.0
2023-06-15 06:00:00	MSFT	Stock	335.1	335.16	334.84	334.94	1155.0
2023-06-15 06:30:00	MSFT	Stock	335.0	335.66	334.88	335.33	2995.0
2023-06-15 07:00:00	MSFT	Stock	335.49	335.94	335.49	335.7	11893.0
2023-06-15 07:30:00	MSFT	Stock	335.6	335.69	335.2	335.6	5667.0
2023-06-15 08:00:00	MSFT	Stock	335.83	337.58	335.15	335.3	15638.0
2023-06-15 08:30:00	MSFT	Stock	335.15	336.8	335.05	336.68	26055.0
2023-06-15 09:00:00	MSFT	Stock	336.68	337.64	336.33	337.47	23395.0
2023-06-15 09:30:00	MSFT	Stock	337.48	341.9289	337.2	341.06	3838746.0
2023-06-15 10:00:00	MSFT	Stock	341.1	344.8029	340.4	344.46	2974922.0
2023-06-15 10:30:00	MSFT	Stock	344.45	345.81	343.4	345.1953	2314204.0
2023-06-15 11:00:00	MSFT	Stock	345.19	345.37	344.01	345.09	1275643.0
2023-06-15 11:30:00	MSFT	Stock	345.085	346.16	344.68	345.39	1069406.0
2023-06-15 12:00:00	MSFT	Stock	345.41	346.78	345.16	346.2689	979335.0
2023-06-15 12:30:00	MSFT	Stock	346.27	346.62	345.35	345.8159	838599.0

> showing 50 of 103,538 rows — these rows as CSV

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