PREVIEW / stock_30min / 2023-05-04

all stock 30-min files

  file:    by_date/stock_30min/2023/2023-05-04.parquet
  size:    2.1 MB
  rows:    102,790
  symbols: 1,657

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-05-04 04:00:00	AAPL	Stock	166.02	166.44	165.35	165.36	43222.0
2023-05-04 04:30:00	AAPL	Stock	165.43	165.6	165.15	165.4	21075.0
2023-05-04 05:00:00	AAPL	Stock	165.5	165.64	165.5	165.6	5053.0
2023-05-04 05:30:00	AAPL	Stock	165.54	165.64	165.2	165.41	13758.0
2023-05-04 06:00:00	AAPL	Stock	165.5	165.9	165.32	165.9	8728.0
2023-05-04 06:30:00	AAPL	Stock	165.91	166.16	165.5	165.5	29814.0
2023-05-04 07:00:00	AAPL	Stock	165.52	165.57	164.8	165.15	76308.0
2023-05-04 07:30:00	AAPL	Stock	165.15	165.32	164.86	165.15	45915.0
2023-05-04 08:00:00	AAPL	Stock	165.399	166.62	164.48	165.0	253062.0
2023-05-04 08:30:00	AAPL	Stock	164.91	165.31	164.82	164.9	121913.0
2023-05-04 09:00:00	AAPL	Stock	164.92	165.18	164.22	164.83	162236.0
2023-05-04 09:30:00	AAPL	Stock	164.88	165.5	164.31	165.165	8145733.0
2023-05-04 10:00:00	AAPL	Stock	165.16	165.77	165.0	165.255	4544353.0
2023-05-04 10:30:00	AAPL	Stock	165.255	166.23	165.1303	165.95	3369275.0
2023-05-04 11:00:00	AAPL	Stock	165.93	166.88	165.71	165.935	4026012.0
2023-05-04 11:30:00	AAPL	Stock	165.94	166.19	165.5184	165.7766	2029234.0
2023-05-04 12:00:00	AAPL	Stock	165.76	166.23	165.43	166.21	2117508.0
2023-05-04 12:30:00	AAPL	Stock	166.21	166.64	165.95	166.58	2041491.0
2023-05-04 13:00:00	AAPL	Stock	166.585	167.04	166.41	166.6726	2279325.0
2023-05-04 13:30:00	AAPL	Stock	166.675	166.905	166.01	166.37	2381119.0
2023-05-04 14:00:00	AAPL	Stock	166.38	166.4	165.5101	165.5328	1995057.0
2023-05-04 14:30:00	AAPL	Stock	165.53	165.74	165.3	165.615	2684524.0
2023-05-04 15:00:00	AAPL	Stock	165.61	165.97	165.08	165.6734	3628376.0
2023-05-04 15:30:00	AAPL	Stock	165.675	166.34	165.3821	165.78	8099642.0
2023-05-04 16:00:00	AAPL	Stock	165.78	166.68	165.3	166.3088	5870904.0
2023-05-04 16:30:00	AAPL	Stock	166.19	171.47	165.79	167.39	3844638.0
2023-05-04 17:00:00	AAPL	Stock	167.3	170.0	166.69	169.31	2123038.0
2023-05-04 17:30:00	AAPL	Stock	169.32	170.26	167.75	169.2	2089304.0
2023-05-04 18:00:00	AAPL	Stock	169.2	169.66	168.8	169.52	408967.0
2023-05-04 18:30:00	AAPL	Stock	169.52	169.63	169.25	169.35	151695.0
2023-05-04 19:00:00	AAPL	Stock	169.39	169.57	169.35	169.55	107551.0
2023-05-04 19:30:00	AAPL	Stock	169.55	169.92	169.46	169.92	226167.0
2023-05-04 04:00:00	MSFT	Stock	306.0	306.25	305.77	306.23	5509.0
2023-05-04 04:30:00	MSFT	Stock	306.25	306.59	306.15	306.56	2083.0
2023-05-04 05:00:00	MSFT	Stock	306.58	306.8	306.2	306.5	1515.0
2023-05-04 05:30:00	MSFT	Stock	306.41	306.41	306.01	306.01	1476.0
2023-05-04 06:00:00	MSFT	Stock	306.18	306.18	305.98	305.98	675.0
2023-05-04 06:30:00	MSFT	Stock	306.13	306.21	306.13	306.21	622.0
2023-05-04 07:00:00	MSFT	Stock	305.9	305.9	305.65	305.75	2352.0
2023-05-04 07:30:00	MSFT	Stock	305.85	305.91	305.64	305.77	3767.0
2023-05-04 08:00:00	MSFT	Stock	305.65	306.87	305.0	305.75	37754.0
2023-05-04 08:30:00	MSFT	Stock	305.3	305.81	305.3	305.35	5353.0
2023-05-04 09:00:00	MSFT	Stock	305.63	306.42	305.01	306.3	26424.0
2023-05-04 09:30:00	MSFT	Stock	306.46	306.5	303.81	303.95	1973229.0
2023-05-04 10:00:00	MSFT	Stock	303.93	305.42	303.4	303.75	1219697.0
2023-05-04 10:30:00	MSFT	Stock	303.75	305.8144	303.66	305.3905	1301116.0
2023-05-04 11:00:00	MSFT	Stock	305.43	306.6	305.03	306.01	986256.0
2023-05-04 11:30:00	MSFT	Stock	306.01	306.92	305.23	305.6	793589.0
2023-05-04 12:00:00	MSFT	Stock	305.59	306.38	305.01	306.35	767260.0
2023-05-04 12:30:00	MSFT	Stock	306.35	306.94	305.8	306.87	677847.0

> showing 50 of 102,790 rows — these rows as CSV

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