PREVIEW / stock_30min / 2022-07-06

all stock 30-min files

  file:    by_date/stock_30min/2022/2022-07-06.parquet
  size:    2.1 MB
  rows:    102,620
  symbols: 2,317

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
2022-07-06 04:00:00	AAPL	Stock	141.9	142.0	141.36	141.36	16985.0
2022-07-06 04:30:00	AAPL	Stock	141.3	141.3	141.03	141.25	7702.0
2022-07-06 05:00:00	AAPL	Stock	141.14	141.35	141.03	141.35	5818.0
2022-07-06 05:30:00	AAPL	Stock	141.3	141.49	141.24	141.42	4101.0
2022-07-06 06:00:00	AAPL	Stock	141.42	141.56	141.38	141.56	5568.0
2022-07-06 06:30:00	AAPL	Stock	141.5	141.5	141.12	141.3	8352.0
2022-07-06 07:00:00	AAPL	Stock	141.21	141.21	141.02	141.05	32324.0
2022-07-06 07:30:00	AAPL	Stock	141.06	141.11	140.45	140.62	47301.0
2022-07-06 08:00:00	AAPL	Stock	141.2202	141.57	140.23	140.5899	152142.0
2022-07-06 08:30:00	AAPL	Stock	140.55	141.18	140.55	140.9101	194783.0
2022-07-06 09:00:00	AAPL	Stock	140.92	141.57	140.8211	141.33	243699.0
2022-07-06 09:30:00	AAPL	Stock	141.36	142.87	141.29	142.82	8667941.0
2022-07-06 10:00:00	AAPL	Stock	142.82	143.7501	142.015	142.76	7887940.0
2022-07-06 10:30:00	AAPL	Stock	142.75	143.04	142.06	142.23	4664072.0
2022-07-06 11:00:00	AAPL	Stock	142.21	142.42	141.2701	141.535	4104375.0
2022-07-06 11:30:00	AAPL	Stock	141.53	141.76	141.08	141.7087	2886584.0
2022-07-06 12:00:00	AAPL	Stock	141.71	142.0193	141.525	141.93	2324821.0
2022-07-06 12:30:00	AAPL	Stock	141.93	142.07	141.64	141.9	1588197.0
2022-07-06 13:00:00	AAPL	Stock	141.9	142.415	141.875	142.184	2023827.0
2022-07-06 13:30:00	AAPL	Stock	142.18	142.55	142.1279	142.44	1688489.0
2022-07-06 14:00:00	AAPL	Stock	142.435	143.39	141.86	143.05	4767150.0
2022-07-06 14:30:00	AAPL	Stock	143.06	143.64	142.83	143.615	4733332.0
2022-07-06 15:00:00	AAPL	Stock	143.62	143.93	143.1101	143.8801	4009179.0
2022-07-06 15:30:00	AAPL	Stock	143.885	144.12	142.365	142.96	7995204.0
2022-07-06 16:00:00	AAPL	Stock	142.96	143.08	142.7	143.01	6436810.0
2022-07-06 16:30:00	AAPL	Stock	143.0	143.07	142.83	142.91	24978.0
2022-07-06 17:00:00	AAPL	Stock	142.9439	142.99	142.85	142.86	33050.0
2022-07-06 17:30:00	AAPL	Stock	142.8669	142.95	142.84	142.88	17276.0
2022-07-06 18:00:00	AAPL	Stock	142.87	143.06	142.87	143.03	21679.0
2022-07-06 18:30:00	AAPL	Stock	143.03	143.03	142.92	142.92	13152.0
2022-07-06 19:00:00	AAPL	Stock	142.92	143.0	142.85	142.87	11247.0
2022-07-06 19:30:00	AAPL	Stock	142.91	143.05	142.62	142.62	40644.0
2022-07-06 04:00:00	MSFT	Stock	262.0	263.8	262.0	263.24	3369.0
2022-07-06 04:30:00	MSFT	Stock	262.34	262.45	262.09	262.26	2129.0
2022-07-06 05:00:00	MSFT	Stock	262.26	262.52	262.26	262.52	200.0
2022-07-06 05:30:00	MSFT	Stock	262.5	262.85	262.27	262.85	2112.0
2022-07-06 06:00:00	MSFT	Stock	262.8	263.28	262.8	263.28	914.0
2022-07-06 06:30:00	MSFT	Stock	263.25	263.25	262.7	262.7	825.0
2022-07-06 07:00:00	MSFT	Stock	262.7	262.83	262.25	262.31	4583.0
2022-07-06 07:30:00	MSFT	Stock	262.69	262.85	261.73	261.73	9036.0
2022-07-06 08:00:00	MSFT	Stock	262.2901	262.8	261.4	262.11	11673.0
2022-07-06 08:30:00	MSFT	Stock	262.4	263.86	262.4	263.02	8846.0
2022-07-06 09:00:00	MSFT	Stock	263.32	264.44	263.15	263.61	17417.0
2022-07-06 09:30:00	MSFT	Stock	263.75	265.38	262.4	265.205	1999528.0
2022-07-06 10:00:00	MSFT	Stock	265.25	266.16	263.6	264.5654	1236915.0
2022-07-06 10:30:00	MSFT	Stock	264.54	265.3	263.98	264.95	880318.0
2022-07-06 11:00:00	MSFT	Stock	264.93	265.05	263.38	263.65	817535.0
2022-07-06 11:30:00	MSFT	Stock	263.62	264.3333	262.82	264.185	842063.0
2022-07-06 12:00:00	MSFT	Stock	264.18	264.745	263.9207	264.41	470605.0
2022-07-06 12:30:00	MSFT	Stock	264.41	264.63	263.88	264.6	437205.0

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

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