PREVIEW / stock_30min / 2021-06-28

all stock 30-min files

  file:    by_date/stock_30min/2021/2021-06-28.parquet
  size:    2.3 MB
  rows:    115,720
  symbols: 2,973

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-06-28 04:00:00	AAPL	Stock	133.11	133.48	133.11	133.26	4685.0
2021-06-28 04:30:00	AAPL	Stock	133.1	133.19	133.02	133.19	3162.0
2021-06-28 05:00:00	AAPL	Stock	133.14	133.16	133.1	133.11	2196.0
2021-06-28 05:30:00	AAPL	Stock	133.15	133.15	133.15	133.15	100.0
2021-06-28 06:00:00	AAPL	Stock	133.11	133.11	133.01	133.01	4537.0
2021-06-28 06:30:00	AAPL	Stock	133.07	133.07	133.07	133.07	100.0
2021-06-28 07:00:00	AAPL	Stock	133.08	133.3	133.0	133.12	41448.0
2021-06-28 07:30:00	AAPL	Stock	133.12	133.17	133.0	133.17	43026.0
2021-06-28 08:00:00	AAPL	Stock	133.19	133.28	132.778	133.23	143816.0
2021-06-28 08:30:00	AAPL	Stock	133.24	133.26	133.11	133.11	187725.0
2021-06-28 09:00:00	AAPL	Stock	133.22	133.5	133.13	133.41	99134.0
2021-06-28 09:30:00	AAPL	Stock	133.42	135.04	133.35	134.9981	11576887.0
2021-06-28 10:00:00	AAPL	Stock	135.0	135.1499	134.81	135.0106	5285161.0
2021-06-28 10:30:00	AAPL	Stock	135.02	135.22	134.8	134.84	4512971.0
2021-06-28 11:00:00	AAPL	Stock	134.84	135.04	134.78	135.035	2746309.0
2021-06-28 11:30:00	AAPL	Stock	135.04	135.1783	134.83	134.885	2488435.0
2021-06-28 12:00:00	AAPL	Stock	134.89	135.18	134.84	135.11	2227306.0
2021-06-28 12:30:00	AAPL	Stock	135.1087	135.2	134.94	134.9688	1799569.0
2021-06-28 13:00:00	AAPL	Stock	134.97	134.97	134.72	134.7685	1829625.0
2021-06-28 13:30:00	AAPL	Stock	134.76	134.9	134.67	134.815	1865753.0
2021-06-28 14:00:00	AAPL	Stock	134.81	134.99	134.7	134.9822	1864998.0
2021-06-28 14:30:00	AAPL	Stock	134.985	135.245	134.98	135.098	3300549.0
2021-06-28 15:00:00	AAPL	Stock	135.095	135.1	134.75	134.828	3498126.0
2021-06-28 15:30:00	AAPL	Stock	134.825	134.88	134.71	134.75	5298663.0
2021-06-28 16:00:00	AAPL	Stock	134.74	134.78	134.6	134.66	6400758.0
2021-06-28 16:30:00	AAPL	Stock	134.66	134.78	134.59	134.61	55453.0
2021-06-28 17:00:00	AAPL	Stock	134.65	134.78	134.61	134.75	33748.0
2021-06-28 17:30:00	AAPL	Stock	134.72	134.75	134.7	134.72	9825.0
2021-06-28 18:00:00	AAPL	Stock	134.7	134.7	134.6	134.65	21130.0
2021-06-28 18:30:00	AAPL	Stock	134.65	134.69	134.62	134.65	6752.0
2021-06-28 19:00:00	AAPL	Stock	134.61	134.65	134.6	134.63	9360.0
2021-06-28 19:30:00	AAPL	Stock	134.61	134.67	134.61	134.65	21235.0
2021-06-28 04:00:00	MSFT	Stock	265.83	265.9	265.8	265.8	540.0
2021-06-28 04:30:00	MSFT	Stock	265.99	265.99	265.8	265.89	1037.0
2021-06-28 05:00:00	MSFT	Stock	266.47	266.47	266.23	266.23	369.0
2021-06-28 05:30:00	MSFT	Stock	266.3	266.3	266.05	266.17	400.0
2021-06-28 06:00:00	MSFT	Stock	266.07	266.07	266.0	266.0	493.0
2021-06-28 07:00:00	MSFT	Stock	266.29	266.43	266.12	266.37	2733.0
2021-06-28 07:30:00	MSFT	Stock	266.36	266.45	266.24	266.42	4010.0
2021-06-28 08:00:00	MSFT	Stock	266.4199	266.6	266.28	266.55	8173.0
2021-06-28 08:30:00	MSFT	Stock	266.5	266.75	266.46	266.59	11418.0
2021-06-28 09:00:00	MSFT	Stock	266.655	267.0	266.0	266.12	38348.0
2021-06-28 09:30:00	MSFT	Stock	266.12	268.47	265.91	267.75	2239728.0
2021-06-28 10:00:00	MSFT	Stock	267.79	268.39	267.73	267.93	880162.0
2021-06-28 10:30:00	MSFT	Stock	267.94	268.26	267.44	267.55	773927.0
2021-06-28 11:00:00	MSFT	Stock	267.5661	268.17	267.4441	268.02	720939.0
2021-06-28 11:30:00	MSFT	Stock	268.01	268.545	267.92	268.3	680557.0
2021-06-28 12:00:00	MSFT	Stock	268.3	268.59	268.2	268.44	605578.0
2021-06-28 12:30:00	MSFT	Stock	268.44	268.54	267.9799	268.025	541669.0
2021-06-28 13:00:00	MSFT	Stock	268.025	268.1583	267.85	267.9	501683.0

> showing 50 of 115,720 rows — these rows as CSV

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