PREVIEW / stock_30min / 2020-11-05

all stock 30-min files

  file:    by_date/stock_30min/2020/2020-11-05.parquet
  size:    2.0 MB
  rows:    100,166
  symbols: 2,524

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
2020-11-05 04:00:00	AAPL	Stock	117.7	118.17	117.5	118.0	59649.0
2020-11-05 04:30:00	AAPL	Stock	118.0	118.4	117.88	118.1	38930.0
2020-11-05 05:00:00	AAPL	Stock	118.22	119.0	117.96	118.55	55848.0
2020-11-05 05:30:00	AAPL	Stock	118.55	118.75	118.41	118.65	50629.0
2020-11-05 06:00:00	AAPL	Stock	118.65	118.95	118.41	118.6	39459.0
2020-11-05 06:30:00	AAPL	Stock	118.55	118.6	118.13	118.21	32468.0
2020-11-05 07:00:00	AAPL	Stock	118.17	118.4	117.57	118.05	354575.0
2020-11-05 07:30:00	AAPL	Stock	118.07	118.22	117.81	118.21	173222.0
2020-11-05 08:00:00	AAPL	Stock	117.98	118.29	115.23	117.92	666795.0
2020-11-05 08:30:00	AAPL	Stock	117.92	118.16	117.91	117.989	335309.0
2020-11-05 09:00:00	AAPL	Stock	117.98	118.1	117.5	117.93	532710.0
2020-11-05 09:30:00	AAPL	Stock	117.93	119.62	116.869	118.77	21889026.0
2020-11-05 10:00:00	AAPL	Stock	118.761	119.24	117.58	117.72	12941723.0
2020-11-05 10:30:00	AAPL	Stock	117.72	118.4	117.7	118.4	7904642.0
2020-11-05 11:00:00	AAPL	Stock	118.39	118.59	117.92	118.309	5591123.0
2020-11-05 11:30:00	AAPL	Stock	118.3	118.39	117.922	118.11	4989412.0
2020-11-05 12:00:00	AAPL	Stock	118.12	118.38	117.41	117.59	5913513.0
2020-11-05 12:30:00	AAPL	Stock	117.59	118.08	117.455	117.98	4427666.0
2020-11-05 13:00:00	AAPL	Stock	117.98	118.38	117.84	118.23	4514011.0
2020-11-05 13:30:00	AAPL	Stock	118.24	118.47	118.02	118.41	3385767.0
2020-11-05 14:00:00	AAPL	Stock	118.4	118.86	118.345	118.82	4959432.0
2020-11-05 14:30:00	AAPL	Stock	118.82	119.27	118.58	119.163	7235014.0
2020-11-05 15:00:00	AAPL	Stock	119.16	119.285	118.77	119.025	6372774.0
2020-11-05 15:30:00	AAPL	Stock	119.025	119.3	118.455	118.99	10750223.0
2020-11-05 16:00:00	AAPL	Stock	119.03	119.3	118.96	119.19	10067271.0
2020-11-05 16:30:00	AAPL	Stock	119.2	119.27	119.12	119.2	181638.0
2020-11-05 17:00:00	AAPL	Stock	119.18	119.25	119.17	119.2	66202.0
2020-11-05 17:30:00	AAPL	Stock	119.2	119.23	119.15	119.17	58560.0
2020-11-05 18:00:00	AAPL	Stock	119.16	119.2	119.0	119.01	127769.0
2020-11-05 18:30:00	AAPL	Stock	119.02	119.02	118.5	118.72	159394.0
2020-11-05 19:00:00	AAPL	Stock	118.7	118.72	118.15	118.15	203322.0
2020-11-05 19:30:00	AAPL	Stock	118.15	118.3	117.98	118.0	159358.0
2020-11-05 04:00:00	MSFT	Stock	220.63	221.99	220.63	221.99	14920.0
2020-11-05 04:30:00	MSFT	Stock	221.9	222.28	221.85	222.03	2803.0
2020-11-05 05:00:00	MSFT	Stock	222.47	223.49	222.4	222.68	7432.0
2020-11-05 05:30:00	MSFT	Stock	222.51	222.89	222.0	222.5	18337.0
2020-11-05 06:00:00	MSFT	Stock	222.51	222.86	221.79	222.5	36902.0
2020-11-05 06:30:00	MSFT	Stock	222.4	222.5	221.88	222.04	8189.0
2020-11-05 07:00:00	MSFT	Stock	222.04	222.9	221.5	222.2	88678.0
2020-11-05 07:30:00	MSFT	Stock	222.2	222.5	221.61	222.26	37297.0
2020-11-05 08:00:00	MSFT	Stock	222.15	222.8	221.5	222.19	90809.0
2020-11-05 08:30:00	MSFT	Stock	222.11	222.35	221.954	222.0	87722.0
2020-11-05 09:00:00	MSFT	Stock	221.95	222.0	221.202	221.98	92708.0
2020-11-05 09:30:00	MSFT	Stock	221.83	223.6	221.15	222.85	5160197.0
2020-11-05 10:00:00	MSFT	Stock	222.84	224.0	222.19	222.34	2776854.0
2020-11-05 10:30:00	MSFT	Stock	222.38	223.24	221.5	223.23	2018496.0
2020-11-05 11:00:00	MSFT	Stock	223.22	223.34	222.16	222.73	1344136.0
2020-11-05 11:30:00	MSFT	Stock	222.73	223.0	221.78	221.98	1314466.0
2020-11-05 12:00:00	MSFT	Stock	221.99	222.95	221.72	221.85	1461097.0
2020-11-05 12:30:00	MSFT	Stock	221.87	222.86	221.52	222.75	995153.0

> showing 50 of 100,166 rows — these rows as CSV

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