PREVIEW / stock_30min / 2023-10-26

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-10-26.parquet
  size:    2.0 MB
  rows:    96,546
  symbols: 1,340

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-10-26 04:00:00	AAPL	Stock	169.2	169.51	168.7	169.05	24647.0
2023-10-26 04:30:00	AAPL	Stock	169.1	169.32	168.91	169.0	10931.0
2023-10-26 05:00:00	AAPL	Stock	168.99	169.5	168.95	169.5	10139.0
2023-10-26 05:30:00	AAPL	Stock	169.35	169.43	169.24	169.24	2662.0
2023-10-26 06:00:00	AAPL	Stock	169.33	169.79	169.25	169.79	12569.0
2023-10-26 06:30:00	AAPL	Stock	169.7	169.8	169.5	169.51	22582.0
2023-10-26 07:00:00	AAPL	Stock	169.38	169.47	169.21	169.41	21496.0
2023-10-26 07:30:00	AAPL	Stock	169.49	169.61	169.1	169.6	21704.0
2023-10-26 08:00:00	AAPL	Stock	169.5387	171.1	168.16	169.91	279839.0
2023-10-26 08:30:00	AAPL	Stock	169.99	170.9	169.65	170.6	102992.0
2023-10-26 09:00:00	AAPL	Stock	170.66	171.1	170.0	170.43	133284.0
2023-10-26 09:30:00	AAPL	Stock	170.4	171.3775	169.375	169.81	6038880.0
2023-10-26 10:00:00	AAPL	Stock	169.78	170.03	168.13	168.66	4870295.0
2023-10-26 10:30:00	AAPL	Stock	168.65	168.95	167.89	168.315	4500492.0
2023-10-26 11:00:00	AAPL	Stock	168.31	168.415	166.84	166.9496	4412499.0
2023-10-26 11:30:00	AAPL	Stock	166.945	167.53	166.52	167.2682	3471205.0
2023-10-26 12:00:00	AAPL	Stock	167.26	167.32	165.97	166.2974	3721940.0
2023-10-26 12:30:00	AAPL	Stock	166.29	166.44	165.95	166.075	2353151.0
2023-10-26 13:00:00	AAPL	Stock	166.075	166.7	165.72	165.95	2619510.0
2023-10-26 13:30:00	AAPL	Stock	165.95	166.885	165.67	166.77	2625519.0
2023-10-26 14:00:00	AAPL	Stock	166.77	167.3829	166.68	167.18	2685100.0
2023-10-26 14:30:00	AAPL	Stock	167.17	167.71	166.9	167.685	2936330.0
2023-10-26 15:00:00	AAPL	Stock	167.68	167.94	167.21	167.3143	2660046.0
2023-10-26 15:30:00	AAPL	Stock	167.31	167.44	166.375	166.76	6971736.0
2023-10-26 16:00:00	AAPL	Stock	166.89	167.05	166.56	166.9517	8078533.0
2023-10-26 16:30:00	AAPL	Stock	166.95	167.07	166.52	166.69	119567.0
2023-10-26 17:00:00	AAPL	Stock	166.68	166.69	165.3	165.57	172926.0
2023-10-26 17:30:00	AAPL	Stock	165.57	166.2884	165.3201	166.24	182855.0
2023-10-26 18:00:00	AAPL	Stock	166.32	166.82	166.3	166.746	54371.0
2023-10-26 18:30:00	AAPL	Stock	166.59	166.89	166.3	166.46	113501.0
2023-10-26 19:00:00	AAPL	Stock	166.41	167.05	166.4	166.95	53677.0
2023-10-26 19:30:00	AAPL	Stock	166.95	167.25	166.82	167.25	39541.0
2023-10-26 04:00:00	MSFT	Stock	336.47	337.62	336.47	337.0	14700.0
2023-10-26 04:30:00	MSFT	Stock	337.36	337.64	337.06	337.1	1979.0
2023-10-26 05:00:00	MSFT	Stock	337.5	337.83	337.0	337.83	2524.0
2023-10-26 05:30:00	MSFT	Stock	337.69	337.69	337.5	337.5	419.0
2023-10-26 06:00:00	MSFT	Stock	337.69	338.38	337.69	338.38	902.0
2023-10-26 06:30:00	MSFT	Stock	338.14	338.4	338.0	338.01	4096.0
2023-10-26 07:00:00	MSFT	Stock	337.87	338.0	337.0	337.2	7846.0
2023-10-26 07:30:00	MSFT	Stock	337.4	338.0	337.15	338.0	6844.0
2023-10-26 08:00:00	MSFT	Stock	340.67	340.67	334.73	338.93	160188.0
2023-10-26 08:30:00	MSFT	Stock	338.65	340.8	338.22	340.54	75355.0
2023-10-26 09:00:00	MSFT	Stock	340.48	342.0	339.76	340.55	91392.0
2023-10-26 09:30:00	MSFT	Stock	340.54	341.63	334.68	335.38	3903556.0
2023-10-26 10:00:00	MSFT	Stock	335.27	335.34	332.13	333.475	2714499.0
2023-10-26 10:30:00	MSFT	Stock	333.46	335.88	333.1016	334.08	1858879.0
2023-10-26 11:00:00	MSFT	Stock	334.0417	334.096	330.03	330.73	1923885.0
2023-10-26 11:30:00	MSFT	Stock	330.81	331.34	329.6	330.71	1323014.0
2023-10-26 12:00:00	MSFT	Stock	330.72	330.78	326.94	328.58	2052466.0
2023-10-26 12:30:00	MSFT	Stock	328.55	328.9	327.11	327.95	1368667.0

> showing 50 of 96,546 rows — these rows as CSV

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