PREVIEW / stock_30min / 2021-04-28

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-04-28.parquet
  size:    2.2 MB
  rows:    110,052
  symbols: 2,972

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-04-28 04:00:00	AAPL	Stock	134.31	134.7	134.0	134.19	9420.0
2021-04-28 04:30:00	AAPL	Stock	134.11	134.35	134.11	134.32	3857.0
2021-04-28 05:00:00	AAPL	Stock	134.28	134.28	134.0	134.0	12315.0
2021-04-28 05:30:00	AAPL	Stock	134.0	134.11	133.92	134.11	7632.0
2021-04-28 06:00:00	AAPL	Stock	134.14	134.22	134.06	134.22	15478.0
2021-04-28 06:30:00	AAPL	Stock	134.2	134.27	134.09	134.17	6362.0
2021-04-28 07:00:00	AAPL	Stock	134.17	134.7	134.14	134.53	135074.0
2021-04-28 07:30:00	AAPL	Stock	134.53	134.53	134.22	134.4	156425.0
2021-04-28 08:00:00	AAPL	Stock	134.5199	134.7	134.21	134.52	269282.0
2021-04-28 08:30:00	AAPL	Stock	134.5	134.55	134.28	134.37	158360.0
2021-04-28 09:00:00	AAPL	Stock	134.37	134.5	134.2	134.3	188249.0
2021-04-28 09:30:00	AAPL	Stock	134.29	134.93	133.933	134.69	9809625.0
2021-04-28 10:00:00	AAPL	Stock	134.69	135.02	134.245	134.2886	6527769.0
2021-04-28 10:30:00	AAPL	Stock	134.289	134.3	133.795	134.1116	5643811.0
2021-04-28 11:00:00	AAPL	Stock	134.115	134.225	133.82	133.93	3645809.0
2021-04-28 11:30:00	AAPL	Stock	133.935	134.07	133.08	133.23	5227434.0
2021-04-28 12:00:00	AAPL	Stock	133.234	133.69	133.09	133.356	5255162.0
2021-04-28 12:30:00	AAPL	Stock	133.355	133.808	133.33	133.64	3203918.0
2021-04-28 13:00:00	AAPL	Stock	133.645	133.74	133.51	133.6487	2368555.0
2021-04-28 13:30:00	AAPL	Stock	133.6455	134.03	133.62	133.9699	3412388.0
2021-04-28 14:00:00	AAPL	Stock	133.97	134.39	133.65	133.97	4703529.0
2021-04-28 14:30:00	AAPL	Stock	133.9685	134.775	133.76	134.3077	6357693.0
2021-04-28 15:00:00	AAPL	Stock	134.31	134.4	133.83	134.325	5381109.0
2021-04-28 15:30:00	AAPL	Stock	134.33	134.355	133.31	133.82	10181763.0
2021-04-28 16:00:00	AAPL	Stock	133.735	135.34	133.58	135.34	6052000.0
2021-04-28 16:30:00	AAPL	Stock	135.35	139.5	135.34	137.87	10610474.0
2021-04-28 17:00:00	AAPL	Stock	137.85	138.27	135.55	135.81	2728208.0
2021-04-28 17:30:00	AAPL	Stock	135.98	137.13	135.51	136.72	1581216.0
2021-04-28 18:00:00	AAPL	Stock	136.72	137.24	136.5	136.75	681783.0
2021-04-28 18:30:00	AAPL	Stock	136.75	136.85	136.45	136.59	280453.0
2021-04-28 19:00:00	AAPL	Stock	136.61	136.8	136.51	136.75	197279.0
2021-04-28 19:30:00	AAPL	Stock	136.71	137.0	136.65	136.7	306469.0
2021-04-28 04:00:00	MSFT	Stock	255.18	256.19	255.18	256.07	8500.0
2021-04-28 04:30:00	MSFT	Stock	256.44	256.58	256.3	256.3	3201.0
2021-04-28 05:00:00	MSFT	Stock	256.5	256.5	256.2	256.3	4265.0
2021-04-28 05:30:00	MSFT	Stock	256.28	256.34	256.16	256.24	3628.0
2021-04-28 06:00:00	MSFT	Stock	256.27	256.38	256.13	256.13	3076.0
2021-04-28 06:30:00	MSFT	Stock	256.14	256.25	255.55	255.85	6430.0
2021-04-28 07:00:00	MSFT	Stock	255.72	256.0	255.2	255.84	59517.0
2021-04-28 07:30:00	MSFT	Stock	255.8	255.83	254.7	254.85	71503.0
2021-04-28 08:00:00	MSFT	Stock	255.47	256.0	254.55	255.35	195204.0
2021-04-28 08:30:00	MSFT	Stock	255.41	256.7	255.0	256.0	261821.0
2021-04-28 09:00:00	MSFT	Stock	256.01	256.87	255.0	256.22	216129.0
2021-04-28 09:30:00	MSFT	Stock	256.078	256.5399	253.1	254.6699	8029425.0
2021-04-28 10:00:00	MSFT	Stock	254.66	254.9	253.67	253.92	3616387.0
2021-04-28 10:30:00	MSFT	Stock	253.92	254.17	253.54	253.68	2118722.0
2021-04-28 11:00:00	MSFT	Stock	253.6827	254.55	253.555	254.16	2025750.0
2021-04-28 11:30:00	MSFT	Stock	254.16	254.24	253.08	253.09	2192703.0
2021-04-28 12:00:00	MSFT	Stock	253.08	253.97	252.95	253.83	2129979.0
2021-04-28 12:30:00	MSFT	Stock	253.8301	254.91	253.61	254.835	1691776.0

> showing 50 of 110,052 rows — these rows as CSV

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