PREVIEW / stock_30min / 2021-12-14

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-12-14.parquet
  size:    2.3 MB
  rows:    111,817
  symbols: 2,693

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
2021-12-14 04:00:00	AAPL	Stock	177.27	177.84	176.98	177.31	173256.0
2021-12-14 04:30:00	AAPL	Stock	177.34	177.41	175.74	175.85	88989.0
2021-12-14 05:00:00	AAPL	Stock	175.8	176.45	175.8	176.35	39267.0
2021-12-14 05:30:00	AAPL	Stock	176.26	176.5	176.0	176.33	24598.0
2021-12-14 06:00:00	AAPL	Stock	176.33	176.65	176.16	176.57	35160.0
2021-12-14 06:30:00	AAPL	Stock	176.64	176.73	176.26	176.4	21195.0
2021-12-14 07:00:00	AAPL	Stock	176.45	177.4	176.0	177.28	248078.0
2021-12-14 07:30:00	AAPL	Stock	177.25	177.41	176.92	176.95	149526.0
2021-12-14 08:00:00	AAPL	Stock	176.64	177.42	175.301	176.74	465418.0
2021-12-14 08:30:00	AAPL	Stock	176.66	176.66	174.58	175.0	764642.0
2021-12-14 09:00:00	AAPL	Stock	174.97	175.34	174.4	175.25	447383.0
2021-12-14 09:30:00	AAPL	Stock	175.28	177.74	174.71	175.8604	16243414.0
2021-12-14 10:00:00	AAPL	Stock	175.87	176.09	174.25	174.51	10851612.0
2021-12-14 10:30:00	AAPL	Stock	174.5	175.08	173.15	173.36	8708081.0
2021-12-14 11:00:00	AAPL	Stock	173.35	173.63	172.39	173.49	9423883.0
2021-12-14 11:30:00	AAPL	Stock	173.5	173.6	172.7253	173.255	5494285.0
2021-12-14 12:00:00	AAPL	Stock	173.24	173.29	172.21	172.56	4800989.0
2021-12-14 12:30:00	AAPL	Stock	172.555	173.47	172.47	173.445	6312111.0
2021-12-14 13:00:00	AAPL	Stock	173.43	174.07	173.35	173.655	4689720.0
2021-12-14 13:30:00	AAPL	Stock	173.6516	173.7098	173.08	173.45	2989036.0
2021-12-14 14:00:00	AAPL	Stock	173.45	174.55	173.38	174.17	4789684.0
2021-12-14 14:30:00	AAPL	Stock	174.1785	174.7	174.06	174.52	4255001.0
2021-12-14 15:00:00	AAPL	Stock	174.52	175.5	174.35	175.3707	5417112.0
2021-12-14 15:30:00	AAPL	Stock	175.37	175.61	173.77	174.34	11797066.0
2021-12-14 16:00:00	AAPL	Stock	174.63	174.63	174.17	174.23	19481435.0
2021-12-14 16:30:00	AAPL	Stock	174.26	174.37	174.21	174.25	30616.0
2021-12-14 17:00:00	AAPL	Stock	174.25	174.29	173.75	173.86	55140.0
2021-12-14 17:30:00	AAPL	Stock	173.85	174.33	173.81	173.95	1190381.0
2021-12-14 18:00:00	AAPL	Stock	173.95	174.44	173.91	174.05	53466.0
2021-12-14 18:30:00	AAPL	Stock	174.06	174.15	173.81	174.05	15939.0
2021-12-14 19:00:00	AAPL	Stock	174.03	174.25	173.95	174.18	20546.0
2021-12-14 19:30:00	AAPL	Stock	174.25	174.44	174.2	174.44	26056.0
2021-12-14 04:00:00	MSFT	Stock	339.59	339.9	339.2	339.2	1988.0
2021-12-14 04:30:00	MSFT	Stock	339.36	339.36	336.79	336.84	7369.0
2021-12-14 05:00:00	MSFT	Stock	337.0	337.01	336.07	336.66	5340.0
2021-12-14 05:30:00	MSFT	Stock	336.73	336.87	336.32	336.4	1625.0
2021-12-14 06:00:00	MSFT	Stock	336.33	336.9	336.33	336.9	2980.0
2021-12-14 06:30:00	MSFT	Stock	336.58	336.65	336.13	336.5	3166.0
2021-12-14 07:00:00	MSFT	Stock	336.7	337.43	336.4	336.99	10126.0
2021-12-14 07:30:00	MSFT	Stock	337.72	337.72	336.73	336.94	6571.0
2021-12-14 08:00:00	MSFT	Stock	336.9432	339.4	336.55	339.4	29542.0
2021-12-14 08:30:00	MSFT	Stock	336.64	336.64	333.72	335.25	57944.0
2021-12-14 09:00:00	MSFT	Stock	335.04	335.39	332.42	333.18	64733.0
2021-12-14 09:30:00	MSFT	Stock	332.71	334.64	329.67	330.03	4216009.0
2021-12-14 10:00:00	MSFT	Stock	330.045	330.33	328.69	329.67	2285165.0
2021-12-14 10:30:00	MSFT	Stock	329.645	329.87	326.32	326.82	2049523.0
2021-12-14 11:00:00	MSFT	Stock	326.78	326.98	324.82	326.53	2790101.0
2021-12-14 11:30:00	MSFT	Stock	326.56	326.65	325.18	325.895	1548424.0
2021-12-14 12:00:00	MSFT	Stock	325.89	326.01	324.42	325.0	1421551.0
2021-12-14 12:30:00	MSFT	Stock	325.0	325.12	324.11	324.9	1105925.0

> showing 50 of 111,817 rows — these rows as CSV

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